From 1e44886d6f53d5bb9621211810fdea247f7fbd71 Mon Sep 17 00:00:00 2001 From: Mateja Date: Sat, 3 Oct 2020 00:10:38 +0200 Subject: moved notes --- test/notes.sql | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 test/notes.sql (limited to 'test') diff --git a/test/notes.sql b/test/notes.sql new file mode 100644 index 0000000..dd59770 --- /dev/null +++ b/test/notes.sql @@ -0,0 +1,27 @@ +CREATE DATABASE yota_db; +USE yota_db; + +CREATE TABLE activities( + `id` int(11) not null auto_increment primary key, + `approved` boolean not null default false; + `specialCall` varchar(50) not null, + `fromTime` datetime not null, + `toTime` datetime not null, + `frequencies` varchar(255) not null, + `modes` varchar(255) not null, + `operatorCall` varchar(50) not null, + `operatorName` varchar(50) not null, + `operatorEmail` varchar(100) not null, + `operatorPhone` varchar(50) not null + `qso` int not null default 0; + ) charset=utf8; + +CREATE TABLE admins( + `id` int(11) not null auto_increment primary key, + `email` varchar(100) not null, + `password` varchar(255) not null + ) charset=utf8; + +GRANT ALL PRIVILEGES ON `yota_db`.* TO `yota_admin`@`localhost` IDENTIFIED BY 'quaequaquagh6ahwoh6Chahx1EiFooGh'; +GRANT SELECT ON `yota_db`.* TO `yota_user`@`localhost` IDENTIFIED BY 'gahdeer6shai9hogai2sai4quuaj1eVu'; +GRANT INSERT ON `yota_db`.`activities` TO `yota_requester`@`localhost` IDENTIFIED BY 'oon5iraeghaidoShi5sheefie2uuz3gu'; -- cgit v1.2.3