diff options
Diffstat (limited to 'src/charon/plugins/sql/sqlite.sql')
| -rw-r--r-- | src/charon/plugins/sql/sqlite.sql | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/src/charon/plugins/sql/sqlite.sql b/src/charon/plugins/sql/sqlite.sql index e1002d458..f8bac1fcf 100644 --- a/src/charon/plugins/sql/sqlite.sql +++ b/src/charon/plugins/sql/sqlite.sql @@ -155,15 +155,11 @@ CREATE TABLE shared_secret_identity ( DROP TABLE IF EXISTS pools; CREATE TABLE pools ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - name TEXT NOT NULL, + name TEXT NOT NULL UNIQUE, start BLOB NOT NULL, end BLOB NOT NULL, timeout INTEGER NOT NULL ); -DROP INDEX IF EXISTS pools_name; -CREATE INDEX pools_name ON pools ( - name -); DROP TABLE IF EXISTS addresses; CREATE TABLE addresses ( |