Changeset View
Changeset View
Standalone View
Standalone View
branches/5.2.x/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 |