/[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.4 - (show annotations)
Wed Jun 6 10:55:45 2001 UTC (22 years, 10 months ago) by ravilov
Branch: MAIN
Changes since 1.3: +11 -13 lines 
Izbaceni test useri.
1 --
2 -- Selected TOC Entries:
3 --
4 DROP TABLE "user_product";
5 DROP TABLE "products";
6 DROP SEQUENCE "products_product_id_seq";
7 DROP TABLE "users";
8 DROP PROCEDURAL LANGUAGE 'plpgsql';
9 DROP FUNCTION "plpgsql_call_handler" ();
10 --
11 -- TOC Entry ID 7 (OID 94221)
12 --
13 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: ravilov
14 --
15
16 CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
17
18 --
19 -- TOC Entry ID 8 (OID 94222)
20 --
21 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
22 --
23
24 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
25
26 --
27 -- TOC Entry ID 4 (OID 94223)
28 --
29 -- Name: users Type: TABLE Owner: ravilov
30 --
31
32 CREATE TABLE "users" (
33 "login" character varying(16) NOT NULL,
34 "password" character varying(32),
35 "full_name" character varying(150),
36 "email" character varying(200),
37 Constraint "users_pkey" Primary Key ("login")
38 );
39
40 --
41 -- TOC Entry ID 2 (OID 94239)
42 --
43 -- Name: products_product_id_seq Type: SEQUENCE Owner: ravilov
44 --
45
46 CREATE SEQUENCE "products_product_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
47
48 --
49 -- TOC Entry ID 5 (OID 94258)
50 --
51 -- Name: products Type: TABLE Owner: ravilov
52 --
53
54 CREATE TABLE "products" (
55 "product_id" integer DEFAULT nextval('"products_product_id_seq"'::text) NOT NULL,
56 "naziv" character varying(50),
57 "link_market" character varying(255),
58 "link_competition" character varying(255),
59 "link_quality" character varying(255),
60 "link_production" character varying(255),
61 "link_potential" character varying(255),
62 "link_dosage" character varying(255),
63 "link_purchasing" character varying(255),
64 "link_economics" character varying(255),
65 "link_sales" character varying(255),
66 "link_risks" character varying(255),
67 "comment" character varying(255),
68 "cust_potential" character varying(10) DEFAULT '' NOT NULL,
69 "cust_existing" character varying(10) DEFAULT '' NOT NULL,
70 "fc_price" character varying(100) DEFAULT '' NOT NULL,
71 "competitors" character varying(100) DEFAULT '' NOT NULL,
72 "holders" character varying(100) DEFAULT '' NOT NULL,
73 "market_size" character varying(100) DEFAULT '' NOT NULL,
74 "quality" character varying(100) DEFAULT '' NOT NULL,
75 "registrations" character varying(100) DEFAULT '' NOT NULL,
76 "last_fda" character varying(100) DEFAULT '' NOT NULL,
77 "cap_nominal" character varying(100) DEFAULT '' NOT NULL,
78 "cap_util" character varying(100) DEFAULT '' NOT NULL,
79 "ther_class" character varying(100) DEFAULT '' NOT NULL,
80 "indication" character varying(100) DEFAULT '' NOT NULL,
81 "sales_1999" character varying(100) DEFAULT '' NOT NULL,
82 "launch_year" character varying(100) DEFAULT '' NOT NULL,
83 "mat_raw" character varying(100) DEFAULT '' NOT NULL,
84 "suppliers" character varying(100) DEFAULT '' NOT NULL,
85 "mat_cost" character varying(100) DEFAULT '' NOT NULL,
86 "fc_rank" character varying(100) DEFAULT '' NOT NULL,
87 "fc_share" character varying(100) DEFAULT '' NOT NULL,
88 "maturity" character varying(100) DEFAULT '' NOT NULL,
89 "comp_intensity" character varying(100) DEFAULT '' NOT NULL,
90 "comp_position" character varying(100) DEFAULT '' NOT NULL,
91 "cogs" character varying(100) DEFAULT '' NOT NULL,
92 "op_income" character varying(100) DEFAULT '' NOT NULL,
93 "break_even" character varying(100) DEFAULT '' NOT NULL,
94 "m3" character varying(100) DEFAULT '' NOT NULL,
95 "sales_img" character varying(100) DEFAULT '' NOT NULL,
96 "risks" character varying(100) DEFAULT '' NOT NULL,
97 Constraint "products_pkey" Primary Key ("product_id")
98 );
99
100 --
101 -- TOC Entry ID 6 (OID 94357)
102 --
103 -- Name: user_product Type: TABLE Owner: ravilov
104 --
105
106 CREATE TABLE "user_product" (
107 "login" character varying(16) NOT NULL,
108 "product_id" bigint DEFAULT 0 NOT NULL,
109 "market" boolean,
110 "production" boolean,
111 "purchasing" boolean,
112 "economics" boolean,
113 "risks" boolean,
114 "competition" boolean,
115 "potential" boolean,
116 "portfolio" boolean,
117 "sales" boolean,
118 "quality" boolean,
119 "dosage" boolean,
120 "evaluation" boolean,
121 "comment" boolean,
122 Constraint "user_product_pkey" Primary Key ("login", "product_id")
123 );
124
125 --
126 -- Data for TOC Entry ID 9 (OID 94223)
127 --
128 -- Name: users Type: TABLE DATA Owner: ravilov
129 --
130
131
132 INSERT INTO "users" ("login","password","full_name","email") VALUES ('dpavlin','eec62eae0230be16dd9c00de1dadce75','Dobrca Pavlinusic','dpavlin@intranet.pliva.hr');
133 INSERT INTO "users" ("login","password","full_name","email") VALUES ('popov','auth_pop3','Dragica Popov','popov@intranet.pliva.hr');
134 INSERT INTO "users" ("login","password","full_name","email") VALUES ('rfrankov','auth_pop3','Robert Frankovic','rfrankov@intranet.pliva.hr');
135 INSERT INTO "users" ("login","password","full_name","email") VALUES ('iblazic','auth_pop3','Ivica Blazic','iblazic@intranet.pliva.hr');
136 INSERT INTO "users" ("login","password","full_name","email") VALUES ('iherceg','auth_pop3','Ivan Herceg','iherceg@intranet.pliva.hr');
137 INSERT INTO "users" ("login","password","full_name","email") VALUES ('ipudic','auth_pop3','Ivan Pudic','ipudic@intranet.pliva.hr');
138 INSERT INTO "users" ("login","password","full_name","email") VALUES ('vsupek','auth_pop3','Vladimir Supek','vsupek@intranet.pliva.hr');
139 INSERT INTO "users" ("login","password","full_name","email") VALUES ('dkardun','auth_pop3','Drago Kardun','dkardun@intranet.pliva.hr');
140 INSERT INTO "users" ("login","password","full_name","email") VALUES ('bloncar','auth_pop3','Biserka Loncar','bloncar@intranet.pliva.hr');
141 INSERT INTO "users" ("login","password","full_name","email") VALUES ('btokin','auth_pop3','Bojana Tokin','btokin@intranet.pliva.hr');
142 INSERT INTO "users" ("login","password","full_name","email") VALUES ('ndoko','auth_pop3','Natalija Doko-Maltar','ndoko@intranet.pliva.hr');
143 INSERT INTO "users" ("login","password","full_name","email") VALUES ('kbartos','auth_pop3','Ksenija Bartos','kbartos@intranet.pliva.hr');
144 INSERT INTO "users" ("login","password","full_name","email") VALUES ('jvedrina','auth_pop3','Jasna Vedrina','jvedrina@intranet.pliva.hr');
145 INSERT INTO "users" ("login","password","full_name","email") VALUES ('nbencedi','auth_pop3','Nada Bencedic','nbencedi@intranet.pliva.hr');
146 INSERT INTO "users" ("login","password","full_name","email") VALUES ('kgregori','auth_pop3','Katarina Gregoric','kgregori@intranet.pliva.hr');
147 INSERT INTO "users" ("login","password","full_name","email") VALUES ('vvlasic','auth_pop3','Vedrana Vlasic','vvlasic@intranet.pliva.hr');
148 INSERT INTO "users" ("login","password","full_name","email") VALUES ('rcvjetic','auth_pop3','Romana Cvjetic','rcvjetic@intranet.pliva.hr');
149 INSERT INTO "users" ("login","password","full_name","email") VALUES ('ijurkovi','auth_pop3','Ivica Jurkovic','ijurkovi@intranet.pliva.hr');
150 INSERT INTO "users" ("login","password","full_name","email") VALUES ('fkrpan','auth_pop3','Franjo Krpan','fkrpan@intranet.pliva.hr');
151 INSERT INTO "users" ("login","password","full_name","email") VALUES ('vsamardz','auth_pop3','Vesna Samardzic','vsamardz@intranet.pliva.hr');
152 INSERT INTO "users" ("login","password","full_name","email") VALUES ('vselendi','auth_pop3','Vedrana Selendic','vselendi@intranet.pliva.hr');
153 INSERT INTO "users" ("login","password","full_name","email") VALUES ('nmorovic','auth_pop3','Nikola Morovic','nmorovic@intranet.pliva.hr');
154 INSERT INTO "users" ("login","password","full_name","email") VALUES ('dskrinja','auth_pop3','Davorin Skrinjaric','dskrinja@intranet.pliva.hr');
155 INSERT INTO "users" ("login","password","full_name","email") VALUES ('aekart','auth_pop3','Aleksandar Ekart','aekart@intranet.pliva.hr');
156 INSERT INTO "users" ("login","password","full_name","email") VALUES ('nurli','auth_pop3','Nikoleta Urli','nurli@intranet.pliva.hr');
157 INSERT INTO "users" ("login","password","full_name","email") VALUES ('tzignic','auth_pop3','Tanja Zignic','tzignic@intranet.pliva.hr');
158 INSERT INTO "users" ("login","password","full_name","email") VALUES ('ravilov','auth_pop3','Robert Avilov','ravilov@intranet.pliva.hr');
159 --
160 -- Data for TOC Entry ID 10 (OID 94258)
161 --
162 -- Name: products Type: TABLE DATA Owner: ravilov
163 --
164
165
166 INSERT INTO "products" ("product_id","naziv","link_market","link_competition","link_quality","link_production","link_potential","link_dosage","link_purchasing","link_economics","link_sales","link_risks","comment","cust_potential","cust_existing","fc_price","competitors","holders","market_size","quality","registrations","last_fda","cap_nominal","cap_util","ther_class","indication","sales_1999","launch_year","mat_raw","suppliers","mat_cost","fc_rank","fc_share","maturity","comp_intensity","comp_position","cogs","op_income","break_even","m3","sales_img","risks") VALUES (2,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
167 INSERT INTO "products" ("product_id","naziv","link_market","link_competition","link_quality","link_production","link_potential","link_dosage","link_purchasing","link_economics","link_sales","link_risks","comment","cust_potential","cust_existing","fc_price","competitors","holders","market_size","quality","registrations","last_fda","cap_nominal","cap_util","ther_class","indication","sales_1999","launch_year","mat_raw","suppliers","mat_cost","fc_rank","fc_share","maturity","comp_intensity","comp_position","cogs","op_income","break_even","m3","sales_img","risks") VALUES (1,'Acetazolamid','http://fcproducts.pliva.hr/.index.php?A=V&F=Mark.pos.ACETAZOLAMIDE.doc&D=%2FAcetazolamide','http://fcproducts.pliva.hr/.index.php?A=V&F=Comp.ACETAZOLAMIDE.doc&D=%2FAcetazolamide','','','','http://fcproducts.pliva.hr/.index.php?A=V&F=Dosf.mark.ACETAZOLAMIDE.doc&D=%2FAcetazolamide','','','M03uu2d7.gif','','Tralala...\015\012Komentar.\015\012\015\012\015\012\015\012\015\012ITD.','','TEST','','','','','','','','','','','','','','','','','','','','','','','','','','964e139f19c75fd93d55a3c92fe4edb9.gif','');
168 --
169 -- Data for TOC Entry ID 11 (OID 94357)
170 --
171 -- Name: user_product Type: TABLE DATA Owner: ravilov
172 --
173
174
175 INSERT INTO "user_product" ("login","product_id","market","production","purchasing","economics","risks","competition","potential","portfolio","sales","quality","dosage","evaluation","comment") VALUES ('dpavlin','1','t','t','t','t',NULL,'f',NULL,'f','f','t','t',NULL,'t');
176 INSERT INTO "user_product" ("login","product_id","market","production","purchasing","economics","risks","competition","potential","portfolio","sales","quality","dosage","evaluation","comment") VALUES ('test2','1','t','t','t','t','t','t','t','t','t','t','t','t','t');
177 INSERT INTO "user_product" ("login","product_id","market","production","purchasing","economics","risks","competition","potential","portfolio","sales","quality","dosage","evaluation","comment") VALUES ('test','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
178 --
179 -- TOC Entry ID 3 (OID 94239)
180 --
181 -- Name: products_product_id_seq Type: SEQUENCE SET Owner:
182 --
183
184 SELECT setval ('"products_product_id_seq"', 1, 't');
185
  ViewVC Help
Powered by ViewVC 1.1.26