]>
Commit | Line | Data |
---|---|---|
51e7c423 | 1 | /mit/smsdev/db/README: $Header$ |
2 | ||
3 | This directory contains stuff necessary to create and initialize an | |
4 | sms database. Note that some other directories rely on files here | |
5 | (notably dbbuild), and that the newsms program relies on other files. | |
6 | ||
7 | STEPS TO CREATE A DATABASE: | |
8 | ||
9 | 1. run "createdb" from the shell | |
10 | 2. run the quel commands in newdb to create the tables | |
11 | 3. run newsms | |
12 | 4. if you want any queries to be publically executable, change their | |
13 | capacls entries from list_id 2 to 1. | |
14 | ||
15 | Example: | |
16 | ||
17 | createdb testsms | |
18 | quel testsms | |
19 | \i newdb | |
20 | \g | |
21 | \q | |
22 | newsms | |
23 | mar | |
24 | ||
25 | 19000 | |
26 | 19000 | |
27 | 600 | |
28 | mar | |
29 | renamedb testsms newsms | |
30 | ||
31 | ||
32 | THINGS TO DO: | |
33 | ||
34 | automate generation of stub procs in newsms.qc |