
-- 2016-10-20 10:34:25 添加pin_hash字段 spring36-
ALTER TABLE `host`
ADD COLUMN `pin_hash`  varchar(64) NOT NULL DEFAULT '' AFTER `terminal_id`;

-- 2016-10-20 10:34:25 添加加密方式字段
ALTER TABLE `eap_token`
ADD COLUMN `encryption_mode`  varchar(64) NOT NULL DEFAULT 'SLIM_ECDH_PSK_WITH_AES_256_CTR_SHA256' AFTER `token`;

-- 2016-10-24 15:37:06 修改加密方式字段
ALTER TABLE `eap_token`
CHANGE COLUMN `encryption_mode` `layer2_encryption_mode`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'SLIM_ECDH_PSK_WITH_AES_256_CTR_SHA256' AFTER `token`,
ADD COLUMN `layer1_client_encryption_mode`  varchar(64) NOT NULL DEFAULT 'SLIM_ECDH_PSK_WITH_AES_256_CTR_SHA256' AFTER `token`,
ADD COLUMN `layer1_appserver_encryption_mode`  varchar(64) NOT NULL DEFAULT 'SLIM_ECDH_PSK_WITH_AES_256_CTR_SHA256' AFTER `layer1_client_encryption_mode`;
