diff options
| author | Andrei Karas <akaras@inbox.ru> | 2015-09-05 20:30:10 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2015-09-05 20:30:10 +0300 |
| commit | b3f0062ac62a75c87fcccc7cf4b271e4453ab0aa (patch) | |
| tree | 06c9f0cfeba58a17c283b0d3d0a874fd381c59fc /sql-files/main.sql | |
| parent | 6fb2cdc2dbf40d6bc9cf2d65c7b8e039455c4089 (diff) | |
| download | serverdata-b3f0062ac62a75c87fcccc7cf4b271e4453ab0aa.tar.gz serverdata-b3f0062ac62a75c87fcccc7cf4b271e4453ab0aa.tar.bz2 serverdata-b3f0062ac62a75c87fcccc7cf4b271e4453ab0aa.tar.xz serverdata-b3f0062ac62a75c87fcccc7cf4b271e4453ab0aa.zip | |
update sql files.
Diffstat (limited to 'sql-files/main.sql')
| -rw-r--r-- | sql-files/main.sql | 24 |
1 files changed, 4 insertions, 20 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index a00a3319..64bdfb5c 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -176,6 +176,7 @@ CREATE TABLE IF NOT EXISTS `char` ( `unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', `uniqueitem_counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `sex` ENUM('M','F','U') NOT NULL DEFAULT 'U', + `hotkey_rowshift` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`char_id`), UNIQUE KEY `name_key` (`name`), KEY `account_id` (`account_id`), @@ -495,16 +496,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` -- @@ -808,16 +799,9 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1398477600); -- 2014-04-26--10-0 INSERT INTO `sql_updates` (`timestamp`) VALUES (1400256139); -- 2014-05-17--00-06.sql INSERT INTO `sql_updates` (`timestamp`) VALUES (1409590380); -- 2014-09-01--16-53.sql INSERT INTO `sql_updates` (`timestamp`) VALUES (1414975503); -- 2014-11-03--00-45.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; +INSERT INTO `sql_updates` (`timestamp`) VALUES (1435860840); -- 2015-07-02--18-14.sql +INSERT INTO `sql_updates` (`timestamp`) VALUES (1436360978); -- 2015-07-08--13-08.sql +INSERT INTO `sql_updates` (`timestamp`) VALUES (1440688342); -- 2015-08-27--20-42.sql -- -- Table structure for table `storage` |