DROP TABLE IF EXISTS `clf_members`;
CREATE TABLE IF NOT EXISTS `clf_members` (
`memid` int(11) NOT NULL auto_increment,
`fullname` varchar(45) default NULL,
`email` varchar(45) default NULL,
`password` varchar(45) default NULL,
`lastlogin` datetime default NULL,
`ip` varchar(15) NOT NULL default '0',
`code` varchar(35) NOT NULL default '0',
`verified` enum('0','1') NOT NULL default '0',
`enabled` enum('0','1') NOT NULL default '0',
`pass_change` tinyint(1) NULL default '0',
PRIMARY KEY (`memid`)
) TYPE=MyISAM AUTO_INCREMENT=0 ;
ALTER TABLE `clf_ads` ADD `memid` int(5) NULL AFTER `email`
ALTER TABLE `clf_events` ADD `memid` int(5) NULL AFTER `posteremail`
رد مع اقتباس
