summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
diff options
context:
space:
mode:
authorAndrei Karas <akaras@inbox.ru>2014-11-05 01:11:22 +0300
committerAndrei Karas <akaras@inbox.ru>2014-11-05 01:11:22 +0300
commit72de794eefefe6ec3e4e6b35edbf4057ed150b1b (patch)
tree24c155f11fa6afb1a244aa855e4b0a20584ebd53 /sql-files/main.sql
parent13cf1b274ab9c18e5e080e9f2e3c10533fd38bad (diff)
downloadserverdata-72de794eefefe6ec3e4e6b35edbf4057ed150b1b.tar.gz
serverdata-72de794eefefe6ec3e4e6b35edbf4057ed150b1b.tar.bz2
serverdata-72de794eefefe6ec3e4e6b35edbf4057ed150b1b.tar.xz
serverdata-72de794eefefe6ec3e4e6b35edbf4057ed150b1b.zip
update initial sql scripts from hercules.
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r--sql-files/main.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 934b406a..a00a3319 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -175,6 +175,7 @@ CREATE TABLE IF NOT EXISTS `char` (
`font` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`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',
PRIMARY KEY (`char_id`),
UNIQUE KEY `name_key` (`name`),
KEY `account_id` (`account_id`),
@@ -806,6 +807,7 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1396893866); -- 2014-04-07--22-0
INSERT INTO `sql_updates` (`timestamp`) VALUES (1398477600); -- 2014-04-26--10-00.sql
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`