1 |
-- |
2 |
-- Project: Clipping |
3 |
-- Author: Nelson Ferraz <nferraz@phperl.com> |
4 |
-- Date: 2003-08-14 |
5 |
-- |
6 |
|
7 |
|
8 |
-- |
9 |
-- VIEW: CUSTOMER |
10 |
-- |
11 |
|
12 |
CREATE VIEW view_c_customer AS |
13 |
SELECT |
14 |
c_customer_id, |
15 |
c_customer_name, |
16 |
c_customer_phone, |
17 |
c_customer_email, |
18 |
c_customer_notes, |
19 |
c_customer_date_created, |
20 |
c_customer_date_updated, |
21 |
c_customer_date_deleted |
22 |
FROM c_customer |
23 |
; |
24 |
|
25 |
|
26 |
|
27 |
-- |
28 |
-- VIEW: SOURCE |
29 |
-- |
30 |
|
31 |
CREATE VIEW view_c_source AS |
32 |
SELECT |
33 |
c_source_id, |
34 |
c_source_description, |
35 |
c_source_notes, |
36 |
c_source_date_created, |
37 |
c_source_date_updated, |
38 |
c_source_date_deleted |
39 |
FROM c_source |
40 |
; |
41 |
|
42 |
|
43 |
|
44 |
-- |
45 |
-- VIEW: TYPE |
46 |
-- |
47 |
|
48 |
CREATE VIEW view_c_type AS |
49 |
SELECT |
50 |
c_type_id, |
51 |
c_type_description, |
52 |
c_type_notes, |
53 |
c_type_date_created, |
54 |
c_type_date_updated, |
55 |
c_type_date_deleted |
56 |
FROM c_type |
57 |
; |
58 |
|
59 |
|
60 |
|
61 |
-- |
62 |
-- VIEW: NEWS |
63 |
-- |
64 |
|
65 |
CREATE VIEW view_c_news AS |
66 |
SELECT |
67 |
c_source_id, |
68 |
c_source_description, |
69 |
c_source_notes, |
70 |
c_customer_id, |
71 |
c_customer_name, |
72 |
c_customer_phone, |
73 |
c_customer_email, |
74 |
c_customer_notes, |
75 |
c_type_id, |
76 |
c_type_description, |
77 |
c_type_notes, |
78 |
c_news_id, |
79 |
c_news_section, |
80 |
c_news_page, |
81 |
c_news_title, |
82 |
c_news_abstract, |
83 |
c_news_full_text, |
84 |
c_news_date_created, |
85 |
c_news_date_updated, |
86 |
c_news_date_deleted |
87 |
FROM c_news |
88 |
LEFT JOIN c_source ON (c_source.c_source_id = c_news.c_source_fk) |
89 |
LEFT JOIN c_customer ON (c_customer.c_customer_id = c_news.c_customer_fk) |
90 |
LEFT JOIN c_type ON (c_type.c_type_id = c_news.c_type_fk); |
91 |
|
92 |
|
93 |
|
94 |
-- END -- |
95 |
|
96 |
-- |
97 |
-- This program is free software; you can redistribute it and/or |
98 |
-- modify it under the terms of the GNU General Public License |
99 |
-- |