This document details how to create the ASPNETDB and WEBPREFSDB with just SQL queries. (Each item links out to a separate article)
ALL QUERIES MUST BE RUN IN THE ORDER SPECIFIED
ASPNETDB Creation
The ASPNETDB creation is broken down into 5 scripts.
- Manitou Core - SQL Query - Creating the Database (Sub-Article) (#1 of 5)
- Manitou Core - SQL Query - Adding Tables (Sub-Article) (#2 of 5)
- Manitou Core - SQL Query - Adding Views (Sub-Article) (#3 of 5)
- Manitou Core - SQL Query - Adding Stored Procedures (Sub-Article) (#4 of 5)
- Manitou Core - SQL Query - Adding Roles Functions and Schemas (Sub-Article) (#5 of 5)
Each script will need to be run in the order listed above, otherwise the process may fail.
WEBPREFSDB
The WEBPREFSDB can be added with just two scripts.