Database changes by Dec 24

From: Andriy Shapochka (ashapochk..otmail.com)
Date: Fri Dec 21 2001 - 16:11:30 EST

  • Next message: Andrei Adamchik: "Re: Database changes by Dec 24"

    /*By Rich*/
    UPDATE WB_ITEM_CLASS
    SET CATEGORY_ID = NULL
    WHERE CATEGORY_ID IN(SELECT CATEGORY_ID FROM WB_CATEGORY WHERE CATEGORY_NAME
    = 'Other'
    )

    DELETE WB_CATEGORY WHERE CATEGORY_NAME = 'Other'

    /*By Dmitry*/
    update WB_COMP_TYPE set OPEN_FOLDER_ICON = 'Images/icons/item_mediafolder_o.gif' where COMP_TYPE_ID = 9

    Andriy.

    This archive was generated by hypermail 2.0.0 : Fri Dec 21 2001 - 16:01:45 EST