Document toolboxDocument toolbox

(2022.1) Create the Database Tables

Owned by Marty Goodrich
Jun 22, 2020
1 min read
# Get the Create SQL for each Schema
/usr/bin/php /var/www/pcr360/prod/cli/zfcli.php -a update.create.download -d -e prod -i /var/www/pcr360/configs/pcr360.ini --js '{"schema":"default"}' > create.sql
/usr/bin/php /var/www/pcr360/prod/cli/zfcli.php -a update.create.download -d -e prod -i /var/www/pcr360/configs/pcr360.ini --js '{"schema":"archive"}' > archive.sql
/usr/bin/php /var/www/pcr360/prod/cli/zfcli.php -a update.create.download -d -e prod -i /var/www/pcr360/configs/pcr360.ini --js '{"schema":"metadata"}' > metadata.sql

# Load the tables into each schema

# MySQL
mysql -h localhost -u pcr360_prod -p<DATABASE_PASSWORD> -D PCR360_PROD -f < create.sql
mysql -h localhost -u pcr360_prod -p<DATABASE_PASSWORD> -D PCR360_PROD_ARCHIVE -f < archive.sql
mysql -h localhost -u pcr360_prod -p<DATABASE_PASSWORD> -D PCR360_PROD_METADATA -f < Metadata.sql

# Oracle
exit | sqlplus "PCR360_PROD/<DATABASE_PASSWORD>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<DB_SERVER>)(PORT=1521))(CONNECT_DATA=(SID=<DB_SID>)))" @create.sql
exit | sqlplus "PCR360_PROD_ARCHIVE/<DATABASE_PASSWORD>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<DB_SERVER>)(PORT=1521))(CONNECT_DATA=(SID=<DB_SID>)))" @archive.sql
exit | sqlplus "PCR360_PROD_METADATA/<DATABASE_PASSWORD>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<DB_SERVER>)(PORT=1521))(CONNECT_DATA=(SID=<DB_SID>)))" @metadata.sql