Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO `glpi_tickets` (`users_id`,`content`,`name`,`user_email`,`use_email_notification`,`urgency`,`itemtype`,`requesttypes_id`,`entities_id`,`impact`,`priority`,`users_id_recipient`,`status`,`global_vali
- dation`,`date`,`groups_id`,`groups_id_assign`,`items_id`,`users_id_assign`,`suppliers_id_assign`,`ticketcategories_id`,`date_mod`) VALUES (\'293\',\'Здравствуйте!Не открывается 1с 7.7 или открывается сразу 256
- раз. \\n \\n С уважением,\\n uuuuuuuuu mmmmm \\nБухгалтер \\n Компания XXXX \\n-------------------------------------------- \\n Раб.: +7 (495)zzzzzzzz (доб. 1222) \\n yyyyyyyyyyy @ XXXX . ru \\n -------------
- ------------------------------- \\n Информационнаябезопасность вашего бизнеса \\n http://www.XXXX.ru | http://XXXXblog.livejournal.com \\n Входит в XXXXGroup \\n www.XXXXXXXXXXXX\',\'Здравствуйте!Не открыва
- ется 1с 7.7 или открывается сразу 256 раз. \\n \\\',\'[email protected]\',\'1\',\'3\',\'\',\'2\',\'6\',\'3\',\'3\',\'293\',\'new\',\'none\',\'2011-01-31 16:54:44\',0,0,0,0,0,0,\'2011-01-31 16:54:44\')
- Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[email protected]','1','3','','2','6','3','3','293','new','none',
- '2011-01-31 1' at line 1
- CREATE TABLE IF NOT EXISTS `glpi_tickets` (
- `id` int(11) NOT NULL auto_increment,
- `entities_id` int(11) NOT NULL default '0',
- `name` varchar(255) collate utf8_unicode_ci default NULL,
- `date` datetime default NULL,
- `closedate` datetime default NULL,
- `solvedate` datetime default NULL,
- `date_mod` datetime default NULL,
- `status` varchar(255) collate utf8_unicode_ci default 'new',
- `users_id` int(11) NOT NULL default '0',
- `users_id_recipient` int(11) NOT NULL default '0',
- `groups_id` int(11) NOT NULL default '0',
- `requesttypes_id` int(11) NOT NULL default '0',
- `users_id_assign` int(11) NOT NULL default '0',
- `suppliers_id_assign` int(11) NOT NULL default '0',
- `groups_id_assign` int(11) NOT NULL default '0',
- `itemtype` varchar(100) collate utf8_unicode_ci NOT NULL,
- `items_id` int(11) NOT NULL default '0',
- `content` longtext collate utf8_unicode_ci,
- `urgency` int(11) NOT NULL default '1',
- `impact` int(11) NOT NULL default '1',
- `priority` int(11) NOT NULL default '1',
- `user_email` varchar(255) collate utf8_unicode_ci default NULL,
- `use_email_notification` tinyint(1) NOT NULL default '0',
- `realtime` float NOT NULL default '0',
- `ticketcategories_id` int(11) NOT NULL default '0',
- `cost_time` decimal(20,4) NOT NULL default '0.0000',
- `cost_fixed` decimal(20,4) NOT NULL default '0.0000',
- `cost_material` decimal(20,4) NOT NULL default '0.0000',
- `ticketsolutiontypes_id` int(11) NOT NULL default '0',
- `solution` text collate utf8_unicode_ci,
- `global_validation` varchar(255) collate utf8_unicode_ci default 'none',
- PRIMARY KEY (`id`),
- KEY `date` (`date`),
- KEY `closedate` (`closedate`),
- KEY `status` (`status`),
- KEY `priority` (`priority`),
- KEY `request_type` (`requesttypes_id`),
- KEY `date_mod` (`date_mod`),
- KEY `users_id_assign` (`users_id_assign`),
- KEY `groups_id_assign` (`groups_id_assign`),
- KEY `suppliers_id_assign` (`suppliers_id_assign`),
- KEY `users_id` (`users_id`),
- KEY `ticketcategories_id` (`ticketcategories_id`),
- KEY `entities_id` (`entities_id`),
- KEY `groups_id` (`groups_id`),
- KEY `users_id_recipient` (`users_id_recipient`),
- KEY `item` (`itemtype`,`items_id`),
- KEY `solvedate` (`solvedate`),
- KEY `ticketsolutiontypes_id` (`ticketsolutiontypes_id`),
- KEY `urgency` (`urgency`),
- KEY `impact` (`impact`),
- KEY `global_validation` (`global_validation`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5545 ;
Advertisement
Add Comment
Please, Sign In to add comment