[Ils-source] r1381 - trunk/sql

[scribe at crosswire.org]

Author: scribe
Date: 2016-01-20 14:47:11 -0700 (Wed, 20 Jan 2016)
New Revision: 1381

Modified:
   trunk/sql/addcompany.properties
Log:
Fixed to include accessprivs on insert of new admin


Modified: trunk/sql/addcompany.properties
===================================================================
--- trunk/sql/addcompany.properties	2016-01-20 21:35:50 UTC (rev 1380)
+++ trunk/sql/addcompany.properties	2016-01-20 21:47:11 UTC (rev 1381)
@@ -7,4 +7,4 @@
 Form.1=Funds Available|0.00
 Form.2=Cost Per Seat|0.00
 SQL2=INSERT INTO COMPANY (CONAME, COFUNDSAVAIL, COPERSEATCOST) VALUES ('{0}', {1}, {2})
-SQL3=INSERT INTO USERPROFILE (COMPANYID, USERPRNUM, USERPRPASSWD, USERPRFNAME, USERPRLNAME, USERPRSTATUSID, USERPRACCESSLEVEL) SELECT COMPANYID, 'admin', 'Administrator1', 'Admin', 'Admin', 1 from COMPANY WHERE CONAME='{0}'
+SQL3=INSERT INTO USERPROFILE (COMPANYID, USERPRNUM, USERPRPASSWD, USERPRFNAME, USERPRLNAME, USERPRSTATUSID, USERPRACCESSLEVEL) SELECT COMPANYID, 'admin', 'Administrator1', 'Admin', 'Admin', 1, 3 from COMPANY WHERE CONAME='{0}'