CREATE TABLE Config (confAcronym VARCHAR(20) NOT NULL,
			confName VARCHAR(100) NOT NULL,
			confURL VARCHAR(100) NOT NULL,
                        confMail VARCHAR(60) NOT NULL,
                        chairMail VARCHAR(60) NOT NULL,
	                two_phases_submission CHAR(1) NOT NULL,
	                blind_review CHAR(1) NOT NULL,
	                extended_submission_form CHAR(1) NOT NULL,
	                multi_topics CHAR(1) NOT NULL,
                        submissionDeadline DATE NOT NULL,
                        reviewDeadline DATE NOT NULL,
			cameraReadyDeadline DATE NOT NULL,
                        isAbstractSubmissionOpen CHAR(1) NOT NULL,
                        isSubmissionOpen CHAR(1) NOT NULL,
                        discussion_mode INT NOT NULL,
                        ballot_mode INT NOT NULL,
			isCameraReadyOpen CHAR(1) NOT NULL,
			passwordGenerator VARCHAR(10) NOT NULL,
		        uploadDir     VARCHAR (30) DEFAULT 'FILES',
		        fileTypes   VARCHAR (80) DEFAULT 'pdf',
                       nbReviewersPerItem INTEGER NOT NULL,
                       sizeOfBallot INTEGER NOT NULL,
                        /* The following indicates whether a copy
                               of mail must be sent to the conf mngt */
			mailOnAbstract CHAR(1) NOT NULL,
			mailOnUpload CHAR(1) NOT NULL,
			mailOnReview CHAR(1) NOT NULL,
                     /* The following attr. define the current 
                       selection criteria for the paper status summary table */
                     papersWithStatus char(3) NOT NULL,
                     papersWithFilter char(1) NOT NULL,
                     papersWithRate   decimal (5,2) NOT NULL,
                     papersWithReviewer varchar(60) NOT NULL,
                     papersWithConflict char(1) NOT NULL, /* A, Y, N */
                     papersWithMissingReview char(1) NOT NULL, /* Y, N, A*/
                     papersWithTopic int NOT NULL,
                     papersWithTitle VARCHAR(30) NOT NULL,
                     papersWithAuthor VARCHAR(30) NOT NULL,
                     papersUploaded char(1) NOT NULL, /* A, Y, N */
                     papersQuestions VARCHAR(255) NOT NULL,
                     reviewsQuestions VARCHAR(255) NOT NULL,
                                 /* Encoding of questions/answers */
			/* Selection criterias for papers.reviewers
				 during assignment */
                     selectedPaperTopic   INTEGER NOT NULL,
                     selectedReviewerTopic   INTEGER NOT NULL,
                     installInfo   VARCHAR(255) NOT NULL,
                     installationDate   DATE NOT NULL,
                       PRIMARY KEY (confAcronym)
                     );

# Always insert one and only one line !!!

INSERT INTO Config Values ('MyReview''05' /* conf acronym */,
			'Intl. Conf on Paper Submission Systems',
                        'http://myreview.lri.fr/demo/',
			   'myreview@lri.fr' /* Conf mail */,
			   'myreview@lri.fr' /* Chair */,
	                   'Y', /* Two phases submission */
	                   'N', /* Blind review */
	                   'Y', /* Extended submission form */
	                   'Y', /* Multi-topics */
                            NOW() /* Submission deadline */,
                            NOW() /* Review deadline */,
		            NOW() /* CR deadline */,
                            'Y' /* Abstract submission is open */,
                            'Y' /* Submission is open */,
                            1 /* Discussion is closed by default */,
                            2 /* Ballot mode = general by default */,
			    'N' /* Camera Ready phase is not yet open */,
 			   'pwd' /* Simple password generator */,
 			   'FILES' /* Default dir. for uploaded files */,
 			   'pdf' /* Default: accept only PDF files */,
                           '3' /* RevPerPaper*/,
                      '999',  /* Size of ballots */    
                          'Y', 'Y', 'Y',
			 '0' /* Status of selected papers*/, 
			'0'  /* Position wrt the rate below*/, 
			'0'  /* rate of reference  */,
                        'All' /* All reviewers */,
                        'A' /* With or without conflict */,
                        'A' /* With or without missing review */,
                        0 /* Any topic */,
                        'Any' /* Any title */,
                        'Any' /* Any author */,
                        'A' /* Uploaded or not */,
                        '' /* Encoding of paper questions /answers */,
                        '' /* Encoding of review questions /answers */,
	                0, 0 /* No selected topic */,
                       'Manual install', NOW());