/* v1.0.1 */
|
--表结构变更
|
alter table dbo.asr_loc_detl add mat_status varchar(10);
|
alter table dbo.asr_wrk_detl add mat_status varchar(10);
|
/* v1.0.2 2021.03.05 */
|
--表结构变更
|
CREATE TABLE [dbo].[asr_loc_normal](
|
[matnr] [varchar](50) NOT NULL,
|
[maktx] [nvarchar](50) NULL,
|
[lgnum] [varchar](255) NULL,
|
[type] [varchar](50) NULL,
|
[mnemonic] [varchar](255) NULL,
|
[supplier] [varchar](255) NULL,
|
[warehouse] [varchar](255) NULL,
|
[brand] [varchar](255) NULL,
|
[anfme] [decimal](24, 9) NULL,
|
[altme] [nvarchar](50) NULL,
|
[bname] [nvarchar](50) NULL,
|
[memo] [varchar](600) NULL,
|
[modi_user] [bigint] NULL,
|
[modi_time] [datetime] NULL,
|
[appe_user] [bigint] NULL,
|
[appe_time] [datetime] NULL,
|
[state] [varchar](10) NULL
|
) ON [PRIMARY]
|
|
CREATE TABLE [dbo].[asr_loc_area](
|
[id] [bigint] IDENTITY(1,1) NOT NULL,
|
[uuid] [varchar](50) NULL,
|
[name] [varchar](255) NULL,
|
[status] [int] NULL,
|
[create_by] [bigint] NULL,
|
[create_time] [datetime] NULL,
|
[update_by] [bigint] NULL,
|
[update_time] [datetime] NULL,
|
[memo] [varchar](255) NULL
|
) ON [PRIMARY]
|
|
/* v1.0.3 2021.03.11 */
|
--表结构变更
|
alter table asr_loc_normal add id int identity(1,1)
|
