smartschool-platform/applications/device/device-client/src/main/resources/schema.sql

create table if not exists access_control
(
id varchar(50) primary key not null,
name varchar(300) not null,
ip varchar(20) not null,
port int not null,
username varchar(30) not null,
password varchar(50) not null
);

create table if not exists school
(
name varchar(500) not null,
id varchar(32) not null,
secret varchar(100) not null
);

create table if not exists iccard
(
ip varchar(20) not null,
port int not null,
username varchar(30) not null,
password varchar(50) not null,
databaseName varchar(30) not null
);

alter table access_control add column if not exists accessType int default 1;