Changeset 4273

Show
Ignore:
Timestamp:
08/22/08 09:38:59 (5 months ago)
Author:
martin
Message:

pool names are unique

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/src/charon/plugins/sql/sqlite.sql

    r4205 r4273  
    156156CREATE TABLE pools ( 
    157157  id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
    158   name TEXT NOT NULL, 
     158  name TEXT NOT NULL UNIQUE, 
    159159  start BLOB NOT NULL, 
    160160  end BLOB NOT NULL, 
    161161  timeout INTEGER NOT NULL 
    162 ); 
    163 DROP INDEX IF EXISTS pools_name; 
    164 CREATE INDEX pools_name ON pools ( 
    165   name 
    166162); 
    167163