0_1_99-propertydatabase.sql

这是linux下ssl vpn的实现程序

//
// This is the first database created so is the best place to create the functions
//

CREATE ALIAS PASSWORD FOR 'com.sslexplorer.jdbc.hsqldb.DBFunctions.password';
CREATE ALIAS ENCODE FOR 'com.sslexplorer.jdbc.hsqldb.DBFunctions.encode';
CREATE ALIAS DECODE FOR 'com.sslexplorer.jdbc.hsqldb.DBFunctions.decode';
CREATE ALIAS ENCPASSWORD FOR 'com.sslexplorer.jdbc.hsqldb.DBFunctions.encPassword';
CREATE ALIAS MATCHES FOR 'com.sslexplorer.jdbc.hsqldb.DBFunctions.matches';

// DB configuration

SET PROPERTY "hsqldb.cache_scale" 8;

// 
// Properties
//

CREATE CACHED TABLE EXPLORER_PROPERTIES
(
   USERNAME VARCHAR(255) not null,
   NAME VARCHAR(255) not null,
   VALUE VARCHAR(255) not null,
   PROFILE_ID INTEGER
);

CREATE UNIQUE INDEX SYS_IDX_PROPERTY_CONSTRAINT_1 ON EXPLORER_PROPERTIES
(
  USERNAME,
  NAME,
  PROFILE_ID
);


INSERT INTO EXPLORER_PROPERTIES (USERNAME,NAME,VALUE,PROFILE_ID) VALUES ('','client.heartbeat.interval','40000',0);
INSERT INTO EXPLORER_PROPERTIES (USERNAME,NAME,VALUE,PROFILE_ID) VALUES ('','client.registration.synchronization.timeout','10000',0);
INSERT INTO EXPLORER_PROPERTIES (USERNAME,NAME,VALUE,PROFILE_ID) VALUES ('','client.shutdown.wait','2500',0);
CREATE CACHED TABLE EXPLORER_PROPERTY_DEFINITION
(
   NAME VARCHAR(255) PRIMARY KEY,
   VISIBILITY TINYINT not null,
   TYPE TINYINT not null,
   SORT_ORDER INTEGER not null,
   TYPE_META VARCHAR(255) not null,
   CATEGORY INTEGER not null,
   DEFAULT_VALUE VARCHAR(255) not null,
   HIDDEN TINYINT
);

INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('authenticationScheme.default',2,3,5,'',65,'1',1);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('cifs.guestPassword',2,4,200,'',40,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('cifs.guestUser',2,0,190,'',40,'GUEST',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('cifs.userCacheSize',2,0,170,'',40,'10000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('cifs.userCacheTTL',2,7,180,'s',40,'30000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('client.autoStart',1,2,40,'',10,'false',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('client.browserCommand',1,0,50,'',10,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('client.debug',1,2,70,'',10,'false',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('client.heartbeat.interval',1,7,10,'s',10,'40000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('client.preventSessionTimeoutIfActive',1,2,110,'',10,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('client.registration.synchronization.timeout',1,7,30,'s',10,'60000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('client.shutdown.wait',1,7,20,'s',10,'2500',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('client.tunnel.inactivity',1,7,65,'s',10,'600000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('client.webforward.inactivity',1,7,60,'s',10,'300000',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('clientProxy.hostname',1,0,20,'',15,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('clientProxy.password',1,4,50,'',15,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('clientProxy.port',1,1,30,'',15,'3128',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('clientProxy.preferredAuthentication',1,3,60,'AUTO,BASIC,NTLM',15,'AUTO',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('clientProxy.type',1,3,10,'none,browser,http,https',15,'browser',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('clientProxy.username',1,0,40,'',15,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('fileBrowsing.auth.tryCurrentUser',2,2,70,'',20,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('fileBrowsing.auth.tryGuest',2,2,80,'',20,'true',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.netbios.baddr',2,0,80,'',40,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.netbios.hostname',2,0,50,'',40,'',0);
INSERT INTO EXPLORER_PROPERTY_DEFINITION (NAME,VISIBILITY,TYPE,SORT_ORDER,TYPE_META,CATEGORY,DEFAULT_VALUE,HIDDEN) VALUES ('jcifs.netbios.laddr',2,0,70,'',40,'',0);