Subdomain Posts
SQL | 1 min ago
SQL | 19 hours ago
SQL | 20 hours ago
SQL | 1 day ago
SQL | 1 day ago
SQL | 1 day ago
SQL | 1 day ago
SQL | 2 days ago
SQL | 4 days ago
SQL | 6 days ago
Recent Posts
None | 25 sec ago
C | 28 sec ago
Java | 29 sec ago
ASM (NASM) | 30 sec ago
None | 36 sec ago
None | 40 sec ago
C# | 47 sec ago
None | 1 min ago
None | 1 min ago
SQL | 1 min ago
Sitereport
Find cool info about any domain on the internet?
visit sitereport
Free Subdomains
Want a pastebin.com sub-domain for your community?
learn more...
What is pastebin?
Pastebin is a website that hosts all your text & code on dedicated servers for easy sharing.
learn more...
Learn a little bit about the new Pastebin.com on our help page. hide message
By bzcoder on the 6th of Feb 2010 05:06:25 PM Download | Raw | Embed | Report
  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
Submit a correction or amendment below. [ previous version ] | [ difference ] | Make A New Post
To highlight particular lines, prefix each line with @h@
Syntax highlighting:
Post expiration:
Post exposure:
Name / Title:
Email: