view release on metacpan or  search on metacpan

doc/examples/petmarket/petmarket.sql  view on Meta::CPAN

INSERT INTO product VALUES ('FI-SW-02','FISH');
INSERT INTO product VALUES ('FI-FW-01','FISH');
INSERT INTO product VALUES ('K9-CW-01','DOGS');

--
-- Table structure for table 'product_details'
--

CREATE TABLE product_details (
  productid varchar(10) NOT NULL default '',
  locale varchar(10) NOT NULL default '',
  name varchar(80) NOT NULL default '',
  image varchar(255) default NULL,
  descn varchar(255) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'product_details'
--


INSERT INTO product_details VALUES ('K9-RT-01','en-US','Golden Retriever','dog1.gif','Great family dog');
INSERT INTO product_details VALUES ('K9-DL-01','en-US','Dalmation','dog5.gif','Great dog for a Fire Station');
INSERT INTO product_details VALUES ('FI-SW-01','en-US','Angelfish','fish1.jpg','Salt Water fish from Australia');
INSERT INTO product_details VALUES ('FI-FW-02','en-US','Goldfish','fish2.gif','Fresh Water fish from China');
INSERT INTO product_details VALUES ('K9-BD-01','en-US','Bulldog','dog2.gif','Friendly dog from England');
INSERT INTO product_details VALUES ('K9-PO-02','en-US','Poodle','dog6.gif','Cute dog from France');
INSERT INTO product_details VALUES ('FL-DLH-02','en-US','Persian','cat1.gif','Friendly house cat, doubles as a princess');
INSERT INTO product_details VALUES ('K9-RT-02','en-US','Labrador Retriever','dog5.gif','Great hunting dog');
INSERT INTO product_details VALUES ('AV-CB-01','en-US','Amazon Parrot','bird4.gif','Great companion for up to 75 years');
INSERT INTO product_details VALUES ('AV-SB-02','en-US','Finch','bird1.gif','Great stress reliever');
INSERT INTO product_details VALUES ('FL-DSH-01','en-US','Manx','cat3.gif','Great for reducing mouse populations');
INSERT INTO product_details VALUES ('RP-SN-01','en-US','Rattlesnake','lizard3.gif','Doubles as a watch dog');
INSERT INTO product_details VALUES ('RP-LI-02','en-US','Iguana','lizard2.gif','Friendly green friend');
INSERT INTO product_details VALUES ('FI-SW-02','en-US','Tiger Shark','fish4.gif','Salt Water fish from Australia');
INSERT INTO product_details VALUES ('FI-FW-01','en-US','Koi','fish3.gif','Fresh Water fish from Japan');
INSERT INTO product_details VALUES ('K9-CW-01','en-US','Chihuahua','dog4.gif','Great companion dog');

--
-- Table structure for table 'user_details'
--

CREATE TABLE user_details (
  email varchar(50) default NULL,
  password varchar(50) default NULL,
  firstname varchar(50) default NULL,
  lastname varchar(50) default NULL,
  homestreet1 varchar(50) default NULL,
  homestreet2 varchar(50) default NULL,
  homecity varchar(50) default NULL,
  homestate char(2) default NULL,
  homecountry varchar(50) default NULL,
  homezip varchar(10) default NULL,
  homephone varchar(20) default NULL,
  shippingstreet1 varchar(50) default NULL,
  shippingstreet2 varchar(50) default NULL,
  shippingcity varchar(50) default NULL,
  shippingcountry varchar(50) default NULL,
  shippingzip varchar(10) default NULL,
  shippingphone varchar(20) default NULL,
  creditcardnumber varchar(50) default NULL,
  creditcardtype varchar(50) default NULL,
  creditcardexpiry varchar(50) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'user_details'
--