Utils

ALTER TABLE spex.TB_R_REPORT_PROBLEM ADD REFILL_QTY INT NULL;

USE [SPEX_DB]
GO
/** Object:  Table [dbo].[TB_R_REFILL]    Script Date: 2/11/2020 5:50:50 PM **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_R_REFILL](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [TRANSFER_NO] [VARCHAR](MAX) NOT NULL,
    [BT_NO] [VARCHAR](MAX) NOT NULL,
    [PART_NO] [VARCHAR](MAX) NOT NULL,
    [QTY] [INT] NULL,
    [CREATED_BY] [VARCHAR](MAX) NOT NULL,
    [CREATED_DT] [datetime] NOT NULL,
    [CHANGED_BY] [VARCHAR](MAX) NULL,
    [CHANGED_DT] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE dbo.TB_R_REFILL ADD SOURCE VARCHAR (MAX) NULL;
ALTER TABLE dbo.TB_R_REFILL ADD RACK_ADDRESS VARCHAR (MAX) NULL;
-- ALTER TABLE dbo.TB_R_REFILL ADD IS_BINNING INT  NOT NULL DEFAULT(0);