|
3
|
1 -- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64)
|
|
|
2 --
|
|
|
3 -- Host: localhost Database: LGServices
|
|
|
4 -- ------------------------------------------------------
|
|
|
5 -- Server version 5.5.43-0ubuntu0.14.04.1
|
|
|
6
|
|
|
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
|
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
|
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
|
10 /*!40101 SET NAMES utf8 */;
|
|
|
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
|
12 /*!40103 SET TIME_ZONE='+00:00' */;
|
|
|
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
|
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
|
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
|
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
17
|
|
|
18 --
|
|
|
19 -- Table structure for table `Branch`
|
|
|
20 --
|
|
|
21
|
|
|
22 DROP TABLE IF EXISTS `Branch`;
|
|
|
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
24 /*!40101 SET character_set_client = utf8 */;
|
|
|
25 CREATE TABLE `Branch` (
|
|
|
26 `id` bigint(20) NOT NULL,
|
|
|
27 `creationDate` datetime DEFAULT NULL,
|
|
|
28 `lastChangeDate` datetime DEFAULT NULL,
|
|
|
29 `bookId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
30 `bookName` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
|
|
|
31 `contributors` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
32 `currentLastFileId` bigint(20) DEFAULT NULL,
|
|
|
33 `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
34 `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
35 `sectionId` bigint(20) DEFAULT NULL,
|
|
|
36 `sectionName` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
|
|
|
37 `userId` bigint(20) DEFAULT NULL,
|
|
|
38 PRIMARY KEY (`id`)
|
|
|
39 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
40 /*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
41
|
|
|
42 --
|
|
|
43 -- Table structure for table `File`
|
|
|
44 --
|
|
|
45
|
|
|
46 DROP TABLE IF EXISTS `File`;
|
|
|
47 /*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
48 /*!40101 SET character_set_client = utf8 */;
|
|
|
49 CREATE TABLE `File` (
|
|
|
50 `id` bigint(20) NOT NULL,
|
|
|
51 `creationDate` datetime DEFAULT NULL,
|
|
|
52 `lastChangeDate` datetime DEFAULT NULL,
|
|
|
53 `branchId` bigint(20) DEFAULT NULL,
|
|
|
54 `dvId` bigint(20) DEFAULT NULL,
|
|
|
55 `fileName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
56 `lastVersion` bit(1) DEFAULT NULL,
|
|
|
57 `notes` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
58 `userId` bigint(20) DEFAULT NULL,
|
|
|
59 `version` int(11) DEFAULT NULL,
|
|
|
60 PRIMARY KEY (`id`)
|
|
|
61 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
62 /*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
63
|
|
|
64 --
|
|
|
65 -- Table structure for table `hibernate_sequences`
|
|
|
66 --
|
|
|
67
|
|
|
68 DROP TABLE IF EXISTS `hibernate_sequences`;
|
|
|
69 /*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
70 /*!40101 SET character_set_client = utf8 */;
|
|
|
71 CREATE TABLE `hibernate_sequences` (
|
|
|
72 `sequence_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
73 `sequence_next_hi_value` int(11) DEFAULT NULL
|
|
|
74 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
75 /*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
76
|
|
|
77 --
|
|
|
78 -- Table structure for table `row_sequence`
|
|
|
79 --
|
|
|
80
|
|
|
81 DROP TABLE IF EXISTS `row_sequence`;
|
|
|
82 /*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
83 /*!40101 SET character_set_client = utf8 */;
|
|
|
84 CREATE TABLE `row_sequence` (
|
|
|
85 `id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
86 `last_value` bigint(20) DEFAULT NULL,
|
|
|
87 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
|
88 PRIMARY KEY (`id`)
|
|
|
89 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
90 /*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
91
|
|
|
92 --
|
|
|
93 -- Table structure for table `test`
|
|
|
94 --
|
|
|
95
|
|
|
96 DROP TABLE IF EXISTS `test`;
|
|
|
97 /*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
98 /*!40101 SET character_set_client = utf8 */;
|
|
|
99 CREATE TABLE `test` (
|
|
|
100 `test_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
101 `name` varchar(255) DEFAULT NULL,
|
|
|
102 PRIMARY KEY (`test_id`)
|
|
|
103 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='latin1_swedish_ci';
|
|
|
104 /*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
105 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
106
|
|
|
107 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
|
108 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
|
109 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
|
110 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
|
111 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
|
112 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
|
113 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
114
|
|
|
115 -- Dump completed on 2015-05-12 14:53:23
|
