Login   Register  
PHP Classes
elePHPant
Icontem

File: sample-data.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of marcelo entraigas  >  Simple DB  >  sample-data.sql  
File: sample-data.sql
Role: Auxiliary data
Content type: text/plain
Description: sample data
Class: Simple DB
Store and retrieve data from a MySQL database
 

Contents

Class file image Download 
CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(11) NOT NULL auto_increment,
  `username` varchar(20) default NULL,
  `password` varchar(20) default NULL,
  `user_type` enum('regular','admin') NOT NULL default 'regular',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=72 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`user_id`, `username`, `password`, `user_type`) VALUES
(10, 'dummy1', 'dummy001', 'regular'),
(11, 'dummy2', 'dummy002', 'regular'),
(12, 'dummy3', 'dummy003', 'regular'),
(20, 'tadd', 'tadd', 'admin'),
(30, 'alfonso', 'jiggerofgin', 'regular'),
(35, 'juan', 'drymartini', 'regular'),
(40, 'scott', 'scotchandsoda', 'admin'),
(50, 'admin-il', 'shalom', 'regular'),
(60, 'avi', 'avi', 'regular'),
(70, 'akiva', 'akiva', 'regular');