/[debian]/quickappoint/trunk/debian/patches/pgsql.dpatch
ViewVC logotype

Contents of /quickappoint/trunk/debian/patches/pgsql.dpatch

Parent Directory Parent Directory | Revision Log Revision Log


Revision 143 - (show annotations)
Sat Feb 25 17:48:46 2006 UTC (15 years, 4 months ago) by gregoa
File size: 1752 byte(s)
Load quickappoint-0.1+svn20051119 into debian/quickappoint/trunk.

1 #! /bin/sh /usr/share/dpatch/dpatch-run
2 ## pgsql.dpatch by <gregor+debian@comodo.priv.at>
3 ##
4 ## All lines beginning with `## DP:' are a description of the patch.
5 ## DP: No description.
6
7 @DPATCH@
8 diff -urNad quickappoint-0.1+svn20051119~/doc/dump.sql quickappoint-0.1+svn20051119/doc/dump.sql
9 --- quickappoint-0.1+svn20051119~/doc/dump.sql 2005-11-20 00:19:30.000000000 +0100
10 +++ quickappoint-0.1+svn20051119/doc/dump.sql 2005-11-20 00:23:03.000000000 +0100
11 @@ -8,24 +8,6 @@
12 SET search_path = public, pg_catalog;
13
14 --
15 --- TOC entry 20 (OID 52099)
16 --- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: philipp
17 ---
18 -
19 -CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
20 - AS '$libdir/plpgsql', 'plpgsql_call_handler'
21 - LANGUAGE c;
22 -
23 -
24 ---
25 --- TOC entry 18 (OID 52100)
26 --- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner:
27 ---
28 -
29 -CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
30 -
31 -
32 ---
33 -- TOC entry 5 (OID 21697)
34 -- Name: person; Type: TABLE; Schema: public; Owner: gregoa
35 --
36 @@ -262,3 +244,13 @@
37 COMMENT ON COLUMN permission.manageperson IS 'if true, the person may add or remove persons for this appointment.';
38
39
40 +-- additional SQL commands
41 +ALTER USER quickappoint PASSWORD 'quickappoint';
42 +GRANT ALL ON DATABASE quickappoint TO quickappoint;
43 +GRANT USAGE ON SCHEMA public TO quickappoint;
44 +GRANT ALL ON TABLE appointment TO quickappoint;
45 +GRANT ALL ON TABLE person TO quickappoint;
46 +GRANT ALL ON TABLE permission TO quickappoint;
47 +GRANT ALL ON TABLE proposal TO quickappoint;
48 +GRANT ALL ON TABLE response TO quickappoint;
49 +INSERT INTO person VALUES (1, 'quick', '7d8e1de4afe448799eca785ed3c42095', 'Local Quickappoint Admin', NULL, true, true, '');

Properties

Name Value
svn:executable *

  ViewVC Help
Powered by ViewVC 1.1.26