Changeset View
Changeset View
Standalone View
Standalone View
core/install/install_schema.sql
| Show First 20 Lines • Show All 1174 Lines • ▼ Show 20 Line(s) | |||||
| KEY ContentNum (ContentNum,PageId), | KEY ContentNum (ContentNum,PageId), | ||||
| KEY RevisionId (RevisionId) | KEY RevisionId (RevisionId) | ||||
| ); | ); | ||||
| CREATE TABLE PageRevisions ( | CREATE TABLE PageRevisions ( | ||||
| RevisionId int(11) NOT NULL AUTO_INCREMENT, | RevisionId int(11) NOT NULL AUTO_INCREMENT, | ||||
| PageId int(11) NOT NULL, | PageId int(11) NOT NULL, | ||||
| RevisionNumber int(11) NOT NULL, | RevisionNumber int(11) NOT NULL, | ||||
| l1_ContentBlockContent text, | |||||
| l2_ContentBlockContent text, | |||||
| l3_ContentBlockContent text, | |||||
| l4_ContentBlockContent text, | |||||
| l5_ContentBlockContent text, | |||||
| IsDraft tinyint(4) NOT NULL, | IsDraft tinyint(4) NOT NULL, | ||||
| FromRevisionId int(11) NOT NULL, | FromRevisionId int(11) NOT NULL, | ||||
| CreatedById int(11) DEFAULT NULL, | CreatedById int(11) DEFAULT NULL, | ||||
| CreatedOn int(11) DEFAULT NULL, | CreatedOn int(11) DEFAULT NULL, | ||||
| AutoSavedOn int(11) DEFAULT NULL, | AutoSavedOn int(11) DEFAULT NULL, | ||||
| `Status` tinyint(4) NOT NULL DEFAULT '2', | `Status` tinyint(4) NOT NULL DEFAULT '2', | ||||
| PRIMARY KEY (RevisionId), | PRIMARY KEY (RevisionId), | ||||
| KEY PageId (PageId), | KEY PageId (PageId), | ||||
| ▲ Show 20 Lines • Show All 281 Lines • Show Last 20 Lines | |||||