-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 31, 2006 at 09:24 AM
-- Server version: 5.0.18
-- PHP Version: 4.4.1-pl3-gentoo
--
-- Database: `Helpdesk`
--
-- --------------------------------------------------------
--
-- Table structure for table `FlowChartQuestions`
--
CREATE TABLE `FlowChartQuestions` (
`Level` char(20) default NULL,
`Type` int(11) default NULL,
`Step` int(11) default NULL,
`Question` char(255) default NULL,
`Template` char(80) default NULL,
`EndPoint` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `FlowChartQuestions`
--
INSERT INTO `FlowChartQuestions` VALUES ('0', 0, 0, 'Is this an email problem or an internet problem', 'emailorinternet.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.2', 0, 0, 'Can the user surf', 'cansurfgoogle.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.2.2', 0, 0, 'Check Email Settings', 'checkemailsettings.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.2.2.2', 1, 0, 'Hangup', 'hangup.tpl', 1);
INSERT INTO `FlowChartQuestions` VALUES ('0.2.2.1', 2, 1, 'Disable Anti-Virus', 'disableav.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.2.2.1', 3, 2, 'Reboot PC', 'rebootpc.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.2.2.1.2', 1, 0, 'Hangup', 'hangup.tpl', 1);
INSERT INTO `FlowChartQuestions` VALUES ('0.2.2.1.1', 4, 0, 'Level 2', 'level2.tpl', 1);
INSERT INTO `FlowChartQuestions` VALUES ('0.1', 0, 0, 'Ping stable.reliable.internal.host', 'pingreliable.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2', 0, 0, 'Can surf to www.internal.site.com', 'cansurfinternal.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.2', 0, 0, 'Can surf to www.google.com', 'cansurfgoogle.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.2.2', 1, 0, 'Hangup', 'hangup.tpl', 1);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.2.1', 4, 0, 'Level 2', 'level2.tpl', 1);
INSERT INTO `FlowChartQuestions` VALUES ('0.2.1', 5, 0, '0.1', '', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1', 0, 0, 'Ping a.b.c.d', 'pingip.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.2', 2, 1, 'Check DNS Settings', 'checkdns.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.2', 3, 2, 'Ping stable.reliable.internal.host', 'pingreliable.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.2.2', 5, 0, '0.1.2', '', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.2.1', 4, 0, 'Level 2', 'level2.tpl', 1);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.1', 0, 0, 'Check proxy settings', 'proxysettings.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.1.2', 2, 1, 'Remove proxy settings', 'removeproxysettings.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.1.2', 6, 2, '0.1.2.1.3', '', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.1.1', 2, 1, 'Reboot PC', 'rebootpc.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.1.1', 6, 2, '0.1.2.1.3', '', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.1.3', 0, 0, 'Can surf to www.internal.site.com', 'cansurfinternal.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.1.3.2', 5, 0, '0.1.2.2', '', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.2.1.3.1', 4, 0, 'Level 2', 'level2.tpl', 1);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.1', 2, 1, 'Power cycle router', 'powercyclerouter.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.1', 3, 2, 'Ping a.b.c.d', 'pinginternal.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.1.2', 0, 0, 'Ping stable.reliable.internal.host', 'pingreliable.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.1.2.2', 5, 0, '0.1.2', '', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.1.2.1', 5, 0, '0.1.1.2', '', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.1.1', 2, 1, 'Power off router', 'poweroffrouter.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.1.1', 2, 2, 'Power cycle radio', 'powercycleradio.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.1.1', 2, 3, 'Power on router', 'poweronrouter.tpl', 0);
INSERT INTO `FlowChartQuestions` VALUES ('0.1.1.1.1', 6, 4, '0.1.1.1.2', '', 0);
--
-- Table structure for table `FlowChartOptions`
--
CREATE TABLE `FlowChartOptions` (
`Level` char(20) default NULL,
`OptionNumber` int(11) default NULL,
`OptionCaption` char(50) default NULL,
`FlagLog` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `FlowChartOptions`
--
INSERT INTO `FlowChartOptions` VALUES ('0', 1, 'Internet', 0);
INSERT INTO `FlowChartOptions` VALUES ('0', 2, 'Email', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.2', 1, 'No', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.2', 2, 'Yes', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.2.2', 1, 'No', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.2.2', 2, 'Yes', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.2.2.1', 1, 'No', 1);
INSERT INTO `FlowChartOptions` VALUES ('0.2.2.1', 2, 'Yes', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1', 1, 'Unknown Host', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1', 2, 'Resolves', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.2', 1, 'No', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.2', 2, 'Yes', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.2.2', 1, 'No', 1);
INSERT INTO `FlowChartOptions` VALUES ('0.1.2.2', 2, 'Yes', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.2.1', 1, 'No', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.2.1', 2, 'Yes', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.2.1.3', 1, 'No', 1);
INSERT INTO `FlowChartOptions` VALUES ('0.1.2.1.3', 2, 'Yes', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.1', 1, 'Error', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.1', 2, 'Reply From', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.1.2', 1, 'Unknown Host', 1);
INSERT INTO `FlowChartOptions` VALUES ('0.1.1.2', 2, 'Resolves', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.1.1', 1, 'Error', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.1.1', 2, 'Reply From', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.1.1.2', 1, 'Unknown Host', 0);
INSERT INTO `FlowChartOptions` VALUES ('0.1.1.1.2', 2, 'Resolves', 0);
|