Verzeichnisstruktur phpBB-3.1.0
- Veröffentlicht
- 27.10.2014
So funktioniert es
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
postgres_schema.sql
01
02 BEGIN;
03
04 /*
05 Domain definition
06 */
07 CREATE DOMAIN varchar_ci AS varchar(255) NOT NULL DEFAULT ''::character varying;
08
09 /*
10 Operation Functions
11 */
12 CREATE FUNCTION _varchar_ci_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) = LOWER($2)' LANGUAGE SQL STRICT;
13 CREATE FUNCTION _varchar_ci_not_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) != LOWER($2)' LANGUAGE SQL STRICT;
14 CREATE FUNCTION _varchar_ci_less_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) < LOWER($2)' LANGUAGE SQL STRICT;
15 CREATE FUNCTION _varchar_ci_less_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) <= LOWER($2)' LANGUAGE SQL STRICT;
16 CREATE FUNCTION _varchar_ci_greater_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) > LOWER($2)' LANGUAGE SQL STRICT;
17 CREATE FUNCTION _varchar_ci_greater_equals(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) >= LOWER($2)' LANGUAGE SQL STRICT;
18
19 /*
20 Operators
21 */
22 CREATE OPERATOR <(
23 PROCEDURE = _varchar_ci_less_than,
24 LEFTARG = varchar_ci,
25 RIGHTARG = varchar_ci,
26 COMMUTATOR = >,
27 NEGATOR = >=,
28 RESTRICT = scalarltsel,
29 JOIN = scalarltjoinsel);
30
31 CREATE OPERATOR <=(
32 PROCEDURE = _varchar_ci_less_equal,
33 LEFTARG = varchar_ci,
34 RIGHTARG = varchar_ci,
35 COMMUTATOR = >=,
36 NEGATOR = >,
37 RESTRICT = scalarltsel,
38 JOIN = scalarltjoinsel);
39
40 CREATE OPERATOR >(
41 PROCEDURE = _varchar_ci_greater_than,
42 LEFTARG = varchar_ci,
43 RIGHTARG = varchar_ci,
44 COMMUTATOR = <,
45 NEGATOR = <=,
46 RESTRICT = scalargtsel,
47 JOIN = scalargtjoinsel);
48
49 CREATE OPERATOR >=(
50 PROCEDURE = _varchar_ci_greater_equals,
51 LEFTARG = varchar_ci,
52 RIGHTARG = varchar_ci,
53 COMMUTATOR = <=,
54 NEGATOR = <,
55 RESTRICT = scalargtsel,
56 JOIN = scalargtjoinsel);
57
58 CREATE OPERATOR <>(
59 PROCEDURE = _varchar_ci_not_equal,
60 LEFTARG = varchar_ci,
61 RIGHTARG = varchar_ci,
62 COMMUTATOR = <>,
63 NEGATOR = =,
64 RESTRICT = neqsel,
65 JOIN = neqjoinsel);
66
67 CREATE OPERATOR =(
68 PROCEDURE = _varchar_ci_equal,
69 LEFTARG = varchar_ci,
70 RIGHTARG = varchar_ci,
71 COMMUTATOR = =,
72 NEGATOR = <>,
73 RESTRICT = eqsel,
74 JOIN = eqjoinsel,
75 HASHES,
76 MERGES,
77 SORT1= <);
78
79 COMMIT;
80
81