Skip to content

v23.1

v23.1: 23.1 sample schema release (#15)
@gvenzl gvenzl tagged this 18 Apr 12:59 
* Introducing 21c HR schema version

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix ReadMe typo

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix ReadMe typo

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix ReadMe typo

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update release date

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update release date

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix ReadMe.md typo

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix ReadMe.txt typo

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Use full word file names

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Use full word file names

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update comment section on user creation

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Standardize comments

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* reduce privileges for schema

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update template formatting

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move user creation to install script

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Merge table and index creation into co_create.sql

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Add views creation into co_create

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move constraints into co_create

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move comments into co_create

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* remove co_ddl.sql no longer needed

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move inserts into co_populate.sql

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move products into co_populate

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* move stores into populate

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move orders into populate

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move shipments into populate

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move order_items into populate

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move inventory into populate

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* insert into portion finished

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* integrate identity column value restart into co_populate

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove dml setup files now part of co_populate

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Move drops into uninstall script

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* formatting

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* formatting

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* change column definition

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Add installation verification

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update data

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* do not send NULL in INSERT INTO store queries

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update HR ReadMes

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* ReadMe updates

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix Typo in comment

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix Typo in comment

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Formatting and typo fix

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Formatting

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Use BEGIN/END blocks for INSERTs

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Add schema overwrite check

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update schema overwrite check and position

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update schema overwrite check and position

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Use exit instead of disconnect to keep parity with when errors occur

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Add installation description

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Retire OE schema

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix minor typos in HR/CO ReadMe's

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Archive BI schema

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove trailing space

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Archive PM schema

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Updated SH schema install

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Make ARCHIVED more prominent

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove IX schema

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove QS

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove old install scripts

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update top level READMEs

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update copyright to 2023

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update LICENSE.md

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update contributing

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix typo

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* co_main.sql no longer used

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove empty line in CUSTOMERS table DDL

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix typos in ReadMes

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix typo

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* sample_queries.sql was never used

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Retire BI schema, never used

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update SQLcl requirement for SH

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update ReadMes

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* 23.1 release candidate

Signed-off-by: GitHub Action <41898282+github-actions[bot]@users.noreply.github.com>

* 23.1 release candidate (#13)

* place some missing ";"

 place some missing ";" to end of commands that create error when executing file.

* Retire OE schema

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix minor typos in HR/CO ReadMe's

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Archive BI schema

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove trailing space

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Archive PM schema

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Updated SH schema install

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Make ARCHIVED more prominent

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove IX schema

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove QS

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove old install scripts

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update top level READMEs

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update copyright to 2023

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update LICENSE.md

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update contributing

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix typo

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* co_main.sql no longer used

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Remove empty line in CUSTOMERS table DDL

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix typos in ReadMes

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Fix typo

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* sample_queries.sql was never used

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Retire BI schema, never used

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update SQLcl requirement for SH

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* Update ReadMes

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>

* 23.1 release candidate

Signed-off-by: GitHub Action <41898282+github-actions[bot]@users.noreply.github.com>

---------

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>
Signed-off-by: GitHub Action <41898282+github-actions[bot]@users.noreply.github.com>
Co-authored-by: mostafavtp <mostafa_vtp@yahoo.com>
Co-authored-by: Chris Saxon <chris.saxon@oracle.com>
Co-authored-by: GitHub Action <41898282+github-actions[bot]@users.noreply.github.com>

---------

Signed-off-by: Gerald Venzl <gerald.venzl@oracle.com>
Signed-off-by: GitHub Action <41898282+github-actions[bot]@users.noreply.github.com>
Co-authored-by: GitHub Action <41898282+github-actions[bot]@users.noreply.github.com>
Co-authored-by: mostafavtp <mostafa_vtp@yahoo.com>
Co-authored-by: Chris Saxon <chris.saxon@oracle.com>
Assets 2