projects
/
fusionforge
/
fusionforge.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
project home
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
2985d03
)
FTI DB fixes to clean installation procedure
author
Alain Peyrat
<aljeux@free.fr>
Tue, 28 Oct 2008 19:36:55 +0000
(19:36 +0000)
committer
Alain Peyrat
<aljeux@free.fr>
Tue, 28 Oct 2008 19:36:55 +0000
(19:36 +0000)
gforge/db/FTI-20050530.sql
patch
|
blob
|
history
diff --git
a/gforge/db/FTI-20050530.sql
b/gforge/db/FTI-20050530.sql
index bb92cac8d5c3d2e7f003260b393742c3a263d094..fb7aa327b9856488efcbf2c8c2777628a28adc2e 100644
(file)
--- a/
gforge/db/FTI-20050530.sql
+++ b/
gforge/db/FTI-20050530.sql
@@
-1,10
+1,3
@@
-CREATE TYPE forums_results AS (msg_id integer,
- subject text,
- post_date integer,
- realname character varying(32),
- forum_name text
-);
-
CREATE OR REPLACE FUNCTION forums_search(text, integer, text, boolean) RETURNS SETOF forums_results AS '
DECLARE
data forums_results;
@@
-60,4
+53,4
@@
CREATE OR REPLACE FUNCTION forums_search(text, integer, text, boolean) RETURNS S
END IF;
RETURN;
END;'
-LANGUAGE 'plpgsql';
\ No newline at end of file
+LANGUAGE 'plpgsql';