diff --git a/sql/upgrades/070.sql b/sql/upgrades/070.sql index df84de53..23ed82e0 100644 --- a/sql/upgrades/070.sql +++ b/sql/upgrades/070.sql @@ -1,15 +1,15 @@ -- SWH DB schema upgrade -- from_version: 69 -- to_version: 70 -- description: Drop the archiver's related tables in main schema (move to its own database) -insert into dbversion(version, release, description) - values(70, now(), 'Work In Progress'); +INSERT INTO dbversion(version, release, description) +VALUES(70, now(), 'Work In Progress'); -drop domain archive_id; +DROP TABLE content_archive; -drop tab le archives; +DROP TABLE archives; -drop type archive_status; +DROP TYPE archive_status; -drop table content_archive; +DROP DOMAIN archive_id;