diff options
| author | Martin Willi <martin@strongswan.org> | 2008-08-22 07:38:59 +0000 |
|---|---|---|
| committer | Martin Willi <martin@strongswan.org> | 2008-08-22 07:38:59 +0000 |
| commit | 5ba7efb08350c52fb61dc2cafe1c2f957db52021 (patch) | |
| tree | ba5bf1652d0313411e35524755b419007b92bf79 /src/charon/plugins/sql/sqlite.sql | |
| parent | 3e45b3a1ad0df3d00418be1fa43bd7911eff89a3 (diff) | |
| download | strongswan-5ba7efb08350c52fb61dc2cafe1c2f957db52021.tar.bz2 strongswan-5ba7efb08350c52fb61dc2cafe1c2f957db52021.tar.xz | |
pool names are unique
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 ( |