viewvc.cgi/fcproducts/fcproducts.sql

--
-- Selected TOC Entries:
--
DROP TABLE "user_product";
DROP TABLE "products";
DROP SEQUENCE "products_product_id_seq";
DROP TABLE "users";
DROP PROCEDURAL LANGUAGE 'plpgsql';
DROP FUNCTION "plpgsql_call_handler" ();
--
-- TOC Entry ID 6 (OID 93059)
--
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: dpavlin
--

CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';

--
-- TOC Entry ID 7 (OID 93060)
--
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: 
--

CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';

--
-- TOC Entry ID 3 (OID 93061)
--
-- Name: users Type: TABLE Owner: dpavlin
--

CREATE TABLE "users" (
        "login" character varying(16) NOT NULL,
        "password" character varying(16),
        "full_name" character varying(150),
        "email" character varying(200),
        Constraint "users_pkey" Primary Key ("login")
);

--
-- TOC Entry ID 2 (OID 93077)
--
-- Name: products_product_id_seq Type: SEQUENCE Owner: dpavlin
--

CREATE SEQUENCE "products_product_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 4 (OID 93096)
--
-- Name: products Type: TABLE Owner: dpavlin
--

CREATE TABLE "products" (
        "product_id" integer DEFAULT nextval('"products_product_id_seq"'::text) NOT NULL,
        "naziv" character varying(50),
        "link_market" character varying(255),
        "link_competition" character varying(255),
        "link_quality" character varying(255),
        "link_production" character varying(255),
        "link_potential" character varying(255),
        "link_dosage" character varying(255),
        "link_purchasing" character varying(255),
        "link_economics" character varying(255),
        "link_sales" character varying(255),
        "link_risks" character varying(255),
        "comment" character varying(255),
        "cust_potential" character varying(10) DEFAULT '' NOT NULL,
        "cust_existing" character varying(10) DEFAULT '' NOT NULL,
        "fc_price" character varying(100) DEFAULT '' NOT NULL,
        "competitors" character varying(100) DEFAULT '' NOT NULL,
        "holders" character varying(100) DEFAULT '' NOT NULL,
        "market_size" character varying(100) DEFAULT '' NOT NULL,
        "quality" character varying(100) DEFAULT '' NOT NULL,
        "registrations" character varying(100) DEFAULT '' NOT NULL,
        "last_fda" character varying(100) DEFAULT '' NOT NULL,
        "cap_nominal" character varying(100) DEFAULT '' NOT NULL,
        "cap_util" character varying(100) DEFAULT '' NOT NULL,
        "ther_class" character varying(100) DEFAULT '' NOT NULL,
        "indication" character varying(100) DEFAULT '' NOT NULL,
        "sales_1999" character varying(100) DEFAULT '' NOT NULL,
        "launch_year" character varying(100) DEFAULT '' NOT NULL,
        "mat_raw" character varying(100) DEFAULT '' NOT NULL,
        "suppliers" character varying(100) DEFAULT '' NOT NULL,
        "mat_cost" character varying(100) DEFAULT '' NOT NULL,
        "fc_rank" character varying(100) DEFAULT '' NOT NULL,
        "fc_share" character varying(100) DEFAULT '' NOT NULL,
        "maturity" character varying(100) DEFAULT '' NOT NULL,
        "comp_intensity" character varying(100) DEFAULT '' NOT NULL,
        "comp_position" character varying(100) DEFAULT '' NOT NULL,
        "cogs" character varying(100) DEFAULT '' NOT NULL,
        "op_income" character varying(100) DEFAULT '' NOT NULL,
        "break_even" character varying(100) DEFAULT '' NOT NULL,
        "m3" character varying(100) DEFAULT '' NOT NULL,
        "sales_img" character varying(100) DEFAULT '' NOT NULL,
        "risks" character varying(100) DEFAULT '' NOT NULL,
        Constraint "products_pkey" Primary Key ("product_id")
);

--
-- TOC Entry ID 5 (OID 93195)
--
-- Name: user_product Type: TABLE Owner: dpavlin
--

CREATE TABLE "user_product" (
        "login" character varying(16) NOT NULL,
        "product_id" bigint DEFAULT 0 NOT NULL,
        "market" boolean,
        "production" boolean,
        "purchasing" boolean,
        "economics" boolean,
        "risks" boolean,
        "competition" boolean,
        "potential" boolean,
        "portfolio" boolean,
        "sales" boolean,
        "quality" boolean,
        "dosage" boolean,
        "evaluation" boolean,
        "comment" boolean,
        Constraint "user_product_pkey" Primary Key ("login", "product_id")
);

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 6 (OID 93059)
12	--
13	-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: dpavlin
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 7 (OID 93060)
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 3 (OID 93061)
28	--
29	-- Name: users Type: TABLE Owner: dpavlin
30	--
31
32	CREATE TABLE "users" (
33	"login" character varying(16) NOT NULL,
34	"password" character varying(16),
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 93077)
42	--
43	-- Name: products_product_id_seq Type: SEQUENCE Owner: dpavlin
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 4 (OID 93096)
50	--
51	-- Name: products Type: TABLE Owner: dpavlin
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 5 (OID 93195)
102	--
103	-- Name: user_product Type: TABLE Owner: dpavlin
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