

insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (0,  'Text File','Plain text file', 'txt', 'text/plain', '/images/icons/icon_text.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (1,  'Acrobat PDF','Adobe Acrobat PDF', 'pdf', 'application/pdf', '/images/icons/icon_pdf.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (2,  'Image/JPEG','JPEG, JPG, JFIF, etc.', 'jpg', 'image/jpeg', '/images/icons/icon_jpg.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (3,  'Image/GIF','GIF Image.', 'gif', 'image/gif', '/images/icons/icon_gif.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (4,  'Image/BMP','Windows BMP Image', 'bmp', 'image/bmp', '/images/icons/icon_bmp.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (5,  'Image/TIF','TIFF Image.', 'tif', 'image/tif', '/images/icons/icon_jpg.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (6,  'Image/TGA','TARGA Image', 'tga', 'image/tga', '/images/icons/icon_jpg.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (7,  'MS Word','Microsoft Word Document', 'doc', 'application/msword', '/images/icons/icon_word.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (8,  'MS Excel','Microsoft Excel File', 'xls', 'application/vnd.ms-excel', '/images/icons/icon_xls.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (9,  'MS PowerPoint','Microsoft PowerPoint File', 'ppt', 'application/vnd.ms-powerpoint', '/images/icons/icon_ppt.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (10, 'MS Access Database','Microsoft Access File', 'mdb', 'application/vnd.ms-access', '/images/icons/icon_mdb.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (11, 'Visio Drawing','Microsoft Visio File', 'vsd', 'application/vnd.visio', '/images/icons/icon_vsd.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (12, 'XML Data',' XML File', 'xml', 'text/xml', '/images/icons/icon_text.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (13, 'Zip File','ZIP Compressed file', 'zip', 'application/x-zip-compressed', '/images/icons/icon_zip.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (14, 'File','Unknown file type', '.', 'application/octet', '/images/icons/icon_text.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (15, 'HTML File','HTML File', 'htm', 'text/html', '/images/icons/icon_html.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (16, 'HTML File','HTML File', 'html', 'text/html', '/images/icons/icon_html.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (17, 'GZip File','GZIP Compressed file', 'gz', 'application/x-gzip-compressed', '/images/icons/icon_zip.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (18, 'MS Excel','Microsoft Excel File', 'csv', 'application/vnd.ms-excel', '/images/icons/icon_xls.gif');
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (19, 'Note','Note', 'txt', 'text/plain', '/images/icons/sm_notes.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (20, 'Email','Email', 'eml', 'text/plain', '/images/icons/sm_email.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (21, 'Calendar Date','Calendar Date', 'date', 'text/plain', '/images/icons/sm_calendar.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (22, 'Reminder','Reminder', 'reminder', 'text/plain', '/images/icons/sm_reminder.gif' );
insert into ELEMENT_TYPE (ELEMENT_TYPE_ID, NAME, DESCRIPTION, EXTENSION, MIME_TYPE, ICON_URL) VALUES (23, 'Contact','Contact', 'contact', 'text/plain', '/images/icons/sm_addressbook.gif' );

insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (1, 'ACCOUNT_ID', 1000);
insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (2, 'FOLDER_ID', 1000);
insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (3, 'ELEMENT_TYPE_ID', 1000);
insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (4, 'ELEMENT_ID', 1000);
insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (5, 'EMAIL_ACCOUNT_ID', 1000);
insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (6, 'REMINDER_FREQUENCY_ID', 1000);
insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (7, 'MAIL_FILTER_ID', 1000);
insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (8, 'USER_RULE_ID', 1000);
insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (10, 'USER_ACTION_ID', 1000);
insert into SEQUENCE (SEQUENCE_ID, NAME, CURRENT_VALUE) values (11, 'EMAIL_ID', 1000);

CREATE INDEX DELETED_UID_EMAIL_ID on DELETED_UID (EMAIL_ACCOUNT_ID);
CREATE INDEX DELETED_UID_UID on DELETED_UID ("UID");

commit;
