[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 sms" from the shell
2. run the quel commands in newdb to create the tables
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 sms
    quel sms
	    \i newdb
	    \g
	    \q
    newmoira
	    mar

	    19000
	    19000
	    600
	    mar
    quel sms
	    \i dbopt
	    \g
	    \q


THINGS TO DO:

automate generation of stub procs in newmoira.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
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
51e7c423	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
68566efb	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