Bug #2453
closedEmpty DB created, add necessary population + verify
0%
Description
Currenty, the sql scripts, both generated and static, do not properly build the database. It is currently impossible to build a working empty database, instead you must use a backup copy from vegbank.org. These scripts need to be updated so that the creation of an empty db is possible. Also, all of the bootstrapping functions, such as creating an initial admin user need to be taken care of by the scripts. The known scripts that must be run are:
bash$ psql -U vegbank vegbank < build/sql/vegbank.sql >dbcreate.log
bash$ psql -U vegbank vegbank < build/sql/create_aggregrates.sql
bash$ psql -U vegbank vegbank < build/sql/create_extras.sql
bash$ psql -U vegbank vegbank < build/sql/denorm/add_embargo_all_or_nothingfields.sql.sql
bash$ psql
vegbank=# insert into party (party_id, givenname, surname, email) values (1,'jim','bob','jimbob@cooluni.edu');
INSERT 0 1
vegbank=# insert into usr (usr_id, party_id, password, permission_type, email_address) values (1,1,'mypasswd',15,'jimbob@cooluni.edu');
INSERT 0 1
see the INSTALL file for additional notes.