0_1_99-propertydatabase.sql

这是linux下ssl vpn的实现程序

INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.netbios.lmhosts',2,0,90,'',40,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.netbios.retryCount',2,1,110,'',40,'2',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.netbios.retryTimeout',2,7,120,'s',40,'3000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.netbios.scope',2,0,60,'',40,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.netbios.soTimeout',2,7,100,'s',40,'5000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.netbios.wins',2,0,40,'',40,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.resolveOrder',2,0,160,'',40,'LMHOSTS,WINS,BCAST,DNS',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.smb.client.disablePlainTextPasswords',2,2,140,'',40,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.smb.client.laddr',2,0,130,'',40,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.smb.client.responseTimeout',2,7,150,'s',40,'10000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.smb.client.soTimeout',2,7,150,'s',40,'15000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('profiles.promptForProfileAtLogon',2,2,10,'',50,'false',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('radius.accountingPort',2,1,30,'',200,'1813',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('radius.authenticationMethod',2,3,50,'chap,ppp',200,'chap',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('radius.authenticationPort',2,1,20,'',200,'1812',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('radius.serverHostName',2,0,10,'',200,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('radius.sharedSecret',2,0,40,'',200,'shared_secret',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.administrators',2,5,100,'25x5',60,'Administrators!admin',1);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.lockDuration',2,1,30,'',60,'300',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.maskPersonalAnswers',2,2,130,'',60,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.maxLocksBeforeDisable',2,1,20,'',60,'3',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.maxLogonAttemptsBeforeLock',2,1,10,'',60,'3',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.multipleSessions',2,3,100,'0,1,2',60,'0',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.password.daysBeforeExpiry',2,1,70,'',60,'28',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.password.daysBeforeExpiryWarning',2,1,60,'',60,'21',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.password.pattern',2,0,40,'',60,'.{5,}',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.password.pattern.description',2,6,50,'30x5',60,'Password must be at least five characters in length',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.session.lockSessionOnBrowserClose',2,2,90,'',60,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.session.maxCookieAge',2,1,80,'',60,'900',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.userDatabase',2,3,5,'',60,'builtIn',1);

INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('security.privateKeyMode',2,3,90,'disabled,prompt,automatic',67,'automatic',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('pki.algorithm',2,3,200,'rsa,dsa',67,'rsa',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('pki.bitLength',2,3,210,'512,768,1024,2048',67,'1024',0);

INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('smtp.hostname',2,0,10,'',220,'localhost',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('smtp.login',2,0,30,'',220,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('smtp.port',2,1,20,'',220,'25',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('smtp.senderAddress',2,0,30,'',220,'[e-mail]',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('smtp.startOnStartup',2,2,0,'',220,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('ui.homePage',1,0,20,'',30,'/showHome.do',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('ui.theme',1,0,40,'',30,'/theme/default',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('ui.toolTips',1,2,10,'',30,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('updates.automaticallyConnectToApplicationStore',2,2,0,'',110,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('updates.checkForCoreUpdates',2,2,10,'',110,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('updates.checkForExtensionUpdates',2,2,20,'',110,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('webForwards.cache.clearOnLogout',2,2,50,'',90,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('webForwards.cache.directory',2,0,10,'',90,'%TMP%/webcache',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('webForwards.cache.maxUserAge',2,1,40,'',90,'0',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('webForwards.cache.maxUserObjects',2,1,30,'',90,'10000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('webForwards.cache.maxUserSize',2,1,20,'',90,'10',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('webServer.compression',1,2,120,'',70,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('webServer.sessionInactivityTimeout',1,1,50,'',70,'15',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('webServer.validExternalHostnames',2,5,150,'30x5',70,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('webServer.invalidHostnameAction',2,3,160,'none,redirect,error,disconnect',70,'none',0);

//
// Profiles
//

CREATE CACHED TABLE PROPERTY_PROFILES
(
   ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL ,
   USERNAME VARCHAR(50) not null,
   SHORT_NAME VARCHAR(255) not null,
   DESCRIPTION VARCHAR(255) not null,
   PARENT_RESOURCE_PERMISSION INTEGER,
   DATE_CREATED TIMESTAMP,
   DATE_AMENDED TIMESTAMP
);

INSERT INTO PROPERTY_PROFILES (USERNAME,SHORT_NAME,DESCRIPTION,PARENT_RESOURCE_PERMISSION,DATE_CREATED,DATE_AMENDED) VALUES ('','Default','The default profile.',0,NOW(),NOW());