imported>Import: Imported current content

2026-01-28T11:54:25Z

Imported current content

New page

<pre>
# 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'
) TYPE<code>MyISAM COMMENT</code>'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>

PubWanBackup.2003-01-01 - Revision history

imported>Import: Imported current content