VvsVtmYA

1CREATE DATABASE IF NOT EXISTS mydata;
2USE mydata;
3
4CREATE OR REPLACE USER webuser IDENTIFIED BY 'xxx';
5FLUSH PRIVILEGES;
6
7GRANT SELECT, INSERT, UPDATE, DELETE ON mydata.* TO 'webuser'@'localhost';
8
9DROP TABLE IF EXISTS messages;
10CREATE TABLE messages (
11    id            INTEGER AUTO_INCREMENT NOT NULL,
12    msgType       VARCHAR(15),
13    msgText       VARCHAR(MAX),
14    toLeadership  BOOLEAN,
15    toGrievance   BOOLEAN,
16    toBargaining  BOOLEAN,
17    toMembership  BOOLEAN,
18    private       BOOLEAN,
19    PRIMARY KEY(id)
20);
21