SF.net SVN: ledger-smb:[2672] trunk/install-mycompany.sh

[..hidden..]

Revision: 2672
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2672&view=rev
Author:   jfkw
Date:     2009-06-12 21:23:44 +0000 (Fri, 12 Jun 2009)

Log Message:
-----------
install-mycompany.sh: entity.control_code can not be NULL.

Modified Paths:
--------------
    trunk/install-mycompany.sh

Modified: trunk/install-mycompany.sh
===================================================================
--- trunk/install-mycompany.sh	2009-06-12 21:23:30 UTC (rev 2671)
+++ trunk/install-mycompany.sh	2009-06-12 21:23:44 UTC (rev 2672)
@@ -22,7 +22,7 @@
 sed -e "s/<?lsmb dbname ?>/mycompany/g" $CWD/sql/modules/Roles.sql > $CWD/mycompany_roles.sql ; 
 psql -U postgres -d mycompany -f $CWD/mycompany_roles.sql ; 
 createuser --no-superuser --createdb --no-createrole -U postgres --pwprompt --encrypted myuser ; 
-psql -U postgres -d mycompany -t -c "INSERT INTO entity (name, entity_class, created) VALUES ('myuser', 3, NOW()) RETURNING name, entity_class, created;" ; 
+psql -U postgres -d mycompany -t -c "INSERT INTO entity (name, entity_class, created, control_code) VALUES ('myuser', 3, NOW(), '123') RETURNING name, entity_class, created;" ; 
 psql -U postgres -d mycompany -t -c "INSERT INTO person (entity_id, first_name, last_name, created) VALUES (2, 'Firstname', 'Lastname', NOW()) RETURNING entity_id, first_name, last_name, created;" ; 
 psql -U postgres -d mycompany -t -c "INSERT INTO entity_employee (person_id, entity_id, startdate, role) VALUES (1, 2, NOW(), 'myuser') RETURNING person_id, entity_id, startdate, role;" ; 
 psql -U postgres -d mycompany -t -c "INSERT INTO users (username, entity_id) VALUES ('myuser', 2) RETURNING username, entity_id;" ; 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.