From 8caa0e564b5331a88d8dc1712513368b37ba9694 Mon Sep 17 00:00:00 2001 From: Haru Date: Wed, 8 Jul 2015 15:11:32 +0200 Subject: Removed unused tables sstatus and interreg Signed-off-by: Haru --- sql-files/main.sql | 20 -------------------- sql-files/upgrades/2015-07-08--13-08.sql | 6 ++++++ sql-files/upgrades/index.txt | 3 ++- 3 files changed, 8 insertions(+), 21 deletions(-) create mode 100644 sql-files/upgrades/2015-07-08--13-08.sql (limited to 'sql-files') diff --git a/sql-files/main.sql b/sql-files/main.sql index 646805d1b..c95610016 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -494,16 +494,6 @@ CREATE TABLE IF NOT EXISTS `interlog` ( `log` VARCHAR(255) NOT NULL DEFAULT '' ) ENGINE=MyISAM; --- --- Table structure for table `interreg` --- - -CREATE TABLE IF NOT EXISTS `interreg` ( - `varname` VARCHAR(11) NOT NULL, - `value` VARCHAR(20) NOT NULL, - PRIMARY KEY (`varname`) -) ENGINE=InnoDB; - -- -- Table structure for table `inventory` -- @@ -810,16 +800,6 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1409590380); -- 2014-09-01--16-5 INSERT INTO `sql_updates` (`timestamp`) VALUES (1414975503); -- 2014-11-03--00-45.sql INSERT INTO `sql_updates` (`timestamp`) VALUES (1435860840); -- 2015-07-02--18-14.sql --- --- Table structure for table `sstatus` --- - -CREATE TABLE IF NOT EXISTS `sstatus` ( - `index` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', - `name` VARCHAR(255) NOT NULL DEFAULT '', - `user` INT(11) UNSIGNED NOT NULL DEFAULT '0' -) ENGINE=MyISAM; - -- -- Table structure for table `storage` -- diff --git a/sql-files/upgrades/2015-07-08--13-08.sql b/sql-files/upgrades/2015-07-08--13-08.sql new file mode 100644 index 000000000..f9cbf1a42 --- /dev/null +++ b/sql-files/upgrades/2015-07-08--13-08.sql @@ -0,0 +1,6 @@ +#1436360978 + +DROP TABLE IF EXISTS interreg; +DROP TABLE IF EXISTS sstatus; + +INSERT INTO `sql_updates` (`timestamp`) VALUES (1435860840); diff --git a/sql-files/upgrades/index.txt b/sql-files/upgrades/index.txt index 0e6917f16..94d87d191 100644 --- a/sql-files/upgrades/index.txt +++ b/sql-files/upgrades/index.txt @@ -25,4 +25,5 @@ 2014-05-17--00-06.sql 2014-09-01--16-53.sql 2014-11-03--00-45.sql -2015-07-02--18-14.sql \ No newline at end of file +2015-07-02--18-14.sql +2015-07-08--13-08.sql -- cgit v1.2.3-70-g09d2