diff options
| author | shennetsind <ind@henn.et> | 2013-10-10 12:25:22 -0300 |
|---|---|---|
| committer | shennetsind <ind@henn.et> | 2013-10-10 12:25:22 -0300 |
| commit | c5c3381b0b8b0b59c669d474acf749db82d7edb1 (patch) | |
| tree | 5947d2a80594a1be87d3f5390cd04207c54e6ca3 /sql-files | |
| parent | fc4ae790a3e4c0a86beb2eec140479a9511b265d (diff) | |
| download | hercules-c5c3381b0b8b0b59c669d474acf749db82d7edb1.tar.gz hercules-c5c3381b0b8b0b59c669d474acf749db82d7edb1.tar.bz2 hercules-c5c3381b0b8b0b59c669d474acf749db82d7edb1.tar.xz hercules-c5c3381b0b8b0b59c669d474acf749db82d7edb1.zip | |
Introducing Bank Support
http://hercules.ws/board/topic/2455-introducing-bank-support/
Thanks to Yommy, Haru!
Signed-off-by: shennetsind <ind@henn.et>
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 16 | ||||
| -rw-r--r-- | sql-files/upgrades/2013-10-09--21-38.sql | 3 | ||||
| -rw-r--r-- | sql-files/upgrades/index.txt | 1 |
3 files changed, 20 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 0e9dc5b67..dcb735129 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -657,6 +657,7 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1362794218); INSERT INTO `sql_updates` (`timestamp`) VALUES (1364409316); INSERT INTO `sql_updates` (`timestamp`) VALUES (1366075474); INSERT INTO `sql_updates` (`timestamp`) VALUES (1366078541); +INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728); -- -- Table structure for table `sstatus` @@ -691,6 +692,10 @@ CREATE TABLE IF NOT EXISTS `storage` ( KEY `account_id` (`account_id`) ) ENGINE=MyISAM; +-- +-- Table structure for table `interreg` +-- + CREATE TABLE IF NOT EXISTS `interreg` ( `varname` varchar(11) NOT NULL, `value` varchar(20) NOT NULL, @@ -698,3 +703,14 @@ CREATE TABLE IF NOT EXISTS `interreg` ( ) ENGINE=InnoDB; INSERT INTO `interreg` (`varname`, `value`) VALUES ('unique_id', '0'); + +-- +-- Table structure for table `account_data` +-- + +CREATE TABLE IF NOT EXISTS `account_data` ( + `account_id` int(11) unsigned NOT NULL default '0', + `bank_vault` int(11) unsigned NOT NULL default '0', + PRIMARY KEY (`account_id`) +) ENGINE=MyISAM; + diff --git a/sql-files/upgrades/2013-10-09--21-38.sql b/sql-files/upgrades/2013-10-09--21-38.sql new file mode 100644 index 000000000..fee85c40b --- /dev/null +++ b/sql-files/upgrades/2013-10-09--21-38.sql @@ -0,0 +1,3 @@ +#1381354728 +ALTER TABLE `zenylog` MODIFY `type` enum('T','V','P','M','S','N','D','C','A','E','I','B','K') NOT NULL DEFAULT 'S'; +INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728);
\ No newline at end of file diff --git a/sql-files/upgrades/index.txt b/sql-files/upgrades/index.txt index 984898b22..bffc42f99 100644 --- a/sql-files/upgrades/index.txt +++ b/sql-files/upgrades/index.txt @@ -4,3 +4,4 @@ 2013-03-06--00-00.sql 2013-03-09--01-56.sql 2013-04-16--01-24.sql +2013-10-09--21-38.sql
\ No newline at end of file |