annotate database/schema.sql @ 37:edf081d0b282

Need to retain the mime-type of messages.
author David A. Holland
date Sun, 15 Jun 2014 17:13:50 -0400
parents 000519947282
children debc55088b4f
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
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
19 commit;
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
20
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
21
68cc276ac118 SQL material from old tree, split up for accessibility.
David A. Holland
parents:
diff changeset
22