------------------------2018/12/3------------------------ ALTER TABLE TN_WM_B_TRAY_ITEM_DTL ADD CN_S_VENDOR_NO VARCHAR(32) NULL ALTER TABLE TN_WM_B_TRAY_ITEM_DTL ADD CN_S_VENDOR_NAME VARCHAR(64) NULL ALTER TABLE TN_WM_B_TRAY_ITEM_MST DROP COLUMN CN_S_VENDOR_NO ALTER TABLE TN_WM_B_TRAY_ITEM_MST DROP COLUMN CN_S_VENDOR_NAME ------------------------2018/12/4------------------------ alter table tn_wm_b_location_ext add CN_S_COL char(4), CN_S_FLOOR char(4) ------------------------2018/12/5------------------------ --ÍÐÅÌÎïÁÏÊýÁ¿±í·ÖÅäÁ¿ÉèΪ²»¿ÉΪ¿Õ ALTER TABLE TN_WM_B_TRAY_ITEM_MST ALTER COLUMN CN_F_ALLOC_QTY DECIMAL(18,4) NOT NULL --ÍÐÅÌÎïÁÏÊýÁ¿±í·ÖÅäÁ¿Ä¬ÈÏÖµÉèΪ0 ALTER TABLE TN_WM_B_TRAY_ITEM_MST ADD DEFAULT (0) FOR CN_F_ALLOC_QTY WITH VALUES ------------------------2018/12/5------------------------ alter table tn_wm_tray_info drop COLUMN CN_S_FROM,CN_GUID,CN_S_CREATE_TYPE,CN_S_DEPARTMENT,CN_S_STATUS ------------------------2018/12/6------------------------ alter table tn_wm_operation_type drop COLUMN CN_S_FROM,CN_GUID,CN_S_CREATE_TYPE,CN_S_DEPARTMENT,CN_S_STATUS ------------------------2018/12/8------------------------ create table TN_WM_PRINT_TEMPLET (CN_S_STOCK_CODE varchar(32), CN_S_TEMPLET_TYPE varchar(16), CN_S_TEMPLET_NAME varchar(32), CN_S_PRINTER varchar(32), CN_S_IP varchar(16) ) create table TN_WM_PRINT_TASK ( CN_S_TEMPLET_TYPE varchar(16), CN_S_TEMPLET_NAME varchar(32), CN_S_PRINTER varchar(32), CN_S_IP varchar(16), CN_S_CONTENT varchar(256), CN_T_CREATE datetime ) ------------------------2018/12/8------------------------ alter table TN_WM_PRINT_TEMPLET add CN_S_MAC varchar(36) alter table TN_WM_PRINT_TASK add CN_S_MAC varchar(36) ------------------------2018/12/12------------------------ alter table TN_WM_PRINT_TASK add CN_GUID char(36), CN_C_IS_PRINTED char(36) ------------------------2018/12/13------------------------ --²ßÂÔ±íÐÂÔöÓ¢Îıêʶ×ֶΡ­¡­ ALTER TABLE TN_WM_B_STRATEGY ADD CN_S_CODE VARCHAR(64) --¸ü¸ÄÔö¼Ó¿â´æÒµÎñ×Ó±íµÄ´òÂëÊýÁ¿×Ö¶ÎÃû³Æ exec sp_rename 'TN_WM_INCREASE_INVENTORY_DTL.CN_N_PRINTING_QTY','CN_F_PRINTING_QTY' --¸ü¸Äµ½»õµ¥×Ó±íµÄ´òÂëÊýÁ¿×Ö¶ÎÃû³Æ exec sp_rename 'TN_WM_ARRIVAL_DTL.CN_N_PRINTING_QTY','CN_F_PRINTING_QTY' ------------------------2018/12/14------------------------ alter table TN_WM_PRINT_TEMPLET add CN_GUID varchar(36) ------------------------2018/12/14------------------------ --Ð޸Ŀͻ§Ãû³Æ³¤¶È alter table tn_wm_out_mst alter column [CN_S_CUSTOMER_NAME] varchar(128) --ÐÞ¸ÄÊÖ»úºÅÂ볤¶È alter table tn_wm_out_mst alter column [CN_S_PHONE] varchar(32) --Èë¿âµ¥ÐÂÔöÀÛ¼ÆÒÑÂëÅÌÊýÁ¿ alter table dbo.TN_WM_INCREASE_INVENTORY_DTL add CN_F_ADD_ONTRAY_QTY DECIMAL(18,4) default(0) not null ------------------------2018/12/15------------------------ alter table TN_WM_CHECK_LIST add CN_S_PACKING_UNIT varchar(8), CN_F_PACKING_QTY decimal(18,4), CN_S_PRODUCTION_BATCH varchar(32) ------------------------2018/12/18------------------------ --ÍÐÅÌÎïÁÏÃ÷ϸ±íÐÂÔöGUID×ֶΠALTER TABLE TN_WM_B_TRAY_ITEM_DTL ADD CN_GUID VARCHAR(36) NOT NULL --·Ö¼ð½á¹û±íÔö¼Ó¼ÆÁ¿µ¥Î»×ֶΠALTER TABLE TN_WM_SORTING_RESULT ADD [CN_S_MEASURE_UNIT] VARCHAR(8) ------------------------2018/12/19------------------------ CREATE TABLE [dbo].[TN_WM_B_OWNER]( [CN_GUID] [varchar](36) NOT NULL, [CN_S_OWNER] [varchar](32) NOT NULL, [CN_B_DEFAULT] [bit] NOT NULL, [CN_S_REMARK] [varchar](1024) NULL, CONSTRAINT [PK_TN_WM_B_OWNER] PRIMARY KEY CLUSTERED ( [CN_GUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TN_WM_B_OWNER] ADD CONSTRAINT [DF_TN_WM_B_OWNER_CN_B_DEFAULT] DEFAULT ((0)) FOR [CN_B_DEFAULT] GO ------------------------2018/12/20------------------------ ALTER TABLE TN_WM_PRINT_TEMPLET ADD CN_C_IS_TOOL_PRINT char(1) ,CN_C_IS_UPLOADED char(1) ------------------------2018/12/22------------------------ --²ßÂÔ±íÐÂÔöÐÐÊý¾Ý INSERT INTO [tn_wm_b_strategy_def]([CN_S_GROUP],[CN_S_CODE],[CN_S_NAME],[CN_S_VALUE_TYPE],[CN_N_MIN_VALUE],[CN_N_MAX_VALUE],[CN_S_DIC_NAME],[CN_N_USE],[CN_S_REMARK],[CN_S_CREATOR],[CN_S_CREATOR_BY],[CN_T_CREATE],[CN_S_MODIFY],[CN_S_MODIFY_BY],[CN_T_MODFIY]) VALUES('ϵͳ²ßÂÔ','IsUseK3','ÊÇ·ñÆôÓÃK3¶Ô½Ó','bool',null,null,null,'Y',null,'hh','hh','2018-01-01 00:00:00.000','hh','hh','2018-01-01 00:00:00.000') ------------------------2018/12/24------------------------ alter table TN_WM_SORTING_LOCATION add CN_S_AREA_CODE varchar(32) ------------------------2018/12/25------------------------ alter table TN_WM_B_MOVE_RESULT add CN_S_PRODUCTION_BATCH varchar(32), CN_S_CREATOR char(16) , CN_S_CREATOR_BY varchar(32) , CN_T_CREATE datetime , CN_S_MODIFY varchar(30) , CN_S_MODIFY_BY varchar(30) , CN_T_MODIFY datetime alter table TN_WM_MOVE_DTL add CN_S_PRODUCTION_BATCH varchar(32) --·Ö¼ð½á¹û°ü×°µ¥Î» ALTER TABLE TN_WM_SORTING_RESULT ADD CN_S_PACKING_UNIT VARCHAR(8) --°ü×°ÊýÁ¿ ALTER TABLE TN_WM_SORTING_RESULT ADD CN_F_PACKING_QTY DECIMAL(18,4) ------------------------2018/12/26------------------------ create table TN_WM_OP_STORE_REL ( CN_S_STOCK_CODE varchar(8), CN_S_AREA_CODE varchar(8), CN_S_AREA_TYPE varchar(8), CN_S_OPERATION_CODE varchar(8), CN_C_IS_USE char(1), CN_S_MODIFY char(16), CN_S_MODIFY_BY varchar(16), CN_T_MODIFY datetime ) ------------------------2018/12/28------------------------ --¶©µ¥¼ð»õ¹ØÁª°ü×°µ¥Î» ALTER TABLE TN_WM_ORDER_SORTING_REL ADD CN_S_PACKING_UNIT VARCHAR(8) --¶©µ¥¼ð»õ¹ØÁª°ü×°ÊýÁ¿ ALTER TABLE TN_WM_ORDER_SORTING_REL ADD CN_F_PACKING_QTY DECIMAL(18,4) --ÎïÁ÷¹«Ë¾ÐÂÔöGUID ALTER TABLE TN_WM_LOGISTICS_COMPANY ADD CN_GUID VARCHAR(36) UPDATE TN_WM_LOGISTICS_COMPANY SET CN_GUID=NEWID() --»õÖ÷ÐÂÔö²Ù×÷ÐÅÏ¢ ALTER TABLE TN_WM_B_OWNER ADD [CN_S_CREATOR] VARCHAR(32) ALTER TABLE TN_WM_B_OWNER ADD [CN_S_CREATOR_BY] VARCHAR(32) ALTER TABLE TN_WM_B_OWNER ADD [CN_T_CREATE] DATETIME ALTER TABLE TN_WM_B_OWNER ADD [CN_S_MODIFY] VARCHAR(32) ALTER TABLE TN_WM_B_OWNER ADD [CN_S_MODIFY_BY] VARCHAR(32) ALTER TABLE TN_WM_B_OWNER ADD [CN_T_MODIFY] DATETIME ------------------------2018/12/29------------------------ alter table tn_wm_check_list add CN_S_CREATOR varchar(30) NOT NULL; alter table tn_wm_check_list add CN_S_CREATOR_BY varchar(30) NOT NULL; alter table tn_wm_check_list add CN_T_CREATE DATETIME NOT NULL; alter table tn_wm_check_list add CN_S_MODIFY varchar(30) NULL; alter table tn_wm_check_list add CN_S_MODIFY_BY varchar(30) NULL; alter table tn_wm_check_list add CN_T_MODIFY DATETIME NULL; ------------------------2019/1/2------------------------ --¶©µ¥¼ð»õ¹ØÁªÎ¨Ò»Âë ALTER TABLE TN_WM_ORDER_SORTING_REL ADD CN_S_UNIQUE_CODE VARCHAR(32) ------------------------2019/1/7------------------------ --Èë¿âµÄÉ豸¾ùºâ¡¢ÏïµÀ¾ùºâ¡¢Óɽü¼°Ô¶¿ÉÅäÖà INSERT INTO [dbo].[tn_wm_b_strategy] ([CN_GUID] ,[CN_S_CODE] ,[CN_S_NAME] ,[CN_S_TYPE] ,[CN_C_IS_USE] ,[CN_S_WHERE] ,[CN_S_NOTE]) VALUES ('b175e1b1-63e8-5c95-a183-9550c98ca92d','EquipmentBalance','É豸¾ùºâ','Èë¿â ','Y','1','') GO INSERT INTO [dbo].[tn_wm_b_strategy] ([CN_GUID] ,[CN_S_CODE] ,[CN_S_NAME] ,[CN_S_TYPE] ,[CN_C_IS_USE] ,[CN_S_WHERE] ,[CN_S_NOTE]) VALUES ('b175e1b1-63e8-6c95-a183-9550c98ca92d','EquipmentBalance','ÏïµÀ¾ùºâ','Èë¿â ','Y','1','') GO INSERT INTO [dbo].[tn_wm_b_strategy] ([CN_GUID] ,[CN_S_CODE] ,[CN_S_NAME] ,[CN_S_TYPE] ,[CN_C_IS_USE] ,[CN_S_WHERE] ,[CN_S_NOTE]) VALUES ('b175e1b1-63e8-7c95-a183-9550c98ca92d','EquipmentBalance','Óɽü¼°Ô¶','Èë¿â ','Y','1','') INSERT INTO [dbo].[tn_wm_b_strategy] ([CN_GUID] ,[CN_S_CODE] ,[CN_S_NAME] ,[CN_S_TYPE] ,[CN_C_IS_USE] ,[CN_S_WHERE] ,[CN_S_NOTE]) VALUES ('b175e1b1-63e8-7c95-a183-9650c98ca92d','NoDivideFirstOut','²»²ð°üÓÅÏÈ','³ö¿â ','Y','1','') GO ------------------------2019/1/7------------------------ alter table TN_WM_CHECK_MST add CN_S_OPERATOER varchar(16), CN_S_OPERATOER_NAME varchar(32) CREATE TABLE [dbo].[TN_WM_LOGISTICS_TEMPLET_REL]( [CN_GUID] [varchar](36) NULL, [CN_S_LOGISTICS_FLAG] [varchar](16) NULL, [CN_S_TEMPLET_NAME] [varchar](32) NOT NULL, [CN_S_TEMPLET_GUID] [varchar](36) NULL, [CN_N_IS_DEFAULT] [bit] NULL, [CN_S_CREATOR] [varchar](30) NOT NULL, [CN_S_CREATOR_BY] [varchar](30) NOT NULL, [CN_T_CREATE] [datetime] NOT NULL, [CN_S_MODIFY] [varchar](30) NULL, [CN_S_MODIFY_BY] [varchar](30) NULL, [CN_T_MODIFY] [datetime] NULL ) ------------------------2019/1/9------------------------ alter table TN_WM_ORDER_SORTING_REL add CN_S_MEASURE_UNIT varchar(8) ------------------------2019/1/10------------------------ alter table TN_WM_UP_HISTORY add CN_S_OP_FROM varchar(32), CN_S_FROM_NO varchar(32), CN_S_STOCK_CODE varchar(16), CN_S_STOCK_AREA varchar(16) CREATE TABLE TN_WM_UP_HISTORY( [CN_GUID] [char](36) NOT NULL, [CN_S_LOCATION_CODE] [varchar](32) NULL, [CN_S_TRAY_CODE] [varchar](32) NOT NULL, [CN_S_TRAY_GRID] [varchar](8) NOT NULL, [CN_S_OWNER] [varchar](64) NOT NULL, [CN_S_ITEM_CODE] [varchar](32) NOT NULL, [CN_S_ITEM_NAME] [varchar](64) NULL, [CN_S_FIGURE_NO] [varchar](64) NULL, [CN_S_MODEL] [varchar](64) NULL, [CN_S_ITEM_STATE] [varchar](8) NOT NULL, [CN_F_QUANTITY] [decimal](18, 4) NOT NULL, [CN_S_MEASURE_UNIT] [varchar](8) NOT NULL, [CN_S_LOT_NO] [varchar](20) NOT NULL, [CN_S_PACKING_UNIT] [varchar](8) NULL, [CN_F_PACKING_QTY] [decimal](18, 4) NULL, [CN_S_PRODUCTION_BATCH] [varchar](32) NULL, [CN_S_CREATOR] [varchar](16) NOT NULL, [CN_S_CREATOR_BY] [varchar](32) NOT NULL, [CN_T_CREATE] [datetime] NOT NULL, [CN_S_MODIFY] [varchar](16) NOT NULL, [CN_S_MODIFY_BY] [varchar](32) NOT NULL, [CN_T_MODIFY] [datetime] NOT NULL, [CN_S_OP_FROM] [varchar](32) NULL, [CN_S_FROM_NO] [varchar](32) NULL ) --·Ö¼ðÃ÷ϸ°ü×°µ¥Î» ALTER TABLE TN_WM_SORTING_LOCATION ADD CN_S_PACKING_UNIT VARCHAR(8) --°ü×°ÊýÁ¿ ALTER TABLE TN_WM_SORTING_LOCATION ADD CN_F_PACKING_QTY DECIMAL(18,4) ------------------------2019/1/23------------------------ --AutoBom¿âÐèÒªÐÂÔö´¥·¢Æ÷----¿Í»§µØÖ·±í CREATE TRIGGER TR_AB_B_ADDRESS_INFO ON TN_AB_B_ADDRESS_INFO AFTER INSERT,UPDATE,DELETE AS BEGIN --ÐÂÔö if exists(SELECT 1 FROM inserted) and not exists(SELECT 1 FROM deleted) BEGIN --ÏÈɾ³ý DELETE TN_AB_B_SYNCH_LOG FROM TN_AB_B_SYNCH_LOG A INNER JOIN inserted B ON A.CN_S_GUID=B.CN_GUID AND A.CN_S_TABLE_NAME='TN_AB_B_ADDRESS_INFO' and A.CN_N_OP_FLAG=1 --ÔÚÐÂÔö INSERT INTO TN_AB_B_SYNCH_LOG(CN_S_GUID,CN_S_TABLE_NAME,CN_N_OP_FLAG,CN_T_CREATE) SELECT CN_GUID,'TN_AB_B_ADDRESS_INFO',1,GETDATE() FROM inserted END --ÐÞ¸Ä if exists(SELECT 1 FROM inserted) and exists(SELECT 1 FROM deleted) BEGIN --ÏÈɾ³ý DELETE TN_AB_B_SYNCH_LOG FROM TN_AB_B_SYNCH_LOG A INNER JOIN inserted B ON A.CN_S_GUID=B.CN_GUID AND A.CN_S_TABLE_NAME='TN_AB_B_ADDRESS_INFO' and A.CN_N_OP_FLAG=2 --ÔÚÐÂÔö INSERT INTO TN_AB_B_SYNCH_LOG(CN_S_GUID,CN_S_TABLE_NAME,CN_N_OP_FLAG,CN_T_CREATE) SELECT CN_GUID,'TN_AB_B_ADDRESS_INFO',2,GETDATE() FROM inserted END --ɾ³ý if not exists(SELECT 1 FROM inserted) and exists(SELECT 1 FROM deleted) BEGIN --ÏÈɾ³ý DELETE TN_AB_B_SYNCH_LOG FROM TN_AB_B_SYNCH_LOG A INNER JOIN deleted B ON A.CN_S_GUID=B.CN_GUID AND A.CN_S_TABLE_NAME='TN_AB_B_ADDRESS_INFO' and A.CN_N_OP_FLAG=4 --ÔÚÐÂÔö INSERT INTO TN_AB_B_SYNCH_LOG(CN_S_GUID,CN_S_TABLE_NAME,CN_N_OP_FLAG,CN_T_CREATE) SELECT CN_GUID,'TN_AB_B_ADDRESS_INFO',4,GETDATE() FROM deleted END END --AutoBom¿âÐèÒªÐÂÔö´¥·¢Æ÷----¸¨Öúµ¥Î»±í CREATE TRIGGER TR_AB_B_AUXILIARY_UNIT ON TN_AB_B_AUXILIARY_UNIT AFTER INSERT,UPDATE,DELETE AS BEGIN --ÐÂÔö if exists(SELECT 1 FROM inserted) and not exists(SELECT 1 FROM deleted) BEGIN --ÏÈɾ³ý DELETE TN_AB_B_SYNCH_LOG FROM TN_AB_B_SYNCH_LOG A INNER JOIN inserted B ON A.CN_S_GUID=B.CN_GUID AND A.CN_S_TABLE_NAME='TN_AB_B_AUXILIARY_UNIT' and A.CN_N_OP_FLAG=1 --ÔÚÐÂÔö INSERT INTO TN_AB_B_SYNCH_LOG(CN_S_GUID,CN_S_TABLE_NAME,CN_N_OP_FLAG,CN_T_CREATE) SELECT CN_GUID,'TN_AB_B_AUXILIARY_UNIT',1,GETDATE() FROM inserted END --ÐÞ¸Ä if exists(SELECT 1 FROM inserted) and exists(SELECT 1 FROM deleted) BEGIN --ÏÈɾ³ý DELETE TN_AB_B_SYNCH_LOG FROM TN_AB_B_SYNCH_LOG A INNER JOIN inserted B ON A.CN_S_GUID=B.CN_GUID AND A.CN_S_TABLE_NAME='TN_AB_B_AUXILIARY_UNIT' and A.CN_N_OP_FLAG=2 --ÔÚÐÂÔö INSERT INTO TN_AB_B_SYNCH_LOG(CN_S_GUID,CN_S_TABLE_NAME,CN_N_OP_FLAG,CN_T_CREATE) SELECT CN_GUID,'TN_AB_B_AUXILIARY_UNIT',2,GETDATE() FROM inserted END --ɾ³ý if not exists(SELECT 1 FROM inserted) and exists(SELECT 1 FROM deleted) BEGIN --ÏÈɾ³ý DELETE TN_AB_B_SYNCH_LOG FROM TN_AB_B_SYNCH_LOG A INNER JOIN deleted B ON A.CN_S_GUID=B.CN_GUID AND A.CN_S_TABLE_NAME='TN_AB_B_AUXILIARY_UNIT' and A.CN_N_OP_FLAG=4 --ÔÚÐÂÔö INSERT INTO TN_AB_B_SYNCH_LOG(CN_S_GUID,CN_S_TABLE_NAME,CN_N_OP_FLAG,CN_T_CREATE) SELECT CN_GUID,'TN_AB_B_AUXILIARY_UNIT',4,GETDATE() FROM deleted END END ------------------------2019/1/24------------------------ ALTER TABLE dbo.TN_WM_SORTING_LOCATION ALTER COLUMN CN_F_QUANTITY DECIMAL(18,4) ------------------------2019/1/27------------------------ alter table tn_wm_check_dtl alter column CN_S_MODEL varchar(64) ------------------------2019/1/28------------------------ ALTER TABLE TN_WM_SORTING_LIST ALTER COLUMN CN_T_OPERATE VARCHAR(32) ALTER TABLE dbo.tn_wm_check_list ALTER COLUMN CN_S_MEASURE_UNIT varchar(8) NULL ALTER TABLE TN_WM_ORDER_SORTING_REL ALTER COLUMN CN_F_QUANTITY DECIMAL(18,4) NOT NULL ALTER TABLE TN_WM_ORDER_SORTING_REL ALTER COLUMN CN_F_RECHECK DECIMAL(18,4) ALTER TABLE TN_WM_B_BOX_DTL ALTER COLUMN CN_F_QUANTITY DECIMAL(18,4) CREATE TABLE [dbo].[TN_WM_VERSION_LOG]( [CN_GUID] [varchar](36) NOT NULL, [CN_S_VERSION] [varchar](16) NULL, [CN_T_UPDATE] [datetime] NULL, [CN_S_CONTENT] [varchar](1024) NULL, [CN_N_ORDER] [int] NULL, [CN_S_REMARK] [varchar](256) NULL, CONSTRAINT [PK_TN_WM_UPDATERECORD] PRIMARY KEY CLUSTERED ( [CN_GUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'1', N'V2.1.1', CAST(0x0000A9E300000000 AS DateTime), N'Ôö¼ÓÎïÁ÷±¨±í', 1, NULL) INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'10', N'V2.1.1', CAST(0x0000A9E300000000 AS DateTime), N'ÐÞ¸´ìøµÀbug', 5, NULL) INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'11', N'V2.1.0', CAST(0x0000A9DE00000000 AS DateTime), N'ÐÞ¸´ìøµÀbug', 6, N'') INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'2', N'V2.1.1', CAST(0x0000A9E300000000 AS DateTime), N'Ôö¼ÓÐÞ¸ÄÃÜÂë', 2, NULL) INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'3', N'V2.1.1', CAST(0x0000A9E300000000 AS DateTime), N'µ½»õµ¥Ö§³Ö¶àÑ¡ÉóºË', 3, NULL) INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'4', N'V2.1.1', CAST(0x0000A9E300000000 AS DateTime), N'µ½»õµ¥Ö§³Ö¶àÑ¡ÉóºË', 4, NULL) INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'5', N'V2.1.0', CAST(0x0000A9DE00000000 AS DateTime), N'Ôö¼ÓÈë¿âµ¥¡¢µ½»õµ¥µ¼³ö¡¢³ö¿âµ¥µ¼³ö', 1, N'') INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'6', N'V2.1.0', CAST(0x0000A9DE00000000 AS DateTime), N'Èë¿âµ¥ÅúÁ¿ÉóºË', 2, N'') INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'7', N'V2.1.0', CAST(0x0000A9DE00000000 AS DateTime), N'Xmlµ¼³öÎļþÃû×Ô¶¯´ø³ö', 3, N'') INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'8', N'V2.1.0', CAST(0x0000A9DE00000000 AS DateTime), N'³ö¿âÈÎÎñµç×Ó¿´°å', 4, N'') INSERT [dbo].[TN_WM_VERSION_LOG] ([CN_GUID], [CN_S_VERSION], [CN_T_UPDATE], [CN_S_CONTENT], [CN_N_ORDER], [CN_S_REMARK]) VALUES (N'9', N'V2.1.0', CAST(0x0000A9DE00000000 AS DateTime), N'Ö§³ÖÒ»¸ö¿Í»§¶à¸öµØÖ·', 5, N'') ------------------------2019/2/18------------------------ drop TABLE [dbo].[TN_WM_INTERFACE_DEF] CREATE TABLE [dbo].[TN_WM_INTERFACE_DEF]( [CN_S_INTF_CODE] [varchar](16) NULL, [CN_S_INTF_NAME] [varchar](16) NULL, [CN_S_TYPE] [varchar](16) NULL, [CN_S_URL] [varchar](128) NULL, [CN_S_PROTOCOL] [varchar](32) NULL, [CN_S_MODE] [varchar](8) NULL, [CN_S_DB_TYPE] [varchar](8) NULL, [CN_S_CENTER_TABLE] [varchar](32) NULL, [CN_S_METHOD] [varchar](16) NULL, [CN_C_IS_ENABLE] [char](1) NULL, [CN_S_CREATOR] [varchar](16) NULL, [CN_S_CREATOR_BY] [varchar](16) NULL, [CN_T_CREATE] [datetime] NULL, [CN_S_MODIFY] [varchar](16) NULL, [CN_S_MODIFY_BY] [varchar](16) NULL, [CN_T_MODIFY] [datetime] NULL ) ON [PRIMARY] CREATE TABLE [dbo].[TN_WM_INTERFACE_PARAM]( [CN_S_OTHER_SYS] [varchar](8) NULL, [CN_S_INTF_CODE] [varchar](16) NULL, [CN_S_WMS_PARAM_NAME] [varchar](32) NULL, [CN_S_OTHER_PARAM_NAME] [varchar](32) NULL, [CN_S_FIXED_PARAM_NAME] [varchar](32) NULL, [CN_S_FIXED_PARAM_VALUE] [varchar](32) NULL, [CN_S_FIXED_PARAM_TYPE] [varchar](8) NULL, [CN_C_IS_ENABLE] [char](1) NULL, [CN_S_CREATOR] [varchar](16) NULL, [CN_S_CREATOR_BY] [varchar](16) NULL, [CN_T_CREATE] [datetime] NULL, [CN_S_MODIFY] [varchar](16) NULL, [CN_S_MODIFY_BY] [varchar](16) NULL, [CN_T_MODIFY] [datetime] NULL ) ON [PRIMARY] ------------------------2019/2/19------------------------ --Ö÷±í CREATE TABLE [dbo].[TN_WM_POWER_ENABLED_MST]( [CN_GUID] [varchar](36) NOT NULL, [CN_S_TYPE] [varchar](32) NULL, [CN_S_POWER] [varchar](64) NULL, [CN_B_READONLY] [bit] NOT NULL, [CN_S_REMARK] [varchar](1024) NULL, CONSTRAINT [PK_TN_WM_POWER_ENABLED_MST] PRIMARY KEY CLUSTERED ( [CN_GUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TN_WM_POWER_ENABLED_MST] ADD CONSTRAINT [DF_TN_WM_POWER_ENABLED_MST_CN_B_READONLY] DEFAULT ((0)) FOR [CN_B_READONLY] --×Ó±í CREATE TABLE [dbo].[TN_WM_POWER_ENABLED_DTL]( [CN_GUID] [varchar](36) NOT NULL, [CN_S_PARENTID] [varchar](36) NULL, [CN_S_POWER_CODE] [varchar](32) NOT NULL, [CN_S_POWER_NAME] [varchar](32) NULL, [CN_B_ENABLED] [bit] NOT NULL, [CN_F_WIDTH] [decimal](18, 0) NULL, [CN_S_ALIGN] [varchar](16) NULL, [CN_S_METHOD_NAME] [varchar](32) NULL, [CN_S_REMARK] [varchar](256) NULL, [CN_N_ORDER] [int] NOT NULL, CONSTRAINT [PK_TN_WM_POWER_ENABLED] PRIMARY KEY CLUSTERED ( [CN_GUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TN_WM_POWER_ENABLED_DTL] ADD CONSTRAINT [DF_TN_WM_POWER_ENABLED_CN_B_ENABLED] DEFAULT ((0)) FOR [CN_B_ENABLED] GO ALTER TABLE [dbo].[TN_WM_POWER_ENABLED_DTL] ADD CONSTRAINT [DF_TN_WM_POWER_ENABLED_DTL_CN_N_ORDER] DEFAULT ((0)) FOR [CN_N_ORDER] GO ------------------------2019/2/20------------------------ alter table TN_WM_INTERFACE_PARAM add CN_GUID varchar(36) ------------------------2019/2/25------------------------ alter table TN_WM_SYS_CONFIG add CN_S_TYPE varchar(16) , CN_S_MODIFY varchar(16), CN_S_MODIFY_BY varchar(32) , CN_T_MODIFY datetime ------------------------2019/2/28------------------------ ALTER TABLE TN_WM_OUT_MST ADD [CN_S_SPLIT_FROM] VARCHAR(32) ALTER TABLE TN_WM_OUT_MST ADD [CN_B_CANCEL] BIT ALTER TABLE [DBO].[TN_WM_OUT_MST] ADD CONSTRAINT [DF_TN_WM_OUT_MST_CN_B_CANCEL] DEFAULT ((0)) FOR [CN_B_CANCEL] ------------------------2019/3/5------------------------ drop table tn_wm_in_task drop table tn_wm_out_task drop table TN_WM_TRANSPORT_TASK CREATE TABLE [dbo].[TN_WM_TASK]( [CN_S_TASK_NO] [varchar](32) NOT NULL, [CN_S_TASK_TYPE] [varchar](8) NULL, [CN_S_FROM_OP] [varchar](16) NULL, [CN_S_FROM_NO] [varchar](32) NULL, [CN_S_TRAY_CODE] [varchar](128) NOT NULL, [CN_S_STOCK_CODE] [varchar](32) NULL, [CN_S_START_AREA] [varchar](32) NULL, [CN_S_START_BIT] [varchar](32) NOT NULL, [CN_S_END_AREA] [varchar](32) NULL, [CN_S_END_BIT] [varchar](32) NOT NULL, [CN_S_STATE] [varchar](8) NOT NULL, [CN_T_START] [datetime] NULL, [CN_T_END] [datetime] NULL, [CN_S_BF_TASK_NO] [varchar](32) NULL, [CN_S_AF_TASK_NO] [varchar](32) NULL, [CN_N_PRIORITY] [int] NULL, [CN_S_REMARK] [nvarchar](64) NULL, [CN_S_CREATOR] [varchar](16) NULL, [CN_S_CREATOR_BY] [varchar](32) NULL, [CN_T_CREATE] [datetime] NULL, [CN_S_MODIFY] [varchar](16) NULL, [CN_S_MODIFY_BY] [varchar](32) NULL, [CN_T_MODIFY] [datetime] NULL, CONSTRAINT [PK__tn_wm_in__93E3EBC91DBB5747] PRIMARY KEY CLUSTERED ( [CN_S_TASK_NO] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] ------------------------2019/3/6------------------------ alter table TN_WM_PRINT_TEMPLET add CN_C_IS_FIRST char(1), [CN_C_IS_UPLOADED] char(1), [CN_T_UPLOAD_TIME] datetime, [CN_S_UPLOADOR] varchar(16) alter table tn_wm_b_stock_qty add CN_S_FIGURE_NO varchar(128), CN_S_MODEL varchar(64) , CN_S_MEASURE_UNIT varchar(8) alter table tn_wm_b_area_qty add CN_S_FIGURE_NO varchar(128), CN_S_MODEL varchar(64) , CN_S_MEASURE_UNIT varchar(8) ------------------------2019/3/7------------------------ drop TABLE TN_WM_B_TRAY_ALLOC CREATE TABLE [dbo].[TN_WM_TRAY_ALLOC]( [CN_GUID] [varchar](36) NOT NULL, [CN_S_TRAY_CODE] [varchar](32) NOT NULL, [CN_S_TRAY_GRID] [varchar](4) NULL, [CN_S_SERIAL_NO] [varchar](64) NULL, [CN_S_ITEM_CODE] [varchar](32) NOT NULL, [CN_S_ITEM_NAME] [varchar](64) NULL, [CN_S_ITEM_STATE] [varchar](8) NOT NULL, [CN_S_MODEL] [varchar](32) NULL, [CN_S_FIGURE_NO] [varchar](32) NULL, [CN_F_QUANTITY] [decimal](18, 4) NULL, [CN_S_CREATOR] [varchar](16) NOT NULL, [CN_S_CREATOR_BY] [varchar](32) NOT NULL, [CN_T_CREATE] [datetime] NOT NULL, [CN_S_MODIFY] [varchar](16) NULL, [CN_S_MODIFY_BY] [varchar](32) NULL, [CN_T_MODIFY] [datetime] NULL, CONSTRAINT [PK__tn_wm_b___444F97604D94879B] PRIMARY KEY CLUSTERED ( [CN_GUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[TN_WM_WORK_AREA_PRO]( [CN_GUID] [varchar](36) NOT NULL, [CN_S_TYPE] [varchar](16) NOT NULL, [CN_S_START_AREA_CODE] [varchar](32) NOT NULL, [CN_S_END_AREA_CODE] [varchar](32) NOT NULL, [CN_S_START_AREA_NAME] [varchar](32) NOT NULL, [CN_S_END_AREA_NAME] [varchar](32) NOT NULL, [CN_B_IS_USE] [bit] NOT NULL, [CN_S_CREATOR] [varchar](16) NOT NULL, [CN_S_CREATOR_BY] [varchar](32) NOT NULL, [CN_T_CREATE] [datetime] NOT NULL, [CN_S_MODIFY] [varchar](16) NULL, [CN_S_MODIFY_BY] [varchar](32) NULL, [CN_T_MODIFY] [datetime] NULL, [CN_C_IS_AUTO] [char](1) NULL, [CN_N_PRIORITY] [int] NULL, [CN_S_EXPRESS] [varchar](128) NULL, CONSTRAINT [PK__TN_WM_WO__444F976031A25463] PRIMARY KEY CLUSTERED ( [CN_GUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TN_WM_WORK_AREA_PRO] ADD CONSTRAINT [DF_TN_WM_WORK_AREA_PRO_CN_B_IS_USE] DEFAULT ((0)) FOR [CN_B_IS_USE] GO ------------------------2019/3/8------------------------ ALTER TABLE TN_WM_OUT_DTL ADD CN_S_EXT1 VARCHAR(32) ALTER TABLE TN_WM_OUT_DTL ADD CN_S_EXT2 VARCHAR(32) ALTER TABLE TN_WM_OUT_DTL ADD CN_S_EXT3 VARCHAR(32) ALTER TABLE TN_WM_OUT_DTL ADD CN_S_EXT4 VARCHAR(32) ALTER TABLE TN_WM_OUT_DTL ADD CN_S_EXT5 VARCHAR(32) alter table TN_WM_TRAY_ALLOC add CN_S_SORTING_PLATFROM varchar(32) ------------------------2019/3/12------------------------ --·Ö¼ðÃ÷ϸ±íÒѼðÊý ALTER TABLE TN_WM_SORTING_LOCATION ADD CN_F_PICKED_QTY DECIMAL(18,4) ------------------------2019/3/18------------------------ drop TABLE TN_WM_B_OBJ_LOCATION drop TABLE [dbo].[tn_wm_check_list] CREATE TABLE [dbo].[tn_wm_check_list]( [CN_GUID] [varchar](36) NOT NULL, [CN_S_OP_NO] [varchar](32) NULL, [CN_S_DTL_ROW] [int] NULL, [CN_S_STOCK_CODE] [varchar](32) NULL, [CN_S_STOCK_AREA] [varchar](32) NULL, [CN_S_LOCATION_CODE] [varchar](32) NULL, [CN_S_TRAY_CODE] [varchar](32) NULL, [CN_S_TRAY_GRID] [varchar](8) NULL, [CN_S_ITEM_CODE] [varchar](32) NULL, [CN_S_ITEM_NAME] [varchar](64) NULL, [CN_S_ITEM_STATE] [varchar](8) NULL, [CN_S_OWNER] [varchar](32) NULL, [CN_S_LOT_NO] [varchar](16) NULL, [CN_S_MODEL] [varchar](32) NULL, [CN_S_FIGURE_NO] [varchar](32) NULL, [CN_F_QUANTITY] [decimal](18, 4) NOT NULL, [CN_F_CHECK_QTY] [decimal](18, 4) NOT NULL, [CN_S_MEASURE_UNIT] [varchar](8) NULL, [CN_S_NOTE] [varchar](1024) NULL, [CN_S_ISCHECK] [char](1) NULL, [CN_S_ISWIN] [char](1) NULL, [CN_S_OPERATOR] [varchar](8) NULL, [CN_T_OPERATE] [datetime] NULL, [CN_S_PACK_CODE] [varchar](32) NULL, [CN_S_PACKING_UNIT] [varchar](8) NULL, [CN_F_PACKING_QTY] [decimal](18, 4) NULL, [CN_S_PRODUCTION_BATCH] [varchar](32) NULL, [CN_S_CREATOR] [varchar](30) NOT NULL, [CN_S_CREATOR_BY] [varchar](30) NOT NULL, [CN_T_CREATE] [datetime] NOT NULL, [CN_S_MODIFY] [varchar](30) NULL, [CN_S_MODIFY_BY] [varchar](30) NULL, [CN_T_MODIFY] [datetime] NULL, CONSTRAINT [PK_tn_wm_check_list] PRIMARY KEY CLUSTERED ( [CN_GUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] --ÎïÁÏ»ì·ÅÉÏÏÞ ALTER TABLE TN_WM_TRAY_INFO ADD CN_N_GOODUPLINE INT update TN_WM_TRAY_INFO set CN_N_GOODUPLINE=3 ------------------------2019/3/28------------------------ ALTER TABLE TN_WM_OUT_MST ADD CN_S_OUT_TYPE VARCHAR(32) ALTER TABLE TN_WM_OUT_MST ADD [CN_S_LOT_CODE] VARCHAR(20) ------------------------2019/4/1------------------------ ALTER TABLE TN_WM_OUT_MST ADD CN_S_EXT1 VARCHAR(32) ALTER TABLE TN_WM_OUT_MST ADD CN_S_EXT2 VARCHAR(32) ALTER TABLE TN_WM_OUT_MST ADD CN_S_EXT3 VARCHAR(32) ALTER TABLE TN_WM_OUT_MST ADD CN_S_EXT4 VARCHAR(32) ALTER TABLE TN_WM_OUT_MST ADD CN_S_EXT5 VARCHAR(32) ALTER TABLE TN_WM_TASK ADD CN_B_SENDAMS BIT DEFAULT 0 CREATE TABLE [dbo].[TN_WM_DOWN_HISTORY]( [CN_GUID] [char](36) NOT NULL, [CN_S_LOCATION_CODE] [varchar](32) NULL, [CN_S_TRAY_CODE] [varchar](32) NOT NULL, [CN_S_TRAY_GRID] [varchar](8) NOT NULL, [CN_S_OWNER] [varchar](64) NOT NULL, [CN_S_ITEM_CODE] [varchar](32) NOT NULL, [CN_S_ITEM_NAME] [varchar](64) NULL, [CN_S_FIGURE_NO] [varchar](64) NULL, [CN_S_MODEL] [varchar](64) NULL, [CN_S_ITEM_STATE] [varchar](8) NOT NULL, [CN_F_QUANTITY] [decimal](18, 4) NOT NULL, [CN_S_MEASURE_UNIT] [varchar](8) NOT NULL, [CN_S_LOT_NO] [varchar](20) NULL, [CN_S_PACKING_UINIT] [varchar](8) NULL, [CN_F_PACKING_QTY] [decimal](18, 4) NULL, [CN_S_PRODUCTION_BATCH] [varchar](32) NULL, [CN_S_CREATOR] [varchar](16) NOT NULL, [CN_S_CREATOR_BY] [varchar](32) NOT NULL, [CN_T_CREATE] [datetime] NOT NULL, [CN_S_MODIFY] [varchar](16) NOT NULL, [CN_S_MODIFY_BY] [varchar](32) NOT NULL, [CN_T_MODIFY] [datetime] NOT NULL, [CN_S_OP_FROM] [varchar](32) NULL, [CN_S_FROM_NO] [varchar](32) NULL, [CN_S_STOCK_CODE] [varchar](16) NULL, [CN_S_STOCK_AREA] [varchar](16) NULL, [CN_S_PACKING_UNIT] [varchar](8) NULL ) ON [PRIMARY] ------------------------2019/4/2------------------------ alter table TN_WM_PRINT_TASK alter column CN_S_CONTENT varchar(8000) ------------------------2019/4/3------------------------ alter table tn_wm_b_location_ext alter column CN_S_STOCK_CODE varchar(32) alter table tn_wm_b_location_ext alter column CN_S_ROW varchar(10) alter table tn_wm_b_location_ext alter column CN_S_LOCATION_CODE varchar(32) alter table tn_wm_b_location_ext alter column CN_S_LOCATION_STATE varchar(16) alter table tn_wm_b_location_ext alter column CN_S_USE_STATE varchar(10) alter table tn_wm_b_location_ext alter column CN_S_BEF_FAULT_STATE varchar(10) alter table tn_wm_b_location_ext alter column CN_S_ROADWAY varchar(10) alter table tn_wm_b_location_ext alter column CN_S_COL varchar(8) alter table tn_wm_b_location_ext alter column CN_S_FLOOR varchar(8) ------------------------2019/4/4------------------------ CREATE TABLE [dbo].[TN_REQ_INF_LOG]( [CN_GUID] [char](36) NULL, [CN_S_INTERFACE] [varchar](32) NULL, [CN_S_INTERFACE_NAME] [varchar](32) NULL, [CN_S_REQUEST] [varchar](1024) NULL, [CN_S_RESPONSE] [varchar](1024) NULL, [CN_T_CREATE] [datetime] NULL ) ON [PRIMARY] ------------------------2019/4/10------------------------ alter table TN_WM_B_TRAY_ITEM_MST alter column CN_S_TIMESTAMP char(32) null ALTER TABLE TN_WM_B_TRAY_ITEM_MST ADD PRIMARY KEY (CN_GUID) drop table [SS_WMS].[dbo].[TN_WMS_REQ_LOG] CREATE TABLE [dbo].[TN_WMS_REQ_LOG]( [CN_GUID] [char](36) NULL, [CN_S_INTERFACE] [varchar](32) NULL, [CN_S_INTERFACE_NAME] [varchar](32) NULL, [CN_S_REQUEST] [varchar](1024) NULL, [CN_S_RESPONSE] [varchar](1024) NULL, [CN_T_CREATE] [datetime] NULL ) ON [PRIMARY] ------------------------2019/4/11------------------------ INSERT INTO [dbo].[tn_wm_b_strategy_def] ([CN_S_GROUP] ,[CN_S_CODE] ,[CN_S_NAME] ,[CN_S_VALUE_TYPE] ,[CN_N_MIN_VALUE] ,[CN_N_MAX_VALUE] ,[CN_S_DIC_NAME] ,[CN_N_USE] ,[CN_S_REMARK] ,[CN_S_CREATOR] ,[CN_S_CREATOR_BY] ,[CN_T_CREATE] ,[CN_S_MODIFY] ,[CN_S_MODIFY_BY] ,[CN_T_MODFIY]) VALUES ('Èë¿â²ßÂÔ' ,'UpshelfWithIncrease' ,'Èë¿âÖ±½ÓÉú³ÉÈë¿âµ¥' ,'bool' ,NULL ,NULL ,NULL ,'1' ,NULL ,'hh' ,'ºººÍÐÅÏ¢' ,'2019-03-27 17:08:10.750' ,'hh' ,'ºººÍÐÅÏ¢' ,'2019-03-27 17:08:10.750') GO