diff options
Diffstat (limited to 'modules_v3/user_blog')
| -rw-r--r-- | modules_v3/user_blog/db_schema/db_schema_1_2.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/modules_v3/user_blog/db_schema/db_schema_1_2.php b/modules_v3/user_blog/db_schema/db_schema_1_2.php index 496eda1f52..a522f9cdc3 100644 --- a/modules_v3/user_blog/db_schema/db_schema_1_2.php +++ b/modules_v3/user_blog/db_schema/db_schema_1_2.php @@ -23,7 +23,7 @@ use PDOException; // Add new columns try { - \Webtrees\Database::exec( + Database::exec( "ALTER TABLE `##news`" . " ADD user_id INTEGER NULL AFTER n_id," . " ADD gedcom_id INTEGER NULL AFTER user_id," . @@ -37,7 +37,7 @@ try { // Migrate data from the old columns to the new ones try { - \Webtrees\Database::exec( + Database::exec( "UPDATE `##news` n" . " LEFT JOIN `##gedcom` g ON (n.n_username=g.gedcom_name)" . " LEFT JOIN `##user` u ON (n.n_username=u.user_name)" . @@ -49,7 +49,7 @@ try { // Delete orphaned rows try { - \Webtrees\Database::exec( + Database::exec( "DELETE FROM `##news` WHERE user_id IS NULL AND gedcom_id IS NULL" ); } catch (PDOException $ex) { @@ -58,7 +58,7 @@ try { // Delete/rename old columns try { - \Webtrees\Database::exec( + Database::exec( "ALTER TABLE `##news`" . " DROP n_username, DROP n_date," . " CHANGE n_id news_id INTEGER NOT NULL AUTO_INCREMENT," . |