drur9VtW

1CREATE TABLE IF NOT EXISTS `friends` (
2        `Id` int(10) NOT NULL AUTO_INCREMENT,
3        `providerid` int(10) NOT NULL AUTO_INCREMENT,
4        `requestid` int(10) NOT NULL AUTO_INCREMENT,
5        `status` binary(1) NOT NULL,
6        PRIMARY KEY (`Id`))
7
8    CREATE TABLE IF NOT EXISTS `messages` (
9        `Id` int(255) NOT NULL AUTO_INCREMENT,
10        `fromuid` int(255) NOT NULL,
11        `touid` int(255) NOT NULL,
12        `sentdt` datetime NOT NULL,
13        `read` tinyint(1) NOT NULL DEFAULT '0', 
14        `readdt` datetime DEFAULT NULL,
15        `messagetext` longtext CHARACTER SET utf8 NOT NULL,
16        PRIMARY KEY (`Id`),
17    )
18
19
20    CREATE TABLE IF NOT EXISTS `users` ( 
21        `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
22        `username` varchar(45) NOT NULL DEFAULT '',
23        `password` varchar(32) NOT NULL DEFAULT '',
24        `email` varchar(45) NOT NULL DEFUALT '',
25        `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
26        `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
27        `authenticationTime` datetime NOT DEFAULT DEFAULT '0000-00-00 00:00:00',
28        `userKey` varchar(32) NOT NULL DEFAULT '',
29        `IP` varchar(45) NOT NULL DEFAULT '',
30        `port` int(10) unsigned NOT NULL DEFAULT '0',
31        PRIMARY KEY (`Id`),
32
33)
34	
35CREATE TABLE IF NOT EXISTS `friends` (
36    `Id` int(10) NOT NULL AUTO_INCREMENT,
37    `providerid` int(10) NOT NULL ,
38    `requestid` int(10) NOT NULL ,
39    `status` binary(1) NOT NULL ,
40    PRIMARY KEY (`Id`));
41
42CREATE TABLE IF NOT EXISTS `messages` (
43    `Id` int(255) NOT NULL AUTO_INCREMENT,
44    `fromuid` int(255) NOT NULL,
45    `touid` int(255) NOT NULL,
46    `sentdt` datetime NOT NULL,
47    `read` tinyint(1) NOT NULL DEFAULT '0', 
48    `readdt` datetime DEFAULT NULL,
49    `messagetext` longtext CHARACTER SET utf8 NOT NULL ,
50    PRIMARY KEY (`Id`)
51);
52
53
54CREATE TABLE IF NOT EXISTS `users` ( 
55    `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
56    `username` varchar(45) NOT NULL DEFAULT '',
57    `password` varchar(32) NOT NULL DEFAULT '',
58    `email` varchar(45) NOT NULL DEFAULT '',
59    `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
60    `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
61    `authenticationTime` datetime NOT NULL  DEFAULT CURRENT_TIMESTAMP,
62    `userKey` varchar(32) NOT NULL DEFAULT '',
63    `IP` varchar(45) NOT NULL DEFAULT '',
64    `port` int(10) unsigned NOT NULL DEFAULT '0',
65    PRIMARY KEY (`Id`)
66)