Untitled
By: a guest | Aug 12th, 2008 | Syntax:
MySQL | Size: 1.21 KB | Hits: 34 | Expires: Never
--
-- Table structure for table `default_table`
--
CREATE TABLE `default_table` (
`biz_id` int(11) NOT NULL auto_increment,
`biz_name` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`city` varchar(100) NOT NULL default '',
`state` varchar(100) NOT NULL default '',
`zip` varchar(20) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`hours` varchar(100) NOT NULL default '',
`details` text NOT NULL,
PRIMARY KEY (`biz_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2582 ;
--
-- Dumping data for table `default_table`
--
INSERT INTO `default_table` VALUES (1, 'Animal Shelters', '1201 Parkwood Drive', 'Anniston', 'AL', '36201', '(256) 236-1581', '', '', '', '', '\n<b>Products & Services:</b><br>\n<ul>\n<li>City & County Government</li>\n</ul>\n');
INSERT INTO `default_table` VALUES (2, 'The Dog Pound', '1701 US Highway 72 West', 'Athens', 'AL', '35611', '(256) 771-7889', 'http://www.the-dog-pound.com', '', '', '', '\n<b>Products & Services:</b><br>\n<ul>\n<li>City & County Government</li>\n</ul>\n');