[Ils-source] r1385 - in branches/1.6: . sql

[scribe at crosswire.org]

Author: scribe
Date: 2016-01-20 15:07:27 -0700 (Wed, 20 Jan 2016)
New Revision: 1385

Modified:
   branches/1.6/
   branches/1.6/sql/addcompany.properties
Log:
update addcompany script to add new admin user



Property changes on: branches/1.6
___________________________________________________________________
Modified: svn:mergeinfo
   - /trunk:796-1303,1306-1307,1309-1311,1319-1320,1322-1323,1325,1328-1330,1332,1334-1335,1337,1339,1349-1355,1360-1365,1382-1383
   + /trunk:796-1303,1306-1307,1309-1311,1319-1320,1322-1323,1325,1328-1330,1332,1334-1335,1337,1339,1349-1355,1360-1365,1380-1383

Modified: branches/1.6/sql/addcompany.properties
===================================================================
--- branches/1.6/sql/addcompany.properties	2016-01-20 22:05:26 UTC (rev 1384)
+++ branches/1.6/sql/addcompany.properties	2016-01-20 22:07:27 UTC (rev 1385)
@@ -7,3 +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, 3 from COMPANY WHERE CONAME='{0}'