database.pgsql 23.6 KB
Newer Older
Dries's avatar
 
Dries committed
1
2
3
--
-- Selected TOC Entries:
--
Dries's avatar
   
Dries committed
4
5
6
7
8
9
10
11
12
13
14
\connect - root
--
-- TOC Entry ID 1 (OID 0)
--
-- Name: drupal Type: DATABASE Owner: root
--

Create Database "drupal";

\connect drupal postgres
\connect - postgres
Dries's avatar
 
Dries committed
15
--
Dries's avatar
   
Dries committed
16
-- TOC Entry ID 92 (OID 18720)
Dries's avatar
 
Dries committed
17
18
19
20
--
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
--

Dries's avatar
   
Dries committed
21
CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
Dries's avatar
 
Dries committed
22
23

--
Dries's avatar
   
Dries committed
24
-- TOC Entry ID 93 (OID 18721)
Dries's avatar
 
Dries committed
25
26
27
28
--
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
--

Dries's avatar
   
Dries committed
29
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
Dries's avatar
 
Dries committed
30
31
32

\connect - root
--
Dries's avatar
   
Dries committed
33
-- TOC Entry ID 27 (OID 46073)
Dries's avatar
 
Dries committed
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
--
-- Name: pga_queries Type: TABLE Owner: root
--

CREATE TABLE "pga_queries" (
  "queryname" character varying(64),
  "querytype" character(1),
  "querycommand" text,
  "querytables" text,
  "querylinks" text,
  "queryresults" text,
  "querycomments" text
);

--
Dries's avatar
   
Dries committed
49
-- TOC Entry ID 28 (OID 46104)
Dries's avatar
 
Dries committed
50
51
52
53
54
55
56
57
58
59
--
-- Name: pga_forms Type: TABLE Owner: root
--

CREATE TABLE "pga_forms" (
  "formname" character varying(64),
  "formsource" text
);

--
Dries's avatar
   
Dries committed
60
-- TOC Entry ID 29 (OID 46130)
Dries's avatar
 
Dries committed
61
62
63
64
65
66
67
68
69
70
--
-- Name: pga_scripts Type: TABLE Owner: root
--

CREATE TABLE "pga_scripts" (
  "scriptname" character varying(64),
  "scriptsource" text
);

--
Dries's avatar
   
Dries committed
71
-- TOC Entry ID 30 (OID 46156)
Dries's avatar
 
Dries committed
72
73
74
75
76
77
78
79
80
81
82
83
84
--
-- Name: pga_reports Type: TABLE Owner: root
--

CREATE TABLE "pga_reports" (
  "reportname" character varying(64),
  "reportsource" text,
  "reportbody" text,
  "reportprocs" text,
  "reportoptions" text
);

--
Dries's avatar
   
Dries committed
85
-- TOC Entry ID 31 (OID 46185)
Dries's avatar
 
Dries committed
86
87
88
89
90
91
92
93
94
95
96
--
-- Name: pga_schema Type: TABLE Owner: root
--

CREATE TABLE "pga_schema" (
  "schemaname" character varying(64),
  "schematables" text,
  "schemalinks" text
);

--
Dries's avatar
   
Dries committed
97
-- TOC Entry ID 2 (OID 46212)
Dries's avatar
 
Dries committed
98
99
100
101
102
103
104
--
-- Name: access_aid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "access_aid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
105
-- TOC Entry ID 32 (OID 46231)
Dries's avatar
 
Dries committed
106
107
108
109
110
111
112
113
114
115
116
117
118
--
-- Name: access Type: TABLE Owner: root
--

CREATE TABLE "access" (
  "aid" integer DEFAULT nextval('"access_aid_seq"'::text) NOT NULL,
  "mask" character varying(255) NOT NULL,
  "type" character varying(255) NOT NULL,
  "status" smallint NOT NULL,
  Constraint "access_pkey" Primary Key ("aid")
);

--
Dries's avatar
   
Dries committed
119
-- TOC Entry ID 3 (OID 46317)
Dries's avatar
 
Dries committed
120
121
122
123
124
125
126
--
-- Name: boxes_bid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "boxes_bid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
127
-- TOC Entry ID 33 (OID 46336)
Dries's avatar
 
Dries committed
128
129
130
131
132
133
134
135
136
137
138
139
140
141
--
-- Name: boxes Type: TABLE Owner: root
--

CREATE TABLE "boxes" (
  "bid" integer DEFAULT nextval('"boxes_bid_seq"'::text) NOT NULL,
  "title" character varying(64) NOT NULL,
  "body" text NOT NULL,
  "info" character varying(128) NOT NULL,
  "type" smallint NOT NULL,
  Constraint "boxes_pkey" Primary Key ("bid")
);

--
Dries's avatar
   
Dries committed
142
-- TOC Entry ID 4 (OID 46369)
Dries's avatar
 
Dries committed
143
144
145
146
147
148
149
--
-- Name: bundle_bid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "bundle_bid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
150
-- TOC Entry ID 34 (OID 46388)
Dries's avatar
 
Dries committed
151
152
153
154
155
156
157
158
159
160
161
162
--
-- Name: bundle Type: TABLE Owner: root
--

CREATE TABLE "bundle" (
  "bid" integer DEFAULT nextval('"bundle_bid_seq"'::text) NOT NULL,
  "title" character varying(255) NOT NULL,
  "attributes" character varying(255) NOT NULL,
  Constraint "bundle_pkey" Primary Key ("bid")
);

--
Dries's avatar
   
Dries committed
163
-- TOC Entry ID 35 (OID 46404)
Dries's avatar
 
Dries committed
164
165
166
167
168
169
170
171
172
173
174
175
--
-- Name: cache Type: TABLE Owner: root
--

CREATE TABLE "cache" (
  "url" character varying(255) NOT NULL,
  "data" text NOT NULL,
  "timestamp" integer NOT NULL,
  Constraint "cache_pkey" Primary Key ("url")
);

--
Dries's avatar
   
Dries committed
176
-- TOC Entry ID 5 (OID 46434)
Dries's avatar
 
Dries committed
177
178
179
180
181
182
183
--
-- Name: category_cid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "category_cid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
184
-- TOC Entry ID 36 (OID 46453)
Dries's avatar
 
Dries committed
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
--
-- Name: category Type: TABLE Owner: root
--

CREATE TABLE "category" (
  "cid" integer DEFAULT nextval('"category_cid_seq"'::text) NOT NULL,
  "name" character varying(32) NOT NULL,
  "type" character varying(16) NOT NULL,
  "post" integer NOT NULL,
  "dump" integer NOT NULL,
  "expire" integer NOT NULL,
  "comment" integer NOT NULL,
  "submission" integer NOT NULL,
  "promote" integer NOT NULL,
  Constraint "category_pkey" Primary Key ("cid")
);

--
Dries's avatar
   
Dries committed
203
-- TOC Entry ID 6 (OID 46475)
Dries's avatar
 
Dries committed
204
205
206
207
208
209
210
--
-- Name: channel_id_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "channel_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
211
-- TOC Entry ID 37 (OID 46494)
Dries's avatar
 
Dries committed
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
--
-- Name: channel Type: TABLE Owner: root
--

CREATE TABLE "channel" (
  "id" integer DEFAULT nextval('"channel_id_seq"'::text) NOT NULL,
  "site" character varying(255) NOT NULL,
  "file" character varying(255) NOT NULL,
  "url" character varying(255) NOT NULL,
  "contact" character varying(255) NOT NULL,
  "timestamp" integer NOT NULL,
  Constraint "channel_pkey" Primary Key ("id")
);

--
Dries's avatar
   
Dries committed
227
-- TOC Entry ID 7 (OID 46513)
Dries's avatar
 
Dries committed
228
229
230
231
232
233
234
--
-- Name: chatevents_id_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "chatevents_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
235
-- TOC Entry ID 38 (OID 46532)
Dries's avatar
 
Dries committed
236
237
238
239
240
241
242
243
244
245
246
247
--
-- Name: chatevents Type: TABLE Owner: root
--

CREATE TABLE "chatevents" (
  "id" integer DEFAULT nextval('"chatevents_id_seq"'::text) NOT NULL,
  "body" character varying(255) NOT NULL,
  "timestamp" integer NOT NULL,
  Constraint "chatevents_pkey" Primary Key ("id")
);

--
Dries's avatar
   
Dries committed
248
-- TOC Entry ID 8 (OID 46548)
Dries's avatar
 
Dries committed
249
250
251
252
253
254
255
--
-- Name: chatmembers_id_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "chatmembers_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
256
-- TOC Entry ID 39 (OID 46567)
Dries's avatar
 
Dries committed
257
258
259
260
261
262
263
264
265
266
267
268
--
-- Name: chatmembers Type: TABLE Owner: root
--

CREATE TABLE "chatmembers" (
  "id" integer DEFAULT nextval('"chatmembers_id_seq"'::text) NOT NULL,
  "nick" character varying(32) NOT NULL,
  "timestamp" integer NOT NULL,
  Constraint "chatmembers_pkey" Primary Key ("id")
);

--
Dries's avatar
   
Dries committed
269
-- TOC Entry ID 9 (OID 46583)
Dries's avatar
 
Dries committed
270
271
272
273
274
275
276
--
-- Name: collection_cid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "collection_cid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
277
-- TOC Entry ID 40 (OID 46602)
Dries's avatar
 
Dries committed
278
279
280
281
282
283
284
285
286
287
288
289
--
-- Name: collection Type: TABLE Owner: root
--

CREATE TABLE "collection" (
  "cid" integer DEFAULT nextval('"collection_cid_seq"'::text) NOT NULL,
  "name" character varying(32) NOT NULL,
  "types" character varying(128) NOT NULL,
  Constraint "collection_pkey" Primary Key ("cid")
);

--
Dries's avatar
   
Dries committed
290
-- TOC Entry ID 10 (OID 46618)
Dries's avatar
 
Dries committed
291
292
293
294
295
296
297
--
-- Name: comments_cid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "comments_cid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
298
-- TOC Entry ID 41 (OID 46637)
Dries's avatar
 
Dries committed
299
300
301
302
303
304
305
306
307
308
309
310
311
--
-- Name: cvs Type: TABLE Owner: root
--

CREATE TABLE "cvs" (
  "username" character varying(32) NOT NULL,
  "files" text NOT NULL,
  "status" smallint NOT NULL,
  "message" text NOT NULL,
  "timestamp" integer NOT NULL
);

--
Dries's avatar
   
Dries committed
312
-- TOC Entry ID 42 (OID 46695)
Dries's avatar
 
Dries committed
313
314
315
316
317
318
319
320
321
322
323
324
--
-- Name: pga_layout Type: TABLE Owner: root
--

CREATE TABLE "pga_layout" (
  "tablename" character varying(64),
  "nrcols" smallint,
  "colnames" text,
  "colwidth" text
);

--
Dries's avatar
   
Dries committed
325
-- TOC Entry ID 11 (OID 46773)
Dries's avatar
 
Dries committed
326
327
328
329
330
331
332
--
-- Name: entry_eid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "entry_eid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
333
-- TOC Entry ID 43 (OID 46792)
Dries's avatar
 
Dries committed
334
335
336
337
338
339
340
341
342
343
344
345
346
--
-- Name: entry Type: TABLE Owner: root
--

CREATE TABLE "entry" (
  "eid" integer DEFAULT nextval('"entry_eid_seq"'::text) NOT NULL,
  "name" character varying NOT NULL,
  "attributes" character varying(32) NOT NULL,
  "collection" character varying(32),
  Constraint "entry_pkey" Primary Key ("eid")
);

--
Dries's avatar
   
Dries committed
347
-- TOC Entry ID 12 (OID 46824)
Dries's avatar
 
Dries committed
348
349
350
351
352
353
354
--
-- Name: feed_fid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "feed_fid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
355
-- TOC Entry ID 44 (OID 46843)
Dries's avatar
 
Dries committed
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
--
-- Name: feed Type: TABLE Owner: root
--

CREATE TABLE "feed" (
  "fid" integer DEFAULT nextval('"feed_fid_seq"'::text) NOT NULL,
  "title" character varying(255) NOT NULL,
  "url" character varying(255) NOT NULL,
  "refresh" integer NOT NULL,
  "uncache" integer NOT NULL,
  "timestamp" integer NOT NULL,
  "attributes" character varying(255) NOT NULL,
  "link" character varying(255) NOT NULL,
  "description" text NOT NULL,
  Constraint "feed_pkey" Primary Key ("fid")
);

--
Dries's avatar
   
Dries committed
374
-- TOC Entry ID 13 (OID 46880)
Dries's avatar
 
Dries committed
375
376
377
378
379
380
381
--
-- Name: file_lid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "file_lid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
382
-- TOC Entry ID 45 (OID 46899)
Dries's avatar
 
Dries committed
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
--
-- Name: file Type: TABLE Owner: root
--

CREATE TABLE "file" (
  "lid" integer DEFAULT nextval('"file_lid_seq"'::text) NOT NULL,
  "nid" integer NOT NULL,
  "version" character varying(10) NOT NULL,
  "url" character varying(255) NOT NULL,
  "downloads" integer NOT NULL,
  "abstract" text NOT NULL,
  "description" text NOT NULL,
  "homepage" character varying(255) NOT NULL,
  Constraint "file_pkey" Primary Key ("lid")
);

--
Dries's avatar
   
Dries committed
400
-- TOC Entry ID 14 (OID 46935)
Dries's avatar
 
Dries committed
401
402
403
404
405
406
407
--
-- Name: forum_lid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "forum_lid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
408
-- TOC Entry ID 15 (OID 46985)
Dries's avatar
 
Dries committed
409
410
411
412
413
414
415
--
-- Name: item_iid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "item_iid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
416
-- TOC Entry ID 46 (OID 47004)
Dries's avatar
 
Dries committed
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
--
-- Name: item Type: TABLE Owner: root
--

CREATE TABLE "item" (
  "iid" integer DEFAULT nextval('"item_iid_seq"'::text) NOT NULL,
  "fid" integer NOT NULL,
  "title" character varying(255) NOT NULL,
  "link" character varying(255) NOT NULL,
  "author" character varying(255) NOT NULL,
  "description" text NOT NULL,
  "timestamp" integer NOT NULL,
  "attributes" character varying(255) NOT NULL,
  Constraint "item_pkey" Primary Key ("iid")
);

--
Dries's avatar
   
Dries committed
434
-- TOC Entry ID 47 (OID 47040)
Dries's avatar
 
Dries committed
435
436
437
438
439
440
441
--
-- Name: layout Type: TABLE Owner: root
--

CREATE TABLE "layout" (
  "userid" integer NOT NULL,
  "block" character varying(64) NOT NULL
Dries's avatar
   
Dries committed
442
);
Dries's avatar
 
Dries committed
443
444

--
Dries's avatar
   
Dries committed
445
-- TOC Entry ID 16 (OID 47051)
Dries's avatar
 
Dries committed
446
--
Dries's avatar
   
Dries committed
447
-- Name: locales_id_seq Type: SEQUENCE Owner: root
Dries's avatar
 
Dries committed
448
449
--

Dries's avatar
   
Dries committed
450
CREATE SEQUENCE "locales_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
Dries's avatar
 
Dries committed
451
452

--
Dries's avatar
   
Dries committed
453
-- TOC Entry ID 48 (OID 47070)
Dries's avatar
 
Dries committed
454
--
Dries's avatar
   
Dries committed
455
-- Name: locales Type: TABLE Owner: root
Dries's avatar
 
Dries committed
456
457
--

Dries's avatar
   
Dries committed
458
459
460
461
462
463
464
465
466
467
468
469
470
471
CREATE TABLE "locales" (
  "id" integer DEFAULT nextval('"locales_id_seq"'::text) NOT NULL,
  "location" character varying(128) NOT NULL,
  "string" text NOT NULL,
  "da" text NOT NULL,
  "fi" text NOT NULL,
  "fr" text NOT NULL,
  "en" text NOT NULL,
  "es" text NOT NULL,
  "nl" text NOT NULL,
  "no" text NOT NULL,
  "sw" text NOT NULL,
  Constraint "locales_pkey" Primary Key ("id")
);
Dries's avatar
 
Dries committed
472
473

--
Dries's avatar
   
Dries committed
474
-- TOC Entry ID 49 (OID 47109)
Dries's avatar
 
Dries committed
475
--
Dries's avatar
   
Dries committed
476
-- Name: modules Type: TABLE Owner: root
Dries's avatar
 
Dries committed
477
478
--

Dries's avatar
   
Dries committed
479
480
481
CREATE TABLE "modules" (
  "name" character varying(64) NOT NULL,
  Constraint "modules_pkey" Primary Key ("name")
Dries's avatar
 
Dries committed
482
483
484
);

--
Dries's avatar
   
Dries committed
485
-- TOC Entry ID 17 (OID 47122)
Dries's avatar
 
Dries committed
486
--
Dries's avatar
   
Dries committed
487
-- Name: node_nid_seq Type: SEQUENCE Owner: root
Dries's avatar
 
Dries committed
488
489
--

Dries's avatar
   
Dries committed
490
CREATE SEQUENCE "node_nid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
Dries's avatar
 
Dries committed
491
492

--
Dries's avatar
   
Dries committed
493
-- TOC Entry ID 50 (OID 47141)
Dries's avatar
 
Dries committed
494
--
Dries's avatar
   
Dries committed
495
-- Name: notify Type: TABLE Owner: root
Dries's avatar
 
Dries committed
496
497
--

Dries's avatar
   
Dries committed
498
499
500
501
502
503
504
505
CREATE TABLE "notify" (
  "uid" integer NOT NULL,
  "status" integer NOT NULL,
  "node" integer NOT NULL,
  "comment" integer NOT NULL,
  "attempts" integer NOT NULL,
  Constraint "notify_pkey" Primary Key ("uid")
);
Dries's avatar
 
Dries committed
506
507

--
Dries's avatar
   
Dries committed
508
-- TOC Entry ID 18 (OID 47211)
Dries's avatar
 
Dries committed
509
--
Dries's avatar
   
Dries committed
510
-- Name: poll_lid_seq Type: SEQUENCE Owner: root
Dries's avatar
 
Dries committed
511
512
--

Dries's avatar
   
Dries committed
513
CREATE SEQUENCE "poll_lid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
Dries's avatar
 
Dries committed
514
515

--
Dries's avatar
   
Dries committed
516
-- TOC Entry ID 51 (OID 47230)
Dries's avatar
 
Dries committed
517
518
519
520
521
522
523
524
525
526
527
528
529
530
--
-- Name: poll Type: TABLE Owner: root
--

CREATE TABLE "poll" (
  "lid" integer DEFAULT nextval('"poll_lid_seq"'::text) NOT NULL,
  "nid" integer NOT NULL,
  "runtime" integer NOT NULL,
  "voters" text NOT NULL,
  "active" integer NOT NULL,
  Constraint "poll_pkey" Primary Key ("lid")
);

--
Dries's avatar
   
Dries committed
531
-- TOC Entry ID 19 (OID 47263)
Dries's avatar
 
Dries committed
532
533
534
535
536
537
538
--
-- Name: poll_choices_chid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "poll_choices_chid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
539
-- TOC Entry ID 52 (OID 47282)
Dries's avatar
 
Dries committed
540
541
542
543
544
545
546
547
548
549
550
551
552
553
--
-- Name: poll_choices Type: TABLE Owner: root
--

CREATE TABLE "poll_choices" (
  "chid" integer DEFAULT nextval('"poll_choices_chid_seq"'::text) NOT NULL,
  "nid" integer NOT NULL,
  "chtext" character varying(128) DEFAULT '' NOT NULL,
  "chvotes" integer NOT NULL,
  "chorder" integer NOT NULL,
  Constraint "poll_choices_pkey" Primary Key ("chid")
);

--
Dries's avatar
   
Dries committed
554
-- TOC Entry ID 53 (OID 47301)
Dries's avatar
 
Dries committed
555
556
557
558
559
560
561
562
563
564
565
566
--
-- Name: rating Type: TABLE Owner: root
--

CREATE TABLE "rating" (
  "userid" integer NOT NULL,
  "new" integer NOT NULL,
  "old" integer NOT NULL,
  Constraint "user_pkey" Primary Key ("userid")
);

--
Dries's avatar
   
Dries committed
567
-- TOC Entry ID 54 (OID 47316)
Dries's avatar
 
Dries committed
568
569
570
571
572
573
574
575
576
577
--
-- Name: referer Type: TABLE Owner: root
--

CREATE TABLE "referer" (
  "url" character varying(255) DEFAULT '' NOT NULL,
  "timestamp" integer NOT NULL
);

--
Dries's avatar
   
Dries committed
578
-- TOC Entry ID 20 (OID 47328)
Dries's avatar
 
Dries committed
579
580
581
582
583
584
585
--
-- Name: role_rid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "role_rid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
586
-- TOC Entry ID 21 (OID 47347)
Dries's avatar
 
Dries committed
587
588
589
590
591
592
593
--
-- Name: site_sid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "site_sid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
594
-- TOC Entry ID 55 (OID 47366)
Dries's avatar
 
Dries committed
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
--
-- Name: site Type: TABLE Owner: root
--

CREATE TABLE "site" (
  "sid" integer DEFAULT nextval('"site_sid_seq"'::text) NOT NULL,
  "name" character varying(128) DEFAULT '' NOT NULL,
  "link" character varying(255) DEFAULT '' NOT NULL,
  "size" text NOT NULL,
  "timestamp" integer NOT NULL,
  "feed" character varying(255) DEFAULT '' NOT NULL,
  Constraint "site_pkey" Primary Key ("sid")
);

--
Dries's avatar
   
Dries committed
610
-- TOC Entry ID 22 (OID 47454)
Dries's avatar
 
Dries committed
611
612
613
614
615
616
617
--
-- Name: tag_tid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "tag_tid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
618
-- TOC Entry ID 56 (OID 47473)
Dries's avatar
 
Dries committed
619
620
621
622
623
624
625
626
627
628
629
630
631
--
-- Name: tag Type: TABLE Owner: root
--

CREATE TABLE "tag" (
  "tid" integer DEFAULT nextval('"tag_tid_seq"'::text) NOT NULL,
  "name" character varying(32) DEFAULT '' NOT NULL,
  "attributes" character varying(255) DEFAULT '' NOT NULL,
  "collections" character varying(32) DEFAULT '' NOT NULL,
  Constraint "tag_pkey" Primary Key ("tid")
);

--
Dries's avatar
   
Dries committed
632
-- TOC Entry ID 23 (OID 47493)
Dries's avatar
 
Dries committed
633
634
635
636
637
638
639
--
-- Name: topic_tid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "topic_tid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
640
-- TOC Entry ID 57 (OID 47512)
Dries's avatar
 
Dries committed
641
642
643
644
645
646
647
648
649
650
651
652
653
--
-- Name: topic Type: TABLE Owner: root
--

CREATE TABLE "topic" (
  "tid" integer DEFAULT nextval('"topic_tid_seq"'::text) NOT NULL,
  "pid" integer NOT NULL,
  "name" character varying(32) DEFAULT '' NOT NULL,
  "moderate" text NOT NULL,
  Constraint "topic_pkey" Primary Key ("tid")
);

--
Dries's avatar
   
Dries committed
654
-- TOC Entry ID 24 (OID 47545)
Dries's avatar
 
Dries committed
655
656
657
658
659
660
661
--
-- Name: trip_link_lid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "trip_link_lid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
662
-- TOC Entry ID 58 (OID 47564)
Dries's avatar
 
Dries committed
663
664
665
666
667
668
669
670
671
672
673
674
675
--
-- Name: trip_link Type: TABLE Owner: root
--

CREATE TABLE "trip_link" (
  "lid" integer DEFAULT nextval('"trip_link_lid_seq"'::text) NOT NULL,
  "nid" integer NOT NULL,
  "url" text NOT NULL,
  "body" text NOT NULL,
  Constraint "trip_link_pkey" Primary Key ("lid")
);

--
Dries's avatar
   
Dries committed
676
-- TOC Entry ID 25 (OID 47596)
Dries's avatar
 
Dries committed
677
678
679
680
681
682
683
--
-- Name: users_uid_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "users_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
684
-- TOC Entry ID 59 (OID 47615)
Dries's avatar
 
Dries committed
685
686
687
688
689
690
691
692
693
694
695
--
-- Name: variable Type: TABLE Owner: root
--

CREATE TABLE "variable" (
  "name" character varying(32) DEFAULT '' NOT NULL,
  "value" text NOT NULL,
  Constraint "variable_pkey" Primary Key ("name")
);

--
Dries's avatar
   
Dries committed
696
-- TOC Entry ID 26 (OID 47645)
Dries's avatar
 
Dries committed
697
698
699
700
701
702
703
--
-- Name: watchdog_id_seq Type: SEQUENCE Owner: root
--

CREATE SEQUENCE "watchdog_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
Dries's avatar
   
Dries committed
704
-- TOC Entry ID 60 (OID 47664)
Dries's avatar
 
Dries committed
705
706
707
708
709
710
--
-- Name: watchdog Type: TABLE Owner: root
--

CREATE TABLE "watchdog" (
  "id" integer DEFAULT nextval('"watchdog_id_seq"'::text) NOT NULL,
Dries's avatar
   
Dries committed
711
  "uid" integer NOT NULL,
Dries's avatar
 
Dries committed
712
713
714
715
716
717
718
719
720
  "type" character varying(16) DEFAULT '' NOT NULL,
  "message" character varying(255) DEFAULT '' NOT NULL,
  "location" character varying(128) DEFAULT '' NOT NULL,
  "hostname" character varying(128) DEFAULT '' NOT NULL,
  "timestamp" integer NOT NULL,
  Constraint "watchdog_pkey" Primary Key ("id")
);

--
Dries's avatar
   
Dries committed
721
-- TOC Entry ID 61 (OID 47688)
Dries's avatar
 
Dries committed
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
--
-- Name: users Type: TABLE Owner: root
--

CREATE TABLE "users" (
  "uid" integer DEFAULT nextval('"users_uid_seq"'::text) NOT NULL,
  "name" character varying(60) DEFAULT '' NOT NULL,
  "mail" character varying(64) DEFAULT '',
  "homepage" character varying(128) DEFAULT '',
  "mode" integer,
  "sort" integer,
  "threshold" integer,
  "theme" character varying(255) DEFAULT '',
  "signature" character varying(255) DEFAULT '',
  "last_access" integer,
  "last_host" character varying(255),
  "status" integer NOT NULL,
  "timezone" character varying(8),
  "rating" numeric(8,2),
  "language" character(2) DEFAULT '',
  "role" character varying(32) DEFAULT '' NOT NULL,
  "session" character varying(128) DEFAULT '',
  "hostname" character varying(128) DEFAULT '',
  "timestamp" integer NOT NULL,
  "jabber" character varying(128) DEFAULT '',
  "drupal" character varying(128) DEFAULT '',
  "init" character varying(64) DEFAULT '',
  "real_email" character varying(64) DEFAULT '',
  "pass" character varying(32) DEFAULT '',
  Constraint "users_pkey" Primary Key ("uid")
);

--
Dries's avatar
   
Dries committed
755
-- TOC Entry ID 62 (OID 47739)
Dries's avatar
 
Dries committed
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
--
-- Name: blocks Type: TABLE Owner: root
--

CREATE TABLE "blocks" (
  "name" character varying(64) NOT NULL,
  "module" character varying(64) NOT NULL,
  "delta" smallint NOT NULL,
  "status" smallint,
  "weight" smallint,
  "region" smallint,
  "remove" smallint,
  Constraint "blocks_pkey" Primary Key ("name")
);

--
Dries's avatar
   
Dries committed
772
-- TOC Entry ID 63 (OID 47758)
Dries's avatar
 
Dries committed
773
774
775
776
777
778
779
780
781
782
783
784
--
-- Name: role Type: TABLE Owner: root
--

CREATE TABLE "role" (
  "rid" integer DEFAULT nextval('"role_rid_seq"'::text) NOT NULL,
  "name" character varying(32) DEFAULT '' NOT NULL,
  "perm" text,
  Constraint "role_pkey" Primary Key ("rid")
);

--
Dries's avatar
   
Dries committed
785
-- TOC Entry ID 64 (OID 47790)
Dries's avatar
 
Dries committed
786
787
788
789
790
791
792
793
794
795
--
-- Name: node Type: TABLE Owner: root
--

CREATE TABLE "node" (
  "nid" integer DEFAULT nextval('"node_nid_seq"'::text) NOT NULL,
  "lid" integer NOT NULL,
  "type" character varying(16) NOT NULL,
  "score" integer NOT NULL,
  "votes" integer NOT NULL,
Dries's avatar
   
Dries committed
796
  "uid" integer NOT NULL,
Dries's avatar
 
Dries committed
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
  "status" integer NOT NULL,
  "timestamp" integer NOT NULL,
  "comment" smallint NOT NULL,
  "promote" smallint NOT NULL,
  "moderate" text NOT NULL,
  "users" text,
  "timestamp_posted" integer,
  "timestamp_queued" integer,
  "timestamp_hidden" integer,
  "attributes" character varying(255),
  "title" character varying(128),
  Constraint "node_pkey" Primary Key ("nid")
);

--
Dries's avatar
   
Dries committed
812
-- TOC Entry ID 65 (OID 47871)
Dries's avatar
 
Dries committed
813
--
Dries's avatar
   
Dries committed
814
-- Name: moderate Type: TABLE Owner: root
Dries's avatar
 
Dries committed
815
816
--

Dries's avatar
   
Dries committed
817
818
819
820
821
822
823
CREATE TABLE "moderate" (
  "cid" integer,
  "nid" integer,
  "uid" integer NOT NULL,
  "score" smallint NOT NULL,
  "timestamp" integer NOT NULL
);
Dries's avatar
 
Dries committed
824
825

--
Dries's avatar
   
Dries committed
826
-- TOC Entry ID 66 (OID 47885)
Dries's avatar
 
Dries committed
827
--
Dries's avatar
   
Dries committed
828
-- Name: comments Type: TABLE Owner: root
Dries's avatar
 
Dries committed
829
830
--

Dries's avatar
   
Dries committed
831
832
CREATE TABLE "comments" (
  "cid" integer DEFAULT nextval('"comments_cid_seq"'::text) NOT NULL,
Dries's avatar
 
Dries committed
833
  "pid" integer NOT NULL,
Dries's avatar
   
Dries committed
834
835
836
837
838
839
840
841
  "lid" integer NOT NULL,
  "uid" integer NOT NULL,
  "subject" character varying(64) NOT NULL,
  "comment" text NOT NULL,
  "hostname" character varying(128) NOT NULL,
  "timestamp" integer NOT NULL,
  "link" character varying(16) NOT NULL,
  Constraint "comments_pkey" Primary Key ("cid")
Dries's avatar
 
Dries committed
842
843
844
);

--
Dries's avatar
   
Dries committed
845
-- TOC Entry ID 67 (OID 48008)
Dries's avatar
 
Dries committed
846
--
Dries's avatar
   
Dries committed
847
-- Name: blog Type: TABLE Owner: root
Dries's avatar
 
Dries committed
848
849
--

Dries's avatar
   
Dries committed
850
851
852
853
CREATE TABLE "blog" (
  "nid" integer NOT NULL,
  "body" text NOT NULL
);
Dries's avatar
 
Dries committed
854
855

--
Dries's avatar
   
Dries committed
856
-- TOC Entry ID 68 (OID 48061)
Dries's avatar
 
Dries committed
857
--
Dries's avatar
   
Dries committed
858
-- Name: story Type: TABLE Owner: root
Dries's avatar
 
Dries committed
859
860
--

Dries's avatar
   
Dries committed
861
862
863
864
CREATE TABLE "story" (
  "nid" integer NOT NULL,
  "abstract" text NOT NULL,
  "body" text NOT NULL
Dries's avatar
 
Dries committed
865
866
867
);

--
Dries's avatar
   
Dries committed
868
-- TOC Entry ID 69 (OID 48116)
Dries's avatar
 
Dries committed
869
--
Dries's avatar
   
Dries committed
870
-- Name: page Type: TABLE Owner: root
Dries's avatar
 
Dries committed
871
872
--

Dries's avatar
   
Dries committed
873
874
875
876
877
878
CREATE TABLE "page" (
  "nid" integer NOT NULL,
  "link" character varying(128) DEFAULT '' NOT NULL,
  "body" text NOT NULL,
  "format" integer NOT NULL
);
Dries's avatar
 
Dries committed
879
880

--
Dries's avatar
   
Dries committed
881
-- TOC Entry ID 70 (OID 48171)
Dries's avatar
 
Dries committed
882
--
Dries's avatar
   
Dries committed
883
-- Name: forum Type: TABLE Owner: root
Dries's avatar
 
Dries committed
884
885
--

Dries's avatar
   
Dries committed
886
887
888
CREATE TABLE "forum" (
  "nid" integer NOT NULL,
  "body" text NOT NULL
Dries's avatar
 
Dries committed
889
890
891
);

--
Dries's avatar
   
Dries committed
892
-- TOC Entry ID 71 (OID 48228)
Dries's avatar
 
Dries committed
893
--
Dries's avatar
   
Dries committed
894
-- Name: book Type: TABLE Owner: root
Dries's avatar
 
Dries committed
895
896
--

Dries's avatar
   
Dries committed
897
898
899
900
901
902
903
904
905
CREATE TABLE "book" (
  "nid" integer NOT NULL,
  "body" text NOT NULL,
  "section" integer,
  "parent" integer NOT NULL,
  "weight" integer NOT NULL,
  "pid" integer NOT NULL,
  "log" text NOT NULL
);
Dries's avatar
 
Dries committed
906
907

--
Dries's avatar
   
Dries committed
908
-- TOC Entry ID 72 (OID 46231)
Dries's avatar
 
Dries committed
909
910
911
912
913
914
915
--
-- Name: "mask_access_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "mask_access_ukey" on "access" using btree ( "mask" "varchar_ops" );

--
Dries's avatar
   
Dries committed
916
-- TOC Entry ID 73 (OID 46336)
Dries's avatar
 
Dries committed
917
918
919
920
921
922
923
--
-- Name: "title_boxes_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "title_boxes_ukey" on "boxes" using btree ( "title" "varchar_ops" );

--
Dries's avatar
   
Dries committed
924
-- TOC Entry ID 74 (OID 46336)
Dries's avatar
 
Dries committed
925
926
927
928
929
930
931
--
-- Name: "info_boxes_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "info_boxes_ukey" on "boxes" using btree ( "info" "varchar_ops" );

--
Dries's avatar
   
Dries committed
932
-- TOC Entry ID 75 (OID 46453)
Dries's avatar
 
Dries committed
933
934
935
936
937
938
939
--
-- Name: "name_category_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "name_category_ukey" on "category" using btree ( "name" "varchar_ops" );

--
Dries's avatar
   
Dries committed
940
-- TOC Entry ID 76 (OID 46494)
Dries's avatar
 
Dries committed
941
942
943
944
945
946
947
--
-- Name: "url_channel_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "url_channel_ukey" on "channel" using btree ( "url" "varchar_ops" );

--
Dries's avatar
   
Dries committed
948
-- TOC Entry ID 77 (OID 46494)
Dries's avatar
 
Dries committed
949
950
951
952
953
954
955
--
-- Name: "file_channel_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "file_channel_ukey" on "channel" using btree ( "file" "varchar_ops" );

--
Dries's avatar
   
Dries committed
956
-- TOC Entry ID 78 (OID 46494)
Dries's avatar
 
Dries committed
957
958
959
960
961
962
963
--
-- Name: "site_channel_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "site_channel_ukey" on "channel" using btree ( "site" "varchar_ops" );

--
Dries's avatar
   
Dries committed
964
-- TOC Entry ID 79 (OID 46602)
Dries's avatar
 
Dries committed
965
966
967
968
969
970
971
--
-- Name: "name_collection_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "name_collection_ukey" on "collection" using btree ( "name" "varchar_ops" );

--
Dries's avatar
   
Dries committed
972
-- TOC Entry ID 80 (OID 46792)
Dries's avatar
 
Dries committed
973
974
975
976
977
978
979
--
-- Name: "entry_namcoll_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "entry_namcoll_ukey" on "entry" using btree ( "name" "varchar_ops", "collection" "varchar_ops" );

--
Dries's avatar
   
Dries committed
980
-- TOC Entry ID 81 (OID 46843)
Dries's avatar
 
Dries committed
981
982
983
984
985
986
987
--
-- Name: "url_feed_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "url_feed_ukey" on "feed" using btree ( "url" "varchar_ops" );

--
Dries's avatar
   
Dries committed
988
-- TOC Entry ID 82 (OID 46843)
Dries's avatar
 
Dries committed
989
990
991
992
993
994
995
--
-- Name: "title_feed_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "title_feed_ukey" on "feed" using btree ( "title" "varchar_ops" );

--
Dries's avatar
   
Dries committed
996
-- TOC Entry ID 83 (OID 47366)
Dries's avatar
 
Dries committed
997
998
999
1000
1001
1002
1003
--
-- Name: "link_site_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "link_site_ukey" on "site" using btree ( "link" "varchar_ops" );

--
Dries's avatar
   
Dries committed
1004
-- TOC Entry ID 84 (OID 47366)
Dries's avatar
 
Dries committed
1005
1006
1007
1008
1009
1010
1011
--
-- Name: "name_site_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "name_site_ukey" on "site" using btree ( "name" "varchar_ops" );

--
Dries's avatar
   
Dries committed
1012
-- TOC Entry ID 85 (OID 47473)
Dries's avatar
 
Dries committed
1013
1014
1015
1016
1017
1018
1019
--
-- Name: "tag_namecoll_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "tag_namecoll_ukey" on "tag" using btree ( "name" "varchar_ops", "collections" "varchar_ops" );

--
Dries's avatar
   
Dries committed
1020
-- TOC Entry ID 86 (OID 47512)
Dries's avatar
 
Dries committed
1021
1022
1023
1024
1025
1026
1027
--
-- Name: "name_topic_ukey" Type: INDEX Owner: root
--

CREATE UNIQUE INDEX "name_topic_ukey" on "topic" using btree ( "name" "varchar_ops" );

--
Dries's avatar
   
Dries committed
1028
1029
1030
1031
1032
1033
1034
1035
1036
-- TOC Entry ID 91 (OID 47790)
--
-- Name: "uid_node_key" Type: INDEX Owner: root
--

CREATE  INDEX "uid_node_key" on "node" using btree ( "uid" "int4_ops" );

--
-- TOC Entry ID 87 (OID 47871)
Dries's avatar
 
Dries committed
1037
1038
1039
1040
1041
1042
1043
--
-- Name: "moderate_cid_key" Type: INDEX Owner: root
--

CREATE  INDEX "moderate_cid_key" on "moderate" using btree ( "cid" "int4_ops" );

--
Dries's avatar
   
Dries committed
1044
-- TOC Entry ID 88 (OID 47871)
Dries's avatar
 
Dries committed
1045
1046
1047
1048
1049
1050
1051
--
-- Name: "moderate_nid_key" Type: INDEX Owner: root
--

CREATE  INDEX "moderate_nid_key" on "moderate" using btree ( "nid" "int4_ops" );

--
Dries's avatar
   
Dries committed
1052
-- TOC Entry ID 89 (OID 47885)
Dries's avatar
 
Dries committed
1053
1054
1055
1056
1057
1058
--
-- Name: "lid_comments_key" Type: INDEX Owner: root
--

CREATE  INDEX "lid_comments_key" on "comments" using btree ( "lid" "int4_ops" );

Dries's avatar
   
Dries committed
1059
1060
1061
1062
1063
1064
1065
1066
--
-- TOC Entry ID 90 (OID 47885)
--
-- Name: "uid_comments_key" Type: INDEX Owner: root
--

CREATE  INDEX "uid_comments_key" on "comments" using btree ( "uid" "int4_ops" );