search

bsoetaer / CMPUT391Project

0 stars 0 forks source link

Base DBs with default admin. #17

Closed bsoetaer closed 9 years ago

bsoetaer commented 9 years ago

@Tyler-Meen @vzphung Default database setup script from website modified to have a default admin user. Run the setup script by running the following in the folder:

sqlplus SQL > @setup.sql

Added a comment on how to bulk add more meaningful data if we need it later to issue #7

Feel free to review this if you want guys. Also post if you aren't going to review it and then I'll just merge it.

vzphung commented 9 years ago

Looks good to me

bsoetaer commented 9 years ago

K, I'll merge it later. I am doing a networking assignment then working on this the rest of the week. Going to change the tables to auto-increment the ids that originate in that table as suggested on the class forums.

If you guys need this now though you can merge it or pull from my branch and if you merge it I'll just make a new small branch to change to auto-increment.

bsoetaer commented 9 years ago

Going to merge now. Had to use sequences and triggers to implement auto-increment because the oracle version we are using is only 11g and Identities aren't supported until 12c.