T1fGRMLr

1DROP TABLE IF EXISTS `users`;
2
3CREATE TABLE `users` (
4  `uid` int(6) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT 'User ID',
5  `age` bit(1) NOT NULL COMMENT 'user age',
6  `sex` bit(1) NOT NULL COMMENT 'user sex',
7  `channel` varchar(30) DEFAULT '0' COMMENT 'chennel id',
8  `pass` int(6) NOT NULL COMMENT 'password',
9  `date` date NOT NULL COMMENT 'Last Seen Date',
10  `credit` tinyint(2) COMMENT 'Credit for Subscribtion',
11  PRIMARY KEY(`uid`),
12  INDEX `ids`(`uid`, `channel`),
13  INDEX `search`(`age`, `sex`)
14)
15ENGINE=INNODB
16COMMENT = 'Registered users data'
17CHARACTER SET latin1 ;
18
19DROP TABLE IF EXISTS `conference`;
20
21CREATE TABLE `conference` (
22  `uid` int(6) UNSIGNED ZEROFILL NOT NULL,
23  `confno` int(6) UNSIGNED ZEROFILL NOT NULL,
24  `status` tinyint(1) UNSIGNED NOT NULL,
25  PRIMARY KEY(`uid`, `confno`, `status`),
26  CONSTRAINT `userid` FOREIGN KEY (`uid`)
27    REFERENCES `users`(`uid`)
28    ON DELETE CASCADE
29    ON UPDATE CASCADE
30)
31ENGINE=INNODB
32COMMENT = 'MeetMe conference rooms';