S9v2K4kn

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-31 19:34:31
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for wp_ngkm_event_add_information
20-- ----------------------------
21DROP TABLE IF EXISTS `wp_ngkm_event_add_information`;
22CREATE TABLE `wp_ngkm_event_add_information` (
23  `id` bigint(20) NOT NULL AUTO_INCREMENT,
24  `event_id` bigint(20) NOT NULL,
25  `description` varchar(255) NOT NULL,
26  `value` text NOT NULL,
27  `sort` int(11) NOT NULL DEFAULT '0',
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30
31-- ----------------------------
32-- Table structure for wp_ngkm_event_to_type
33-- ----------------------------
34DROP TABLE IF EXISTS `wp_ngkm_event_to_type`;
35CREATE TABLE `wp_ngkm_event_to_type` (
36  `id` bigint(20) NOT NULL AUTO_INCREMENT,
37  `event_id` bigint(20) NOT NULL,
38  `event_type_id` bigint(20) NOT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42-- ----------------------------
43-- Table structure for wp_ngkm_event_types
44-- ----------------------------
45DROP TABLE IF EXISTS `wp_ngkm_event_types`;
46CREATE TABLE `wp_ngkm_event_types` (
47  `id` bigint(20) NOT NULL AUTO_INCREMENT,
48  `name` varchar(80) NOT NULL,
49  `color` varchar(20) NOT NULL,
50  PRIMARY KEY (`id`)
51) ENGINE=InnoDB DEFAULT CHARSET=latin1;
52
53-- ----------------------------
54-- Table structure for wp_ngkm_events
55-- ----------------------------
56DROP TABLE IF EXISTS `wp_ngkm_events`;
57CREATE TABLE `wp_ngkm_events` (
58  `id` bigint(20) NOT NULL AUTO_INCREMENT,
59  `post_id` bigint(20) NOT NULL,
60  `start_date` date NOT NULL,
61  `start_time` time DEFAULT NULL,
62  `end_date` date NOT NULL,
63  `end_time` time DEFAULT NULL,
64  `start_display` date DEFAULT NULL,
65  `end_display` date DEFAULT NULL,
66  `custom_title` varchar(80) DEFAULT NULL,
67  `in_church` int(1) NOT NULL,
68  `location` longtext,
69  `organizer` text,
70  `created_by` bigint(20) NOT NULL,
71  `modified_by` bigint(20) NOT NULL,
72  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
73  PRIMARY KEY (`id`)
74) ENGINE=InnoDB DEFAULT CHARSET=latin1;
75
76-- ----------------------------
77-- Table structure for wp_ngkm_news
78-- ----------------------------
79DROP TABLE IF EXISTS `wp_ngkm_news`;
80CREATE TABLE `wp_ngkm_news` (
81  `id` bigint(20) NOT NULL AUTO_INCREMENT,
82  `post_id` bigint(20) NOT NULL,
83  `start_display` date DEFAULT NULL,
84  `end_display` date DEFAULT NULL,
85  `custom_title` varchar(80) DEFAULT NULL,
86  `created_by` bigint(20) DEFAULT NULL,
87  `modified_by` bigint(20) DEFAULT NULL,
88  `last_modified` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
89  PRIMARY KEY (`id`)
90) ENGINE=InnoDB DEFAULT CHARSET=latin1;
91
92-- ----------------------------
93-- Table structure for wp_ngkm_news_to_type
94-- ----------------------------
95DROP TABLE IF EXISTS `wp_ngkm_news_to_type`;
96CREATE TABLE `wp_ngkm_news_to_type` (
97  `id` bigint(20) NOT NULL AUTO_INCREMENT,
98  `news_id` bigint(20) NOT NULL,
99  `news_type_id` bigint(20) NOT NULL,
100  PRIMARY KEY (`id`)
101) ENGINE=InnoDB DEFAULT CHARSET=latin1;
102
103-- ----------------------------
104-- Table structure for wp_ngkm_news_type
105-- ----------------------------
106DROP TABLE IF EXISTS `wp_ngkm_news_type`;
107CREATE TABLE `wp_ngkm_news_type` (
108  `id` bigint(20) NOT NULL AUTO_INCREMENT,
109  `name` varchar(80) NOT NULL,
110  `color` varchar(20) NOT NULL,
111  PRIMARY KEY (`id`)
112) ENGINE=InnoDB DEFAULT CHARSET=latin1;
113
114-- ----------------------------
115-- Table structure for wp_ngkm_post_visibility
116-- ----------------------------
117DROP TABLE IF EXISTS `wp_ngkm_post_visibility`;
118CREATE TABLE `wp_ngkm_post_visibility` (
119  `id` bigint(20) NOT NULL AUTO_INCREMENT,
120  `post_id` bigint(20) NOT NULL,
121  `start_display` date DEFAULT NULL,
122  `end_display` date DEFAULT NULL,
123  `created_by` bigint(20) NOT NULL,
124  `modified_by` bigint(20) NOT NULL,
125  `last_modified` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
126  PRIMARY KEY (`id`)
127) ENGINE=InnoDB DEFAULT CHARSET=latin1;
128SET FOREIGN_KEY_CHECKS=1;