Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `players`
- (
- `id` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) NOT NULL,
- `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
- `group_id` INT NOT NULL DEFAULT 1,
- `account_id` INT NOT NULL DEFAULT 0,
- `level` INT NOT NULL DEFAULT 1,
- `vocation` INT NOT NULL DEFAULT 0,
- `health` INT NOT NULL DEFAULT 150,
- `healthmax` INT NOT NULL DEFAULT 150,
- `experience` BIGINT NOT NULL DEFAULT 0,
- `lookbody` INT NOT NULL DEFAULT 0,
- `lookfeet` INT NOT NULL DEFAULT 0,
- `lookhead` INT NOT NULL DEFAULT 0,
- `looklegs` INT NOT NULL DEFAULT 0,
- `looktype` INT NOT NULL DEFAULT 136,
- `lookaddons` INT NOT NULL DEFAULT 0,
- `maglevel` INT NOT NULL DEFAULT 0,
- `mana` INT NOT NULL DEFAULT 0,
- `manamax` INT NOT NULL DEFAULT 0,
- `manaspent` INT NOT NULL DEFAULT 0,
- `soul` INT UNSIGNED NOT NULL DEFAULT 0,
- `town_id` INT NOT NULL DEFAULT 0,
- `posx` INT NOT NULL DEFAULT 0,
- `posy` INT NOT NULL DEFAULT 0,
- `posz` INT NOT NULL DEFAULT 0,
- `conditions` BLOB NOT NULL,
- `cap` INT NOT NULL DEFAULT 0,
- `sex` INT NOT NULL DEFAULT 0,
- `lastlogin` BIGINT UNSIGNED NOT NULL DEFAULT 0,
- `lastip` INT UNSIGNED NOT NULL DEFAULT 0,
- `save` TINYINT(1) NOT NULL DEFAULT 1,
- `redskull` TINYINT(1) NOT NULL DEFAULT 0,
- `redskulltime` BIGINT NOT NULL DEFAULT 0,
- `skull` TINYINT(1) NOT NULL DEFAULT 0,
- `skulltime` BIGINT NOT NULL DEFAULT 0,
- `rank_id` INT NOT NULL DEFAULT 0,
- `guildnick` VARCHAR(255) NOT NULL DEFAULT '',
- `lastlogout` BIGINT UNSIGNED NOT NULL DEFAULT 0,
- `blessings` TINYINT(2) NOT NULL DEFAULT 0,
- `balance` BIGINT NOT NULL DEFAULT 0,
- `stamina` BIGINT NOT NULL DEFAULT 151200000 COMMENT 'stored in miliseconds',
- `direction` INT NOT NULL DEFAULT 2,
- `loss_experience` INT NOT NULL DEFAULT 100,
- `loss_mana` INT NOT NULL DEFAULT 100,
- `loss_skills` INT NOT NULL DEFAULT 100,
- `loss_containers` INT NOT NULL DEFAULT 100,
- `loss_items` INT NOT NULL DEFAULT 100,
- `premend` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER',
- `online` TINYINT(1) NOT NULL DEFAULT 0,
- `marriage` INT UNSIGNED NOT NULL DEFAULT 0,
- `promotion` INT NOT NULL DEFAULT 0,
- `deleted` TINYINT(1) NOT NULL DEFAULT FALSE,
- `description` VARCHAR(255) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`), UNIQUE (`name`, `deleted`),
- KEY (`account_id`), KEY (`group_id`),
- KEY (`online`), KEY (`deleted`),
- FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE
- ) ENGINE = InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement