1 -- MySQL dump 10.13 Distrib 5.5.24, for Linux (x86_64)
3 -- Host: localhost Database: kyberia
4 -- ------------------------------------------------------
5 -- Server version 5.5.24-log
6 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
7 /*!40103 SET TIME_ZONE='+00:00' */;
8 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
9 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
10 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,POSTGRESQL' */;
11 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
14 -- XXX checks keys everywhere
18 -- Table structure for table "mail"
21 DROP TYPE IF EXISTS "menum" CASCADE;
22 CREATE TYPE menum
AS ENUM ('no','to','from','both');
24 DROP TABLE IF EXISTS "mail";
25 /*!40101 SET @saved_cs_client = @@character_set_client */;
26 /*!40101 SET character_set_client = utf8 */;
28 "mail_id" int NOT NULL,
29 "mail_from" int NOT NULL DEFAULT '0',
30 "mail_to" int NOT NULL DEFAULT '0',
31 "mail_timestamp" timestamp,
32 "mail_read" menum
DEFAULT 'no',
33 "mail_deleted" menum
DEFAULT 'no',
35 -- CREATE UNIQUE INDEX mail_id ON mail (mail_id);
36 -- PRIMARY KEY ("mail_id"),
37 -- KEY "mail_id" ("mail_id"),
38 -- KEY "mail_user_from_to" ("mail_from","mail_to"),
39 -- KEY "mail_user_to_read" ("mail_to","mail_read")
41 /*!40101 SET character_set_client = @saved_cs_client */;
44 -- Table structure for table "neurons"
47 DROP TYPE IF EXISTS "link_enum" CASCADE;
48 CREATE TYPE link_enum
AS ENUM ('hard','soft','bookmark','synapse');
50 DROP TABLE IF EXISTS "neurons";
51 /*!40101 SET @saved_cs_client = @@character_set_client */;
52 /*!40101 SET character_set_client = utf8 */;
53 CREATE TABLE "neurons" (
54 -- "synapse_id" serial NOT NULL,
55 "dst" int DEFAULT NULL,
56 "src" int DEFAULT NULL,
57 "synapse_creator" int NOT NULL DEFAULT '0',
58 "synapse_weight" double precision NOT NULL DEFAULT '1',
59 "link" link_enum
DEFAULT 'soft',
60 "last_impulse" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
61 "synapse_created" timestamp DEFAULT NULL
62 -- UNIQUE KEY "relation" ("dst","src"),
63 -- KEY "central_link" ("dst","link"),
66 /*!40101 SET character_set_client = @saved_cs_client */;
69 -- Table structure for table "node_access"
71 DROP TYPE IF EXISTS "acc_enum" CASCADE;
72 CREATE TYPE acc_enum
AS ENUM ('master','op','access','silence','ban','execute');
74 DROP TABLE IF EXISTS "node_access";
75 /*!40101 SET @saved_cs_client = @@character_set_client */;
76 /*!40101 SET character_set_client = utf8 */;
77 CREATE TABLE "node_access" (
78 "node_id" int NOT NULL DEFAULT '0',
79 "user_id" int NOT NULL DEFAULT '0',
80 "node_permission" acc_enum
DEFAULT NULL,
81 "last_visit" timestamp DEFAULT NULL,
82 "visits" int DEFAULT '0',
83 "given_k" boolean DEFAULT false
84 -- UNIQUE KEY "node_access" ("node_id","user_id"),
87 /*!40101 SET character_set_client = @saved_cs_client */;
91 -- Table structure for table "nodes"
94 DROP TABLE IF EXISTS "nodes";
95 /*!40101 SET @saved_cs_client = @@character_set_client */;
96 /*!40101 SET character_set_client = utf8 */;
97 CREATE TABLE "nodes" (
98 "node_id" serial
NOT NULL,
99 "node_template_id" int DEFAULT NULL,
100 "node_parent" int NOT NULL DEFAULT '0',
101 "node_creator" int NOT NULL DEFAULT '0',
102 "node_external_access" boolean DEFAULT false,
103 "node_created" timestamp DEFAULT NULL,
104 "node_lastchild_created" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
105 "node_lastdescendant_created" timestamp DEFAULT NULL,
106 "node_updated" timestamp DEFAULT NULL,
107 "node_children_count" int DEFAULT '0',
108 "node_k" int DEFAULT '0',
109 "node_views" int DEFAULT NULL,
110 "node_descendant_count" int DEFAULT NULL,
111 "node_name" varchar(128) DEFAULT NULL,
112 "node_external_link" varchar(128) DEFAULT NULL,
114 -- PRIMARY KEY ("node_id"),
115 -- KEY "node_name" ("node_name"),
116 -- KEY "node_creator" ("node_creator"),
117 -- KEY "external_link" ("node_external_link"),
118 -- KEY "node_parent" ("node_parent")
120 /*!40101 SET character_set_client = @saved_cs_client */;
123 -- Table structure for table "tiamat" (XXX sync with nodes)
126 DROP TABLE IF EXISTS "tiamat";
127 /*!40101 SET @saved_cs_client = @@character_set_client */;
128 /*!40101 SET character_set_client = utf8 */;
129 CREATE TABLE "tiamat" (
130 "tiamat_node_id" int NOT NULL DEFAULT '0'
132 /*!40101 SET character_set_client = @saved_cs_client */;
135 -- Table structure for table "users"
136 -- XXX session string
138 -- XXX header_id vs node template_id
139 -- XXX guild_id hardcoded 4738121
140 -- XXX login == select node_name from nodes where node_id=user_id ??? => sync?
141 -- "bookstyle" int(1) NOT NULL DEFAULT '0',
142 -- "password_change_period" int DEFAULT NULL,
145 DROP TYPE IF EXISTS "l_order" CASCADE;
146 CREATE TYPE l_order
AS ENUM ('asc','desc');
149 DROP TABLE IF EXISTS "users";
150 /*!40101 SET @saved_cs_client = @@character_set_client */;
151 /*!40101 SET character_set_client = utf8 */;
152 CREATE TABLE "users" (
153 "user_id" int NOT NULL DEFAULT '0',
154 "login" varchar(128) DEFAULT NULL,
155 "xmpp" varchar(256) DEFAULT NULL,
156 "password" varchar(230) NOT NULL,
157 "register_hash" varchar(128) DEFAULT NULL,
158 "email" varchar(256) DEFAULT NULL,
159 "user_gpg_prv" text DEFAULT NULL,
160 "user_gpg_pub" text DEFAULT NULL,
161 "last_action" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
162 "session_string" varchar(64) DEFAULT NULL,
163 "user_action" varchar(128) DEFAULT NULL,
164 "user_action_id" int DEFAULT NULL,
165 "listing_amount" int DEFAULT '32', -- XXX constant
166 "listing_order" l_order
DEFAULT 'desc',
167 "user_k" int DEFAULT '0',
168 "k_wallet" int DEFAULT '0',
169 "header_id" int DEFAULT NULL,
170 "mail_notify" boolean DEFAULT false,
171 "acc_lockout" timestamp DEFAULT NULL,
172 "moods" varchar(128) DEFAULT NULL,
173 "invisible" boolean DEFAULT false,
174 "login_retry" int NOT NULL DEFAULT '0',
175 "date_last_login" timestamp,
176 "date_password_changed" timestamp NOT NULL,
177 "date_login_failed" timestamp NOT NULL,
178 "user_setting_metadata" text NOT NULL,
180 -- PRIMARY KEY ("user_id"),
181 -- UNIQUE KEY "session_string" ("session_string"),
182 -- UNIQUE KEY "login" ("login")
185 /*!40101 SET character_set_client = @saved_cs_client */;
187 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
189 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
190 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
191 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
192 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
194 -- Dump completed on 2012-07-30 15:14:05
This page took 0.557886 seconds and 4 git commands to generate.