{"type":"doc","content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"codeBlock","content":[{"text":"# Get the Create SQL for each Schema\n/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\n/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\n/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\n\n# Load the tables into each schema\n\n# MySQL\nmysql -h localhost -u pcr360_prod -p -D PCR360_PROD -f < create.sql\nmysql -h localhost -u pcr360_prod -p -D PCR360_PROD_ARCHIVE -f < archive.sql\nmysql -h localhost -u pcr360_prod -p -D PCR360_PROD_METADATA -f < Metadata.sql\n\n# Oracle\nexit | sqlplus \"PCR360_PROD/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(CONNECT_DATA=(SID=)))\" @create.sql\nexit | sqlplus \"PCR360_PROD_ARCHIVE/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(CONNECT_DATA=(SID=)))\" @archive.sql\nexit | sqlplus \"PCR360_PROD_METADATA/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(CONNECT_DATA=(SID=)))\" @metadata.sql","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}],"version":1}

Browser not supported