mugs

create coeus sponsor sql

Feb 26th, 2015
307
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.06 KB | None | 0 0
  1. INSERT INTO `rolodex`
  2. (`ROLODEX_ID`,`LAST_NAME`,`FIRST_NAME`,`MIDDLE_NAME`,`SUFFIX`,`PREFIX`,`TITLE`,`ORGANIZATION`,`ADDRESS_LINE_1`,`ADDRESS_LINE_2`,`ADDRESS_LINE_3`,`FAX_NUMBER`,`EMAIL_ADDRESS`,`CITY`,`COUNTY`,`STATE`,`POSTAL_CODE`,`COMMENTS`,`PHONE_NUMBER`,`COUNTRY_CODE`,`SPONSOR_CODE`,`OWNED_BY_UNIT`,`SPONSOR_ADDRESS_FLAG`,`DELETE_FLAG`,`CREATE_USER`,`UPDATE_TIMESTAMP`,`UPDATE_USER`,`VER_NBR`,`OBJ_ID`,`ACTV_IND`)
  3. VALUES (11870,NULL,NULL,NULL,NULL,NULL,NULL,'Air Force',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'DC',NULL,NULL,NULL,'USA','000100','000001','Y',NULL,'admin',now(),'admin',1,uuid(),'Y');
  4.  
  5.  
  6. INSERT INTO `sponsor`
  7. (`SPONSOR_CODE`,`SPONSOR_NAME`,`ACRONYM`,`SPONSOR_TYPE_CODE`,`DUN_AND_BRADSTREET_NUMBER`,`DUNS_PLUS_FOUR_NUMBER`,`DODAC_NUMBER`,`CAGE_NUMBER`,`POSTAL_CODE`,`STATE`,`COUNTRY_CODE`,`ROLODEX_ID`,`AUDIT_REPORT_SENT_FOR_FY`,`OWNED_BY_UNIT`,`CREATE_USER`,`UPDATE_TIMESTAMP`,`UPDATE_USER`,`VER_NBR`,`OBJ_ID`,`ACTV_IND`)
  8. VALUES ('000100','Air Force','Air','0',NULL,NULL,NULL,NULL,NULL,'DC','USA',11870,NULL,'000001','admin',now(),'admin',1,uuid(),'Y');
Advertisement
Add Comment
Please, Sign In to add comment