diff options
| author | Hans Hagen <pragma@wxs.nl> | 2018-03-21 09:47:34 +0100 |
|---|---|---|
| committer | Context Git Mirror Bot <phg42.2a@gmail.com> | 2018-03-21 09:47:34 +0100 |
| commit | f47b4939787074397c9ea37c1d892a1f7ccc7290 (patch) | |
| tree | 7768be58efe0faab8e2dccb999686c6a674bf0d7 /tex/context/base/mkiv/util-sql-logins.lua | |
| parent | f923c957a3b322ae3ee8e7a0b20df1580869bee7 (diff) | |
| download | context-f47b4939787074397c9ea37c1d892a1f7ccc7290.tar.gz | |
2018-03-21 09:24:00
Diffstat (limited to 'tex/context/base/mkiv/util-sql-logins.lua')
| -rw-r--r-- | tex/context/base/mkiv/util-sql-logins.lua | 39 |
1 files changed, 22 insertions, 17 deletions
diff --git a/tex/context/base/mkiv/util-sql-logins.lua b/tex/context/base/mkiv/util-sql-logins.lua index 9717a8175..dcb48fb35 100644 --- a/tex/context/base/mkiv/util-sql-logins.lua +++ b/tex/context/base/mkiv/util-sql-logins.lua @@ -34,22 +34,27 @@ end logins.usedb = checkeddb local template = [[ -CREATE TABLE - `logins` - ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `name` varchar(50) COLLATE utf8_bin NOT NULL, - `time` int(11) DEFAULT '0', - `n` int(11) DEFAULT '0', - `state` int(11) DEFAULT '0', - PRIMARY KEY (`id`), - UNIQUE KEY `id_UNIQUE` (`id`), - UNIQUE KEY `name_UNIQUE` (`name`) - ) - ENGINE=InnoDB - DEFAULT CHARSET=utf8 - COLLATE=utf8_bin - COMMENT='state: 0=unset 1=known 2=unknown' + CREATE TABLE IF NOT EXISTS %basename% ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `name` varchar(50) NOT NULL, + `time` int(11) DEFAULT '0', + `n` int(11) DEFAULT '0', + `state` int(11) DEFAULT '0', + + PRIMARY KEY (`id`), + UNIQUE KEY `id_unique_index` (`id`), + UNIQUE KEY `name_unique_key` (`name`) + ) DEFAULT CHARSET = utf8 ; +]] + +local sqlite_template = [[ + CREATE TABLE IF NOT EXISTS %basename% ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `name` TEXT NOT NULL, + `time` INTEGER DEFAULT '0', + `n` INTEGER DEFAULT '0', + `state` INTEGER DEFAULT '0' + ) ; ]] function logins.createdb(presets,datatable) @@ -57,7 +62,7 @@ function logins.createdb(presets,datatable) local db = checkeddb(presets,datatable) local data, keys = db.execute { - template = template, + template = db.usedmethod == "sqlite" and sqlite_template or template, variables = { basename = db.basename, }, |