Advertisement
Guest User

r-a-y

a guest
Mar 13th, 2010
333
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.79 KB | None | 0 0
  1. DROP TABLE IF EXISTS `wp_blogs`;
  2. CREATE TABLE `wp_blogs` (
  3.   `blog_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  4.   `site_id` BIGINT(20) NOT NULL DEFAULT '0',
  5.   `domain` VARCHAR(200) NOT NULL DEFAULT '',
  6.   `path` VARCHAR(100) NOT NULL DEFAULT '',
  7.   `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  8.   `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  9.   `public` tinyint(2) NOT NULL DEFAULT '1',
  10.   `archived` enum('0','1') NOT NULL DEFAULT '0',
  11.   `mature` tinyint(2) NOT NULL DEFAULT '0',
  12.   `spam` tinyint(2) NOT NULL DEFAULT '0',
  13.   `deleted` tinyint(2) NOT NULL DEFAULT '0',
  14.   `lang_id` INT(11) NOT NULL DEFAULT '0',
  15.   PRIMARY KEY (`blog_id`),
  16.   KEY `domain` (`domain`(50),`path`(5)),
  17.   KEY `lang_id` (`lang_id`)
  18. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement