From 5ba7efb08350c52fb61dc2cafe1c2f957db52021 Mon Sep 17 00:00:00 2001
From: Martin Willi <martin@strongswan.org>
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

