create TABLE SI_IMAGE_FORMATS_tab (
   SI_FORMAT   VARCHAR2(1400) PRIMARY KEY,
   READ_FLG    VARCHAR2(1) NOT NULL,
   WRITE_FLG   VARCHAR2(1) NOT NULL,
   SI_FORMAT_DSC VARCHAR2(255) NOT NULL
);
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'BMPF',
                                          'Y',
                                          'Y',
                                          'Microsoft Windows Bitmap');
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'CALS',
                                          'Y',
                                          'Y',
                                          'CALS Raster');
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'FPIX',
                                          'Y',
                                          'N' ,
                                          'Flashpix' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'GIFF',
                                          'Y',
                                          'Y',
                                          'Graphics Interchange Format' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'JFIF',
                                          'Y',
                                          'Y',
                                          'JPEG File Interchange Format' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'PBMF',
                                          'Y',
                                          'Y',
                                          'Portable Bitmap' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'PCXF',
                                          'Y',
                                          'N',
                                          'PC Paintbrush File Format' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'PGMF',
                                          'Y',
                                          'Y',
                                          'Portable Graymap' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'PICT',
                                          'Y',
                                          'Y',
                                          'Macintosh PICT' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'PNGF',
                                          'Y',
                                          'Y',
                                          'Portable Network Graphic Format' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'PNMF',
                                          'Y',
                                          'Y',
                                          'Portable Anymap' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'PPMF',
                                          'Y',
                                          'Y',
                                          'Portable Pixmap' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'RPIX',
                                          'Y',
                                          'Y',
                                          'Oracle Raw Pixel' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'RASF',
                                          'Y',
                                          'Y',
                                          'Sun Raster' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'TGAF',
                                          'Y',
                                          'Y',
                                        'Truevision Graphics Adapter Format' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'TIFF',
                                          'Y',
                                          'Y',
                                          'Tag Image File Format' );
INSERT INTO SI_IMAGE_FORMATS_tab values ( 'WBMP',
                                          'Y',
                                          'Y',
                                          'WAP Bitmap' );
commit;
create table SI_FEATURES_tab
  (
   SI_feature_name  varchar2(100) PRIMARY KEY
   );
insert into SI_Features_tab values('SI_AverageColor');
insert into SI_Features_tab values('SI_ColorHistogram');
insert into SI_Features_tab values('SI_PositionalColor');
insert into SI_Features_tab values('SI_Texture');
commit;
create table SI_VALUES_tab
  (
   SI_VALUE VARCHAR2(255) NOT NULL PRIMARY KEY,
   SI_SUPPORTED_VALUE INTEGER   
   );
insert into SI_VALUES_tab values('SI_MaxContentLength', 4000000000);
insert into SI_VALUES_tab values('SI_MaxFeatureNameLength', 255);
insert into SI_VALUES_tab values('SI_MaxFormatLength', 4000);
insert into SI_VALUES_tab values('SI_MaxHistogramLength', 100);
insert into SI_VALUES_tab values('SI_MaxRGBColor', 255);
insert into SI_VALUES_tab values('SI_MaxTextureLength', 5);
insert into SI_VALUES_tab values('SI_NumberSections', 9);
insert into SI_VALUES_tab values('SI_MaxValueLength', 4000);
commit;