Difference between revisions of "Database Table: posts raw"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) m (Robot: Updating page description status.) |
|||
| Line 1: | Line 1: | ||
{{Database Table|name=posts_raw|table type=other}} | {{Database Table|name=posts_raw|table type=other}} | ||
[[description::Table for sphinx to use.]] | [[description::Table for sphinx to use.]] | ||
| − | |||
| − | |||
= Definition = | = Definition = | ||
| − | |||
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE `posts_raw` | CREATE TABLE `posts_raw` | ||
| Line 24: | Line 21: | ||
) ENGINE=InnoDB; | ) ENGINE=InnoDB; | ||
</source> | </source> | ||
| − | {{Database Table Footer}} | + | {{Database Table Footer|norels=1}} |
Revision as of 13:27, 27 January 2010
"{{{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;
