diff options
| author | Haru <haru@dotalux.com> | 2015-07-08 15:11:32 +0200 |
|---|---|---|
| committer | Haru <haru@dotalux.com> | 2015-08-09 21:14:02 +0200 |
| commit | 8caa0e564b5331a88d8dc1712513368b37ba9694 (patch) | |
| tree | c9a1f5db3f1657c8c7bd1be409d937fe46d23c9b /sql-files | |
| parent | 84e02ac28fbb15c58d0a0f8a916b49663198b05b (diff) | |
| download | hercules-8caa0e564b5331a88d8dc1712513368b37ba9694.tar.gz hercules-8caa0e564b5331a88d8dc1712513368b37ba9694.tar.bz2 hercules-8caa0e564b5331a88d8dc1712513368b37ba9694.tar.xz hercules-8caa0e564b5331a88d8dc1712513368b37ba9694.zip | |
Removed unused tables sstatus and interreg
Signed-off-by: Haru <haru@dotalux.com>
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 20 | ||||
| -rw-r--r-- | sql-files/upgrades/2015-07-08--13-08.sql | 6 | ||||
| -rw-r--r-- | sql-files/upgrades/index.txt | 3 |
3 files changed, 8 insertions, 21 deletions
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 @@ -495,16 +495,6 @@ CREATE TABLE IF NOT EXISTS `interlog` ( ) 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` -- @@ -811,16 +801,6 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1414975503); -- 2014-11-03--00-4 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 |