[Ils-source] r1380 - trunk/sql

[scribe at crosswire.org]

Author: scribe
Date: 2016-01-20 14:35:50 -0700 (Wed, 20 Jan 2016)
New Revision: 1380

Modified:
   trunk/sql/addcompany.properties
Log:
Added creation of admin account for new company


Modified: trunk/sql/addcompany.properties
===================================================================
--- trunk/sql/addcompany.properties	2016-01-19 23:00:07 UTC (rev 1379)
+++ trunk/sql/addcompany.properties	2016-01-20 21:35:50 UTC (rev 1380)
@@ -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 from COMPANY WHERE CONAME='{0}'