<commit_before>CREATE TABLE AFFILIATION_TYPE ( 
	VER_NBR NUMBER(8,0) DEFAULT 1 NOT NULL, 
	OBJ_ID VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL, 
	AFFILIATION_TYPE_CODE NUMBER(3,0) NOT NULL, 
	DESCRIPTION VARCHAR2(200) NOT NULL, 
	UPDATE_TIMESTAMP DATE NOT NULL, 
	UPDATE_USER VARCHAR2(60) NOT NULL);

drop table award;

CREATE TABLE AWARD(
	AWARD_ID NUMBER NOT NULL,
	DOCUMENT_NUMBER VARCHAR2(10) NOT NULL,
	AWARD_NUMBER VARCHAR2(10) NOT NULL,
	SEQUENCE_NUMBER NUMBER(4) NOT NULL,
	SPONSOR_CODE VARCHAR2(6) NOT NULL,
	STATUS_CODE NUMBER(3) NOT NULL,
	TEMPLATE_CODE NUMBER(5),
	ACCOUNT_NUMBER VARCHAR2(7),
	APPRVD_EQUIPMENT_INDICATOR VARCHAR2(2) NOT NULL,
	APPRVD_FOREIGN_TRIP_INDICATOR VARCHAR2(2) NOT NULL,
	APPRVD_SUBCONTRACT_INDICATOR VARCHAR2(2) NOT NULL,
	AWARD_EFFECTIVE_DATE DATE,
	AWARD_EXECUTION_DATE DATE,
	BEGIN_DATE DATE,
	COST_SHARING_INDICATOR VARCHAR2(2) NOT NULL,
	IDC_INDICATOR VARCHAR2(2) NOT NULL,
	MODIFICATION_NUMBER VARCHAR2(50),
	NSF_CODE VARCHAR2(15),
	PAYMENT_SCHEDULE_INDICATOR VARCHAR2(2) NOT NULL,
	SCIENCE_CODE_INDICATOR VARCHAR2(2) NOT NULL,
	SPECIAL_REVIEW_INDICATOR VARCHAR2(2) NOT NULL,
	SPONSOR_AWARD_NUMBER VARCHAR2(70),
	TRANSFER_SPONSOR_INDICATOR VARCHAR2(2) NOT NULL,
	ACCOUNT_TYPE_CODE NUMBER(3),
	ACTIVITY_TYPE_CODE NUMBER(3) NOT NULL, 
	AWARD_TYPE_CODE NUMBER(3) NOT NULL, 
	PRIME_SPONSOR_CODE VARCHAR2(6), 
	BASIS_OF_PAYMENT_CODE NUMBER(3) NOT NULL,
	CFDA_NUMBER VARCHAR2(6),
	COMPETING_RENEWAL_PRPSL_DUE NUMBER(3),
	DFAFS_NUMBER VARCHAR2(20),
	FINAL_INVOICE_DUE NUMBER(3),
	INVOICE_NUMBER_OF_COPIES NUMBER(1),
	METHOD_OF_PAYMENT_CODE NUMBER(3) NOT NULL,
	NON_COMPETING_CONT_PRPSL_DUE NUMBER(3),
	PAYMENT_INVOICE_FREQ_CODE NUMBER(3),
	PRE_AWARD_AUTHORIZED_AMOUNT NUMBER(12,2),
	PRE_AWARD_EFFECTIVE_DATE DATE,
	PRE_AWARD_IN_AUTHORIZED_AMOUNT   NUMBER(12,2),
    PRE_AWARD_INST_EFFECTIVE_DATE      DATE,
	PROCUREMENT_PRIORITY_CODE VARCHAR2(6),
	PROPOSAL_NUMBER VARCHAR2(8),
	SPECIAL_EB_RATE_OFF_CAMPUS NUMBER(5,2),
	SPECIAL_EB_RATE_ON_CAMPUS NUMBER(5,2),
	SUB_PLAN_FLAG VARCHAR2(1),
	TITLE VARCHAR2(200) NOT NULL,
	VER_NBR NUMBER(8,0) DEFAULT 1 NOT NULL,
	OBJ_ID VARCHAR2(36) DEFAULT SYS_GUID()  NOT NULL,
	UPDATE_TIMESTAMP DATE NOT NULL,
	UPDATE_USER VARCHAR2(10) NOT NULL);

CREATE TABLE AWARD_APPROVED_EQUIPMENT (
   AWARD_APPROVED_EQUIPMENT_ID NUMBER(22,0) NOT NULL,
   AWARD_ID NUMBER(22,0) NOT NULL,
   AWARD_NUMBER varchar2(10) NOT NULL,
   SEQUENCE_NUMBER NUMBER(4) NOT NULL,
   ITEM varchar2(100) NOT NULL,
   VENDOR varchar2(50),
   MODEL varchar2(50),<commit_msg>Database Script changes for Rel 2<commit_after>CREATE TABLE AFFILIATION_TYPE ( 
	VER_NBR NUMBER(8,0) DEFAULT 1 NOT NULL, 
	OBJ_ID VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL, 
	AFFILIATION_TYPE_CODE NUMBER(3,0) NOT NULL, 
	DESCRIPTION VARCHAR2(200) NOT NULL, 
	UPDATE_TIMESTAMP DATE NOT NULL, 
	UPDATE_USER VARCHAR2(60) NOT NULL);

drop table award;

CREATE TABLE AWARD(
	AWARD_ID NUMBER NOT NULL,
	DOCUMENT_NUMBER VARCHAR2(10) NOT NULL,
	AWARD_NUMBER VARCHAR2(10) NOT NULL,
	SEQUENCE_NUMBER NUMBER(4) NOT NULL,
	SPONSOR_CODE VARCHAR2(6) NOT NULL,
	STATUS_CODE NUMBER(3) NOT NULL,
	TEMPLATE_CODE NUMBER(5),
	ACCOUNT_NUMBER VARCHAR2(7),
	APPRVD_EQUIPMENT_INDICATOR VARCHAR2(2) NOT NULL,
	APPRVD_FOREIGN_TRIP_INDICATOR VARCHAR2(2) NOT NULL,
	APPRVD_SUBCONTRACT_INDICATOR VARCHAR2(2) NOT NULL,
	AWARD_EFFECTIVE_DATE DATE,
	AWARD_EXECUTION_DATE DATE,
	BEGIN_DATE DATE,
	COST_SHARING_INDICATOR VARCHAR2(2) NOT NULL,
	IDC_INDICATOR VARCHAR2(2) NOT NULL,
	MODIFICATION_NUMBER VARCHAR2(50),
	NSF_CODE VARCHAR2(15),
	PAYMENT_SCHEDULE_INDICATOR VARCHAR2(2) NOT NULL,
	SCIENCE_CODE_INDICATOR VARCHAR2(2) NOT NULL,
	SPECIAL_REVIEW_INDICATOR VARCHAR2(2) NOT NULL,
	SPONSOR_AWARD_NUMBER VARCHAR2(70),
	TRANSFER_SPONSOR_INDICATOR VARCHAR2(2) NOT NULL,
	ACCOUNT_TYPE_CODE NUMBER(3),
	ACTIVITY_TYPE_CODE NUMBER(3) NOT NULL, 
	AWARD_TYPE_CODE NUMBER(3) NOT NULL, 
	PRIME_SPONSOR_CODE VARCHAR2(6), 
	BASIS_OF_PAYMENT_CODE NUMBER(3),
	CFDA_NUMBER VARCHAR2(6),
	COMPETING_RENEWAL_PRPSL_DUE NUMBER(3),
	DFAFS_NUMBER VARCHAR2(20),
	FINAL_INVOICE_DUE NUMBER(3),
	INVOICE_NUMBER_OF_COPIES NUMBER(1),
	METHOD_OF_PAYMENT_CODE NUMBER(3),
	NON_COMPETING_CONT_PRPSL_DUE NUMBER(3),
	PAYMENT_INVOICE_FREQ_CODE NUMBER(3),
	PRE_AWARD_AUTHORIZED_AMOUNT NUMBER(12,2),
	PRE_AWARD_EFFECTIVE_DATE DATE,
	PRE_AWARD_IN_AUTHORIZED_AMOUNT   NUMBER(12,2),
    PRE_AWARD_INST_EFFECTIVE_DATE      DATE,
	PROCUREMENT_PRIORITY_CODE VARCHAR2(6),
	PROPOSAL_NUMBER VARCHAR2(8),
	SPECIAL_EB_RATE_OFF_CAMPUS NUMBER(5,2),
	SPECIAL_EB_RATE_ON_CAMPUS NUMBER(5,2),
	SUB_PLAN_FLAG VARCHAR2(1),
	TITLE VARCHAR2(200) NOT NULL,
	VER_NBR NUMBER(8,0) DEFAULT 1 NOT NULL,
	OBJ_ID VARCHAR2(36) DEFAULT SYS_GUID()  NOT NULL,
	UPDATE_TIMESTAMP DATE NOT NULL,
	UPDATE_USER VARCHAR2(10) NOT NULL);

CREATE TABLE AWARD_APPROVED_EQUIPMENT (
   AWARD_APPROVED_EQUIPMENT_ID NUMBER(22,0) NOT NULL,
   AWARD_ID NUMBER(22,0) NOT NULL,
   AWARD_NUMBER varchar2(10) NOT NULL,
   SEQUENCE_NUMBER NUMBER(4) NOT NULL,
   ITEM varchar2(100) NOT NULL,
   VENDOR varchar2(50),
   MODEL varchar2(50),
{'fraction_non_alphanumeric': 0.07765830346475508, 'fraction_numerical': 0.04838709677419355, 'mean_word_length': 6.897798742138365, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1793031', 'n_tokens_mistral': 2351, 'n_tokens_neox': 2107, 'n_words': 432}