Annotation of embedaddon/strongswan/src/pool/sqlite.sql, revision 1.1
1.1 ! misho 1:
! 2:
! 3: DROP TABLE IF EXISTS identities;
! 4: CREATE TABLE identities (
! 5: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 6: type INTEGER NOT NULL,
! 7: data BLOB NOT NULL,
! 8: UNIQUE (type, data)
! 9: );
! 10:
! 11:
! 12: DROP TABLE IF EXISTS child_configs;
! 13: CREATE TABLE child_configs (
! 14: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 15: name TEXT NOT NULL,
! 16: lifetime INTEGER NOT NULL DEFAULT '1500',
! 17: rekeytime INTEGER NOT NULL DEFAULT '1200',
! 18: jitter INTEGER NOT NULL DEFAULT '60',
! 19: updown TEXT DEFAULT NULL,
! 20: hostaccess INTEGER NOT NULL DEFAULT '0',
! 21: mode INTEGER NOT NULL DEFAULT '2',
! 22: start_action INTEGER NOT NULL DEFAULT '0',
! 23: dpd_action INTEGER NOT NULL DEFAULT '0',
! 24: close_action INTEGER NOT NULL DEFAULT '0',
! 25: ipcomp INTEGER NOT NULL DEFAULT '0',
! 26: reqid INTEGER NOT NULL DEFAULT '0'
! 27: );
! 28: DROP INDEX IF EXISTS child_configs_name;
! 29: CREATE INDEX child_configs_name ON child_configs (
! 30: name
! 31: );
! 32:
! 33:
! 34: DROP TABLE IF EXISTS child_config_traffic_selector;
! 35: CREATE TABLE child_config_traffic_selector (
! 36: child_cfg INTEGER NOT NULL,
! 37: traffic_selector INTEGER NOT NULL,
! 38: kind INTEGER NOT NULL
! 39: );
! 40: DROP INDEX IF EXISTS child_config_traffic_selector_all;
! 41: CREATE INDEX child_config_traffic_selector_all ON child_config_traffic_selector (
! 42: child_cfg, traffic_selector
! 43: );
! 44:
! 45: DROP TABLE IF EXISTS proposals;
! 46: CREATE TABLE proposals (
! 47: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 48: proposal TEXT NOT NULL
! 49: );
! 50:
! 51:
! 52: DROP TABLE IF EXISTS child_config_proposal;
! 53: CREATE TABLE child_config_proposal (
! 54: child_cfg INTEGER NOT NULL,
! 55: prio INTEGER NOT NULL,
! 56: prop INTEGER NOT NULL
! 57: );
! 58:
! 59:
! 60: DROP TABLE IF EXISTS ike_configs;
! 61: CREATE TABLE ike_configs (
! 62: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 63: certreq INTEGER NOT NULL DEFAULT '1',
! 64: force_encap INTEGER NOT NULL DEFAULT '0',
! 65: local TEXT NOT NULL,
! 66: remote TEXT NOT NULL
! 67: );
! 68:
! 69:
! 70: DROP TABLE IF EXISTS ike_config_proposal;
! 71: CREATE TABLE ike_config_proposal (
! 72: ike_cfg INTEGER NOT NULL,
! 73: prio INTEGER NOT NULL,
! 74: prop INTEGER NOT NULL
! 75: );
! 76:
! 77:
! 78: DROP TABLE IF EXISTS peer_configs;
! 79: CREATE TABLE peer_configs (
! 80: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 81: name TEXT NOT NULL,
! 82: ike_version INTEGER NOT NULL DEFAULT '2',
! 83: ike_cfg INTEGER NOT NULL,
! 84: local_id TEXT NOT NULL,
! 85: remote_id TEXT NOT NULL,
! 86: cert_policy INTEGER NOT NULL DEFAULT '1',
! 87: uniqueid INTEGER NOT NULL DEFAULT '0',
! 88: auth_method INTEGER NOT NULL DEFAULT '1',
! 89: eap_type INTEGER NOT NULL DEFAULT '0',
! 90: eap_vendor INTEGER NOT NULL DEFAULT '0',
! 91: keyingtries INTEGER NOT NULL DEFAULT '3',
! 92: rekeytime INTEGER NOT NULL DEFAULT '7200',
! 93: reauthtime INTEGER NOT NULL DEFAULT '0',
! 94: jitter INTEGER NOT NULL DEFAULT '180',
! 95: overtime INTEGER NOT NULL DEFAULT '300',
! 96: mobike INTEGER NOT NULL DEFAULT '1',
! 97: dpd_delay INTEGER NOT NULL DEFAULT '120',
! 98: virtual TEXT DEFAULT NULL,
! 99: pool TEXT DEFAULT NULL,
! 100: mediation INTEGER NOT NULL DEFAULT '0',
! 101: mediated_by INTEGER NOT NULL DEFAULT '0',
! 102: peer_id INTEGER NOT NULL DEFAULT '0'
! 103: );
! 104: DROP INDEX IF EXISTS peer_configs_name;
! 105: CREATE INDEX peer_configs_name ON peer_configs (
! 106: name
! 107: );
! 108:
! 109:
! 110: DROP TABLE IF EXISTS peer_config_child_config;
! 111: CREATE TABLE peer_config_child_config (
! 112: peer_cfg INTEGER NOT NULL,
! 113: child_cfg INTEGER NOT NULL,
! 114: PRIMARY KEY (peer_cfg, child_cfg)
! 115: );
! 116:
! 117:
! 118: DROP TABLE IF EXISTS traffic_selectors;
! 119: CREATE TABLE traffic_selectors (
! 120: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 121: type INTEGER NOT NULL DEFAULT '7',
! 122: protocol INTEGER NOT NULL DEFAULT '0',
! 123: start_addr BLOB DEFAULT NULL,
! 124: end_addr BLOB DEFAULT NULL,
! 125: start_port INTEGER NOT NULL DEFAULT '0',
! 126: end_port INTEGER NOT NULL DEFAULT '65535'
! 127: );
! 128:
! 129:
! 130: DROP TABLE IF EXISTS certificates;
! 131: CREATE TABLE certificates (
! 132: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 133: type INTEGER NOT NULL,
! 134: keytype INTEGER NOT NULL,
! 135: data BLOB NOT NULL
! 136: );
! 137:
! 138:
! 139: DROP TABLE IF EXISTS certificate_identity;
! 140: CREATE TABLE certificate_identity (
! 141: certificate INTEGER NOT NULL,
! 142: identity INTEGER NOT NULL,
! 143: PRIMARY KEY (certificate, identity)
! 144: );
! 145:
! 146:
! 147: DROP TABLE IF EXISTS private_keys;
! 148: CREATE TABLE private_keys (
! 149: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 150: type INTEGER NOT NULL,
! 151: data BLOB NOT NULL
! 152: );
! 153:
! 154:
! 155: DROP TABLE IF EXISTS private_key_identity;
! 156: CREATE TABLE private_key_identity (
! 157: private_key INTEGER NOT NULL,
! 158: identity INTEGER NOT NULL,
! 159: PRIMARY KEY (private_key, identity)
! 160: );
! 161:
! 162:
! 163: DROP TABLE IF EXISTS shared_secrets;
! 164: CREATE TABLE shared_secrets (
! 165: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 166: type INTEGER NOT NULL,
! 167: data BLOB NOT NULL
! 168: );
! 169:
! 170:
! 171: DROP TABLE IF EXISTS shared_secret_identity;
! 172: CREATE TABLE shared_secret_identity (
! 173: shared_secret INTEGER NOT NULL,
! 174: identity INTEGER NOT NULL,
! 175: PRIMARY KEY (shared_secret, identity)
! 176: );
! 177:
! 178:
! 179: DROP TABLE IF EXISTS certificate_authorities;
! 180: CREATE TABLE certificate_authorities (
! 181: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 182: certificate INTEGER NOT NULL
! 183: );
! 184:
! 185:
! 186: DROP TABLE IF EXISTS certificate_distribution_points;
! 187: CREATE TABLE certificate_distribution_points (
! 188: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 189: ca INTEGER NOT NULL,
! 190: type INTEGER NOT NULL,
! 191: uri TEXT NOT NULL
! 192: );
! 193:
! 194:
! 195: DROP TABLE IF EXISTS pools;
! 196: CREATE TABLE pools (
! 197: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 198: name TEXT NOT NULL UNIQUE,
! 199: start BLOB NOT NULL,
! 200: end BLOB NOT NULL,
! 201: timeout INTEGER NOT NULL
! 202: );
! 203:
! 204: DROP TABLE IF EXISTS addresses;
! 205: CREATE TABLE addresses (
! 206: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 207: pool INTEGER NOT NULL,
! 208: address BLOB NOT NULL,
! 209: identity INTEGER NOT NULL DEFAULT 0,
! 210: acquired INTEGER NOT NULL DEFAULT 0,
! 211: released INTEGER NOT NULL DEFAULT 1
! 212: );
! 213: DROP INDEX IF EXISTS addresses_pool;
! 214: CREATE INDEX addresses_pool ON addresses (
! 215: pool
! 216: );
! 217: DROP INDEX IF EXISTS addresses_address;
! 218: CREATE INDEX addresses_address ON addresses (
! 219: address
! 220: );
! 221: DROP INDEX IF EXISTS addresses_identity;
! 222: CREATE INDEX addresses_identity ON addresses (
! 223: identity
! 224: );
! 225:
! 226: DROP TABLE IF EXISTS leases;
! 227: CREATE TABLE leases (
! 228: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 229: address INTEGER NOT NULL,
! 230: identity INTEGER NOT NULL,
! 231: acquired INTEGER NOT NULL,
! 232: released INTEGER NOT NULL
! 233: );
! 234:
! 235: DROP TABLE IF EXISTS attribute_pools;
! 236: CREATE TABLE attribute_pools (
! 237: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 238: name TEXT NOT NULL
! 239: );
! 240:
! 241: DROP TABLE IF EXISTS attributes;
! 242: CREATE TABLE attributes (
! 243: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 244: identity INTEGER NOT NULL DEFAULT 0,
! 245: pool INTEGER NOT NULL DEFAULT 0,
! 246: type INTEGER NOT NULL,
! 247: value BLOB NOT NULL
! 248: );
! 249: DROP INDEX IF EXISTS attributes_identity;
! 250: CREATE INDEX attributes_identity ON attributes (
! 251: identity
! 252: );
! 253: DROP INDEX IF EXISTS attributes_pool;
! 254: CREATE INDEX attributes_pool ON attributes (
! 255: pool
! 256: );
! 257:
! 258: DROP TABLE IF EXISTS ike_sas;
! 259: CREATE TABLE ike_sas (
! 260: local_spi BLOB NOT NULL PRIMARY KEY,
! 261: remote_spi BLOB NOT NULL,
! 262: id INTEGER NOT NULL,
! 263: initiator INTEGER NOT NULL,
! 264: local_id_type INTEGER NOT NULL,
! 265: local_id_data BLOB DEFAULT NULL,
! 266: remote_id_type INTEGER NOT NULL,
! 267: remote_id_data BLOB DEFAULT NULL,
! 268: host_family INTEGER NOT NULL,
! 269: local_host_data BLOB NOT NULL,
! 270: remote_host_data BLOB NOT NULL,
! 271: created INTEGER NOT NULL DEFAULT CURRENT_TIMESTAMP
! 272: );
! 273:
! 274: DROP TABLE IF EXISTS logs;
! 275: CREATE TABLE logs (
! 276: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
! 277: local_spi BLOB NOT NULL,
! 278: signal INTEGER NOT NULL,
! 279: level INTEGER NOT NULL,
! 280: msg TEXT NOT NULL,
! 281: time INTEGER NOT NULL DEFAULT CURRENT_TIMESTAMP
! 282: );
! 283:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>