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

annotate database/schema.sql @ 49:4b7f0ee35994

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use != in python and <> in sql.
author David A. Holland
date Sat, 02 Apr 2022 18:10:30 -0400
parents debc55088b4f
children 40f64a96481f
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
22
8870309149f8 add a descriptive comment
David A. Holland
parents: 8
diff changeset
1 -- Load the database schema.
28
000519947282 swallowtail_admin, not swallowtail-admin.
David A. Holland
parents: 27
diff changeset
2 -- Should be done as the swallowtail_admin user.
22
8870309149f8 add a descriptive comment
David A. Holland
parents: 8
diff changeset
3
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
4 begin;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
5
27
021ec7010271 make the inclusions work
David A. Holland
parents: 22
diff changeset
6 \ir schema/version.sql
021ec7010271 make the inclusions work
David A. Holland
parents: 22
diff changeset
7 \ir schema/config.sql
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
8
27
021ec7010271 make the inclusions work
David A. Holland
parents: 22
diff changeset
9 \ir schema/users.sql
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
10
27
021ec7010271 make the inclusions work
David A. Holland
parents: 22
diff changeset
11 \ir schema/bugs.sql
021ec7010271 make the inclusions work
David A. Holland
parents: 22
diff changeset
12 \ir schema/messages.sql
021ec7010271 make the inclusions work
David A. Holland
parents: 22
diff changeset
13 \ir schema/subscription.sql
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
14
27
021ec7010271 make the inclusions work
David A. Holland
parents: 22
diff changeset
15 \ir schema/classify.sql
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
16
27
021ec7010271 make the inclusions work
David A. Holland
parents: 22
diff changeset
17 \ir schema/logs.sql
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
18
43
debc55088b4f add administrative queue
David A. Holland
parents: 28
diff changeset
19 \ir schema/admin.sql
debc55088b4f add administrative queue
David A. Holland
parents: 28
diff changeset
20
8
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
21 commit;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
22
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
23
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
24