Runtime

--

--  Copyright 2017 Anyware Services

--

--  Licensed under the Apache License, Version 2.0 (the "License");

--  you may not use this file except in compliance with the License.

--  You may obtain a copy of the License at

--

--      http://www.apache.org/licenses/LICENSE-2.0

--

--  Unless required by applicable law or agreed to in writing, software

--  distributed under the License is distributed on an "AS IS" BASIS,

--  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

--  See the License for the specific language governing permissions and

--  limitations under the License.

--

drop table if exists Authentication_Token;

CREATE TABLE Authentication_Token (

  id int PRIMARY KEY NOT NULL AUTO_INCREMENT,

  login varchar(64) BINARY NOT NULL,

  population_id VARCHAR(200) BINARY NOT NULL,

  token varchar(128)  NOT NULL,

  salt varchar(64) NOT NULL,

  creation_date datetime,

  end_date datetime,

  last_update_date datetime,

  nb_uses_left INTEGER NULL,

  auto_renew_duration BIGINT(13) NULL,

  context VARCHAR (200) NULL,

  type varchar(64) NOT NULL,

  token_comment LONGBLOB

)ENGINE=innodb CHARACTER SET utf8;