summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHaru <haru@dotalux.com>2015-07-08 15:11:32 +0200
committerHaru <haru@dotalux.com>2015-08-09 21:14:02 +0200
commit8caa0e564b5331a88d8dc1712513368b37ba9694 (patch)
treec9a1f5db3f1657c8c7bd1be409d937fe46d23c9b /sql-files
parent84e02ac28fbb15c58d0a0f8a916b49663198b05b (diff)
downloadhercules-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.sql20
-rw-r--r--sql-files/upgrades/2015-07-08--13-08.sql6
-rw-r--r--sql-files/upgrades/index.txt3
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