Difference between revisions of "Database Table: logprop history"
From Dreamwidth Notes
(Created page with '{{Database Table|name=logprop_history|table type=global}} Category:Database Tables Needing Description = Definition = <source lang="sql"> CREATE TABLE logprop_history ( j…') |
|||
| Line 1: | Line 1: | ||
| − | {{Database Table|name=logprop_history|table type= | + | {{Database Table|name=logprop_history|table type=clustered}} |
[[Category:Database Tables Needing Description]] | [[Category:Database Tables Needing Description]] | ||
= Definition = | = Definition = | ||
Revision as of 12:48, 27 January 2010
"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. This is a clustered table.
Definition
CREATE TABLE logprop_history ( journalid INT UNSIGNED NOT NULL, jitemid MEDIUMINT UNSIGNED NOT NULL, propid TINYINT UNSIGNED NOT NULL, change_time INT UNSIGNED NOT NULL DEFAULT '0', old_value VARCHAR(255) DEFAULT NULL, new_value VARCHAR(255) DEFAULT NULL, note VARCHAR(255) DEFAULT NULL, INDEX (journalid,jitemid,propid) )
