Newer
Older
CosmosServer / docker / mysql / initdb.d / schma.sql
CREATE TABLE users(
uId varchar(36) PRIMARY KEY NOT NULL,
name varchar(36) NOT NULL,
uri varchar(100) NOT NULL,
iconUri varchar(100) NOT NULL,
login BIT	NOT NULL
);

CREATE TABLE token(
token varchar(36) PRIMARY KEY NOT NULL,
uId varchar(36) NOT NULL
);

CREATE TABLE groups(
gId varchar(36) PRIMARY KEY NOT NULL,
name varchar(36) NOT NULL,
uri varchar(100) NOT NULL
);

CREATE TABLE request(
rId varchar(36) PRIMARY KEY NOT NULL,
gId varchar(36)  NOT NULL,
date DATE NOT NULL,
issuer varchar(36) NOT NULL,
request varchar(36) NOT NULL,
deadline DATE NOT NULL,
location varchar(36),
done BIT NOT NULL
);

create TABLE belong(
gId varchar(36) PRIMARY KEY NOT NULL,
uId varchar(36)  NOT NULL
);