v012_to_v013.sql

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

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