1 |
-- |
2 |
-- Project: Clipping |
3 |
-- Author: Nelson Ferraz <nferraz@phperl.com> |
4 |
-- Date: 2003-08-14 |
5 |
-- |
6 |
|
7 |
|
8 |
-- |
9 |
-- DROP: CUSTOMER |
10 |
-- |
11 |
|
12 |
DROP TABLE c_customer CASCADE; |
13 |
-- DROP TABLE log_c_customer; |
14 |
|
15 |
DROP SEQUENCE c_customer_c_customer_id_seq; |
16 |
|
17 |
DROP VIEW view_c_customer; |
18 |
|
19 |
-- DROP FUNCTION sp_log_c_customer; |
20 |
-- DROP TRIGGER trig_c_customer; |
21 |
|
22 |
DROP FUNCTION sp_ins_c_customer ( |
23 |
varchar /* c_customer_name */, |
24 |
varchar /* c_customer_phone */, |
25 |
varchar /* c_customer_email */, |
26 |
text /* c_customer_notes */ |
27 |
); |
28 |
|
29 |
DROP FUNCTION sp_upd_c_customer ( |
30 |
int /* id */, |
31 |
varchar /* c_customer_name */, |
32 |
varchar /* c_customer_phone */, |
33 |
varchar /* c_customer_email */, |
34 |
text /* c_customer_notes */ |
35 |
); |
36 |
|
37 |
DROP FUNCTION sp_del_c_customer ( |
38 |
int /* id */ |
39 |
); |
40 |
|
41 |
|
42 |
|
43 |
-- |
44 |
-- DROP: SOURCE |
45 |
-- |
46 |
|
47 |
DROP TABLE c_source CASCADE; |
48 |
-- DROP TABLE log_c_source; |
49 |
|
50 |
DROP SEQUENCE c_source_c_source_id_seq; |
51 |
|
52 |
DROP VIEW view_c_source; |
53 |
|
54 |
-- DROP FUNCTION sp_log_c_source; |
55 |
-- DROP TRIGGER trig_c_source; |
56 |
|
57 |
DROP FUNCTION sp_ins_c_source ( |
58 |
varchar /* c_source_description */, |
59 |
text /* c_source_notes */ |
60 |
); |
61 |
|
62 |
DROP FUNCTION sp_upd_c_source ( |
63 |
int /* id */, |
64 |
varchar /* c_source_description */, |
65 |
text /* c_source_notes */ |
66 |
); |
67 |
|
68 |
DROP FUNCTION sp_del_c_source ( |
69 |
int /* id */ |
70 |
); |
71 |
|
72 |
|
73 |
|
74 |
-- |
75 |
-- DROP: TYPE |
76 |
-- |
77 |
|
78 |
DROP TABLE c_type CASCADE; |
79 |
-- DROP TABLE log_c_type; |
80 |
|
81 |
DROP SEQUENCE c_type_c_type_id_seq; |
82 |
|
83 |
DROP VIEW view_c_type; |
84 |
|
85 |
-- DROP FUNCTION sp_log_c_type; |
86 |
-- DROP TRIGGER trig_c_type; |
87 |
|
88 |
DROP FUNCTION sp_ins_c_type ( |
89 |
varchar /* c_type_description */, |
90 |
text /* c_type_notes */ |
91 |
); |
92 |
|
93 |
DROP FUNCTION sp_upd_c_type ( |
94 |
int /* id */, |
95 |
varchar /* c_type_description */, |
96 |
text /* c_type_notes */ |
97 |
); |
98 |
|
99 |
DROP FUNCTION sp_del_c_type ( |
100 |
int /* id */ |
101 |
); |
102 |
|
103 |
|
104 |
|
105 |
-- |
106 |
-- DROP: NEWS |
107 |
-- |
108 |
|
109 |
DROP TABLE c_news CASCADE; |
110 |
-- DROP TABLE log_c_news; |
111 |
|
112 |
DROP SEQUENCE c_news_c_news_id_seq; |
113 |
|
114 |
DROP VIEW view_c_news; |
115 |
|
116 |
-- DROP FUNCTION sp_log_c_news; |
117 |
-- DROP TRIGGER trig_c_news; |
118 |
|
119 |
DROP FUNCTION sp_ins_c_news ( |
120 |
int /* c_source_fk */, |
121 |
int /* c_customer_fk */, |
122 |
int /* c_type_fk */, |
123 |
varchar /* c_news_section */, |
124 |
varchar /* c_news_page */, |
125 |
varchar /* c_news_title */, |
126 |
text /* c_news_abstract */, |
127 |
text /* c_news_full_text */ |
128 |
); |
129 |
|
130 |
DROP FUNCTION sp_upd_c_news ( |
131 |
int /* id */, |
132 |
int /* c_source_fk */, |
133 |
int /* c_customer_fk */, |
134 |
int /* c_type_fk */, |
135 |
varchar /* c_news_section */, |
136 |
varchar /* c_news_page */, |
137 |
varchar /* c_news_title */, |
138 |
text /* c_news_abstract */, |
139 |
text /* c_news_full_text */ |
140 |
); |
141 |
|
142 |
DROP FUNCTION sp_del_c_news ( |
143 |
int /* id */ |
144 |
); |
145 |
|
146 |
|
147 |
|
148 |
-- END -- |
149 |
|
150 |
-- |
151 |
-- This program is free software; you can redistribute it and/or |
152 |
-- modify it under the terms of the GNU General Public License |
153 |
-- |