/[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

Annotation of /fcproducts.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.3 - (hide annotations)
Wed Jun 6 10:54:22 2001 UTC (22 years, 10 months ago) by ravilov
Branch: MAIN
Changes since 1.2: +75 -12 lines 
Dodana POP3 i MD5 autorizacija, izbacena plaintext autorizacija.
1 ravilov 1.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 ravilov 1.3 -- TOC Entry ID 7 (OID 94023)
12 ravilov 1.1 --
13 ravilov 1.3 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: ravilov
14 ravilov 1.1 --
15    
16     CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
17    
18     --
19 ravilov 1.3 -- TOC Entry ID 8 (OID 94024)
20 ravilov 1.1 --
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 ravilov 1.3 -- TOC Entry ID 4 (OID 94025)
28 ravilov 1.1 --
29 ravilov 1.3 -- Name: users Type: TABLE Owner: ravilov
30 ravilov 1.1 --
31    
32     CREATE TABLE "users" (
33     "login" character varying(16) NOT NULL,
34 ravilov 1.3 "password" character varying(32),
35 ravilov 1.1 "full_name" character varying(150),
36     "email" character varying(200),
37     Constraint "users_pkey" Primary Key ("login")
38     );
39    
40     --
41 ravilov 1.3 -- TOC Entry ID 2 (OID 94041)
42 ravilov 1.1 --
43 ravilov 1.3 -- Name: products_product_id_seq Type: SEQUENCE Owner: ravilov
44 ravilov 1.1 --
45    
46     CREATE SEQUENCE "products_product_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
47    
48     --
49 ravilov 1.3 -- TOC Entry ID 5 (OID 94060)
50 ravilov 1.1 --
51 ravilov 1.3 -- Name: products Type: TABLE Owner: ravilov
52 ravilov 1.1 --
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 ravilov 1.3 -- TOC Entry ID 6 (OID 94159)
102 ravilov 1.1 --
103 ravilov 1.3 -- Name: user_product Type: TABLE Owner: ravilov
104 ravilov 1.1 --
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 ravilov 1.3
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 ravilov 1.1
  ViewVC Help
Powered by ViewVC 1.1.26