aboutsummaryrefslogtreecommitdiffstats
path: root/src/libcharon/plugins/sql/mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/libcharon/plugins/sql/mysql.sql')
-rw-r--r--src/libcharon/plugins/sql/mysql.sql281
1 files changed, 0 insertions, 281 deletions
diff --git a/src/libcharon/plugins/sql/mysql.sql b/src/libcharon/plugins/sql/mysql.sql
deleted file mode 100644
index 1b437593d..000000000
--- a/src/libcharon/plugins/sql/mysql.sql
+++ /dev/null
@@ -1,281 +0,0 @@
-
-DROP TABLE IF EXISTS `identities`;
-CREATE TABLE `identities` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `type` tinyint(4) unsigned NOT NULL,
- `data` varbinary(64) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE (`type`, `data`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS `child_configs`;
-CREATE TABLE `child_configs` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `name` varchar(32) collate utf8_unicode_ci NOT NULL,
- `lifetime` mediumint(8) unsigned NOT NULL default '1500',
- `rekeytime` mediumint(8) unsigned NOT NULL default '1200',
- `jitter` mediumint(8) unsigned NOT NULL default '60',
- `updown` varchar(128) collate utf8_unicode_ci default NULL,
- `hostaccess` tinyint(1) unsigned NOT NULL default '0',
- `mode` tinyint(4) unsigned NOT NULL default '2',
- `start_action` tinyint(4) unsigned NOT NULL default '0',
- `dpd_action` tinyint(4) unsigned NOT NULL default '0',
- `close_action` tinyint(4) unsigned NOT NULL default '0',
- `ipcomp` tinyint(4) unsigned NOT NULL default '0',
- `reqid` mediumint(8) unsigned NOT NULL default '0',
- PRIMARY KEY (`id`),
- INDEX (`name`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS `child_config_traffic_selector`;
-CREATE TABLE `child_config_traffic_selector` (
- `child_cfg` int(10) unsigned NOT NULL,
- `traffic_selector` int(10) unsigned NOT NULL,
- `kind` tinyint(3) unsigned NOT NULL,
- INDEX (`child_cfg`, `traffic_selector`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS `proposals`;
-CREATE TABLE `proposals` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `proposal` varchar(128) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS `child_config_proposal`;
-CREATE TABLE `child_config_proposal` (
- `child_cfg` int(10) unsigned NOT NULL,
- `prio` smallint(5) unsigned NOT NULL,
- `prop` int(10) unsigned NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS `ike_configs`;
-CREATE TABLE `ike_configs` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `certreq` tinyint(3) unsigned NOT NULL default '1',
- `force_encap` tinyint(1) NOT NULL default '0',
- `local` varchar(128) collate utf8_unicode_ci NOT NULL,
- `remote` varchar(128) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS `ike_config_proposal`;
-CREATE TABLE `ike_config_proposal` (
- `ike_cfg` int(10) unsigned NOT NULL,
- `prio` smallint(5) unsigned NOT NULL,
- `prop` int(10) unsigned NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS `peer_configs`;
-CREATE TABLE `peer_configs` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `name` varchar(32) collate utf8_unicode_ci NOT NULL,
- `ike_version` tinyint(3) unsigned NOT NULL default '2',
- `ike_cfg` int(10) unsigned NOT NULL,
- `local_id` varchar(64) collate utf8_unicode_ci NOT NULL,
- `remote_id` varchar(64) collate utf8_unicode_ci NOT NULL,
- `cert_policy` tinyint(3) unsigned NOT NULL default '1',
- `uniqueid` tinyint(3) unsigned NOT NULL default '0',
- `auth_method` tinyint(3) unsigned NOT NULL default '1',
- `eap_type` tinyint(3) unsigned NOT NULL default '0',
- `eap_vendor` smallint(5) unsigned NOT NULL default '0',
- `keyingtries` tinyint(3) unsigned NOT NULL default '3',
- `rekeytime` mediumint(8) unsigned NOT NULL default '7200',
- `reauthtime` mediumint(8) unsigned NOT NULL default '0',
- `jitter` mediumint(8) unsigned NOT NULL default '180',
- `overtime` mediumint(8) unsigned NOT NULL default '300',
- `mobike` tinyint(1) NOT NULL default '1',
- `dpd_delay` mediumint(8) unsigned NOT NULL default '120',
- `virtual` varchar(40) default NULL,
- `pool` varchar(32) default NULL,
- `mediation` tinyint(1) NOT NULL default '0',
- `mediated_by` int(10) unsigned NOT NULL default '0',
- `peer_id` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`id`),
- INDEX (`name`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS `peer_config_child_config`;
-CREATE TABLE `peer_config_child_config` (
- `peer_cfg` int(10) unsigned NOT NULL,
- `child_cfg` int(10) unsigned NOT NULL,
- PRIMARY KEY (`peer_cfg`, `child_cfg`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS `traffic_selectors`;
-CREATE TABLE `traffic_selectors` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `type` tinyint(3) unsigned NOT NULL default '7',
- `protocol` smallint(5) unsigned NOT NULL default '0',
- `start_addr` varbinary(16) default NULL,
- `end_addr` varbinary(16) default NULL,
- `start_port` smallint(5) unsigned NOT NULL default '0',
- `end_port` smallint(5) unsigned NOT NULL default '65535',
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS certificates;
-CREATE TABLE certificates (
- `id` int(10) unsigned NOT NULL auto_increment,
- `type` tinyint(3) unsigned NOT NULL,
- `keytype` tinyint(3) unsigned NOT NULL,
- `data` BLOB NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS certificate_identity;
-CREATE TABLE certificate_identity (
- `certificate` int(10) unsigned NOT NULL,
- `identity` int(10) unsigned NOT NULL,
- PRIMARY KEY (`certificate`, `identity`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS private_keys;
-CREATE TABLE private_keys (
- `id` int(10) unsigned NOT NULL auto_increment,
- `type` tinyint(3) unsigned NOT NULL,
- `data` BLOB NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS private_key_identity;
-CREATE TABLE private_key_identity (
- `private_key` int(10) unsigned NOT NULL,
- `identity` int(10) unsigned NOT NULL,
- PRIMARY KEY (`private_key`, `identity`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS shared_secrets;
-CREATE TABLE shared_secrets (
- `id` int(10) unsigned NOT NULL auto_increment,
- `type` tinyint(3) unsigned NOT NULL,
- `data` varbinary(256) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS shared_secret_identity;
-CREATE TABLE shared_secret_identity (
- `shared_secret` int(10) unsigned NOT NULL,
- `identity` int(10) unsigned NOT NULL,
- PRIMARY KEY (`shared_secret`, `identity`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS certificate_authorities;
-CREATE TABLE certificate_authorities (
- `id` int(10) unsigned NOT NULL auto_increment,
- `certificate` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS certificate_distribution_points;
-CREATE TABLE certificate_distribution_points (
- `id` int(10) unsigned NOT NULL auto_increment,
- `ca` int(10) unsigned NOT NULL,
- `type` tinyint(3) unsigned NOT NULL,
- `uri` varchar(256) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS pools;
-CREATE TABLE pools (
- `id` int(10) unsigned NOT NULL auto_increment,
- `name` varchar(32) NOT NULL,
- `start` varbinary(16) NOT NULL,
- `end` varbinary(16) NOT NULL,
- `timeout` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE (`name`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS addresses;
-CREATE TABLE addresses (
- `id` int(10) unsigned NOT NULL auto_increment,
- `pool` int(10) unsigned NOT NULL,
- `address` varbinary(16) NOT NULL,
- `identity` int(10) unsigned NOT NULL DEFAULT 0,
- `acquired` int(10) unsigned NOT NULL DEFAULT 0,
- `released` int(10) unsigned NOT NULL DEFAULT 1,
- PRIMARY KEY (`id`),
- INDEX (`pool`),
- INDEX (`identity`),
- INDEX (`address`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-DROP TABLE IF EXISTS leases;
-CREATE TABLE leases (
- `id` int(10) unsigned NOT NULL auto_increment,
- `address` int(10) unsigned NOT NULL,
- `identity` int(10) unsigned NOT NULL,
- `acquired` int(10) unsigned NOT NULL,
- `released` int(10) unsigned DEFAULT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-DROP TABLE IF EXISTS attribute_pools;
-CREATE TABLE attribute_pools (
- `id` int(10) unsigned NOT NULL auto_increment,
- `name` varchar(32) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-DROP TABLE IF EXISTS attributes;
-CREATE TABLE attributes (
- `id` int(10) unsigned NOT NULL auto_increment,
- `identity` int(10) unsigned NOT NULL default '0',
- `pool` int(10) unsigned NOT NULL default '0',
- `type` int(10) unsigned NOT NULL,
- `value` varbinary(16) NOT NULL,
- PRIMARY KEY (`id`),
- INDEX (`identity`),
- INDEX (`pool`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-DROP TABLE IF EXISTS ike_sas;
-CREATE TABLE ike_sas (
- `local_spi` varbinary(8) NOT NULL,
- `remote_spi` varbinary(8) NOT NULL,
- `id` int(10) unsigned NOT NULL,
- `initiator` tinyint(1) NOT NULL,
- `local_id_type` tinyint(3) NOT NULL,
- `local_id_data` varbinary(64) DEFAULT NULL,
- `remote_id_type` tinyint(3) NOT NULL,
- `remote_id_data` varbinary(64) DEFAULT NULL,
- `host_family` tinyint(3) NOT NULL,
- `local_host_data` varbinary(16) NOT NULL,
- `remote_host_data` varbinary(16) NOT NULL,
- `lastuse` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`local_spi`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-
-DROP TABLE IF EXISTS logs;
-CREATE TABLE logs (
- `id` int(10) unsigned NOT NULL auto_increment,
- `local_spi` varbinary(8) NOT NULL,
- `signal` tinyint(3) NOT NULL,
- `level` tinyint(3) NOT NULL,
- `msg` varchar(256) NOT NULL,
- `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-