uSDNZvDg

1CREATE TABLE IF NOT EXISTS `ms_members` (
2  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
3  `type` int(1) NOT NULL COMMENT 'req|select|array|customerTypes',
4  `email` varchar(64) NOT NULL COMMENT 'req|email|unique-email-members',
5  `password` varchar(32) NOT NULL COMMENT 'req|password',
6  `url` varchar(255) NOT NULL COMMENT 'nreq|str',
7  `facebook_url` varchar(255) NOT NULL COMMENT 'nreq|str',
8  `twitter_url` varchar(255) NOT NULL COMMENT 'nreq|str',
9  `linkedin_url` varchar(255) NOT NULL COMMENT 'nreq|str',
10  `date` datetime NOT NULL COMMENT 'req|datetime',
11  `status` int(1) NOT NULL COMMENT 'req|select|array|customerStatuses',
12  PRIMARY KEY (`id`),
13  KEY `email` (`email`),
14  KEY `date` (`date`),
15  KEY `status` (`status`),
16  KEY `type` (`type`)
17) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 ;