v026_to_v027.sql

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

update qw_fieldinfo set qw_enumlabel='Other' where qw_tablename = 'qw_ticket' and qw_columnname='qw_source' and qw_enumvalue =6 
GO
update qw_fieldinfo set qw_enumvalue=3 where qw_tablename = 'qw_interaction' and qw_columnname='qw_source' and qw_enumlabel='Incoming Email'
update qw_fieldinfo set qw_enumvalue=4 where qw_tablename = 'qw_interaction' and qw_columnname='qw_source' and qw_enumlabel='Outgoing Email'
update qw_fieldinfo set qw_enumvalue=5 where qw_tablename = 'qw_interaction' and qw_columnname='qw_source' and qw_enumlabel='Walk-up'
update qw_fieldinfo set qw_enumvalue=6 where qw_tablename = 'qw_interaction' and qw_columnname='qw_source' and qw_enumlabel='Other'
GO

delete from QX_KEYS where tablename='qw_inter_ticket'
GO
ALTER TABLE [dbo].[QW_INTER_TICKET] DROP CONSTRAINT [pk_qw_linkid]
GO
ALTER TABLE [dbo].[QW_INTER_TICKET] DROP CONSTRAINT [un_qw_interticket]
GO
ALTER TABLE [dbo].[QW_INTER_TICKET]DROP COLUMN [qw_linkid]
ALTER TABLE [dbo].[QW_INTER_TICKET]DROP COLUMN [qw_datecreated]
ALTER TABLE [dbo].[QW_INTER_TICKET]DROP COLUMN [qw_createdbyid]
GO
ALTER TABLE [dbo].[QW_INTER_TICKET] 
ADD CONSTRAINT [pk_inter_ticket] PRIMARY KEY CLUSTERED (
	[qw_interactionid] ASC,
	[qw_ticketid] ASC
) WITH FILLFACTOR = 80 ON [PRIMARY]
GO

UPDATE QX_SYS_PROP SET PROP_VAL = '027' WHERE (PROP_ID = 'DB_APP_VERSION');