6M4LX5DJ

1
2
3CREATE DATABASE IF NOT EXISTS opencp;
4
5SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
6
7
8
9CREATE TABLE IF NOT EXISTS `pe_users` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `username` varchar(20) NOT NULL,
12  `nickname` varchar(20) NOT NULL,
13  `email` varchar(999) NOT NULL,
14  `password` varchar(999) NOT NULL,
15  `active` int(1) NOT NULL DEFAULT '0',
16  `ubdate` varchar(255) NOT NULL,
17  `items` longblob NOT NULL,
18  `stamps` longblob NOT NULL,
19  `curhead` varchar(10) NOT NULL DEFAULT '0',
20  `curface` varchar(10) NOT NULL DEFAULT '0',
21  `curneck` varchar(10) NOT NULL DEFAULT '0',
22  `curbody` varchar(10) NOT NULL DEFAULT '0',
23  `curhands` varchar(10) NOT NULL DEFAULT '0',
24  `curfeet` varchar(10) NOT NULL DEFAULT '0',
25  `curphoto` varchar(10) NOT NULL DEFAULT '0',
26  `curflag` varchar(10) NOT NULL DEFAULT '0',
27  `colour` varchar(10) NOT NULL DEFAULT '1',
28  `buddies` longtext NOT NULL,
29  `ignore` longtext NOT NULL,
30  `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
31  `lkey` varchar(50) NOT NULL,
32  `coins` int(11) NOT NULL,
33  `ismoderator` int(11) NOT NULL,
34  `rank` int(11) NOT NULL DEFAULT '1',
35  `ips` longtext,
36  `igloo` int(11) NOT NULL default '1',
37  `floor` int(11) NOT NULL default '0',
38  `furniture` longtext NOT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=MyISAM  DEFAULT CHARSET=latin1;