From 5f5380e8d5fa2e6042813e35101cb33b656e3972 Mon Sep 17 00:00:00 2001 From: Shido Date: Fri, 16 May 2014 21:42:25 +0800 Subject: Renamed incuvate of Pet System. --- sql-files/upgrades/2014-05-17--00-06.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql-files/upgrades/2014-05-17--00-06.sql (limited to 'sql-files/upgrades/2014-05-17--00-06.sql') diff --git a/sql-files/upgrades/2014-05-17--00-06.sql b/sql-files/upgrades/2014-05-17--00-06.sql new file mode 100644 index 000000000..8f19c859f --- /dev/null +++ b/sql-files/upgrades/2014-05-17--00-06.sql @@ -0,0 +1,3 @@ +#1400256139 +RENAME TABLE `incuvate` TO `incubate` +INSERT INTO `sql_updates` (`timestamp`) VALUES (1400256139); -- cgit v1.2.3-70-g09d2 From a42f880e87962b1020fbab36c690ccbf7f28da01 Mon Sep 17 00:00:00 2001 From: Haru Date: Sat, 17 May 2014 13:37:39 +0200 Subject: Follow-up to 5f5380e8d5fa2e6042813e35101cb33b656e3972 - Fixed a missing semicolon in the upgrade script. Special thanks to QQfoolsorellina Signed-off-by: Haru --- sql-files/upgrades/2014-05-17--00-06.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql-files/upgrades/2014-05-17--00-06.sql') diff --git a/sql-files/upgrades/2014-05-17--00-06.sql b/sql-files/upgrades/2014-05-17--00-06.sql index 8f19c859f..a9943ce38 100644 --- a/sql-files/upgrades/2014-05-17--00-06.sql +++ b/sql-files/upgrades/2014-05-17--00-06.sql @@ -1,3 +1,3 @@ #1400256139 -RENAME TABLE `incuvate` TO `incubate` +RENAME TABLE `incuvate` TO `incubate`; INSERT INTO `sql_updates` (`timestamp`) VALUES (1400256139); -- cgit v1.2.3-70-g09d2 From 3591de7e7ac2db4e3eeaa9bad2615648e7f94b3a Mon Sep 17 00:00:00 2001 From: Shido Date: Sun, 18 May 2014 00:56:03 +0800 Subject: Follow-up 5f5380e and a42f880e, Fixed crappy coding with sql-update file(Special thanks to QQfoolsorellina) --- sql-files/upgrades/2014-05-17--00-06.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql-files/upgrades/2014-05-17--00-06.sql') diff --git a/sql-files/upgrades/2014-05-17--00-06.sql b/sql-files/upgrades/2014-05-17--00-06.sql index a9943ce38..4e5d0d32a 100644 --- a/sql-files/upgrades/2014-05-17--00-06.sql +++ b/sql-files/upgrades/2014-05-17--00-06.sql @@ -1,3 +1,3 @@ #1400256139 -RENAME TABLE `incuvate` TO `incubate`; +ALTER TABLE `pet` CHANGE `incuvate` `incubate` int(11) unsigned NOT NULL default '0'; INSERT INTO `sql_updates` (`timestamp`) VALUES (1400256139); -- cgit v1.2.3-70-g09d2