3 -- Allow table_alias to be nullable, but don't require it
4 -- to be null for core tables.
6 INSERT INTO config.upgrade_log (version) VALUES ('0207'); -- Scott McKellar
8 ALTER TABLE query.from_relation
9 ALTER COLUMN table_alias DROP NOT NULL;
11 ALTER TABLE query.from_relation
12 DROP CONSTRAINT join_or_core;
14 ALTER TABLE query.from_relation
15 ADD CONSTRAINT join_or_core CHECK (
16 ( parent_relation IS NULL AND join_type IS NULL
17 AND on_clause IS NULL )
19 ( parent_relation IS NOT NULL AND join_type IS NOT NULL
20 AND on_clause IS NOT NULL )