v023_to_v024.sql

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

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