<?xml version="1.0" encoding="UTF-8"?>
<project version="4">
  <component name="DBNavigator.Project.DataEditorManager">
    <record-view-column-sorting-type value="BY_INDEX" />
    <value-preview-text-wrapping value="false" />
    <value-preview-pinned value="false" />
  </component>
  <component name="DBNavigator.Project.DataExportManager">
    <export-instructions>
      <create-header value="true" />
      <quote-values-containing-separator value="true" />
      <quote-all-values value="false" />
      <value-separator value="" />
      <file-name value="" />
      <file-location value="" />
      <scope value="GLOBAL" />
      <destination value="FILE" />
      <format value="EXCEL" />
      <charset value="windows-1250" />
    </export-instructions>
  </component>
  <component name="DBNavigator.Project.DatabaseBrowserManager">
    <autoscroll-to-editor value="false" />
    <autoscroll-from-editor value="true" />
    <show-object-properties value="true" />
    <loaded-nodes>
      <connection connection-id="3900d660-5450-45b4-9fbc-5b68f9158736">
        <schema name="matko9@uniba.sk" object-types="table, view, function, column" />
        <schema name="pg_catalog" object-types="table, view, function" />
        <schema name="public" object-types="table, view, function" />
      </connection>
    </loaded-nodes>
  </component>
  <component name="DBNavigator.Project.DatabaseConsoleManager">
    <connection id="3900d660-5450-45b4-9fbc-5b68f9158736">
      <console name="Pripojka" type="STANDARD" schema="matko9@uniba.sk" session="Main"><![CDATA[--*/Tom? Ma?ko - Elektronick? St?vkovanie */
drop table if exists uzivatelia cascade;
Create TABLE uzivatelia(
id serial primary key,
meno varchar(20) NOT NULL,
priezvisko varchar(20) NOT NULL,
email varchar(50) UNIQUE,
login varchar(30) NOT NULL,
heslo varchar(30) NOT NULL,
kredit numeric CHECK(kredit>0),
pocetTiketov numeric
);
drop table if exists bookmakeri cascade;
Create TABLE bookmakeri(
id serial primary key,
meno varchar(20) NOT NULL,
priezvisko varchar(20) NOT NULL,
email varchar(50) UNIQUE,
login varchar(30) UNIQUE,
heslo varchar(30) NOT NULL
);
drop table if exists transakcie cascade;
Create TABLE transakcie(
id serial primary key,
suma numeric CHECK(suma>0),
vyber boolean,
datum timestamp,
id_uzivatela integer references uzivatelia(id)
);
drop table if exists stavky cascade;
Create table stavky(
id serial primary key,
datum timestamp,
max numeric CHECK(max>0),
min numeric CHECK(min>=0),
dokedy timestamp,
od_koho integer references bookmakeri(id)
);
drop table if exists tikety cascade;
Create TABLE tikety(
id serial primary key,
id_stavky integer references stavky(id),
id_uzivatela integer references uzivatelia(id),
tip numeric NOT NULL,
idTiketu integer, 
suma numeric CHECK(suma>0),
stav varchar,
vyherny boolean,
datum date
);
drop table if exists kancelaria cascade;
create table kancelaria(
id serial primary key,
kredit numeric,
login varchar,
heslo varchar,
id_stavky integer references stavky(id)
);
drop table if exists goly cascade;
Create Table goly(
id serial primary key,
id_stavky integer references stavky(id),
nazov1 varchar,
nazov2 varchar,
golov_01 numeric CHECK(golov_01>0),
golov_23 numeric CHECK(golov_23>0),
golov_45 numeric CHECK(golov_45>0),
nad5_golov numeric CHECK(nad5_golov>0),
vyhra int
);
drop table if exists vyhra cascade;
Create Table vyhra(
id serial primary key,
id_stavky integer references stavky(id),
nazov1 varchar,
nazov2 varchar,
tim1 numeric CHECK(tim1>0),
tim2 numeric CHECK(tim2>0),
remiza numeric CHECK(remiza>0),
vyherny_tim int
);
truncate table vyhra,goly,tikety,uzivatelia,bookmakeri,kancelaria,konta,stavky cascade;

truncate table vyhra,goly,tikety,uzivatelia,bookmakeri,kancelaria,konta,stavky cascade;


---- pomocne tabulky na generovanie dat

drop table if exists first_names cascade;
create table first_names
(
    first_name varchar
);
insert into first_names (first_name)
values	('James'), ('Willie'), ('Chad'), ('Zachary'), ('Mathew'),
	('John'), ('Ralph'), ('Jacob'), ('Corey'), ('Tyrone'),
	('Robert'), ('Larence'), ('Lee'), ('Herman'), ('Darren'),
	('Michael'), ('Nicholas'), ('Melvin'), ('Maurice'), ('Lonnie'),
	('William'), ('Roy'), ('Alfred'), ('Vernon'), ('Lance'),
	('David'), ('Benjamin'), ('Kyle'), ('Roberto'), ('Cody');

drop table if exists last_names cascade;
create table last_names
(
    last_name varchar
);
insert into last_names (last_name)
values	('Smith'), ('Jones'), ('Taylor'), ('Williams'), ('Brown'),
	('Davies'), ('Evans'), ('Wilson'), ('Thomas'), ('Roberts'),
	('Johnson'), ('Lewis'), ('Walker'), ('Robinson'), ('Wood'),
	('Thompson'), ('White'), ('Watson'), ('Jackson'), ('Wright'),
	('Green'), ('Harris'), ('Cooper'), ('King'), ('Lee'),
	('Martin'), ('Clarke'), ('James'), ('Morgan'), ('Hughes'),
	('Edwards'), ('Hill'), ('Moore'), ('Clark'), ('Harrison'),
	('Scott'), ('Young'), ('Morris'), ('Hall'), ('Ward'),
	('Turner'), ('Carter'), ('Phillips'), ('Mitchell'), ('Patel'),
	('Adams'), ('Campbell'), ('Anderson'), ('Allen'), ('Cook');

drop table if exists teams cascade;
create table teams
(
    team varchar
);
insert into teams (team)
values  ('Slovensko'),('Ukrajina'),('USA'),('Maroko'),('Urugay'),('Kambodža'),('Paraguay'),
        ('Venezuela'),('Kanada'),('Belgicko'),('Nemecko'),('Mexiko'),('Kazachstan'),('Madarsko'),('Norsko'),('Polsko'),('Bielorusko'),
        ('Senegal'),('JAR'),('Egypt'),('Izrael'),('Saudská Arábia'),('Čína'),('Austrália'),('Španielsko'),
        ('Portugalsko'),('Brazília'),('Chille'),('Gronsko'),('Irak'),('Thajsko'),('Holandsko'),('Švédsko'),
        ('Manchester United'), ('Real Madrid'), ('Manchester City'), ('Chelsea'), ('Liverpool'),
		('Tottenham'), ('Arsenal'), ('Barcelona'), ('Atletico Madrid'), ('Bilbao'),
		('Valencia'), ('Juventus'), ('AC Milano'), ('Inter'), ('Rim'),('Slovan Bratislava'),
        ('Zilina'), ('Trencin'), ('Košice'), ('Spartak Vrable'),
		('Tým Južnej Moravy'),('Budapest'),('Martin'),('Poprad'),('Nové Zámky'),('Nitra'),
        ('Banská Bystrica'),('Rakúsko'),('Taliansko'),('Rusko'),('Anglicko'),('Česko');

---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
---- kancelaria
insert into kancelaria (kredit,login,heslo)
values('100000','kancelaria','kancelaria');

---- uzivatelia
with data as ( 
	select	tmp1.i, tmp2.i,
			first_name,
			last_name,
			first_name || '.' || seq.i || last_name || '@gmail.com' as email,
			floor(random() * (1000 - 50) + 50) as kredit,
            'a' || seq.i as login,
            'a' || seq.i  as heslo
	from generate_series(1, 10000) as seq(i)
	cross join lateral (select seq.i, * from first_names order by random() limit 1) as tmp1
	cross join lateral (select seq.i, * from last_names order by random() limit 1) as tmp2
)
insert into uzivatelia (meno, priezvisko, email,kredit,pocetTiketov,login,heslo)
select first_name, last_name, email, kredit,2,login,heslo from data;

insert into uzivatelia(meno,priezvisko,login,heslo,kredit,email,pocetTiketov)
values('Tomas','Matko','tomas','matko','1000','tkolo789@gmail.com',1);



---Bookmakeri
with data as (
	select	tmp1.i, tmp2.i,
			first_name,
			last_name,
			first_name || '.' || seq.i || last_name || '@gmail.com' as email,
            'a' || seq.i as login,
            'a' || seq.i  as heslo
	from generate_series(1, 1000) as seq(i)
	cross join lateral (select seq.i, * from first_names order by random() limit 1) as tmp1
	cross join lateral (select seq.i, * from last_names order by random() limit 1) as tmp2
)
insert into bookmakeri (meno, priezvisko, email,login,heslo)
select first_name, last_name, email,login,heslo from data;


insert into bookmakeri (meno, priezvisko, email,login,heslo)
values  ('bookmaker','bookmaker','bookmaker@gmail.com','bookmaker','bookmaker');


----stavky
with data as ( 
	select  
			timestamp '2019-05-04 12:00:00' + random() * (timestamp '2020-05-04 12:00:00' - timestamp '2019-05-04 12:00:00') as datum,
			floor(random() * (5)) as min,
			floor(random() * (5000)+ 500) as max
	from generate_series(1, 10000) as seq(i)  
)

insert into stavky (datum,max,min)
select datum,max,min from data;
update stavky set dokedy = (datum - INTERVAL '1' HOUR);
update stavky set od_koho = floor(random()* (6) + 1 );

------transakcie

with data as ( 
	select
			timestamp '2016-02-04 12:00:00' + random() * (timestamp '2019-02-04 12:00:00' - timestamp '2016-02-04 12:00:00') as datum,
			floor(random() * (10) + 1)*5 as suma,
			cast(cast(random() as integer)as boolean) as vyber,
			floor(random() * (10001)+ 1) as uziv
	from generate_series(1, 2500) as seq(i)
)
insert into transakcie (suma,vyber,datum,id_uzivatela)
select suma,vyber,datum,uziv from data;

------goly
with data as ( 
	select	team1.i, team2.i,
			team1.team as first,
			team2.team as second,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz1,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz2,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz3,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz4,
			floor(random() * (4) + 1)  as win,
            team1.i as stavka_id
            
	from generate_series(1, 2000) as seq(i)
	cross join lateral (select seq.i, * from teams order by random() limit 1) as team1
	cross join lateral (select seq.i, * from teams order by random() limit 1) as team2
)
insert into goly (golov_01,golov_23,golov_45,nad5_golov,vyhra,nazov1,nazov2,id_stavky)
select kurz1,kurz2,kurz3,kurz4,win,first,second,stavka_id from data;

with data as ( 
	select	team1.i, team2.i,
			team1.team as first,
			team2.team as second,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz1,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz2,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz3,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz4,
            4000+team1.i as stavka_id
	from generate_series(1, 2000) as seq(i)
	cross join lateral (select seq.i, * from teams order by random() limit 1) as team1
	cross join lateral (select seq.i, * from teams order by random() limit 1) as team2
)
insert into goly (golov_01,golov_23,golov_45,nad5_golov,nazov1,nazov2,id_stavky)
select kurz1,kurz2,kurz3,kurz4,first,second,stavka_id from data;

------vyhra

with data as ( 
	select	team1.i, team2.i,
			team1.team as first,
			team2.team as second,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz1,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz2,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz3,
			floor(random() * (3) + 1)  as vyhra,
            2000+team1.i as stavka_id
	from generate_series(1, 2000) as seq(i)
	cross join lateral (select seq.i, * from teams order by random() limit 1) as team1
	cross join lateral (select seq.i, * from teams order by random() limit 1) as team2
)
insert into vyhra (tim1,tim2,remiza,vyherny_tim,nazov1,nazov2,id_stavky)
select kurz1,kurz2,kurz3,vyhra,first,second,stavka_id from data;

with data as ( 
	select	team1.i, team2.i,
			team1.team as first,
			team2.team as second,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz1,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz2,
			cast((random() * (5) + 1) as decimal(8,2)) as kurz3,
            6000+team1.i as stavka_id
	from generate_series(1, 4000) as seq(i)
	cross join lateral (select seq.i, * from teams order by random() limit 1) as team1
	cross join lateral (select seq.i, * from teams order by random() limit 1) as team2
)
insert into vyhra (tim1,tim2,remiza,nazov1,nazov2,id_stavky)
select kurz1,kurz2,kurz3,first,second,stavka_id from data;


drop table if exists teams cascade;
drop table if exists first_names cascade;
drop table if exists last_names cascade;

-------Tikety

with data as ( 
	select  
            seq.i as stavka,
            seq.i as uziv,
            'p' as st,
            floor(random() * (100)+1) as suma,
            floor(random()* 2 + 1) as tip
	from generate_series(1, 8000) as seq(i)  
)

insert into tikety (id_stavky,id_uzivatela,tip,idTiketu,suma,stav)
select stavka,uziv,tip,1,suma,st from data;

with data as ( 
	select  
            seq.i as stavka,
            seq.i as uziv,
            'z' as st,
            floor(random() * (100)+1) as suma,
            floor(random()* 2 + 1) as tip
	from generate_series(8001, 10000) as seq(i)  
)
insert into tikety (id_stavky,id_uzivatela,tip,idTiketu,suma,stav)
select stavka,uziv,tip,1,suma,st from data;]]></console>
    </connection>
  </component>
  <component name="DBNavigator.Project.DatabaseFileManager">
    <open-files />
  </component>
  <component name="DBNavigator.Project.DatabaseSessionManager">
    <connection id="3900d660-5450-45b4-9fbc-5b68f9158736" />
  </component>
  <component name="DBNavigator.Project.DatasetFilterManager">
    <filter-actions connection-id="3900d660-5450-45b4-9fbc-5b68f9158736" dataset="matko9@uniba.sk.konta" active-filter-id="" />
  </component>
  <component name="DBNavigator.Project.EditorStateManager">
    <last-used-providers />
  </component>
  <component name="DBNavigator.Project.FileConnectionMappingManager">
    <mapping file-url="file://$PROJECT_DIR$/Generate.sql" connection-id="3900d660-5450-45b4-9fbc-5b68f9158736" session-id="MAIN" current-schema="matko9@uniba.sk" />
  </component>
  <component name="DBNavigator.Project.MethodExecutionManager">
    <method-browser />
    <execution-history>
      <group-entries value="true" />
      <execution-inputs />
    </execution-history>
    <argument-values-cache />
  </component>
  <component name="DBNavigator.Project.ObjectDependencyManager">
    <last-used-dependency-type value="INCOMING" />
  </component>
  <component name="DBNavigator.Project.ObjectQuickFilterManager">
    <last-used-operator value="EQUAL" />
    <filters />
  </component>
  <component name="DBNavigator.Project.ScriptExecutionManager" clear-outputs="true">
    <recently-used-interfaces>
      <mapping database-type="POSTGRES" interface-id="DEFAULT" />
    </recently-used-interfaces>
  </component>
  <component name="DBNavigator.Project.Settings">
    <connections>
      <connection id="3900d660-5450-45b4-9fbc-5b68f9158736" active="true">
        <database>
          <name value="Pripojka" />
          <description value="" />
          <database-type value="POSTGRES" />
          <config-type value="BASIC" />
          <database-version value="10.8" />
          <driver-source value="BUILTIN" />
          <driver-library value="" />
          <driver value="" />
          <url-type value="DATABASE" />
          <host value="db.dai.fmph.uniba.sk" />
          <port value="5432" />
          <database value="playground" />
          <os-authentication value="false" />
          <empty-authentication value="false" />
          <user value="matko9@uniba.sk" />
          <deprecated-pwd value="dG90b2hlc2xv" />
        </database>
        <properties>
          <auto-commit value="false" />
        </properties>
        <ssh-settings>
          <active value="false" />
          <proxy-host value="" />
          <proxy-port value="22" />
          <proxy-user value="" />
          <deprecated-proxy-pwd value="" />
          <auth-type value="PASSWORD" />
          <key-file value="" />
          <key-passphrase value="" />
        </ssh-settings>
        <ssl-settings>
          <active value="false" />
          <certificate-authority-file value="" />
          <client-certificate-file value="" />
          <client-key-file value="" />
        </ssl-settings>
        <details>
          <charset value="UTF-8" />
          <session-management value="true" />
          <ddl-file-binding value="true" />
          <database-logging value="false" />
          <connect-automatically value="true" />
          <restore-workspace value="true" />
          <restore-workspace-deep value="true" />
          <environment-type value="default" />
          <idle-time-to-disconnect value="30" />
          <idle-time-to-disconnect-pool value="5" />
          <credential-expiry-time value="10" />
          <max-connection-pool-size value="7" />
          <alternative-statement-delimiter value="" />
        </details>
        <object-filters hide-empty-schemas="false">
          <object-type-filter use-master-settings="true">
            <object-type name="SCHEMA" enabled="true" />
            <object-type name="USER" enabled="true" />
            <object-type name="ROLE" enabled="true" />
            <object-type name="PRIVILEGE" enabled="true" />
            <object-type name="CHARSET" enabled="true" />
            <object-type name="TABLE" enabled="true" />
            <object-type name="VIEW" enabled="true" />
            <object-type name="MATERIALIZED_VIEW" enabled="true" />
            <object-type name="NESTED_TABLE" enabled="true" />
            <object-type name="COLUMN" enabled="true" />
            <object-type name="INDEX" enabled="true" />
            <object-type name="CONSTRAINT" enabled="true" />
            <object-type name="DATASET_TRIGGER" enabled="true" />
            <object-type name="DATABASE_TRIGGER" enabled="true" />
            <object-type name="SYNONYM" enabled="true" />
            <object-type name="SEQUENCE" enabled="true" />
            <object-type name="PROCEDURE" enabled="true" />
            <object-type name="FUNCTION" enabled="true" />
            <object-type name="PACKAGE" enabled="true" />
            <object-type name="TYPE" enabled="true" />
            <object-type name="TYPE_ATTRIBUTE" enabled="true" />
            <object-type name="ARGUMENT" enabled="true" />
            <object-type name="DIMENSION" enabled="true" />
            <object-type name="CLUSTER" enabled="true" />
            <object-type name="DBLINK" enabled="true" />
          </object-type-filter>
          <object-name-filters />
        </object-filters>
      </connection>
    </connections>
    <browser-settings>
      <general>
        <display-mode value="TABBED" />
        <navigation-history-size value="100" />
        <show-object-details value="false" />
      </general>
      <filters>
        <object-type-filter>
          <object-type name="SCHEMA" enabled="true" />
          <object-type name="USER" enabled="true" />
          <object-type name="ROLE" enabled="true" />
          <object-type name="PRIVILEGE" enabled="true" />
          <object-type name="CHARSET" enabled="true" />
          <object-type name="TABLE" enabled="true" />
          <object-type name="VIEW" enabled="true" />
          <object-type name="MATERIALIZED_VIEW" enabled="true" />
          <object-type name="NESTED_TABLE" enabled="true" />
          <object-type name="COLUMN" enabled="true" />
          <object-type name="INDEX" enabled="true" />
          <object-type name="CONSTRAINT" enabled="true" />
          <object-type name="DATASET_TRIGGER" enabled="true" />
          <object-type name="DATABASE_TRIGGER" enabled="true" />
          <object-type name="SYNONYM" enabled="true" />
          <object-type name="SEQUENCE" enabled="true" />
          <object-type name="PROCEDURE" enabled="true" />
          <object-type name="FUNCTION" enabled="true" />
          <object-type name="PACKAGE" enabled="true" />
          <object-type name="TYPE" enabled="true" />
          <object-type name="TYPE_ATTRIBUTE" enabled="true" />
          <object-type name="ARGUMENT" enabled="true" />
          <object-type name="DIMENSION" enabled="true" />
          <object-type name="CLUSTER" enabled="true" />
          <object-type name="DBLINK" enabled="true" />
        </object-type-filter>
      </filters>
      <sorting>
        <object-type name="COLUMN" sorting-type="NAME" />
        <object-type name="FUNCTION" sorting-type="NAME" />
        <object-type name="PROCEDURE" sorting-type="NAME" />
        <object-type name="ARGUMENT" sorting-type="POSITION" />
      </sorting>
      <default-editors>
        <object-type name="VIEW" editor-type="SELECTION" />
        <object-type name="PACKAGE" editor-type="SELECTION" />
        <object-type name="TYPE" editor-type="SELECTION" />
      </default-editors>
    </browser-settings>
    <navigation-settings>
      <lookup-filters>
        <lookup-objects>
          <object-type name="SCHEMA" enabled="true" />
          <object-type name="USER" enabled="false" />
          <object-type name="ROLE" enabled="false" />
          <object-type name="PRIVILEGE" enabled="false" />
          <object-type name="CHARSET" enabled="false" />
          <object-type name="TABLE" enabled="true" />
          <object-type name="VIEW" enabled="true" />
          <object-type name="MATERIALIZED VIEW" enabled="true" />
          <object-type name="NESTED TABLE" enabled="false" />
          <object-type name="COLUMN" enabled="false" />
          <object-type name="INDEX" enabled="true" />
          <object-type name="CONSTRAINT" enabled="true" />
          <object-type name="DATASET TRIGGER" enabled="true" />
          <object-type name="DATABASE TRIGGER" enabled="true" />
          <object-type name="SYNONYM" enabled="false" />
          <object-type name="SEQUENCE" enabled="true" />
          <object-type name="PROCEDURE" enabled="true" />
          <object-type name="FUNCTION" enabled="true" />
          <object-type name="PACKAGE" enabled="true" />
          <object-type name="TYPE" enabled="true" />
          <object-type name="TYPE ATTRIBUTE" enabled="false" />
          <object-type name="ARGUMENT" enabled="false" />
          <object-type name="DIMENSION" enabled="false" />
          <object-type name="CLUSTER" enabled="false" />
          <object-type name="DBLINK" enabled="true" />
        </lookup-objects>
        <force-database-load value="false" />
        <prompt-connection-selection value="true" />
        <prompt-schema-selection value="true" />
      </lookup-filters>
    </navigation-settings>
    <dataset-grid-settings>
      <general>
        <enable-zooming value="true" />
        <enable-column-tooltip value="true" />
      </general>
      <sorting>
        <nulls-first value="true" />
        <max-sorting-columns value="4" />
      </sorting>
      <tracking-columns>
        <columnNames value="" />
        <visible value="true" />
        <editable value="false" />
      </tracking-columns>
    </dataset-grid-settings>
    <dataset-editor-settings>
      <text-editor-popup>
        <active value="false" />
        <active-if-empty value="false" />
        <data-length-threshold value="100" />
        <popup-delay value="1000" />
      </text-editor-popup>
      <values-actions-popup>
        <show-popup-button value="true" />
        <element-count-threshold value="1000" />
        <data-length-threshold value="250" />
      </values-actions-popup>
      <general>
        <fetch-block-size value="100" />
        <fetch-timeout value="30" />
        <trim-whitespaces value="true" />
        <convert-empty-strings-to-null value="true" />
        <select-content-on-cell-edit value="true" />
        <large-value-preview-active value="true" />
      </general>
      <filters>
        <prompt-filter-dialog value="true" />
        <default-filter-type value="BASIC" />
      </filters>
      <qualified-text-editor text-length-threshold="300">
        <content-types>
          <content-type name="Text" enabled="true" />
          <content-type name="Properties" enabled="true" />
          <content-type name="XML" enabled="true" />
          <content-type name="DTD" enabled="true" />
          <content-type name="HTML" enabled="true" />
          <content-type name="XHTML" enabled="true" />
          <content-type name="CSS" enabled="true" />
          <content-type name="Java" enabled="true" />
          <content-type name="SQL" enabled="true" />
          <content-type name="PL/SQL" enabled="true" />
          <content-type name="JavaScript" enabled="true" />
          <content-type name="JSP" enabled="true" />
          <content-type name="JSPx" enabled="true" />
          <content-type name="Groovy" enabled="true" />
          <content-type name="FTL" enabled="true" />
          <content-type name="TML" enabled="true" />
          <content-type name="GSP" enabled="true" />
          <content-type name="ASP" enabled="true" />
          <content-type name="VTL" enabled="true" />
          <content-type name="AIDL" enabled="true" />
          <content-type name="YAML" enabled="true" />
          <content-type name="Flex" enabled="true" />
          <content-type name="Manifest" enabled="true" />
        </content-types>
      </qualified-text-editor>
      <record-navigation>
        <navigation-target value="VIEWER" />
      </record-navigation>
    </dataset-editor-settings>
    <code-editor-settings>
      <general>
        <show-object-navigation-gutter value="false" />
        <show-spec-declaration-navigation-gutter value="true" />
        <enable-spellchecking value="true" />
        <enable-reference-spellchecking value="false" />
      </general>
      <confirmations>
        <save-changes value="false" />
        <revert-changes value="true" />
      </confirmations>
    </code-editor-settings>
    <code-completion-settings>
      <filters>
        <basic-filter>
          <filter-element type="RESERVED_WORD" id="keyword" selected="true" />
          <filter-element type="RESERVED_WORD" id="function" selected="true" />
          <filter-element type="RESERVED_WORD" id="parameter" selected="true" />
          <filter-element type="RESERVED_WORD" id="datatype" selected="true" />
          <filter-element type="RESERVED_WORD" id="exception" selected="true" />
          <filter-element type="OBJECT" id="schema" selected="true" />
          <filter-element type="OBJECT" id="role" selected="true" />
          <filter-element type="OBJECT" id="user" selected="true" />
          <filter-element type="OBJECT" id="privilege" selected="true" />
          <user-schema>
            <filter-element type="OBJECT" id="table" selected="true" />
            <filter-element type="OBJECT" id="view" selected="true" />
            <filter-element type="OBJECT" id="materialized view" selected="true" />
            <filter-element type="OBJECT" id="index" selected="true" />
            <filter-element type="OBJECT" id="constraint" selected="true" />
            <filter-element type="OBJECT" id="trigger" selected="true" />
            <filter-element type="OBJECT" id="synonym" selected="false" />
            <filter-element type="OBJECT" id="sequence" selected="true" />
            <filter-element type="OBJECT" id="procedure" selected="true" />
            <filter-element type="OBJECT" id="function" selected="true" />
            <filter-element type="OBJECT" id="package" selected="true" />
            <filter-element type="OBJECT" id="type" selected="true" />
            <filter-element type="OBJECT" id="dimension" selected="true" />
            <filter-element type="OBJECT" id="cluster" selected="true" />
            <filter-element type="OBJECT" id="dblink" selected="true" />
          </user-schema>
          <public-schema>
            <filter-element type="OBJECT" id="table" selected="false" />
            <filter-element type="OBJECT" id="view" selected="false" />
            <filter-element type="OBJECT" id="materialized view" selected="false" />
            <filter-element type="OBJECT" id="index" selected="false" />
            <filter-element type="OBJECT" id="constraint" selected="false" />
            <filter-element type="OBJECT" id="trigger" selected="false" />
            <filter-element type="OBJECT" id="synonym" selected="false" />
            <filter-element type="OBJECT" id="sequence" selected="false" />
            <filter-element type="OBJECT" id="procedure" selected="false" />
            <filter-element type="OBJECT" id="function" selected="false" />
            <filter-element type="OBJECT" id="package" selected="false" />
            <filter-element type="OBJECT" id="type" selected="false" />
            <filter-element type="OBJECT" id="dimension" selected="false" />
            <filter-element type="OBJECT" id="cluster" selected="false" />
            <filter-element type="OBJECT" id="dblink" selected="false" />
          </public-schema>
          <any-schema>
            <filter-element type="OBJECT" id="table" selected="true" />
            <filter-element type="OBJECT" id="view" selected="true" />
            <filter-element type="OBJECT" id="materialized view" selected="true" />
            <filter-element type="OBJECT" id="index" selected="true" />
            <filter-element type="OBJECT" id="constraint" selected="true" />
            <filter-element type="OBJECT" id="trigger" selected="true" />
            <filter-element type="OBJECT" id="synonym" selected="true" />
            <filter-element type="OBJECT" id="sequence" selected="true" />
            <filter-element type="OBJECT" id="procedure" selected="true" />
            <filter-element type="OBJECT" id="function" selected="true" />
            <filter-element type="OBJECT" id="package" selected="true" />
            <filter-element type="OBJECT" id="type" selected="true" />
            <filter-element type="OBJECT" id="dimension" selected="true" />
            <filter-element type="OBJECT" id="cluster" selected="true" />
            <filter-element type="OBJECT" id="dblink" selected="true" />
          </any-schema>
        </basic-filter>
        <extended-filter>
          <filter-element type="RESERVED_WORD" id="keyword" selected="true" />
          <filter-element type="RESERVED_WORD" id="function" selected="true" />
          <filter-element type="RESERVED_WORD" id="parameter" selected="true" />
          <filter-element type="RESERVED_WORD" id="datatype" selected="true" />
          <filter-element type="RESERVED_WORD" id="exception" selected="true" />
          <filter-element type="OBJECT" id="schema" selected="true" />
          <filter-element type="OBJECT" id="user" selected="true" />
          <filter-element type="OBJECT" id="role" selected="true" />
          <filter-element type="OBJECT" id="privilege" selected="true" />
          <user-schema>
            <filter-element type="OBJECT" id="table" selected="true" />
            <filter-element type="OBJECT" id="view" selected="true" />
            <filter-element type="OBJECT" id="materialized view" selected="true" />
            <filter-element type="OBJECT" id="index" selected="true" />
            <filter-element type="OBJECT" id="constraint" selected="true" />
            <filter-element type="OBJECT" id="trigger" selected="true" />
            <filter-element type="OBJECT" id="synonym" selected="true" />
            <filter-element type="OBJECT" id="sequence" selected="true" />
            <filter-element type="OBJECT" id="procedure" selected="true" />
            <filter-element type="OBJECT" id="function" selected="true" />
            <filter-element type="OBJECT" id="package" selected="true" />
            <filter-element type="OBJECT" id="type" selected="true" />
            <filter-element type="OBJECT" id="dimension" selected="true" />
            <filter-element type="OBJECT" id="cluster" selected="true" />
            <filter-element type="OBJECT" id="dblink" selected="true" />
          </user-schema>
          <public-schema>
            <filter-element type="OBJECT" id="table" selected="true" />
            <filter-element type="OBJECT" id="view" selected="true" />
            <filter-element type="OBJECT" id="materialized view" selected="true" />
            <filter-element type="OBJECT" id="index" selected="true" />
            <filter-element type="OBJECT" id="constraint" selected="true" />
            <filter-element type="OBJECT" id="trigger" selected="true" />
            <filter-element type="OBJECT" id="synonym" selected="true" />
            <filter-element type="OBJECT" id="sequence" selected="true" />
            <filter-element type="OBJECT" id="procedure" selected="true" />
            <filter-element type="OBJECT" id="function" selected="true" />
            <filter-element type="OBJECT" id="package" selected="true" />
            <filter-element type="OBJECT" id="type" selected="true" />
            <filter-element type="OBJECT" id="dimension" selected="true" />
            <filter-element type="OBJECT" id="cluster" selected="true" />
            <filter-element type="OBJECT" id="dblink" selected="true" />
          </public-schema>
          <any-schema>
            <filter-element type="OBJECT" id="table" selected="true" />
            <filter-element type="OBJECT" id="view" selected="true" />
            <filter-element type="OBJECT" id="materialized view" selected="true" />
            <filter-element type="OBJECT" id="index" selected="true" />
            <filter-element type="OBJECT" id="constraint" selected="true" />
            <filter-element type="OBJECT" id="trigger" selected="true" />
            <filter-element type="OBJECT" id="synonym" selected="true" />
            <filter-element type="OBJECT" id="sequence" selected="true" />
            <filter-element type="OBJECT" id="procedure" selected="true" />
            <filter-element type="OBJECT" id="function" selected="true" />
            <filter-element type="OBJECT" id="package" selected="true" />
            <filter-element type="OBJECT" id="type" selected="true" />
            <filter-element type="OBJECT" id="dimension" selected="true" />
            <filter-element type="OBJECT" id="cluster" selected="true" />
            <filter-element type="OBJECT" id="dblink" selected="true" />
          </any-schema>
        </extended-filter>
      </filters>
      <sorting enabled="true">
        <sorting-element type="RESERVED_WORD" id="keyword" />
        <sorting-element type="RESERVED_WORD" id="datatype" />
        <sorting-element type="OBJECT" id="column" />
        <sorting-element type="OBJECT" id="table" />
        <sorting-element type="OBJECT" id="view" />
        <sorting-element type="OBJECT" id="materialized view" />
        <sorting-element type="OBJECT" id="index" />
        <sorting-element type="OBJECT" id="constraint" />
        <sorting-element type="OBJECT" id="trigger" />
        <sorting-element type="OBJECT" id="synonym" />
        <sorting-element type="OBJECT" id="sequence" />
        <sorting-element type="OBJECT" id="procedure" />
        <sorting-element type="OBJECT" id="function" />
        <sorting-element type="OBJECT" id="package" />
        <sorting-element type="OBJECT" id="type" />
        <sorting-element type="OBJECT" id="dimension" />
        <sorting-element type="OBJECT" id="cluster" />
        <sorting-element type="OBJECT" id="dblink" />
        <sorting-element type="OBJECT" id="schema" />
        <sorting-element type="OBJECT" id="role" />
        <sorting-element type="OBJECT" id="user" />
        <sorting-element type="RESERVED_WORD" id="function" />
        <sorting-element type="RESERVED_WORD" id="parameter" />
      </sorting>
      <format>
        <enforce-code-style-case value="true" />
      </format>
    </code-completion-settings>
    <execution-engine-settings>
      <statement-execution>
        <fetch-block-size value="100" />
        <execution-timeout value="20" />
        <debug-execution-timeout value="600" />
        <focus-result value="false" />
        <prompt-execution value="false" />
      </statement-execution>
      <script-execution>
        <command-line-interfaces />
        <execution-timeout value="300" />
      </script-execution>
      <method-execution>
        <execution-timeout value="30" />
        <debug-execution-timeout value="600" />
        <parameter-history-size value="10" />
      </method-execution>
    </execution-engine-settings>
    <operation-settings>
      <transactions>
        <uncommitted-changes>
          <on-project-close value="ASK" />
          <on-disconnect value="ASK" />
          <on-autocommit-toggle value="ASK" />
        </uncommitted-changes>
        <multiple-uncommitted-changes>
          <on-commit value="ASK" />
          <on-rollback value="ASK" />
        </multiple-uncommitted-changes>
      </transactions>
      <session-browser>
        <disconnect-session value="ASK" />
        <kill-session value="ASK" />
        <reload-on-filter-change value="false" />
      </session-browser>
      <compiler>
        <compile-type value="KEEP" />
        <compile-dependencies value="ASK" />
        <always-show-controls value="false" />
      </compiler>
      <debugger>
        <debugger-type value="ASK" />
        <use-generic-runners value="true" />
      </debugger>
    </operation-settings>
    <ddl-file-settings>
      <extensions>
        <mapping file-type-id="VIEW" extensions="vw" />
        <mapping file-type-id="TRIGGER" extensions="trg" />
        <mapping file-type-id="PROCEDURE" extensions="prc" />
        <mapping file-type-id="FUNCTION" extensions="fnc" />
        <mapping file-type-id="PACKAGE" extensions="pkg" />
        <mapping file-type-id="PACKAGE_SPEC" extensions="pks" />
        <mapping file-type-id="PACKAGE_BODY" extensions="pkb" />
        <mapping file-type-id="TYPE" extensions="tpe" />
        <mapping file-type-id="TYPE_SPEC" extensions="tps" />
        <mapping file-type-id="TYPE_BODY" extensions="tpb" />
      </extensions>
      <general>
        <lookup-ddl-files value="true" />
        <create-ddl-files value="false" />
        <synchronize-ddl-files value="true" />
        <use-qualified-names value="false" />
        <make-scripts-rerunnable value="true" />
      </general>
    </ddl-file-settings>
    <general-settings>
      <regional-settings>
        <date-format value="MEDIUM" />
        <number-format value="UNGROUPED" />
        <locale value="SYSTEM_DEFAULT" />
        <use-custom-formats value="false" />
      </regional-settings>
      <environment>
        <environment-types>
          <environment-type id="development" name="Development" description="Development environment" color="-2430209/-12296320" readonly-code="false" readonly-data="false" />
          <environment-type id="integration" name="Integration" description="Integration environment" color="-2621494/-12163514" readonly-code="true" readonly-data="false" />
          <environment-type id="production" name="Production" description="Productive environment" color="-11574/-10271420" readonly-code="true" readonly-data="true" />
          <environment-type id="other" name="Other" description="" color="-1576/-10724543" readonly-code="false" readonly-data="false" />
        </environment-types>
        <visibility-settings>
          <connection-tabs value="true" />
          <dialog-headers value="true" />
          <object-editor-tabs value="true" />
          <script-editor-tabs value="false" />
          <execution-result-tabs value="true" />
        </visibility-settings>
      </environment>
    </general-settings>
  </component>
  <component name="DBNavigator.Project.StatementExecutionManager">
    <execution-variables />
  </component>
</project>