PHP Classes

File: example/sample-db/creation.sql

Recommend this page to a friend!
  Classes of Joseluis Laso  >  PHP Preemptive Cache  >  example/sample-db/creation.sql  >  Download  
File: example/sample-db/creation.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Preemptive Cache
Cache a limited amount of data records in memory
Author: By
Last change:
Date: 7 years ago
Size: 637 bytes
 

Contents

Class file image Download
CREATE TABLE `family` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `ratio` float DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `product` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `ratio` float DEFAULT NULL, `family_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `data` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL, `cost` float DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;