· 8 years ago · Feb 22, 2018, 02:28 AM
1DROP TABLE IF EXISTS players;
2CREATE TABLE players (
3 id INTEGER PRIMARY KEY
4 NOT NULL,
5 name VARCHAR( 255 ) NOT NULL,
6 world_id INTEGER NOT NULL
7 DEFAULT '0',
8 group_id INTEGER NOT NULL
9 DEFAULT '1',
10 account_id INTEGER NOT NULL,
11 level INTEGER NOT NULL
12 DEFAULT '1',
13 vocation INTEGER NOT NULL
14 DEFAULT '0',
15 health INTEGER NOT NULL
16 DEFAULT '100',
17 healthmax INTEGER NOT NULL
18 DEFAULT '100',
19 experience INTEGER NOT NULL
20 DEFAULT '0',
21 lookbody INTEGER NOT NULL
22 DEFAULT '10',
23 lookfeet INTEGER NOT NULL
24 DEFAULT '10',
25 lookhead INTEGER NOT NULL
26 DEFAULT '10',
27 looklegs INTEGER NOT NULL
28 DEFAULT '10',
29 looktype INTEGER NOT NULL
30 DEFAULT '136',
31 lookaddons INTEGER NOT NULL
32 DEFAULT '0',
33 lookmount INTEGER NOT NULL
34 DEFAULT '0',
35 maglevel INTEGER NOT NULL
36 DEFAULT '0',
37 mana INTEGER NOT NULL
38 DEFAULT '100',
39 manamax INTEGER NOT NULL
40 DEFAULT '100',
41 manaspent INTEGER NOT NULL
42 DEFAULT '0',
43 soul INTEGER NOT NULL
44 DEFAULT '0',
45 town_id INTEGER NOT NULL,
46 posx INTEGER NOT NULL
47 DEFAULT '32369',
48 posy INTEGER NOT NULL
49 DEFAULT '32241',
50 posz INTEGER NOT NULL
51 DEFAULT '7',
52 conditions BLOB NOT NULL,
53 cap INTEGER NOT NULL
54 DEFAULT '0',
55 sex INTEGER NOT NULL
56 DEFAULT '0',
57 lastlogin INTEGER NOT NULL
58 DEFAULT '0',
59 lastip INTEGER NOT NULL
60 DEFAULT '0',
61 save BOOLEAN NOT NULL
62 DEFAULT 'TRUE',
63 skull INTEGER NOT NULL
64 DEFAULT '0',
65 skulltime INTEGER NOT NULL
66 DEFAULT '0',
67 rank_id INTEGER NOT NULL,
68 guildnick VARCHAR( 255 ) NOT NULL
69 DEFAULT '''',
70 lastlogout INTEGER NOT NULL
71 DEFAULT '0',
72 blessings INTEGER NOT NULL
73 DEFAULT '0',
74 pvp_blessing BOOLEAN NOT NULL
75 DEFAULT 'FALSE',
76 balance INTEGER NOT NULL
77 DEFAULT '0',
78 stamina INTEGER NOT NULL
79 DEFAULT '151200000',
80 direction INTEGER NOT NULL
81 DEFAULT '2',
82 loss_experience INTEGER NOT NULL
83 DEFAULT '100',
84 loss_mana INTEGER NOT NULL
85 DEFAULT '100',
86 loss_skills INTEGER NOT NULL
87 DEFAULT '100',
88 loss_containers INTEGER NOT NULL
89 DEFAULT '100',
90 loss_items INTEGER NOT NULL
91 DEFAULT '100',
92 premend INTEGER NOT NULL
93 DEFAULT '0',
94 online INTEGER NOT NULL
95 DEFAULT '0',
96 marriage INTEGER NOT NULL
97 DEFAULT '0',
98 promotion INTEGER NOT NULL
99 DEFAULT '0',
100 deleted INTEGER NOT NULL
101 DEFAULT '0',
102 description VARCHAR( 255 ) NOT NULL
103 DEFAULT '''',
104 comment TEXT NOT NULL,
105 create_ip INT( 11 ) NOT NULL
106 DEFAULT '0',
107 create_date INT( 11 ) NOT NULL
108 DEFAULT '0',
109 hide_char INT( 11 ) NOT NULL
110 DEFAULT '0',
111 signature TEXT NOT NULL,
112 offlinetraining_time SMALLINT UNSIGNED NOT NULL
113 DEFAULT '43200',
114 offlinetraining_skill INT NOT NULL
115 DEFAULT '-1',
116 cast TINYINT( 4 ) NOT NULL
117 DEFAULT '0',
118 castViewers INT( 11 ) NOT NULL
119 DEFAULT '0',
120 castDescription VARCHAR( 255 ) NOT NULL,
121 created INT( 11 ) NOT NULL
122 DEFAULT '0',
123 nick_verify INT( 11 ) NOT NULL
124 DEFAULT '0',
125 old_name VARCHAR( 255 ) NOT NULL
126 DEFAULT '',
127 worldtransfer INT( 11 ) NOT NULL
128 DEFAULT '0',
129 show_outfit TINYINT( 4 ) NOT NULL
130 DEFAULT '1',
131 show_eq TINYINT( 4 ) NOT NULL
132 DEFAULT '1',
133 show_bars TINYINT( 4 ) NOT NULL
134 DEFAULT '1',
135 show_skills TINYINT( 4 ) NOT NULL
136 DEFAULT '1',
137 show_quests TINYINT( 4 ) NOT NULL
138 DEFAULT '1',
139 stars INT( 10 ) NOT NULL
140 DEFAULT '0',
141 ip VARCHAR( 17 ) NOT NULL
142 DEFAULT '0',
143 UNIQUE ( name, deleted ),
144 FOREIGN KEY ( account_id ) REFERENCES accounts ( id )
145);
146INSERT 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);