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' ;
Y3JlYXRlIHRhYmxlIGVtcGxveWVlKEZuYW1lIHZhcmNoYXIyKDE1KSBub3QgbnVsbCwKTWluaXQgdmFyY2hhcjIoMSkgbm90IG51bGwsCkxuYW1lIHZhcmNoYXIyKDE1KSBub3QgbnVsbCwKU3NuIG51bWJlcigxMCkgbm90IG51bGwsCkJkYXRlIGRhdGUgbm90IG51bGwsCkFkZHJlc3MgdmFyY2hhcjIoNTApIG5vdCBudWxsLApTZXggdmFyY2hhcjIoMSkgbm90IG51bGwsClNhbGFyeSBudW1iZXIoNSkgbm90IG51bGwsClN1cGVyX3NzbiBudW1iZXIoMTApLApwcmltYXJ5IGtleShzc24pLApmb3JlaWduIGtleShTdXBlcl9zc24pIHJlZmVyZW5jZXMgZW1wbG95ZWUoU3NuKQopOwoKY3JlYXRlIHRhYmxlIGRlcGFydG1lbnQgCihEbmFtZSB2YXJjaGFyMigxMCkgbm90IG51bGwsCkRudW1iZXIgbnVtYmVyKDIpIHByaW1hcnkga2V5LApNZ3Jfc3NuIG51bWJlcigxMCksCk1ncl9zdGFydF9kYXRlIGRhdGUgbm90IG51bGwsCmZvcmVpZ24ga2V5KE1ncl9zc24pIHJlZmVyZW5jZXMgZW1wbG95ZWUoU3NuKQopOwoKCmFsdGVyIHRhYmxlIGVtcGxveWVlIAphZGQgRG5vIG51bWJlcigyKSBhZGQgZm9yZWlnbiBrZXkgKERubykgcmVmZXJlbmNlcyBEZXBhcnRtZW50KERudW1iZXIpKTsKCgoKCmNyZWF0ZSB0YWJsZSBkZXB0X2xvY2F0aW9ucwooRG51bWJlciBudW1iZXIoMikgcmVmZXJlbmNlcyBkZXBhcnRtZW50KERudW1iZXIpLApEbG9jYXRpb24gdmFyY2hhcjIoMTUpLApwcmltYXJ5IGtleSAoRG51bWJlcixEbG9jYXRpb24pCik7CgpjcmVhdGUgdGFibGUgcHJvamVjdAooUG5hbWUgdmFyY2hhcjIoMTUpIG5vdCBudWxsLApQbnVtYmVyIG51bWJlcigyKSBwcmltYXJ5IGtleSwKUGxvY2F0aW9uIHZhcmNoYXIyKDE1KSBub3QgbnVsbCwKRG51bSBudW1iZXIoMikgcmVmZXJlbmNlcyBkZXBhcnRtZW50KERudW1iZXIpCik7CgpjcmVhdGUgdGFibGUgd29ya3Nfb24KKEVzc24gbnVtYmVyKDEwKSwKUG5vIG51bWJlcigyKSByZWZlcmVuY2VzIHByb2plY3QoUG51bWJlciksCmhvdXJzIG51bWJlcigzLDEpLApwcmltYXJ5IGtleShFc3NuLFBubyksCmZvcmVpZ24ga2V5KEVzc24pIHJlZmVyZW5jZXMgZW1wbG95ZWUoc3NuKQopOwoKY3JlYXRlIHRhYmxlIGRlcGVuZGVudAooRXNzbiBudW1iZXIoMTApLApEZXBlbmRlbnRfbmFtZSB2YXJjaGFyMigxMCksCnNleCB2YXJjaGFyMigxKSBub3QgbnVsbCwKQmRhdGUgZGF0ZSBub3QgbnVsbCwKUmVsZWF0aW9uc2hpcCB2YXJjaGFyMigxMCkgbm90IG51bGwsCnByaW1hcnkga2V5KEVzc24sRGVwZW5kZW50X25hbWUpLApmb3JlaWduIGtleShFc3NuKSByZWZlcmVuY2VzIGVtcGxveWVlKFNzbikKKTsKCgoKCgovL0luc2VydCBzdGF0ZW1lbnQgZm9yIHRhYmxlIGVtcGxveWVlCgppbnNlcnQgaW50byBlbXBsb3llZShGbmFtZSxtaW5pdCxsbmFtZSxzc24sYmRhdGUsYWRkcmVzcyxzZXgsc2FsYXJ5KQp2YWx1ZXMoJ0pvaG4nLCdCJywnU21pdGgnLDEyMzQ1Njc4OSx0b19kYXRlKCcxOTY1LTAxLTA5JywneXl5eS1tbS1kZCcpLCc3MzEgRm9uZHJlbiwgTW91c3RvbiwgVFgnLCdNJywzMDAwMCk7CgppbnNlcnQgaW50byBlbXBsb3llZShGbmFtZSxtaW5pdCxsbmFtZSxzc24sYmRhdGUsYWRkcmVzcyxzZXgsc2FsYXJ5KQp2YWx1ZXMoJ0ZyYW5rbGluJywnVCcsJ1dvbmsnLDMzMzQ0NTU1NSx0b19kYXRlKCcxOTU1LTEyLTA4JywneXl5eS1tbS1kZCcpLCc2MzggVm9zdCxIb3VzdG9uLFRYJywnTScsNDAwMDApOwoKaW5zZXJ0IGludG8gZW1wbG95ZWUoRm5hbWUsbWluaXQsbG5hbWUsc3NuLGJkYXRlLGFkZHJlc3Msc2V4LHNhbGFyeSxzdXBlcl9zc24pCnZhbHVlcygnQWxpY2lhJywnJywnV2FsbGFjZScsOTg3NjU0MzIxLHRvX2RhdGUoJzE5NDEtMDYtMjAnLCd5eXl5LW1tLWRkJyksJzI5MSBDYXN0bGUsIFNwcmluZywgVFgnLCdGJywyNTAwMCwzMzM0NDU1NTUpOwoKCgppbnNlcnQgaW50byBlbXBsb3llZShGbmFtZSxtaW5pdCxsbmFtZSxzc24sYmRhdGUsYWRkcmVzcyxzZXgsc2FsYXJ5KQp2YWx1ZXMoJ1plbm5pZmVyJywnUycsJ1dhbGxhY2UnLDk4NzY1NDMyMSx0b19kYXRlKCcxOTQxLTA2LTIwJywneXl5eS1tbS1kZCcpLCcyOTEgQmVycnksIEJvbGxhcmUsIFRYJywnRicsNDMwMDApOwoKaW5zZXJ0IGludG8gZW1wbG95ZWUoRm5hbWUsbWluaXQsbG5hbWUsc3NuLGJkYXRlLGFkZHJlc3Msc2V4LHNhbGFyeSkKdmFsdWVzKCdSYW1lc2gnLCdLJywnTmFyYXlhbicsNjY2ODg0NDQ0LHRvX2RhdGUoJzE5NjItMDktMTUnLCd5eXl5LW1tLWRkJyksJzk3NSBGaXJlIE9hayxIdW1ibGUsIFRYJywnTScsMzgwMDApOwoKCmluc2VydCBpbnRvIGVtcGxveWVlKEZuYW1lLG1pbml0LGxuYW1lLHNzbixiZGF0ZSxhZGRyZXNzLHNleCxzYWxhcnkpCnZhbHVlcygnQWhtYWQnLCd2JywnSmFiYmFyJyw5ODc5ODc5ODcsdG9fZGF0ZSgnMTk2OS0wMy0yOScsJ3l5eXktbW0tZGQnKSwnOTgwIERhbGxhcyxIb3VzdGlvbiwgVFgnLCdNJywyNTAwMCk7CgppbnNlcnQgaW50byBlbXBsb3llZShGbmFtZSxtaW5pdCxsbmFtZSxzc24sYmRhdGUsYWRkcmVzcyxzZXgsc2FsYXJ5KQp2YWx1ZXMoJ0phbWVzJywnRScsJ0JvcmcnLDg4ODY2NTU1NSx0b19kYXRlKCcxOTM3LTExLTEwJywneXl5eS1tbS1kZCcpLCc0NTAgU3RvbmUsSG91c3Rpb24sIFRYJywnTScsNTUwMDApOwoKCmluc2VydCBpbnRvIGVtcGxveWVlKEZuYW1lLG1pbml0LGxuYW1lLHNzbixiZGF0ZSxhZGRyZXNzLHNleCxzYWxhcnkpCnZhbHVlcygnSm95Y2UnLCdBJywnRW5nbGlzaCcsNDUzNDUzNDUzLHRvX2RhdGUoJzE5NzItMDctMzEnLCd5eXl5LW1tLWRkJyksJzU2MzEgUmljZSxIb3VzdGlvbiwgVFgnLCdGJywyNTAwMCk7CgovL0luc2VydCBTdGF0ZW1lbnQgZm9yIERlcGFydG1lbnQgdGFibGUKCmluc2VydCBpbnRvIERlcGFydG1lbnQKdmFsdWVzKCdSZXNlYXJjaCcsNSwzMzM0NDU1NTUsdG9fZGF0ZSgnMTk4OC0wNS0yMicsJ3l5eXktbW0tZGQnKSk7CgoKCmluc2VydCBpbnRvIERlcGFydG1lbnQKdmFsdWVzKCdBZG1pbmlzdHJhdGlvbicsNCw5ODc2NTQzMjEsdG9fZGF0ZSgnMTk5NS0wMS0wMScsJ3l5eXktbW0tZGQnKSk7CgoKCmluc2VydCBpbnRvIERlcGFydG1lbnQKdmFsdWVzKCdIZWFkcXVhcnRlcnMnLDEsODg4NjY1NTU1LHRvX2RhdGUoJzE5ODEtMDYtMTknLCd5eXl5LW1tLWRkJykpOwoKCgoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgc3VwZXJfc3NuPTMzMzQ0NTU1NQp3aGVyZSBzdXBlcl9zc24gaXMgbnVsbCBhbmQgbWluaXQ9J0InOwoKCgp1cGRhdGUgZW1wbG95ZWUKc2V0IHN1cGVyX3Nzbj04ODg1NjU1NTUKd2hlcmUgc3NuPTMzMzQ0NTU1NTsKCnVwZGF0ZSBlbXBsb3llZQpzZXQgc3VwZXJfc3NuPTMzMzQ0NTU1NQp3aGVyZSBzc249OTk5ODg3Nzc3OwoKdXBkYXRlIGVtcGxveWVlCnNldCBzdXBlcl9zc249OTg3NjU0MzIxCndoZXJlIHNzbj05OTk4ODc3Nzc7Cgp1cGRhdGUgZW1wbG95ZWUKc2V0IHN1cGVyX3Nzbj04ODg2NjU1NTUKd2hlcmUgc3NuPTk4NzY1NDMyMTsKCgp1cGRhdGUgZW1wbG95ZWUKc2V0IHN1cGVyX3Nzbj0zMzM0NDU1NTUKd2hlcmUgc3NuPTY2Njg4NDQ0NDsKCnVwZGF0ZSBlbXBsb3llZQpzZXQgc3VwZXJfc3NuPTMzMzQ0NTU1NQp3aGVyZSBzc249NDUzNDUzNDUzOwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgc3VwZXJfc3NuPTk4NzY1NDMyMQp3aGVyZSBzc249OTg3OTg3OTg3OwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgc3VwZXJfc3NuPW51bGwKd2hlcmUgc3NuPTg4ODY2NTU1NTsKCgppbnNlcnQgaW50byBkZXB0X2xvY2F0aW9ucyB2YWx1ZXMoMSwnSG91c3RvbicpOwoKaW5zZXJ0IGludG8gZGVwdF9sb2NhdGlvbnMgdmFsdWVzKDQsJ1N0YWZmb3JkJyk7CgppbnNlcnQgaW50byBkZXB0X2xvY2F0aW9ucyB2YWx1ZXMoNSwnQmVsbGFycmUnKTsKCmluc2VydCBpbnRvIGRlcHRfbG9jYXRpb25zIHZhbHVlcyg1LCdTdWdhcmxhbmQnKTsKCmluc2VydCBpbnRvIGRlcHRfbG9jYXRpb25zIHZhbHVlcyg1LCdIb3VzdG9uJyk7CgoKaW5zZXJ0IGludG8gcHJvamVjdCB2YWx1ZXMoJ1Byb2R1Y3RzWCcsMSwnQmVsbGFpcmUnLDUpOwoKaW5zZXJ0IGludG8gcHJvamVjdCB2YWx1ZXMoJ1Byb2R1Y3RzWScsMiwnU3VnYXJsYW5kJyw1KTsKCmluc2VydCBpbnRvIHByb2plY3QgdmFsdWVzKCdQcm9kdWN0c1onLDMsJ0hvdXN0b24nLDUpOwoKaW5zZXJ0IGludG8gcHJvamVjdCB2YWx1ZXMoJ0NvbXB1dGVyaXphdGlvbicsMTAsJ1N0YWZmb3JkJyw0KTsKCmluc2VydCBpbnRvIHByb2plY3QgdmFsdWVzKCdSZW9yZ2FuaXphdGlvbicsMjAsJ0hvdXN0b24nLDEpOwoKaW5zZXJ0IGludG8gcHJvamVjdCB2YWx1ZXMoJ05ld2JlbmVmaXRzJywzMCwnU3RhZmZvcmQnLDQpOwoKCmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcygxMjM0NTY3ODksMSwzLjIpOwppbnNlcnQgaW50byB3b3Jrc19vbiB2YWx1ZXMoMTIzNDU2Nzg5LDIsNy41KTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDY2Njg4NDQ0NCwzLDQwLjApOwppbnNlcnQgaW50byB3b3Jrc19vbiB2YWx1ZXMoNDUzNDUzNDUzLDEsMjAuMCk7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcyg0NTM0NTM0NTMsMiwyMC4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDMzMzQ0NTU1NSwyLDEwLjApOwppbnNlcnQgaW50byB3b3Jrc19vbiB2YWx1ZXMoMzMzNDQ1NTU1LDMsMTAuMCk7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcygzMzM0NDU1NTUsMTAsMTAuMCk7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcygzMzM0NDU1NTUsMjAsMTAuMCk7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcyg5OTk4ODc3NzcsMzAsMzAuMCk7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcyg5OTk4ODc3NzcsMTAsMTAuMCk7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcyg5ODc5ODc5ODcsMTAsMzUuMCk7Cmluc2VydCBpbnRvIHdvcmtzX29uIHZhbHVlcyg5ODc5ODc5ODcsMzAsNS4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDk4NzY1NDMyMSwzMCwyMC4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDk4NzY1NDMyMSwyMCw3NS4wKTsKaW5zZXJ0IGludG8gd29ya3Nfb24gdmFsdWVzKDg4ODY2NTU1NSwyMCxudWxsKTsKCgoKaW5zZXJ0IGludG8gZGVwZW5kZW50IHZhbHVlcygzMzM0NDU1NTUsJ0FsaWNlJywnRicsVE9fREFURSgnMTk4Ni0wNC0wNScsJ3l5eXktbW0tZGQnKSwnZGF1Z2h0ZXInKTsKCmluc2VydCBpbnRvIGRlcGVuZGVudCB2YWx1ZXMoMzMzNDQ1NTU1LCdUaGVvZG9yZScsJ00nLFRPX0RBVEUoJzE5ODMtMTAtMjUnLCd5eXl5LW1tLWRkJyksJ3NvbicpOwoKaW5zZXJ0IGludG8gZGVwZW5kZW50IHZhbHVlcygzMzM0NDU1NTUsJ0pveScsJ0YnLFRPX0RBVEUoJzE5NTgtMDUtMDMnLCd5eXl5LW1tLWRkJyksJ3Nwb3VzZScpOwoKaW5zZXJ0IGludG8gZGVwZW5kZW50IHZhbHVlcyg5ODc2NTQzMjEsJ0FibmVyJywnTScsVE9fREFURSgnMTk0Mi0wMi0yOCcsJ3l5eXktbW0tZGQnKSwnc3BvdXNlJyk7CgppbnNlcnQgaW50byBkZXBlbmRlbnQgdmFsdWVzKDEyMzQ1Njc4OSwnTWljaGFlbCcsJ00nLFRPX0RBVEUoJzE5ODgtMDEtMDQnLCd5eXl5LW1tLWRkJyksJ3NvbicpOwoKaW5zZXJ0IGludG8gZGVwZW5kZW50IHZhbHVlcygxMjM0NTY3ODksJ0FsaWNlJywnRicsVE9fREFURSgnMTk4OC0xMi0zMCcsJ3l5eXktbW0tZGQnKSwnZGF1Z2h0ZXInKTsKCmluc2VydCBpbnRvIGRlcGVuZGVudCB2YWx1ZXMoMTIzNDU2Nzg5LCdFbGl6YWJldGgnLCdGJyxUT19EQVRFKCcxOTY3LTA1LTA1JywneXl5eS1tbS1kZCcpLCdzcG91c2UnKTsKCgoKCkFsdGVyIHRhYmxlIGVtcGxveWVlIGFkZChEbm8gbnVtYmVyKDEpKTsKCnVwZGF0ZSBlbXBsb3llZQpzZXQgRG5vPTUKd2hlcmUgbWluaXQ9J0InOwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgRG5vPTUKd2hlcmUgbWluaXQ9J1QnOwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgRG5vPTQKd2hlcmUgbWluaXQ9J0onOwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgRG5vPTQKd2hlcmUgbWluaXQ9J1MnOwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgRG5vPTUKd2hlcmUgbWluaXQ9J0snOwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgRG5vPTUKd2hlcmUgbWluaXQ9J0EnOwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgRG5vPTQKd2hlcmUgbWluaXQ9J1YnOwoKCnVwZGF0ZSBlbXBsb3llZQpzZXQgRG5vPTEKd2hlcmUgbWluaXQ9J0UnOw==