X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/2dc40abda5c2d4b29f55d2314a89db42a1c6a798..2d32cef3c3da66c0bfaa07aa34fbc9a41f7f1a87:/db/README diff --git a/db/README b/db/README index e2f16e2a..be348e64 100644 --- a/db/README +++ b/db/README @@ -2,38 +2,37 @@ This directory contains stuff necessary to create and initialize an sms database. Note that some other directories rely on files here -(notably dbbuild), and that the newsms program relies on other files. +(notably newdb), and that the newsms program relies on other files. STEPS TO CREATE A DATABASE: -1. run "createdb" from the shell +1. run "createdb sms" from the shell 2. run the quel commands in newdb to create the tables -3. run newsms +3. run newmoira 4. if you want any queries to be publically executable, change their capacls entries from list_id 2 to 1. 5. run the quel commands in dbopt to create indices on the data. Example: - createdb testsms - quel testsms + createdb sms + quel sms \i newdb \g \q - newsms + newmoira mar 19000 19000 600 mar - quel testsms + quel sms \i dbopt \g \q - renamedb testsms newsms THINGS TO DO: -automate generation of stub procs in newsms.qc +automate generation of stub procs in newmoira.qc