Share Pastebin
Guest
Public paste!

bzcoder

By: a guest | Feb 6th, 2010 | Syntax: SQL | Size: 0.44 KB | Hits: 104 | Expires: Never
This paste has a previous version, view the difference. Copy text to clipboard
  1. CREATE TABLE IF NOT EXISTS `sites` (
  2.   `site_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  3.   `url` varchar(500) NOT NULL,
  4.   `pubDate` varchar(50) NOT NULL,
  5.   `title` varchar(255) NOT NULL,
  6.   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  7.   `viewed` tinyint(1) NOT NULL DEFAULT '0',
  8.   PRIMARY KEY  (`site_id`)
  9. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
  10.  
  11.  
  12. Remove TRAILING slashes AND the unmatched } at the end