lp1849212: Archive Courses

[evergreen-equinox.git] / Open-ILS / src / sql / Pg / 040.schema.asset.sql

diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql
index 2091a69..262a689 100644 (file)
--- a/Open-ILS/src/sql/Pg/040.schema.asset.sql
+++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql
@@ -1110,7 +1110,8 @@ CREATE TABLE asset.course_module_course (
     name            TEXT NOT NULL,
     course_number   TEXT NOT NULL,
     section_number  TEXT,
-    owning_lib      INT REFERENCES actor.org_unit (id)
+    owning_lib      INT REFERENCES actor.org_unit (id),
+    is_archived        BOOLEAN DEFAULT false
 );
 
 CREATE TABLE asset.course_module_course_users (