Permalink
Fetching contributors…
Cannot retrieve contributors at this time
354 lines (302 sloc) 11.7 KB
-- MySQL dump 10.16 Distrib 10.1.24-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: webird_git
-- ------------------------------------------------------
-- Server version 10.1.24-MariaDB-1~xenial
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `audit`
--
DROP TABLE IF EXISTS `audit`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audit` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usersId` int(10) NOT NULL,
`model_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`ipaddress` char(15) COLLATE utf8_unicode_ci NOT NULL,
`type` char(1) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `audit`
--
LOCK TABLES `audit` WRITE;
/*!40000 ALTER TABLE `audit` DISABLE KEYS */;
/*!40000 ALTER TABLE `audit` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `audit_detail`
--
DROP TABLE IF EXISTS `audit_detail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audit_detail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`audit_id` int(11) NOT NULL,
`field_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`old_value` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`new_value` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `audit_detail`
--
LOCK TABLES `audit_detail` WRITE;
/*!40000 ALTER TABLE `audit_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `audit_detail` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `email_confirmations`
--
DROP TABLE IF EXISTS `email_confirmations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `email_confirmations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usersId` int(10) unsigned NOT NULL,
`code` char(32) NOT NULL,
`createdAt` int(10) unsigned NOT NULL,
`modifiedAt` int(10) unsigned DEFAULT NULL,
`confirmed` char(1) DEFAULT 'N',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `email_confirmations`
--
LOCK TABLES `email_confirmations` WRITE;
/*!40000 ALTER TABLE `email_confirmations` DISABLE KEYS */;
/*!40000 ALTER TABLE `email_confirmations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `failed_signins`
--
DROP TABLE IF EXISTS `failed_signins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_signins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usersId` int(10) unsigned DEFAULT NULL,
`ipAddress` char(15) NOT NULL,
`attempted` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `usersId` (`usersId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `failed_signins`
--
LOCK TABLES `failed_signins` WRITE;
/*!40000 ALTER TABLE `failed_signins` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_signins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `password_changes`
--
DROP TABLE IF EXISTS `password_changes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_changes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usersId` int(10) unsigned NOT NULL,
`ipAddress` char(15) NOT NULL,
`userAgent` varchar(48) NOT NULL,
`createdAt` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `usersId` (`usersId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `password_changes`
--
LOCK TABLES `password_changes` WRITE;
/*!40000 ALTER TABLE `password_changes` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_changes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `permissions`
--
DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rolesId` int(10) unsigned NOT NULL,
`namespace` varchar(12) NOT NULL,
`resource` varchar(30) NOT NULL,
`action` varchar(16) NOT NULL,
PRIMARY KEY (`id`),
KEY `profilesId` (`rolesId`)
) ENGINE=InnoDB AUTO_INCREMENT=319 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `permissions`
--
LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (226,3,'web','settings','changePassword'),(281,2,'api','users','list'),(282,2,'api','users','count'),(283,2,'web','settings','changePassword'),(284,2,'web','features','index'),(288,2,'web','features','postcss'),(289,1,'cli','chat','open'),(290,1,'api','users','list'),(291,1,'api','users','count'),(292,1,'api','helloworld','index'),(293,1,'web','settings','changePassword'),(294,1,'web','features','index'),(298,1,'web','features','postcss'),(299,1,'web','features','fetch'),(300,1,'admin','index','index'),(301,1,'admin','roles','index'),(302,1,'admin','roles','search'),(303,1,'admin','roles','edit'),(304,1,'admin','roles','create'),(305,1,'admin','roles','delete'),(306,1,'admin','permissions','index'),(307,1,'admin','users','index'),(308,1,'admin','users','search'),(309,1,'admin','users','create'),(310,1,'admin','users','edit'),(311,1,'admin','users','delete'),(312,1,'web','features','vue'),(313,1,'web','features','vuex'),(314,1,'web','features','pdfviewer'),(316,1,'web','broadcast','index'),(317,1,'web','broadcast','post'),(318,1,'web','broadcast','serversent');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `remember_tokens`
--
DROP TABLE IF EXISTS `remember_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `remember_tokens` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usersId` int(10) unsigned NOT NULL,
`token` char(32) NOT NULL,
`userAgent` varchar(120) NOT NULL,
`createdAt` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `remember_tokens`
--
LOCK TABLES `remember_tokens` WRITE;
/*!40000 ALTER TABLE `remember_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `remember_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `reset_passwords`
--
DROP TABLE IF EXISTS `reset_passwords`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reset_passwords` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usersId` int(10) unsigned NOT NULL,
`code` varchar(48) NOT NULL,
`createdAt` int(10) unsigned NOT NULL,
`modifiedAt` int(10) unsigned DEFAULT NULL,
`reset` char(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `usersId` (`usersId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `reset_passwords`
--
LOCK TABLES `reset_passwords` WRITE;
/*!40000 ALTER TABLE `reset_passwords` DISABLE KEYS */;
/*!40000 ALTER TABLE `reset_passwords` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`active` char(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `active` (`active`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roles`
--
LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'Administrators','Y'),(2,'Users','Y'),(3,'Read-Only','Y');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `session_data`
--
DROP TABLE IF EXISTS `session_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `session_data` (
`session_id` varchar(35) COLLATE utf8_unicode_ci NOT NULL,
`data` text COLLATE utf8_unicode_ci NOT NULL,
`created_at` int(15) unsigned NOT NULL,
`modified_at` int(15) unsigned DEFAULT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `session_data`
--
LOCK TABLES `session_data` WRITE;
/*!40000 ALTER TABLE `session_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `session_data` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `success_signins`
--
DROP TABLE IF EXISTS `success_signins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `success_signins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usersId` int(10) unsigned NOT NULL,
`ipAddress` char(15) NOT NULL,
`method` varchar(15) NOT NULL,
`userAgent` varchar(120) NOT NULL,
PRIMARY KEY (`id`),
KEY `usersId` (`usersId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `success_signins`
--
LOCK TABLES `success_signins` WRITE;
/*!40000 ALTER TABLE `success_signins` DISABLE KEYS */;
/*!40000 ALTER TABLE `success_signins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` char(60) NOT NULL,
`mustChangePassword` char(1) DEFAULT NULL,
`rolesId` int(10) unsigned NOT NULL,
`banned` char(1) NOT NULL,
`active` varchar(1) NOT NULL,
`deleted` varchar(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `emailUnique` (`email`),
KEY `profilesId` (`rolesId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2017-06-21 0:29:45