diff options
Diffstat (limited to 'sql-files/main.sql')
| -rw-r--r-- | sql-files/main.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 3270bf7e2..b7b3e5226 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -438,7 +438,9 @@ CREATE TABLE IF NOT EXISTS `login` ( `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', `last_ip` varchar(100) NOT NULL default '', `birthdate` DATE NOT NULL DEFAULT '0000-00-00', - `character_slots` TINYINT( 3 ) unsigned NOT NULL, + `character_slots` TINYINT( 3 ) unsigned NOT NULL default '0', + `pincode` varchar(4) NOT NULL default '', + `pincode_change` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`account_id`), KEY `name` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000; @@ -648,6 +650,8 @@ CREATE TABLE IF NOT EXISTS `sql_updates` ( INSERT INTO `sql_updates` (`timestamp`) VALUES (1360858500); INSERT INTO `sql_updates` (`timestamp`) VALUES (1360951560); INSERT INTO `sql_updates` (`timestamp`) VALUES (1362445531); +INSERT INTO `sql_updates` (`timestamp`) VALUES (1362528000); +INSERT INTO `sql_updates` (`timestamp`) VALUES (1362794218); -- -- Table structure for table `sstatus` |