[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.

Example:

    createdb testsms
    quel testsms
	    \i newdb
	    \g
	    \q
    newsms
	    mar

	    19000
	    19000
	    600
	    mar
    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.
	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