From aa8ce3c6c7a7e68743f283a7b471c773701f9be1 Mon Sep 17 00:00:00 2001 From: Jane Sandberg Date: Wed, 2 Sep 2020 08:02:18 -0700 Subject: [PATCH] LP1849212: Add tables in the correct order Signed-off-by: Jane Sandberg --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 12 ++++++------ .../sql/Pg/upgrade/XXXX.schema.course-materials-module.sql | 12 ++++++------ 2 files changed, 12 insertions(+), 12 deletions(-) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index d948f8daa0..609b09b9a0 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -1114,6 +1114,12 @@ CREATE TABLE asset.course_module_course ( is_archived BOOLEAN DEFAULT false ); +CREATE TABLE asset.course_module_role ( + id SERIAL PRIMARY KEY, + name TEXT UNIQUE NOT NULL, + is_public BOOLEAN NOT NULL DEFAULT false +); + CREATE TABLE asset.course_module_course_users ( id SERIAL PRIMARY KEY, course INT NOT NULL REFERENCES asset.course_module_course (id), @@ -1143,12 +1149,6 @@ CREATE TABLE asset.course_module_term ( end_date TIMESTAMP WITH TIME ZONE ); -CREATE TABLE asset.course_module_role ( - id SERIAL PRIMARY KEY, - name TEXT UNIQUE NOT NULL, - is_public BOOLEAN NOT NULL DEFAULT false -); - CREATE TABLE asset.course_module_term_course_map ( id BIGSERIAL PRIMARY KEY, term INT NOT NULL REFERENCES asset.course_module_term (id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql index c5dfeed65c..d3692d1aee 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql @@ -11,6 +11,12 @@ CREATE TABLE asset.course_module_course ( is_archived BOOLEAN NOT NULL DEFAULT false; ); +CREATE TABLE asset.course_module_role ( + id SERIAL PRIMARY KEY, + name TEXT UNIQUE NOT NULL, + is_public BOOLEAN NOT NULL DEFAULT false +); + CREATE TABLE asset.course_module_course_users ( id SERIAL PRIMARY KEY, course INT NOT NULL REFERENCES asset.course_module_course (id), @@ -40,12 +46,6 @@ CREATE TABLE asset.course_module_term ( end_date TIMESTAMP WITH TIME ZONE ); -CREATE TABLE asset.course_module_role ( - id SERIAL PRIMARY KEY, - name TEXT UNIQUE NOT NULL, - is_public BOOLEAN NOT NULL DEFAULT false -); - INSERT INTO asset.course_module_role (id, name, is_public) VALUES (1, oils_i18n_gettext(1, 'Instructor', 'acmr', 'name'), true), (2, oils_i18n_gettext(2, 'Teaching assistant', 'acmr', 'name'), true), -- 2.11.0