systemdatabase.properties

这是linux下ssl vpn的实现程序

createApplicationShortcut.lastInsertId=SELECT LAST_INSERT_ID() as id FROM application_shortcuts
createApplicationShortcut.insert=INSERT INTO application_shortcuts ( application, name, description, parent_resource_permission, date_created, date_amended ) VALUES (?,?,?,?,?,?)
createApplicationShortcut.insertParameters=INSERT INTO application_shortcuts_parameters (shortcut_id, parameter, value) VALUES (?,?,?)
updateApplicationShortcut.update=UPDATE application_shortcuts SET name = ?,description = ?, parent_resource_permission = ?, date_amended = ? WHERE resource_id = ?
updateApplicationShortcut.deleteParameters=DELETE FROM application_shortcuts_parameters WHERE shortcut_id = ?
removeApplicationShortcuts.select=SELECT * FROM application_shortcuts WHERE application=?
removeApplicationShortcuts.delete.shortcuts=DELETE FROM application_shortcuts WHERE application=?
removeApplicationShortcuts.delete.shortcutParameters=DELETE FROM application_shortcuts_parameters WHERE shortcut_id=?
verifyIPAddress.select.type=SELECT address FROM ip_restrictions WHERE type=?
verifyIPAddress.select.count=SELECT COUNT(address) AS authorized FROM ip_restrictions WHERE type=1 OR type=2
verifyIPAddress.select.addressType=SELECT address FROM ip_restrictions WHERE address = ? AND type = ?
createTunnel.select=SELECT tunnel_id FROM tunnels WHERE type = ? AND transport = ? AND username = ? AND source_port = ? AND destination_port = ? AND destination_host = ?
createTunnel.lastInsertId=SELECT LAST_INSERT_ID() as id FROM tunnels
createTunnel.insert=INSERT INTO tunnels (name, description, type, auto_start, transport, username, source_port, destination_port, destination_host, allow_external_hosts, parent_resource_permission, date_created, date_amended) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)
updateTunnel.update=UPDATE tunnels SET name=?,description=?,type=?,auto_start=?,transport=?,username=?,source_port=?,destination_port=?,destination_host=?,allow_external_hosts=?,parent_resource_permission=?,date_amended=? WHERE tunnel_id=?
addIpRestriction.insert=INSERT into ip_restrictions ( address, type ) VALUES(?,?)
getIpRestrictions.select=SELECT * FROM ip_restrictions
removeIpRestriction.delete=DELETE FROM ip_restrictions WHERE restriction_id = ?
removeTunnel.deleteTunnel=DELETE FROM tunnels WHERE tunnel_id = ?
getShortcuts.select=SELECT * FROM application_shortcuts WHERE application = ?
getShortcuts.selectAll=SELECT * FROM application_shortcuts
buildShortcut.select.parameters=SELECT * FROM application_shortcuts_parameters WHERE shortcut_id = ?
getShortcutByName.select=SELECT * FROM application_shortcuts WHERE name=?
getShortcut.select=SELECT * FROM application_shortcuts WHERE resource_id=?
deleteShortcuts.delete.shortcut=DELETE FROM application_shortcuts WHERE application_shortcuts.resource_id=?
deleteShortcuts.delete.shortcutParameters=DELETE FROM application_shortcuts_parameters WHERE application_shortcuts_parameters.shortcut_id=?
addFavorite.insert=INSERT INTO favorites ( type, username, favorite_key) VALUES (?,?,?)
getTunnels.select=SELECT * FROM tunnels
getTunnel.select.id=SELECT * FROM tunnels WHERE tunnel_id=?
getTunnel.select.name=SELECT * FROM tunnels WHERE name=?
getReverseProxyWebForward.select=SELECT webforward_id FROM reverse_proxy_paths WHERE ( username=? OR username=? ) AND locate(path,?) = 1 ORDER BY username DESC  
getWebForward.select.global=SELECT * FROM webforward WHERE destination_url=? AND username=? ORDER BY username DESC
getWebForward.select.user=SELECT * FROM webforward WHERE destination_url=? AND ( username=? OR username=? ) ORDER BY username DESC
getWebForward.select.url=SELECT * FROM webforward WHERE destination_url=?
getWebForward.select.name=SELECT * FROM webforward WHERE short_name=?
getWebForwards.select.type=SELECT * FROM webforward WHERE type=? ORDER BY category,username,short_name ASC
getWebForwards.select.allTypes=SELECT * FROM webforward ORDER BY category,short_name ASC
getWebForward.selectById=SELECT * FROM webforward WHERE id=?
getWebForward.reverseProxy.selectById=SELECT * FROM reverse_proxy_paths WHERE webforward_id=?
getWebForward.reverseProxyOptions.selectById=SELECT * FROM reverse_proxy_options WHERE webforward_id=?
getWebForward.replacementProxyOptions.selectById=SELECT * FROM secure_proxy_options WHERE webforward_id=?
createWebForward.insert=INSERT INTO webforward (destination_url, type, short_name, description, category, parent_resource_permission, date_created, date_amended) VALUES (?,?,?,?,?,?,?,?)
createWebForward.reverseProxy.insert=INSERT INTO reverse_proxy_paths (path,webforward_id) VALUES (?,?)
createWebForward.reverseProxy.path.exists=SELECT * FROM reverse_proxy_paths WHERE path=?
createWebForward.reverseProxy.path.already.exists=SELECT * FROM reverse_proxy_paths WHERE path=? AND webforward_id=?
createWebForward.reverseProxyOptions.insert=INSERT INTO reverse_proxy_options (webforward_id,authentication_username,authentication_password,preferred_authentication_scheme,active_dns,host_header,form_type,form_parameters,charset) VALUES (?,?,?,?,?,?,?,?,?)
createWebForward.replacementProxyOptions.insert=INSERT INTO secure_proxy_options (webforward_id,authentication_username,authentication_password,preferred_authentication_scheme,encoding,restrict_to_hosts,form_type,form_parameters) VALUES (?,?,?,?,?,?,?,?)
createWebForward.lastInsertId=SELECT LAST_INSERT_ID() as id FROM webforward
updateWebForward.update=UPDATE webforward SET type=?, short_name=?, destination_url=?, description=?, category=?, parent_resource_permission=?, date_amended=? WHERE id=?
updateWebForward.reverseProxy.delete=DELETE FROM reverse_proxy_paths WHERE webforward_id=?
updateWebForward.reverseProxy.insert=INSERT INTO reverse_proxy_paths (path,webforward_id) VALUES (?,?)
updateWebForward.reverseProxyOptions.update=UPDATE reverse_proxy_options SET authentication_username=?, authentication_password=?,preferred_authentication_scheme=?,active_dns=?,host_header=?,form_type=?,form_parameters=?,charset=? WHERE webforward_id=? 
updateWebForward.replacementProxyOptions.update=UPDATE secure_proxy_options SET encoding=?,restrict_to_hosts=?,authentication_username=?, authentication_password=?,preferred_authentication_scheme=?,form_type=?,form_parameters=? WHERE webforward_id=?
deleteWebForward.delete.webForward=DELETE FROM webforward WHERE id=?
deleteWebForward.delete.reverseProxy=DELETE FROM reverse_proxy_paths WHERE webforward_id=?
deleteWebForward.delete.reverseProxy.options=DELETE FROM reverse_proxy_options WHERE webforward_id=?
deleteWebForward.delete.replacementProxy.options=DELETE FROM secure_proxy_options WHERE webforward_id=?

# network places
createNetworkPlace.lastInsertId=SELECT LAST_INSERT_ID() as resource_id FROM network_places
getNetworkPlace.select=SELECT * FROM network_places WHERE resource_id=?
getNetworkPlace.select.name=SELECT * FROM network_places WHERE short_name=?
getNetworkPlaces.select=SELECT * FROM network_places
deleteNetworkPlace.delete=DELETE FROM network_places WHERE resource_id=?
updateNetworkPlace.update=UPDATE network_places SET short_name=?,scheme=?,path=?,description=?,read_only=?, allow_resursive=?, no_delete=?, show_hidden=?, parent_resource_permission=?,date_amended=? WHERE resource_id=?
createNetworkPlace.insert=INSERT INTO network_places (scheme, path, short_name, description, read_only, allow_resursive, no_delete, show_hidden, parent_resource_permission, date_created, date_amended) VALUES (?,?,?,?,?,?,?,?,?,?,?)

# favorites
removeUser.delete.favorites=DELETE FROM favorites WHERE username=?
deleteWebForward.delete.favorites=DELETE FROM favorites WHERE type=? AND favorite_key=?
deleteNetworkPlace.delete.favorites.user=DELETE FROM favorites WHERE type=? AND favorite_key=? AND username=?
deleteNetworkPlace.delete.favorites.global=DELETE FROM favorites WHERE type=? AND favorite_key=?
removeApplicationShortcuts.delete.favorites=DELETE FROM favorites WHERE type=? AND favorite_key=?
cleanup.applicationShortcuts.getShortcuts=SELECT shortcut_id,username WHERE username NOT =
removeFavorite.delete=DELETE FROM favorites WHERE type=? AND username=? AND favorite_key=?
getFavorites.selectAllForUser=SELECT * FROM favorites WHERE username=?
getFavorites.selectTypeForUser=SELECT * FROM favorites WHERE username=? AND type=?
getFavorite.select=SELECT * FROM favorites WHERE username=? AND type=? AND favorite_key=?
removeTunnel.deleteFavorite=DELETE FROM favorites WHERE type = ? AND favorite_key = ?
deleteShortcuts.delete.favorite=DELETE FROM favorites WHERE favorite_key = ? AND type = ?

getReplacementsForContent.select.allSites=SELECT * FROM replacements WHERE mime_type=? AND replace_type=? AND site_pattern=?  ORDER BY replace_type,mime_type,sequence ASC
getReplacementsForContent.select=SELECT * FROM replacements WHERE mime_type=? AND replace_type=? AND MATCHES(?,site_pattern)=?  ORDER BY replace_type,mime_type,sequence ASC
deleteReplacements.delete=DELETE FROM replacements WHERE sequence=?
updateReplacements.update=UPDATE replacements SET mime_type=?, site_pattern=?, match_pattern=?, replace_pattern=?, replace_type=? WHERE sequence=?
createReplacement.insert=INSERT INTO replacements ( replace_type, mime_type, site_pattern, match_pattern, replace_pattern ) VALUES (?,?,?,?,?)
createReplacement.lastInsertId=SELECT LAST_INSERT_ID() as id FROM replacements
getReplacements.select=SELECT * FROM replacements ORDER BY replace_type,mime_type,sequence ASC
getReplacement.select=SELECT * FROM replacements WHERE sequence=?
getPersonalAnswers.select=SELECT * FROM personal_answers WHERE username=?
setPersonalAnswers.delete=DELETE FROM personal_answers WHERE username=?
setPersonalAnswers.insert=INSERT INTO personal_answers (username, id, answer) VALUES (?,?,?)
getPersonalAnswer.select=SELECT * FROM personal_answers WHERE username=? AND id=?
removeUser.delete.applicationShortcutParameters=DELETE FROM application_shortcuts_parameters WHERE shortcut_id IN ( SELECT shortcut_id FROM application_shortcuts WHERE username=? )
removeUser.delete.applicationShortcuts=DELETE FROM application_shortcuts WHERE username=?
removeUser.delete.explorerProperties=DELETE FROM explorer_properties WHERE username=?
removeUser.delete.propertyProfiles=DELETE FROM property_profiles WHERE username=?
removeUser.delete.replacements=DELETE FROM replacements WHERE username=?
removeUser.delete.tunnels=DELETE FROM tunnels WHERE username=?
removeUser.delete.webforward=DELETE FROM webforward WHERE username=?

# Authentication schemes
getAuthenticationSchemeSequence.select=SELECT * FROM auth_schemes WHERE resource_id=?
getAuthenticationSchemeSequence.select.scheme=SELECT module_id FROM auth_sequence WHERE scheme_id=? ORDER BY sequence ASC
createAuthenticationSchemeSequence.insert=INSERT INTO auth_schemes (resource_name, resource_description, date_created, date_amended,enabled) VALUES (?,?,?,?,?)
createAuthenticationSchemeSequence.lastInsertId=SELECT LAST_INSERT_ID() as resource_id FROM auth_schemes
deleteAuthenticationSchemeSequence.delete.authSchemes=DELETE FROM auth_schemes WHERE resource_id=?
deleteAuthenticationSchemeSequence.delete.authSequence=DELETE FROM auth_sequence WHERE scheme_id=?
updateAuthenticationSchemeSequence.update=UPDATE auth_schemes SET resource_name=?, resource_description=?, date_amended=?, enabled=? WHERE resource_id=?
updateSequence.delete=DELETE FROM auth_sequence WHERE scheme_id=?
updateSequence.insert=INSERT INTO auth_sequence (scheme_id, module_id, sequence) VALUES (?,?,?)
getAuthenticationSchemeSequences.select=SELECT * FROM auth_schemes
buildAuthenticationSchemeSequences.select.scheme=SELECT module_id FROM auth_sequence WHERE scheme_id=? ORDER BY sequence ASC