|
I just need the user sql table. It's almost working but it's asking for a timezone. I'm using this user dump, which is probably taylored for vbulletin integration with reviewpost.
CREATE TABLE `user` (
`userid` int(25) NOT NULL auto_increment,
`usergroupid` int(5) NOT NULL default '0',
`username` varchar(30) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`email` varchar(75) NOT NULL default '',
`homepage` varchar(100) default NULL,
`icq` varchar(50) default NULL,
`aim` varchar(30) default NULL,
`yahoo` varchar(30) default NULL,
`joindate` int(25) NOT NULL default '0',
`posts` int(20) NOT NULL default '0',
`birthday` date NOT NULL default '0000-00-00',
`ipaddress` varchar(18) default NULL,
`location` varchar(100) default NULL,
`interests` varchar(250) default NULL,
`occupation` varchar(250) default NULL,
`bio` varchar(250) default NULL,
`site` varchar(30) default NULL,
`offset` smallint(2) unsigned NOT NULL default '0',
`views` int(10) NOT NULL default '0',
`timezoneoffset ` varchar(36) NOT NULL default '',
PRIMARY KEY (`userid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
|