Project

General

Profile

Actions

Bug #2453

closed

Empty DB created, add necessary population + verify

Added by Chad Berkley about 18 years ago. Updated almost 18 years ago.

Status:
Resolved
Priority:
Immediate
Assignee:
Category:
db_implement
Target version:
Start date:
06/02/2006
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2453

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','');
INSERT 0 1
vegbank=# insert into usr (usr_id, party_id, password, permission_type, email_address) values (1,1,'mypasswd',15,'');
INSERT 0 1

see the INSTALL file for additional notes.

Actions

Also available in: Atom PDF