Login   Register  
PHP Classes
elePHPant
Icontem

File: sqlscript.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ismet Ozalp  >  Mysql Database Functions  >  sqlscript.sql  >  Download  
File: sqlscript.sql
Role: Auxiliary data
Content type: text/plain
Description: sql script to test
Class: Mysql Database Functions
MySQL wrapper to access data and manipulate tables
Author: By
Last change:
Date: 2005-03-22 09:00
Size: 1,863 bytes
 

Contents

Class file image Download 
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);