-- IBM Confidential -- -- OCO Source Materials -- -- BI and PM: JSM -- -- (c) Copyright IBM Corp. 2015 -- -- The source code for this program is not published or otherwise divested of its trade secrets, irrespective of what has been deposited with the U.S. Copyright Office. -- ------------------------------------------------------------------------------- -- NC1032_UPDATE_Hsql.SQL *DO NOT EDIT* Data Store Version: 1032 ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$100-- backup create begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$110-- backup inserts begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$130-- views drop begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$140-- tables drop begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$200-- recreate tables begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$201-- indices create begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$202-- primary keys add begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$203-- alter tables begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$210-- views create begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$220-- server data inserts begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$230-- restore inserts begin ------------------------------------------------------------------------------- INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(1032,'build no.'); ------------------------------------------------------------------------------- --$250-- backup drop begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$260-- end sql by function ------------------------------------------------------------------------------- -- END NC1032_UPDATE_Hsql.SQL * DO NOT EDIT * -------------------------------------------------------------------------------