/[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.3 - (show annotations)
Wed Jun 6 10:54:22 2001 UTC (22 years, 9 months ago) by ravilov
Branch: MAIN
Changes since 1.2: +75 -12 lines
Dodana POP3 i MD5 autorizacija, izbacena plaintext autorizacija.

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 94023)
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 94024)
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 94025)
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 94041)
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 94060)
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 94159)
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 94025)
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 ('test','','test','');
159 INSERT INTO "users" ("login","password","full_name","email") VALUES ('test2','','','');
160 INSERT INTO "users" ("login","password","full_name","email") VALUES ('ravilov','auth_pop3','Robert Avilov','ravilov@pliva.hr');
161 --
162 -- Data for TOC Entry ID 10 (OID 94060)
163 --
164 -- Name: products Type: TABLE DATA Owner: ravilov
165 --
166
167
168 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,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
169 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','');
170 --
171 -- Data for TOC Entry ID 11 (OID 94159)
172 --
173 -- Name: user_product Type: TABLE DATA Owner: ravilov
174 --
175
176
177 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');
178 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');
179 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);
180 --
181 -- TOC Entry ID 3 (OID 94041)
182 --
183 -- Name: products_product_id_seq Type: SEQUENCE SET Owner:
184 --
185
186 SELECT setval ('"products_product_id_seq"', 1, 't');
187

  ViewVC Help
Powered by ViewVC 1.1.26