Guest
Public paste!

Untitled

By: a guest | Aug 12th, 2008 | Syntax: MySQL | Size: 1.21 KB | Hits: 34 | Expires: Never
Copy text to clipboard
  1.  
  2. --
  3. -- Table structure for table `default_table`
  4. --
  5.  
  6. CREATE TABLE `default_table` (
  7.   `biz_id` int(11) NOT NULL auto_increment,
  8.   `biz_name` varchar(255) NOT NULL default '',
  9.   `address` varchar(255) NOT NULL default '',
  10.   `city` varchar(100) NOT NULL default '',
  11.   `state` varchar(100) NOT NULL default '',
  12.   `zip` varchar(20) NOT NULL default '',
  13.   `phone` varchar(20) NOT NULL default '',
  14.   `url` varchar(255) NOT NULL default '',
  15.   `email` varchar(255) NOT NULL default '',
  16.   `description` text NOT NULL,
  17.   `hours` varchar(100) NOT NULL default '',
  18.   `details` text NOT NULL,
  19.   PRIMARY KEY  (`biz_id`)
  20. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2582 ;
  21.  
  22. --
  23. -- Dumping data for table `default_table`
  24. --
  25.  
  26. INSERT INTO `default_table` VALUES (1, 'Animal Shelters', '1201 Parkwood Drive', 'Anniston', 'AL', '36201', '(256) 236-1581', '', '', '', '', '\n<b>Products &amp; Services:</b><br>\n<ul>\n<li>City & County Government</li>\n</ul>\n');
  27. 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 &amp; Services:</b><br>\n<ul>\n<li>City & County Government</li>\n</ul>\n');