|
@@ 36-40 (lines=5) @@
|
| 33 |
|
} |
| 34 |
|
|
| 35 |
|
// Entries Modification Date [#983] |
| 36 |
|
if (!Symphony::Database()->tableContainsField('tbl_entries', 'modification_date')) { |
| 37 |
|
Symphony::Database()->query("ALTER TABLE `tbl_entries` ADD `modification_date` DATETIME NOT NULL;"); |
| 38 |
|
Symphony::Database()->query("ALTER TABLE `tbl_entries` ADD KEY `modification_date` (`modification_date`)"); |
| 39 |
|
Symphony::Database()->query("UPDATE `tbl_entries` SET modification_date = creation_date;"); |
| 40 |
|
} |
| 41 |
|
|
| 42 |
|
if (!Symphony::Database()->tableContainsField('tbl_entries', 'modification_date_gmt')) { |
| 43 |
|
Symphony::Database()->query("ALTER TABLE `tbl_entries` ADD `modification_date_gmt` DATETIME NOT NULL;"); |
|
@@ 42-46 (lines=5) @@
|
| 39 |
|
Symphony::Database()->query("UPDATE `tbl_entries` SET modification_date = creation_date;"); |
| 40 |
|
} |
| 41 |
|
|
| 42 |
|
if (!Symphony::Database()->tableContainsField('tbl_entries', 'modification_date_gmt')) { |
| 43 |
|
Symphony::Database()->query("ALTER TABLE `tbl_entries` ADD `modification_date_gmt` DATETIME NOT NULL;"); |
| 44 |
|
Symphony::Database()->query("ALTER TABLE `tbl_entries` ADD KEY `modification_date_gmt` (`modification_date_gmt`)"); |
| 45 |
|
Symphony::Database()->query("UPDATE `tbl_entries` SET modification_date_gmt = creation_date_gmt;"); |
| 46 |
|
} |
| 47 |
|
|
| 48 |
|
// Cleanup #977, remove `entry_order` & `entry_order_direction` from `tbl_sections` |
| 49 |
|
if (Symphony::Database()->tableContainsField('tbl_sections', 'entry_order')) { |