9XA4Xpn1

1SET NAMES utf8;
2SET time_zone = '+00:00';
3SET foreign_key_checks = 0;
4SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
5
6DROP TABLE IF EXISTS `Puffles`;
7CREATE TABLE `Puffles` (
8  `ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Puffle ID',
9  `Owner` int(11) unsigned NOT NULL COMMENT 'Owner''s player ID',
10  `Name` tinytext NOT NULL COMMENT 'Puffle name',
11  `Type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Puffle type',
12  `Hunger` tinyint(3) unsigned NOT NULL DEFAULT '100' COMMENT 'Puffle''s hunger status',
13  `Health` tinyint(3) unsigned NOT NULL DEFAULT '100' COMMENT 'Puffle''s health status',
14  `Rest` tinyint(3) unsigned NOT NULL DEFAULT '100' COMMENT 'Puffle''s rest status',
15  `Walking` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Puffle''s walking status',
16  PRIMARY KEY (`ID`)
17) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Contains data regarding user puffles';
18
19
20DROP TABLE IF EXISTS `Stats`;
21CREATE TABLE `Stats` (
22  `ID` tinyint(3) unsigned NOT NULL COMMENT 'Server ID',
23  `Population` smallint(5) unsigned NOT NULL COMMENT 'Server''s Population',
24  PRIMARY KEY (`ID`)
25) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Server statistics';
26
27
28DROP TABLE IF EXISTS `users`;
29CREATE TABLE `users` (
30  `ID` int(10) NOT NULL AUTO_INCREMENT,
31  `Username` char(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'Nickname',
32  `Password` varchar(255) NOT NULL COMMENT 'Password hash',
33  `Email` char(128) NOT NULL,
34  `RegisteredTime` int(11) NOT NULL COMMENT 'Unix timestamp',
35  `LoginKey` char(40) DEFAULT '' COMMENT 'Used for logging into the game server',
36  `Active` tinyint(1) unsigned NOT NULL DEFAULT '1',
37  `Status` varchar(240) NOT NULL DEFAULT '' COMMENT 'Contains the player''s online status',
38  `Coins` int(10) unsigned NOT NULL DEFAULT '10000' COMMENT 'Player coins',
39  `Color` varchar(12) NOT NULL DEFAULT '1' COMMENT 'Current color item',
40  `Head` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Current head item',
41  `Face` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Current face item',
42  `Neck` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Current neck item',
43  `Body` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Current body item',
44  `Hand` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Current hand item',
45  `Feet` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Current feet item',
46  `Photo` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Current photo item',
47  `Buddies` varchar(240) NOT NULL DEFAULT '' COMMENT 'Player buddies',
48  `Flag` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Current flag item',
49  `Ignores` varchar(240) NOT NULL DEFAULT '' COMMENT 'Player''s ignored list',
50  `Inventory` varchar(240) DEFAULT '' COMMENT 'Player inventory',
51  `Igloo` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT 'Current igloo ID',
52  `Igloos` varchar(240) NOT NULL DEFAULT '' COMMENT 'Player''s owned igloos',
53  `Music` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT 'Current music ID',
54  `Floor` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Current flooring ID',
55  `RoomFurniture` varchar(240) NOT NULL DEFAULT '' COMMENT 'Igloo furniture',
56  `Furniture` varchar(240) NOT NULL DEFAULT '' COMMENT 'Furniture inventory',
57  `Postcards` varchar(240) NOT NULL DEFAULT '''0''' COMMENT 'Player postcards',
58  `Title` varchar(240) NOT NULL DEFAULT '''0''',
59  `Nameglow` varchar(240) NOT NULL DEFAULT '''0''',
60  `Namecolor` varchar(240) NOT NULL DEFAULT '''0''',
61  `Text` varchar(240) NOT NULL DEFAULT '''0''',
62  `Bubblecolor` varchar(240) NOT NULL DEFAULT '''0''',
63  `Penguinglow` varchar(240) NOT NULL DEFAULT '''0''',
64  `Snowballglow` varchar(240) NOT NULL DEFAULT '''0''',
65  `Ringcolor` varchar(240) NOT NULL DEFAULT '''0''',
66  `Chatglow` varchar(240) NOT NULL DEFAULT '''0''',
67  `Moodcolor` varchar(240) NOT NULL DEFAULT '''0''',
68  `Moodglow` varchar(240) NOT NULL DEFAULT '''0''',
69  `Speed` int(3) NOT NULL DEFAULT '4',
70  `Mood` char(100) NOT NULL DEFAULT 'I have a mood',
71  `Size` int(3) NOT NULL DEFAULT '100',
72  `Alpha` int(3) NOT NULL DEFAULT '100',
73  `Moderator` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Player''s moderator status',
74  `Rank` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Player''s rank (badge when multiplied by 146)',
75  `LastLogin` int(11) unsigned DEFAULT NULL COMMENT 'Unix timestamp',
76  PRIMARY KEY (`ID`),
77  UNIQUE KEY `Username` (`Username`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This is the table in which all player data is stored.';