/mit/moiradev/db/README: $Header$

This directory contains stuff necessary to create and initialize a
Moira database.  Note that some other directories rely on files here
(notably newdb), and that the newmoira program relies on other files.

STEPS TO CREATE A DATABASE (Ingres-specific instructions):

-1.Make sure there is enough disk space on the partition which is to
   hold the database.  Building the indexes for Athena takes something
   like 50 Meg of free disk space, *after* the ~100 Meg for the base DB.
0. If necessary, run "destroydb moira" from the shell. [a few seconds]
1. Run "createdb moira" from the shell. [a minute or so]
2. Run the sql commands in src/db/schema to create the tables. [a few seconds]
3. Run mrrestore. [10-20 hours on a decstation]
4. If you want any queries to be publically executable, change their
   capacls entries from list_id 2 to 1.
5. Run the sql commands in src/db/dbopt to create indices on the data.
   Any failures are probably due to insufficient disk space.  (Check
   /ingres/files/errlog.log to make sure.) [ <= 1 hour on a decstation]  
  

Example:

    createdb moira
    sql moira
	\include schema
	\go
	\quit
    /moira/bin/mrrestore moira
	yes
	yes
	<path prefix with trailing '/'>
	yes
    sql moira
	\include dbopt
	\quit


THINGS TO DO:

automate generation of stub procs in newmoira.qc