Mercurial > hg > ismi-richfaces

annotate docs/db/openmind_schema_public_tables_2014.05.06.sql @ 195:5309d29b3061

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
change links in OpenMind UI to use new bibliography on ismi server.
author Robert Casties <casties@mpiwg-berlin.mpg.de>
date Fri, 14 Dec 2018 16:54:05 +0100
parents ded3bccf2cf9
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
6
jurzua
parents:
diff changeset
1 -- MySQL dump 10.11
jurzua
parents:
diff changeset
2 --
jurzua
parents:
diff changeset
3 -- Host: localhost Database: openmind
jurzua
parents:
diff changeset
4 -- ------------------------------------------------------
jurzua
parents:
diff changeset
5 -- Server version 5.0.90-log
jurzua
parents:
diff changeset
6
jurzua
parents:
diff changeset
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
jurzua
parents:
diff changeset
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
jurzua
parents:
diff changeset
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
jurzua
parents:
diff changeset
10 /*!40101 SET NAMES utf8 */;
jurzua
parents:
diff changeset
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
jurzua
parents:
diff changeset
12 /*!40103 SET TIME_ZONE='+00:00' */;
jurzua
parents:
diff changeset
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
jurzua
parents:
diff changeset
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
jurzua
parents:
diff changeset
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
jurzua
parents:
diff changeset
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
jurzua
parents:
diff changeset
17
jurzua
parents:
diff changeset
18
jurzua
parents:
diff changeset
19 DROP TABLE IF EXISTS `viewer_attribute`;
jurzua
parents:
diff changeset
20 /*!40101 SET @saved_cs_client = @@character_set_client */;
jurzua
parents:
diff changeset
21 /*!40101 SET character_set_client = utf8 */;
jurzua
parents:
diff changeset
22 CREATE TABLE `viewer_attribute` (
jurzua
parents:
diff changeset
23 `id` bigint(20) NOT NULL auto_increment,
jurzua
parents:
diff changeset
24 `page` bigint(20) default NULL,
jurzua
parents:
diff changeset
25 `label` varchar(255) default NULL,
jurzua
parents:
diff changeset
26 `query` varchar(255) default NULL,
jurzua
parents:
diff changeset
27 `user` varchar(255) character set utf8 default NULL,
jurzua
parents:
diff changeset
28 `position` int(11) default NULL,
jurzua
parents:
diff changeset
29 `display_mode` int(11) default NULL,
jurzua
parents:
diff changeset
30 `created` datetime default NULL,
jurzua
parents:
diff changeset
31 `updated` datetime default NULL,
jurzua
parents:
diff changeset
32 PRIMARY KEY (`id`)
jurzua
parents:
diff changeset
33 ) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
jurzua
parents:
diff changeset
34 /*!40101 SET character_set_client = @saved_cs_client */;
jurzua
parents:
diff changeset
35
jurzua
parents:
diff changeset
36 --
jurzua
parents:
diff changeset
37 -- Table structure for table `viewer_page`
jurzua
parents:
diff changeset
38 --
jurzua
parents:
diff changeset
39
jurzua
parents:
diff changeset
40 DROP TABLE IF EXISTS `viewer_page`;
jurzua
parents:
diff changeset
41 /*!40101 SET @saved_cs_client = @@character_set_client */;
jurzua
parents:
diff changeset
42 /*!40101 SET character_set_client = utf8 */;
jurzua
parents:
diff changeset
43 CREATE TABLE `viewer_page` (
jurzua
parents:
diff changeset
44 `id` bigint(20) NOT NULL auto_increment,
jurzua
parents:
diff changeset
45 `label` varchar(255) character set utf8 default NULL,
jurzua
parents:
diff changeset
46 `updated` datetime default NULL,
jurzua
parents:
diff changeset
47 `created` datetime default NULL,
jurzua
parents:
diff changeset
48 `user` varchar(255) default NULL,
jurzua
parents:
diff changeset
49 `definition` varchar(255) default NULL,
jurzua
parents:
diff changeset
50 PRIMARY KEY (`id`)
jurzua
parents:
diff changeset
51 ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
jurzua
parents:
diff changeset
52 /*!40101 SET character_set_client = @saved_cs_client */;
jurzua
parents:
diff changeset
53 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
jurzua
parents:
diff changeset
54
jurzua
parents:
diff changeset
55 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
jurzua
parents:
diff changeset
56 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
jurzua
parents:
diff changeset
57 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
jurzua
parents:
diff changeset
58 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
jurzua
parents:
diff changeset
59 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
jurzua
parents:
diff changeset
60 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
jurzua
parents:
diff changeset
61 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
jurzua
parents:
diff changeset
62
jurzua
parents:
diff changeset
63 -- Dump completed on 2014-05-06 11:01:15