diff options
Diffstat (limited to 'examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql')
| -rw-r--r-- | examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql | 232 |
1 files changed, 0 insertions, 232 deletions
diff --git a/examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql b/examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql deleted file mode 100644 index a2ff5733b..000000000 --- a/examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql +++ /dev/null @@ -1,232 +0,0 @@ -/* - * ============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 --- - |