· 9 years ago · Jan 02, 2017, 11:08 AM
1
2CREATE TABLE IF NOT EXISTS `ms_members` (
3 `id` int(11) NOT NULL auto_increment,
4 `usr` varchar(32) NOT NULL DEFAULT '',
5 `pass` varchar(32) NOT NULL DEFAULT '',
6 `email` varchar(255) NOT NULL DEFAULT '',
7 `regIP` varchar(15) NOT NULL DEFAULT '',
8 `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
9 `visit` int(11) NOT NULL DEFAULT '0',
10 `privmsg` int(11) NOT NULL DEFAULT '0',
11 `posts` int(11) NOT NULL DEFAULT '0',
12 PRIMARY KEY (`id`),
13 UNIQUE KEY `usr` (`usr`),
14 UNIQUE KEY `email` (`email`),
15 KEY `visit` (`visit`)
16) ENGINE=MyISAM;