Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
tree: 01fbad700e
Chris Coyier
25 lines (22 sloc) 0.861 kB
CREATE TABLE IF NOT EXISTS `chat_rooms` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`numofuser` int(10) NOT NULL,
`file` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
CREATE TABLE IF NOT EXISTS `chat_users` (
`id` tinyint(10) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`status` tinyint(1) NOT NULL,
`time_mod` int(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;
CREATE TABLE IF NOT EXISTS `chat_users_rooms` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`room` varchar(100) NOT NULL,
`mod_time` int(40) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1472 ;
Jump to Line
Something went wrong with that request. Please try again.