# Dump for Database list

CREATE DATABASE list;

USE list;

# Dumping Table items

CREATE TABLE items (
	thing varchar(64)   , 
	id tinyint(1) NOT NULL  auto_increment, 
	rank tinyint(1) NOT NULL  , 
	url varchar(128)    ,
	PRIMARY KEY (id)	
) TYPE=;

# Dumping Data - 4 rows
INSERT INTO items VALUES("truck",2,0,"http://chevy.com");
INSERT INTO items VALUES("pliers",3,8,"http://www.hooverfence.com/tools/fence_tools.htm");
INSERT INTO items VALUES("towel",5,1,"http://www.sears.com");
INSERT INTO items VALUES("donut",6,2,"http://www.dunkindonuts.com");
