# # 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')