 INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','modifyTemplate','DEMOTHEmodify.tpl');
 INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','addressesMBI','');
 INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','sourceDoc','Thesis');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','addressesMBI','');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','authorfile','DEMOTXT_AU');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','autorngen','Y');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','counterpath','lastid_DEMOTXT_<PA>categ</PA>_<PA>yy</PA>');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','createTemplate','DEMOTXTcreate.tpl');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','documenttype','fulltext');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','edsrn','DEMOTXT_RN');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','emailFile','SuE');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','fieldnameMBI','DEMOTXT_CHANGE');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','iconsize','180');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','modifyTemplate','DEMOTXTmodify.tpl');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','newrnin','');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','paths_and_suffixes','{\"DEMOTXT_FILE\":\"\"}');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','rename','<PA>file:DEMOTXT_RN</PA>');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','rnformat','DEMO-TEXT-<PA>categ</PA>-<PA>yy</PA>');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','rnin','comboDEMOTXT');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','sourceDoc','Textual Document');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','sourceTemplate','DEMOTXT.tpl');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','status','ADDED');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','titleFile','DEMOTXT_TITLE');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOTXT','yeargen','AUTO');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','autorngen','Y');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','counterpath','lastid_DEMOBOO_<PA>yy</PA>');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','edsrn','DEMOBOO_RN');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','rnformat','DEMO-BOOK-<PA>yy</PA>');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','rnin','comboDEMOBOO');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','yeargen','AUTO');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','newrnin','NEWRN');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','status','APPROVAL');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','authorfile','DEMOBOO_AU');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','emailFile','SuE');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','titleFile','DEMOBOO_TITLE');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','categformatDAM','');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','addressesDAM','');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','directory','DEMOBOO');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','fieldnameMBI','DEMOBOO_CHANGE');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','modifyTemplate','DEMOBOOmodify.tpl');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','sourceTemplate','DEMOBOO.tpl');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','addressesMBI','');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','sourceDoc','BOOK');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','casevalues','approve,reject');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','casesteps','2,3');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','casevariable','DEMOBOO_DECSN');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','casedefault','');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','categformatAPP','');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','addressesAPP','');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','createTemplate','DEMOBOOcreate.tpl');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','documenttype','fulltext');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','iconsize','180');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','paths_and_suffixes','{\"DEMOBOO_FILE\":\"\"}');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','rename','<PA>file:DEMOBOO_RN</PA>');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','dummyrec_source_tpl','DEMOBOO.tpl');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','dummyrec_create_tpl','DEMOBOOcreate.tpl');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','decision_file','DEMOBOO_DECSN');
+INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','comments_file','DEMOBOO_COMNT');
 
 INSERT INTO rnkMETHOD (id,name,last_updated) VALUES (2,'demo_jif','0000-00-00 00:00:00');
 INSERT INTO collection_rnkMETHOD (id_collection,id_rnkMETHOD,score) VALUES (15,2,90);


INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'DEMOTHE',1);
INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'DEMOPIC',2);
INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'TEXT',3);
INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'RTEXT',4);

INSERT INTO sbmCATEGORIES (doctype,sname,lname) VALUES ('TEXT','ARTICLE','Article');
INSERT INTO sbmCATEGORIES (doctype,sname,lname) VALUES ('TEXT','BOOK','Book');

INSERT INTO sbmFIELD VALUES ('MBIDEMOTHE',1,1,'DEMOTHE_RN','<table width=\"100%\" bgcolor=\"#D3E3E2\" align=\"center\" cellspacing=\"2\" cellpadding=\"2\" border=\"1\"><tr><td align=\"left\"><br /><b>Modify a thesis\' bibliographic information:</b><br /><br /><span style=\'color: red;\'>*</span>Thesis Reference Number:&nbsp;&nbsp;','M','Reference Number','','2008-03-05','2008-03-05',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('MBIDEMOTHE',1,2,'DEMOTHE_CHANGE','<br /><br /><span style=\"color: red;\">*</span>Choose the fields to be modified:<br />','M','Fields to Modify','','2008-03-05','2008-03-05',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('MBIDEMOTHE',1,3,'DEMOTHE_CONT','<br /><br /></td></tr></table>','O','','','2008-03-05','2008-03-05',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,1,'DEMOTXT_REP','<TABLE WIDTH=\"100%\" BGCOLOR=\"#D3E3E2\" ALIGN=\"center\" CELLSPACING=\"2\" CELLPADDING=\"2\" BORDER=\"1\"><TR><TD ALIGN=\"left\"><br /><b>Submit an ATLANTIS Textual Document:</b><br /><br />Your document will be given a reference number automatically.<br /> However, if it has other reference numbers, please enter them here:<br /><i>(one per line)</i><br />','O','Other Report Numbers','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,2,'DEMOTXT_TITLE','<br /><br /><span style=\"color: red;\">*</span>Document Title:<br />','M','Title','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,3,'DEMOTXT_AU','<br /><br /><table width=\"100%\"><tr><td valign=\"top\"><span style=\"color: red;\">*</span>Author of the Document: <i>(one per line)</i><br />','M','Author(s)','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,4,'DEMOTXT_ABS','</td></tr></table><br /><span style=\"color: red;\">*</span>Abstract:<br />','M','Abstract','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,5,'DEMOTXT_NUMP','<br /><br />Number of Pages:&nbsp;','O','Number of Pages','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,6,'DEMOTXT_LANG','<br /><br /><span style=\"color: red;\">*</span>Language:&nbsp;','O','Language','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,7,'DEMOTXT_DATE','<br /><br /><span style=\"color: red;\">*</span>Date of Document: <i>(dd/mm/yyyy)</i>&nbsp;','M','Date of Document','DatCheckNew','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,8,'DEMOTXT_KW','<br /><br />Keywords/Key-phrases: <i>(one per line)</i><br />','O','Keywords/Key-phrases','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,9,'DEMOTXT_NOTE','<br /><br />Additional Notes or Comments:<br />','O','Notes/Comments','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,10,'DEMOTXT_FILE','<br><br><span style=\"color: red;\">*</span>Enter the full path to the source file to upload:<br />','M','Source File','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOTXT',1,11,'DEMOTXT_END','<br /><br /></td></tr></table><br />','O','','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('MBIDEMOTXT',1,1,'DEMOTXT_RN','<table width=\"100%\" bgcolor=\"#D3E3E2\" align=\"center\" cellspacing=\"2\" cellpadding=\"2\" border=\"1\"><tr><td align=\"left\"><br /><b>Modify a document\'s bibliographic information:</b><br /><br /><span style=\'color: red;\'>*</span>Document Reference Number:&nbsp;&nbsp;','M','Reference Number','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('MBIDEMOTXT',1,2,'DEMOTXT_CHANGE','<br /><br /><span style=\"color: red;\">*</span>Choose the fields to be modified:<br />','M','Fields to Modify','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('MBIDEMOTXT',1,3,'DEMOTXT_CONT','<br /><br /></td></tr></table>','O','','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,1,'DEMOBOO_REP','<TABLE WIDTH=\"100%\" BGCOLOR=\"#D3E3E2\" ALIGN=\"center\" CELLSPACING=\"2\" CELLPADDING=\"2\" BORDER=\"1\"><TR><TD ALIGN=\"left\"><br /><b>Submit an ATLANTIS Book:</b><br /><br />Your book will be given a reference number automatically.<br /> However, if it has other reference numbers, please enter them here:<br /><i>(one per line)</i><br />','O','Other Report Numbers','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,2,'DEMOBOO_TITLE','<br /><br /><span style=\"color: red;\">*</span>Book Title:<br />','M','Title','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,3,'DEMOBOO_AU','<br /><br /><table width=\"100%\"><tr><td valign=\"top\"><span style=\"color: red;\">*</span>Author of the Book: <i>(one per line)</i><br />','M','Author(s)','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,4,'DEMOBOO_ABS','</td></tr></table><br /><span style=\"color: red;\">*</span>Abstract:<br />','M','Abstract','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,5,'DEMOBOO_NUMP','<br /><br />Number of Pages:&nbsp;','O','Number of Pages','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,6,'DEMOBOO_LANG','<br /><br /><span style=\"color: red;\">*</span>Language:&nbsp;','O','Language','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,7,'DEMOBOO_DATE','<br /><br /><span style=\"color: red;\">*</span>Date of the Book: <i>(dd/mm/yyyy)</i>&nbsp;','M','Date of Document','DatCheckNew','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,8,'DEMOBOO_KW','<br /><br />Keywords/Key-phrases: <i>(one per line)</i><br />','O','Keywords/Key-phrases','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,9,'DEMOBOO_NOTE','<br /><br />Additional Notes or Comments:<br />','O','Notes/Comments','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,10,'DEMOBOO_FILE','<br><br><span style=\"color: red;\">*</span>Enter the full path to the source file to upload:<br />','M','Source File','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,11,'DEMOBOO_END','<br /><br /></td></tr></table><br />','O','','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('MBIDEMOBOO',1,1,'DEMOBOO_RN','<table width=\"100%\" bgcolor=\"#D3E3E2\" align=\"center\" cellspacing=\"2\" cellpadding=\"2\" border=\"1\"><tr><td align=\"left\"><br /><b>Modify a book\'s bibliographic information:</b><br /><br /><span style=\'color: red;\'>*</span>Book Reference Number:&nbsp;&nbsp;','M','Reference Number','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('MBIDEMOBOO',1,2,'DEMOBOO_CHANGE','<br /><br /><span style=\"color: red;\">*</span>Choose the fields to be modified:<br />','M','Fields to Modify','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('MBIDEMOBOO',1,3,'DEMOBOO_CONT','<br /><br /></td></tr></table>','O','','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('APPDEMOBOO',1,1,'DEMOBOO_RN','<table width=\"100%\" bgcolor=\"#D3E3E2\" align=\"center\" cellspacing=\"2\" cellpadding=\"2\" border=\"1\"><tr><td align=\"left\"><br /><b>Approve or reject an ATLANTIS book:</b><br /><br /><span style=\'color: red;\'>*</span>Book Reference Number:&nbsp;&nbsp;','M','Reference Number','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('APPDEMOBOO',1,2,'DEMOBOO_DECSN','<br /><br /><span style=\"color: red;\">*</span>Decision:<br />\r\n','M','Decision','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('APPDEMOBOO',1,3,'DEMOBOO_COMNT','<br /><br />Comments on Decision:<br />\r\n','O','Referee\'s Comments','','2008-03-07','2008-03-07',NULL,NULL);
INSERT INTO sbmFIELD VALUES ('APPDEMOBOO',1,4,'DEMOBOO_REGB','<br /><br /></td></tr></table>','O','','','2008-03-07','2008-03-07',NULL,NULL);

INSERT INTO sbmFIELDDESC VALUES ('TI','TI','245__a','T',0,5,60,0,'','','1998-08-17','2002-06-11','<br //>Please correct the title:<br //>','',0);
INSERT INTO sbmFIELDDESC VALUES ('AU','100__a','100__a,700__a','T',0,6,30,0,'','','1998-08-17','2002-02-08','<br //>Please correct the list of authors:<br //>','',0);
