Guest User

Untitled

a guest
Jan 31st, 2011
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.88 KB | None | 0 0
  1. 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
  2. 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
  3. раз. \\n \\n С уважением,\\n uuuuuuuuu mmmmm \\nБухгалтер \\n Компания XXXX \\n-------------------------------------------- \\n Раб.: +7 (495)zzzzzzzz (доб. 1222) \\n yyyyyyyyyyy @ XXXX . ru \\n -------------
  4. ------------------------------- \\n Информационнаябезопасность вашего бизнеса \\n http://www.XXXX.ru   |  http://XXXXblog.livejournal.com \\n Входит в XXXXGroup \\n www.XXXXXXXXXXXX\',\'Здравствуйте!Не открыва
  5. ется 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\')
  6.  
  7. 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',
  8. '2011-01-31 1' at line 1
  9.  
  10. CREATE TABLE IF NOT EXISTS `glpi_tickets` (
  11. `id` int(11) NOT NULL auto_increment,
  12. `entities_id` int(11) NOT NULL default '0',
  13. `name` varchar(255) collate utf8_unicode_ci default NULL,
  14. `date` datetime default NULL,
  15. `closedate` datetime default NULL,
  16. `solvedate` datetime default NULL,
  17. `date_mod` datetime default NULL,
  18. `status` varchar(255) collate utf8_unicode_ci default 'new',
  19. `users_id` int(11) NOT NULL default '0',
  20. `users_id_recipient` int(11) NOT NULL default '0',
  21. `groups_id` int(11) NOT NULL default '0',
  22. `requesttypes_id` int(11) NOT NULL default '0',
  23. `users_id_assign` int(11) NOT NULL default '0',
  24. `suppliers_id_assign` int(11) NOT NULL default '0',
  25. `groups_id_assign` int(11) NOT NULL default '0',
  26. `itemtype` varchar(100) collate utf8_unicode_ci NOT NULL,
  27. `items_id` int(11) NOT NULL default '0',
  28. `content` longtext collate utf8_unicode_ci,
  29. `urgency` int(11) NOT NULL default '1',
  30. `impact` int(11) NOT NULL default '1',
  31. `priority` int(11) NOT NULL default '1',
  32. `user_email` varchar(255) collate utf8_unicode_ci default NULL,
  33. `use_email_notification` tinyint(1) NOT NULL default '0',
  34. `realtime` float NOT NULL default '0',
  35. `ticketcategories_id` int(11) NOT NULL default '0',
  36. `cost_time` decimal(20,4) NOT NULL default '0.0000',
  37. `cost_fixed` decimal(20,4) NOT NULL default '0.0000',
  38. `cost_material` decimal(20,4) NOT NULL default '0.0000',
  39. `ticketsolutiontypes_id` int(11) NOT NULL default '0',
  40. `solution` text collate utf8_unicode_ci,
  41. `global_validation` varchar(255) collate utf8_unicode_ci default 'none',
  42. PRIMARY KEY (`id`),
  43. KEY `date` (`date`),
  44. KEY `closedate` (`closedate`),
  45. KEY `status` (`status`),
  46. KEY `priority` (`priority`),
  47. KEY `request_type` (`requesttypes_id`),
  48. KEY `date_mod` (`date_mod`),
  49. KEY `users_id_assign` (`users_id_assign`),
  50. KEY `groups_id_assign` (`groups_id_assign`),
  51. KEY `suppliers_id_assign` (`suppliers_id_assign`),
  52. KEY `users_id` (`users_id`),
  53. KEY `ticketcategories_id` (`ticketcategories_id`),
  54. KEY `entities_id` (`entities_id`),
  55. KEY `groups_id` (`groups_id`),
  56. KEY `users_id_recipient` (`users_id_recipient`),
  57. KEY `item` (`itemtype`,`items_id`),
  58. KEY `solvedate` (`solvedate`),
  59. KEY `ticketsolutiontypes_id` (`ticketsolutiontypes_id`),
  60. KEY `urgency` (`urgency`),
  61. KEY `impact` (`impact`),
  62. KEY `global_validation` (`global_validation`)
  63. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5545 ;
Advertisement
Add Comment
Please, Sign In to add comment