server/ses-manage/sql/2019-06/2019-06-18.sql

delete from frame_dict where dict_name='OrgType' and dict_text='学服中心' and dict_value=5;

insert into frame_dict (DICT_NAME, DICT_VALUE, DICT_TEXT, DICT_ORDER)
values ('OrgType', '5', '衔接学校', '5');

-- Create table
create table pl_major_apply_join_school
(
  id             number(10) not null,
  apply_id       number(10),
  join_school_id number(10)
)
;
-- Add comments to the table 
comment on table pl_major_apply_join_school
  is '申报专业-对应的衔接学校表';
-- Add comments to the columns 
comment on column pl_major_apply_join_school.apply_id
  is '专业申报ID，和专业申报表关联';
comment on column pl_major_apply_join_school.join_school_id
  is '衔接学校ID，和cf_organization表关联';
-- Create/Recreate primary, unique and foreign key constraints 
alter table pl_major_apply_join_school
  add constraint PK_PL_MAJOR_APPLY_SCHOOL_ID primary key (ID);

  
-- Create sequence 
create sequence SEQ_PL_MAJOR_APPLY_JOIN_SCHOOL
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;