MYiTvZWu

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_tr_attendence` */
20
21DROP TABLE IF EXISTS `lok_tr_attendence`;
22
23CREATE TABLE `lok_tr_attendence` (
24  `id` varchar(15) NOT NULL,
25  `payment_id` varchar(15) NOT NULL,
26  `event_id` varchar(15) NOT NULL,
27  `ticket_number` varchar(15) NOT NULL COMMENT '1 participent 1 ticket number',
28  `participent` text NOT NULL COMMENT 'isi nya data participent atas ticket number tersebut',
29  `foodandbeverage` smallint(1) DEFAULT '1',
30  `status` smallint(1) DEFAULT '1' COMMENT '1:"new";2:"present on event"',
31  `input_un` varchar(20) DEFAULT NULL,
32  `input_time` int(11) DEFAULT NULL,
33  `modified_un` varchar(20) DEFAULT NULL,
34  `modified_time` int(11) DEFAULT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38/*Data for the table `lok_tr_attendence` */
39
40/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
41/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
42/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
43/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;