Columns and table names in backticks

[mailer.git] / install / tables.sql

diff --git a/install/tables.sql b/install/tables.sql
index c231e0f4340574a2ec3cd9afec85874fefa8037f..24c48bbe9f056a7634e05dce698cbae14db88d54 100644 (file)
--- a/install/tables.sql
+++ b/install/tables.sql
@@ -246,10 +246,10 @@ CREATE TABLE `mxchange_user_stats` (
 alter table `mxchange_user_data` add `joined` varchar(10) not null default '0';\r
 alter table `mxchange_config` add `last_update` varchar(10) not null default '0';\r
 \r
-UPDATE `mxchange_member_menu` SET locked = 'N' WHERE 'id'='12' OR 'id'='11' LIMIT 1;\r
+UPDATE `mxchange_member_menu` SET `locked` = 'N' WHERE 'id'='12' OR 'id'='11' LIMIT 1;\r
 \r
-UPDATE `mxchange_guest_menu` SET counter='0';\r
-UPDATE `mxchange_member_menu` SET counter='0';\r
+UPDATE `mxchange_guest_menu` SET `counter`=0;\r
+UPDATE `mxchange_member_menu` SET `counter`=0;\r
 \r
 INSERT INTO `mxchange_mod_reg` VALUES (NULL,'chk_login','N','N','N','','N',0);\r
 alter table `mxchange_pool` modify `data_type` enum('TEMP','SEND','NEW','ADMIN','ACTIVE') not null default 'TEMP';\r
@@ -274,35 +274,35 @@ alter table `mxchange_config` add `patch_ctime` varchar(10) not null default '0'
 alter table `mxchange_admins` add `email` varchar(255) not null;\r
 \r
 DROP TABLE IF EXISTS `mxchange_task_system`;\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
+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
 ) TYPE=MyISAM;\r
 \r
-ALTER TABLE `mxchange_pool` ADD INDEX (sender);\r
-ALTER TABLE `mxchange_pool` ADD INDEX (payment_id);\r
-ALTER TABLE `mxchange_pool` ADD INDEX (cat_id);\r
-ALTER TABLE `mxchange_refsystem` ADD INDEX (userid);\r
-ALTER TABLE `mxchange_task_system` ADD INDEX (assigned_admin);\r
-ALTER TABLE `mxchange_task_system` ADD INDEX (userid);\r
-ALTER TABLE `mxchange_user_cats` ADD INDEX (userid);\r
-ALTER TABLE `mxchange_user_cats` ADD INDEX (cat_id);\r
-ALTER TABLE `mxchange_user_data` ADD INDEX (refid);\r
-ALTER TABLE `mxchange_user_links` ADD INDEX (userid);\r
-ALTER TABLE `mxchange_user_links` ADD INDEX (stats_id);\r
-ALTER TABLE `mxchange_user_points` ADD INDEX (userid);\r
-ALTER TABLE `mxchange_user_stats` ADD INDEX (userid);\r
-ALTER TABLE `mxchange_user_stats` ADD INDEX (cat_id);\r
-ALTER TABLE `mxchange_user_stats` ADD INDEX (payment_id);\r
-ALTER TABLE `mxchange_user_stats` ADD INDEX (pool_id);\r
+ALTER TABLE `mxchange_pool` ADD INDEX (`sender`);\r
+ALTER TABLE `mxchange_pool` ADD INDEX (`payment_id`);\r
+ALTER TABLE `mxchange_pool` ADD INDEX (`cat_id`);\r
+ALTER TABLE `mxchange_refsystem` ADD INDEX (`userid`);\r
+ALTER TABLE `mxchange_task_system` ADD INDEX (`assigned_admin`);\r
+ALTER TABLE `mxchange_task_system` ADD INDEX (`userid`);\r
+ALTER TABLE `mxchange_user_cats` ADD INDEX (`userid`);\r
+ALTER TABLE `mxchange_user_cats` ADD INDEX (`cat_id`);\r
+ALTER TABLE `mxchange_user_data` ADD INDEX (`refid`);\r
+ALTER TABLE `mxchange_user_links` ADD INDEX (`userid`);\r
+ALTER TABLE `mxchange_user_links` ADD INDEX (`stats_id`);\r
+ALTER TABLE `mxchange_user_points` ADD INDEX (`userid`);\r
+ALTER TABLE `mxchange_user_stats` ADD INDEX (`userid`);\r
+ALTER TABLE `mxchange_user_stats` ADD INDEX (`cat_id`);\r
+ALTER TABLE `mxchange_user_stats` ADD INDEX (`payment_id`);\r
+ALTER TABLE `mxchange_user_stats` ADD INDEX (`pool_id`);\r
 \r
 alter table `mxchange_user_stats` add `clicks` bigint not null;\r
 alter table `mxchange_config` add `code_length` tinyint not null default '5';\r
@@ -311,14 +311,14 @@ alter table `mxchange_config` add `ref_payout` tinyint not null default '5';
 alter table `mxchange_user_data` add `ref_payout` tinyint not null default '0';\r
 alter table `mxchange_user_points` add `locked_points` bigint not null default '0';\r
 \r
-DROP TABLE IF EXISTS mxchange_extensions;\r
-CREATE TABLE mxchange_extensions (\r
-  id bigint(20) NOT NULL auto_increment,\r
-  ext_name varchar(255) NOT NULL default '',\r
-  ext_lang_file varchar(255) NOT NULL default '',\r
-  ext_active enum('Y','N') NOT NULL default 'N',\r
-  ext_version varchar(255) NOT NULL default '0.',\r
-  PRIMARY KEY  (id)\r
+DROP TABLE IF EXISTS `mxchange_extensions`;\r
+CREATE TABLE `mxchange_extensions` (\r
+  `id` bigint(20) NOT NULL auto_increment,\r
+  `ext_name` varchar(255) NOT NULL default '',\r
+  `ext_lang_file` varchar(255) NOT NULL default '',\r
+  `ext_active` enum('Y','N') NOT NULL default 'N',\r
+  `ext_version` varchar(255) NOT NULL default '0.',\r
+  PRIMARY KEY  (`id`)\r
 ) TYPE=MyISAM;\r
 \r
 DROP TABLE IF EXISTS `mxchange_jackpot`;\r
@@ -344,7 +344,3 @@ alter table `mxchange_user_data` modify `last_profile_sent` varchar(10)  not nul
 alter table `mxchange_user_data` modify `last_update` varchar(10)  not null default '0';\r
 alter table `mxchange_user_data` modify `joined` varchar(10)  not null default '0';\r
 alter table `mxchange_user_data` modify `last_online` varchar(10)  not null default '0';\r
-update `mxchange_user_data` SET last_profile_sent='0' WHERE last_profile_sent='0000000000';\r
-update `mxchange_user_data` SET last_update='0' WHERE last_update='0000000000';\r
-update `mxchange_user_data` SET joined='0' WHERE joined='0000000000';\r
-update `mxchange_user_data` SET last_online='0' WHERE last_online='0000000000';\r