-CREATE TABLE mxchange_task_system (\r
- id bigint(20) NOT NULL auto_increment,\r
- assigned_admin bigint(20) NOT NULL default '0',\r
- userid bigint(20) NOT NULL default '0',\r
- status enum('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL default 'NEW',\r
- task_type enum('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS', 'EXTENSION', 'EXTENSION_UPDATE') NOT NULL default 'FIRST_USER',\r
- subject varchar(255) NOT NULL default '',\r
- text longblob NOT NULL,\r
- task_created varchar(10) NOT NULL default '0',\r
- KEY (assigned_admin),\r
- PRIMARY KEY (id)\r
+CREATE TABLE `mxchange_task_system` (\r
+ `id` bigint(20) NOT NULL auto_increment,\r
+ `assigned_admin` bigint(20) NOT NULL default '0',\r
+ `userid` bigint(20) NOT NULL default '0',\r
+ `status` enum('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL default 'NEW',\r
+ `task_type` enum('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS', 'EXTENSION', 'EXTENSION_UPDATE') NOT NULL default 'FIRST_USER',\r
+ `subject` varchar(255) NOT NULL default '',\r
+ `text` longblob NOT NULL,\r
+ `task_created` varchar(10) NOT NULL default '0',\r
+ KEY (`assigned_admin`),\r
+ PRIMARY KEY (`id`)\r