Ticket #29 (task)

Opened 6 years ago

Last modified 6 years ago

Put DB schema under SVN control

Status: closed (fixed)

Reported by: cbc Assigned to: cbc
Priority: major Milestone: Test implementation of SEACOOS CDL v.3
Component: db Version: 3.0
Keywords: cdl qaqc Cc: jcothran monisha jcleary

Talk to Jeremy. In the sprint, we found the nautilus schema had qaqc flags, nemo did not. We want to make sure the schema checked in also matches the scout version checked in.

Change History

07/13/06 11:23:00: Modified by cbc

  • status changed from new to assigned.

07/13/06 11:33:57: Modified by cbc

parent ticket 22 - Modify DB schema for QAQC flags and attributes. We need a starting point in order to make the schema for the test fixture.

07/13/06 14:47:47: Modified by cbc

  • status changed from assigned to closed.
  • component changed from scout to db.
  • resolution set to fixed.

Used these commands (from ccalloway login):

pg_dump -s sea_coos_obs -U postgres -f ~/sea_coos_obs.schema

pg_dump -s myGISdb -U postgres -f ~/myGISdb.schema

and put the results here.

This ticket opened a new component in trac: db.

07/13/06 15:05:59: Modified by cbc

schema now moved here.