alter table base_role
add depart_id numeric(18) null
go


create table  base_depart
( 
 id              numeric(18)  not null  identity,
 depart_name     varchar(20)  not null  ,
 constraint base_depart_pk_id primary key(id)
)
go

insert into base_depart(depart_name) values('业务部')
insert into base_depart(depart_name) values('市场部')
go

update base_role set depart_id = 0 where id =1
update base_role set depart_id = 1 where id <> 1
go

alter table buyer_mx_08
add is_warned  numeric(18) default 0 null
go

alter table buyer_mx_08
ALTER COLUMN buyer_id  numeric(18) NULL
go

create table buyer_mx_11
(
 id                        numeric(18)       not null  identity,
 buyer_id                  numeric(18)       not null,  
 title                     varchar(50)           null, 
 user_date                 datetime              null, 
 create_date               datetime              null,  
 user_id                   numeric(18)           null,            
 money                     numeric(18,2)         null,  
 memo                      varchar(2000)         null,  
 is_deleted                numeric(18)           null,
 constraint buyer_mx_11_pk_id primary key(id) 
)

go