1 |
dpavlin |
1.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 |
|
|
-- |