diff options
| author | Andrei Karas <akaras@inbox.ru> | 2015-02-18 15:26:11 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2015-02-18 15:30:41 +0300 |
| commit | a78224ded6873bbb3078a7f01f123551b34a82fb (patch) | |
| tree | f286da32fb0018820ae59d9eeadbe5de31e6486c /hercules/templates | |
| parent | 1cf8a73eaab31a1a868ea9edf88d256a37d21fc2 (diff) | |
| download | evol-tools-a78224ded6873bbb3078a7f01f123551b34a82fb.tar.gz evol-tools-a78224ded6873bbb3078a7f01f123551b34a82fb.tar.bz2 evol-tools-a78224ded6873bbb3078a7f01f123551b34a82fb.tar.xz evol-tools-a78224ded6873bbb3078a7f01f123551b34a82fb.zip | |
hercules: add converter for account.txt
Diffstat (limited to 'hercules/templates')
| -rw-r--r-- | hercules/templates/login.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/hercules/templates/login.sql b/hercules/templates/login.sql new file mode 100644 index 0000000..39bf531 --- /dev/null +++ b/hercules/templates/login.sql @@ -0,0 +1,21 @@ +CREATE TABLE IF NOT EXISTS `login` ( + `account_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `userid` VARCHAR(23) NOT NULL DEFAULT '', + `user_pass` VARCHAR(32) NOT NULL DEFAULT '', + `sex` ENUM('M','F','S') NOT NULL DEFAULT 'M', + `email` VARCHAR(39) NOT NULL DEFAULT '', + `group_id` TINYINT(3) NOT NULL DEFAULT '0', + `state` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `unban_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `expiration_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `logincount` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0', + `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 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=InnoDB AUTO_INCREMENT=2000000; + |