PHP Classes

File: sampledata.sql

Recommend this page to a friend!
  Classes of Alexander Selifonov   Report generating and drawing   sampledata.sql   Download  
File: sampledata.sql
Role: Auxiliary data
Content type: text/plain
Description: MySql script for creating sample data tables
Class: Report generating and drawing
Generate reports from database query results
Author: By
Last change:
Date: 15 years ago
Size: 2,332 bytes
 

Contents

Class file image Download
CREATE TABLE animal_categories ( categoryid INT(10) not null auto_increment, categoryname VARCHAR(32) default '', primary key(categoryid)); INSERT INTO animal_categories VALUES(1,'Sea animals'); INSERT INTO animal_categories VALUES(2,'Jungle animals'); CREATE TABLE animals ( animalid INT(10) not null auto_increment, category INT(10) not null default 0, animalname VARCHAR(32) default '', primary key(animalid)); INSERT INTO animals VALUES(1,1,'whales'); INSERT INTO animals VALUES(2,1,'sharks'); INSERT INTO animals VALUES(3,1,'dolphins'); INSERT INTO animals VALUES(4,2,'elephants'); INSERT INTO animals VALUES(5,2,'gorillas'); CREATE TABLE big_zoo ( itemid INT(10) not null auto_increment, animalid INT(10) not null default 0, nickname VARCHAR(32) default '', birth DATE, gender CHAR(1) default 'm', weight INT(6) default 0, primary key(itemid)); /*whales */ INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(1,'Whale-Boy','1997-06-22','m',7000); INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(1,'Whale-Girl','2000-08-01','f',6500); /* sharks */ INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(2,'BloodyJaws','2001-09-15','m',1500); INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(2,'HungryMary','2002-11-10','f',1200); /* dolphins */ INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(3,'BigBob','1996-01-12','m',3500); INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(3,'BigMartha','1998-05-20','f',3000); /* elephants */ INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(4,'LazyTom','2004-10-23','m',5000); INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(4,'MightyJack','2003-06-16','m',5300); INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(4,'Samantha-Shy','2004-04-24','f',4200); /* gorillas */ INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(5,'Gorilla-Dad','2000-02-05','m',180); INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(5,'Gorilla-Mom','2001-08-23','f',150); INSERT INTO big_zoo (animalid,nickname,birth,gender,weight) VALUES(5,'Gorilla-Son','2008-04-15','m',40);