PHP Classes

File: example.sql

Recommend this page to a friend!
  Classes of Cesar D. Rodas  >  CRUD Class  >  example.sql  >  Download  
File: example.sql
Role: Auxiliary data
Content type: text/plain
Description: Example database
Class: CRUD Class
Generate pages to list and edit database records
Author: By
Last change:
Date: 14 years ago
Size: 728 bytes
 

Contents

Class file image Download
CREATE TABLE `table_1` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, `sex` enum('male','female') NOT NULL, `country` int(11) NOT NULL, `age` int(3) NOT NULL, `email` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM ; INSERT INTO `table_1` VALUES (1, 'cesar rodas', 'male', 2, 5, 'saddor@foo.com'); CREATE TABLE `table_2` ( `countryId` int(11) NOT NULL auto_increment, `countryName` varchar(50) NOT NULL, KEY `countryId` (`countryId`) ) ENGINE=MyISAM ; INSERT INTO `table_2` VALUES (1, 'Paraguay'); INSERT INTO `table_2` VALUES (2, 'Brazil'); INSERT INTO `table_2` VALUES (3, 'Argentina'); INSERT INTO `table_2` VALUES (4, 'Chile');