v012_to_v013.sql

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

--------- Add extra fields to QW_TICKET ----------
ALTER TABLE [dbo].[QW_TICKET] ADD [qw_modifiedbyid] int NULL 
GO
ALTER TABLE [dbo].[QW_TICKET] ADD CONSTRAINT [fk_qw_ticket_modifiedby] FOREIGN KEY([qw_modifiedbyid])
REFERENCES [dbo].[QX_USERS] ([pkey])
GO


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