Mercurial > ~dholland > hg > swallowtail > index.cgi
comparison database/schema/bugs.sql @ 29:cd36b49f4437
fix.
now loads into postgresql92
author | David A. Holland |
---|---|
date | Sun, 26 May 2013 23:24:45 -0400 |
parents | d4c3bd255653 |
children | 7458a278cb64 |
comparison
equal
deleted
inserted
replaced
28:000519947282 | 29:cd36b49f4437 |
---|---|
13 -- basic description | 13 -- basic description |
14 synopsis text not null, | 14 synopsis text not null, |
15 confidential boolean not null, | 15 confidential boolean not null, |
16 | 16 |
17 -- states | 17 -- states |
18 state text not null references states (name); | 18 state text not null references states (name), |
19 locked boolean not null, -- deny modifications | 19 locked boolean not null, -- deny modifications |
20 | 20 |
21 -- intended constraint: | 21 -- intended constraint: |
22 -- select * from PRs, states where PRs.state = states.name | 22 -- select * from PRs, states where PRs.state = states.name |
23 -- and states.closed = false and PRs.locked = true | 23 -- and states.closed = false and PRs.locked = true |
47 description text , | 47 description text , |
48 how_to_repeat text , | 48 how_to_repeat text , |
49 fix text , | 49 fix text , |
50 unformatted text | 50 unformatted text |
51 | 51 |
52 ) without oids; | 52 ) |
53 WITHOUT OIDS; |