From 4bead55dcd50f13bf065841ed3eb3c46cb7b4c37 Mon Sep 17 00:00:00 2001 From: leak Date: Wed, 28 Mar 2012 19:51:13 +0200 Subject: SQL: Proper prefixing --- sql/updates/auth/2012_03_28_03_auth_ip_banned.sql | 2 ++ sql/updates/auth/2012_03_28_03_ip_banned.sql | 2 -- sql/updates/auth/2012_03_28_04_auth_logs.sql | 5 +++++ sql/updates/auth/2012_03_28_04_logs.sql | 5 ----- sql/updates/auth/2012_03_28_05_auth_realmcharacters.sql | 4 ++++ sql/updates/auth/2012_03_28_05_realmcharacters.sql | 4 ---- sql/updates/auth/2012_03_28_06_auth_realmlist.sql | 6 ++++++ sql/updates/auth/2012_03_28_06_realmlist.sql | 6 ------ sql/updates/auth/2012_03_28_07_auth_uptime.sql | 6 ++++++ sql/updates/auth/2012_03_28_07_uptime.sql | 6 ------ 10 files changed, 23 insertions(+), 23 deletions(-) create mode 100644 sql/updates/auth/2012_03_28_03_auth_ip_banned.sql delete mode 100644 sql/updates/auth/2012_03_28_03_ip_banned.sql create mode 100644 sql/updates/auth/2012_03_28_04_auth_logs.sql delete mode 100644 sql/updates/auth/2012_03_28_04_logs.sql create mode 100644 sql/updates/auth/2012_03_28_05_auth_realmcharacters.sql delete mode 100644 sql/updates/auth/2012_03_28_05_realmcharacters.sql create mode 100644 sql/updates/auth/2012_03_28_06_auth_realmlist.sql delete mode 100644 sql/updates/auth/2012_03_28_06_realmlist.sql create mode 100644 sql/updates/auth/2012_03_28_07_auth_uptime.sql delete mode 100644 sql/updates/auth/2012_03_28_07_uptime.sql (limited to 'sql') diff --git a/sql/updates/auth/2012_03_28_03_auth_ip_banned.sql b/sql/updates/auth/2012_03_28_03_auth_ip_banned.sql new file mode 100644 index 00000000000..2e754effc60 --- /dev/null +++ b/sql/updates/auth/2012_03_28_03_auth_ip_banned.sql @@ -0,0 +1,2 @@ +ALTER TABLE `ip_banned` + ROW_FORMAT=DEFAULT ENGINE=INNODB; diff --git a/sql/updates/auth/2012_03_28_03_ip_banned.sql b/sql/updates/auth/2012_03_28_03_ip_banned.sql deleted file mode 100644 index 2e754effc60..00000000000 --- a/sql/updates/auth/2012_03_28_03_ip_banned.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `ip_banned` - ROW_FORMAT=DEFAULT ENGINE=INNODB; diff --git a/sql/updates/auth/2012_03_28_04_auth_logs.sql b/sql/updates/auth/2012_03_28_04_auth_logs.sql new file mode 100644 index 00000000000..4c837a47ed1 --- /dev/null +++ b/sql/updates/auth/2012_03_28_04_auth_logs.sql @@ -0,0 +1,5 @@ +ALTER TABLE `logs` + CHANGE `time` `time` INT(10) UNSIGNED NOT NULL, + CHANGE `realm` `realm` INT(10) UNSIGNED NOT NULL, + CHANGE `type` `type` TINYINT(3) UNSIGNED NOT NULL, + ROW_FORMAT=DEFAULT ENGINE=INNODB; diff --git a/sql/updates/auth/2012_03_28_04_logs.sql b/sql/updates/auth/2012_03_28_04_logs.sql deleted file mode 100644 index 4c837a47ed1..00000000000 --- a/sql/updates/auth/2012_03_28_04_logs.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE `logs` - CHANGE `time` `time` INT(10) UNSIGNED NOT NULL, - CHANGE `realm` `realm` INT(10) UNSIGNED NOT NULL, - CHANGE `type` `type` TINYINT(3) UNSIGNED NOT NULL, - ROW_FORMAT=DEFAULT ENGINE=INNODB; diff --git a/sql/updates/auth/2012_03_28_05_auth_realmcharacters.sql b/sql/updates/auth/2012_03_28_05_auth_realmcharacters.sql new file mode 100644 index 00000000000..e50b3c3f331 --- /dev/null +++ b/sql/updates/auth/2012_03_28_05_auth_realmcharacters.sql @@ -0,0 +1,4 @@ +ALTER TABLE `realmcharacters` + CHANGE `realmid` `realmid` INT(10) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `acctid` `acctid` INT(10) UNSIGNED NOT NULL, + ROW_FORMAT=DEFAULT ENGINE=INNODB; diff --git a/sql/updates/auth/2012_03_28_05_realmcharacters.sql b/sql/updates/auth/2012_03_28_05_realmcharacters.sql deleted file mode 100644 index e50b3c3f331..00000000000 --- a/sql/updates/auth/2012_03_28_05_realmcharacters.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE `realmcharacters` - CHANGE `realmid` `realmid` INT(10) UNSIGNED DEFAULT 0 NOT NULL, - CHANGE `acctid` `acctid` INT(10) UNSIGNED NOT NULL, - ROW_FORMAT=DEFAULT ENGINE=INNODB; diff --git a/sql/updates/auth/2012_03_28_06_auth_realmlist.sql b/sql/updates/auth/2012_03_28_06_auth_realmlist.sql new file mode 100644 index 00000000000..e5e7b2e00d4 --- /dev/null +++ b/sql/updates/auth/2012_03_28_06_auth_realmlist.sql @@ -0,0 +1,6 @@ +ALTER TABLE `realmlist` + CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, + CHANGE `address` `address` VARCHAR(15) DEFAULT '127.0.0.1' NOT NULL, + CHANGE `port` `port` SMALLINT(5) UNSIGNED DEFAULT '8085' NOT NULL, + CHANGE `gamebuild` `gamebuild` INT(10) UNSIGNED DEFAULT '12340' NOT NULL, + ROW_FORMAT=DEFAULT ENGINE=INNODB; \ No newline at end of file diff --git a/sql/updates/auth/2012_03_28_06_realmlist.sql b/sql/updates/auth/2012_03_28_06_realmlist.sql deleted file mode 100644 index e5e7b2e00d4..00000000000 --- a/sql/updates/auth/2012_03_28_06_realmlist.sql +++ /dev/null @@ -1,6 +0,0 @@ -ALTER TABLE `realmlist` - CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, - CHANGE `address` `address` VARCHAR(15) DEFAULT '127.0.0.1' NOT NULL, - CHANGE `port` `port` SMALLINT(5) UNSIGNED DEFAULT '8085' NOT NULL, - CHANGE `gamebuild` `gamebuild` INT(10) UNSIGNED DEFAULT '12340' NOT NULL, - ROW_FORMAT=DEFAULT ENGINE=INNODB; \ No newline at end of file diff --git a/sql/updates/auth/2012_03_28_07_auth_uptime.sql b/sql/updates/auth/2012_03_28_07_auth_uptime.sql new file mode 100644 index 00000000000..0ea4e3321df --- /dev/null +++ b/sql/updates/auth/2012_03_28_07_auth_uptime.sql @@ -0,0 +1,6 @@ +ALTER TABLE `uptime` + DROP COLUMN `startstring`, + CHANGE `realmid` `realmid` INT(10) UNSIGNED NOT NULL, + CHANGE `starttime` `starttime` INT(10) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `uptime` `uptime` INT(10) UNSIGNED DEFAULT 0 NOT NULL, + ROW_FORMAT=DEFAULT ENGINE=INNODB; diff --git a/sql/updates/auth/2012_03_28_07_uptime.sql b/sql/updates/auth/2012_03_28_07_uptime.sql deleted file mode 100644 index 0ea4e3321df..00000000000 --- a/sql/updates/auth/2012_03_28_07_uptime.sql +++ /dev/null @@ -1,6 +0,0 @@ -ALTER TABLE `uptime` - DROP COLUMN `startstring`, - CHANGE `realmid` `realmid` INT(10) UNSIGNED NOT NULL, - CHANGE `starttime` `starttime` INT(10) UNSIGNED DEFAULT 0 NOT NULL, - CHANGE `uptime` `uptime` INT(10) UNSIGNED DEFAULT 0 NOT NULL, - ROW_FORMAT=DEFAULT ENGINE=INNODB; -- cgit v1.2.3