-- Run this file so: -- psql -f load-data-model.sql [your database name] -- -- RBM: Alternatively, and for debugging purposes, you can do -- psql -f load-data-model.sql [your database name] 2> datamodel.txt -- which will output the results to the file datamodel.txt that can be -- edited to check if everything went well. -- \i postgres.sql -- rank-for-search.sql allows dumb keyword searching of forums if no -- decent sitewide search mechanism is installed. Probably too slow and -- dumb to use for all portions of a site, or with bboards with a large -- number of accumulated posts. -- -- You must configure postgres using --with-tcl and set UseOpenACSSearch to 1 in -- your OpenACS configuration file to use this. -- \i rank-for-search.sql -- \i lob.sql \i modules.sql \i community-core.sql \i user-groups.sql \i security.sql \i content-sections.sql \i pl-sql.sql \i general-permissions.sql \i news.sql \i calendar.sql \i bboard.sql \i classifieds.sql \i contest.sql \i display.sql \i download.sql \i adserver.sql -- We're using new-ticket for now -- \i ticket.sql \i notification.sql \i new-ticket.sql \i dw.sql \i faq.sql \i glassroom.sql \i homepage.sql \i pull-down-menus.sql \i pull-down-menu-data.sql \i survey-simple.sql \i registry.sql \i spam.sql \i neighbor.sql \i address-book.sql \i bannerideas.sql \i chat.sql \i content-tagging.sql \i email-handler.sql \i glossary.sql \i intranet.sql \i partner.sql \i member-value.sql \i robot-detection.sql \i tools.sql \i file-storage.sql \i bookmarks.sql \i general-comments.sql \i general-links.sql \i portals.sql \i crm.sql \i user-custom.sql \i poll.sql \i press.sql \i curriculum.sql \i ecommerce.sql \i ecommerce-plsql.sql \i events.sql \i table-metadata.sql -- Education is no longer included by default because it causes too much -- trouble with all of its triggers. Load it up manually if you so desire -- BMA (v 3.2.4, 9/21/2000). -- \i education.sql \i wp.sql -- More stuff not in standard ACS \i todo.sql \i sdm.sql