X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=install%2Ftables.sql;h=24c48bbe9f056a7634e05dce698cbae14db88d54;hb=2f7ccb30d9251afcf733d840e48d6ac2317a9f6c;hp=c231e0f4340574a2ec3cd9afec85874fefa8037f;hpb=d0ab0382dd73638f0bc13a1a3d6f117ec11a203e;p=mailer.git

diff --git a/install/tables.sql b/install/tables.sql
index c231e0f434..24c48bbe9f 100644
--- 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';
 alter table `mxchange_config` add `last_update` varchar(10) not null default '0';
 
-UPDATE `mxchange_member_menu` SET locked = 'N' WHERE 'id'='12' OR 'id'='11' LIMIT 1;
+UPDATE `mxchange_member_menu` SET `locked` = 'N' WHERE 'id'='12' OR 'id'='11' LIMIT 1;
 
-UPDATE `mxchange_guest_menu` SET counter='0';
-UPDATE `mxchange_member_menu` SET counter='0';
+UPDATE `mxchange_guest_menu` SET `counter`=0;
+UPDATE `mxchange_member_menu` SET `counter`=0;
 
 INSERT INTO `mxchange_mod_reg` VALUES (NULL,'chk_login','N','N','N','','N',0);
 alter table `mxchange_pool` modify `data_type` enum('TEMP','SEND','NEW','ADMIN','ACTIVE') not null default 'TEMP';
@@ -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;
 
 DROP TABLE IF EXISTS `mxchange_task_system`;
-CREATE TABLE mxchange_task_system (
-  id bigint(20) NOT NULL auto_increment,
-  assigned_admin bigint(20) NOT NULL default '0',
-  userid bigint(20) NOT NULL default '0',
-  status enum('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL default 'NEW',
-  task_type enum('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS', 'EXTENSION', 'EXTENSION_UPDATE') NOT NULL default 'FIRST_USER',
-  subject varchar(255) NOT NULL default '',
-  text longblob NOT NULL,
-  task_created varchar(10) NOT NULL default '0',
-  KEY (assigned_admin),
-  PRIMARY KEY  (id)
+CREATE TABLE `mxchange_task_system` (
+  `id` bigint(20) NOT NULL auto_increment,
+  `assigned_admin` bigint(20) NOT NULL default '0',
+  `userid` bigint(20) NOT NULL default '0',
+  `status` enum('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL default 'NEW',
+  `task_type` enum('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS', 'EXTENSION', 'EXTENSION_UPDATE') NOT NULL default 'FIRST_USER',
+  `subject` varchar(255) NOT NULL default '',
+  `text` longblob NOT NULL,
+  `task_created` varchar(10) NOT NULL default '0',
+  KEY (`assigned_admin`),
+  PRIMARY KEY  (`id`)
 ) TYPE=MyISAM;
 
-ALTER TABLE `mxchange_pool` ADD INDEX (sender);
-ALTER TABLE `mxchange_pool` ADD INDEX (payment_id);
-ALTER TABLE `mxchange_pool` ADD INDEX (cat_id);
-ALTER TABLE `mxchange_refsystem` ADD INDEX (userid);
-ALTER TABLE `mxchange_task_system` ADD INDEX (assigned_admin);
-ALTER TABLE `mxchange_task_system` ADD INDEX (userid);
-ALTER TABLE `mxchange_user_cats` ADD INDEX (userid);
-ALTER TABLE `mxchange_user_cats` ADD INDEX (cat_id);
-ALTER TABLE `mxchange_user_data` ADD INDEX (refid);
-ALTER TABLE `mxchange_user_links` ADD INDEX (userid);
-ALTER TABLE `mxchange_user_links` ADD INDEX (stats_id);
-ALTER TABLE `mxchange_user_points` ADD INDEX (userid);
-ALTER TABLE `mxchange_user_stats` ADD INDEX (userid);
-ALTER TABLE `mxchange_user_stats` ADD INDEX (cat_id);
-ALTER TABLE `mxchange_user_stats` ADD INDEX (payment_id);
-ALTER TABLE `mxchange_user_stats` ADD INDEX (pool_id);
+ALTER TABLE `mxchange_pool` ADD INDEX (`sender`);
+ALTER TABLE `mxchange_pool` ADD INDEX (`payment_id`);
+ALTER TABLE `mxchange_pool` ADD INDEX (`cat_id`);
+ALTER TABLE `mxchange_refsystem` ADD INDEX (`userid`);
+ALTER TABLE `mxchange_task_system` ADD INDEX (`assigned_admin`);
+ALTER TABLE `mxchange_task_system` ADD INDEX (`userid`);
+ALTER TABLE `mxchange_user_cats` ADD INDEX (`userid`);
+ALTER TABLE `mxchange_user_cats` ADD INDEX (`cat_id`);
+ALTER TABLE `mxchange_user_data` ADD INDEX (`refid`);
+ALTER TABLE `mxchange_user_links` ADD INDEX (`userid`);
+ALTER TABLE `mxchange_user_links` ADD INDEX (`stats_id`);
+ALTER TABLE `mxchange_user_points` ADD INDEX (`userid`);
+ALTER TABLE `mxchange_user_stats` ADD INDEX (`userid`);
+ALTER TABLE `mxchange_user_stats` ADD INDEX (`cat_id`);
+ALTER TABLE `mxchange_user_stats` ADD INDEX (`payment_id`);
+ALTER TABLE `mxchange_user_stats` ADD INDEX (`pool_id`);
 
 alter table `mxchange_user_stats` add `clicks` bigint not null;
 alter table `mxchange_config` add `code_length` tinyint not null default '5';
@@ -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';
 alter table `mxchange_user_points` add `locked_points` bigint not null default '0';
 
-DROP TABLE IF EXISTS mxchange_extensions;
-CREATE TABLE mxchange_extensions (
-  id bigint(20) NOT NULL auto_increment,
-  ext_name varchar(255) NOT NULL default '',
-  ext_lang_file varchar(255) NOT NULL default '',
-  ext_active enum('Y','N') NOT NULL default 'N',
-  ext_version varchar(255) NOT NULL default '0.',
-  PRIMARY KEY  (id)
+DROP TABLE IF EXISTS `mxchange_extensions`;
+CREATE TABLE `mxchange_extensions` (
+  `id` bigint(20) NOT NULL auto_increment,
+  `ext_name` varchar(255) NOT NULL default '',
+  `ext_lang_file` varchar(255) NOT NULL default '',
+  `ext_active` enum('Y','N') NOT NULL default 'N',
+  `ext_version` varchar(255) NOT NULL default '0.',
+  PRIMARY KEY  (`id`)
 ) TYPE=MyISAM;
 
 DROP TABLE IF EXISTS `mxchange_jackpot`;
@@ -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';
 alter table `mxchange_user_data` modify `joined` varchar(10)  not null default '0';
 alter table `mxchange_user_data` modify `last_online` varchar(10)  not null default '0';
-update `mxchange_user_data` SET last_profile_sent='0' WHERE last_profile_sent='0000000000';
-update `mxchange_user_data` SET last_update='0' WHERE last_update='0000000000';
-update `mxchange_user_data` SET joined='0' WHERE joined='0000000000';
-update `mxchange_user_data` SET last_online='0' WHERE last_online='0000000000';