_sdl_followup,
};
-static char *gusl_fields[] = {
- "login", "domain_sid",
- "login", "sid", "created",
-};
-
-static struct validate gusl_validate =
-{
- VOuser0,
- 1,
- NULL,
- NULL,
- 0,
- 0,
- 0,
- 0,
- 0,
-};
-
-static char *glsn_fields[] = {
- "name", "domain_sid",
- "name", "sid", "created",
-};
-
-static struct validate glsn_validate =
-{
- VOlist0,
- 1,
- NULL,
- NULL,
- 0,
- 0,
- 0,
- 0,
- 0,
-};
-
-static char *ausl_fields[] = {
- "login", "sid",
-};
-
-static struct validate ausl_validate =
-{
- VOuser0,
- 1,
- "sid",
- "users_id = %d AND sid = '%s'",
- 2,
- 0,
- 0,
- 0,
- 0,
-};
-
-static char *alsn_fields[] = {
- "name", "sid",
-};
-
-static struct validate alsn_validate =
-{
- VOlist0,
- 1,
- "sid",
- "list_id = %d AND sid = '%s'",
- 2,
- 0,
- 0,
- 0,
- 0,
-};
-
-static char *gdds_fields[] = {
- "sid",
-};
-
static char *gcon7_fields[] = {
"name",
"name", "description", "location", "contact",
&_sdl_validate,
},
- {
- /* Q_GUSL - GET_USER_SIDS_BY_LOGIN, v4 */
- "get_user_sids_by_login",
- "gusl",
- 4,
- RETRIEVE,
- "s",
- USERSIDS_TABLE,
- "u.login, us.sid, TO_CHAR(us.created, 'YYYY-MM-DD HH24:MI:SS') FROM users u, usersids us",
- gusl_fields,
- 3,
- "us.users_id = %d AND u.users_id = us.users_id AND SUBSTR(us.sid, 1, LENGTH(us.sid)-8) = '%s'",
- 2,
- NULL,
- &gusl_validate,
- },
-
- {
- /* Q_AUSL - ADD_USER_SID_BY_LOGIN, v4 */
- "add_user_sid_by_login",
- "ausl",
- 4,
- APPEND,
- "s",
- USERSIDS_TABLE,
- "INTO usersids (users_id, sid) VALUES (%d, '%s')",
- ausl_fields,
- 2,
- NULL,
- 0,
- NULL,
- &ausl_validate,
- },
-
- {
- /* Q_GLSN - GET_LIST_SIDS_BY_NAME, v4 */
- "get_list_sids_by_name",
- "glsn",
- 4,
- RETRIEVE,
- "s",
- LISTSIDS_TABLE,
- "l.name, ls.sid, TO_CHAR(ls.created, 'YYYY-MM-DD HH24:MI:SS') FROM list l, listsids ls",
- glsn_fields,
- 3,
- "ls.list_id = %d AND l.list_id = ls.list_id AND SUBSTR(ls.sid, 1, LENGTH(ls.sid)-8) = '%s'",
- 2,
- NULL,
- &glsn_validate,
- },
-
- {
- /* Q_ALSN - ADD_LIST_SID_BY_NAME, v4 */
- "add_list_sid_by_name",
- "alsn",
- 4,
- APPEND,
- "s",
- LISTSIDS_TABLE,
- "INTO listsids (list_id, sid) VALUES (%d, '%s')",
- alsn_fields,
- 2,
- NULL,
- 0,
- NULL,
- &alsn_validate,
- },
-
- {
- /* Q_GDDS - GET_DISTINCT_DOMAIN_SIDS, v4 */
- "get_distinct_domain_sids",
- "gdds",
- 4,
- RETRIEVE,
- "s",
- USERSIDS_TABLE,
- "DISTINCT SUBSTR(sid, 1, LENGTH(sid)-8) FROM usersids",
- gdds_fields,
- 1,
- NULL,
- 0,
- NULL,
- NULL,
- },
-
{
/* Q_GCON - GET_CONTAINER, v7 */
"get_container",