From 5ba7efb08350c52fb61dc2cafe1c2f957db52021 Mon Sep 17 00:00:00 2001 From: Martin Willi Date: Fri, 22 Aug 2008 07:38:59 +0000 Subject: pool names are unique --- src/charon/plugins/sql/sqlite.sql | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) (limited to 'src/charon/plugins/sql/sqlite.sql') 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 ( -- cgit v1.2.3