V7sjnU6M

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_price` */
20
21DROP TABLE IF EXISTS `lok_tr_price`;
22
23CREATE TABLE `lok_tr_price` (
24  `id` varchar(15) NOT NULL,
25  `event_id` varchar(15) NOT NULL,
26  `price` decimal(10,0) NOT NULL,
27  `start_date` int(11) NOT NULL,
28  `end_date` int(11) NOT NULL,
29  `type` smallint(1) NOT NULL DEFAULT '1' COMMENT '1:"Early Bird"; 2:"Discount"',
30  `input_un` varchar(20) NOT NULL,
31  `input_time` int(11) NOT NULL,
32  `modified_un` varchar(20) NOT NULL,
33  `modified_time` int(11) NOT NULL,
34  PRIMARY KEY (`id`),
35  UNIQUE KEY `id_UNIQUE` (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;