4x2C58h2

1-- MySQL Script generated by MySQL Workbench
2-- 01/23/19 00:46:01
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema abac
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `abac` ;
14
15-- -----------------------------------------------------
16-- Schema abac
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `abac` DEFAULT CHARACTER SET utf8 ;
19USE `abac` ;
20
21-- -----------------------------------------------------
22-- Table `Attribute`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `Attribute` ;
25
26CREATE TABLE IF NOT EXISTS `Attribute` (
27  `id` BIGINT(64) NOT NULL AUTO_INCREMENT,
28  `name` VARCHAR(45) NULL,
29  `slug` VARCHAR(45) NULL,
30  `description` LONGTEXT NULL,
31  `created_at` DATETIME NULL,
32  `updated_at` DATETIME NULL,
33  `deleted_at` DATETIME NULL,
34  `active` TINYINT NULL,
35  PRIMARY KEY (`id`))
36ENGINE = InnoDB;
37
38CREATE UNIQUE INDEX `name_UNIQUE` ON `Attribute` (`name` ASC);
39
40CREATE UNIQUE INDEX `slug_UNIQUE` ON `Attribute` (`slug` ASC);
41
42
43-- -----------------------------------------------------
44-- Table `Role`
45-- -----------------------------------------------------
46DROP TABLE IF EXISTS `Role` ;
47
48CREATE TABLE IF NOT EXISTS `Role` (
49  `id` BIGINT(64) NOT NULL AUTO_INCREMENT,
50  `name` VARCHAR(45) NULL,
51  `slug` VARCHAR(45) NULL,
52  `description` LONGTEXT NULL,
53  `created_at` DATETIME NULL,
54  `updated_at` DATETIME NULL,
55  `deleted_at` DATETIME NULL,
56  `active` TINYINT NULL,
57  PRIMARY KEY (`id`))
58ENGINE = InnoDB;
59
60CREATE UNIQUE INDEX `name_UNIQUE` ON `Role` (`name` ASC);
61
62CREATE UNIQUE INDEX `slug_UNIQUE` ON `Role` (`slug` ASC);
63
64
65-- -----------------------------------------------------
66-- Table `RoleUser`
67-- -----------------------------------------------------
68DROP TABLE IF EXISTS `RoleUser` ;
69
70CREATE TABLE IF NOT EXISTS `RoleUser` (
71  `role_id` BIGINT NOT NULL,
72  `user_id` BIGINT NOT NULL)
73ENGINE = InnoDB;
74
75
76-- -----------------------------------------------------
77-- Table `Activity`
78-- -----------------------------------------------------
79DROP TABLE IF EXISTS `Activity` ;
80
81CREATE TABLE IF NOT EXISTS `Activity` (
82  `id` BIGINT(64) NOT NULL AUTO_INCREMENT,
83  `name` VARCHAR(45) NULL,
84  `slug` VARCHAR(45) NULL,
85  `description` LONGTEXT NULL,
86  `created_at` DATETIME NULL,
87  `updated_at` DATETIME NULL,
88  `deleted_at` DATETIME NULL,
89  `active` TINYINT NULL,
90  PRIMARY KEY (`id`))
91ENGINE = InnoDB;
92
93CREATE UNIQUE INDEX `name_UNIQUE` ON `Activity` (`name` ASC);
94
95CREATE UNIQUE INDEX `slug_UNIQUE` ON `Activity` (`slug` ASC);
96
97
98-- -----------------------------------------------------
99-- Table `Permission`
100-- -----------------------------------------------------
101DROP TABLE IF EXISTS `Permission` ;
102
103CREATE TABLE IF NOT EXISTS `Permission` (
104  `id` INT NOT NULL,
105  `name` VARCHAR(45) NOT NULL,
106  `slug` VARCHAR(45) NOT NULL,
107  `description` LONGTEXT NULL,
108  `updated_at` DATETIME NULL,
109  `created_at` DATETIME NOT NULL,
110  `deleted_at` DATETIME NULL,
111  `active` TINYINT NOT NULL)
112ENGINE = InnoDB;
113
114CREATE UNIQUE INDEX `name_UNIQUE` ON `Permission` (`name` ASC);
115
116CREATE UNIQUE INDEX `slug_UNIQUE` ON `Permission` (`slug` ASC);
117
118
119-- -----------------------------------------------------
120-- Table `AttributePermission`
121-- -----------------------------------------------------
122DROP TABLE IF EXISTS `AttributePermission` ;
123
124CREATE TABLE IF NOT EXISTS `AttributePermission` (
125  `attribute_id` BIGINT NOT NULL,
126  `permission_id` BIGINT NOT NULL)
127ENGINE = InnoDB;
128
129
130-- -----------------------------------------------------
131-- Table `ActivityPermission`
132-- -----------------------------------------------------
133DROP TABLE IF EXISTS `ActivityPermission` ;
134
135CREATE TABLE IF NOT EXISTS `ActivityPermission` (
136  `activity_id` BIGINT NOT NULL,
137  `permission_id` BIGINT NOT NULL)
138ENGINE = InnoDB;
139
140
141-- -----------------------------------------------------
142-- Table `PermissionRole`
143-- -----------------------------------------------------
144DROP TABLE IF EXISTS `PermissionRole` ;
145
146CREATE TABLE IF NOT EXISTS `PermissionRole` (
147  `permission_id` BIGINT NOT NULL,
148  `role_id` BIGINT NOT NULL)
149ENGINE = InnoDB;
150
151
152SET SQL_MODE=@OLD_SQL_MODE;
153SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
154SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;