jBkSTjVz

1SET FOREIGN_KEY_CHECKS=0;
2
3CREATE SCHEMA `S4League`;
4
5USE `S4League`;
6
7DROP TABLE IF EXISTS `accounts`;
8CREATE TABLE `accounts` (
9  `id` int(11) NOT NULL auto_increment,
10  `name` varchar(13) NOT NULL default '',
11  `password` varchar(128) NOT NULL default '',
12  `loggedin` tinyint(4) NOT NULL default '0',
13  `banned` tinyint(1) NOT NULL default '0',
14  `banreason` text,
15  `tempban` timestamp NOT NULL default '0000-00-00 00:00:00',
16  `gm` tinyint(1) NOT NULL default '0',
17  `tickets` int(11) default NULL,
18  `coins` int(11) default NULL,
19  `alapoints` int(11) default NULL,
20  `pen` int(11) default NULL,
21  PRIMARY KEY  (`id`),
22  UNIQUE KEY `name` (`name`)
23) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=latin1;
24
25DROP TABLE IF EXISTS `characters`;
26CREATE TABLE `characters` (
27  `characterid` int(11) NOT NULL auto_increment,
28  `accountid` int(11) NOT NULL default '0',
29  `name` varchar(13) NOT NULL default '',
30  `level` int(11) NOT NULL default '0',
31  `exp` int(11) NOT NULL default '0',
32  `gender` int(11) NOT NULL default '0',
33  PRIMARY KEY  (`characterid`),
34  KEY `accountid` (`accountid`)
35) ENGINE=InnoDB AUTO_INCREMENT=30417 DEFAULT CHARSET=latin1;
36
37DROP TABLE IF EXISTS `servers`;
38CREATE TABLE `servers` (
39  `serverid` int(10) unsigned NOT NULL auto_increment,
40  `servername` varchar(13) NOT NULL default '',
41  `maxusers` tinyint(1) NOT NULL default '0',
42  PRIMARY KEY  (`serverid`)
43) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
44
45DROP TABLE IF EXISTS `channels`;
46CREATE TABLE `channels` (
47  `serverid` tinyint(1) NOT NULL default '0',
48  `channelid` int(10) unsigned NOT NULL auto_increment,
49  `channelname` varchar(13) NOT NULL default '',
50  `channelminlevel` int(11) default NULL,
51  `channelmaxlevel` int(11) default NULL,
52  PRIMARY KEY  (`channelid`)
53) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
54
55DROP TABLE IF EXISTS `equipment`;
56CREATE TABLE `equipment` (
57  `characterid` int(10) unsigned NOT NULL default '0',
58  `equipmentid` int(10) unsigned NOT NULL auto_increment,
59  `useritemid` int(10) unsigned NOT NULL default '0',
60  PRIMARY KEY  (`equipmentid`),
61  KEY `useritemid` (`useritemid`)
62) ENGINE=InnoDB AUTO_INCREMENT=791601 DEFAULT CHARSET=latin1;
63
64DROP TABLE IF EXISTS `items`;
65CREATE TABLE `items` (
66  `useritemid` int(10) unsigned NOT NULL auto_increment,
67  `characterid` int(11) default NULL,
68  `itemid` int(11) NOT NULL default '0',
69  `itemtype` int(11) NOT NULL default '0',
70  `position` int(11) NOT NULL default '0',
71  `level` int(11) NOT NULL default '0',
72  `hp` int(11) NOT NULL default '0',
73  `sp` int(11) NOT NULL default '0',
74  `att` int(11) NOT NULL default '0',
75  `speed` int(11) NOT NULL default '0',
76  `movementspeed` int(11) NOT NULL default '0',
77  `def` int(11) NOT NULL default '0',
78  `chaserprobability` int(11) NOT NULL default '0',
79  PRIMARY KEY  (`useritemid`),
80  KEY `characterid` (`characterid`),
81  KEY `itemtype` (`itemtype`)
82) ENGINE=InnoDB AUTO_INCREMENT=2208418 DEFAULT CHARSET=latin1;
83
84DROP TABLE IF EXISTS `shopitems`;
85CREATE TABLE `shopitems` (
86  `shopitemid` int(10) unsigned NOT NULL auto_increment,
87  `itemid` int(11) NOT NULL default '0',
88  `price` int(11) NOT NULL default '0',
89  `position` int(11) NOT NULL default '0',
90  PRIMARY KEY  (`shopitemid`)
91) ENGINE=InnoDB AUTO_INCREMENT=993540 DEFAULT CHARSET=latin1;