aboutsummaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
Diffstat (limited to 'test')
-rw-r--r--test/notes.sql27
1 files changed, 27 insertions, 0 deletions
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';