-- MySQL dump 10.10 -- -- Host: localhost Database: glide -- ------------------------------------------------------ -- Server version 5.0.27-community /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `task` -- DROP TABLE IF EXISTS `task`; CREATE TABLE `task` ( `sys_class_name` varchar(80) default NULL, `number` varchar(40) default NULL, `short_description` varchar(80) default NULL, `parent` char(32) default NULL, `active` bit(1) default NULL, `comments` mediumtext, `description` mediumtext, `assigned_to` char(32) default NULL, `assignment_group` char(32) default NULL, `cmdb_ci` char(32) default NULL, `company` char(32) default NULL, `state` int(11) default NULL, `priority` int(11) default NULL, `urgency` int(11) default NULL, `impact` int(11) default NULL, `escalation` int(11) default NULL, `approval` varchar(40) default NULL, `approval_history` mediumtext, `approval_set` datetime default NULL, `work_notes` mediumtext, `close_notes` mediumtext, `opened_at` datetime default NULL, `closed_at` datetime default NULL, `time_worked` datetime default NULL, `calendar_duration` datetime default NULL, `business_duration` datetime default NULL, `opened_by` char(32) default NULL, `closed_by` char(32) default NULL, `watch_list` mediumtext, `group_list` mediumtext, `knowledge` bit(1) default NULL, `location` char(32) default NULL, `contact_type` varchar(40) default NULL, `follow_up` datetime default NULL, `due_date` datetime default NULL, `sla_due` datetime default NULL, `activity_due` datetime default NULL, `correlation_id` varchar(100) default NULL, `correlation_display` varchar(100) default NULL, `user_input` mediumtext, `made_sla` bit(1) default NULL, `sys_id` char(32) NOT NULL, `sys_updated_by` varchar(40) default NULL, `sys_updated_on` datetime default NULL, `sys_created_by` varchar(40) default NULL, `sys_created_on` datetime default NULL, `sys_mod_count` int(11) default NULL, PRIMARY KEY (`sys_id`), KEY `task_index1` (`active`,`assigned_to`), KEY `task_index2` (`cmdb_ci`), KEY `task_index3` (`number`), KEY `task_ref3` (`parent`), KEY `task_ref7` (`assigned_to`), KEY `task_ref8` (`assignment_group`), KEY `task_ref10` (`company`), KEY `task_ref26` (`opened_by`), KEY `task_ref27` (`closed_by`), KEY `task_ref31` (`location`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `task` -- LOCK TABLES `task` WRITE; /*!40000 ALTER TABLE `task` DISABLE KEYS */; INSERT INTO `task` VALUES ('sc_request','REQ10001',NULL,NULL,'','Request automatically approved for total price <= $1000',NULL,NULL,NULL,NULL,NULL,1,4,3,3,0,'approved',NULL,NULL,NULL,NULL,'2006-05-18 23:24:30',NULL,NULL,NULL,NULL,'681ccaf9c0a8016400b98a06818d57c7',NULL,NULL,NULL,'\0',NULL,'phone',NULL,'2006-05-23 23:24:28',NULL,NULL,NULL,NULL,NULL,NULL,'49d07de3c611227d001e3728b303b9a0','employee','2006-05-18 23:24:30','employee','2006-05-18 23:24:30',1),('sc_req_item','RITM10001','Blackberry',NULL,'',NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,1,4,3,3,0,'approved',NULL,NULL,NULL,NULL,'2006-05-18 23:24:29',NULL,NULL,NULL,NULL,'681ccaf9c0a8016400b98a06818d57c7',NULL,NULL,NULL,'\0',NULL,'phone',NULL,'2006-05-23 23:24:28',NULL,NULL,NULL,NULL,NULL,NULL,'49d07f1cc611227d01b3c3d9837847ab','employee','2006-05-18 23:24:31','employee','2006-05-18 23:24:28',1),('change_request','CHG00008','Install new Cisco',NULL,'',NULL,'Please install new Cat. 6500 in Data center 01','681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,1,3,3,0,'requested',NULL,NULL,NULL,NULL,'2006-02-07 23:14:14',NULL,NULL,NULL,NULL,'glide.maint',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46cb2f54a9fe198101cf6814a2754606','glide.maint','2006-05-17 22:41:28','glide.maint','2006-02-07 23:14:14',3),('change_request','CHG00005','Install new PBX',NULL,'',NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,'10884798c61122750108b095e21e4080',NULL,1,4,3,3,0,'approved',NULL,NULL,NULL,NULL,'2006-02-07 23:15:36',NULL,NULL,NULL,NULL,'glide.maint',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46cc713aa9fe1981008a95d213681c65','glide.maint','2006-05-17 22:41:34','glide.maint','2006-02-07 23:15:36',2),('change_request','CHG00003','Roll back Windows SP2 patch',NULL,'',NULL,'Please roll-back SP2 patch for all XP Users. ','681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,2,1,3,3,0,'approved',NULL,NULL,NULL,NULL,'2006-02-07 23:47:34',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46e9b4afa9fe198101026e122b85f442','glide.maint','2006-05-17 22:41:13','admin','2006-02-07 23:47:34',1),('change_request','CHG00006','Put another 100 Gb drive on the 2nd Floor Server',NULL,'',NULL,'We\'re going to put another 100 GB drive on the floor 2 server.\r\n \r\n Needs a 100 GB SCSI II Ultra Drive.','681b365ec0a80164000fb0b05854a0cd',NULL,'b0c25d1bc0a800090168be1bfcdcd759',NULL,1,3,NULL,NULL,0,'not requested','ITIL User added as an approver',NULL,'Ordered the drive, it should be in Tuesday.',NULL,'2004-08-26 22:37:58',NULL,NULL,NULL,NULL,'5136503cc611227c0183e96598c4f706',NULL,NULL,NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9d3f823bc611228700376cc3b4b5b87b','glide.maint','2006-05-17 22:41:40','pat','2004-08-26 22:37:58',4),('change_request','CHG00002','Switch Sales over to the new 555 prefix',NULL,'',NULL,'Sales has their own private dialing prefix now so they\'ll always have an open outside line even if the PBX is full.\r ','681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,2,4,NULL,NULL,1,'not requested',NULL,NULL,'PBX came in on 8/20/04\r PBX installed and tested by 8/24/04\r Started the wiring on 8/25/04',NULL,'2004-08-26 22:40:25',NULL,NULL,NULL,NULL,'5136503cc611227c0183e96598c4f706',NULL,NULL,NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9d41c061c611228700edc88b231ec47c','glide.maint','2006-05-17 22:41:05','pat','2004-08-26 22:40:25',3),('change_request','CHG00007','R&D wants to know what it\'d cost to switch them over to Linux desktops',NULL,'',NULL,'The new VP of R&D is thinking of switching the engineers over to Linux desktops and wants to know what it\'d take on our end to support them, what it would cost to install them, and how fast the whole thing could happen.','681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,5,NULL,NULL,0,'rejected',NULL,NULL,'Waiting until we see if the CIO approves this project. ',NULL,'2004-08-26 22:44:30',NULL,NULL,NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9d457fbac6112287007379b57c6b2e60','glide.maint','2006-05-17 22:41:48','pat','2004-08-26 22:44:30',7),('change_request','CHG00001','Rollback Oracle Version',NULL,'',NULL,'Performance of the Siebel SFA software has been severely degraded since the upgrade performed this weekend. \r\n\r\nWe moved to an unsupported Oracle DB version. Need to rollback the Oracle Instance to a supported version.','681b365ec0a80164000fb0b05854a0cd',NULL,'a9c0c8d2c6112276018f7705562f9cb0',NULL,1,3,3,3,0,'requested','Bow Ruggeri added as an approver\nDavid Loo added as an approver\nDon Goodliffe added as an approver\nFred Luddy added as an approver\nBow Ruggeri requested to approve task\nDavid Loo requested to approve task\nDon Goodliffe requested to approve task\nFred Luddy requested to approve task\nBow Ruggeri approved the task. Comments:',NULL,NULL,NULL,'2006-04-17 22:12:50',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'a9e9c33dc61122760072455df62663d2','glide.maint','2006-05-17 22:40:56','admin','2006-04-17 22:12:50',16),('change_request','CHG00004','Upgrade to Oracle 11i',NULL,'',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,5,NULL,NULL,0,'not requested',NULL,NULL,NULL,NULL,'2004-09-10 15:31:06',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'e8f816d5c0a801640131b8101100744c','glide.maint','2006-02-07 23:20:10','admin','2004-09-10 15:31:06',1),('change_task','CTASK10001','Back-Up Database',NULL,'',NULL,NULL,'9ee1b13dc6112271007f9d0efdb69cd0',NULL,'0c43d5e2c61122750182c132a8b9e2d9',NULL,1,1,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-04-17 22:19:51',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,'2006-04-22 22:19:41',NULL,NULL,NULL,NULL,NULL,NULL,'a9f030cfc611227600f37bb8d031ab1b','admin','2006-04-17 22:19:51','admin','2006-04-17 22:19:51',0),('change_task','CTASK10002','Take VmWare snapshot of Environment',NULL,'',NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,'a9c0c8d2c6112276018f7705562f9cb0',NULL,1,1,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-04-17 22:20:20',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,'2006-04-22 22:20:17',NULL,NULL,NULL,NULL,NULL,NULL,'a9f0a2d2c6112276001c51b4e5715988','admin','2006-04-17 22:20:20','admin','2006-04-17 22:20:20',0),('change_task','CTASK10003','Install Oracle 10g onto SD1',NULL,'',NULL,NULL,'f298d2d2c611227b0106c6be7f154bc8',NULL,'a9c68505c6112276017ee7d52f43e7c6',NULL,1,2,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-04-17 22:21:28',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,'2006-04-23 02:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'a9f1ab97c611227600a920ad739997ea','admin','2006-04-17 22:21:28','admin','2006-04-17 22:21:28',0),('change_task','CTASK10004','Configure Siebel Software for new DB',NULL,'',NULL,NULL,'9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,NULL,1,3,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-04-17 22:22:08',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,'2006-04-23 22:21:56',NULL,NULL,NULL,NULL,NULL,NULL,'a9f2473bc61122760086a27688428a40','admin','2006-04-17 22:22:18','admin','2006-04-17 22:22:08',1),('change_task','CTASK10005','Preliminary System Testing',NULL,'',NULL,NULL,'f298d2d2c611227b0106c6be7f154bc8',NULL,NULL,NULL,1,3,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-04-17 22:22:48',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,'2006-04-23 22:22:39',NULL,NULL,NULL,NULL,NULL,NULL,'a9f2e5bdc61122760052c1250f7ac503','admin','2006-04-17 22:22:48','admin','2006-04-17 22:22:48',0),('change_task','CTASK10006','Multi-User Testing and QA',NULL,'',NULL,NULL,'f298d2d2c611227b0106c6be7f154bc8',NULL,'a9c0c8d2c6112276018f7705562f9cb0',NULL,1,1,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-04-17 22:23:24',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,'2006-04-24 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'a9f3703ac611227601245c4f5fa75b6d','admin','2006-04-17 22:23:24','admin','2006-04-17 22:23:24',0),('incident','INC00009','Reset my password',NULL,'\0','Need this done ASAP!! Will loose business if this is not reset.',NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,1,1,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-01 22:50:23','2006-02-02 22:55:16',NULL,'1970-01-02 00:04:53','1970-01-01 08:04:53','9ee1b13dc6112271007f9d0efdb69cd0','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0','108752c8c611227501d4ab0e392ba97f','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46b66a40a9fe198101f243dfbc79033d','glide.maint','2007-01-10 17:25:42','don.goodliffe','2006-02-07 22:51:33',7),('incident','INC00010','Need Oracle 10GR2 installed',NULL,'\0',NULL,NULL,'9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,NULL,1,2,3,2,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-26 22:53:02','2006-01-31 22:54:55',NULL,'1970-01-06 00:01:53','1970-01-02 00:01:53','9ee1b13dc6112271007f9d0efdb69cd0','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0','108752c8c611227501d4ab0e392ba97f','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46b9490da9fe1981003c938dab89bda3','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-07 22:54:41',7),('incident','INC00011','Need new Blackberry setup',NULL,'\0',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,3,2,2,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-02 23:01:12','2006-02-06 23:02:54',NULL,'1970-01-05 00:01:42','1970-01-01 16:01:42','9ee1b13dc6112271007f9d0efdb69cd0','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0','105cf7f3c611227501e75e08b14a38ba','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46c03489a9fe19810148cd5b8cbf501e','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-07 23:02:15',6),('incident','INC00012','eFax is not working',NULL,'\0','please update our account to enable e-fax. ',NULL,'5137153cc611227c000bbd1bd8cd2007','287ee6fea9fe198100ada7950d0b1b73','0c43cc3ec61122750182c1324e2722d9',NULL,1,4,3,3,2,'not requested',NULL,NULL,NULL,NULL,'2006-01-10 23:07:00','2006-02-02 23:12:02',NULL,'1970-01-24 00:05:02','1970-01-06 16:05:02','f298d2d2c611227b0106c6be7f154bc8','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0','105cf7f3c611227501e75e08b14a38ba','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46c88ac1a9fe1981014de1c831fbcf6d','glide.maint','2007-01-10 17:25:43','glide.maint','2006-02-07 23:11:21',6),('incident','INC00013','EMAIL is slow when an attachment is involved',NULL,'\0',NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,1,2,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-06 23:15:58','2006-02-07 23:18:40',NULL,'1970-01-02 00:02:42','1970-01-01 08:02:42','9ee1b13dc6112271007f9d0efdb69cd0','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46cebb88a9fe198101aee93734f9768b','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-07 23:18:07',5),('incident','INC00014','missing my home directory',NULL,'','I don\'t seem to see my home dir. ',NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-11 23:37:35',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0','108752c8c611227501d4ab0e392ba97f','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46e18c0fa9fe19810066a0083f76bd56','admin','2006-02-08 02:07:51','admin','2006-02-07 23:38:40',2),('incident','INC00015','I can\'t launch my game anymore',NULL,'','I was unable to launch the Bingo game since the SP2 upgrade on my machine',NULL,'9ee1b13dc6112271007f9d0efdb69cd0',NULL,'46c7318aa9fe198100c76003f0bc82e9',NULL,1,4,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-22 23:38:46','2006-01-27 23:39:10',NULL,'1970-01-06 00:00:24','1970-01-02 14:39:10','681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,'\0','105cf7f3c611227501e75e08b14a38ba','phone',NULL,NULL,'2006-02-11 01:00:00',NULL,NULL,NULL,NULL,NULL,'46e2fee9a9fe19810049b49dee0daf58','glide.maint','2007-01-10 17:25:43','admin','2006-02-07 23:40:15',9),('incident','INC00016','Rain is leaking on main DNS Server',NULL,'','please fix the roof.\nturns out it was the sprinkler, not the rain. ',NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-17 23:40:23','2006-02-02 23:40:40',NULL,'1970-01-17 00:00:17','1970-01-05 00:00:17','6816f79cc0a8016401c5a33be04be441','6816f79cc0a8016401c5a33be04be441',NULL,NULL,'\0','108486c7c611227500b093211aa88dcc','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46e3e949a9fe19810069b824ba2c761a','glide.maint','2007-01-10 17:25:43','admin','2006-02-07 23:41:15',6),('incident','INC00017','How do I create a sub-folder',NULL,'',NULL,NULL,'5137153cc611227c000bbd1bd8cd2005',NULL,NULL,NULL,1,4,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-25 23:41:00',NULL,NULL,NULL,NULL,'9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46e482d9a9fe198101d3e3f3e2a14459','admin','2006-02-08 02:08:42','don.goodliffe','2006-02-07 23:41:54',5),('incident','INC00018','Sales forcast spreadsheet is READ ONLY',NULL,'','I need to be able to update the spreadsheet. I am unable to do so since the SP2 upgrade. ',NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,1,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-23 23:42:46','2006-01-24 23:44:21',NULL,'1970-01-02 00:01:35','1970-01-01 08:01:35','6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0','1081761cc611227501d063fd3475a2de','phone',NULL,NULL,'2006-01-24 07:42:46',NULL,NULL,NULL,NULL,NULL,'46e57642a9fe1981000b96a5dca501ff','glide.maint','2007-01-10 17:25:43','admin','2006-02-07 23:42:56',8),('incident','INC00019','Can\'t launch X-Win32',NULL,'','I got some patches last night and now can\'t log in to the Unix box I need to for development. ',NULL,'46c6f9efa9fe198101ddf5eed9adf6e7',NULL,NULL,NULL,1,2,1,2,1,'not requested',NULL,NULL,NULL,NULL,'2006-01-25 23:44:39','2006-01-31 23:45:37',NULL,'1970-01-07 00:00:58','1970-01-02 08:00:58','6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0','1059cb53c6112275003052ce61c907e8','phone',NULL,NULL,'2006-01-26 23:44:39',NULL,NULL,NULL,NULL,NULL,'46e8219ba9fe1981013806b6e04fed06','glide.maint','2007-01-10 17:25:43','admin','2006-02-07 23:45:51',9),('incident','INC00020','Request for a Blackberry',NULL,'',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-04 23:51:35',NULL,NULL,NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,'\0','1081761cc611227501d063fd3475a2de','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46edaa6aa9fe198101b9d14ced16619f','admin','2006-02-08 02:09:08','david.loo','2006-02-07 23:51:54',3),('incident','INC00021','New employee hire',NULL,'\0',NULL,NULL,'46d44a23a9fe19810012d100cca80666',NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-01 23:52:01','2006-02-06 23:52:17',NULL,'1970-01-06 00:00:16','1970-01-02 00:00:16','5137153cc611227c000bbd1bd8cd2007','5137153cc611227c000bbd1bd8cd2007',NULL,NULL,'\0','1083361cc611227501b682158cabf646','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46ee0924a9fe198100f1cf78c198454a','glide.maint','2007-01-10 17:25:43','david.loo','2006-02-07 23:52:18',8),('incident','INC00024','Issue with a web page',NULL,'\0',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-07 23:52:52','2006-02-07 23:53:08',NULL,'1970-01-01 00:00:16','1970-01-01 00:00:16','5137153cc611227c000bbd1bd8cd2007','5137153cc611227c000bbd1bd8cd2007',NULL,NULL,'\0','108752c8c611227501d4ab0e392ba97f','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46ee8c2fa9fe198100623592c70d643e','glide.maint','2007-01-10 17:25:43','david.loo','2006-02-07 23:53:13',4),('incident','INC00025','I need more memory',NULL,'',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,'469facd7a9fe1981015830c43428ca2d',NULL,1,4,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-15 23:53:46','2006-02-02 23:55:10',NULL,'1970-01-19 00:01:24','1970-01-05 14:55:10','5137153cc611227c000bbd1bd8cd2007','5137153cc611227c000bbd1bd8cd2007',NULL,NULL,'\0','105cf7f3c611227501e75e08b14a38ba','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46f09e75a9fe198100f4ffd8d366d17b','glide.maint','2007-01-10 17:25:43','david.loo','2006-02-07 23:55:07',6),('incident','INC00026','Seem to have an issue with my hard drive...',NULL,'\0',NULL,NULL,'9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,NULL,1,2,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-09 23:54:59','2006-01-11 23:56:53',NULL,'1970-01-03 00:01:54','1970-01-01 16:01:54','5137153cc611227c000bbd1bd8cd2006','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46f1784ba9fe19810018aa27fbb23482','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-07 23:56:03',5),('incident','INC00028','My disk is still having issues. Can\'t delete a file',NULL,'\0',NULL,NULL,'9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,NULL,1,2,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-18 23:58:00','2006-01-23 23:58:58',NULL,'1970-01-06 00:00:58','1970-01-02 00:00:58','5137153cc611227c000bbd1bd8cd2006','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46f3ee0ea9fe198100c5c0e53d5abe0b','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-07 23:58:44',5),('incident','INC00027','please remove this hotfix',NULL,'',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,'46d15686a9fe19810031d499aed2dfcf',NULL,1,2,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-03 23:55:55','2006-02-07 23:59:20',NULL,'1970-01-05 00:03:25','1970-01-01 16:03:25','5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,'\0','1059cb53c6112275003052ce61c907e8','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46f4f4dfa9fe198100063e60278f76ec','glide.maint','2007-01-10 17:25:43','david.loo','2006-02-07 23:59:52',6),('incident','INC00029','I cant get my weather report',NULL,'',NULL,NULL,'9ee1b13dc6112271007f9d0efdb69cd0',NULL,'46b8e13ba9fe1981005990e20d315e4a',NULL,1,1,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-06 00:00:44',NULL,NULL,NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,'\0','108752c8c611227501d4ab0e392ba97f','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46f67787a9fe198101e06dfcf3a78e99','admin','2006-02-08 02:10:09','david.loo','2006-02-08 00:01:31',1),('incident','INC00030','Lost connection to the wireless network',NULL,'\0',NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,1,2,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-03 00:01:12','2006-02-03 01:02:14',NULL,'1970-01-01 01:01:02','1970-01-01 00:58:48','5137153cc611227c000bbd1bd8cd2006','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46f6ede0a9fe198100e10154c34a0c2a','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-08 00:02:01',5),('incident','INC00031','EMAIL Server Down',NULL,'','Server out of memory',NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,1,1,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-11 00:18:03','2006-01-11 00:30:02',NULL,'1970-01-01 00:11:59','1970-01-01 00:11:59','9ee1b13dc6112271007f9d0efdb69cd0','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'47064b68a9fe19810186793eefffc9b7','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-08 00:18:48',6),('incident','INC00032','EMAIL Server Down Again',NULL,'\0','Server ran out of memory again',NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-18 00:19:36','2006-01-18 00:35:27',NULL,'1970-01-01 00:15:51','1970-01-01 00:15:51','9ee1b13dc6112271007f9d0efdb69cd0','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'47079b68a9fe198100a614a4c225c88d','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-08 00:20:14',5),('incident','INC00033','File Server is 80% full - Needs upgrade',NULL,'\0',NULL,NULL,'9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,NULL,1,1,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-11 22:22:52','2006-01-12 00:24:08',NULL,'1970-01-01 02:01:16','1970-01-01 02:01:16','5137153cc611227c000bbd1bd8cd2007','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0','105cf7f3c611227501e75e08b14a38ba','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'470af5afa9fe198101b324dd773ef379','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-08 00:23:54',5),('incident','INC00034','Does not look like a backup occurred last night',NULL,'\0',NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,1,1,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-01-19 20:25:29','2006-01-21 00:26:41',NULL,'1970-01-02 04:01:12','1970-01-01 12:01:12','9ee1b13dc6112271007f9d0efdb69cd0','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'470d51a0a9fe1981006c20c825e48933','glide.maint','2007-01-10 17:25:43','don.goodliffe','2006-02-08 00:26:28',5),('incident','INC00035','Reset my password',NULL,'\0',NULL,NULL,'46d96f57a9fe198101947a9620895886',NULL,'0c43b143c6112275019abd2b3390d1f9',NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-05 00:32:47','2006-02-08 00:33:33',NULL,'1970-01-04 00:00:46','1970-01-01 15:33:33','5137153cc611227c000bbd1bd8cd2007','5137153cc611227c000bbd1bd8cd2007',NULL,NULL,'\0','108486c7c611227500b093211aa88dcc','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'47138238a9fe1981016e3762d1fd26d4','glide.maint','2007-01-10 17:25:43','david.loo','2006-02-08 00:33:14',6),('incident','INC00036','Issue with networking',NULL,'\0',NULL,NULL,'46d96f57a9fe198101947a9620895886',NULL,'14a9e27bc61122750037b90c4d34da38',NULL,1,3,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-02 00:33:49','2006-02-06 00:34:21',NULL,'1970-01-05 00:00:32','1970-01-01 16:26:11','5137153cc611227c000bbd1bd8cd2007','5137153cc611227c000bbd1bd8cd2007',NULL,NULL,'\0','108752c8c611227501d4ab0e392ba97f','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4714a2aca9fe198100ecabacf6273482','glide.maint','2007-01-10 17:25:43','david.loo','2006-02-08 00:34:28',5),('incident','INC00037','Request for a new service',NULL,'',NULL,NULL,'46ca0887a9fe19810191e08e51927ebf',NULL,'0c43b55ac6112275019abd2b247baf31',NULL,1,3,1,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-08 00:34:56','2006-02-08 00:35:39',NULL,'1970-01-01 00:00:43','1970-01-01 00:00:43','5137153cc611227c000bbd1bd8cd2007','5137153cc611227c000bbd1bd8cd2007',NULL,NULL,'\0','108486c7c611227500b093211aa88dcc','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4715ab62a9fe1981018c3efb96143495','glide.maint','2007-01-10 17:25:43','david.loo','2006-02-08 00:35:36',6),('incident','INC00038','my PDF docs are all locked from editing',NULL,'\0','Please assist user with PDF creation. ',NULL,'46d96f57a9fe198101947a9620895886',NULL,'46c4ca00a9fe1981015194a1a56bfc3f',NULL,1,4,3,2,3,'not requested',NULL,NULL,NULL,NULL,'2006-02-02 00:36:44','2006-02-09 00:37:14',NULL,'1970-01-08 00:00:30','1970-01-02 16:00:30','5137153cc611227c000bbd1bd8cd2005','6816f79cc0a8016401c5a33be04be441',NULL,NULL,'\0','105cf7f3c611227501e75e08b14a38ba','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4717dfe5a9fe198100450448b2404c16','glide.maint','2007-01-10 17:25:43','admin','2006-02-08 00:38:00',4),('incident','INC00039','Routing to oregon mail server',NULL,'','Routing from San Diego to the Oregon mail server appears to be getting packet lose!',NULL,NULL,'287ebd7da9fe198100f92cc8d1d2154e','b0c4030ac0a800090152e7a4564ca36c',NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-08 00:41:01',NULL,NULL,NULL,NULL,'46c6f9efa9fe198101ddf5eed9adf6e7',NULL,NULL,NULL,'\0','108486c7c611227500b093211aa88dcc','phone',NULL,NULL,'2006-03-01 00:41:01',NULL,NULL,NULL,NULL,NULL,'471bfbc7a9fe198101e77a3e10e5d47f','admin','2006-04-17 21:16:29','admin','2006-02-08 00:42:29',2),('incident','INC00040','Javascript error',NULL,'','Javascript error (line 202) on the home page. Not sure what is going on, does not happen on my Windows machine!',NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,'0c43b896c6112275019abd2b2b93f464',NULL,1,3,2,2,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-08 00:42:45',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0','108486c7c611227500b093211aa88dcc','phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'471d4732a9fe198100affbf655e59172','admin','2006-02-08 02:11:38','admin','2006-02-08 00:43:54',1),('incident','INC00041','My cubical phone does not work',NULL,'','When someone tries to call my extension, it will not ring.',NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-08 00:44:53',NULL,NULL,NULL,NULL,'f298d2d2c611227b0106c6be7f154bc8',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'471eb058a9fe198100f89592e1ea93d3','admin','2006-02-08 02:11:45','bow','2006-02-08 00:45:27',1),('incident','INC00044',NULL,NULL,'',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-08 00:47:08',NULL,NULL,NULL,NULL,'681ccaf9c0a8016400b98a06818d57c7',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'47204688a9fe1981011a20af100f381a','admin','2006-02-08 02:11:55','employee','2006-02-08 00:47:11',1),('incident','INC00006','Hang when trying to print VISIO document',NULL,'\0',NULL,'When I try to print VISIO, my whole computer just stares at me','46ca0887a9fe19810191e08e51927ebf',NULL,NULL,NULL,1,4,1,1,0,NULL,NULL,NULL,NULL,NULL,'2006-01-25 23:08:05','2006-02-08 00:36:40',NULL,'1970-01-14 01:28:35','1970-01-04 01:28:35','5136503cc611227c0183e96598c4f706','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0','1081761cc611227501d063fd3475a2de',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8d6246c7c0a80164012fb063cecd4ace','glide.maint','2007-01-10 17:25:42','employee','2004-08-23 20:42:01',13),('incident','INC00007','Need access to sales db for the west',NULL,'',NULL,'I have to analyze all US data in the SFA system, but am unable to get to see the date from the west coast.','5137153cc611227c000bbd1bd8cd2005',NULL,NULL,NULL,1,4,1,1,0,NULL,NULL,NULL,'You might have to check with his boss',NULL,'2006-01-25 23:08:24',NULL,NULL,NULL,NULL,'681ccaf9c0a8016400b98a06818d57c7',NULL,NULL,NULL,'\0','108752c8c611227501d4ab0e392ba97f',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8d6353eac0a8016400d8a125ca14fc1f','david.loo','2006-02-08 00:00:34','employee','2004-08-23 20:43:10',43),('incident','INC00008','Printer in my office is out of toner',NULL,'\0',NULL,'Where do I find toner for the HP 950C I have?','681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,1,1,0,NULL,NULL,NULL,'We should write a knowledge base article on this?',NULL,'2006-02-02 23:08:39','2006-02-07 23:08:57',NULL,'1970-01-06 00:00:18','1970-01-02 00:00:18','681ccaf9c0a8016400b98a06818d57c7','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0','1059cb53c6112275003052ce61c907e8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8d641046c0a80164000bc7c0d3ed46a0','glide.maint','2007-01-10 17:25:42','employee','2004-08-23 20:43:58',18),('incident','INC00001','Can\'t read email',NULL,'\0',NULL,'User can\'t access email on mail.company.com.','46b87022a9fe198101a78787e40d7547',NULL,'b0c4030ac0a800090152e7a4564ca36c',NULL,1,2,1,1,0,NULL,NULL,NULL,'Reset his password, had him restart computer, but still no luck.',NULL,'2006-01-25 23:09:51','2006-01-26 23:10:06',NULL,'1970-01-02 00:00:15','1970-01-01 08:00:15','681ccaf9c0a8016400b98a06818d57c7','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0','1083361cc611227501b682158cabf646',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9c573169c611228700193229fff72400','glide.maint','2007-01-10 17:25:42','pat','2004-08-26 18:24:13',20),('incident','INC00002','Can\'t get to network file shares',NULL,'',NULL,'User can\'t get to any of his files on the file server.','46ca0887a9fe19810191e08e51927ebf',NULL,'b0c25d1bc0a800090168be1bfcdcd759',NULL,1,4,1,1,3,NULL,NULL,NULL,'Tried to reset his password, but it still didn\'t work.\r\nI tried to get to the same set of files and got through so looks like the server is still up.\r\nRouter problem maybe?',NULL,'2006-01-30 23:07:12',NULL,NULL,NULL,NULL,'681ccaf9c0a8016400b98a06818d57c7',NULL,NULL,NULL,'\0','108486c7c611227500b093211aa88dcc',NULL,NULL,NULL,'2006-02-20 23:07:12',NULL,NULL,NULL,NULL,NULL,'9d385017c611228701d22104cc95c371','glide.maint','2007-01-10 18:06:25','pat','2004-08-26 22:30:06',15),('incident','INC00004','Forgot email password',NULL,'\0',NULL,'User forgot their email password.','46c6f9efa9fe198101ddf5eed9adf6e7',NULL,NULL,NULL,1,4,1,1,1,NULL,NULL,NULL,'Reset it.','Walked him through settng his password, again.','2006-02-01 22:49:22','2006-02-03 00:40:24',NULL,'1970-01-02 01:51:02','1970-01-01 09:51:02','681b365ec0a80164000fb0b05854a0cd','9ee1b13dc6112271007f9d0efdb69cd0',NULL,NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9d3c1197c611228701cd1d94bc32d76d','glide.maint','2007-01-10 17:25:42','pat','2004-08-26 22:34:12',9),('incident','INC00047','Issue with email',NULL,'','Can\'t connect to Email from home. Webmail appears to be down.\nSpoke to customer, appears to need a new VPN token.\nWill deliver new token tomorrow when I\'m in the San Diego office.',NULL,'46d44a23a9fe19810012d100cca80666',NULL,'a9a2d111c611227601fb37542399caa8',NULL,1,4,3,3,0,'not requested',NULL,NULL,'Be sure to record VPN ID number in the CMDB.',NULL,'2006-04-17 20:53:18',NULL,NULL,NULL,NULL,'681ccaf9c0a8016400b98a06818d57c7',NULL,NULL,NULL,'\0','108752c8c611227501d4ab0e392ba97f','phone',NULL,NULL,'2006-05-08 20:53:18',NULL,NULL,NULL,NULL,NULL,'a9a16740c61122760004fe9095b7ddca','glide.maint','2006-05-17 22:37:39','employee','2006-04-17 20:53:47',4),('incident','INC00046','Can\'t access SFA software',NULL,'','System seems to be lagging and can\'t login',NULL,NULL,'8a4dde73c6112278017a6a4baf547aa7','a9c0c8d2c6112276018f7705562f9cb0',NULL,1,3,3,1,0,'not requested',NULL,NULL,NULL,NULL,'2006-04-17 22:04:15',NULL,NULL,NULL,NULL,'46c6f9efa9fe198101ddf5eed9adf6e7',NULL,NULL,NULL,'\0','105cf7f3c611227501e75e08b14a38ba','phone',NULL,NULL,'2006-04-26 22:04:15',NULL,NULL,NULL,NULL,NULL,'a9e30c7dc61122760116894de7bcc7bd','glide.maint','2006-05-17 22:37:27','admin','2006-04-17 22:05:30',4),('incident','INC00048','Having problems with performance on the Sales Tools',NULL,'','Everything is running really SLOW!',NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,'a9c0c8d2c6112276018f7705562f9cb0',NULL,1,2,3,2,2,'not requested',NULL,NULL,NULL,NULL,'2006-04-17 22:05:36',NULL,NULL,NULL,NULL,'46d96f57a9fe198101947a9620895886',NULL,NULL,NULL,'\0','108752c8c611227501d4ab0e392ba97f','phone',NULL,NULL,'2006-04-18 22:05:36',NULL,NULL,NULL,NULL,NULL,'a9e428cac61122760075710592216c58','glide.maint','2006-05-17 22:38:13','admin','2006-04-17 22:06:42',5),('incident','INC00003','Wireless access not available on floor 3',NULL,'',NULL,'I just moved from floor 2 to floor 3 and my laptop cannot connect to any wireless network.','46d44a23a9fe19810012d100cca80666',NULL,NULL,NULL,1,4,1,1,0,NULL,NULL,NULL,NULL,NULL,'2006-02-06 23:07:30',NULL,NULL,NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,'\0','105cf7f3c611227501e75e08b14a38ba',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'e8caedcbc0a80164017df472f39eaed1','admin','2006-02-08 00:35:06','admin','2004-09-10 14:41:46',10),('incident','INC00005','CPU load high for over 10 minutes',NULL,'',NULL,'Watcher daemon detected that the CPU was 100% busy for more than 10 minutes','46b87022a9fe198101a78787e40d7547',NULL,'b0cb50c3c0a8000900893e69d3c5885e',NULL,1,2,1,1,3,NULL,NULL,NULL,NULL,NULL,'2006-02-01 23:06:52',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0','1083361cc611227501b682158cabf646',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'e8e875b0c0a80164009dc852b4d677d5','admin','2006-02-08 00:36:15','admin','2004-09-10 15:14:01',9),('problem','PRB00001','Windows xp SP2 causing errors in Enterprise',NULL,'',NULL,'SP2 is causing several applications not to work anymore. ','681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,3,3,1,'not requested',NULL,NULL,NULL,NULL,'2006-02-07 23:48:36',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46eaa7c9a9fe198100bbe282da0d4b7d','glide.maint','2006-05-17 22:39:09','admin','2006-02-07 23:48:36',1),('problem','PRB00008','Hang when trying to print VISIO document',NULL,'',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-08 00:06:28',NULL,NULL,NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46fb0230a9fe198101a23f6712475e11','glide.maint','2006-05-17 22:40:09','david.loo','2006-02-08 00:06:28',2),('problem','PRB00003','Request for a Blackberry',NULL,'',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-08 00:07:08',NULL,NULL,NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46fb9e31a9fe198101492060c2a4f8cb','glide.maint','2006-05-17 22:39:22','david.loo','2006-02-08 00:07:08',2),('problem','PRB00005','please remove this hotfix',NULL,'',NULL,NULL,'681b365ec0a80164000fb0b05854a0cd',NULL,'46d15686a9fe19810031d499aed2dfcf',NULL,1,2,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-08 00:40:00',NULL,NULL,NULL,NULL,'5137153cc611227c000bbd1bd8cd2007',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4719b33ea9fe19810036eb762096188b','glide.maint','2006-05-17 22:39:49','david.loo','2006-02-08 00:40:00',2),('problem','PRB00004','Boot with shift key held down',NULL,'',NULL,'If the shift key is not held down the RAID enclosure does not power on. ','5137153cc611227c000bbd1bd8cd2005',NULL,'46da0ca0a9fe19810117268ba4d4aceb',NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-02-08 00:40:42',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'471a5450a9fe198101f2054169e75bf4','glide.maint','2006-05-17 22:39:28','admin','2006-02-08 00:40:42',1),('problem','PRB00007','Router Down',NULL,'',NULL,'The 1st floor router is down again. Nobody down there can get at anything outside their own subnet.','681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,'2004-08-26 22:32:07',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9d3a266ac6112287004e37fb2ceb0133','glide.maint','2006-05-17 22:40:02','pat','2004-08-26 22:32:07',8),('problem','PRB00002','2nd Floor File Server Short on Space',NULL,'',NULL,'We really, really need to buy more dirves for the second floor file. The users keep filling up their 10 MB quota and they aren\'t going to take it much longer.','681b365ec0a80164000fb0b05854a0cd',NULL,'b0c25d1bc0a800090168be1bfcdcd759',NULL,1,4,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2004-08-26 22:35:29',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9d3d3b85c61122870138f3d1472bba01','glide.maint','2006-05-17 22:39:16','pat','2004-08-26 22:35:29',7),('problem','PRB00009','T-1 Saturated',NULL,'',NULL,'Every lunch hour our T-1 bottlenecks when everyone goes and does their ebay shopping.\r\n','681b365ec0a80164000fb0b05854a0cd',NULL,NULL,NULL,1,4,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2004-08-26 22:54:00',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9d4e2f00c61122870027d525c8c77965','glide.maint','2006-05-17 22:40:14','pat','2004-08-26 22:54:00',6),('problem','PRB00010','Oracle Down',NULL,'',NULL,'The PeopleSoft Oracle instance is down (again). ','681b365ec0a80164000fb0b05854a0cd',NULL,'b0cb50c3c0a8000900893e69d3c5885e',NULL,1,4,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2004-08-26 22:55:28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9d4f87a3c6112287010ed0a5ccdcba04','glide.maint','2006-05-17 22:40:19','pat','2004-08-26 22:55:28',8),('problem','PRB00006','Can\'t access SFA software',NULL,'',NULL,'Performance of the Siebel SFA software has been severely degraded since the upgrade performed this weekend. \r\n\r\nWe moved to an unsupported Oracle DB version. ','681b365ec0a80164000fb0b05854a0cd',NULL,'a9c0c8d2c6112276018f7705562f9cb0',NULL,1,3,3,3,2,'not requested',NULL,NULL,NULL,NULL,'2006-04-17 22:07:07',NULL,NULL,NULL,NULL,'6816f79cc0a8016401c5a33be04be441',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'a9e4890bc6112276003d7a5a5c774a74','glide.maint','2006-05-17 22:39:56','ITIL User','2006-04-17 22:07:07',6),('release_phase','PHASE10001','Plan phase for project REL10001 ()',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-05-07 05:40:02',NULL,NULL,NULL,NULL,'glide.maint',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0d5c0350c0a802660169be56e6149a9b','glide.maint','2006-05-07 05:40:02','glide.maint','2006-05-07 05:40:02',0),('release_phase','PHASE10002','Build phase for project REL10001 ()',NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-05-07 05:40:03',NULL,NULL,NULL,NULL,'glide.maint',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0d5c095ac0a802660007612a9dd1c42a','glide.maint','2006-05-07 05:40:03','glide.maint','2006-05-07 05:40:03',0),('release_phase','PHASE10003','Accept phase for project REL10001 ()',NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-05-07 05:40:03',NULL,NULL,NULL,NULL,'glide.maint',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0d5c0aa3c0a802660121dba87f00f21c','glide.maint','2006-05-07 05:40:03','glide.maint','2006-05-07 05:40:03',0),('release_phase','PHASE10004','Release phase for project REL10001 ()',NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-05-07 05:40:04',NULL,NULL,NULL,NULL,'glide.maint',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0d5c0b6ec0a80266011c9fcc3efb9735','glide.maint','2006-05-07 05:40:04','glide.maint','2006-05-07 05:40:04',0),('release_phase','PHASE10005','Deploy phase for project REL10001 ()',NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-05-07 05:40:04',NULL,NULL,NULL,NULL,'glide.maint',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0d5c0cb6c0a80266004d9ebfe515a776','glide.maint','2006-05-07 05:40:04','glide.maint','2006-05-07 05:40:04',0),('release_phase','PHASE10006','Back Out phase for project REL10001 ()',NULL,'\0',NULL,NULL,NULL,NULL,NULL,NULL,1,4,3,3,0,'not requested',NULL,NULL,NULL,NULL,'2006-05-07 05:40:04',NULL,NULL,NULL,NULL,'glide.maint',NULL,NULL,NULL,'\0',NULL,'phone',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0d5c0e2dc0a8026601ff88c3ef9ba532','glide.maint','2006-05-07 05:40:04','glide.maint','2006-05-07 05:40:04',0); /*!40000 ALTER TABLE `task` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2007-01-10 21:48:00