/[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.4 - (hide annotations)
Wed Jun 6 10:55:45 2001 UTC (18 years, 3 months ago) by ravilov
Branch: MAIN
Changes since 1.3: +11 -13 lines
Izbaceni test useri.

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.4 -- TOC Entry ID 7 (OID 94221)
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.4 -- TOC Entry ID 8 (OID 94222)
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.4 -- TOC Entry ID 4 (OID 94223)
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.4 -- TOC Entry ID 2 (OID 94239)
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.4 -- TOC Entry ID 5 (OID 94258)
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.4 -- TOC Entry ID 6 (OID 94357)
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 ravilov 1.4 -- Data for TOC Entry ID 9 (OID 94223)
127 ravilov 1.3 --
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 ravilov 1.4 INSERT INTO "users" ("login","password","full_name","email") VALUES ('ravilov','auth_pop3','Robert Avilov','ravilov@intranet.pliva.hr');
159 ravilov 1.3 --
160 ravilov 1.4 -- Data for TOC Entry ID 10 (OID 94258)
161 ravilov 1.3 --
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 ravilov 1.4 -- Data for TOC Entry ID 11 (OID 94357)
170 ravilov 1.3 --
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 ravilov 1.4 -- TOC Entry ID 3 (OID 94239)
180 ravilov 1.3 --
181     -- Name: products_product_id_seq Type: SEQUENCE SET Owner:
182     --
183    
184     SELECT setval ('"products_product_id_seq"', 1, 't');
185 ravilov 1.1

  ViewVC Help
Powered by ViewVC 1.1.26