PubWanBackup.2003-01-01

# phpMyAdmin MySQL-Dump
# version 2.2.0
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: January 2, 2003, 7:43 am
# Server version: 3.23.40
# PHP Version: 4.1.2
# Database : `PubWan`
# --------------------------------------------------------

#
# Table structure for table `SandBox`
#

CREATE TABLE SandBox (
  who varchar(80) default NULL,
  what text,
  when timestamp(14) NOT NULL,
  where text,
  why text,
  how text,
  quantity int(11) NOT NULL default '1'
) TYPEMyISAM COMMENT'This is for playing with SQL';

#
# Dumping data for table `SandBox`
#

INSERT INTO SandBox VALUES ('JimScarver','Created SandBox table in PubWan',20021227074559,'Newark','Big fun.','myPhpAdmin',1);
INSERT INTO SandBox VALUES ('JimScarver','invites you to add rows (data), fields and do queries',20021227080050,'here in the PubWan database','to play and learn SQL','trial and error and reading the documentation available and maybe the SqlClassroom',1);
# --------------------------------------------------------

#
# Table structure for table `adjective`
#

CREATE TABLE adjective (
  key bigint(20) default NULL,
  adjective text
) TYPE=MyISAM;

#
# Dumping data for table `adjective`
#

INSERT INTO adjective VALUES (1,'clover
');
INSERT INTO adjective VALUES (2,'crunchy
');
INSERT INTO adjective VALUES (3,'dark
');
INSERT INTO adjective VALUES (4,'hot
');
INSERT INTO adjective VALUES (5,'natural
');
INSERT INTO adjective VALUES (6,'onion
');
INSERT INTO adjective VALUES (7,'pure
');
INSERT INTO adjective VALUES (8,'sage
');
INSERT INTO adjective VALUES (9,'toasted
');
INSERT INTO adjective VALUES (10,'wheat
');
# --------------------------------------------------------

#
# Table structure for table `brand`
#

CREATE TABLE brand (
  key bigint(20) default NULL,
  brand text
) TYPE=MyISAM;

#
# Dumping data for table `brand`
#

INSERT INTO brand VALUES (1,'Brownberry®
');
INSERT INTO brand VALUES (2,'Karo®
');
INSERT INTO brand VALUES (3,'Krema®
');
INSERT INTO brand VALUES (4,'Meijer®
');
INSERT INTO brand VALUES (5,'Quaker® Kretschmer®
');
INSERT INTO brand VALUES (6,'Ralston®
');
# --------------------------------------------------------

#
# Table structure for table `noun`
#

CREATE TABLE noun (
  key bigint(20) default NULL,
  noun text
) TYPE=MyISAM;

#
# Dumping data for table `noun`
#

INSERT INTO noun VALUES (1,'honey
');
INSERT INTO noun VALUES (2,'crouton
');
INSERT INTO noun VALUES (3,'cereal
');
INSERT INTO noun VALUES (4,'peanut butter
');
INSERT INTO noun VALUES (5,'wheat germ
');
INSERT INTO noun VALUES (6,'corn syrup
');
# --------------------------------------------------------

#
# Table structure for table `package`
#

CREATE TABLE package (
  key bigint(20) default NULL,
  system tinyint(4) default NULL,
  upc1 bigint(20) default NULL,
  upc2 bigint(20) default NULL,
  check tinyint(4) default NULL,
  brand bigint(20) default NULL,
  noun bigint(20) default NULL,
  net_mass float default NULL
) TYPE=MyISAM;

#
# Dumping data for table `package`
#

INSERT INTO package VALUES (1,,41250,96481,,4,1,'2.27');
INSERT INTO package VALUES (2,,73410,1671,8,1,2,'0.397');
INSERT INTO package VALUES (3,,91669,10045,2,6,3,'0.567');
INSERT INTO package VALUES (4,,79311,99,3,3,4,'0.453');
INSERT INTO package VALUES (5,,30000,2270,2,5,5,'0.567');
INSERT INTO package VALUES (6,,48001,5010,5,2,6,);
# --------------------------------------------------------

#
# Table structure for table `package_adjective`
#

CREATE TABLE package_adjective (
  key bigint(20) default NULL,
  package bigint(20) default NULL,
  adjective bigint(20) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `package_adjective`
#

INSERT INTO package_adjective VALUES (1,1,7);
INSERT INTO package_adjective VALUES (2,1,1);
INSERT INTO package_adjective VALUES (3,2,8);
INSERT INTO package_adjective VALUES (4,2,6);
INSERT INTO package_adjective VALUES (5,3,10);
INSERT INTO package_adjective VALUES (6,3,4);
INSERT INTO package_adjective VALUES (7,4,5);
INSERT INTO package_adjective VALUES (8,4,2);
INSERT INTO package_adjective VALUES (9,5,9);
INSERT INTO package_adjective VALUES (10,6,3);
</verbatim>