patrick24601
04-12-04, 07:47 AM
I found this /* in the CVS dotproject.sql. This was preventing my entire database from getting created properly. Was this on purpose?
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_contact` int(11) NOT NULL default '0',
`user_username` varchar(255) NOT NULL default '',
`user_password` varchar(32) NOT NULL default '',
`user_parent` int(11) NOT NULL default '0',
`user_type` tinyint(3) not null default '0',
`user_company` int(11) default '0',
`user_department` int(11) default '0',
/* `user_first_name` varchar(50) default '',
`user_last_name` varchar(50) default '',
`user_email` varchar(255) default '',
`user_phone` varchar(30) default '',
`user_home_phone` varchar(30) default '',
`user_mobile` varchar(30) default '',
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_contact` int(11) NOT NULL default '0',
`user_username` varchar(255) NOT NULL default '',
`user_password` varchar(32) NOT NULL default '',
`user_parent` int(11) NOT NULL default '0',
`user_type` tinyint(3) not null default '0',
`user_company` int(11) default '0',
`user_department` int(11) default '0',
/* `user_first_name` varchar(50) default '',
`user_last_name` varchar(50) default '',
`user_email` varchar(255) default '',
`user_phone` varchar(30) default '',
`user_home_phone` varchar(30) default '',
`user_mobile` varchar(30) default '',