Changeset View
Changeset View
Standalone View
Standalone View
core/install/install_schema.sql
| Show First 20 Lines • Show All 1134 Lines • ▼ Show 20 Line(s) | |||||
| ); | ); | ||||
| 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, | ||||
| IsDraft tinyint(4) NOT NULL, | IsDraft tinyint(4) NOT NULL, | ||||
| FromRevisionId int(11) NOT NULL, | FromRevisionId int(11) NOT NULL, | ||||
| l1_PageContent longtext null, | |||||
| l2_PageContent longtext null, | |||||
| l3_PageContent longtext null, | |||||
| l4_PageContent longtext null, | |||||
| l5_PageContent longtext 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), | ||||
| KEY RevisionNumber (RevisionNumber), | KEY RevisionNumber (RevisionNumber), | ||||
| KEY IsDraft (IsDraft), | KEY IsDraft (IsDraft), | ||||
| ▲ Show 20 Lines • Show All 277 Lines • Show Last 20 Lines | |||||