Mercurial > ~dholland > hg > swallowtail > index.cgi

comparison database/schema/bugs.sql @ 29:cd36b49f4437

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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;