[4] | 1 | # Database settings for sqlite 3.x |
---|
| 2 | # |
---|
| 3 | # General information on database access can be found here: |
---|
| 4 | # http://weka.wikispaces.com/Databases |
---|
| 5 | # |
---|
| 6 | # url: http://www.sqlite.org/ |
---|
| 7 | # jdbc: http://www.zentus.com/sqlitejdbc/ |
---|
| 8 | # author: Fracpete (fracpete at waikato dot ac dot nz) |
---|
| 9 | # version: $Revision: 5837 $ |
---|
| 10 | |
---|
| 11 | # JDBC driver (comma-separated list) |
---|
| 12 | jdbcDriver=org.sqlite.JDBC |
---|
| 13 | |
---|
| 14 | # database URL |
---|
| 15 | jdbcURL=jdbc:sqlite:/path/to/database.db |
---|
| 16 | |
---|
| 17 | # specific data types |
---|
| 18 | # string, getString() = 0; --> nominal |
---|
| 19 | # boolean, getBoolean() = 1; --> nominal |
---|
| 20 | # double, getDouble() = 2; --> numeric |
---|
| 21 | # byte, getByte() = 3; --> numeric |
---|
| 22 | # short, getByte()= 4; --> numeric |
---|
| 23 | # int, getInteger() = 5; --> numeric |
---|
| 24 | # long, getLong() = 6; --> numeric |
---|
| 25 | # float, getFloat() = 7; --> numeric |
---|
| 26 | # date, getDate() = 8; --> date |
---|
| 27 | # text, getString() = 9; --> string |
---|
| 28 | # time, getTime() = 10; --> date |
---|
| 29 | |
---|
| 30 | # other options |
---|
| 31 | CREATE_DOUBLE=DOUBLE |
---|
| 32 | CREATE_STRING=TEXT |
---|
| 33 | CREATE_INT=INT |
---|
| 34 | CREATE_DATE=DATETIME |
---|
| 35 | DateFormat=yyyy-MM-dd HH:mm:ss |
---|
| 36 | checkUpperCaseNames=false |
---|
| 37 | checkLowerCaseNames=false |
---|
| 38 | checkForTable=true |
---|
| 39 | |
---|
| 40 | # All the reserved keywords for this database |
---|
| 41 | # Based on the keywords listed at the following URL (2009-04-13): |
---|
| 42 | # http://www.sqlite.org/lang_keywords.html |
---|
| 43 | Keywords=\ |
---|
| 44 | ABORT,\ |
---|
| 45 | ADD,\ |
---|
| 46 | AFTER,\ |
---|
| 47 | ALL,\ |
---|
| 48 | ALTER,\ |
---|
| 49 | ANALYZE,\ |
---|
| 50 | AND,\ |
---|
| 51 | AS,\ |
---|
| 52 | ASC,\ |
---|
| 53 | ATTACH,\ |
---|
| 54 | AUTOINCREMENT,\ |
---|
| 55 | BEFORE,\ |
---|
| 56 | BEGIN,\ |
---|
| 57 | BETWEEN,\ |
---|
| 58 | BY,\ |
---|
| 59 | CASCADE,\ |
---|
| 60 | CASE,\ |
---|
| 61 | CAST,\ |
---|
| 62 | CHECK,\ |
---|
| 63 | COLLATE,\ |
---|
| 64 | COLUMN,\ |
---|
| 65 | COMMIT,\ |
---|
| 66 | CONFLICT,\ |
---|
| 67 | CONSTRAINT,\ |
---|
| 68 | CREATE,\ |
---|
| 69 | CROSS,\ |
---|
| 70 | CURRENT_DATE,\ |
---|
| 71 | CURRENT_TIME,\ |
---|
| 72 | CURRENT_TIMESTAMP,\ |
---|
| 73 | DATABASE,\ |
---|
| 74 | DEFAULT,\ |
---|
| 75 | DEFERRABLE,\ |
---|
| 76 | DEFERRED,\ |
---|
| 77 | DELETE,\ |
---|
| 78 | DESC,\ |
---|
| 79 | DETACH,\ |
---|
| 80 | DISTINCT,\ |
---|
| 81 | DROP,\ |
---|
| 82 | EACH,\ |
---|
| 83 | ELSE,\ |
---|
| 84 | END,\ |
---|
| 85 | ESCAPE,\ |
---|
| 86 | EXCEPT,\ |
---|
| 87 | EXCLUSIVE,\ |
---|
| 88 | EXISTS,\ |
---|
| 89 | EXPLAIN,\ |
---|
| 90 | FAIL,\ |
---|
| 91 | FOR,\ |
---|
| 92 | FOREIGN,\ |
---|
| 93 | FROM,\ |
---|
| 94 | FULL,\ |
---|
| 95 | GLOB,\ |
---|
| 96 | GROUP,\ |
---|
| 97 | HAVING,\ |
---|
| 98 | IF,\ |
---|
| 99 | IGNORE,\ |
---|
| 100 | IMMEDIATE,\ |
---|
| 101 | IN,\ |
---|
| 102 | INDEX,\ |
---|
| 103 | INDEXED,\ |
---|
| 104 | INITIALLY,\ |
---|
| 105 | INNER,\ |
---|
| 106 | INSERT,\ |
---|
| 107 | INSTEAD,\ |
---|
| 108 | INTERSECT,\ |
---|
| 109 | INTO,\ |
---|
| 110 | IS,\ |
---|
| 111 | ISNULL,\ |
---|
| 112 | JOIN,\ |
---|
| 113 | KEY,\ |
---|
| 114 | LEFT,\ |
---|
| 115 | LIKE,\ |
---|
| 116 | LIMIT,\ |
---|
| 117 | MATCH,\ |
---|
| 118 | NATURAL,\ |
---|
| 119 | NOT,\ |
---|
| 120 | NOTNULL,\ |
---|
| 121 | NULL,\ |
---|
| 122 | OF,\ |
---|
| 123 | OFFSET,\ |
---|
| 124 | ON,\ |
---|
| 125 | OR,\ |
---|
| 126 | ORDER,\ |
---|
| 127 | OUTER,\ |
---|
| 128 | PLAN,\ |
---|
| 129 | PRAGMA,\ |
---|
| 130 | PRIMARY,\ |
---|
| 131 | QUERY,\ |
---|
| 132 | RAISE,\ |
---|
| 133 | REFERENCES,\ |
---|
| 134 | REGEXP,\ |
---|
| 135 | REINDEX,\ |
---|
| 136 | RELEASE,\ |
---|
| 137 | RENAME,\ |
---|
| 138 | REPLACE,\ |
---|
| 139 | RESTRICT,\ |
---|
| 140 | RIGHT,\ |
---|
| 141 | ROLLBACK,\ |
---|
| 142 | ROW,\ |
---|
| 143 | SAVEPOINT,\ |
---|
| 144 | SELECT,\ |
---|
| 145 | SET,\ |
---|
| 146 | TABLE,\ |
---|
| 147 | TEMP,\ |
---|
| 148 | TEMPORARY,\ |
---|
| 149 | THEN,\ |
---|
| 150 | TO,\ |
---|
| 151 | TRANSACTION,\ |
---|
| 152 | TRIGGER,\ |
---|
| 153 | UNION,\ |
---|
| 154 | UNIQUE,\ |
---|
| 155 | UPDATE,\ |
---|
| 156 | USING,\ |
---|
| 157 | VACUUM,\ |
---|
| 158 | VALUES,\ |
---|
| 159 | VIEW,\ |
---|
| 160 | VIRTUAL,\ |
---|
| 161 | WHEN,\ |
---|
| 162 | WHERE |
---|
| 163 | |
---|
| 164 | # The character to append to attribute names to avoid exceptions due to |
---|
| 165 | # clashes between keywords and attribute names |
---|
| 166 | KeywordsMaskChar=_ |
---|
| 167 | |
---|
| 168 | #flags for loading and saving instances using DatabaseLoader/Saver |
---|
| 169 | nominalToStringLimit=50 |
---|
| 170 | idColumn=auto_generated_id |
---|
| 171 | |
---|