Changeset View
Changeset View
Standalone View
Standalone View
sql/upgrades/002.sql
- This file was added.
-- SWH DB schema upgrade | |||||
-- from_version: 1 | |||||
-- to_version: 2 | |||||
-- description: add flag to acknowledge directories' flattening | |||||
insert into dbversion(version, release, description) | |||||
values(2, now(), 'Work In Progress'); | |||||
alter table content | |||||
alter column date set not null; | |||||
alter table directory | |||||
add column flat boolean not null default false; | |||||
alter table directory | |||||
alter column date set not null; |