Difference between revisions of "Database Table: posts raw"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Updating: Format)
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Database Table|name=posts_raw|table type=other}}
+
{{Database Table|name=posts_raw|table type=other|ok=1}}
 
[[description::Table for sphinx to use.]]
 
[[description::Table for sphinx to use.]]
 
= Definition =
 
= Definition =
Line 21: Line 21:
 
) ENGINE=InnoDB;
 
) ENGINE=InnoDB;
 
</source>
 
</source>
{{Database Table Footer|norels=1}}
+
{{Database Table Footer}}

Latest revision as of 20:57, 19 September 2011

"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property.

Table for sphinx to use.

Definition

CREATE TABLE `posts_raw`
(
 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `journal_id` INT(10) UNSIGNED NOT NULL,
 `jitemid` INT(10) UNSIGNED NOT NULL,
 `poster_id` INT(10) UNSIGNED NOT NULL,
 `security_bits` VARCHAR(255) NOT NULL,
 `allow_global_search` enum('0','1') NOT NULL DEFAULT '1',
 `is_deleted` enum('0','1') NOT NULL DEFAULT '0',
 `date_posted` INT(10) UNSIGNED NOT NULL,
 `title` VARCHAR(255) DEFAULT NULL,
 `data` mediumtext,
 `revtime` INT(10) UNSIGNED NOT NULL,
 `touchtime` INT(10) UNSIGNED NOT NULL,
 PRIMARY KEY  (`id`),
 UNIQUE KEY `journal_id` (`journal_id`,`jitemid`)
) ENGINE=InnoDB;

Relationships