forked from DarkstarProject/darkstar
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathchars.sql
51 lines (50 loc) · 1.69 KB
/
chars.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
/*
MySQL Data Transfer
Source Host: localhost
Source Database: dspdb
Target Host: localhost
Target Database: dspdb
Date: 2/11/2013 11:16:49 PM
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for chars
-- ----------------------------
DROP TABLE IF EXISTS `chars`;
CREATE TABLE `chars` (
`charid` int(10) unsigned NOT NULL,
`accid` int(10) unsigned NOT NULL,
`charname` varchar(15) NOT NULL,
`nation` tinyint(1) unsigned NOT NULL DEFAULT '0',
`pos_zone` smallint(3) unsigned NOT NULL,
`pos_prevzone` smallint(3) unsigned NOT NULL DEFAULT '0',
`pos_rot` tinyint(3) unsigned NOT NULL DEFAULT '0',
`pos_x` float(7,3) NOT NULL DEFAULT '0.000',
`pos_y` float(7,3) NOT NULL DEFAULT '0.000',
`pos_z` float(7,3) NOT NULL DEFAULT '0.000',
`boundary` smallint(5) unsigned NOT NULL DEFAULT '0',
`home_zone` tinyint(3) unsigned NOT NULL DEFAULT '0',
`home_rot` tinyint(3) unsigned NOT NULL DEFAULT '0',
`home_x` float(7,3) NOT NULL DEFAULT '0.000',
`home_y` float(7,3) NOT NULL DEFAULT '0.000',
`home_z` float(7,3) NOT NULL DEFAULT '0.000',
`missions` blob,
`assault` blob,
`campaign` blob,
`quests` blob,
`keyitems` blob,
`set_blue_spells` blob,
`abilities` blob,
`weaponskills` blob,
`titles` blob,
`zones` blob,
`playtime` int(10) unsigned NOT NULL DEFAULT '0',
`unlocked_weapons` blob,
`gmlevel` smallint(3) unsigned NOT NULL DEFAULT '0',
`isnewplayer` smallint(3) NOT NULL DEFAULT '1',
`mentor` smallint(3) NOT NULL DEFAULT '0',
`campaign_allegiance` tinyint(1) unsigned NOT NULL DEFAULT '0',
`isstylelocked` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`charid`),
FULLTEXT KEY `charname` (`charname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;