symphonycms /
symphony-2
| @@ 22-33 (lines=12) @@ | ||
| 19 | public static function upgrade() |
|
| 20 | { |
|
| 21 | // Update DB for the new Mime-type length. #1534 |
|
| 22 | if (version_compare(self::$existing_version, '2.3.2beta1', '<=')) { |
|
| 23 | $upload_entry_tables = Symphony::Database()->fetchCol( |
|
| 24 | "field_id", |
|
| 25 | "SELECT `field_id` FROM `tbl_fields_upload`" |
|
| 26 | ); |
|
| 27 | ||
| 28 | if (is_array($upload_entry_tables) && !empty($upload_entry_tables)) { |
|
| 29 | foreach ($upload_entry_tables as $field) { |
|
| 30 | Symphony::Database()->query(sprintf( |
|
| 31 | "ALTER TABLE `tbl_entries_data_%d` CHANGE `mimetype` `mimetype` VARCHAR(100) DEFAULT NULL", |
|
| 32 | $field |
|
| 33 | )); |
|
| 34 | } |
|
| 35 | } |
|
| 36 | } |
|
| @@ 21-38 (lines=18) @@ | ||
| 18 | ||
| 19 | public static function upgrade() |
|
| 20 | { |
|
| 21 | if (version_compare(self::$existing_version, '2.3.3beta1', '<=')) { |
|
| 22 | // Update DB for the new author role #1692 |
|
| 23 | Symphony::Database()->query( |
|
| 24 | "ALTER TABLE `tbl_authors` CHANGE `user_type` `user_type` ENUM('author', 'manager', 'developer') DEFAULT 'author'" |
|
| 25 | ); |
|
| 26 | ||
| 27 | // Remove directory from the upload fields, #1719 |
|
| 28 | $upload_tables = Symphony::Database()->fetchCol( |
|
| 29 | "field_id", |
|
| 30 | "SELECT `field_id` FROM `tbl_fields_upload`" |
|
| 31 | ); |
|
| 32 | ||
| 33 | if (is_array($upload_tables) && !empty($upload_tables)) { |
|
| 34 | foreach ($upload_tables as $field) { |
|
| 35 | Symphony::Database()->query(sprintf( |
|
| 36 | "UPDATE tbl_entries_data_%d SET FILE = substring_index(FILE, '/', -1)", |
|
| 37 | $field |
|
| 38 | )); |
|
| 39 | } |
|
| 40 | } |
|
| 41 | } |
|
