v031_to_v032.sql

CRM源码This file describes some issues that should be implemented in future and how it should be imple

-- 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');