| | 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 | 5. run the quel commands in dbopt to create indices on the data. |
| | 15 | |
| | 16 | Example: |
| | 17 | |
| | 18 | createdb testsms |
| | 19 | quel testsms |
| | 20 | \i newdb |
| | 21 | \g |
| | 22 | \q |
| | 23 | newsms |
| | 24 | mar |
| | 25 | |
| | 26 | 19000 |
| | 27 | 19000 |
| | 28 | 600 |
| | 29 | mar |
| | 30 | quel testsms |
| | 31 | \i dbopt |
| | 32 | \g |
| | 33 | \q |
| | 34 | renamedb testsms newsms |
| | 35 | |
| | 36 | |
| | 37 | THINGS TO DO: |
| | 38 | |
| | 39 | automate generation of stub procs in newsms.qc |
andersk / moira.git / blame_incremental