PHP Classes

File: sample-data.sql

Recommend this page to a friend!
  Classes of marcelo entraigas   Simple DB   sample-data.sql   Download  
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
Author: By
Last change: made it accessible w/o login
Date: 14 years ago
Size: 869 bytes


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');