Let’s
consider a simple database schema with
a singe table as APPLABSUSER.
CREATE
TABLE `applabsuser` (
`USER_ID` int(11) NOT NULL default
'0',
`USER_NAME` varchar(255) NOT NULL
default '',
`USER_PASSWORD` varchar(255) NOT NULL
default '',
`USER_FIRST_NAME` varchar(255) default
NULL,
`USER_LAST_NAME` varchar(255) default
NULL,
`USER_EMAIL` varchar(255) default
NULL,
`USER_CREATION_DATE` date default
NULL,
`USER_MODIFICATION_DATE` date default
NULL,
PRIMARY KEY (`USER_ID`),
UNIQUE KEY `USER_NAME` (`USER_NAME`)
) ;
|
|
