From ad1c6e04f2b177ce109fe1cc9d8defc77250a35b Mon Sep 17 00:00:00 2001 From: WubTheCaptain Date: Sat, 19 Sep 2015 16:57:09 +0000 Subject: Revert "Spelling error of the century" You don't attempt to rename "A" to "A" in the database. Doing so breaks the patch. Restore the intended functionality "A" to "B". You also shouldn't be using Windows newlines. This reverts commit aa61832a73bac8e1045b70a887e5bee1839599d1. --- update.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'update.sql') diff --git a/update.sql b/update.sql index 263718e..ac4d548 100755 --- a/update.sql +++ b/update.sql @@ -3,7 +3,7 @@ CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment; ALTER TABLE `files` CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment, -CHANGE COLUMN `originalname` `originalname` varchar(255) NULL default NULL, +CHANGE COLUMN `orginalname` `originalname` varchar(255) NULL default NULL, CHANGE COLUMN `size` `size` int(10) NULL default NULL, CHANGE COLUMN `user` `user` int(10) NULL default '0'; @@ -13,4 +13,4 @@ CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment; ALTER TABLE `reports` CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment, CHANGE COLUMN `file` `file` varchar(255) NOT NULL, -CHANGE COLUMN `reporter` `reporter` varchar(255) NOT NULL; +CHANGE COLUMN `reporter` `reporter` varchar(255) NOT NULL; \ No newline at end of file -- cgit v1.2.3 From f75694659f5f8438c265709c799750dfcff8cbcc Mon Sep 17 00:00:00 2001 From: WubTheCaptain Date: Sat, 19 Sep 2015 17:06:50 +0000 Subject: Give update.sql some dos2unix(1) treatment --- update.sql | 32 ++++++++++++++++---------------- 1 file changed, 16 insertions(+), 16 deletions(-) (limited to 'update.sql') diff --git a/update.sql b/update.sql index ac4d548..0cdbb5b 100755 --- a/update.sql +++ b/update.sql @@ -1,16 +1,16 @@ -ALTER TABLE `accounts` -CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment; - -ALTER TABLE `files` -CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment, -CHANGE COLUMN `orginalname` `originalname` varchar(255) NULL default NULL, -CHANGE COLUMN `size` `size` int(10) NULL default NULL, -CHANGE COLUMN `user` `user` int(10) NULL default '0'; - -ALTER TABLE `invites` -CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment; - -ALTER TABLE `reports` -CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment, -CHANGE COLUMN `file` `file` varchar(255) NOT NULL, -CHANGE COLUMN `reporter` `reporter` varchar(255) NOT NULL; \ No newline at end of file +ALTER TABLE `accounts` +CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment; + +ALTER TABLE `files` +CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment, +CHANGE COLUMN `orginalname` `originalname` varchar(255) NULL default NULL, +CHANGE COLUMN `size` `size` int(10) NULL default NULL, +CHANGE COLUMN `user` `user` int(10) NULL default '0'; + +ALTER TABLE `invites` +CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment; + +ALTER TABLE `reports` +CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment, +CHANGE COLUMN `file` `file` varchar(255) NOT NULL, +CHANGE COLUMN `reporter` `reporter` varchar(255) NOT NULL; -- cgit v1.2.3 From 0170069575c7b4cc8bb39515c3efc487decbcc4a Mon Sep 17 00:00:00 2001 From: WubTheCaptain Date: Sun, 20 Sep 2015 07:37:36 +0000 Subject: Remove moe panel tables from core database schema Accounts, invites and reports are not used in the core. These will be moved to pomf-moe repository. You don't need it anymore. While the change of `orginalname` to `originalname` is good to mention, it is better served in the documentantion for those who are upgrading instead of laying around useless here in this code repository. OK pantsucat --- update.sql | 16 ---------------- 1 file changed, 16 deletions(-) delete mode 100755 update.sql (limited to 'update.sql') diff --git a/update.sql b/update.sql deleted file mode 100755 index 0cdbb5b..0000000 --- a/update.sql +++ /dev/null @@ -1,16 +0,0 @@ -ALTER TABLE `accounts` -CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment; - -ALTER TABLE `files` -CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment, -CHANGE COLUMN `orginalname` `originalname` varchar(255) NULL default NULL, -CHANGE COLUMN `size` `size` int(10) NULL default NULL, -CHANGE COLUMN `user` `user` int(10) NULL default '0'; - -ALTER TABLE `invites` -CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment; - -ALTER TABLE `reports` -CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment, -CHANGE COLUMN `file` `file` varchar(255) NOT NULL, -CHANGE COLUMN `reporter` `reporter` varchar(255) NOT NULL; -- cgit v1.2.3