Details

    • Type: Sub Task Sub Task
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.1
    • Component/s: Database
    • Labels:
      None
    • Similar issues:
      KULRICE-3773Apply the database changes resulting from the doc search date validation fixes to the master DBs
      KULRICE-3700Apply the modifications resulting from the addition of DataDictionarySearchableAttributeTest to the master databases
      KULRICE-10180Database changes for KULRICE-10175
      KULRICE-6303Apply KRMS Master Database changes - compound proposition sequence number mods.
      KULRICE-8462Apply database scripts to the 2.1 and 2.2 mysql master databases
      KULRICE-8552Apply populate group database scripts to the 2.1 and 2.2 master databases
      KULRICE-3719Create a 1.0.1.1 master database
      KULRICE-6305Create a mirror of the master db that is updated nightly for testing database changes
      KULRICE-5060Update master database from 1.1 to 2.0 and update impex
      KULRICE-8370Apply KULRICE-8300 database scripts to the 2.1.2 master database
    • Rice Module:
      KEN

      Description

      As part of KULRICE-3358, the following SQL needs to be executed against the master databases:

      UPDATE KREN_CNTNT_TYP_T SET XSD=REPLACE((SELECT XSD FROM KREN_CNTNT_TYP_T WHERE NM='Event'), 'type="dateTime"', 'type="c:NonEmptyShortStringType"') WHERE NM='Event'
      /

      I've currently set the fix version of this issue to 1.0.2 based on one of my discussions with Garey, but if it is still permissible to apply this change to 1.0.1, then feel free to change the fix version accordingly.

        Activity

        Hide
        Chad Hagstrom added a comment -

        Switching fix version to 1.0.1 based on the discussion at our team meeting.

        Show
        Chad Hagstrom added a comment - Switching fix version to 1.0.1 based on the discussion at our team meeting.
        Hide
        Eric Westfall added a comment -

        Garey, can you make this change to the rice101dba and ricekulcli101dba databases?

        Show
        Eric Westfall added a comment - Garey, can you make this change to the rice101dba and ricekulcli101dba databases?
        Hide
        Jeremy Hanson added a comment -

        Ran this against rice101dba. Ricekulcli101dba doesn't have any data in this table, so nothing was updated there. This has been committed to 10-20-2009.sql

        Show
        Jeremy Hanson added a comment - Ran this against rice101dba. Ricekulcli101dba doesn't have any data in this table, so nothing was updated there. This has been committed to 10-20-2009.sql

          People

          • Assignee:
            Jeremy Hanson
            Reporter:
            Chad Hagstrom
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Structure Helper Panel