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
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
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
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