[moira.git] / db / README

/mit/smsdev/db/README: $Header$

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.

STEPS TO CREATE A DATABASE:

1. run "createdb" from the shell
2. run the quel commands in newdb to create the tables
3. run newsms
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
	    \i newdb
	    \g
	    \q
    newsms
	    mar

	    19000
	    19000
	    600
	    mar
    quel testsms
	    \i dbopt
	    \g
	    \q
    renamedb testsms newsms


THINGS TO DO:

automate generation of stub procs in newsms.qc
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.
2dc40abd	14	5. run the quel commands in dbopt to create indices on the data.
51e7c423	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
2dc40abd	30	quel testsms
	31	\i dbopt
	32	\g
	33	\q
51e7c423	34	renamedb testsms newsms
	35
	36
	37	THINGS TO DO:
	38
	39	automate generation of stub procs in newsms.qc