/[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.1 - (hide annotations)
Wed Jun 6 09:04:28 2001 UTC (22 years, 10 months ago) by ravilov
Branch: MAIN 
Popravio bazu (premalo mjesta za linkove).
1 ravilov 1.1 --
2     -- Selected TOC Entries:
3     --
4     \connect - dpavlin
5     DROP TABLE "user_product";
6     DROP TABLE "products";
7     DROP SEQUENCE "products_product_id_seq";
8     DROP TABLE "users";
9     DROP PROCEDURAL LANGUAGE 'plpgsql';
10     DROP FUNCTION "plpgsql_call_handler" ();
11     --
12     -- TOC Entry ID 7 (OID 93059)
13     --
14     -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: dpavlin
15     --
16    
17     CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
18    
19     --
20     -- TOC Entry ID 8 (OID 93060)
21     --
22     -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
23     --
24    
25     CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
26    
27     --
28     -- TOC Entry ID 4 (OID 93061)
29     --
30     -- Name: users Type: TABLE Owner: dpavlin
31     --
32    
33     CREATE TABLE "users" (
34     "login" character varying(16) NOT NULL,
35     "password" character varying(16),
36     "full_name" character varying(150),
37     "email" character varying(200),
38     Constraint "users_pkey" Primary Key ("login")
39     );
40    
41     --
42     -- TOC Entry ID 2 (OID 93077)
43     --
44     -- Name: products_product_id_seq Type: SEQUENCE Owner: dpavlin
45     --
46    
47     CREATE SEQUENCE "products_product_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
48    
49     --
50     -- TOC Entry ID 5 (OID 93096)
51     --
52     -- Name: products Type: TABLE Owner: dpavlin
53     --
54    
55     CREATE TABLE "products" (
56     "product_id" integer DEFAULT nextval('"products_product_id_seq"'::text) NOT NULL,
57     "naziv" character varying(50),
58     "link_market" character varying(255),
59     "link_competition" character varying(255),
60     "link_quality" character varying(255),
61     "link_production" character varying(255),
62     "link_potential" character varying(255),
63     "link_dosage" character varying(255),
64     "link_purchasing" character varying(255),
65     "link_economics" character varying(255),
66     "link_sales" character varying(255),
67     "link_risks" character varying(255),
68     "comment" character varying(255),
69     "cust_potential" character varying(10) DEFAULT '' NOT NULL,
70     "cust_existing" character varying(10) DEFAULT '' NOT NULL,
71     "fc_price" character varying(100) DEFAULT '' NOT NULL,
72     "competitors" character varying(100) DEFAULT '' NOT NULL,
73     "holders" character varying(100) DEFAULT '' NOT NULL,
74     "market_size" character varying(100) DEFAULT '' NOT NULL,
75     "quality" character varying(100) DEFAULT '' NOT NULL,
76     "registrations" character varying(100) DEFAULT '' NOT NULL,
77     "last_fda" character varying(100) DEFAULT '' NOT NULL,
78     "cap_nominal" character varying(100) DEFAULT '' NOT NULL,
79     "cap_util" character varying(100) DEFAULT '' NOT NULL,
80     "ther_class" character varying(100) DEFAULT '' NOT NULL,
81     "indication" character varying(100) DEFAULT '' NOT NULL,
82     "sales_1999" character varying(100) DEFAULT '' NOT NULL,
83     "launch_year" character varying(100) DEFAULT '' NOT NULL,
84     "mat_raw" character varying(100) DEFAULT '' NOT NULL,
85     "suppliers" character varying(100) DEFAULT '' NOT NULL,
86     "mat_cost" character varying(100) DEFAULT '' NOT NULL,
87     "fc_rank" character varying(100) DEFAULT '' NOT NULL,
88     "fc_share" character varying(100) DEFAULT '' NOT NULL,
89     "maturity" character varying(100) DEFAULT '' NOT NULL,
90     "comp_intensity" character varying(100) DEFAULT '' NOT NULL,
91     "comp_position" character varying(100) DEFAULT '' NOT NULL,
92     "cogs" character varying(100) DEFAULT '' NOT NULL,
93     "op_income" character varying(100) DEFAULT '' NOT NULL,
94     "break_even" character varying(100) DEFAULT '' NOT NULL,
95     "m3" character varying(100) DEFAULT '' NOT NULL,
96     "sales_img" character varying(100) DEFAULT '' NOT NULL,
97     "risks" character varying(100) DEFAULT '' NOT NULL,
98     Constraint "products_pkey" Primary Key ("product_id")
99     );
100    
101     --
102     -- TOC Entry ID 6 (OID 93195)
103     --
104     -- Name: user_product Type: TABLE Owner: dpavlin
105     --
106    
107     CREATE TABLE "user_product" (
108     "login" character varying(16) NOT NULL,
109     "product_id" bigint DEFAULT 0 NOT NULL,
110     "market" boolean,
111     "production" boolean,
112     "purchasing" boolean,
113     "economics" boolean,
114     "risks" boolean,
115     "competition" boolean,
116     "potential" boolean,
117     "portfolio" boolean,
118     "sales" boolean,
119     "quality" boolean,
120     "dosage" boolean,
121     "evaluation" boolean,
122     "comment" boolean,
123     Constraint "user_product_pkey" Primary Key ("login", "product_id")
124     );
125    
126     --
127     -- Data for TOC Entry ID 9 (OID 93061)
128     --
129     -- Name: users Type: TABLE DATA Owner: dpavlin
130     --
131    
132    
133     COPY "users" FROM stdin;
134     dpavlin pero99 Dobrica Pavlinusic dpavlin@pliva.hr
135     test test
136     test2
137     \.
138     --
139     -- Data for TOC Entry ID 10 (OID 93096)
140     --
141     -- Name: products Type: TABLE DATA Owner: dpavlin
142     --
143    
144    
145     COPY "products" FROM stdin;
146     2 New \N \N \N \N \N \N \N \N \N \N \N
147     1 Acetazolamid http://fcproducts.pliva.hr/.index.php?A=V&F=ACETAZ Mud171t4.gif Tralala... \
148     Komentar. \
149     \
150     \
151     \
152     \
153     ITD. TEST 8c61cc3d3cad45ac4c747089a1665ec7.gif
154     \.
155     --
156     -- Data for TOC Entry ID 11 (OID 93195)
157     --
158     -- Name: user_product Type: TABLE DATA Owner: dpavlin
159     --
160    
161    
162     COPY "user_product" FROM stdin;
163     dpavlin 1 t t t t \N f \N f f t t \N t
164     test2 1 t t t t t t t t t t t t t
165     test 1 \N \N \N \N \N \N \N \N \N \N \N \N \N
166     \.
167     --
168     -- TOC Entry ID 3 (OID 93077)
169     --
170     -- Name: products_product_id_seq Type: SEQUENCE SET Owner:
171     --
172    
173     SELECT setval ('"products_product_id_seq"', 1, 't');
174    
  ViewVC Help
Powered by ViewVC 1.1.26