v023_to_v024.sql

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

ALTER TABLE [dbo].[QW_TICKET] ADD [qw_employeeid] int NULL 
GO
ALTER TABLE [dbo].[QW_TICKET] ADD CONSTRAINT [fk_qw_ticket_employee] FOREIGN KEY([qw_employeeid])
REFERENCES [dbo].[QW_EMPLOYEE] ([qw_employeeid])
GO

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