Index: trunk/admin/install/inportal_schema.sql =================================================================== diff -u -N -r3888 -r3895 --- trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 3888) +++ trunk/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 3895) @@ -387,34 +387,37 @@ # -------------------------------------------------------- -CREATE TABLE PortalUser ( +CREATE TABLE inp_PortalUser ( PortalUserId int(11) NOT NULL auto_increment, Login varchar(255) default NULL, - Password varchar(255) default NULL, + `Password` varchar(255) default NULL, FirstName varchar(255) default NULL, LastName varchar(255) default NULL, + Company varchar(255) NOT NULL default '', Email varchar(255) NOT NULL default '', CreatedOn double NOT NULL default '0', Phone varchar(20) default NULL, + Fax varchar(255) NOT NULL default '', Street varchar(255) default NULL, + Street2 varchar(255) NOT NULL default '', City varchar(20) default NULL, - State VARCHAR(20) NOT NULL, + State varchar(20) NOT NULL default '', Zip varchar(20) default NULL, Country varchar(20) NOT NULL default '', ResourceId int(11) NOT NULL default '0', - Status tinyint(4) NOT NULL default '2', + `Status` tinyint(4) NOT NULL default '2', Modified int(11) NOT NULL default '0', dob double NOT NULL default '0', tz int(11) default NULL, ip varchar(20) default NULL, IsBanned tinyint(1) NOT NULL default '0', - PassResetTime bigint(20), - PwResetConfirm varchar(255), - PwRequestTime bigint(25), - MinPwResetDelay int(11) NOT NULL default '1800', + PassResetTime bigint(20) default NULL, + PwResetConfirm varchar(255) default NULL, + PwRequestTime bigint(25) default NULL, + MinPwResetDelay int(11) NOT NULL default '1800', PRIMARY KEY (PortalUserId), - UNIQUE KEY Login (Login), UNIQUE KEY ResourceId (ResourceId), + UNIQUE KEY Login (Login), KEY CreatedOn (CreatedOn) )