Skip to content

Instantly share code, notes, and snippets.

@gavinrogers

gavinrogers/sql

Created November 15, 2013 14:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gavinrogers/7485123 to your computer and use it in GitHub Desktop.
Save gavinrogers/7485123 to your computer and use it in GitHub Desktop.
Download ZIP
sql
Raw
sql
sqlite> SELECT me.USER_ID, me.CRSID, me.ENGID, me.UID, me.GECOS, me.HOMEDIR, me.PASSWORD_EXPIRY_DATE, me.PROPAGATION, me.STATUS_ID, me.STATUS_DATE, capabilities.CAPABILITIES_ID, capabilities.USER_ID, capabilities.AD_ENABLED, capabilities.AD_PASSWORD, capabilities.AUTOMOUNTER, capabilities.TRUST_ALLOWED, capabilities.UNIX_PASSWD, capabilities.UNIX_ENABLED, capabilities.PROP_TEACH, capabilities.PROP_MAIL, capabilities.PROP_DIVA, capabilities.PROP_DIVB, capabilities.PROP_DIVF, capabilities.PROP_FLUID, capabilities.PROP_STRUCT, capabilities.PROP_WHITTLE, capabilities.PROP_WORKS, capabilities.PROP_TEST, status.STATUS_ID, status.STATUS_NAME, status.AD_PASSWORD, status.AUTOMOUNTER, status.AD_ENABLED, status.TRUST_ALLOWED, status.UNIX_PASSWD, status.UNIX_ENABLED, status.PROP_TEACH, status.PROP_MAIL, status.PROP_DIVA, status.PROP_DIVB, status.PROP_DIVF, status.PROP_FLUID, status.PROP_STRUCT, status.PROP_WHITTLE, status.PROP_WORKS, status.PROP_TEST, passwordchanged.USER_ATTRIBUTE_ID, passwordchanged.USER_ID, passwordchanged.ATTRIBUTE_ID, passwordchanged.ATTRIBUTE_VALUE, passwordchanged.ATTRIBUTE_EFFECTIVE_DATE, passwordchanged.ATTRIBUTE_EXPIRY_DATE, attribute.ATTRIBUTE_ID, attribute.ATTRIBUTE_NAME, primarygroup.GROUP_MEMBERSHIP_ID, primarygroup.USER_ID, primarygroup.GROUP_ID, primarygroup.PRIMARY_GROUP, primarygroup.AFFILIATION_GROUP, mygroup.GROUP_ID, mygroup.GID, mygroup.GROUP_NAME, mygroup.GROUP_DESC, affiliationgroup.GROUP_MEMBERSHIP_ID, affiliationgroup.USER_ID, affiliationgroup.GROUP_ID, affiliationgroup.PRIMARY_GROUP, affiliationgroup.AFFILIATION_GROUP, mygroup_2.GROUP_ID, mygroup_2.GID, mygroup_2.GROUP_NAME, mygroup_2.GROUP_DESC FROM PP_USERS me JOIN PP_USER_CAPABILITIES capabilities ON capabilities.USER_ID = me.USER_ID JOIN PP_STATUSES status ON status.STATUS_ID = me.STATUS_ID JOIN PP_USER_ATTRIBUTES passwordchanged ON passwordchanged.USER_ID = me.USER_ID JOIN PP_ATTRIBUTES attribute ON attribute.ATTRIBUTE_ID = passwordchanged.ATTRIBUTE_ID JOIN PP_GROUP_MEMBERSHIPS primarygroup ON primarygroup.USER_ID = me.USER_ID JOIN PP_GROUPS mygroup ON mygroup.GROUP_ID = primarygroup.GROUP_ID JOIN PP_GROUP_MEMBERSHIPS affiliationgroup ON affiliationgroup.USER_ID = me.USER_ID JOIN PP_GROUPS mygroup_2 ON mygroup_2.GROUP_ID = affiliationgroup.GROUP_ID WHERE ( ( me.CRSID = '' AND me.ENGID = 'tw309eng') );
498||tw309eng|4309|Temporary Course ID|/users/courses/tw309eng|1485014907||10||498|498|0|0|1|0|0|0|1||||||||||10|not-set|0|1|0|0|0|0|1|0|0|0|0|0|0|0|0|0|498|498|1|tcb import|1355414907|1485014907|1|password_changed|987|498|582|1|0|582|104309|tw309eng||987|498|582|1|0|582|104309|tw309eng|
498||tw309eng|4309|Temporary Course ID|/users/courses/tw309eng|1485014907||10||498|498|0|0|1|0|0|0|1||||||||||10|not-set|0|1|0|0|0|0|1|0|0|0|0|0|0|0|0|0|498|498|1|tcb import|1355414907|1485014907|1|password_changed|987|498|582|1|0|582|104309|tw309eng||988|498|6|0|1|6|4000||
498||tw309eng|4309|Temporary Course ID|/users/courses/tw309eng|1485014907||10||498|498|0|0|1|0|0|0|1||||||||||10|not-set|0|1|0|0|0|0|1|0|0|0|0|0|0|0|0|0|498|498|1|tcb import|1355414907|1485014907|1|password_changed|988|498|6|0|1|6|4000|||987|498|582|1|0|582|104309|tw309eng|
498||tw309eng|4309|Temporary Course ID|/users/courses/tw309eng|1485014907||10||498|498|0|0|1|0|0|0|1||||||||||10|not-set|0|1|0|0|0|0|1|0|0|0|0|0|0|0|0|0|498|498|1|tcb import|1355414907|1485014907|1|password_changed|988|498|6|0|1|6|4000|||988|498|6|0|1|6|4000||
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment