v018_to_v019.sql

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

UPDATE QX_USERS SET USER_TYPE = 0, PASSWORD= ''
GO

UPDATE QX_LOCK SET USER_TYPE_ID = 0
GO

UPDATE QX_USER_PROP SET USER_TYPE_ID = 0
GO

UPDATE QX_USER_LOG SET USER_TYPE_ID = 0
GO

UPDATE QX_REPORT SET OWNER_TYPE = 0
GO

DELETE FROM QX_USER_TYPE WHERE USER_TYPE_ID = 1
GO

UPDATE QX_USER_TYPE SET NAME = 'database_login' WHERE USER_TYPE_ID = 0
GO

insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (0, 'Ticket Created')
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (1, 'Status Change')
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (2, 'Priority Change')
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (3, 'Impact Change')
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (4, 'Type Change')
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (5, 'Agent Change')
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (6, 'Owner Change')
insert into QW_EVENTTYPE (qw_eventid, qw_eventtype) values (7, 'Workgroup Change')
GO

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