v031_to_v032.sql

来自「CRM源码This file describes some issues tha」· SQL 代码 · 共 16 行

-- QW_ESCALATION_EVENT
CREATE TABLE dbo.QW_ESCALATION_EVENT (
    QW_ESCEVENTID					INT NOT NULL,
	QW_ESCALATIONID					INT NOT NULL,
    QW_TICKETID						INT NOT NULL,
	QW_NEXT_CHECK			        DATETIME  NOT NULL,
	QW_DATEMODIFIED			        DATETIME  NULL,
  CONSTRAINT PK_QW_ESCALATION_EVENT PRIMARY KEY (QW_ESCEVENTID)
)
go


-- all new update scripts must include a line like this:
UPDATE QX_SYS_PROP SET PROP_VAL = '032' WHERE (PROP_ID = 'DB_APP_VERSION');