| DROP TABLE CONFIGURATION IF EXISTS; |
| CREATE TABLE CONFIGURATION(KEY VARCHAR NOT NULL PRIMARY KEY,VALUE VARCHAR); |
| |
| DROP TABLE CONFIGURATIONS IF EXISTS; |
| CREATE TABLE CONFIGURATIONS(NAME VARCHAR NOT NULL,KEY VARCHAR NOT NULL,VALUE VARCHAR,CONSTRAINT SYS_PK_CONFIGURATIONS PRIMARY KEY(NAME,KEY)); |
| |
| DROP TABLE CONFIGURATIONLIST IF EXISTS; |
| CREATE TABLE CONFIGURATIONLIST(ID VARCHAR NOT NULL PRIMARY KEY, KEY VARCHAR NOT NULL,VALUE VARCHAR);; |
| ; |
| GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC; |
| GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC; |
| CREATE USER SA PASSWORD "" ADMIN; |
| CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"; |
| CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"; |
| CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"; |
| CREATE ALIAS HEXTORAW FOR "org.hsqldb.Library.hexToRaw"; |
| CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"; |
| CREATE ALIAS ABS FOR "org.hsqldb.Library.abs"; |
| CREATE ALIAS POWER FOR "java.lang.Math.pow"; |
| CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"; |
| CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"; |
| CREATE ALIAS PI FOR "org.hsqldb.Library.pi"; |
| CREATE ALIAS RAWTOHEX FOR "org.hsqldb.Library.rawToHex"; |
| CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"; |
| CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"; |
| CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"; |
| CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"; |
| CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"; |
| CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"; |
| CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"; |
| CREATE ALIAS TAN FOR "java.lang.Math.tan"; |
| CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"; |
| CREATE ALIAS FLOOR FOR "java.lang.Math.floor"; |
| CREATE ALIAS NOW FOR "org.hsqldb.Library.now"; |
| CREATE ALIAS ACOS FOR "java.lang.Math.acos"; |
| CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"; |
| CREATE ALIAS CEILING FOR "java.lang.Math.ceil"; |
| CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"; |
| CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"; |
| CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"; |
| CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"; |
| CREATE ALIAS ASIN FOR "java.lang.Math.asin"; |
| CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"; |
| CREATE ALIAS EXP FOR "java.lang.Math.exp"; |
| CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"; |
| CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"; |
| CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"; |
| CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"; |
| CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"; |
| CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"; |
| CREATE ALIAS COT FOR "org.hsqldb.Library.cot"; |
| CREATE ALIAS COS FOR "java.lang.Math.cos"; |
| CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"; |
| CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"; |
| CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"; |
| CREATE ALIAS LOG FOR "java.lang.Math.log"; |
| CREATE ALIAS SIN FOR "java.lang.Math.sin"; |
| CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"; |
| CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"; |
| CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"; |
| CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"; |
| CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"; |
| CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"; |
| CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"; |
| CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"; |
| CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"; |
| CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"; |
| CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"; |
| CREATE ALIAS USER FOR "org.hsqldb.Library.user"; |
| CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"; |
| CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"; |
| CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"; |
| CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"; |
| CREATE ALIAS ATAN FOR "java.lang.Math.atan"; |
| CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"; |
| CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"; |
| CREATE ALIAS RAND FOR "java.lang.Math.random"; |
| CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"; |
| CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"; |
| CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"; |