Advertisement
mugs

create user quickstart sql

Feb 26th, 2015
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.02 KB | None | 0 0
  1. INSERT INTO KRIM_ENTITY_T (ACTV_IND,ENTITY_ID,OBJ_ID,VER_NBR)
  2.   VALUES ('Y','1109',uuid(),1);
  3.  
  4. INSERT INTO KRIM_PRNCPL_T (ACTV_IND,ENTITY_ID,OBJ_ID,PRNCPL_ID,PRNCPL_NM,VER_NBR)
  5.   VALUES ('Y','1109',uuid(),'quickstart','quickstart',1);
  6.  
  7. INSERT INTO KRIM_GRP_MBR_T (GRP_ID,GRP_MBR_ID,MBR_ID,MBR_TYP_CD,OBJ_ID,VER_NBR)
  8.   VALUES ('2003','1109','quickstart','P',uuid(),1);
  9.  
  10. INSERT INTO KRIM_GRP_MBR_T (GRP_ID,GRP_MBR_ID,MBR_ID,MBR_TYP_CD,OBJ_ID,VER_NBR)
  11.   VALUES ('2004','1110','quickstart','P',uuid(),1);
  12.  
  13. INSERT INTO KRIM_ENTITY_NM_T (ACTV_IND,DFLT_IND,ENTITY_ID,ENTITY_NM_ID,FIRST_NM,LAST_NM,NM_TYP_CD,OBJ_ID,VER_NBR)
  14.   VALUES ('Y','Y','1109','1209','quickstart','haraka','PRFR',uuid(),1);
  15.  
  16. INSERT INTO KRIM_ENTITY_ENT_TYP_T (ACTV_IND,ENTITY_ID,ENT_TYP_CD,OBJ_ID,VER_NBR)
  17.   VALUES ('Y','1109','PERSON',uuid(),1);
  18.  
  19. INSERT INTO KRIM_ENTITY_EMAIL_T (ACTV_IND,DFLT_IND,EMAIL_ADDR,EMAIL_TYP_CD,ENTITY_EMAIL_ID,ENTITY_ID,ENT_TYP_CD,OBJ_ID,VER_NBR)
  20.   VALUES ('Y','Y','quickstart@indiana.edu','WRK','1209','1109','PERSON',uuid(),1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement