mysql run all table merge data

0
109

— phpMyAdmin SQL Dump
— version 4.7.7
— https://www.phpmyadmin.net/

— Host: localhost:3306
— Generation Time: Sep 15, 2018 at 05:18 PM
— Server version: 5.6.40
— PHP Version: 5.6.30

SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = “+00:00”;

/*!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 */;


— Database: `gstindia_data`

— ——————————————————–


— Structure for view `view_content`

CREATE ALGORITHM=UNDEFINED DEFINER=`gstindia_data`@`localhost` SQL SECURITY DEFINER VIEW `view_content` AS select `act`.`id` AS `id`,`act`.`type` AS `type`,`act`.`url` AS `url`,`act`.`section` AS `section`,`act`.`title` AS `title`,`act`.`content` AS `content`,`chapter`.`chapter_name` AS `chapter_name` from (`act` left join `chapter` on((`act`.`chapter_id` = `chapter`.`id`))) union all select `rules`.`id` AS `id`,`rules`.`type` AS `type`,`rules`.`url` AS `url`,`master_rule`.`name` AS `name`,`rules`.`title` AS `title`,`rules`.`content` AS `content`,`chapter`.`chapter_name` AS `chapter_name` from ((`rules` left join `chapter` on((`rules`.`chapter_id` = `chapter`.`id`))) join `master_rule` on((`master_rule`.`id` = `rules`.`rule`))) union all select `circulars`.`id` AS `id`,`circulars`.`type` AS `type`,`circulars`.`url` AS `url`,`circulars`.`description` AS `description`,`circulars`.`title` AS `title`,`circulars`.`content` AS `content`,’0′ AS `chapter_name` from `circulars` union all select `notification`.`id` AS `id`,`notification`.`type` AS `type`,`notification`.`url` AS `url`,`notification`.`description` AS `description`,`notification`.`title` AS `title`,`notification`.`content` AS `content`,’0′ AS `chapter_name` from `notification` union all select `others`.`id` AS `id`,`others`.`type` AS `type`,`others`.`url` AS `url`,`others`.`description` AS `description`,`others`.`title` AS `title`,`others`.`content` AS `content`,’0′ AS `chapter_name` from `others` ;


— VIEW `view_content`
— Data: None

COMMIT;

/*!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 */;