--
-- Host: localhost    Database: ralph_deuschle
-- ------------------------------------------------------


--
-- Table structure for table `Category`
--

CREATE TABLE `Category` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `protected` int(11) NOT NULL DEFAULT '0',
  `display` int(11) NOT NULL DEFAULT '0',
  `next` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `description` blob,
  `name` varchar(50) DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL,
  `old_id` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Dumping data for table `Category`
--

INSERT INTO `Category` VALUES (1,0,0,0,2,NULL,'Top Level',NULL,1),(2,0,1,3,0,'','Garden Art','',4),(3,0,1,4,0,NULL,'Coffee Table Art','',5),(4,0,1,5,0,NULL,'Public Sculpture, Corporate','Artist-At-Work+Scott.JPG',7),(5,0,1,0,0,NULL,'Fountains,Water Features','',8);

--
-- Table structure for table `Inventory`
--

CREATE TABLE `Inventory` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `categoryID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `categoryID` (`categoryID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Dumping data for table `Inventory`
--

INSERT INTO `Inventory` VALUES (1,1,2),(2,2,2),(3,3,2),(4,4,2),(5,5,2),(6,6,2),(7,7,2),(8,8,2),(44,9,2),(10,10,2),(11,11,2),(12,12,2),(13,13,2),(45,14,2),(15,15,3),(16,16,3),(17,17,3),(18,18,3),(19,19,3),(20,20,3),(46,21,3),(22,22,3),(23,23,3),(24,24,3),(25,25,3),(26,26,3),(27,27,3),(28,28,4),(29,29,4),(30,30,4),(31,31,5),(32,32,4),(33,33,4),(34,34,4),(35,35,4),(36,36,4),(37,37,4),(38,38,4),(39,39,4),(40,40,4),(41,41,4),(42,42,5),(43,43,5);

--
-- Table structure for table `Invoice`
--

CREATE TABLE `Invoice` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `purchasedby` int(11) NOT NULL DEFAULT '0',
  `deliverto` int(11) NOT NULL DEFAULT '0',
  `processed` int(11) NOT NULL DEFAULT '0',
  `shiptype` varchar(50) DEFAULT NULL,
  `shipcost` double(8,2) NOT NULL DEFAULT '0.00',
  `comment` tinyblob,
  `cart_total` double(8,2) DEFAULT NULL,
  `tax` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Dumping data for table `Invoice`
--


--
-- Table structure for table `Page`
--

CREATE TABLE `Page` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `body` blob,
  `template` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `featured` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `linkname` varchar(50) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Dumping data for table `Page`
--

INSERT INTO `Page` VALUES (1,'<CENTER>\"SERENDIPITY\"</CENTER><BR><CENTER>36\"H x 27\"W</CENTER><BR>Bronze Plated Steel, Clear Coated</CENTER><BR>12\"x12\" Travertine Marble Base (Outdoor)</CENTER><BR>36\" - $3450</CENTER><img src=null>',1,1,'',NULL,NULL,'','',NULL),(2,'Pleasing, teasing, zany geometric fantasies to delight the senses and challenge the eyes best describes Ralph\'s additions to the world of modern sculpture. A student of the works of Meadmore, Smith, Brancusi, Arp and others of the cubist sculpture period, his works are a 90\'s extention of this school of art. Ralph\'s goal is to do Escher moods in the three dimensions of sculpture. Early work is abstracts in oil and acrylics inspired his work in three dimensions. His work is potentially starting a new school of sculpture best described as post-modern cubic/geometric fantasies.\r\n<p>Says Ralph; \"Art should please, delight, refresh, entertain and enrich the viewer, maybe even be a bit playful.\"',1,1,'ArtistAt.GIF',NULL,NULL,'Artist\'s Statement','Artist\'s Statement',NULL),(3,'\"Loveland Sculpture Invitational\" Loveland CO Aug. 11-13, 2000,More information call 970/663-7467.  Sonoran Art League \"Hidden in the Hills Studio Tour\" Cave Creek AZ <BR>   Nov. 17-19, Nov. 24-26, 2000<BR>Maps to studios at the Carefree/Cavecreek CC office<BR> More information call 480.488.3381<BR><BR>Festival of Fine Arts at La Mirada<BR>  Jan. 8-9, Mar. 18-19<BR>Pima Rd at Pinnacle Peak Rd Pinnacle Peak AZ <BR>More information call 602.493.8920 \r\nCarefree Fine Art and Wine Fest<BR>  Jan. 21-23, Mar 4-6<BR>At the Carefree Sundial<BR>More information call 602.837.5637<BR><BR>Celebration of Fine Art<BR>Jan.13-Mar.26<BR>N Scottsdale Rd north of Bell Rd<BR>More information call 480.443.7695<BR><BR>(pending)Sausalito Art Festival 2001<BR>Saausalito, CA<BR>Sep.1-2<BR>www.sausalitoartfest.org<BR><BR>(pending)Laumeier Contemporary Art Fair<BR>May 11-13<BR>St. Louis, MO<BR>314 821 1209<BR><BR>(pending)The Park City Art Festival<BR>Park City, UT<BR>Aug. 4-5<BR>Park City UT<BR>435 649 882 ext 107',1,1,'',NULL,NULL,'Art Show Schedule','Art Show Schedule',NULL),(4,'Galerie L\'Asietique<BR>Marshall Way at E 3rd Ave<BR>7045 E 3rd Ave<BR>Scottsdale, AZ 85251<BR>480 421 1818<BR>www.asietique.com',1,1,'',NULL,NULL,'Galleries','Galleries',NULL),(5,'<CENTER>Ralph started creating sculpture in Iowa in 1974. Subsequent work in Minnesota led to an early retirement in 1992 and establishment of his current studio in the Sonoran foothills of Scottsdale and his full-time pursuit of his passion for sculpture.</CENTER><BR>Education:Washington University, St. Louis; Central Iowa Art Asscociation; Minnetonka Center for the Arts, Minneaoplis. Associations: The Sonoran Arts League, Society of Minnesota Sculptors, International Sculpture Center</CENTER>',1,1,'MyHeadshotBlue.gif',NULL,NULL,'About the Artist','About the Artist',NULL),(6,'<a href=\"http://az.arts.asu.edu/artscomm\">Arizona Arts Commission</a>\r\n<a href=\"http://www.artistsregister.com\">Artists Register</a>\r\n<a href=\"http://www.sculpture.org\">International Sculpture Center</a>\r\n<a href=\"http://dart.fine-art.com\">dART-Internet Art Database</a>\r\n<a href=\"http://www.sonoranartsleague.org\">Sonoran Arts League</a>\r\n<a href=\"http://www.jbartolomeo.com\">John Bartolomeo Sculpture<a>\r\n\r\n\r\n\r\n ',1,1,'',NULL,NULL,'Links Page','Links Page',NULL),(7,'<CENTER>Welcome to the Ralph Deuschle<BR>Art Gallery<BR>This site is evergreen so visit again soon to see updates<BR><P>\r\n</center>\r\n',2,0,'','','','Ralph   Deuschle',NULL,NULL);

--
-- Table structure for table `Product`
--

CREATE TABLE `Product` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `short_description` blob,
  `linkname` varchar(50) DEFAULT NULL,
  `link` blob,
  `alloworder` smallint(6) DEFAULT NULL,
  `instock` smallint(6) DEFAULT NULL,
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `list1` varchar(255) DEFAULT NULL,
  `list2` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `prices` varchar(255) DEFAULT NULL,
  `weight` double(8,4) NOT NULL DEFAULT '0.0000',
  `display` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `long_description` blob,
  `shipcost` float(10,2) NOT NULL DEFAULT '0.00',
  `number` smallint(6) NOT NULL DEFAULT '0',
  `notax` smallint(6) DEFAULT NULL,
  `inactive` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Dumping data for table `Product`
--

INSERT INTO `Product` VALUES (1,'MODERN TIMES','30','56\"H, Fountain, Stainless Steel(316),Water flows up through all three elements and sheeting down the exterior. 25psi softened water recommended at 8 to 20 gpm flow.<BR><BR>Price $4100<BR><BR>Variations on this theme available.<BR><BR>Installations availab',NULL,NULL,1,1,'','',0.00,'','','Fountain57S.jpg','',0.0000,1,1,'56\"H, Fountain, Stainless Steel(316),Water flows up through all three elements and sheeting down the exterior. 25psi softened water recommended at 8 to 20 gpm flow.<BR><BR>Price $4100<BR><BR>Variations on this theme available.<BR><BR>Installations availab',0.00,1,NULL,NULL),(2,'IDEAS','65','69\" Tall, install in 8\" deep pool.<P>Burnished Stainless Steel. 4 paths/heights of falling water.<P>Pumps/piping and installation availble.',NULL,NULL,1,1,'','',3600.00,'','','FountainV68Inch.jpg','',0.0000,1,1,'69\" Tall, install in 8\" deep pool.<P>Burnished Stainless Steel. 4 paths/heights of falling water.<P>Pumps/piping and installation availble.',0.00,2,NULL,NULL),(3,'ILLUSIONS','20','4\"H Cast Bronze, Blue Patina<BR>Sand Stone Base<BR>Price $65<BR><BR>Commissions to 6 feet tall considered.',NULL,NULL,1,1,'','',0.00,'','','SumoGuy35S.jpg','',0.0000,1,1,'4\"H Cast Bronze, Blue Patina<BR>Sand Stone Base<BR>Price $65<BR><BR>Commissions to 6 feet tall considered.',0.00,3,NULL,NULL),(4,'SERENDIPITY','45','5\"H Cast Bronze, Blue/Green Satin Patina.<BR>5\"x5\" Walnut Base.<BR><BR>Price $450<BR><BR>Large size to 24\"H coming.<BR>Check back later for details.<P>(See \"Garden Art\" for larger)',NULL,NULL,1,1,'','',0.00,'','','ManySides35S.jpg','',0.0000,1,1,'5\"H Cast Bronze, Blue/Green Satin Patina.<BR>5\"x5\" Walnut Base.<BR><BR>Price $450<BR><BR>Large size to 24\"H coming.<BR>Check back later for details.<P>(See \"Garden Art\" for larger)',0.00,4,NULL,NULL),(5,'MODERN TIMES','40','5\"H Cast Bronze, Brown Patina<BR>Granite Base<BR><BR>Price $65',NULL,NULL,1,1,'','',0.00,'','','Monuments35S.jpg','',0.0000,1,1,'5\"H Cast Bronze, Brown Patina<BR>Granite Base<BR><BR>Price $65',0.00,5,NULL,NULL),(32,'CONNECTIONS II',NULL,'36\"Hx17\"Wx6\"D Patinaed Steel, Clear Coated (Outdoor)<BR>16\"x16\" Travertine Marble Base<BR><BR>Price: $3250<BR><BR>Commissions to larger sizes possible<BR><BR>See further for variations on this theme.',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'ConnectionsIIPatinaed57S.jpg',NULL,5.0000,1,1,'36\"Hx17\"Wx6\"D Patinaed Steel, Clear Coated (Outdoor)<BR>16\"x16\" Travertine Marble Base<BR><BR>Price: $3250<BR><BR>Commissions to larger sizes possible<BR><BR>See further for variations on this theme.',0.00,0,NULL,NULL),(6,'SERENDIPITY','2','12\"H Cast Bronze, Brown Patina<BR>10\"x12\" Sandstone Base<BR><BR>Price $875<BR>See \"Public Sculpture\" for other sizes/materials.',NULL,NULL,1,1,'','',0.00,'','','CastModernTimes57S.jpg','',0.0000,1,1,'12\"H Cast Bronze, Brown Patina<BR>10\"x12\" Sandstone Base<BR><BR>Price $875<BR>See \"Public Sculpture\" for other sizes/materials.',0.00,6,NULL,NULL),(7,'WIND SONG','55','18\"H Cast Bronze, Brown Patina<BR>10\"x10\" Red Rock Sandstone Base<BR><BR>Price $1100<BR><BR>Smaller Bases are available to fit shallow niche\'s and aclove\'s.',NULL,NULL,1,1,'','',0.00,'','','ConnectionsCast57S.jpg','',0.0000,1,1,'18\"H Cast Bronze, Brown Patina<BR>10\"x10\" Red Rock Sandstone Base<BR><BR>Price $1100<BR><BR>Smaller Bases are available to fit shallow niche\'s and aclove\'s.',0.00,7,NULL,NULL),(8,'CONNECTIONS II','15',' ',NULL,NULL,1,1,'','',0.00,'','','Artist-At-Work+Scott.JPG','',0.0000,1,1,' ',0.00,8,NULL,NULL),(9,'CONNECTIONS II','10','8-feet high<BR>Burnished aluminum, Clear-Coated Powder-Coat Finish. Permanent outdoor installations including in reflecting pools..<BR><BR>Indoor and Outdoor Corporate Installations available.<BR><BR>Price $38,000<BR><BR>Installations available in Arizona',NULL,NULL,1,1,'','',0.00,'','','New8FootSeren.jpg','',0.0000,1,1,'8-feet high<BR>Burnished aluminum, Clear-Coated Powder-Coat Finish. Permanent outdoor installations including in reflecting pools..<BR><BR>Indoor and Outdoor Corporate Installations available.<BR><BR>Price $38,000<BR><BR>Installations available in Arizona',0.00,9,NULL,NULL),(10,'ORBITS','5','Currently under construction a 56\"H copper clad.Texture and patina yet to be added. Future site-specific or public constructions of this image to 10 feet tall.<BR><BR>Price: 56\" Copper-clad: $4350<BR><BR>Call for price/details on site-specific and public ',NULL,NULL,1,1,'','',0.00,'','','CityScapesCopper.jpg','',0.0000,1,1,'Currently under construction a 56\"H copper clad.Texture and patina yet to be added. Future site-specific or public constructions of this image to 10 feet tall.<BR><BR>Price: 56\" Copper-clad: $4350<BR><BR>Call for price/details on site-specific and public ',0.00,10,NULL,NULL),(11,'MODERN TIMES','85','16\"x20\" Cast Bronze Relief, Brown Patina<BR>Gold Picture Frame Mounting for Wall Hanging<BR><BR>Price $',NULL,NULL,1,1,'','',0.00,'','','PhotoComingSoon.jpg','',0.0000,1,1,'16\"x20\" Cast Bronze Relief, Brown Patina<BR>Gold Picture Frame Mounting for Wall Hanging<BR><BR>Price $',0.00,11,NULL,NULL),(12,'CUBIC II','70','12\"H Cast Bronze, Blue Patina<BR>Walnut Base<BR><BR>Price $425<BR><BR>Large sizes coming soon.',NULL,NULL,1,1,'','',0.00,'','','Pathways.jpg','',0.0000,1,1,'12\"H Cast Bronze, Blue Patina<BR>Walnut Base<BR><BR>Price $425<BR><BR>Large sizes coming soon.',0.00,12,NULL,NULL),(13,'ORGANIZATIONS','40','36\"Hx27\"Wx5\"D Powder Coated Aluminum<BR>Textures Bronze/Copper Color (Outdoor or Niche Installation)<BR>14\"x14\" Travertine Marble Base<BR><BR>Price $2450',NULL,NULL,1,1,'','',0.00,'','','BetterOrganizations.jpg','',0.0000,1,1,'36\"Hx27\"Wx5\"D Powder Coated Aluminum<BR>Textures Bronze/Copper Color (Outdoor or Niche Installation)<BR>14\"x14\" Travertine Marble Base<BR><BR>Price $2450',0.00,13,NULL,NULL),(14,'SERENDIPITY','1','14\"Hx13\"W Cast Bronze, Brown Patina<BR>10\"x16\" Sandstone Base<BR><BR>Price $1150<BR><BR>See further for other sizes/materials/colors.<BR>Or \"Search\" by title.',NULL,NULL,1,1,'','',0.00,'','','CastSerenStone57S.jpg','',0.0000,1,1,'14\"Hx13\"W Cast Bronze, Brown Patina<BR>10\"x16\" Sandstone Base<BR><BR>Price $1150<BR><BR>See further for other sizes/materials/colors.<BR>Or \"Search\" by title.',0.00,14,NULL,NULL),(15,'MANY SIDES','4','36\"Hx17\"Wx6\"D Patinaed Steel, Clear Coated (Outdoor)<BR>16\"x16\" Travertine Marble Base<BR><BR>Price: $3250<BR><BR>Commissions to larger sizes possible<BR><BR>See further for variations on this theme.',NULL,NULL,1,1,'','',0.00,'','','ConnectionsIIPatinaed57S.jpg','',0.0000,1,1,'36\"Hx17\"Wx6\"D Patinaed Steel, Clear Coated (Outdoor)<BR>16\"x16\" Travertine Marble Base<BR><BR>Price: $3250<BR><BR>Commissions to larger sizes possible<BR><BR>See further for variations on this theme.',0.00,15,NULL,NULL),(16,'CRYSTALLINE','2','3\"H Cast Bronze, Brown Patina<BR>Granite Base<BR><BR>Price $65',NULL,NULL,1,1,'','',0.00,'','','Crystalline35S.jpg','',0.0000,1,1,'3\"H Cast Bronze, Brown Patina<BR>Granite Base<BR><BR>Price $65',0.00,16,NULL,NULL),(17,'MONUMEMTS','5','5\"H Cast Bronze, Brown Patina<BR>Granite Base<BR><BR>Price $65',NULL,NULL,1,1,'','',0.00,'','','Monuments35S.jpg','',0.0000,1,1,'5\"H Cast Bronze, Brown Patina<BR>Granite Base<BR><BR>Price $65',0.00,17,NULL,NULL),(18,'STAND BY ME','10','This wax maquette (model) is at the foundry. Images of the finished piece are \"Coming Soon\". Check back later.',NULL,NULL,1,1,'','',0.00,'','','StandByMe35S.jpg','',0.0000,1,1,'This wax maquette (model) is at the foundry. Images of the finished piece are \"Coming Soon\". Check back later.',0.00,18,NULL,NULL),(19,'WORK-IN-PROGRESS','8','9\"H Cast Bronze, Brown Patina<BR>Sand Stone Base<BR><BR>Price $525<BR><BR>See further for other sizes/materials/colors.',NULL,NULL,1,1,'','',0.00,'','','WorkInProgress8in57S.jpg','',0.0000,1,1,'9\"H Cast Bronze, Brown Patina<BR>Sand Stone Base<BR><BR>Price $525<BR><BR>See further for other sizes/materials/colors.',0.00,19,NULL,NULL),(20,'MODERN TIMES','6','28\"Hx29\"Wx6\"D Bronze Plated Steel, Brown Patina, Clear Coated (Indoor)<BR>14\"x14\" Polished Walnut Wood Base.<BR><BR>Price $2250<BR><BR>Commisions to 10 feet in powder coated aluminum. Large variations on this theme possible.',NULL,NULL,1,1,'','',0.00,'','','Illusions57S.jpg','',0.0000,1,1,'28\"Hx29\"Wx6\"D Bronze Plated Steel, Brown Patina, Clear Coated (Indoor)<BR>14\"x14\" Polished Walnut Wood Base.<BR><BR>Price $2250<BR><BR>Commisions to 10 feet in powder coated aluminum. Large variations on this theme possible.',0.00,20,NULL,NULL),(21,'CONNECTIONS','7','18\"H Cast Bronze, Brown Patina<BR>10\"x10\" Red Rock Sandstone Base<BR><BR>Price $1100<BR><BR>Smaller Bases are available to fit shallow niche\'s and aclove\'s.',NULL,NULL,1,1,'','',0.00,'','','ConnectionsCast57S.jpg','',0.0000,1,1,'18\"H Cast Bronze, Brown Patina<BR>10\"x10\" Red Rock Sandstone Base<BR><BR>Price $1100<BR><BR>Smaller Bases are available to fit shallow niche\'s and aclove\'s.',0.00,21,NULL,NULL),(22,'ZANY GEARS','11','16\"x20\" Cast Bronze Relief, Brown Patina<BR>Gold Picture Frame Mounting for Wall Hanging<BR><BR>Price $',NULL,NULL,1,1,'','',0.00,'','','PhotoComingSoon.jpg','',0.0000,1,1,'16\"x20\" Cast Bronze Relief, Brown Patina<BR>Gold Picture Frame Mounting for Wall Hanging<BR><BR>Price $',0.00,22,NULL,NULL),(23,'SERENDIPITY','1','14\"Hx13\"W Cast Bronze, Brown Patina<BR>10\"x16\" Sandstone Base<BR><BR>Price $1150<BR><BR>See further for other sizes/materials/colors.<BR>Or \"Search\" by title.',NULL,NULL,1,1,'','',0.00,'','','CastSerenStone57S.jpg','',0.0000,1,1,'14\"Hx13\"W Cast Bronze, Brown Patina<BR>10\"x16\" Sandstone Base<BR><BR>Price $1150<BR><BR>See further for other sizes/materials/colors.<BR>Or \"Search\" by title.',0.00,23,NULL,NULL),(24,'SUMO GUY','3','4\"H Cast Bronze, Blue Patina<BR>Sand Stone Base<BR>Price $65<BR><BR>Commissions to 6 feet tall considered.',NULL,NULL,1,1,'','',0.00,'','','SumoGuy35S.jpg','',0.0000,1,1,'4\"H Cast Bronze, Blue Patina<BR>Sand Stone Base<BR>Price $65<BR><BR>Commissions to 6 feet tall considered.',0.00,24,NULL,NULL),(25,'WORK-IN-PROGRESS','9','9\"H Cast Bronze, Brown Patina<BR>Sand Stone Base<BR><BR>Price $525<BR><BR>See further for other sizes/materials/colors.',NULL,NULL,1,1,'','',0.00,'','','WorkInProgress8in57S.jpg','',0.0000,1,1,'9\"H Cast Bronze, Brown Patina<BR>Sand Stone Base<BR><BR>Price $525<BR><BR>See further for other sizes/materials/colors.',0.00,25,NULL,NULL),(26,'TOUCHING LIVES','60','22\"H Cast Bronze,Green Patina. .<BR><BR>Larger sizes in the near future.<BR><BR>Marble Base<BR><BR>Price $2750',NULL,NULL,1,1,'','',0.00,'','','TouchingLives.jpg','',0.0000,1,1,'22\"H Cast Bronze,Green Patina. .<BR><BR>Larger sizes in the near future.<BR><BR>Marble Base<BR><BR>Price $2750',0.00,26,NULL,NULL),(27,'PATHWAYS','12','12\"H Cast Bronze, Blue Patina<BR>Walnut Base<BR><BR>Price $425<BR><BR>Large sizes coming soon.',NULL,NULL,1,1,'','',0.00,'','','Pathways.jpg','',0.0000,1,1,'12\"H Cast Bronze, Blue Patina<BR>Walnut Base<BR><BR>Price $425<BR><BR>Large sizes coming soon.',0.00,27,NULL,NULL),(28,'At work on an 8 foot tall SERENDIPITY','8',' ',NULL,NULL,1,1,'','',0.00,'','','Artist-At-Work+Scott.JPG','',0.0000,1,1,' ',0.00,28,NULL,NULL),(29,' SERENDIPITY','9','8-feet high<BR>Burnished aluminum, Clear-Coated Powder-Coat Finish. Permanent outdoor installations including in reflecting pools..<BR><BR>Indoor and Outdoor Corporate Installations available.<BR><BR>Price $38,000<BR><BR>Installations available in Arizona',NULL,NULL,1,1,'','',0.00,'','','New8FootSeren.jpg','',0.0000,1,1,'8-feet high<BR>Burnished aluminum, Clear-Coated Powder-Coat Finish. Permanent outdoor installations including in reflecting pools..<BR><BR>Indoor and Outdoor Corporate Installations available.<BR><BR>Price $38,000<BR><BR>Installations available in Arizona',0.00,29,NULL,NULL),(30,' CITY SCAPES','10','36\"Hx17\"Wx6\"D Green Patina on Copper Plated Steel. Clear-Coated for some Outdoor installations.<BR>16\"x16\" Travertine Marble Base<BR><BR>Price $3250<BR><BR>Smaller bases are available to fix shallow niche\'s or alcove\'s.',NULL,NULL,1,1,'','',0.00,'','','ModerntimesIIPatined57S.jpg','',0.0000,1,1,'36\"Hx17\"Wx6\"D Green Patina on Copper Plated Steel. Clear-Coated for some Outdoor installations.<BR>16\"x16\" Travertine Marble Base<BR><BR>Price $3250<BR><BR>Smaller bases are available to fix shallow niche\'s or alcove\'s.',0.00,30,NULL,NULL),(31,'LIFE','1','56\"H, Fountain, Stainless Steel(316),Water flows up through all three elements and sheeting down the exterior. 25psi softened water recommended at 8 to 20 gpm flow.<BR><BR>Price $4100<BR><BR>Variations on this theme available.<BR><BR>Installations availab',NULL,NULL,1,1,'','',0.00,'','','Fountain57S.jpg','',0.0000,1,1,'56\"H, Fountain, Stainless Steel(316),Water flows up through all three elements and sheeting down the exterior. 25psi softened water recommended at 8 to 20 gpm flow.<BR><BR>Price $4100<BR><BR>Variations on this theme available.<BR><BR>Installations availab',0.00,31,NULL,NULL),(33,'CONNECTIONS II',NULL,'Pewter-Plated Steel, Clear coated<BR><BR>36\"Hx17\"W<BR>16\"x16\" Travertine Marble Base<BR><BR>Price $3250<BR><BR>See further for other sizes/materials/colors.',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'ConnectionsIIBetterPic.jpg',NULL,5.0000,1,1,'Pewter-Plated Steel, Clear coated<BR><BR>36\"Hx17\"W<BR>16\"x16\" Travertine Marble Base<BR><BR>Price $3250<BR><BR>See further for other sizes/materials/colors.',0.00,0,NULL,NULL),(34,'CUBIC II',NULL,'36\"Hx14\"Wx14\"D Copper Tinted Aulminum,with clear-coat for outdoors<BR><BR>Self Based<BR><BR>Price $3150',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'CubicII.jpg',NULL,5.0000,1,1,'36\"Hx14\"Wx14\"D Copper Tinted Aulminum,with clear-coat for outdoors<BR><BR>Self Based<BR><BR>Price $3150',0.00,0,NULL,NULL),(35,'ILLUSIONS',NULL,'28\"Hx29\"Wx6\"D Bronze Plated Steel, Brown Patina, Clear Coated (Indoor)<BR>14\"x14\" Polished Walnut Wood Base.<BR><BR>Price $2250<BR><BR>Commisions to 10 feet in powder coated aluminum. Large variations on this theme possible.',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'Illusions57S.jpg',NULL,5.0000,1,1,'28\"Hx29\"Wx6\"D Bronze Plated Steel, Brown Patina, Clear Coated (Indoor)<BR>14\"x14\" Polished Walnut Wood Base.<BR><BR>Price $2250<BR><BR>Commisions to 10 feet in powder coated aluminum. Large variations on this theme possible.',0.00,0,NULL,NULL),(36,'MANY SIDES II',NULL,'24\" tall, patinaed bronze, \"red rock\" sandstone base.<P>',NULL,NULL,1,1,NULL,NULL,3450.00,NULL,NULL,'ManySides24Inch.jpg',NULL,5.0000,1,1,'24\" tall, patinaed bronze, \"red rock\" sandstone base.<P>',0.00,0,NULL,NULL),(37,'MODERN TIMES',NULL,'36\"Hx17\"Wx6\"D Green Patina on Copper Plated Steel. Clear-Coated for some Outdoor installations.<BR>16\"x16\" Travertine Marble Base<BR><BR>Price $3250<BR><BR>Smaller bases are available to fix shallow niche\'s or alcove\'s.',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'ModerntimesIIPatined57S.jpg',NULL,5.0000,1,1,'36\"Hx17\"Wx6\"D Green Patina on Copper Plated Steel. Clear-Coated for some Outdoor installations.<BR>16\"x16\" Travertine Marble Base<BR><BR>Price $3250<BR><BR>Smaller bases are available to fix shallow niche\'s or alcove\'s.',0.00,0,NULL,NULL),(38,'MODERN TIMES',NULL,'45\"xHx33\"W Copper Clad over Western Red Cedar Frame<BR>Flat Aluminum Painted Base<BR><BR>Price $ 4250<BR><BR>Suitable for outdoors in any climate.<BR><BR>Other patina finishs available.',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'CopperCladModernTimesFinished.jpg',NULL,5.0000,1,1,'45\"xHx33\"W Copper Clad over Western Red Cedar Frame<BR>Flat Aluminum Painted Base<BR><BR>Price $ 4250<BR><BR>Suitable for outdoors in any climate.<BR><BR>Other patina finishs available.',0.00,0,NULL,NULL),(39,'ORBITS',NULL,'28\"Hx24\"Wx8\"D Polished, textured steel. Clear-coated<BR>16\"x16\" Travertine Marble Base (Outdoor)<BR><BR>Price: $1950<BR><BR>Commissions to 10 feet (Outdoor)<BR><BR>Variations on this theme for site-specfic installations.<BR>Smaller bases available to fit ',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'Orbits57S.jpg',NULL,5.0000,1,1,'28\"Hx24\"Wx8\"D Polished, textured steel. Clear-coated<BR>16\"x16\" Travertine Marble Base (Outdoor)<BR><BR>Price: $1950<BR><BR>Commissions to 10 feet (Outdoor)<BR><BR>Variations on this theme for site-specfic installations.<BR>Smaller bases available to fit ',0.00,0,NULL,NULL),(40,'SERENDIPITY',NULL,'36\"H x 27\"W Bronze Plated Steel, Clear Coated.<BR>12\" x 12\" Travertine Marble Base.<BR><BR>Price: $3450<BR><BR>See further on for other sizes/materials/colors etc.<BR>Or \"Search\" by title.',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'BronzeSeren57SJEPG.jpg',NULL,5.0000,1,1,'36\"H x 27\"W Bronze Plated Steel, Clear Coated.<BR>12\" x 12\" Travertine Marble Base.<BR><BR>Price: $3450<BR><BR>See further on for other sizes/materials/colors etc.<BR>Or \"Search\" by title.',0.00,0,NULL,NULL),(41,'SERENDIPITY',NULL,'Same as item 1 but with a pale gold etched color, clear-coated for permanent outdoor installation.<BR><BR>Some additional colors available.',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'GoldSerenNew.jpg',NULL,5.0000,1,1,'Same as item 1 but with a pale gold etched color, clear-coated for permanent outdoor installation.<BR><BR>Some additional colors available.',0.00,0,NULL,NULL),(42,'CONNECTIONS',NULL,'18\"H Cast Bronze, Brown Patina<BR>10\"x10\" Red Rock Sandstone Base<BR><BR>Price $1100<BR><BR>Smaller Bases are available to fit shallow niche\'s and aclove\'s.',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'ConnectionsCast57S.jpg',NULL,5.0000,1,1,'18\"H Cast Bronze, Brown Patina<BR>10\"x10\" Red Rock Sandstone Base<BR><BR>Price $1100<BR><BR>Smaller Bases are available to fit shallow niche\'s and aclove\'s.',0.00,0,NULL,NULL),(43,'WORK-IN-PROGRESS',NULL,'7\"H Cast Bronze, green Patina<BR>Red Rock, Sand Stone Base<BR><BR>Price $425',NULL,NULL,1,1,NULL,NULL,0.00,NULL,NULL,'WorkInProgress5in35S.jpg',NULL,5.0000,1,1,'7\"H Cast Bronze, green Patina<BR>Red Rock, Sand Stone Base<BR><BR>Price $425',0.00,0,NULL,NULL);

--
-- Table structure for table `Sale`
--

CREATE TABLE `Sale` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `invoiceID` int(11) NOT NULL DEFAULT '0',
  `name` varchar(60) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `notax` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Dumping data for table `Sale`
--


--
-- Table structure for table `Shipping`
--

CREATE TABLE `Shipping` (
  `carrier` tinytext,
  `method` tinytext,
  `weight` double(16,2) DEFAULT NULL,
  `price` double(16,2) DEFAULT NULL,
  `record_type` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(5) DEFAULT NULL,
  `class` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Dumping data for table `Shipping`
--


--
-- Table structure for table `Shopping`
--

CREATE TABLE `Shopping` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `product` int(11) NOT NULL DEFAULT '0',
  `session` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `label1` tinytext,
  `sitename` tinytext,
  `label2` tinytext,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- Dumping data for table `Shopping`
--

INSERT INTO `Shopping` VALUES (1,35,1009576936,1,'','ralph_deuschle','');

--
-- Dumping events for database 'ralph_deuschle'
--

--
-- Dumping routines for database 'ralph_deuschle'
--


