clipping/db/clipping_create.sql

--
-- Project: Clipping
-- Author:  Nelson Ferraz <nferraz@phperl.com>
-- Date:    2003-08-14
--


--
-- TABLE: CUSTOMER
--

CREATE TABLE c_customer (
        c_customer_id   serial primary key,
        c_customer_name varchar(100) not null,
        c_customer_phone        varchar(50),
        c_customer_email        varchar(50),
        c_customer_notes        text,
        c_customer_date_created timestamp DEFAULT NOW(),
        c_customer_date_updated timestamp,
        c_customer_date_deleted timestamp
);


--
-- TABLE: CUSTOMER LOG
--

/*
CREATE TABLE log_c_customer (
        log_c_customer_id       serial primary key,
        c_customer_id   int,
        c_customer_name varchar(100) not null,
        c_customer_phone        varchar(50),
        c_customer_email        varchar(50),
        c_customer_notes        text,
        c_customer_date_created datetime,
        c_customer_date_updated datetime,
        c_customer_date_deleted datetime,
        is_active       boolean DEFAULT 't' NOT NULL
);
*/


--
-- TABLE: SOURCE
--

CREATE TABLE c_source (
        c_source_id     serial primary key,
        c_source_description    varchar(100) not null,
        c_source_notes  text,
        c_source_date_created   timestamp DEFAULT NOW(),
        c_source_date_updated   timestamp,
        c_source_date_deleted   timestamp
);


--
-- TABLE: SOURCE LOG
--

/*
CREATE TABLE log_c_source (
        log_c_source_id serial primary key,
        c_source_id     int,
        c_source_description    varchar(100) not null,
        c_source_notes  text,
        c_source_date_created   datetime,
        c_source_date_updated   datetime,
        c_source_date_deleted   datetime,
        is_active       boolean DEFAULT 't' NOT NULL
);
*/


--
-- TABLE: TYPE
--

CREATE TABLE c_type (
        c_type_id       serial primary key,
        c_type_description      varchar(50) not null,
        c_type_notes    text,
        c_type_date_created     timestamp DEFAULT NOW(),
        c_type_date_updated     timestamp,
        c_type_date_deleted     timestamp
);


--
-- TABLE: TYPE LOG
--

/*
CREATE TABLE log_c_type (
        log_c_type_id   serial primary key,
        c_type_id       int,
        c_type_description      varchar(50) not null,
        c_type_notes    text,
        c_type_date_created     datetime,
        c_type_date_updated     datetime,
        c_type_date_deleted     datetime,
        is_active       boolean DEFAULT 't' NOT NULL
);
*/


--
-- TABLE: NEWS
--

CREATE TABLE c_news (
        c_news_id       serial primary key,
        c_source_fk     int references c_source,
        c_customer_fk   int references c_customer,
        c_type_fk       int references c_type,
        c_news_section  varchar(100),
        c_news_page     varchar(250),
        c_news_title    varchar(100) not null,
        c_news_abstract text not null,
        c_news_full_text        text,
        c_news_date_created     timestamp DEFAULT NOW(),
        c_news_date_updated     timestamp,
        c_news_date_deleted     timestamp
);


--
-- TABLE: NEWS LOG
--

/*
CREATE TABLE log_c_news (
        log_c_news_id   serial primary key,
        c_source_id     int,
        c_source_description    varchar(100) not null,
        c_source_notes  text,
        c_customer_id   int,
        c_customer_name varchar(100) not null,
        c_customer_phone        varchar(50),
        c_customer_email        varchar(50),
        c_customer_notes        text,
        c_type_id       int,
        c_type_description      varchar(50) not null,
        c_type_notes    text,
        c_news_id       int,
        c_news_section  varchar(100),
        c_news_page     varchar(250),
        c_news_title    varchar(100) not null,
        c_news_abstract text not null,
        c_news_full_text        text,
        c_news_date_created     datetime,
        c_news_date_updated     datetime,
        c_news_date_deleted     datetime,
        is_active       boolean DEFAULT 't' NOT NULL
);
*/


-- END --

--
-- This program is free software; you can redistribute it and/or
-- modify it under the terms of the GNU General Public License
--
1	--
2	-- Project: Clipping
3	-- Author: Nelson Ferraz <nferraz@phperl.com>
4	-- Date: 2003-08-14
5	--
6
7
8	--
9	-- TABLE: CUSTOMER
10	--
11
12	CREATE TABLE c_customer (
13	c_customer_id serial primary key,
14	c_customer_name varchar(100) not null,
15	c_customer_phone varchar(50),
16	c_customer_email varchar(50),
17	c_customer_notes text,
18	c_customer_date_created timestamp DEFAULT NOW(),
19	c_customer_date_updated timestamp,
20	c_customer_date_deleted timestamp
21	);
22
23
24	--
25	-- TABLE: CUSTOMER LOG
26	--
27
28	/*
29	CREATE TABLE log_c_customer (
30	log_c_customer_id serial primary key,
31	c_customer_id int,
32	c_customer_name varchar(100) not null,
33	c_customer_phone varchar(50),
34	c_customer_email varchar(50),
35	c_customer_notes text,
36	c_customer_date_created datetime,
37	c_customer_date_updated datetime,
38	c_customer_date_deleted datetime,
39	is_active boolean DEFAULT 't' NOT NULL
40	);
41	*/
42
43
44
45	--
46	-- TABLE: SOURCE
47	--
48
49	CREATE TABLE c_source (
50	c_source_id serial primary key,
51	c_source_description varchar(100) not null,
52	c_source_notes text,
53	c_source_date_created timestamp DEFAULT NOW(),
54	c_source_date_updated timestamp,
55	c_source_date_deleted timestamp
56	);
57
58
59	--
60	-- TABLE: SOURCE LOG
61	--
62
63	/*
64	CREATE TABLE log_c_source (
65	log_c_source_id serial primary key,
66	c_source_id int,
67	c_source_description varchar(100) not null,
68	c_source_notes text,
69	c_source_date_created datetime,
70	c_source_date_updated datetime,
71	c_source_date_deleted datetime,
72	is_active boolean DEFAULT 't' NOT NULL
73	);
74	*/
75
76
77
78	--
79	-- TABLE: TYPE
80	--
81
82	CREATE TABLE c_type (
83	c_type_id serial primary key,
84	c_type_description varchar(50) not null,
85	c_type_notes text,
86	c_type_date_created timestamp DEFAULT NOW(),
87	c_type_date_updated timestamp,
88	c_type_date_deleted timestamp
89	);
90
91
92	--
93	-- TABLE: TYPE LOG
94	--
95
96	/*
97	CREATE TABLE log_c_type (
98	log_c_type_id serial primary key,
99	c_type_id int,
100	c_type_description varchar(50) not null,
101	c_type_notes text,
102	c_type_date_created datetime,
103	c_type_date_updated datetime,
104	c_type_date_deleted datetime,
105	is_active boolean DEFAULT 't' NOT NULL
106	);
107	*/
108
109
110
111	--
112	-- TABLE: NEWS
113	--
114
115	CREATE TABLE c_news (
116	c_news_id serial primary key,
117	c_source_fk int references c_source,
118	c_customer_fk int references c_customer,
119	c_type_fk int references c_type,
120	c_news_section varchar(100),
121	c_news_page varchar(250),
122	c_news_title varchar(100) not null,
123	c_news_abstract text not null,
124	c_news_full_text text,
125	c_news_date_created timestamp DEFAULT NOW(),
126	c_news_date_updated timestamp,
127	c_news_date_deleted timestamp
128	);
129
130
131	--
132	-- TABLE: NEWS LOG
133	--
134
135	/*
136	CREATE TABLE log_c_news (
137	log_c_news_id serial primary key,
138	c_source_id int,
139	c_source_description varchar(100) not null,
140	c_source_notes text,
141	c_customer_id int,
142	c_customer_name varchar(100) not null,
143	c_customer_phone varchar(50),
144	c_customer_email varchar(50),
145	c_customer_notes text,
146	c_type_id int,
147	c_type_description varchar(50) not null,
148	c_type_notes text,
149	c_news_id int,
150	c_news_section varchar(100),
151	c_news_page varchar(250),
152	c_news_title varchar(100) not null,
153	c_news_abstract text not null,
154	c_news_full_text text,
155	c_news_date_created datetime,
156	c_news_date_updated datetime,
157	c_news_date_deleted datetime,
158	is_active boolean DEFAULT 't' NOT NULL
159	);
160	*/
161
162
163
164	-- END --
165
166	--
167	-- This program is free software; you can redistribute it and/or
168	-- modify it under the terms of the GNU General Public License
169	--