db.sql

-- certificate db
CREATE TABLE atp_certificate (id int(6) NOT NULL auto_increment, certificate_number varchar(255) NOT NULL, building_number varchar(255), vin varchar(255), expire_date datetime not null, symbol varchar(255) not null, PRIMARY KEY (id),UNIQUE id (id));
-- user db
CREATE TABLE atp_user_table (id int(6) NOT NULL auto_increment, login varchar(255) NOT NULL, password varchar(255), PRIMARY KEY (id),UNIQUE id (id));
-- insert user with credentials:
insert into atp_user_table (login, password) values ('atp_user','d4d44849b81fd3afa57402bb24c2a411');

-- information abaout updates
CREATE TABLE atp_update_event (id int(6) NOT NULL auto_increment,  date datetime not null, PRIMARY KEY (id),UNIQUE id (id));

-- logs
create table atp_log_event (id int(6) not null auto_increment, date datetime not null, notes varchar(1024), primary key(id), unique id (id));