Document toolboxDocument toolbox

(2024.2) Create the Database Tables



# 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