Mercurial > hg > LGServices
comparison database/LGServices_Schema.sql @ 3:7ffaefcee5b5
Adding database schema.
author | "jurzua <jurzua@mpiwg-berlin.mpg.de>" |
---|---|
date | Tue, 12 May 2015 14:54:13 +0200 |
parents | |
children |
comparison
equal
deleted
inserted
replaced
2:57d19e93f1c3 | 3:7ffaefcee5b5 |
---|---|
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 |