NC1031_UPDATE_MS.sql 3.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. -- IBM Confidential
  2. --
  3. -- OCO Source Materials
  4. --
  5. -- BI and PM: JSM
  6. --
  7. -- (c) Copyright IBM Corp. 2014
  8. --
  9. -- 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.
  10. --
  11. -------------------------------------------------------------------------------
  12. -- NC1031_UPDATE_MS.SQL *DO NOT EDIT* Data Store Version: 1031
  13. -------------------------------------------------------------------------------
  14. -------------------------------------------------------------------------------
  15. --$100-- backup create begin
  16. -------------------------------------------------------------------------------
  17. -------------------------------------------------------------------------------
  18. --$110-- backup inserts begin
  19. -------------------------------------------------------------------------------
  20. -------------------------------------------------------------------------------
  21. --$130-- views drop begin
  22. -------------------------------------------------------------------------------
  23. -------------------------------------------------------------------------------
  24. --$140-- tables drop begin
  25. -------------------------------------------------------------------------------
  26. -------------------------------------------------------------------------------
  27. --$200-- recreate tables begin
  28. -------------------------------------------------------------------------------
  29. -------------------------------------------------------------------------------
  30. --$201-- indices create begin
  31. -------------------------------------------------------------------------------
  32. -------------------------------------------------------------------------------
  33. --$202-- primary keys add begin
  34. -------------------------------------------------------------------------------
  35. -------------------------------------------------------------------------------
  36. --$203-- alter tables begin
  37. -------------------------------------------------------------------------------
  38. -------------------------------------------------------------------------------
  39. --$210-- views create begin
  40. -------------------------------------------------------------------------------
  41. -------------------------------------------------------------------------------
  42. --$220-- server data inserts begin
  43. -------------------------------------------------------------------------------
  44. -------------------------------------------------------------------------------
  45. --$230-- restore inserts begin
  46. -------------------------------------------------------------------------------
  47. INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(1031, 'build no.')
  48. go
  49. -------------------------------------------------------------------------------
  50. --$250-- backup drop begin
  51. -------------------------------------------------------------------------------
  52. -------------------------------------------------------------------------------
  53. --$260-- end sql by function
  54. -------------------------------------------------------------------------------
  55. -- END NC1031_UPDATE_MS.SQL * DO NOT EDIT *
  56. -------------------------------------------------------------------------------