/[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.2 - (show annotations)
Wed Jun 6 09:24:26 2001 UTC (18 years, 2 months ago) by ravilov
Branch: MAIN
Changes since 1.1: +5 -55 lines
Usminkao malo Makefile

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

  ViewVC Help
Powered by ViewVC 1.1.26