## +----------------------------------------------------------------------+
## | OpenConf                                                             |
## +----------------------------------------------------------------------+
## | Copyright (c) 2002-2012 Zakon Group LLC.  All Rights Reserved.       |
## +----------------------------------------------------------------------+
## | This source file is subject to the OpenConf License, available on    |
## | the OpenConf web site: www.OpenConf.com                              |
## +----------------------------------------------------------------------+

## NOTE: This file cannot contain a semi-colon (;) except at the end of a
## SQL statement.

# --------------------------------------------------------

#
# Table structure for table `module_oc_discussion_post`
#

CREATE TABLE IF NOT EXISTS `module_oc_discussion_post` (
  `postid` int(10) unsigned NOT NULL auto_increment,
  `paperid` mediumint(6) unsigned NOT NULL default '0',
  `accountid` smallint(4) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL,
  `content` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`postid`),
  KEY `paperid` (`paperid`),
  KEY `paperid_2` (`paperid`,`time`)
) AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

# --------------------------------------------------------

#
# Table structure for table `module_oc_discussion_read`
#

CREATE TABLE IF NOT EXISTS `module_oc_discussion_read` (
  `paperid` mediumint(6) unsigned NOT NULL default '0',
  `accountid` smallint(4) unsigned NOT NULL default '0',
  `lastread` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`paperid`,`accountid`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

# --------------------------------------------------------

#
# Table structure for table `module_oc_discussion_notification`
#

CREATE TABLE IF NOT EXISTS `module_oc_discussion_notification` (
  `accountid` smallint(4) unsigned NOT NULL,
  `notification` tinyint( 1 ) unsigned NOT NULL default '0',
  PRIMARY KEY (`accountid`),
  INDEX (`notification`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ; 

# --------------------------------------------------------

INSERT INTO `config` (`module`, `setting`, `value`, `name`, `description`, `parse`) VALUES ('oc_discussion', 'OC_DISCUSSION_reviewerAccess', '1', 'Reviewer Access', 'Selecting Yes will allow reviewers to access the discussion forums, in addition to the program committee members.', 0);
INSERT INTO `config` (`module`, `setting`, `value`, `name`, `description`, `parse`) VALUES ('oc_discussion', 'OC_DISCUSSION_incompleteReviewAccess', '0', 'Incomplete Review Access', 'Selecting Yes will allow reviewers to access the a submission\'s discussion even if they have not completed their review of that submission.', 0);
INSERT INTO `config` (`module`, `setting`, `value`, `name`, `description`, `parse`) VALUES ('oc_discussion', 'OC_DISCUSSION_overrideConflict', '0', 'Override Conflicts', 'Selecting Yes will allow access to a submission\'s discussion even if the user has a conflict.', 0);
INSERT INTO `config` (`module`, `setting`, `value`, `name`, `description`, `parse`) VALUES ('oc_discussion', 'OC_DISCUSSION_accessAllPapers', '1', 'Submission Access', 'Select whether to restrict access to assigned submissions only, or permit access to all submissions (subject to the other settings above)', 0);
INSERT INTO `config` (`module`, `setting`, `value`, `name`, `description`, `parse`) VALUES ('oc_discussion', 'OC_DISCUSSION_includeEmail', '1', 'Include Email', 'Selecting Yes will link the poster\'s name to their email address.', 0);
INSERT INTO `config` (`module`, `setting`, `value`, `name`, `description`, `parse`) VALUES ('oc_discussion', 'OC_DISCUSSION_includeStatus', '1', 'Include Status', 'Selecting Yes will display the submission\'s acceptance status with options below.', 0);
INSERT INTO `config` (`module`, `setting`, `value`, `name`, `description`, `parse`) VALUES ('oc_discussion', 'OC_DISCUSSION_showScore', '1', 'Show Score', 'Selecting Yes will display the submission\'s average review recommendation score.<br />Include Status must be enabled as well.', 0);
INSERT INTO `config` (`module`, `setting`, `value`, `name`, `description`, `parse`) VALUES ('oc_discussion', 'OC_DISCUSSION_displayReviews', '1', 'Display Reviews', 'Selecting Yes will display the reviews beneath the thread display page.', 0);
INSERT INTO `config` (`module`, `setting`, `value`, `name`, `description`, `parse`) VALUES ('oc_discussion', 'OC_DISCUSSION_displayWithScores', '0', 'Display with Scores', 'Selecting Yes will display the discussion thread on the Chair review (show) scores page.', 0);

INSERT INTO `status` (`module`, `setting`, `description`, `status`, `name`, `open`, `close`, `dependency`, `order`) VALUES ('oc_discussion', 'OC_DISCUSSION_open', NULL, 0, 'Discussion', NULL, NULL, NULL, 1);