]>
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 | |
753c1607 | 5 | (notably newdb), and that the newsms program relies on other files. |
51e7c423 | 6 | |
7 | STEPS TO CREATE A DATABASE: | |
8 | ||
68566efb | 9 | 1. run "createdb sms" from the shell |
51e7c423 | 10 | 2. run the quel commands in newdb to create the tables |
68566efb | 11 | 3. run newmoira |
51e7c423 | 12 | 4. if you want any queries to be publically executable, change their |
13 | capacls entries from list_id 2 to 1. | |
2dc40abd | 14 | 5. run the quel commands in dbopt to create indices on the data. |
51e7c423 | 15 | |
16 | Example: | |
17 | ||
68566efb | 18 | createdb sms |
19 | quel sms | |
51e7c423 | 20 | \i newdb |
21 | \g | |
22 | \q | |
68566efb | 23 | newmoira |
51e7c423 | 24 | mar |
25 | ||
26 | 19000 | |
27 | 19000 | |
28 | 600 | |
29 | mar | |
68566efb | 30 | quel sms |
2dc40abd | 31 | \i dbopt |
32 | \g | |
33 | \q | |
51e7c423 | 34 | |
35 | ||
36 | THINGS TO DO: | |
37 | ||
68566efb | 38 | automate generation of stub procs in newmoira.qc |