Login   Register  
PHP Classes
elePHPant
Icontem

File: mydatabase.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Carlos Miguel Guevara  >  classListbox  >  mydatabase.sql  >  Download  
File: mydatabase.sql
Role: Auxiliary data
Content type: text/plain
Description: the database for the example
Class: classListbox
Generate form select inputs from database queries
Author: By
Last change:
Date: 8 years ago
Size: 2,006 bytes
 

Contents

Class file image Download
-- 
-- Table structure for table `catalog`
-- 

CREATE TABLE `catalog` (
  `rowId` tinyint(4) NOT NULL auto_increment,
  `catalog` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`rowId`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `catalog`
-- 

INSERT INTO `catalog` VALUES (1, 'fruits');
INSERT INTO `catalog` VALUES (2, 'vehicles');
INSERT INTO `catalog` VALUES (3, 'names');
INSERT INTO `catalog` VALUES (4, 'countries');

-- --------------------------------------------------------

-- 
-- Table structure for table `inventory`
-- 

CREATE TABLE `inventory` (
  `productId` tinyint(4) NOT NULL auto_increment,
  `catalogId` tinyint(4) NOT NULL default '0',
  `product` varchar(20) NOT NULL default '',
  `decription` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`productId`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;

-- 
-- Dumping data for table `inventory`
-- 

INSERT INTO `inventory` VALUES (1, 1, 'banana', 'yellow fruit');
INSERT INTO `inventory` VALUES (2, 1, 'apple', 'red fruit');
INSERT INTO `inventory` VALUES (3, 1, 'orange', 'delicious fruit');
INSERT INTO `inventory` VALUES (4, 1, 'watermelon', 'my favorite fruit');
INSERT INTO `inventory` VALUES (5, 2, 'car', 'I have a car');
INSERT INTO `inventory` VALUES (6, 2, 'bus', 'a large car');
INSERT INTO `inventory` VALUES (7, 2, 'airplane', 'my private airplane');
INSERT INTO `inventory` VALUES (8, 2, 'motorcycle', 'i dont like this');
INSERT INTO `inventory` VALUES (9, 3, 'cesar', 'my friend');
INSERT INTO `inventory` VALUES (10, 3, 'edward', 'my ugly friend');
INSERT INTO `inventory` VALUES (11, 2, 'Luis', 'cesar''s brother');
INSERT INTO `inventory` VALUES (12, 2, 'tamika', 'my dog');
INSERT INTO `inventory` VALUES (13, 4, 'Mexico', 'I live here');
INSERT INTO `inventory` VALUES (14, 4, 'Chile', 'a nice place');
INSERT INTO `inventory` VALUES (15, 4, 'Germany', 'I like this place');
INSERT INTO `inventory` VALUES (16, 4, 'Brazil', 'the best asses');