File: sample.sql

-- 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);