propertydatabase.properties

这是linux下ssl vpn的实现程序

# This file contains the default resources for the explorer_accounts database
load.properties=SELECT * FROM explorer_property_definition
select.property=SELECT value FROM explorer_properties WHERE ( username=? OR username=? ) AND name=? AND profile_id=? ORDER BY username DESC
insert.property=INSERT INTO explorer_properties (profile_id, username, name, value) VALUES (?,?,?,?)
update.property=UPDATE explorer_properties SET value=? WHERE name=? AND username=? AND profile_id=?
select.global.profiles=SELECT * FROM property_profiles WHERE username = '' OR username=? ORDER BY short_name, username
select.profiles=SELECT * FROM property_profiles WHERE username=? ORDER BY short_name, username
select.profile=SELECT * FROM property_profiles WHERE id=?
insert.profile=INSERT INTO property_profiles (username, short_name, description, parent_resource_permission, date_created, date_amended) VALUES (?,?,?,?,?,?)
insert.profile.lastInsertId=SELECT LAST_INSERT_ID() as id FROM property_profiles
update.profile=UPDATE property_profiles SET short_name=?, description=?, parent_resource_permission=?, date_amended=? WHERE id=?
delete.profile.1=DELETE FROM property_profiles WHERE id=?
delete.profile.2=DELETE FROM explorer_properties WHERE profile_id=?
select.profile.short=SELECT * FROM property_profiles WHERE username=? AND short_name=?