1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
|
/*
* ============LICENSE_START=======================================================
* Copyright (C) 2016-2018 Ericsson. All rights reserved.
* ================================================================================
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
* SPDX-License-Identifier: Apache-2.0
* ============LICENSE_END=========================================================
*/
--
-- Create apex_sales database and populate it
--
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Create the database and switch to it
--
CREATE DATABASE apex_sales;
\connect apex_sales;
--
-- Name: assistants; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE assistants (
assistantid text,
surname text,
firstname text,
middlename text,
age text,
grade text,
phoneno text
);
ALTER TABLE assistants OWNER TO postgres;
--
-- Name: branches; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE branches (
branchname text,
branchid text,
branchcategory text,
street text,
city text,
country text,
postcode text
);
ALTER TABLE branches OWNER TO postgres;
--
-- Name: items; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE items (
itemid text,
description text,
costprice text,
barcode text,
supplierid text,
category text
);
ALTER TABLE items OWNER TO postgres;
--
-- Name: sales; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE sales (
saleid text,
amount text,
itemid text,
quantity text,
assistantid text,
branchname text,
notes text
);
ALTER TABLE sales OWNER TO postgres;
--
-- Data for Name: assistants; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY assistants (assistantid, surname, firstname, middlename, age, grade, phoneno) FROM stdin;
1222 Citizen Sean Tadhg 23 3 871234321
126 Doe Jane Donna 56 2 861234567
13213 Svensson Sven Lars 72 1 854323456
22 Bloggs Joe John 19 3 839877654
33 Yamada Taro Nanno 34 3 892344333
343 Mustermann Max Fritz 21 2 887655432
\.
--
-- Data for Name: branches; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY branches (branchname, branchid, branchcategory, street, city, country, postcode) FROM stdin;
Al Raqqah 5667 Main 7 April Park Al Raqqa Syria SY.RA.RA
Athlone 99556 Sub Church Street Athlone Ireland N37 E733
Cork 326 Main Saint Patrick's Street Cork Ireland T12 TE45
Dallas 323 Main John West Road Dallas, TX USA 75228
Pyongyang 3233 Sub Sungri Street Pyongyang Korea 23060
Tullamore 59 Franchise O'Moore Street Tullamore Ireland R35 YP55
Vladivostok 7884 Main Admiral Yumasheva Street Vladivostok Russian Federation 690000
\.
--
-- Data for Name: items; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY items (itemid, description, costprice, barcode, supplierid, category) FROM stdin;
1232 Table and Chairs 122.34 233454432 12452 Furniture
1277689 Crested Ten 15.23 45543345 134435 Alcahol
16775645 Marlboro Lights 2.25 13215321 2332 Tobacco
234424 Stool 23.23 2132132 12452 Furniture
3455634 Bed 96.78 123123 13325 Furniture
\.
--
-- Data for Name: sales; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY sales (saleid, amount, itemid, quantity, assistantid, branchname, notes) FROM stdin;
6778392 22.45 234424 10 126 Athlone Fabulous Sale
7883454 167.89 1277689 2 343 Tullamore \N
8988516 2445.62 16775645 3545 1222 Cork \N
10093578 10.11 1277689 5 22 Athlone Good Product
11198640 233.45 234424 32 13213 Dallas \N
12303702 8585.74 3455634 435 33 Vladivostok \N
13408764 55 1232 45 1222 Vladivostok \N
14513826 955 16775645 2 33 Pyongyang \N
15618888 788.52 16775645 56 33 Dallas \N
16723950 9555.12 234424 84 33 Al Raqqah \N
17829012 8.78 3455634 5 1222 Cork \N
18934074 1 1232 9 126 Al Raqqah \N
20039136 0 16775645 9 126 Cork \N
21144198 28.63 1277689 4515 126 Athlone \N
22249260 9944.6 234424 4 126 Pyongyang \N
23354322 8.74 3455634 5 343 Dallas \N
24459384 8.77 1232 65 1222 Pyongyang \N
25564446 2722.88 16775645 5 22 Vladivostok \N
26669508 855.21 16775645 65 13213 Athlone \N
27774570 644.37 234424 56 33 Tullamore \N
28879632 633.8 3455634 56 1222 Al Raqqah \N
29984694 743.74 1232 7787 33 Cork \N
31089756 144.63 234424 65 33 Cork \N
32194818 5.7 1277689 89 33 Athlone \N
33299880 522.36 16775645 8 1222 Dallas \N
34404942 855.36 1277689 897 126 Al Raqqah \N
35510004 455.79 234424 5 126 Pyongyang \N
36615066 1.1 3455634 6 343 Pyongyang \N
37720128 966.37 1232 2 1222 Vladivostok \N
38825190 5.27 16775645 2 22 Pyongyang \N
39930252 444.5 16775645 232 13213 Dallas \N
41035314 214.59 234424 2 33 Al Raqqah \N
42140376 6.3 3455634 1 1222 Cork \N
43245438 455.17 1232 1 33 Al Raqqah \N
44350500 658.74 16775645 1 33 Cork \N
45455562 75755.8 1277689 2313 33 Athlone \N
46560624 0.01 234424 1165 1222 Pyongyang \N
47665686 855.96 3455634 33 126 Dallas \N
48770748 44444 1232 3 126 Pyongyang \N
49875810 8555.6 16775645 3131 343 Vladivostok \N
50980872 444577.2 16775645 8 1222 Pyongyang \N
52085934 8277 234424 1 22 Dallas \N
53190996 987.65 3455634 561 13213 Al Raqqah \N
54296058 123.54 1232 6551 33 Cork \N
\.
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- PostgreSQL database dump complete
--
|
