/[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

Annotation of /trunk/webpac.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 9 - (hide 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 dpavlin 9 --
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