[Ils-source] r1591 - trunk/db/mssql

[scribe at crosswire.org]

Author: scribe
Date: 2018-07-18 13:31:53 -0700 (Wed, 18 Jul 2018)
New Revision: 1591

Modified:
   trunk/db/mssql/upgrade1.82.0-1.sql
Log:
added db field for lock course order in curriculum


Modified: trunk/db/mssql/upgrade1.82.0-1.sql
===================================================================
--- trunk/db/mssql/upgrade1.82.0-1.sql	2018-07-18 19:49:45 UTC (rev 1590)
+++ trunk/db/mssql/upgrade1.82.0-1.sql	2018-07-18 20:31:53 UTC (rev 1591)
@@ -1,3 +1,4 @@
 ALTER TABLE USERPROFILE ADD USERPMGRCOMPLEMAILSOVERRIDE CHAR(1) DEFAULT 'F';
 ALTER TABLE COURSE ADD COURSEXTRAPARAMS VARCHAR(255) DEFAULT NULL;
 ALTER TABLE COURSEATTEMPT ADD CASEATSECONDS INTEGER DEFAULT 0;
+ALTER TABLE COURSE ADD COURSISCURRICLCKCRSORD CHAR(1) DEFAULT 'F'