mv0m9kse

1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Jan 22, 2020 at 05:22 AM
7-- Server version: 5.7.26
8-- PHP Version: 7.2.18
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15--
16-- Database: `accountadmin`
17--
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `content_daughter_task`
23--
24
25DROP TABLE IF EXISTS `content_daughter_task`;
26CREATE TABLE IF NOT EXISTS `content_daughter_task` (
27  `id` int(11) NOT NULL AUTO_INCREMENT,
28  `description` text NOT NULL,
29  `deadline` datetime NOT NULL,
30  `ended_time` datetime NOT NULL,
31  `ended` tinyint(1) NOT NULL,
32  `crm_media_id` int(11) NOT NULL,
33  `content_id` int(11) NOT NULL,
34  PRIMARY KEY (`id`),
35  KEY `content_content_daughter_task_id` (`content_id`)
36) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
37
38
39--
40-- Table structure for table `social_media_daughter_task`
41--
42
43DROP TABLE IF EXISTS `social_media_daughter_task`;
44CREATE TABLE IF NOT EXISTS `social_media_daughter_task` (
45  `id` int(11) NOT NULL AUTO_INCREMENT,
46  `description` text NOT NULL,
47  `deadline` datetime NOT NULL,
48  `ended_time` datetime NOT NULL,
49  `ended` tinyint(1) NOT NULL,
50  `crm_media_id` int(11) NOT NULL,
51  `social_media_id` int(11) NOT NULL,
52  PRIMARY KEY (`id`),
53  KEY `social_media_social_media_daughter_task_id` (`social_media_id`)
54) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
55
56--
57-- Constraints for dumped tables
58--
59
60--
61-- Constraints for table `content_daughter_task`
62--
63ALTER TABLE `content_daughter_task`
64  ADD CONSTRAINT `content_content_daughter_task_id` FOREIGN KEY (`content_id`) REFERENCES `content` (`id`);
65
66--
67-- Constraints for table `social_media_daughter_task`
68--
69ALTER TABLE `social_media_daughter_task`
70  ADD CONSTRAINT `social_media_social_media_daughter_task_id` FOREIGN KEY (`social_media_id`) REFERENCES `social_media` (`id`);
71COMMIT;