   PUBLIC_ID NUMBER, 
   VERSION NUMBER(4,2),
   LONG_NAME VARCHAR2(4000) NOT NULL,
-  LOAD_TYPE CHAR(36)
+  LOAD_TYPE CHAR(36),
   LOAD_STATUS NUMBER,
   LOAD_UNLOAD_DATE DATE default sysdate
 );

-- Request new login user "FORMLOADER"


--

alter table SBREXT.FORMS_IN_COLLECTION 
add foreign key (FORM_COLLECTION_IDSEQ) 
references SBREXT.FORM_COLLECTIONS(FORM_COLLECTION_IDSEQ);
commit;

insert into sbrext.DESIGNATION_TYPES_LOV_VIEW (DETL_NAME) values ('Form Loader')
insert into sbrext.DEFINITION_TYPES_LOV_EXT (DEFL_NAME) values ('Form Loader')



-- RETIRED UNLOADEED


-- rem ALTER TABLE FORM_COLLECTIONS MODIFY date_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP

ALTER TABLE SBREXT.FORMS_IN_COLLECTION ADD LOAD_TYPE CHAR(36);

