diff options
Diffstat (limited to 'src/libcharon/plugins/sql/mysql.sql')
-rw-r--r-- | src/libcharon/plugins/sql/mysql.sql | 281 |
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; - - |