Changeset fe61445ceeeb2974d31db88909d8abbbaeaeb578

Show
Ignore:
Timestamp:
10/20/09 14:13:56 (4 years ago)
Author:
Theo Schlossnagle <jesus@omniti.com>
git-committer:
Theo Schlossnagle <jesus@omniti.com> 1256048036 +0000
git-parent:

[66c92038a4140676e18fc96716d36bb945eba924]

git-author:
Theo Schlossnagle <jesus@omniti.com> 1256048036 +0000
Message:

a new way of doing this, refs #150

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/Makefile.in

    r0a06b2c rfe61445  
    2626MODULES_DIR=@MODULES_DIR@ 
    2727 
    28 all: 
     28all:   reconnoiter_ddl_dump.sql 
    2929 
    30 install: 
     30reconnoiter_ddl_dump.sql: 
     31        ./build_ddl.pl scaffolding.sql > reconnoiter_ddl_dump.sql 
     32 
     33install:        reconnoiter_ddl_dump.sql 
    3134        $(top_srcdir)/buildtools/mkinstalldirs $(DESTDIR)$(datarootdir)/reconnoiter 
    3235        $(INSTALL) -m 0644 reconnoiter_ddl_dump.sql $(DESTDIR)$(datarootdir)/reconnoiter/schema.sql 
  • sql/README

    r37c50c6 rfe61445  
    1 == Snap the schema off a live machine == 
     1== Management == 
    22 
    3 pg_dump -s -n stratcon -n prism -U postgres reconnoiter > reconnoiter_ddl_dump.sql 
     3Tables are in tables/, stored procedures/functions are in sprocs/ 
     4 
     5The scaffolding.sql file is used to glue them all together in the right order? 
     6Convoluted? perhaps.  It allows us to manipulate small sections of the schema 
     7as code, stored in version control, and reconstitute the database easily for 
     8testing. 
  • sql/scaffolding.sql

    rb2014c0 rfe61445  
    22create database reconnoiter with owner = reconnoiter; 
    33create user stratcon with unencrypted password 'stratcon'; 
     4alter user stratcon set search_path to noit,public; 
    45create user prism with unencrypted password 'prism'; 
    56\c reconnoiter reconnoiter;