My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Mar 22nd, 2010 | Syntax: SQL | Size: 0.33 KB | Hits: 57 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  1. /* this will create our messages table */
  2. CREATE TABLE IF NOT EXISTS messages (
  3.   `id` int(11) NOT NULL AUTO_INCREMENT,
  4.   `user_id` int(11) NOT NULL,
  5.   `from` int(11) NOT NULL,Cheater
  6.   `subject` varchar(256) NOT NULL,
  7.   `body` TEXT NOT NULL,
  8.   `read` BOOLEAN NOT NULL,
  9.   `created` DATETIME NOT NULL,
  10.   PRIMARY KEY (`id`)
  11. );
create new paste | create new version of this paste RAW Paste Data