wp44igbM

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_event` */
20
21DROP TABLE IF EXISTS `lok_tr_event`;
22
23CREATE TABLE `lok_tr_event` (
24  `id` varchar(15) NOT NULL,
25  `user_id` varchar(15) NOT NULL,
26  `event_category_id` varchar(15) NOT NULL,
27  `name` varchar(200) NOT NULL,
28  `address` text,
29  `description` text,
30  `added_value` text NOT NULL,
31  `price` decimal(10,0) NOT NULL DEFAULT '0',
32  `start_date` int(11) DEFAULT NULL,
33  `end_date` int(11) DEFAULT NULL,
34  `status` tinyint(1) NOT NULL,
35  `input_un` varchar(20) NOT NULL,
36  `input_time` int(11) NOT NULL,
37  `modified_un` varchar(20) NOT NULL,
38  `modified_time` int(11) NOT NULL,
39  PRIMARY KEY (`id`,`user_id`,`event_category_id`),
40  UNIQUE KEY `id_UNIQUE` (`id`)
41) ENGINE=InnoDB DEFAULT CHARSET=latin1;
42
43
44
45/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
46/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
47/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
48/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;