CREATE TABLE `users` (
`USER_ID` smallint(6) NOT NULL auto_increment,
`STATUS` enum('SUSPENDED','OK') NOT NULL default 'OK',
`TYPE` enum('PMANAGER','STAFF') NOT NULL default 'STAFF',
`USERNAME` tinytext NOT NULL,
`PASSWORD` mediumtext NOT NULL,
`LANGUAGE` smallint(6) NOT NULL default '1',
`THEME_ID` smallint(6) NOT NULL default '1',
`FIRST_NAME` tinytext NOT NULL,
`LAST_NAME` tinytext NOT NULL,
`EMAIL` tinytext NOT NULL,
`PHONE` tinytext NOT NULL,
`BIRTHDAY` int(11) NOT NULL default '0',
`SECRET_QUESTION` text NOT NULL,
`REMINDER` text NOT NULL,
`LLOGIN_IP` tinytext NOT NULL,
`LLOGIN_TIME` int(11) NOT NULL default '0',
PRIMARY KEY (`USER_ID`)
) TYPE=MyISAM COMMENT='users' AUTO_INCREMENT=5 ;
INSERT INTO `users` (`USER_ID`, `STATUS`, `TYPE`, `USERNAME`, `PASSWORD`, `LANGUAGE`, `THEME_ID`, `FIRST_NAME`, `LAST_NAME`, `EMAIL`, `PHONE`, `BIRTHDAY`, `SECRET_QUESTION`, `REMINDER`, `LLOGIN_IP`, `LLOGIN_TIME`) VALUES (1, 'OK', 'PMANAGER', 'delivere', 'pword1', 1, 1, 'Name', 'LastName', 'xsdenied@phreaker.net', '212-586-2343', 417420000, '', '', '', 0);
INSERT INTO `users` (`USER_ID`, `STATUS`, `TYPE`, `USERNAME`, `PASSWORD`, `LANGUAGE`, `THEME_ID`, `FIRST_NAME`, `LAST_NAME`, `EMAIL`, `PHONE`, `BIRTHDAY`, `SECRET_QUESTION`, `REMINDER`, `LLOGIN_IP`, `LLOGIN_TIME`) VALUES (3, 'OK', 'STAFF', 'test1', 'pword2', 1, 1, 'Test_Staff_1', 'Test_Staff_1', 'xsdenied@phreaker.net', '212-588-3881', 416124000, '', '', '', 0);
INSERT INTO `users` (`USER_ID`, `STATUS`, `TYPE`, `USERNAME`, `PASSWORD`, `LANGUAGE`, `THEME_ID`, `FIRST_NAME`, `LAST_NAME`, `EMAIL`, `PHONE`, `BIRTHDAY`, `SECRET_QUESTION`, `REMINDER`, `LLOGIN_IP`, `LLOGIN_TIME`) VALUES (4, 'OK', 'STAFF', 'Test_Staff_Rookie', 'pword3', 1, 1, 'Test_Staff_Rookie', 'Test_Staff_Rookie', 'iozalp@falan.net', '212-876-0109', 416210400, '', '', '', 0);
|
Download
