Dinoza

External Mail (SQL)

Feb 19th, 2012
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.56 KB | None | 0 0
  1. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='';
  2.  
  3. DROP TABLE IF EXISTS `mail_external`;
  4. CREATE TABLE `mail_external` (
  5.   `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  6.   `receiver` BIGINT(20) UNSIGNED NOT NULL,
  7.   `subject` VARCHAR(200) DEFAULT 'Support Message',
  8.   `message` VARCHAR(500) DEFAULT 'Support Message',
  9.   `money` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  10.   `item` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  11.   `item_count` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  12.   PRIMARY KEY  (`id`)
  13. ) ENGINE=MyISAM AUTO_INCREMENT=7525 DEFAULT CHARSET=utf8;
Advertisement
Add Comment
Please, Sign In to add comment