//Creating all Tables
create table employee( Fname varchar2( 15 ) not null ,
Minit varchar2( 1 ) not null ,
Lname varchar2( 15 ) not null ,
Ssn number( 10 ) not null ,
Bdate date not null ,
Address varchar2( 50 ) not null ,
Sex varchar2( 1 ) not null ,
Salary number( 5 ) not null ,
Super_ssn number( 10 ) ,
primary key( ssn) ,
foreign key( Super_ssn) references employee( Ssn)
) ;
create table department
( Dname varchar2( 10 ) not null ,
Dnumber number( 2 ) primary key,
Mgr_ssn number( 10 ) ,
Mgr_start_date date not null ,
foreign key( Mgr_ssn) references employee( Ssn)
) ;
alter table employee
add Dno number( 2 ) add foreign key ( Dno) references Department( Dnumber) ) ;
create table dept_locations
( Dnumber number( 2 ) references department( Dnumber) ,
Dlocation varchar2( 15 ) ,
primary key ( Dnumber, Dlocation)
) ;
create table project
( Pname varchar2( 15 ) not null ,
Pnumber number( 2 ) primary key,
Plocation varchar2( 15 ) not null ,
Dnum number( 2 ) references department( Dnumber)
) ;
create table works_on
( Essn number( 10 ) ,
Pno number( 2 ) references project( Pnumber) ,
hours number( 3 , 1 ) ,
primary key( Essn, Pno) ,
foreign key( Essn) references employee( ssn)
) ;
create table dependent
( Essn number( 10 ) ,
Dependent_name varchar2( 10 ) ,
sex varchar2( 1 ) not null ,
Bdate date not null ,
Releationship varchar2( 10 ) not null ,
primary key( Essn, Dependent_name) ,
foreign key( Essn) references employee( Ssn)
) ;
//Insert statement for table employee
insert into employee( Fname, minit, lname, ssn, bdate, address, sex, salary)
values( 'John' , 'B' , 'Smith' , 123456789 , to_date( '1965-01-09' , 'yyyy-mm-dd' ) , '731 Fondren, Mouston, TX' , 'M' , 30000 ) ;
insert into employee( Fname, minit, lname, ssn, bdate, address, sex, salary)
values( 'Franklin' , 'T' , 'Wonk' , 333445555 , to_date( '1955-12-08' , 'yyyy-mm-dd' ) , '638 Vost,Houston,TX' , 'M' , 40000 ) ;
insert into employee( Fname, minit, lname, ssn, bdate, address, sex, salary, super_ssn)
values( 'Alicia' , '' , 'Wallace' , 987654321 , to_date( '1941-06-20' , 'yyyy-mm-dd' ) , '291 Castle, Spring, TX' , 'F' , 25000 , 333445555 ) ;
insert into employee( Fname, minit, lname, ssn, bdate, address, sex, salary)
values( 'Zennifer' , 'S' , 'Wallace' , 987654321 , to_date( '1941-06-20' , 'yyyy-mm-dd' ) , '291 Berry, Bollare, TX' , 'F' , 43000 ) ;
insert into employee( Fname, minit, lname, ssn, bdate, address, sex, salary)
values( 'Ramesh' , 'K' , 'Narayan' , 666884444 , to_date( '1962-09-15' , 'yyyy-mm-dd' ) , '975 Fire Oak,Humble, TX' , 'M' , 38000 ) ;
insert into employee( Fname, minit, lname, ssn, bdate, address, sex, salary)
values( 'Ahmad' , 'v' , 'Jabbar' , 987987987 , to_date( '1969-03-29' , 'yyyy-mm-dd' ) , '980 Dallas,Houstion, TX' , 'M' , 25000 ) ;
insert into employee( Fname, minit, lname, ssn, bdate, address, sex, salary)
values( 'James' , 'E' , 'Borg' , 888665555 , to_date( '1937-11-10' , 'yyyy-mm-dd' ) , '450 Stone,Houstion, TX' , 'M' , 55000 ) ;
insert into employee( Fname, minit, lname, ssn, bdate, address, sex, salary)
values( 'Joyce' , 'A' , 'English' , 453453453 , to_date( '1972-07-31' , 'yyyy-mm-dd' ) , '5631 Rice,Houstion, TX' , 'F' , 25000 ) ;
//Insert Statement for Department table
insert into Department
values( 'Research' , 5 , 333445555 , to_date( '1988-05-22' , 'yyyy-mm-dd' ) ) ;
insert into Department
values( 'Administration' , 4 , 987654321 , to_date( '1995-01-01' , 'yyyy-mm-dd' ) ) ;
insert into Department
values( 'Headquarters' , 1 , 888665555 , to_date( '1981-06-19' , 'yyyy-mm-dd' ) ) ;
update employee
set super_ssn= 333445555
where super_ssn is null and minit= 'B' ;
update employee
set super_ssn= 888565555
where ssn= 333445555 ;
update employee
set super_ssn= 333445555
where ssn= 999887777 ;
update employee
set super_ssn= 987654321
where ssn= 999887777 ;
update employee
set super_ssn= 888665555
where ssn= 987654321 ;
update employee
set super_ssn= 333445555
where ssn= 666884444 ;
update employee
set super_ssn= 333445555
where ssn= 453453453 ;
update employee
set super_ssn= 987654321
where ssn= 987987987 ;
update employee
set super_ssn= null
where ssn= 888665555 ;
insert into dept_locations values( 1 , 'Houston' ) ;
insert into dept_locations values( 4 , 'Stafford' ) ;
insert into dept_locations values( 5 , 'Bellarre' ) ;
insert into dept_locations values( 5 , 'Sugarland' ) ;
insert into dept_locations values( 5 , 'Houston' ) ;
insert into project values( 'ProductsX' , 1 , 'Bellaire' , 5 ) ;
insert into project values( 'ProductsY' , 2 , 'Sugarland' , 5 ) ;
insert into project values( 'ProductsZ' , 3 , 'Houston' , 5 ) ;
insert into project values( 'Computerization' , 10 , 'Stafford' , 4 ) ;
insert into project values( 'Reorganization' , 20 , 'Houston' , 1 ) ;
insert into project values( 'Newbenefits' , 30 , 'Stafford' , 4 ) ;
insert into works_on values( 123456789 , 1 , 3.2 ) ;
insert into works_on values( 123456789 , 2 , 7.5 ) ;
insert into works_on values( 666884444 , 3 , 40.0 ) ;
insert into works_on values( 453453453 , 1 , 20.0 ) ;
insert into works_on values( 453453453 , 2 , 20.0 ) ;
insert into works_on values( 333445555 , 2 , 10.0 ) ;
insert into works_on values( 333445555 , 3 , 10.0 ) ;
insert into works_on values( 333445555 , 10 , 10.0 ) ;
insert into works_on values( 333445555 , 20 , 10.0 ) ;
insert into works_on values( 999887777 , 30 , 30.0 ) ;
insert into works_on values( 999887777 , 10 , 10.0 ) ;
insert into works_on values( 987987987 , 10 , 35.0 ) ;
insert into works_on values( 987987987 , 30 , 5.0 ) ;
insert into works_on values( 987654321 , 30 , 20.0 ) ;
insert into works_on values( 987654321 , 20 , 75.0 ) ;
insert into works_on values( 888665555 , 20 , null ) ;
insert into dependent values( 333445555 , 'Alice' , 'F' , TO_DATE( '1986-04-05' , 'yyyy-mm-dd' ) , 'daughter' ) ;
insert into dependent values( 333445555 , 'Theodore' , 'M' , TO_DATE( '1983-10-25' , 'yyyy-mm-dd' ) , 'son' ) ;
insert into dependent values( 333445555 , 'Joy' , 'F' , TO_DATE( '1958-05-03' , 'yyyy-mm-dd' ) , 'spouse' ) ;
insert into dependent values( 987654321 , 'Abner' , 'M' , TO_DATE( '1942-02-28' , 'yyyy-mm-dd' ) , 'spouse' ) ;
insert into dependent values( 123456789 , 'Michael' , 'M' , TO_DATE( '1988-01-04' , 'yyyy-mm-dd' ) , 'son' ) ;
insert into dependent values( 123456789 , 'Alice' , 'F' , TO_DATE( '1988-12-30' , 'yyyy-mm-dd' ) , 'daughter' ) ;
insert into dependent values( 123456789 , 'Elizabeth' , 'F' , TO_DATE( '1967-05-05' , 'yyyy-mm-dd' ) , 'spouse' ) ;
Alter table employee add( Dno number( 1 ) ) ;
update employee
set Dno= 5
where minit= 'B' ;
update employee
set Dno= 5
where minit= 'T' ;
update employee
set Dno= 4
where minit= 'J' ;
update employee
set Dno= 4
where minit= 'S' ;
update employee
set Dno= 5
where minit= 'K' ;
update employee
set Dno= 5
where minit= 'A' ;
update employee
set Dno= 4
where minit= 'V' ;
update employee
set Dno= 1
where minit= 'E' ;
Ly9DcmVhdGluZyBhbGwgVGFibGVzCgpjcmVhdGUgdGFibGUgZW1wbG95ZWUoRm5hbWUgdmFyY2hhcjIoMTUpIG5vdCBudWxsLApNaW5pdCB2YXJjaGFyMigxKSBub3QgbnVsbCwKTG5hbWUgdmFyY2hhcjIoMTUpIG5vdCBudWxsLApTc24gbnVtYmVyKDEwKSBub3QgbnVsbCwKQmRhdGUgZGF0ZSBub3QgbnVsbCwKQWRkcmVzcyB2YXJjaGFyMig1MCkgbm90IG51bGwsClNleCB2YXJjaGFyMigxKSBub3QgbnVsbCwKU2FsYXJ5IG51bWJlcig1KSBub3QgbnVsbCwKU3VwZXJfc3NuIG51bWJlcigxMCksCnByaW1hcnkga2V5KHNzbiksCmZvcmVpZ24ga2V5KFN1cGVyX3NzbikgcmVmZXJlbmNlcyBlbXBsb3llZShTc24pCik7CgpjcmVhdGUgdGFibGUgZGVwYXJ0bWVudCAKKERuYW1lIHZhcmNoYXIyKDEwKSBub3QgbnVsbCwKRG51bWJlciBudW1iZXIoMikgcHJpbWFyeSBrZXksCk1ncl9zc24gbnVtYmVyKDEwKSwKTWdyX3N0YXJ0X2RhdGUgZGF0ZSBub3QgbnVsbCwKZm9yZWlnbiBrZXkoTWdyX3NzbikgcmVmZXJlbmNlcyBlbXBsb3llZShTc24pCik7CgoKYWx0ZXIgdGFibGUgZW1wbG95ZWUgCmFkZCBEbm8gbnVtYmVyKDIpIGFkZCBmb3JlaWduIGtleSAoRG5vKSByZWZlcmVuY2VzIERlcGFydG1lbnQoRG51bWJlcikpOwoKCgoKY3JlYXRlIHRhYmxlIGRlcHRfbG9jYXRpb25zCihEbnVtYmVyIG51bWJlcigyKSByZWZlcmVuY2VzIGRlcGFydG1lbnQoRG51bWJlciksCkRsb2NhdGlvbiB2YXJjaGFyMigxNSksCnByaW1hcnkga2V5IChEbnVtYmVyLERsb2NhdGlvbikKKTsKCmNyZWF0ZSB0YWJsZSBwcm9qZWN0CihQbmFtZSB2YXJjaGFyMigxNSkgbm90IG51bGwsClBudW1iZXIgbnVtYmVyKDIpIHByaW1hcnkga2V5LApQbG9jYXRpb24gdmFyY2hhcjIoMTUpIG5vdCBudWxsLApEbnVtIG51bWJlcigyKSByZWZlcmVuY2VzIGRlcGFydG1lbnQoRG51bWJlcikKKTsKCmNyZWF0ZSB0YWJsZSB3b3Jrc19vbgooRXNzbiBudW1iZXIoMTApLApQbm8gbnVtYmVyKDIpIHJlZmVyZW5jZXMgcHJvamVjdChQbnVtYmVyKSwKaG91cnMgbnVtYmVyKDMsMSksCnByaW1hcnkga2V5KEVzc24sUG5vKSwKZm9yZWlnbiBrZXkoRXNzbikgcmVmZXJlbmNlcyBlbXBsb3llZShzc24pCik7CgpjcmVhdGUgdGFibGUgZGVwZW5kZW50CihFc3NuIG51bWJlcigxMCksCkRlcGVuZGVudF9uYW1lIHZhcmNoYXIyKDEwKSwKc2V4IHZhcmNoYXIyKDEpIG5vdCBudWxsLApCZGF0ZSBkYXRlIG5vdCBudWxsLApSZWxlYXRpb25zaGlwIHZhcmNoYXIyKDEwKSBub3QgbnVsbCwKcHJpbWFyeSBrZXkoRXNzbixEZXBlbmRlbnRfbmFtZSksCmZvcmVpZ24ga2V5KEVzc24pIHJlZmVyZW5jZXMgZW1wbG95ZWUoU3NuKQopOwoKCgoKCi8vSW5zZXJ0IHN0YXRlbWVudCBmb3IgdGFibGUgZW1wbG95ZWUKCmluc2VydCBpbnRvIGVtcGxveWVlKEZuYW1lLG1pbml0LGxuYW1lLHNzbixiZGF0ZSxhZGRyZXNzLHNleCxzYWxhcnkpCnZhbHVlcygnSm9obicsJ0InLCdTbWl0aCcsMTIzNDU2Nzg5LHRvX2RhdGUoJzE5NjUtMDEtMDknLCd5eXl5LW1tLWRkJyksJzczMSBGb25kcmVuLCBNb3VzdG9uLCBUWCcsJ00nLDMwMDAwKTsKCmluc2VydCBpbnRvIGVtcGxveWVlKEZuYW1lLG1pbml0LGxuYW1lLHNzbixiZGF0ZSxhZGRyZXNzLHNleCxzYWxhcnkpCnZhbHVlcygnRnJhbmtsaW4nLCdUJywnV29uaycsMzMzNDQ1NTU1LHRvX2RhdGUoJzE5NTUtMTItMDgnLCd5eXl5LW1tLWRkJyksJzYzOCBWb3N0LEhvdXN0b24sVFgnLCdNJyw0MDAwMCk7CgppbnNlcnQgaW50byBlbXBsb3llZShGbmFtZSxtaW5pdCxsbmFtZSxzc24sYmRhdGUsYWRkcmVzcyxzZXgsc2FsYXJ5LHN1cGVyX3NzbikKdmFsdWVzKCdBbGljaWEnLCcnLCdXYWxsYWNlJyw5ODc2NTQzMjEsdG9fZGF0ZSgnMTk0MS0wNi0yMCcsJ3l5eXktbW0tZGQnKSwnMjkxIENhc3RsZSwgU3ByaW5nLCBUWCcsJ0YnLDI1MDAwLDMzMzQ0NTU1NSk7CgoKCmluc2VydCBpbnRvIGVtcGxveWVlKEZuYW1lLG1pbml0LGxuYW1lLHNzbixiZGF0ZSxhZGRyZXNzLHNleCxzYWxhcnkpCnZhbHVlcygnWmVubmlmZXInLCdTJywnV2FsbGFjZScsOTg3NjU0MzIxLHRvX2RhdGUoJzE5NDEtMDYtMjAnLCd5eXl5LW1tLWRkJyksJzI5MSBCZXJyeSwgQm9sbGFyZSwgVFgnLCdGJyw0MzAwMCk7CgppbnNlcnQgaW50byBlbXBsb3llZShGbmFtZSxtaW5pdCxsbmFtZSxzc24sYmRhdGUsYWRkcmVzcyxzZXgsc2FsYXJ5KQp2YWx1ZXMoJ1JhbWVzaCcsJ0snLCdOYXJheWFuJyw2NjY4ODQ0NDQsdG9fZGF0ZSgnMTk2Mi0wOS0xNScsJ3l5eXktbW0tZGQnKSwnOTc1IEZpcmUgT2FrLEh1bWJsZSwgVFgnLCdNJywzODAwMCk7CgoKaW5zZXJ0IGludG8gZW1wbG95ZWUoRm5hbWUsbWluaXQsbG5hbWUsc3NuLGJkYXRlLGFkZHJlc3Msc2V4LHNhbGFyeSkKdmFsdWVzKCdBaG1hZCcsJ3YnLCdKYWJiYXInLDk4Nzk4Nzk4Nyx0b19kYXRlKCcxOTY5LTAzLTI5JywneXl5eS1tbS1kZCcpLCc5ODAgRGFsbGFzLEhvdXN0aW9uLCBUWCcsJ00nLDI1MDAwKTsKCmluc2VydCBpbnRvIGVtcGxveWVlKEZuYW1lLG1pbml0LGxuYW1lLHNzbixiZGF0ZSxhZGRyZXNzLHNleCxzYWxhcnkpCnZhbHVlcygnSmFtZXMnLCdFJywnQm9yZycsODg4NjY1NTU1LHRvX2RhdGUoJzE5MzctMTEtMTAnLCd5eXl5LW1tLWRkJyksJzQ1MCBTdG9uZSxIb3VzdGlvbiwgVFgnLCdNJyw1NTAwMCk7CgoKaW5zZXJ0IGludG8gZW1wbG95ZWUoRm5hbWUsbWluaXQsbG5hbWUsc3NuLGJkYXRlLGFkZHJlc3Msc2V4LHNhbGFyeSkKdmFsdWVzKCdKb3ljZScsJ0EnLCdFbmdsaXNoJyw0NTM0NTM0NTMsdG9fZGF0ZSgnMTk3Mi0wNy0zMScsJ3l5eXktbW0tZGQnKSwnNTYzMSBSaWNlLEhvdXN0aW9uLCBUWCcsJ0YnLDI1MDAwKTsKCi8vSW5zZXJ0IFN0YXRlbWVudCBmb3IgRGVwYXJ0bWVudCB0YWJsZQoKaW5zZXJ0IGludG8gRGVwYXJ0bWVudAp2YWx1ZXMoJ1Jlc2VhcmNoJyw1LDMzMzQ0NTU1NSx0b19kYXRlKCcxOTg4LTA1LTIyJywneXl5eS1tbS1kZCcpKTsKCgoKaW5zZXJ0IGludG8gRGVwYXJ0bWVudAp2YWx1ZXMoJ0FkbWluaXN0cmF0aW9uJyw0LDk4NzY1NDMyMSx0b19kYXRlKCcxOTk1LTAxLTAxJywneXl5eS1tbS1kZCcpKTsKCgoKaW5zZXJ0IGludG8gRGVwYXJ0bWVudAp2YWx1ZXMoJ0hlYWRxdWFydGVycycsMSw4ODg2NjU1NTUsdG9fZGF0ZSgnMTk4MS0wNi0xOScsJ3l5eXktbW0tZGQnKSk7CgoKCgoKdXBkYXRlIGVtcGxveWVlCnNldCBzdXBlcl9zc249MzMzNDQ1NTU1CndoZXJlIHN1cGVyX3NzbiBpcyBudWxsIGFuZCBtaW5pdD0nQic7CgoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgc3VwZXJfc3NuPTg4ODU2NTU1NQp3aGVyZSBzc249MzMzNDQ1NTU1OwoKdXBkYXRlIGVtcGxveWVlCnNldCBzdXBlcl9zc249MzMzNDQ1NTU1CndoZXJlIHNzbj05OTk4ODc3Nzc7Cgp1cGRhdGUgZW1wbG95ZWUKc2V0IHN1cGVyX3Nzbj05ODc2NTQzMjEKd2hlcmUgc3NuPTk5OTg4Nzc3NzsKCnVwZGF0ZSBlbXBsb3llZQpzZXQgc3VwZXJfc3NuPTg4ODY2NTU1NQp3aGVyZSBzc249OTg3NjU0MzIxOwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgc3VwZXJfc3NuPTMzMzQ0NTU1NQp3aGVyZSBzc249NjY2ODg0NDQ0OwoKdXBkYXRlIGVtcGxveWVlCnNldCBzdXBlcl9zc249MzMzNDQ1NTU1CndoZXJlIHNzbj00NTM0NTM0NTM7CgoKdXBkYXRlIGVtcGxveWVlCnNldCBzdXBlcl9zc249OTg3NjU0MzIxCndoZXJlIHNzbj05ODc5ODc5ODc7CgoKdXBkYXRlIGVtcGxveWVlCnNldCBzdXBlcl9zc249bnVsbAp3aGVyZSBzc249ODg4NjY1NTU1OwoKCmluc2VydCBpbnRvIGRlcHRfbG9jYXRpb25zIHZhbHVlcygxLCdIb3VzdG9uJyk7CgppbnNlcnQgaW50byBkZXB0X2xvY2F0aW9ucyB2YWx1ZXMoNCwnU3RhZmZvcmQnKTsKCmluc2VydCBpbnRvIGRlcHRfbG9jYXRpb25zIHZhbHVlcyg1LCdCZWxsYXJyZScpOwoKaW5zZXJ0IGludG8gZGVwdF9sb2NhdGlvbnMgdmFsdWVzKDUsJ1N1Z2FybGFuZCcpOwoKaW5zZXJ0IGludG8gZGVwdF9sb2NhdGlvbnMgdmFsdWVzKDUsJ0hvdXN0b24nKTsKCgppbnNlcnQgaW50byBwcm9qZWN0IHZhbHVlcygnUHJvZHVjdHNYJywxLCdCZWxsYWlyZScsNSk7CgppbnNlcnQgaW50byBwcm9qZWN0IHZhbHVlcygnUHJvZHVjdHNZJywyLCdTdWdhcmxhbmQnLDUpOwoKaW5zZXJ0IGludG8gcHJvamVjdCB2YWx1ZXMoJ1Byb2R1Y3RzWicsMywnSG91c3RvbicsNSk7CgppbnNlcnQgaW50byBwcm9qZWN0IHZhbHVlcygnQ29tcHV0ZXJpemF0aW9uJywxMCwnU3RhZmZvcmQnLDQpOwoKaW5zZXJ0IGludG8gcHJvamVjdCB2YWx1ZXMoJ1Jlb3JnYW5pemF0aW9uJywyMCwnSG91c3RvbicsMSk7CgppbnNlcnQgaW50byBwcm9qZWN0IHZhbHVlcygnTmV3YmVuZWZpdHMnLDMwLCdTdGFmZm9yZCcsNCk7CgoKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDEyMzQ1Njc4OSwxLDMuMik7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcygxMjM0NTY3ODksMiw3LjUpOwppbnNlcnQgaW50byB3b3Jrc19vbiB2YWx1ZXMoNjY2ODg0NDQ0LDMsNDAuMCk7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcyg0NTM0NTM0NTMsMSwyMC4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDQ1MzQ1MzQ1MywyLDIwLjApOwppbnNlcnQgaW50byB3b3Jrc19vbiB2YWx1ZXMoMzMzNDQ1NTU1LDIsMTAuMCk7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcygzMzM0NDU1NTUsMywxMC4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDMzMzQ0NTU1NSwxMCwxMC4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDMzMzQ0NTU1NSwyMCwxMC4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDk5OTg4Nzc3NywzMCwzMC4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDk5OTg4Nzc3NywxMCwxMC4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDk4Nzk4Nzk4NywxMCwzNS4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDk4Nzk4Nzk4NywzMCw1LjApOwppbnNlcnQgaW50byB3b3Jrc19vbiB2YWx1ZXMoOTg3NjU0MzIxLDMwLDIwLjApOwppbnNlcnQgaW50byB3b3Jrc19vbiB2YWx1ZXMoOTg3NjU0MzIxLDIwLDc1LjApOwppbnNlcnQgaW50byB3b3Jrc19vbiB2YWx1ZXMoODg4NjY1NTU1LDIwLG51bGwpOwoKCgppbnNlcnQgaW50byBkZXBlbmRlbnQgdmFsdWVzKDMzMzQ0NTU1NSwnQWxpY2UnLCdGJyxUT19EQVRFKCcxOTg2LTA0LTA1JywneXl5eS1tbS1kZCcpLCdkYXVnaHRlcicpOwoKaW5zZXJ0IGludG8gZGVwZW5kZW50IHZhbHVlcygzMzM0NDU1NTUsJ1RoZW9kb3JlJywnTScsVE9fREFURSgnMTk4My0xMC0yNScsJ3l5eXktbW0tZGQnKSwnc29uJyk7CgppbnNlcnQgaW50byBkZXBlbmRlbnQgdmFsdWVzKDMzMzQ0NTU1NSwnSm95JywnRicsVE9fREFURSgnMTk1OC0wNS0wMycsJ3l5eXktbW0tZGQnKSwnc3BvdXNlJyk7CgppbnNlcnQgaW50byBkZXBlbmRlbnQgdmFsdWVzKDk4NzY1NDMyMSwnQWJuZXInLCdNJyxUT19EQVRFKCcxOTQyLTAyLTI4JywneXl5eS1tbS1kZCcpLCdzcG91c2UnKTsKCmluc2VydCBpbnRvIGRlcGVuZGVudCB2YWx1ZXMoMTIzNDU2Nzg5LCdNaWNoYWVsJywnTScsVE9fREFURSgnMTk4OC0wMS0wNCcsJ3l5eXktbW0tZGQnKSwnc29uJyk7CgppbnNlcnQgaW50byBkZXBlbmRlbnQgdmFsdWVzKDEyMzQ1Njc4OSwnQWxpY2UnLCdGJyxUT19EQVRFKCcxOTg4LTEyLTMwJywneXl5eS1tbS1kZCcpLCdkYXVnaHRlcicpOwoKaW5zZXJ0IGludG8gZGVwZW5kZW50IHZhbHVlcygxMjM0NTY3ODksJ0VsaXphYmV0aCcsJ0YnLFRPX0RBVEUoJzE5NjctMDUtMDUnLCd5eXl5LW1tLWRkJyksJ3Nwb3VzZScpOwoKCgoKQWx0ZXIgdGFibGUgZW1wbG95ZWUgYWRkKERubyBudW1iZXIoMSkpOwoKdXBkYXRlIGVtcGxveWVlCnNldCBEbm89NQp3aGVyZSBtaW5pdD0nQic7CgoKdXBkYXRlIGVtcGxveWVlCnNldCBEbm89NQp3aGVyZSBtaW5pdD0nVCc7CgoKdXBkYXRlIGVtcGxveWVlCnNldCBEbm89NAp3aGVyZSBtaW5pdD0nSic7CgoKdXBkYXRlIGVtcGxveWVlCnNldCBEbm89NAp3aGVyZSBtaW5pdD0nUyc7CgoKdXBkYXRlIGVtcGxveWVlCnNldCBEbm89NQp3aGVyZSBtaW5pdD0nSyc7CgoKdXBkYXRlIGVtcGxveWVlCnNldCBEbm89NQp3aGVyZSBtaW5pdD0nQSc7CgoKdXBkYXRlIGVtcGxveWVlCnNldCBEbm89NAp3aGVyZSBtaW5pdD0nVic7CgoKdXBkYXRlIGVtcGxveWVlCnNldCBEbm89MQp3aGVyZSBtaW5pdD0nRSc7CgoK