/[fcproducts]/fcproducts.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /fcproducts.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.1 - (show annotations)
Wed Jun 6 09:04:28 2001 UTC (22 years, 10 months ago) by ravilov
Branch: MAIN 
Popravio bazu (premalo mjesta za linkove).
1 --
2 -- Selected TOC Entries:
3 --
4 \connect - dpavlin
5 DROP TABLE "user_product";
6 DROP TABLE "products";
7 DROP SEQUENCE "products_product_id_seq";
8 DROP TABLE "users";
9 DROP PROCEDURAL LANGUAGE 'plpgsql';
10 DROP FUNCTION "plpgsql_call_handler" ();
11 --
12 -- TOC Entry ID 7 (OID 93059)
13 --
14 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: dpavlin
15 --
16
17 CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
18
19 --
20 -- TOC Entry ID 8 (OID 93060)
21 --
22 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
23 --
24
25 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
26
27 --
28 -- TOC Entry ID 4 (OID 93061)
29 --
30 -- Name: users Type: TABLE Owner: dpavlin
31 --
32
33 CREATE TABLE "users" (
34 "login" character varying(16) NOT NULL,
35 "password" character varying(16),
36 "full_name" character varying(150),
37 "email" character varying(200),
38 Constraint "users_pkey" Primary Key ("login")
39 );
40
41 --
42 -- TOC Entry ID 2 (OID 93077)
43 --
44 -- Name: products_product_id_seq Type: SEQUENCE Owner: dpavlin
45 --
46
47 CREATE SEQUENCE "products_product_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
48
49 --
50 -- TOC Entry ID 5 (OID 93096)
51 --
52 -- Name: products Type: TABLE Owner: dpavlin
53 --
54
55 CREATE TABLE "products" (
56 "product_id" integer DEFAULT nextval('"products_product_id_seq"'::text) NOT NULL,
57 "naziv" character varying(50),
58 "link_market" character varying(255),
59 "link_competition" character varying(255),
60 "link_quality" character varying(255),
61 "link_production" character varying(255),
62 "link_potential" character varying(255),
63 "link_dosage" character varying(255),
64 "link_purchasing" character varying(255),
65 "link_economics" character varying(255),
66 "link_sales" character varying(255),
67 "link_risks" character varying(255),
68 "comment" character varying(255),
69 "cust_potential" character varying(10) DEFAULT '' NOT NULL,
70 "cust_existing" character varying(10) DEFAULT '' NOT NULL,
71 "fc_price" character varying(100) DEFAULT '' NOT NULL,
72 "competitors" character varying(100) DEFAULT '' NOT NULL,
73 "holders" character varying(100) DEFAULT '' NOT NULL,
74 "market_size" character varying(100) DEFAULT '' NOT NULL,
75 "quality" character varying(100) DEFAULT '' NOT NULL,
76 "registrations" character varying(100) DEFAULT '' NOT NULL,
77 "last_fda" character varying(100) DEFAULT '' NOT NULL,
78 "cap_nominal" character varying(100) DEFAULT '' NOT NULL,
79 "cap_util" character varying(100) DEFAULT '' NOT NULL,
80 "ther_class" character varying(100) DEFAULT '' NOT NULL,
81 "indication" character varying(100) DEFAULT '' NOT NULL,
82 "sales_1999" character varying(100) DEFAULT '' NOT NULL,
83 "launch_year" character varying(100) DEFAULT '' NOT NULL,
84 "mat_raw" character varying(100) DEFAULT '' NOT NULL,
85 "suppliers" character varying(100) DEFAULT '' NOT NULL,
86 "mat_cost" character varying(100) DEFAULT '' NOT NULL,
87 "fc_rank" character varying(100) DEFAULT '' NOT NULL,
88 "fc_share" character varying(100) DEFAULT '' NOT NULL,
89 "maturity" character varying(100) DEFAULT '' NOT NULL,
90 "comp_intensity" character varying(100) DEFAULT '' NOT NULL,
91 "comp_position" character varying(100) DEFAULT '' NOT NULL,
92 "cogs" character varying(100) DEFAULT '' NOT NULL,
93 "op_income" character varying(100) DEFAULT '' NOT NULL,
94 "break_even" character varying(100) DEFAULT '' NOT NULL,
95 "m3" character varying(100) DEFAULT '' NOT NULL,
96 "sales_img" character varying(100) DEFAULT '' NOT NULL,
97 "risks" character varying(100) DEFAULT '' NOT NULL,
98 Constraint "products_pkey" Primary Key ("product_id")
99 );
100
101 --
102 -- TOC Entry ID 6 (OID 93195)
103 --
104 -- Name: user_product Type: TABLE Owner: dpavlin
105 --
106
107 CREATE TABLE "user_product" (
108 "login" character varying(16) NOT NULL,
109 "product_id" bigint DEFAULT 0 NOT NULL,
110 "market" boolean,
111 "production" boolean,
112 "purchasing" boolean,
113 "economics" boolean,
114 "risks" boolean,
115 "competition" boolean,
116 "potential" boolean,
117 "portfolio" boolean,
118 "sales" boolean,
119 "quality" boolean,
120 "dosage" boolean,
121 "evaluation" boolean,
122 "comment" boolean,
123 Constraint "user_product_pkey" Primary Key ("login", "product_id")
124 );
125
126 --
127 -- Data for TOC Entry ID 9 (OID 93061)
128 --
129 -- Name: users Type: TABLE DATA Owner: dpavlin
130 --
131
132
133 COPY "users" FROM stdin;
134 dpavlin pero99 Dobrica Pavlinusic dpavlin@pliva.hr
135 test test
136 test2
137 \.
138 --
139 -- Data for TOC Entry ID 10 (OID 93096)
140 --
141 -- Name: products Type: TABLE DATA Owner: dpavlin
142 --
143
144
145 COPY "products" FROM stdin;
146 2 New \N \N \N \N \N \N \N \N \N \N \N
147 1 Acetazolamid http://fcproducts.pliva.hr/.index.php?A=V&F=ACETAZ Mud171t4.gif Tralala...
148 \
149 Komentar.
150 \
151
152 \
153
154 \
155
156 \
157
158 \
159 ITD. TEST 8c61cc3d3cad45ac4c747089a1665ec7.gif
160 \.
161 --
162 -- Data for TOC Entry ID 11 (OID 93195)
163 --
164 -- Name: user_product Type: TABLE DATA Owner: dpavlin
165 --
166
167
168 COPY "user_product" FROM stdin;
169 dpavlin 1 t t t t \N f \N f f t t \N t
170 test2 1 t t t t t t t t t t t t t
171 test 1 \N \N \N \N \N \N \N \N \N \N \N \N \N
172 \.
173 --
174 -- TOC Entry ID 3 (OID 93077)
175 --
176 -- Name: products_product_id_seq Type: SEQUENCE SET Owner:
177 --
178
179 SELECT setval ('"products_product_id_seq"', 1, 't');
180
  ViewVC Help
Powered by ViewVC 1.1.26