· 8 years ago · Jan 05, 2018, 02:02 AM
1/*
2SQLyog Community
3MySQL - 5.5.58-0ubuntu0.14.04.1 : Database - loketix
4*********************************************************************
5*/
6
7/*!40101 SET NAMES utf8 */;
8
9/*!40101 SET SQL_MODE=''*/;
10
11/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
15CREATE DATABASE /*!32312 IF NOT EXISTS*/`loketix` /*!40100 DEFAULT CHARACTER SET latin1 */;
16
17USE `loketix`;
18
19/*Table structure for table `lok_ms_meta_media` */
20
21DROP TABLE IF EXISTS `lok_ms_meta_media`;
22
23CREATE TABLE `lok_ms_meta_media` (
24 `id` varchar(15) NOT NULL,
25 `meta_id` varchar(15) NOT NULL,
26 `type` smallint(6) NOT NULL,
27 `name` varchar(200) NOT NULL,
28 `value` text NOT NULL,
29 `description` text NOT NULL,
30 `status` smallint(1) NOT NULL,
31 `input_un` varchar(20) NOT NULL,
32 `input_time` int(11) NOT NULL,
33 `modified_un` varchar(20) NOT NULL,
34 `modified_time` int(11) NOT NULL,
35 PRIMARY KEY (`id`,`meta_id`),
36 UNIQUE KEY `id_UNIQUE` (`id`),
37 KEY `fk_lok_ms_meta` (`meta_id`),
38 CONSTRAINT `fk_lok_ms_meta` FOREIGN KEY (`meta_id`) REFERENCES `lok_ms_meta` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
39) ENGINE=InnoDB DEFAULT CHARSET=latin1;
40
41/*Data for the table `lok_ms_meta_media` */
42
43insert into `lok_ms_meta_media`(`id`,`meta_id`,`type`,`name`,`value`,`description`,`status`,`input_un`,`input_time`,`modified_un`,`modified_time`) values ('MDA76UYRG657IO9','MET987UY65RGTR4',0,'Halaman Depan','/uploads/media/2018/01/05/halaman-depan.png','Banner Home Dua',1,'USR8EF404A01917',1514366548,'USR8EF404A01917',1515116102);
44insert into `lok_ms_meta_media`(`id`,`meta_id`,`type`,`name`,`value`,`description`,`status`,`input_un`,`input_time`,`modified_un`,`modified_time`) values ('MDA9E989626A818','MET987UY65RGTR4',0,'Jual Tiket Event Kamu ke Seluruh Indonesia','/uploads/media/2018/01/05/5a4ed5d681ea9.jpg','Banner home satu',1,'USR8EF404A01917',1515113784,'USR8EF404A01917',1515116204);
45
46/*Table structure for table `lok_tr_event_meta` */
47
48DROP TABLE IF EXISTS `lok_tr_event_meta`;
49
50CREATE TABLE `lok_tr_event_meta` (
51 `id` varchar(15) NOT NULL,
52 `event_id` varchar(15) NOT NULL,
53 `meta_id` varchar(15) NOT NULL,
54 `value` text NOT NULL,
55 `input_un` varchar(20) NOT NULL,
56 `input_time` int(11) NOT NULL,
57 `modified_un` varchar(20) NOT NULL,
58 `modified_time` int(11) NOT NULL,
59 PRIMARY KEY (`id`,`event_id`,`meta_id`),
60 UNIQUE KEY `id_UNIQUE` (`id`),
61 KEY `fk_lok_tr_event_meta_lok_ms_meta1_idx` (`meta_id`),
62 KEY `fk_lok_tr_event_meta_lok_tr_events1_idx` (`event_id`),
63 CONSTRAINT `fk_lok_tr_event_meta_lok_ms_meta1` FOREIGN KEY (`meta_id`) REFERENCES `lok_ms_meta` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
64 CONSTRAINT `fk_lok_tr_event_meta_lok_tr_events1` FOREIGN KEY (`event_id`) REFERENCES `lok_tr_event` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66
67/*Data for the table `lok_tr_event_meta` */
68
69insert into `lok_tr_event_meta`(`id`,`event_id`,`meta_id`,`value`,`input_un`,`input_time`,`modified_un`,`modified_time`) values ('EVM0336B77A0218','EVTBB0DB81A0917','MET10935B9D5018','/uploads/event/2018/01/03/EVTBB0DB81A0917/5a4cccad50502.jpeg','USR8EF404A01917',1514982573,'USR8EF404A01917',1514982573);
70insert into `lok_tr_event_meta`(`id`,`event_id`,`meta_id`,`value`,`input_un`,`input_time`,`modified_un`,`modified_time`) values ('EVM30F0E751ED18','EVTBB0DB81A0917','MET10935B9D5018','/uploads/event/2018/01/03/EVTBB0DB81A0917/5a4ccd3956210.jpg','USR8EF404A01917',1514982713,'USR8EF404A01917',1514982713);
71insert into `lok_tr_event_meta`(`id`,`event_id`,`meta_id`,`value`,`input_un`,`input_time`,`modified_un`,`modified_time`) values ('EVM66335B923718','EVT50F177261D18','MET10935B9D5018','/uploads/event/2018/01/04/EVT50F177261D18/5a4eaaf6443b2.jpg','USR8EF404A01917',1515105014,'USR8EF404A01917',1515105014);
72insert into `lok_tr_event_meta`(`id`,`event_id`,`meta_id`,`value`,`input_un`,`input_time`,`modified_un`,`modified_time`) values ('EVMD32282958918','EVT50F177261D18','MET10935B9D5018','/uploads/event/2018/01/04/EVT50F177261D18/5a4eaaf9ea73a.jpeg','USR8EF404A01917',1515105017,'USR8EF404A01917',1515105017);
73
74/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
75/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
76/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
77/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;