# # Generation Time: February 14, 2002, 2:18 pm # Server version: 3.23.47 # PHP Version: 4.0.6 # -------------------------------------------------------- CREATE TABLE quotes ( id int(9) unsigned NOT NULL auto_increment, quote text NOT NULL, author varchar(150) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY id (id) ) TYPE=MyISAM; # # Test Data for `quotes` # INSERT INTO quotes VALUES (1,'This is the quote number 1 ','Author name here...'); INSERT INTO quotes VALUES (2,'This is the quote number 2 ','Author name here...'); INSERT INTO quotes VALUES (3,'This is the quote number 3 ','Author name here...'); INSERT INTO quotes VALUES (4,'This is the quote number 4 ','Author name here...'); INSERT INTO quotes VALUES (5,'This is the quote number 5 ','Author name here...'); CREATE TABLE quotes_meta ( id int(11) NOT NULL default '0', number_reached mediumint(9) NOT NULL default '0', date_modified mediumint(9) NOT NULL default '0', PRIMARY KEY (id), KEY id (id) ) TYPE=MyISAM; # # The real Data for `quotes_meta` # INSERT INTO quotes_meta VALUES (1,1,1);