JdCt9hmK

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : usbw
5Source Server Version : 50613
6Source Host           : localhost:3307
7Source Database       : ngkm
8
9Target Server Type    : MYSQL
10Target Server Version : 50613
11File Encoding         : 65001
12
13Date: 2016-10-18 20:43:58
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for wp_ngk_activities
20-- ----------------------------
21DROP TABLE IF EXISTS `wp_ngk_activities`;
22CREATE TABLE `wp_ngk_activities` (
23  `id` bigint(20) NOT NULL AUTO_INCREMENT,
24  `post_id` bigint(20) NOT NULL,
25  `start_date` date DEFAULT NULL,
26  `start_time` time DEFAULT NULL,
27  `end_date` date DEFAULT NULL,
28  `end_time` time DEFAULT NULL,
29  `created_by` bigint(20) DEFAULT NULL,
30  `updated_by` bigint(20) DEFAULT NULL,
31  `last_modified` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35-- ----------------------------
36-- Table structure for wp_ngk_agenda
37-- ----------------------------
38DROP TABLE IF EXISTS `wp_ngk_agenda`;
39CREATE TABLE `wp_ngk_agenda` (
40  `id` bigint(20) NOT NULL AUTO_INCREMENT,
41  `post_id` bigint(20) NOT NULL,
42  `start_date` date DEFAULT NULL,
43  `end_date` date DEFAULT NULL,
44  `created_by` bigint(20) DEFAULT NULL,
45  `updated_by` bigint(20) DEFAULT NULL,
46  `last_modified` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
47  PRIMARY KEY (`id`)
48) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49
50-- ----------------------------
51-- Table structure for wp_ngk_news
52-- ----------------------------
53DROP TABLE IF EXISTS `wp_ngk_news`;
54CREATE TABLE `wp_ngk_news` (
55  `id` bigint(20) NOT NULL AUTO_INCREMENT,
56  `post_id` bigint(20) NOT NULL,
57  `start_date` date DEFAULT NULL,
58  `end_date` date DEFAULT NULL,
59  `created_by` bigint(20) DEFAULT NULL,
60  `updated_by` bigint(20) DEFAULT NULL,
61  `last_modified` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
62  PRIMARY KEY (`id`)
63) ENGINE=InnoDB DEFAULT CHARSET=latin1;
64SET FOREIGN_KEY_CHECKS=1;