
rem ---------------------------------------------------------------------------+
prompt Table: i$sdd_file_registry
rem
rem CW 25-Jan-99
rem Fix bug 789780, define new table for file service
rem ---------------------------------------------------------------------------+
rem
create table i$sdd_file_registry (
  pattern       varchar2(256)                 not null
, rule          varchar2(256)                 not null
, notm          number        default 0       not null
, date_created  date          default sysdate not null
, created_by    varchar2(30)  default user    not null
, date_changed  date
, changed_by    varchar2(30)
, id            number
, seq           number
, platform      varchar2(30)
, description   varchar2(256)
)
/

-- pk_sdd_file_registry
alter table i$sdd_file_registry add constraint pk_sdd_file_registry
primary key (pattern, rule)
/

create or replace trigger sdd_file_registry_audit
before insert or update on i$sdd_file_registry
for each row
begin
  if inserting then
    :new.id := jr_util.get_new_irid;
  elsif updating then
    jr_audit.pre_update( :new.notm, :new.date_changed, :new.changed_by);
  end if;
end;
/

-- Create sequence for inserting seq values into columns that need them...
create sequence file_reg_seq increment by 50;

insert into i$sdd_file_registry (pattern, rule, platform, description, seq) values ('%.doc',  'BIN_FILE', 'WIN32', 'Document file'        , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, platform, description, seq) values ('%.DOC',  'BIN_FILE', 'WIN32', 'Document file'        , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, platform, description, seq) values ('%.bat',  'TXT_FILE', 'WIN32', 'Windows batch file'   , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, platform, description, seq) values ('%.BAT',  'TXT_FILE', 'WIN32', 'Windows batch file'   , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, platform, description, seq) values ('%.cmd',  'TXT_FILE', 'WIN32', 'Windows command file' , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, platform, description, seq) values ('%.CMD',  'TXT_FILE', 'WIN32', 'Windows command file' , file_reg_seq.nextval);

insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.txt',  'TXT_FILE', 'Text file'         , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.TXT',  'TXT_FILE', 'Text file'         , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.sql',  'TXT_FILE', 'SQL source file'   , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.SQL',  'TXT_FILE', 'SQL source file'   , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.sqlj', 'TXT_FILE', 'SQLJ source file'  , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.SQLJ', 'TXT_FILE', 'SQLJ source file'  , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.pls',  'TXT_FILE', 'PL/SQL source file', file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PLS',  'TXT_FILE', 'PL/SQL source file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.xml',  'TXT_FILE', 'XML file'          , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.XML',  'TXT_FILE', 'XML file'          , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.html', 'TXT_FILE', 'HTML file'         , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.HTML', 'TXT_FILE', 'HTML file'         , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.htm',  'TXT_FILE', 'HTML file'         , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.HTM',  'TXT_FILE', 'HTML file'         , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.idl',  'TXT_FILE', 'IDL file'          , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.IDL',  'TXT_FILE', 'IDL file'          , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.ini',  'TXT_FILE', 'INI file'          , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.INI',  'TXT_FILE', 'INI file'          , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.jpr',  'TXT_FILE', 'Java project file' , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JPR',  'TXT_FILE', 'Java project file' , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.jpx',  'TXT_FILE', 'Java project definition file', file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JPX',  'TXT_FILE', 'Java project definition file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.jsp',  'TXT_FILE', 'Java server page file'       , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JSP',  'TXT_FILE', 'Java server page file'       , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.app',  'TXT_FILE', 'JCO application file'        , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.APP',  'TXT_FILE', 'JCO application file'        , file_reg_seq.nextval);

insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.jps',  'TXT_FILE', 'PL/SQL Package specification file' , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JPS',  'TXT_FILE', 'PL/SQL Package specification file' , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.pks',  'TXT_FILE', 'PL/SQL Package specification file' , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PKS',  'TXT_FILE', 'PL/SQL Package specification file' , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.jpb',  'TXT_FILE', 'PL/SQL Package body file'          , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JPB',  'TXT_FILE', 'PL/SQL Package body file'          , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.pkb',  'TXT_FILE', 'PL/SQL Package body file'          , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PKB',  'TXT_FILE', 'PL/SQL Package body file'          , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.java', 'TXT_FILE', 'Java file'       , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JAVA', 'TXT_FILE', 'Java file'       , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.c',    'TXT_FILE', 'C source file'   , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.C',    'TXT_FILE', 'C source file'   , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.h',    'TXT_FILE', 'C header file'   , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.H',    'TXT_FILE', 'C header file'   , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.cpp',  'TXT_FILE', 'CPP source file' , file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.CPP',  'TXT_FILE', 'CPP source file' , file_reg_seq.nextval);

insert into i$sdd_file_registry (pattern, rule, description) values ('%.fmb', 'DIFF_MANAGER', 'oracle.repos.services.diffmerge.typeAdapters.CDevFormDeltaMgr');
insert into i$sdd_file_registry (pattern, rule, description) values ('%.FMB', 'DIFF_MANAGER', 'oracle.repos.services.diffmerge.typeAdapters.CDevFormDeltaMgr');
insert into i$sdd_file_registry (pattern, rule, description) values ('%.olb', 'DIFF_MANAGER', 'oracle.repos.services.diffmerge.typeAdapters.CDevObLibDeltaMgr');
insert into i$sdd_file_registry (pattern, rule, description) values ('%.OLB', 'DIFF_MANAGER', 'oracle.repos.services.diffmerge.typeAdapters.CDevObLibDeltaMgr');
insert into i$sdd_file_registry (pattern, rule, description) values ('%.mmb', 'DIFF_MANAGER', 'oracle.repos.services.diffmerge.typeAdapters.CDevMenuDeltaMgr');
insert into i$sdd_file_registry (pattern, rule, description) values ('%.MMB', 'DIFF_MANAGER', 'oracle.repos.services.diffmerge.typeAdapters.CDevMenuDeltaMgr');

insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.pld', 'TXT_FILE', 'PL/SQL Library file', file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PLD', 'TXT_FILE', 'PL/SQL Library file', file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.fmt', 'TXT_FILE', 'Developer form file', file_reg_seq.nextval); 
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.FMT', 'TXT_FILE', 'Developer form file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.css', 'TXT_FILE', 'Cascading stylesheet file (Web PL/SQL Generator)', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.CSS', 'TXT_FILE', 'Cascading stylesheet file (Web PL/SQL Generator)', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.vbp', 'TXT_FILE', 'Visual basic project file'  , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.VBP', 'TXT_FILE', 'Visual basic project file'  , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.vbw', 'TXT_FILE', 'Visual basic compiled file' , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.VBW', 'TXT_FILE', 'Visual basic compiled file' , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.frm', 'TXT_FILE', 'Visual basic form file'     , file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.FRM', 'TXT_FILE', 'Visual basic form file'     , file_reg_seq.nextval);

insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.hm', 'TXT_FILE', 'Mapping between topic IDs and context string (Help Generator)', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.HM', 'TXT_FILE', 'Mapping between topic IDs and context string (Help Generator)', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.js', 'TXT_FILE', 'JavaScript file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JS', 'TXT_FILE', 'JavaScript file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.hpj', 'TXT_FILE', 'Text file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.HPJ', 'TXT_FILE', 'Text file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.drp', 'TXT_FILE', 'Drop file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.DRP', 'TXT_FILE', 'Drop file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.typ', 'TXT_FILE', 'Oracle object type file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.TYP', 'TXT_FILE', 'Oracle object type file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.tyc', 'TXT_FILE', 'Oracle collection type file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.TYC', 'TXT_FILE', 'Oracle collection type file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.aqt', 'TXT_FILE', 'Queue tables file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.AQT', 'TXT_FILE', 'Queue tables file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.aqp', 'TXT_FILE', 'Persistent queues file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.AQP', 'TXT_FILE', 'Persistent queues file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.aqn', 'TXT_FILE', 'Non-persistent queues file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.AQN', 'TXT_FILE', 'Non-persistent queues file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.aqs', 'TXT_FILE', 'Queue subscribers file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.AQS', 'TXT_FILE', 'Queue subscribers file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.cls', 'TXT_FILE', 'Clusters file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.CLS', 'TXT_FILE', 'Clusters file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.cli', 'TXT_FILE', 'Clusters indexes file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.CLI', 'TXT_FILE', 'Clusters indexes file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.tab', 'TXT_FILE', 'Tables file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.TAB', 'TXT_FILE', 'Tables file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.tyb', 'TXT_FILE', 'Oracle object types file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.TYB', 'TXT_FILE', 'Oracle object types file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.vw',  'TXT_FILE',  'Views file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.VW',  'TXT_FILE',  'Views file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.snl', 'TXT_FILE', 'Snapshot logs file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.SNL', 'TXT_FILE', 'Snapshot logs file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.snp', 'TXT_FILE', 'Snapshots file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.SNP', 'TXT_FILE', 'Snapshots file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.ind', 'TXT_FILE', 'Indexes file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.IND', 'TXT_FILE', 'Indexes file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.con', 'TXT_FILE', 'Constraints file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.CON', 'TXT_FILE', 'Constraints file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.ptn', 'TXT_FILE', 'Partitions file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PTN', 'TXT_FILE', 'Partitions file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.sqs', 'TXT_FILE', 'Sequences file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.SQS', 'TXT_FILE', 'Sequences file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.prc', 'TXT_FILE', 'Procedures file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PRC', 'TXT_FILE', 'Procedures file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.fnc', 'TXT_FILE', 'Functions file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.FNC', 'TXT_FILE', 'Functions file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.jav', 'TXT_FILE', 'Java module file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JAV', 'TXT_FILE', 'Java module file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.trg', 'TXT_FILE', 'Triggers file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.TRG', 'TXT_FILE', 'Triggers file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.syn', 'TXT_FILE', 'Synonyms file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.SYN', 'TXT_FILE', 'Synonyms file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.avt', 'TXT_FILE', 'Allowable values file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.AVT', 'TXT_FILE', 'Allowable values file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.ccs', 'TXT_FILE', 'Code control sequences file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.CCS', 'TXT_FILE', 'Code control sequences file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.grt', 'TXT_FILE', 'Grants file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.GRT', 'TXT_FILE', 'Grants file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.lis', 'TXT_FILE', 'Reconcile report file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.LIS', 'TXT_FILE', 'Reconcile report file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.properties', 'TXT_FILE', 'Properties file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PROPERTIES', 'TXT_FILE', 'Properties file', file_reg_seq.nextval);

insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.fmb', 'BIN_FILE', 'Developer form file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.FMB', 'BIN_FILE', 'Developer form file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.fmx', 'BIN_FILE', 'Developer form runtime file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.FMX', 'BIN_FILE', 'Developer form runtime file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.mmb', 'BIN_FILE', 'Developer menu file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.MMB', 'BIN_FILE', 'Developer menu file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.mmx', 'BIN_FILE', 'Developer menu runtime file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.MMX', 'BIN_FILE', 'Developer menu runtime file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.pll', 'BIN_FILE', 'PL/SQL Library file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PLL', 'BIN_FILE', 'PL/SQL Library file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.plx', 'BIN_FILE', 'PL/SQL Library file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PLX', 'BIN_FILE', 'PL/SQL Library file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.rdf', 'BIN_FILE', 'Developer report file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.RDF', 'BIN_FILE', 'Developer report file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.tdf', 'BIN_FILE', 'Developer report template file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.TDF', 'BIN_FILE', 'Developer report template file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.frx', 'BIN_FILE', 'Visual basic compiled form file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.FRX', 'BIN_FILE', 'Visual basic compiled form file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.hlp', 'BIN_FILE', 'Help file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.HLP', 'BIN_FILE', 'Help file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.olb', 'BIN_FILE', 'Object library file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.OLB', 'BIN_FILE', 'Object library file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.rtf', 'BIN_FILE', 'Rich text format file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.RTF', 'BIN_FILE', 'Rich text format file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.class','BIN_FILE','Java class file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.CLASS','BIN_FILE','Java class file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.ico', 'BIN_FILE', 'Icon file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.ICO', 'BIN_FILE', 'Icon file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.xpm', 'BIN_FILE', 'Icon file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.XPM', 'BIN_FILE', 'Icon file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.jar', 'BIN_FILE', 'Java archive file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JAR', 'BIN_FILE', 'Java archive file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.zip', 'BIN_FILE', 'ZIP file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.ZIP', 'BIN_FILE', 'ZIP file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.bmp', 'BIN_FILE', 'Bitmap file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.BMP', 'BIN_FILE', 'Bitmap file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.gif', 'BIN_FILE', 'GIF file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.GIF', 'BIN_FILE', 'GIF file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.jpg', 'BIN_FILE', 'JPG file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.JPG', 'BIN_FILE', 'JPG file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.png', 'BIN_FILE', 'PNG file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PNG', 'BIN_FILE', 'PNG file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.prf', 'BIN_FILE', 'Deployment profiles file', file_reg_seq.nextval);
insert into i$sdd_file_registry (pattern, rule, description, seq) values ('%.PRF', 'BIN_FILE', 'Deployment profiles file', file_reg_seq.nextval);

--drop the sequence now
drop sequence file_reg_seq;