85639Fyp

1
2CREATE TABLE IF NOT EXISTS `characters` (
3  `ID` int(11) NOT NULL AUTO_INCREMENT,
4  `username` varchar(20) NOT NULL,
5  `password` varchar(20) NOT NULL,
6  `absX` int(5) NOT NULL DEFAULT '3090',
7  `absY` int(5) NOT NULL DEFAULT '3490',
8  `heightLevel` int(10) NOT NULL DEFAULT '0',
9  `hitpoints` int(10) NOT NULL DEFAULT '10',
10  `specialAmount` int(11) NOT NULL DEFAULT '100',
11  `poisonDelay` int(11) NOT NULL DEFAULT '-1',
12  `skullTimer` int(11) NOT NULL DEFAULT '-1',
13  `pkPoints` int(11) NOT NULL DEFAULT '0',
14  `energy` int(11) NOT NULL DEFAULT '100',
15  `ancients` tinyint(1) NOT NULL DEFAULT '1',
16  `playerIsMember` tinyint(1) NOT NULL DEFAULT '1',
17  `dharokDamage` int(11) NOT NULL DEFAULT '0',
18  `spellBook` int(11) NOT NULL DEFAULT '1',
19  `appearanceSet` tinyint(1) NOT NULL DEFAULT '0',
20  `rights` int(1) NOT NULL DEFAULT '0',
21  `ip` varchar(100) NOT NULL DEFAULT 'Not Logged In',
22  `splitChat` tinyint(1) NOT NULL DEFAULT '0',
23  `autoRetaliate` tinyint(1) NOT NULL DEFAULT '0',
24  `combatmode` int(1) NOT NULL DEFAULT '0',
25  `lastmeleemode` tinyint(1) NOT NULL DEFAULT '0',
26  `lastrangemode` tinyint(1) NOT NULL DEFAULT '0',
27  `starter` tinyint(1) NOT NULL DEFAULT '0',
28  `online` tinyint(1) NOT NULL DEFAULT '0',
29  `running` tinyint(1) NOT NULL DEFAULT '0',
30  `poisonDamage` tinyint(1) NOT NULL DEFAULT '-1',
31  `slayerTask` int(11) NOT NULL DEFAULT '-1',
32  `slayerTaskAmount` int(11) NOT NULL DEFAULT '-1',
33  `loyaltyRank` int(11) NOT NULL DEFAULT '0',
34  `slayerMaster` int(11) NOT NULL DEFAULT '0',
35  `prayerBook` tinyint(1) NOT NULL DEFAULT '0',
36  `familiarId` int(11) NOT NULL DEFAULT '0',
37  `musicLevel` int(11) NOT NULL DEFAULT '4',
38  `pvpHelms` int(11) NOT NULL DEFAULT '500',
39  `pvpChests` int(11) NOT NULL DEFAULT '500',
40  `pvpLegs` int(11) NOT NULL DEFAULT '500',
41  `pvpWeapons` int(11) NOT NULL DEFAULT '500',
42  `email` varchar(50) DEFAULT NULL,
43  PRIMARY KEY (`ID`)
44) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=345349 ;