#
# You should have received a copy of the GNU General Public License
# along with Indico; if not, see <http://www.gnu.org/licenses/>.
from __future__ import unicode_literals
from indico.core.db.sqlalchemy import db
_reviewed_for_tracks = db.Table(
'reviewed_for_tracks',
db.metadata,
db.Column('abstract_id',
db.Integer,
db.ForeignKey('event_abstracts.abstracts.id'),
primary_key=True,
autoincrement=False,
index=True),
db.Column('track_id',
db.Integer,
db.ForeignKey('events.tracks.id', ondelete='CASCADE'),
primary_key=True,
autoincrement=False,
index=True),
schema='event_abstracts')
_submitted_for_tracks = db.Table(
'submitted_for_tracks',
db.metadata,
db.Column('abstract_id',
db.Integer,
db.ForeignKey('event_abstracts.abstracts.id'),
primary_key=True,
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
# General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with Indico; if not, see <http://www.gnu.org/licenses/>.
from __future__ import unicode_literals
from indico.core.db.sqlalchemy import db
_track_abstract_reviewers_table = db.Table(
'track_abstract_reviewers',
db.metadata,
db.Column('id', db.Integer, primary_key=True),
db.Column('user_id',
db.Integer,
db.ForeignKey('users.users.id'),
index=True,
nullable=False),
db.Column('event_id',
db.Integer,
db.ForeignKey('events.events.id'),
index=True),
db.Column('track_id',
db.Integer,
db.ForeignKey('events.tracks.id'),
index=True),
db.CheckConstraint('(track_id IS NULL) != (event_id IS NULL)',
name='track_xor_event_id_null'),
schema='events')
