Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS players;
- CREATE TABLE players (
- id INTEGER PRIMARY KEY
- NOT NULL,
- name VARCHAR( 255 ) NOT NULL,
- world_id INTEGER NOT NULL
- DEFAULT '0',
- group_id INTEGER NOT NULL
- DEFAULT '1',
- account_id INTEGER NOT NULL,
- level INTEGER NOT NULL
- DEFAULT '1',
- vocation INTEGER NOT NULL
- DEFAULT '0',
- health INTEGER NOT NULL
- DEFAULT '100',
- healthmax INTEGER NOT NULL
- DEFAULT '100',
- experience INTEGER NOT NULL
- DEFAULT '0',
- lookbody INTEGER NOT NULL
- DEFAULT '10',
- lookfeet INTEGER NOT NULL
- DEFAULT '10',
- lookhead INTEGER NOT NULL
- DEFAULT '10',
- looklegs INTEGER NOT NULL
- DEFAULT '10',
- looktype INTEGER NOT NULL
- DEFAULT '136',
- lookaddons INTEGER NOT NULL
- DEFAULT '0',
- lookmount INTEGER NOT NULL
- DEFAULT '0',
- maglevel INTEGER NOT NULL
- DEFAULT '0',
- mana INTEGER NOT NULL
- DEFAULT '100',
- manamax INTEGER NOT NULL
- DEFAULT '100',
- manaspent INTEGER NOT NULL
- DEFAULT '0',
- soul INTEGER NOT NULL
- DEFAULT '0',
- town_id INTEGER NOT NULL,
- posx INTEGER NOT NULL
- DEFAULT '32369',
- posy INTEGER NOT NULL
- DEFAULT '32241',
- posz INTEGER NOT NULL
- DEFAULT '7',
- conditions BLOB NOT NULL,
- cap INTEGER NOT NULL
- DEFAULT '0',
- sex INTEGER NOT NULL
- DEFAULT '0',
- lastlogin INTEGER NOT NULL
- DEFAULT '0',
- lastip INTEGER NOT NULL
- DEFAULT '0',
- save BOOLEAN NOT NULL
- DEFAULT 'TRUE',
- skull INTEGER NOT NULL
- DEFAULT '0',
- skulltime INTEGER NOT NULL
- DEFAULT '0',
- rank_id INTEGER NOT NULL,
- guildnick VARCHAR( 255 ) NOT NULL
- DEFAULT '''',
- lastlogout INTEGER NOT NULL
- DEFAULT '0',
- blessings INTEGER NOT NULL
- DEFAULT '0',
- pvp_blessing BOOLEAN NOT NULL
- DEFAULT 'FALSE',
- balance INTEGER NOT NULL
- DEFAULT '0',
- stamina INTEGER NOT NULL
- DEFAULT '151200000',
- direction INTEGER NOT NULL
- DEFAULT '2',
- loss_experience INTEGER NOT NULL
- DEFAULT '100',
- loss_mana INTEGER NOT NULL
- DEFAULT '100',
- loss_skills INTEGER NOT NULL
- DEFAULT '100',
- loss_containers INTEGER NOT NULL
- DEFAULT '100',
- loss_items INTEGER NOT NULL
- DEFAULT '100',
- premend INTEGER NOT NULL
- DEFAULT '0',
- online INTEGER NOT NULL
- DEFAULT '0',
- marriage INTEGER NOT NULL
- DEFAULT '0',
- promotion INTEGER NOT NULL
- DEFAULT '0',
- deleted INTEGER NOT NULL
- DEFAULT '0',
- description VARCHAR( 255 ) NOT NULL
- DEFAULT '''',
- comment TEXT NOT NULL,
- create_ip INT( 11 ) NOT NULL
- DEFAULT '0',
- create_date INT( 11 ) NOT NULL
- DEFAULT '0',
- hide_char INT( 11 ) NOT NULL
- DEFAULT '0',
- signature TEXT NOT NULL,
- offlinetraining_time SMALLINT UNSIGNED NOT NULL
- DEFAULT '43200',
- offlinetraining_skill INT NOT NULL
- DEFAULT '-1',
- cast TINYINT( 4 ) NOT NULL
- DEFAULT '0',
- castViewers INT( 11 ) NOT NULL
- DEFAULT '0',
- castDescription VARCHAR( 255 ) NOT NULL,
- created INT( 11 ) NOT NULL
- DEFAULT '0',
- nick_verify INT( 11 ) NOT NULL
- DEFAULT '0',
- old_name VARCHAR( 255 ) NOT NULL
- DEFAULT '',
- worldtransfer INT( 11 ) NOT NULL
- DEFAULT '0',
- show_outfit TINYINT( 4 ) NOT NULL
- DEFAULT '1',
- show_eq TINYINT( 4 ) NOT NULL
- DEFAULT '1',
- show_bars TINYINT( 4 ) NOT NULL
- DEFAULT '1',
- show_skills TINYINT( 4 ) NOT NULL
- DEFAULT '1',
- show_quests TINYINT( 4 ) NOT NULL
- DEFAULT '1',
- stars INT( 10 ) NOT NULL
- DEFAULT '0',
- ip VARCHAR( 17 ) NOT NULL
- DEFAULT '0',
- UNIQUE ( name, deleted ),
- FOREIGN KEY ( account_id ) REFERENCES accounts ( id )
- );
- INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement