/[webpac]/trunk/webpac.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /trunk/webpac.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 9 - (show annotations)
Sat Jan 11 19:55:30 2003 UTC (21 years, 2 months ago) by dpavlin
File size: 1818 byte(s)
renamed "old" index to swish, and introduced index which is -- index;
implemented using PostgreSQL for now.

1 --
2 -- Selected TOC Entries:
3 --
4 \connect - dpavlin
5
6 DROP INDEX "ind_index_author2";
7 DROP INDEX "ind_index_author";
8 DROP INDEX "ind_index_title2";
9 DROP INDEX "ind_index_title";
10 DROP TABLE "index_author";
11 DROP PROCEDURAL LANGUAGE 'plpgsql';
12 \connect - postgres
13
14 DROP FUNCTION "plpgsql_call_handler" ();
15 \connect - dpavlin
16
17 DROP TABLE "index_title";
18 --
19 -- TOC Entry ID 2 (OID 831643)
20 --
21 -- Name: index_title Type: TABLE Owner: dpavlin
22 --
23
24 CREATE TABLE "index_title" (
25 "title" character varying(255)
26 );
27
28 \connect - postgres
29
30 --
31 -- TOC Entry ID 8 (OID 834826)
32 --
33 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
34 --
35
36 CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
37
38 --
39 -- TOC Entry ID 9 (OID 834827)
40 --
41 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
42 --
43
44 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
45
46 \connect - dpavlin
47
48 --
49 -- TOC Entry ID 3 (OID 834828)
50 --
51 -- Name: index_author Type: TABLE Owner: dpavlin
52 --
53
54 CREATE TABLE "index_author" (
55 "author" character varying(255)
56 );
57
58 --
59 -- TOC Entry ID 4 (OID 831645)
60 --
61 -- Name: "ind_index_title" Type: INDEX Owner: dpavlin
62 --
63
64 CREATE INDEX ind_index_title ON index_title USING btree (title);
65
66 --
67 -- TOC Entry ID 5 (OID 831646)
68 --
69 -- Name: "ind_index_title2" Type: INDEX Owner: dpavlin
70 --
71
72 CREATE INDEX ind_index_title2 ON index_title USING btree (upper(title));
73
74 --
75 -- TOC Entry ID 6 (OID 834830)
76 --
77 -- Name: "ind_index_author" Type: INDEX Owner: dpavlin
78 --
79
80 CREATE UNIQUE INDEX ind_index_author ON index_author USING btree (author);
81
82 --
83 -- TOC Entry ID 7 (OID 834831)
84 --
85 -- Name: "ind_index_author2" Type: INDEX Owner: dpavlin
86 --
87
88 CREATE UNIQUE INDEX ind_index_author2 ON index_author USING btree (upper(author));
89

Properties

Name Value
cvs2svn:cvs-rev 1.1

  ViewVC Help
Powered by ViewVC 1.1.26