def forwards(self, orm):
# Adding model 'Service'
db.create_table(
u"social_data_service",
(
(u"id", self.gf("django.db.models.fields.AutoField")(primary_key=True)),
("name", self.gf("django.db.models.fields.CharField")(max_length=64)),
("icon", self.gf("django.db.models.fields.CharField")(max_length=128)),
),
)
db.send_create_signal(u"social_data", ["Service"])
# Adding model 'Post'
db.create_table(
u"social_data_post",
(
(u"id", self.gf("django.db.models.fields.AutoField")(primary_key=True)),
("service", self.gf("django.db.models.fields.related.ForeignKey")(to=orm["social_data.Service"])),
("latitude", self.gf("django.db.models.fields.FloatField")()),
("longitude", self.gf("django.db.models.fields.FloatField")()),
("text", self.gf("django.db.models.fields.CharField")(max_length=256)),
("link", self.gf("django.db.models.fields.CharField")(max_length=256)),
("image", self.gf("django.db.models.fields.CharField")(max_length=256)),
("timestamp", self.gf("django.db.models.fields.DateTimeField")()),
),
)
db.send_create_signal(u"social_data", ["Post"])
def forwards(self, orm):
# Adding model 'Auction'
db.create_table('auctions_auction', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('title', self.gf('django.db.models.fields.CharField')(max_length=255)),
('description', self.gf('django.db.models.fields.TextField')()),
('initial_bid', self.gf('django.db.models.fields.PositiveIntegerField')()),
('bid_step', self.gf('django.db.models.fields.PositiveIntegerField')()),
('buyout_price', self.gf('django.db.models.fields.PositiveIntegerField')()),
('start_date', self.gf('django.db.models.fields.DateTimeField')()),
('end_date', self.gf('django.db.models.fields.DateTimeField')()),
('is_published', self.gf('django.db.models.fields.BooleanField')(default=True)),
('add_date', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
))
db.send_create_signal('auctions', ['Auction'])
# Adding M2M table for field photos on 'Auction'
db.create_table('auctions_auction_photos', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('auction', models.ForeignKey(orm['auctions.auction'], null=False)),
('uploadedfile', models.ForeignKey(orm['common.uploadedfile'], null=False))
))
db.create_unique('auctions_auction_photos', ['auction_id', 'uploadedfile_id'])
# Adding model 'AuctionBid'
db.create_table('auctions_auctionbid', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('auction', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auctions.Auction'])),
('amount', self.gf('django.db.models.fields.PositiveIntegerField')()),
('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'])),
('transaction_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['contenttypes.ContentType'], null=True, blank=True)),
('transaction_id', self.gf('django.db.models.fields.PositiveIntegerField')(null=True, blank=True)),
('add_date', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
))
db.send_create_signal('auctions', ['AuctionBid'])
def forwards(self, orm):
# Adding model 'SharedData'
db.create_table('corp_shareddata', (
('url', self.gf('django.db.models.fields.CharField')(max_length=255, primary_key=True)),
('handler', self.gf('django.db.models.fields.CharField')(max_length=255)),
))
db.send_create_signal('corp', ['SharedData'])
# Adding model 'CorpGroup'
db.create_table('corp_corpgroup', (
('name', self.gf('django.db.models.fields.CharField')(max_length=100, primary_key=True)),
))
db.send_create_signal('corp', ['CorpGroup'])
# Adding M2M table for field corporations on 'CorpGroup'
db.create_table('corp_corpgroup_corporations', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('corpgroup', models.ForeignKey(orm['corp.corpgroup'], null=False)),
('corporation', models.ForeignKey(orm['corp.corporation'], null=False))
))
db.create_unique('corp_corpgroup_corporations', ['corpgroup_id', 'corporation_id'])
# Adding M2M table for field allowed_shares on 'CorpGroup'
db.create_table('corp_corpgroup_allowed_shares', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('corpgroup', models.ForeignKey(orm['corp.corpgroup'], null=False)),
('shareddata', models.ForeignKey(orm['corp.shareddata'], null=False))
))
db.create_unique('corp_corpgroup_allowed_shares', ['corpgroup_id', 'shareddata_id'])
def forwards(self, orm):
# Adding model 'Update'
db.create_table('aggregator_update', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('timestamp', self.gf('django.db.models.fields.DateTimeField')()),
))
db.send_create_signal('aggregator', ['Update'])
def forwards(self, orm):
# Adding model 'User'
db.create_table(u'rt_user_user', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('username', self.gf('django.db.models.fields.CharField')(max_length=255)),
('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
('email', self.gf('django.db.models.fields.EmailField')(max_length=75)),
('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
('modified_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
))
db.send_create_signal(u'rt_user', ['User'])
# Adding model 'Group'
db.create_table(u'rt_user_group', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
('modified_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
))
db.send_create_signal(u'rt_user', ['Group'])
# Adding M2M table for field members on 'Group'
m2m_table_name = db.shorten_name(u'rt_user_group_members')
db.create_table(m2m_table_name, (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('group', models.ForeignKey(orm[u'rt_user.group'], null=False)),
('user', models.ForeignKey(orm[u'rt_user.user'], null=False))
))
db.create_unique(m2m_table_name, ['group_id', 'user_id'])
def forwards(self, orm):
# Adding model 'Cohort'
db.create_table('forum_cohort', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=255)),
('created_at', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now, null=True, blank=True)),
('kickoff_date', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now, null=True, blank=True)),
))
db.send_create_signal('forum', ['Cohort'])
# Adding M2M table for field educators on 'Cohort'
db.create_table('forum_cohort_educators', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('cohort', models.ForeignKey(orm['forum.cohort'], null=False)),
('user', models.ForeignKey(orm['forum.user'], null=False))
))
db.create_unique('forum_cohort_educators', ['cohort_id', 'user_id'])
# Adding M2M table for field students on 'Cohort'
db.create_table('forum_cohort_students', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('cohort', models.ForeignKey(orm['forum.cohort'], null=False)),
('user', models.ForeignKey(orm['forum.user'], null=False))
))
db.create_unique('forum_cohort_students', ['cohort_id', 'user_id'])
def forwards(self, orm):
# Adding model 'UserProfile'
db.create_table('accounts_userprofile', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['auth.User'], unique=True)),
('flickr_nsid', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
('flickr_username', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
('flickr_fullname', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
('flickr_oauth_token', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
('flickr_oauth_token_secret', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
('flickr_user', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['flickr.FlickrUser'], unique=True, null=True, blank=True)),
('date_create', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
('date_update', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
))
db.send_create_signal('accounts', ['UserProfile'])
# Adding model 'FlickrContact'
db.create_table('accounts_flickrcontact', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['accounts.UserProfile'])),
('flickr_user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['flickr.FlickrUser'])),
('friend', self.gf('django.db.models.fields.BooleanField')(default=False)),
('family', self.gf('django.db.models.fields.BooleanField')(default=False)),
))
db.send_create_signal('accounts', ['FlickrContact'])
def forwards(self, orm):
# Adding model 'ProjectVideo'
db.create_table(u'projects_projectvideo', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('video', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['videos.Video'])),
('project', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['projects.Project'])),
))
db.send_create_signal(u'projects', ['ProjectVideo'])
# Adding field 'Project.contractor'
db.add_column(u'projects_project', 'contractor',
self.gf('django.db.models.fields.CharField')(max_length=400, null=True, blank=True),
keep_default=False)
# Changing field 'Project.location_name'
db.alter_column(u'projects_project', 'location_name', self.gf('django.db.models.fields.CharField')(max_length=400, null=True))
# Changing field 'Project.estimated_cost'
db.alter_column(u'projects_project', 'estimated_cost', self.gf('django.db.models.fields.FloatField')(null=True))
# Changing field 'Project.summary'
db.alter_column(u'projects_project', 'summary', self.gf('django.db.models.fields.TextField')(null=True))
# Changing field 'Project.total_cost'
db.alter_column(u'projects_project', 'total_cost', self.gf('django.db.models.fields.FloatField')(null=True))
def forwards(self, orm):
# Adding model 'Device'
db.create_table(u'devices_device', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('given_name', self.gf('django.db.models.fields.CharField')(max_length=50, null=True, blank=True)),
('poll_rate', self.gf('django.db.models.fields.IntegerField')(default=60)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='devices', null=True, to=orm['auth.User'])),
('serial_number', self.gf('django.db.models.fields.IntegerField')(unique=True)),
('sim_serial_number', self.gf('django.db.models.fields.IntegerField')(unique=True)),
('date_manufactured', self.gf('django.db.models.fields.DateField')()),
('date_activated', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
('phone_number', self.gf('django_localflavor_us.models.PhoneNumberField')(max_length=20, blank=True)),
('location', self.gf('django.contrib.gis.db.models.fields.PointField')(null=True, blank=True)),
('battery_life', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),
('is_charging', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
('temperature', self.gf('django.db.models.fields.FloatField')(null=True, blank=True)),
('operating_current', self.gf('django.db.models.fields.FloatField')(null=True, blank=True)),
('power_mode', self.gf('django.db.models.fields.CharField')(max_length=4, null=True, blank=True)),
('signal_strength', self.gf('django.db.models.fields.FloatField')(null=True, blank=True)),
('gps_activated', self.gf('django.db.models.fields.BooleanField')(default=False)),
('gps_satellite_count', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),
('last_request', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
('is_active', self.gf('django.db.models.fields.BooleanField')(default=False)),
))
db.send_create_signal(u'devices', ['Device'])
def forwards(self, orm):
# Adding model 'ExerciseWidget'
db.create_table('askbot_exercisewidget', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('title', self.gf('django.db.models.fields.CharField')(max_length=100)),
('exercise_number', self.gf('django.db.models.fields.PositiveIntegerField')(default=7)),
('tagnames', self.gf('django.db.models.fields.CharField')(max_length=50)),
('group', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['askbot.Tag'], null=True, blank=True)),
('search_query', self.gf('django.db.models.fields.CharField')(max_length=50, null=True, blank=True, default='')),
('order_by', self.gf('django.db.models.fields.CharField')(default='-added_at', max_length=18)),
('style', self.gf('django.db.models.fields.TextField')(default='', blank=True, null=True)),
))
db.send_create_signal('askbot', ['ExerciseWidget'])
# Adding model 'AskWidget'
db.create_table('askbot_askwidget', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('title', self.gf('django.db.models.fields.CharField')(max_length=100)),
('group', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='groups', null=True, to=orm['askbot.Tag'])),
('tag', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['askbot.Tag'], null=True, blank=True)),
('include_text_field', self.gf('django.db.models.fields.BooleanField')(default=False)),
('inner_style', self.gf('django.db.models.fields.TextField')(default='', blank=True)),
('outer_style', self.gf('django.db.models.fields.TextField')(default='', blank=True)),
))
db.send_create_signal('askbot', ['AskWidget'])
def forwards(self, orm):
# Adding model 'FarmerBusinessAdvisor'
db.create_table('fncs_farmerbusinessadvisor', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('actor', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['fncs.Actor'])),
))
db.send_create_signal('fncs', ['FarmerBusinessAdvisor'])
# Adding model 'FBAdvisorRelationShip'
db.create_table('fncs_fbadvisorrelationship', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('fba', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['fncs.FarmerBusinessAdvisor'])),
('farmer', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['fncs.Farmer'])),
('registered_by_actor', self.gf('django.db.models.fields.related.ForeignKey')(related_name='registered_by_actor', null=True, to=orm['fncs.Actor'])),
('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
))
db.send_create_signal('fncs', ['FBAdvisorRelationShip'])
# Adding M2M table for field fbas on 'Farmer'
db.create_table('fncs_farmer_fbas', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('farmer', models.ForeignKey(orm['fncs.farmer'], null=False)),
('farmerbusinessadvisor', models.ForeignKey(orm['fncs.farmerbusinessadvisor'], null=False))
))
db.create_unique('fncs_farmer_fbas', ['farmer_id', 'farmerbusinessadvisor_id'])
def forwards(self, orm):
# Adding model 'CalendarGroup'
db.create_table('schedule_calendargroup', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(max_length=40)),
('color', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['main.Color'])),
))
db.send_create_signal('schedule', ['CalendarGroup'])
# Adding M2M table for field members on 'CalendarGroup'
db.create_table('schedule_calendargroup_members', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('calendargroup', models.ForeignKey(orm['schedule.calendargroup'], null=False)),
('user', models.ForeignKey(orm['auth.user'], null=False))
))
db.create_unique('schedule_calendargroup_members', ['calendargroup_id', 'user_id'])
# Adding field 'Event.group'
db.add_column('schedule_event', 'group',
self.gf('django.db.models.fields.related.ForeignKey')(to=orm['schedule.CalendarGroup'], null=True, blank=True),
keep_default=False)
# Changing field 'Event.calendar'
db.alter_column('schedule_event', 'calendar_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['schedule.Calendar'], null=True))
def forwards(self, orm):
# Adding model 'AccessGroup'
db.create_table('sentry_accessgroup', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('team', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['sentry.Team'])),
('name', self.gf('django.db.models.fields.CharField')(max_length=64)),
('type', self.gf('django.db.models.fields.IntegerField')(default=50)),
('managed', self.gf('django.db.models.fields.BooleanField')(default=False)),
('data', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
('date_added', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)),
))
db.send_create_signal('sentry', ['AccessGroup'])
# Adding M2M table for field projects on 'AccessGroup'
db.create_table('sentry_accessgroup_projects', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('accessgroup', models.ForeignKey(orm['sentry.accessgroup'], null=False)),
('project', models.ForeignKey(orm['sentry.project'], null=False))
))
db.create_unique('sentry_accessgroup_projects', ['accessgroup_id', 'project_id'])
# Adding M2M table for field members on 'AccessGroup'
db.create_table('sentry_accessgroup_members', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('accessgroup', models.ForeignKey(orm['sentry.accessgroup'], null=False)),
('user', models.ForeignKey(orm['auth.user'], null=False))
))
db.create_unique('sentry_accessgroup_members', ['accessgroup_id', 'user_id'])
# Adding unique constraint on 'AccessGroup', fields ['team', 'name']
db.create_unique('sentry_accessgroup', ['team_id', 'name'])
def forwards(self, orm):
# Adding model 'ConsiglioComunaleEvent'
db.create_table('pages4gov_consigliocomunaleevent', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('keywords_string', self.gf('django.db.models.fields.CharField')(blank=True, max_length=500)),
('site', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['sites.Site'])),
('title', self.gf('django.db.models.fields.CharField')(max_length=500)),
('slug', self.gf('django.db.models.fields.CharField')(null=True, max_length=2000, blank=True)),
('_meta_title', self.gf('django.db.models.fields.CharField')(null=True, max_length=500, blank=True)),
('description', self.gf('django.db.models.fields.TextField')(blank=True)),
('gen_description', self.gf('django.db.models.fields.BooleanField')(default=True)),
('created', self.gf('django.db.models.fields.DateTimeField')(null=True)),
('updated', self.gf('django.db.models.fields.DateTimeField')(null=True)),
('status', self.gf('django.db.models.fields.IntegerField')(default=2)),
('publish_date', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
('expiry_date', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
('short_url', self.gf('django.db.models.fields.URLField')(null=True, max_length=200, blank=True)),
('in_sitemap', self.gf('django.db.models.fields.BooleanField')(default=True)),
('content', self.gf('mezzanine.core.fields.RichTextField')()),
('user', self.gf('django.db.models.fields.related.ForeignKey')(related_name='consigliocomunaleevents', to=orm['auth.User'])),
('data_of_performance', self.gf('django.db.models.fields.DateTimeField')()),
('news_url', self.gf('django.db.models.fields.URLField')(blank=True, max_length=200)),
('youtube_video_url', self.gf('django.db.models.fields.URLField')(blank=True, max_length=200)),
('youtube_video_url_query', self.gf('django.db.models.fields.CharField')(blank=True, max_length=200)),
('hangout_url', self.gf('django.db.models.fields.URLField')(blank=True, max_length=200)),
))
db.send_create_signal('pages4gov', ['ConsiglioComunaleEvent'])
def forwards(self, orm):
# Adding model 'Message'
db.create_table('txtmessages_message', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(max_length=128)),
('to_type', self.gf('django.db.models.fields.CharField')(default='Everyone', max_length=64)),
('message', self.gf('django.db.models.fields.TextField')()),
('sent', self.gf('django.db.models.fields.BooleanField')(default=False)),
('time_sent', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
('updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
))
db.send_create_signal('txtmessages', ['Message'])
# Adding M2M table for field custom on 'Message'
db.create_table('txtmessages_message_custom', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('message', models.ForeignKey(orm['txtmessages.message'], null=False)),
('pledge', models.ForeignKey(orm['pledge.pledge'], null=False))
))
db.create_unique('txtmessages_message_custom', ['message_id', 'pledge_id'])
# Adding model 'Status'
db.create_table('txtmessages_status', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('message', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['txtmessages.Message'])),
('receiver', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['pledge.Pledge'])),
('sid', self.gf('django.db.models.fields.CharField')(max_length=64)),
('status', self.gf('django.db.models.fields.CharField')(default='Queued', max_length=64)),
))
db.send_create_signal('txtmessages', ['Status'])
def forwards(self, orm):
# Adding model 'Collection'
db.create_table('umarmot_collection', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('title', self.gf('django.db.models.fields.CharField')(max_length=100)),
))
db.send_create_signal('umarmot', ['Collection'])
# Adding M2M table for field sources on 'Collection'
db.create_table('umarmot_collection_sources', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('collection', models.ForeignKey(orm['umarmot.collection'], null=False)),
('contact', models.ForeignKey(orm['addressbook.contact'], null=False))
))
db.create_unique('umarmot_collection_sources', ['collection_id', 'contact_id'])
# Adding M2M table for field accessions on 'Collection'
db.create_table('umarmot_collection_accessions', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('collection', models.ForeignKey(orm['umarmot.collection'], null=False)),
('accession', models.ForeignKey(orm['accessions.accession'], null=False))
))
db.create_unique('umarmot_collection_accessions', ['collection_id', 'accession_id'])
# Adding M2M table for field locations on 'Collection'
db.create_table('umarmot_collection_locations', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('collection', models.ForeignKey(orm['umarmot.collection'], null=False)),
('location', models.ForeignKey(orm['accessions.location'], null=False))
))
db.create_unique('umarmot_collection_locations', ['collection_id', 'location_id'])
def forwards(self, orm):
# Adding model 'ImageModel'
db.create_table(u'blogs_imagemodel', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('img', self.gf('django.db.models.fields.files.ImageField')(max_length=100)),
('name', self.gf('django.db.models.fields.CharField')(max_length=100)),
))
db.send_create_signal(u'blogs', ['ImageModel'])
# Adding model 'Blog'
db.create_table(u'blogs_blog', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('title', self.gf('django.db.models.fields.CharField')(max_length=100)),
('image', self.gf('django.db.models.fields.files.ImageField')(max_length=100)),
('date', self.gf('django.db.models.fields.DateField')(auto_now_add=True, blank=True)),
('intro', self.gf('tinymce.models.HTMLField')()),
('content', self.gf('tinymce.models.HTMLField')()),
('url', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
))
db.send_create_signal(u'blogs', ['Blog'])
# Adding M2M table for field images on 'Blog'
db.create_table(u'blogs_blog_images', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('blog', models.ForeignKey(orm[u'blogs.blog'], null=False)),
('imagemodel', models.ForeignKey(orm[u'blogs.imagemodel'], null=False))
))
db.create_unique(u'blogs_blog_images', ['blog_id', 'imagemodel_id'])
def forwards(self, orm):
# Adding model 'TrackedUser'
db.create_table(
'sentry_trackeduser', (
(
'id', self.gf('sentry.db.models.fields.bounded.BoundedBigAutoField')(
primary_key=True
)
), (
'project',
self.gf('sentry.db.models.fields.FlexibleForeignKey')(to=orm['sentry.Project'])
), ('ident', self.gf('django.db.models.fields.CharField')(max_length=200)),
('email', self.gf('django.db.models.fields.EmailField')(max_length=75, null=True)),
('data', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), (
'last_seen', self.gf('django.db.models.fields.DateTimeField')(
db_index=True
)
), (
'first_seen', self.gf('django.db.models.fields.DateTimeField')(
db_index=True
)
),
)
)
db.send_create_signal('sentry', ['TrackedUser'])
# Adding unique constraint on 'TrackedUser', fields ['project', 'ident']
db.create_unique('sentry_trackeduser', ['project_id', 'ident'])
def forwards(self, orm):
# Adding model 'UploadedFile'
db.create_table('musikovweb_uploadedfile', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('uploadfile', self.gf('django.db.models.fields.files.FileField')(max_length=100)),
))
db.send_create_signal('musikovweb', ['UploadedFile'])
def forwards(self, orm):
# Adding model 'JellyfishIncident'
db.create_table(u'data_jellyfishincident', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('date_observed', self.gf('django.db.models.fields.DateField')()),
('observation_station', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['data.ObservationStation'], on_delete=models.PROTECT)),
('source', self.gf('django.db.models.fields.CharField')(default='W', max_length=2)),
('sting_incidents', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
('total_incidents', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
('created_on', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
('created_by', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='created-incident', null=True, to=orm['auth.User'])),
('updated_on', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
('updated_by', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='updated-incident', null=True, to=orm['auth.User'])),
))
db.send_create_signal(u'data', ['JellyfishIncident'])
# Adding model 'FlagChange'
db.create_table(u'data_flagchange', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('date', self.gf('django.db.models.fields.DateTimeField')()),
('observation_station', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['data.ObservationStation'], on_delete=models.PROTECT)),
('flag_status', self.gf('django.db.models.fields.CharField')(default='N', max_length=1)),
('jellyfish_flag', self.gf('django.db.models.fields.BooleanField')(default=False)),
('created_on', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
('created_by', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='created-flag', null=True, to=orm['auth.User'])),
('updated_on', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
('updated_by', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='updated-flag', null=True, to=orm['auth.User'])),
))
db.send_create_signal(u'data', ['FlagChange'])
# Adding field 'ObservationRoute.use_incident_form'
db.add_column(u'data_observationroute', 'use_incident_form',
self.gf('django.db.models.fields.BooleanField')(default=False),
keep_default=False)
def forwards(self, orm):
# Adding model 'CellSample'
db.create_table(u'rotmic_cellsample', (
(u'sample_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['rotmic.Sample'], unique=True, primary_key=True)),
('cell', self.gf('django.db.models.fields.related.ForeignKey')(related_name='cell_samples', to=orm['rotmic.CellComponent'])),
))
db.send_create_signal('rotmic', ['CellSample'])
def forwards(self, orm):
# Adding model 'UserProfile'
db.create_table(u'profiles_userprofile', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['auth.User'], unique=True)),
('date_of_birth', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
('sex', self.gf('django.db.models.fields.CharField')(max_length=1, null=True, blank=True)),
('social_security_number', self.gf('django.db.models.fields.CharField')(max_length=11, null=True, blank=True)),
('state_id_number', self.gf('django.db.models.fields.CharField')(max_length=8, null=True, blank=True)),
('phone_number', self.gf('django.db.models.fields.CharField')(max_length=30, null=True, blank=True)),
('parent_phone_number', self.gf('django.db.models.fields.CharField')(max_length=30, null=True, blank=True)),
('address', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['schools.Address'], null=True, blank=True)),
('school', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['schools.School'], null=True, blank=True)),
('school_class', self.gf('django.db.models.fields.CharField')(max_length=20, null=True, blank=True)),
('classlevel', self.gf('django.db.models.fields.CharField')(max_length=2, null=True, blank=True)),
))
db.send_create_signal(u'profiles', ['UserProfile'])
# Adding model 'OrganizerProfile'
db.create_table(u'profiles_organizerprofile', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['auth.User'], unique=True)),
('motto', self.gf('django.db.models.fields.CharField')(max_length=250, null=True, blank=True)),
))
db.send_create_signal(u'profiles', ['OrganizerProfile'])
def forwards(self, orm):
# Adding model 'Subscriber'
db.create_table(u'magazine_subscriber', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
('email', self.gf('django.db.models.fields.CharField')(max_length=255)),
('streetAddress1', self.gf('django.db.models.fields.CharField')(max_length=255)),
('streetAddress2', self.gf('django.db.models.fields.CharField')(max_length=255)),
('city', self.gf('django.db.models.fields.CharField')(max_length=255)),
('state', self.gf('django.db.models.fields.CharField')(max_length=255)),
('country', self.gf('django.db.models.fields.CharField')(max_length=255)),
('zipCode', self.gf('django.db.models.fields.CharField')(max_length=255)),
('customerID', self.gf('django.db.models.fields.CharField')(max_length=255)),
('renew', self.gf('django.db.models.fields.BooleanField')()),
('subscriptionType', self.gf('django.db.models.fields.CharField')(max_length=255)),
('time', self.gf('django.db.models.fields.CharField')(max_length=255)),
))
db.send_create_signal(u'magazine', ['Subscriber'])
# Adding model 'Donation'
db.create_table(u'magazine_donation', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('amount', self.gf('django.db.models.fields.IntegerField')()),
('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
('email', self.gf('django.db.models.fields.CharField')(max_length=255)),
('streetAddress1', self.gf('django.db.models.fields.CharField')(max_length=255)),
('streetAddress2', self.gf('django.db.models.fields.CharField')(max_length=255)),
('city', self.gf('django.db.models.fields.CharField')(max_length=255)),
('state', self.gf('django.db.models.fields.CharField')(max_length=255)),
('country', self.gf('django.db.models.fields.CharField')(max_length=255)),
('zipCode', self.gf('django.db.models.fields.CharField')(max_length=255)),
('customerID', self.gf('django.db.models.fields.CharField')(max_length=255)),
('time', self.gf('django.db.models.fields.CharField')(max_length=255)),
))
db.send_create_signal(u'magazine', ['Donation'])
def forwards(self, orm):
# Adding model 'CalloutUserfield'
db.create_table(u'actionkit_userdetail_calloutuserfield', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
))
db.send_create_signal(u'actionkit_userdetail', ['CalloutUserfield'])
def backwards(self, orm):
# Adding model 'Pic'
db.create_table(u'exchange_pic', (
('image', self.gf('django.db.models.fields.files.ImageField')(max_length=100)),
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
))
db.send_create_signal(u'exchange', ['Pic'])
def forwards(self, orm):
# Adding model 'Category'
db.create_table('yadba_category', (
('description', self.gf('django.db.models.fields.TextField')()),
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
))
db.send_create_signal('yadba', ['Category'])
# Adding model 'Entry'
db.create_table('yadba_entry', (
('body', self.gf('django.db.models.fields.TextField')()),
('tags', self.gf('tagging.fields.TagField')(default='')),
('date_updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
('title', self.gf('django.db.models.fields.CharField')(max_length=255)),
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('date_posted', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
))
db.send_create_signal('yadba', ['Entry'])
# Adding M2M table for field categories on 'Entry'
db.create_table('yadba_entry_categories', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('entry', models.ForeignKey(orm['yadba.entry'], null=False)),
('category', models.ForeignKey(orm['yadba.category'], null=False))
))
db.create_unique('yadba_entry_categories', ['entry_id', 'category_id'])
def forwards(self, orm):
# Adding model 'Decision'
db.create_table(
"publicweb_decision",
(
("id", self.gf("django.db.models.fields.AutoField")(primary_key=True)),
("short_name", self.gf("django.db.models.fields.CharField")(max_length=255)),
("decided_date", self.gf("django.db.models.fields.DateField")(null=True, blank=True)),
("effective_date", self.gf("django.db.models.fields.DateField")(null=True, blank=True)),
("review_date", self.gf("django.db.models.fields.DateField")(null=True, blank=True)),
("expiry_date", self.gf("django.db.models.fields.DateField")(null=True, blank=True)),
("budget", self.gf("django.db.models.fields.CharField")(max_length=255, blank=True)),
("people", self.gf("django.db.models.fields.CharField")(max_length=255, blank=True)),
("description", self.gf("tinymce.models.HTMLField")(blank=True)),
),
)
db.send_create_signal("publicweb", ["Decision"])
# Adding model 'Concern'
db.create_table(
"publicweb_concern",
(
("id", self.gf("django.db.models.fields.AutoField")(primary_key=True)),
("short_name", self.gf("django.db.models.fields.CharField")(max_length=255)),
("decision", self.gf("django.db.models.fields.related.ForeignKey")(to=orm["publicweb.Decision"])),
("description", self.gf("tinymce.models.HTMLField")(blank=True)),
("resolved", self.gf("django.db.models.fields.BooleanField")(default=False)),
),
)
db.send_create_signal("publicweb", ["Concern"])
def backwards(self, orm):
# Adding model 'Customer'
db.create_table(u'attendees_customer', (
('conference', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['conference.Conference'], null=True, on_delete=models.PROTECT)),
('is_exported', self.gf('django.db.models.fields.BooleanField')(default=False)),
('email', self.gf('django.db.models.fields.EmailField')(max_length=250)),
('date_added', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)),
('customer_number', self.gf('django.db.models.fields.IntegerField')(blank=True)),
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
))
db.send_create_signal(u'attendees', ['Customer'])
# Adding unique constraint on 'Customer', fields ['customer_number', 'conference']
db.create_unique(u'attendees_customer', ['customer_number', 'conference_id'])
# User chose to not deal with backwards NULL issues for 'Purchase.customer'
raise RuntimeError("Cannot reverse this migration. 'Purchase.customer' and its values cannot be restored.")
# The following code is provided here to aid in writing a correct migration # Adding field 'Purchase.customer'
db.add_column(u'attendees_purchase', 'customer',
self.gf('django.db.models.fields.related.ForeignKey')(to=orm['attendees.Customer']),
keep_default=False)
# Deleting field 'Purchase.email'
db.delete_column(u'attendees_purchase', 'email')
def forwards(self, orm):
# Deleting model 'NodeProductReports'
db.delete_table('ilsgateway_nodeproductreports')
# Adding model 'NodeProductReport'
db.create_table('ilsgateway_nodeproductreport', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('product', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ilsgateway.Product'])),
('node', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ilsgateway.Node'])),
('report_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ilsgateway.ProductReportType'])),
('quantity', self.gf('django.db.models.fields.IntegerField')()),
))
db.send_create_signal('ilsgateway', ['NodeProductReport'])
# Removing M2M table for field child_nodes on 'Node'
db.delete_table('ilsgateway_node_child_nodes')
# Adding M2M table for field child_node on 'Node'
db.create_table('ilsgateway_node_child_node', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('from_node', models.ForeignKey(orm['ilsgateway.node'], null=False)),
('to_node', models.ForeignKey(orm['ilsgateway.node'], null=False))
))
db.create_unique('ilsgateway_node_child_node', ['from_node_id', 'to_node_id'])
def forwards(self, orm):
# Adding model 'DynamicPage'
db.create_table(u'main_dynamicpage', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('slug', self.gf('django.db.models.fields.SlugField')(max_length=50)),
('template', self.gf('django.db.models.fields.CharField')(max_length=256)),
('content_hebrew', self.gf('django.db.models.fields.TextField')()),
('content_english', self.gf('django.db.models.fields.TextField')()),
))
db.send_create_signal(u'main', ['DynamicPage'])
# Deleting field 'NavbarLink.url'
db.delete_column(u'main_navbarlink', 'url')
# Adding field 'NavbarLink.link_type'
db.add_column(u'main_navbarlink', 'link_type',
self.gf('django.db.models.fields.CharField')(default='category', max_length=256),
keep_default=False)
# Adding field 'NavbarLink.category'
db.add_column(u'main_navbarlink', 'category',
self.gf('django.db.models.fields.related.ForeignKey')(to=orm['main.Category'], null=True, blank=True),
keep_default=False)
# Adding field 'NavbarLink.page'
db.add_column(u'main_navbarlink', 'page',
self.gf('django.db.models.fields.related.ForeignKey')(to=orm['main.DynamicPage'], null=True, blank=True),
keep_default=False)
def forwards(self, orm):
# Adding model 'AvailableFund'
db.create_table(u'wanglibao_buy_availablefund', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('declare_status',
self.gf('django.db.models.fields.BooleanField')()),
('fund_code',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('fund_name',
self.gf('django.db.models.fields.CharField')(max_length=100)),
('fund_state',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('fund_type',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('last_update',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('min_shares', self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('purchase_limit_max',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('purchase_limit_min',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('purchase_second_limit_min',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('quick_cash_limit_max',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('quick_cash_limit_min',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('ration_limit_max',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('ration_limit_min',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('redeem_limit_max',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('redeem_limit_min',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('risk_level', self.gf('django.db.models.fields.IntegerField')()),
('share_type',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('subscribe_limit_max',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('subscribe_limit_min',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('subscribe_state',
self.gf('django.db.models.fields.BooleanField')()),
('transform_limit_max',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('transform_limit_min',
self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('valuagr_state',
self.gf('django.db.models.fields.BooleanField')()),
('withdraw_state',
self.gf('django.db.models.fields.BooleanField')()),
('create_date', self.gf('django.db.models.fields.DateField')(
auto_now=True, blank=True)),
))
db.send_create_signal(u'wanglibao_buy', ['AvailableFund'])
# Adding model 'BindBank'
db.create_table(u'wanglibao_buy_bindbank', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'])),
('no',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('balance', self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('bank_name',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('bank_serial',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('bind_way', self.gf('django.db.models.fields.IntegerField')()),
('capital_mode',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('content_describe',
self.gf('django.db.models.fields.CharField')(max_length=500)),
('is_freeze', self.gf('django.db.models.fields.BooleanField')()),
('is_vaild', self.gf('django.db.models.fields.BooleanField')()),
('limit_describe',
self.gf('django.db.models.fields.CharField')(max_length=200)),
('priority',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('status',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('status_to_cn',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('sub_trade_account',
self.gf('django.db.models.fields.CharField')(max_length=1000)),
('support_auto_pay',
self.gf('django.db.models.fields.BooleanField')()),
('trade_account',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('create_date', self.gf('django.db.models.fields.DateField')(
auto_now=True, blank=True)),
))
db.send_create_signal(u'wanglibao_buy', ['BindBank'])
# Adding model 'TradeHistory'
db.create_table(u'wanglibao_buy_tradehistory', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'])),
('amount', self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('apply_date_time',
self.gf('django.db.models.fields.DateTimeField')()),
('apply_serial',
self.gf('django.db.models.fields.CharField')(max_length=50)),
('bank_account',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('bank_name',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('bank_serial',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('business_type',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('business_type_to_cn',
self.gf('django.db.models.fields.CharField')(max_length=100)),
('can_cancel', self.gf('django.db.models.fields.BooleanField')()),
('fund_code',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('fund_name',
self.gf('django.db.models.fields.CharField')(max_length=100)),
('is_cash_buy', self.gf('django.db.models.fields.BooleanField')()),
('pay_result', self.gf('django.db.models.fields.IntegerField')()),
('pay_status_to_cn',
self.gf('django.db.models.fields.CharField')(max_length=50)),
('pound_age', self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('share_type',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('share_type_to_cn',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('shares', self.gf('django.db.models.fields.DecimalField')(
max_digits=20, decimal_places=2)),
('status', self.gf('django.db.models.fields.IntegerField')()),
('status_to_cn',
self.gf('django.db.models.fields.CharField')(max_length=100)),
('trade_account',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('create_date', self.gf('django.db.models.fields.DateField')()),
))
db.send_create_signal(u'wanglibao_buy', ['TradeHistory'])
def forwards(self, orm):
# Adding model 'Recipe'
db.create_table('recipe_recipe', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('title',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('slug', self.gf('django.db.models.fields.SlugField')(
db_index=True, unique=True, max_length=50, blank=True)),
('author', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'])),
('photo', self.gf('django.db.models.fields.files.ImageField')(
max_length=100, blank=True)),
('course', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['recipe_groups.Course'])),
('cuisine', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['recipe_groups.Cuisine'])),
('info', self.gf('django.db.models.fields.TextField')()),
('cook_time', self.gf('django.db.models.fields.IntegerField')()),
('servings', self.gf('django.db.models.fields.IntegerField')()),
('directions', self.gf('django.db.models.fields.TextField')()),
('shared',
self.gf('django.db.models.fields.IntegerField')(default=0)),
('related',
self.gf('django.db.models.fields.related.OneToOneField')(
blank=True,
related_name='RecipeRelated',
unique=True,
null=True,
to=orm['recipe.Recipe'])),
('pub_date', self.gf('django.db.models.fields.DateTimeField')(
auto_now_add=True, blank=True)),
('update_date', self.gf('django.db.models.fields.DateTimeField')(
auto_now=True, blank=True)),
('rating_votes',
self.gf('django.db.models.fields.PositiveIntegerField')(
default=0, blank=True)),
('rating_score', self.gf('django.db.models.fields.IntegerField')(
default=0, blank=True)),
))
db.send_create_signal('recipe', ['Recipe'])
# Adding model 'StoredRecipe'
db.create_table('recipe_storedrecipe', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('recipe', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['recipe.Recipe'])),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'])),
))
db.send_create_signal('recipe', ['StoredRecipe'])
# Adding model 'NoteRecipe'
db.create_table('recipe_noterecipe', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('recipe', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['recipe.Recipe'])),
('author', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'])),
('text', self.gf('django.db.models.fields.TextField')()),
))
db.send_create_signal('recipe', ['NoteRecipe'])
def forwards(self, orm):
# Adding model 'Label'
db.create_table('webview_label', (
('info', models.TextField(blank=True)),
('startswith',
models.CharField(max_length=1, editable=False, db_index=True)),
('pouetid', models.IntegerField(null=True, blank=True)),
('last_updated', models.DateTimeField(null=True, blank=True)),
('name', models.CharField(
unique=True, max_length=40, db_index=True)),
('wiki_link', models.URLField(blank=True)),
('webpage', models.URLField(blank=True)),
('cease_date', models.DateField(null=True, blank=True)),
('created_by',
models.ForeignKey(orm['auth.User'],
related_name="label_createdby",
null=True,
blank=True)),
('status', models.CharField(default='A', max_length=1)),
('found_date', models.DateField(null=True, blank=True)),
('logo',
models.ImageField(null=True, upload_to='media/labels',
blank=True)),
('id', models.AutoField(primary_key=True)),
))
db.send_create_signal('webview', ['Label'])
# Adding field 'Song.zxdemo_id'
db.add_column('webview_song', 'zxdemo_id',
models.IntegerField(default=0, verbose_name="ZXDemo ID"))
# Adding field 'Song.lemon_id'
db.add_column(
'webview_song', 'lemon_id',
models.IntegerField(default=0, verbose_name="Lemon64 ID"))
# Adding field 'Artist.home_location'
db.add_column(
'webview_artist', 'home_location',
models.CharField(max_length=40,
verbose_name="Location",
blank=True))
# Adding field 'Userprofile.fave_id'
db.add_column(
'webview_userprofile', 'fave_id',
models.IntegerField(null=True,
verbose_name="Fave SongID",
blank=True))
# Adding field 'Song.release_date'
db.add_column(
'webview_song', 'release_date',
models.DateTimeField(null=True,
verbose_name="Release Date",
blank=True))
# Adding field 'Userprofile.email_on_artist_comment'
db.add_column(
'webview_userprofile', 'email_on_artist_comment',
models.BooleanField(default=True,
verbose_name="Send email on artist comments"))
# Adding field 'Artist.home_country'
db.add_column(
'webview_artist', 'home_country',
models.CharField(max_length=10,
verbose_name="Country Code",
blank=True))
# Adding field 'Userprofile.location'
db.add_column(
'webview_userprofile', 'location',
models.CharField(max_length=40,
verbose_name="Geographical Location",
blank=True))
# Adding field 'Artist.wiki_link'
db.add_column('webview_artist', 'wiki_link',
models.URLField(blank=True))
# Adding field 'Compilation.wiki_link'
db.add_column('webview_compilation', 'wiki_link',
models.URLField(blank=True))
# Adding field 'Userprofile.email_on_group_add'
db.add_column(
'webview_userprofile', 'email_on_group_add',
models.BooleanField(default=True,
verbose_name="Send email on group approval"))
# Adding ManyToManyField 'Song.labels'
db.create_table(
'webview_song_labels',
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('song', models.ForeignKey(Song, null=False)),
('label', models.ForeignKey(Label, null=False))))
# Adding field 'Userprofile.email_on_artist_add'
db.add_column(
'webview_userprofile', 'email_on_artist_add',
models.BooleanField(default=True,
verbose_name="Send email on artist approval"))
# Adding ManyToManyField 'Artist.labels'
db.create_table(
'webview_artist_labels',
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('artist', models.ForeignKey(Artist, null=False)),
('label', models.ForeignKey(Label, null=False))))
# Adding field 'Group.wiki_link'
db.add_column('webview_group', 'wiki_link',
models.URLField(blank=True))
# Changing field 'Song.remix_of_id'
db.alter_column(
'webview_song', 'remix_of_id',
models.IntegerField(null=True,
verbose_name="Mix SongID",
blank=True))
# Changing field 'Artist.last_fm_id'
db.alter_column(
'webview_artist', 'last_fm_id',
models.CharField(max_length=32,
verbose_name="Last.fm ID",
blank=True))
def forwards(self, orm):
# Adding model 'Location'
db.create_table('signin_location', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=100)),
))
db.send_create_signal('signin', ['Location'])
# Adding model 'Clinic'
db.create_table('signin_clinic', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=100)),
('location', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['signin.Location'])),
('work_time', self.gf('django.db.models.fields.CharField')(
default='morning', max_length=32)),
))
db.send_create_signal('signin', ['Clinic'])
# Adding model 'Event'
db.create_table('signin_event', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=100)),
))
db.send_create_signal('signin', ['Event'])
# Adding model 'Patient'
db.create_table('signin_patient', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('fName',
self.gf('django.db.models.fields.CharField')(max_length=100)),
('lName',
self.gf('django.db.models.fields.CharField')(max_length=100)),
('dob', self.gf('django.db.models.fields.DateField')()),
))
db.send_create_signal('signin', ['Patient'])
# Adding model 'Provider'
db.create_table('signin_provider', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('fName',
self.gf('django.db.models.fields.CharField')(max_length=100)),
('lName',
self.gf('django.db.models.fields.CharField')(max_length=100)),
))
db.send_create_signal('signin', ['Provider'])
# Adding model 'EventSetHeader'
db.create_table('signin_eventsetheader', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('patient', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['signin.Patient'])),
('clinic', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['signin.Clinic'])),
('provider', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['signin.Provider'], null=True, blank=True)),
('dateTime', self.gf('django.db.models.fields.DateTimeField')(
auto_now_add=True, blank=True)),
))
db.send_create_signal('signin', ['EventSetHeader'])
# Adding model 'PatientEventLog'
db.create_table('signin_patienteventlog', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('event', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['signin.Event'])),
('header', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['signin.EventSetHeader'])),
('dateTime', self.gf('django.db.models.fields.DateTimeField')(
auto_now_add=True, blank=True)),
('user', self.gf('django.db.models.fields.CharField')(
max_length=100, blank=True)),
))
db.send_create_signal('signin', ['PatientEventLog'])
# Adding model 'Payment'
db.create_table('signin_payment', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('header', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['signin.EventSetHeader'])),
('type',
self.gf('django.db.models.fields.CharField')(max_length=16)),
('info', self.gf('django.db.models.fields.CharField')(
max_length=32, blank=True)),
('amount', self.gf('django.db.models.fields.DecimalField')(
max_digits=8, decimal_places=2)),
('dateTime', self.gf('django.db.models.fields.DateTimeField')(
auto_now_add=True, blank=True)),
))
db.send_create_signal('signin', ['Payment'])
def forwards(self, orm):
# Adding model 'Event'
db.create_table('conference_event', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('domain',
self.gf('django.db.models.fields.URLField')(max_length=200)),
('default',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('title',
self.gf('django.db.models.fields.CharField')(max_length=256)),
('description', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('date', self.gf('django.db.models.fields.DateField')()),
('city',
self.gf('django.db.models.fields.CharField')(max_length=64)),
('place',
self.gf('django.db.models.fields.CharField')(max_length=64)),
('address', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('coordinates',
self.gf('django.db.models.fields.CharField')(max_length=24)),
('place_note', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
))
db.send_create_signal('conference', ['Event'])
# Adding field 'ParticipantFuture.event'
db.add_column('conference_participantfuture',
'event',
self.gf('django.db.models.fields.related.ForeignKey')(
default=1, to=orm['conference.Event']),
keep_default=False)
# Adding field 'ScheduleSection.event'
db.add_column('conference_schedulesection',
'event',
self.gf('django.db.models.fields.related.ForeignKey')(
default=1, to=orm['conference.Event']),
keep_default=False)
# Adding field 'Participant.event'
db.add_column('conference_participant',
'event',
self.gf('django.db.models.fields.related.ForeignKey')(
default=1, to=orm['conference.Event']),
keep_default=False)
# Adding field 'Partner.event'
db.add_column('conference_partner',
'event',
self.gf('django.db.models.fields.related.ForeignKey')(
default=1, to=orm['conference.Event']),
keep_default=False)
# Adding field 'Lecture.event'
db.add_column('conference_lecture',
'event',
self.gf('django.db.models.fields.related.ForeignKey')(
default=1, to=orm['conference.Event']),
keep_default=False)
def backwards(self, orm):
# Adding model 'Person'
db.create_table('events_person', (
('created_time', self.gf('django.db.models.fields.DateTimeField')(
null=True, blank=True)),
('created_by',
self.gf('django.db.models.fields.related.ForeignKey')(
related_name='events_person_created_by',
to=orm['auth.User'],
null=True,
blank=True)),
('description_sv', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('editor', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='person_editors',
to=orm['events.Person'],
null=True,
blank=True)),
('data_source',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['events.DataSource'], null=True, blank=True)),
('description',
self.gf('django.db.models.fields.TextField')(blank=True)),
('description_en', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('name_fi', self.gf('django.db.models.fields.CharField')(
max_length=255, null=True, blank=True, db_index=True)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'], null=True, blank=True)),
('modified_by',
self.gf('django.db.models.fields.related.ForeignKey')(
related_name='events_person_modified_by',
to=orm['auth.User'],
null=True,
blank=True)),
('member_of',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['events.Organization'], null=True, blank=True)),
('last_modified_time',
self.gf('django.db.models.fields.DateTimeField')(null=True,
blank=True)),
('description_fi', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('name', self.gf('django.db.models.fields.CharField')(
max_length=255, db_index=True)),
('name_sv', self.gf('django.db.models.fields.CharField')(
max_length=255, null=True, blank=True, db_index=True)),
('image', self.gf('django.db.models.fields.URLField')(
max_length=200, null=True, blank=True)),
('origin_id', self.gf('django.db.models.fields.CharField')(
max_length=255, null=True, blank=True, db_index=True)),
('creator', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='person_creators',
to=orm['events.Person'],
null=True,
blank=True)),
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name_en', self.gf('django.db.models.fields.CharField')(
max_length=255, null=True, blank=True, db_index=True)),
('email', self.gf('django.db.models.fields.EmailField')(
max_length=75, null=True, blank=True)),
('family_name', self.gf('django.db.models.fields.CharField')(
max_length=255, null=True, blank=True)),
))
db.send_create_signal('events', ['Person'])
# Adding model 'Organization'
db.create_table('events_organization', (
('name', self.gf('django.db.models.fields.CharField')(
max_length=255, db_index=True)),
('created_by',
self.gf('django.db.models.fields.related.ForeignKey')(
related_name='events_organization_created_by',
to=orm['auth.User'],
null=True,
blank=True)),
('compact_IRI_name', self.gf('django.db.models.fields.CharField')(
max_length=200, null=True, blank=True)),
('editor', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='organization_editors',
to=orm['events.Person'],
null=True,
blank=True)),
('data_source',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['events.DataSource'], null=True, blank=True)),
('description',
self.gf('django.db.models.fields.TextField')(blank=True)),
('image', self.gf('django.db.models.fields.URLField')(
max_length=200, null=True, blank=True)),
('modified_by',
self.gf('django.db.models.fields.related.ForeignKey')(
related_name='events_organization_modified_by',
to=orm['auth.User'],
null=True,
blank=True)),
('origin_id', self.gf('django.db.models.fields.CharField')(
max_length=255, null=True, blank=True, db_index=True)),
('base_IRI', self.gf('django.db.models.fields.CharField')(
max_length=200, null=True, blank=True)),
('creator', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='organization_creators',
to=orm['events.Person'],
null=True,
blank=True)),
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('created_time', self.gf('django.db.models.fields.DateTimeField')(
null=True, blank=True)),
('last_modified_time',
self.gf('django.db.models.fields.DateTimeField')(null=True,
blank=True)),
))
db.send_create_signal('events', ['Organization'])
# Adding field 'Event.provider'
db.add_column('events_event',
'provider',
self.gf('django.db.models.fields.related.ForeignKey')(
related_name='event_providers',
to=orm['events.Organization'],
null=True,
blank=True),
keep_default=False)
# Adding M2M table for field category on 'Event'
m2m_table_name = db.shorten_name('events_event_category')
db.create_table(
m2m_table_name,
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('event', models.ForeignKey(orm['events.event'], null=False)),
('category', models.ForeignKey(orm['events.category'],
null=False))))
db.create_unique(m2m_table_name, ['event_id', 'category_id'])
# Removing M2M table for field categories on 'Event'
db.delete_table(db.shorten_name('events_event_categories'))
def forwards(self, orm):
# Adding model 'CourseColor'
db.create_table(u'myuw_mobile_coursecolor', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('regid', self.gf('django.db.models.fields.CharField')(
max_length=32, db_index=True)),
('year',
self.gf('django.db.models.fields.PositiveSmallIntegerField')(
db_index=True)),
('quarter', self.gf('django.db.models.fields.CharField')(
max_length=10, db_index=True)),
('curriculum_abbr',
self.gf('django.db.models.fields.CharField')(max_length=10)),
('course_number',
self.gf('django.db.models.fields.CharField')(max_length=3)),
('section_id',
self.gf('django.db.models.fields.CharField')(max_length=2)),
('is_active', self.gf('django.db.models.fields.BooleanField')()),
('color_id',
self.gf('django.db.models.fields.PositiveIntegerField')()),
))
db.send_create_signal(u'myuw', ['CourseColor'])
# Adding model 'User'
db.create_table(u'myuw_mobile_user', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('uwnetid', self.gf('django.db.models.fields.SlugField')(
unique=True, max_length=16)),
('uwregid', self.gf('django.db.models.fields.CharField')(
max_length=32, unique=True, null=True, db_index=True)),
('last_visit', self.gf('django.db.models.fields.DateTimeField')(
default=datetime.datetime(2014, 9, 12, 0, 0))),
))
db.send_create_signal(u'myuw', ['User'])
# Adding model 'Building'
db.create_table(u'myuw_mobile_building', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('code', self.gf('django.db.models.fields.CharField')(
max_length=6, db_index=True)),
('latititude',
self.gf('django.db.models.fields.CharField')(max_length=40)),
('longitude',
self.gf('django.db.models.fields.CharField')(max_length=40)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=200)),
))
db.send_create_signal(u'myuw', ['Building'])
# Adding model 'StudentAccountsBalances'
db.create_table(u'myuw_mobile_studentaccountsbalances', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('student_number', self.gf('django.db.models.fields.CharField')(
unique=True, max_length=10, db_index=True)),
('employee_id', self.gf('django.db.models.fields.CharField')(
db_index=True, max_length=10, null=True, blank=True)),
('asof_datetime',
self.gf('django.db.models.fields.DateTimeField')()),
('is_am',
self.gf('django.db.models.fields.BooleanField')(default=True)),
('husky_card', self.gf('django.db.models.fields.DecimalField')(
default=0.0, max_digits=6, decimal_places=2)),
('residence_hall_dining',
self.gf('django.db.models.fields.DecimalField')(
null=True, max_digits=7, decimal_places=2, blank=True)),
))
db.send_create_signal(u'myuw', ['StudentAccountsBalances'])
# Adding model 'UserNotices'
db.create_table(u'myuw_mobile_usernotices', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('notice_hash',
self.gf('django.db.models.fields.CharField')(max_length=32)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['myuw.User'], on_delete=models.PROTECT)),
('first_viewed', self.gf('django.db.models.fields.DateTimeField')(
auto_now_add=True, blank=True)),
('marked_read',
self.gf('django.db.models.fields.DateTimeField')(null=True)),
('is_read',
self.gf('django.db.models.fields.BooleanField')(default=False)),
))
db.send_create_signal(u'myuw', ['UserNotices'])
# Adding model 'CategoryLinks'
db.create_table(u'myuw_mobile_categorylinks', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('url',
self.gf('django.db.models.fields.CharField')(max_length=150)),
('title',
self.gf('django.db.models.fields.CharField')(max_length=150)),
('campus', self.gf('django.db.models.fields.CharField')(
max_length=8, null=True)),
('category_id',
self.gf('django.db.models.fields.CharField')(max_length=80)),
('category_name',
self.gf('django.db.models.fields.CharField')(max_length=80)),
('sub_category',
self.gf('django.db.models.fields.CharField')(max_length=80)),
))
db.send_create_signal(u'myuw', ['CategoryLinks'])
# Adding model 'TuitionDate'
db.create_table(u'myuw_mobile_tuitiondate', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['myuw.User'], unique=True, on_delete=models.PROTECT)),
('date_stored', self.gf('django.db.models.fields.DateTimeField')(
auto_now=True, blank=True)),
('date', self.gf('django.db.models.fields.DateField')()),
))
db.send_create_signal(u'myuw', ['TuitionDate'])
def forwards(self, orm):
# Adding model 'Group'
db.create_table('community_group', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('longname',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('default_theme',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.Theme'], null=True, blank=True)),
('parent', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.Group'], null=True, blank=True)),
('baseurl',
self.gf('django.db.models.fields.CharField')(max_length=250)),
))
db.send_create_signal('community', ['Group'])
# Adding model 'GroupMember'
db.create_table('community_groupmember', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('group', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.Group'])),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'])),
('userlevel', self.gf('django.db.models.fields.IntegerField')()),
))
db.send_create_signal('community', ['GroupMember'])
# Adding model 'Theme'
db.create_table('community_theme', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('path',
self.gf('django.db.models.fields.CharField')(max_length=250)),
))
db.send_create_signal('community', ['Theme'])
# Adding model 'Navigation'
db.create_table('community_navigation', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('group', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.Group'])),
('label',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('href',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('urltype',
self.gf('django.db.models.fields.IntegerField')(default=0)),
('sortorder',
self.gf('django.db.models.fields.IntegerField')(default=100)),
('navigationType',
self.gf('django.db.models.fields.IntegerField')(default=0)),
))
db.send_create_signal('community', ['Navigation'])
# Adding model 'ApplicationChangelog'
db.create_table('community_applicationchangelog', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('app_label',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('model',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('version',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('applied', self.gf('django.db.models.fields.DateTimeField')()),
))
db.send_create_signal('community', ['ApplicationChangelog'])
# Adding model 'CommunityUserProfile'
db.create_table('community_communityuserprofile', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'], unique=True)),
('displayname',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('public_emailaddress',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('avatar', self.gf('django.db.models.fields.files.ImageField')(
max_length=100, null=True, blank=True)),
('avatar_height', self.gf('django.db.models.fields.IntegerField')(
null=True, blank=True)),
('avatar_width', self.gf('django.db.models.fields.IntegerField')(
null=True, blank=True)),
))
db.send_create_signal('community', ['CommunityUserProfile'])
# Adding model 'CommunityUserProfileField'
db.create_table('community_communityuserprofilefield', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('help_text', self.gf('django.db.models.fields.CharField')(
max_length=250, blank=True)),
('regex', self.gf('django.db.models.fields.CharField')(
max_length=250, blank=True)),
('renderstring', self.gf('django.db.models.fields.CharField')(
max_length=250, blank=True)),
('sortorder', self.gf('django.db.models.fields.IntegerField')()),
))
db.send_create_signal('community', ['CommunityUserProfileField'])
# Adding model 'CommunityUserProfileFieldValue'
db.create_table('community_communityuserprofilefieldvalue', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user_profile',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.CommunityUserProfile'])),
('profile_field',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.CommunityUserProfileField'])),
('value',
self.gf('django.db.models.fields.CharField')(max_length=250)),
))
db.send_create_signal('community', ['CommunityUserProfileFieldValue'])
# Adding unique constraint on 'CommunityUserProfileFieldValue', fields ['user_profile', 'profile_field']
db.create_unique('community_communityuserprofilefieldvalue',
['user_profile_id', 'profile_field_id'])
# Adding model 'GroupTemplate'
db.create_table('community_grouptemplate', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('group', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.Group'])),
('template_name', self.gf('django.db.models.fields.CharField')(
max_length=250, db_index=True)),
('source', self.gf('django.db.models.fields.TextField')()),
))
db.send_create_signal('community', ['GroupTemplate'])
# Adding unique constraint on 'GroupTemplate', fields ['group', 'template_name']
db.create_unique('community_grouptemplate',
['group_id', 'template_name'])
# Adding model 'PermissionFlag'
db.create_table('community_permissionflag', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(
unique=True, max_length=250)),
))
db.send_create_signal('community', ['PermissionFlag'])
# Adding model 'Role'
db.create_table('community_role', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=250)),
('group', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.Group'])),
))
db.send_create_signal('community', ['Role'])
# Adding unique constraint on 'Role', fields ['name', 'group']
db.create_unique('community_role', ['name', 'group_id'])
# Adding M2M table for field permission_flags on 'Role'
db.create_table(
'community_role_permission_flags',
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('role', models.ForeignKey(orm['community.role'], null=False)),
('permissionflag',
models.ForeignKey(orm['community.permissionflag'], null=False))))
db.create_unique('community_role_permission_flags',
['role_id', 'permissionflag_id'])
# Adding model 'RoleMember'
db.create_table('community_rolemember', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('role', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.Role'])),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'], null=True)),
('rolegroup',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.RoleGroup'], null=True)),
('has_limitations',
self.gf('django.db.models.fields.BooleanField')(default=False)),
))
db.send_create_signal('community', ['RoleMember'])
# Adding model 'RoleMemberLimitation'
db.create_table('community_rolememberlimitation', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('role_member',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.RoleMember'])),
('object_type',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['contenttypes.ContentType'])),
('object_id',
self.gf('django.db.models.fields.PositiveIntegerField')(
db_index=True)),
))
db.send_create_signal('community', ['RoleMemberLimitation'])
# Adding unique constraint on 'RoleMemberLimitation', fields ['role_member', 'object_type', 'object_id']
db.create_unique('community_rolememberlimitation',
['role_member_id', 'object_type_id', 'object_id'])
# Adding model 'RoleGroup'
db.create_table('community_rolegroup', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('group', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.Group'])),
('name',
self.gf('django.db.models.fields.CharField')(max_length=250)),
))
db.send_create_signal('community', ['RoleGroup'])
# Adding unique constraint on 'RoleGroup', fields ['group', 'name']
db.create_unique('community_rolegroup', ['group_id', 'name'])
# Adding model 'RoleGroupMember'
db.create_table('community_rolegroupmember', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('rolegroup',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.RoleGroup'])),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'])),
))
db.send_create_signal('community', ['RoleGroupMember'])
# Adding unique constraint on 'RoleGroupMember', fields ['rolegroup', 'user']
db.create_unique('community_rolegroupmember',
['rolegroup_id', 'user_id'])
# Adding model 'Tag'
db.create_table('community_tag', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('group', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['community.Group'])),
('name',
self.gf('django.db.models.fields.CharField')(max_length=250)),
))
db.send_create_signal('community', ['Tag'])
# Adding unique constraint on 'Tag', fields ['group', 'name']
db.create_unique('community_tag', ['group_id', 'name'])
# Adding model 'TagLabel'
db.create_table('community_taglabel', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('tag', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='labels', to=orm['community.Tag'])),
('label',
self.gf('django.db.models.fields.CharField')(max_length=250)),
))
db.send_create_signal('community', ['TagLabel'])
# Adding unique constraint on 'TagLabel', fields ['tag', 'label']
db.create_unique('community_taglabel', ['tag_id', 'label'])
# Adding model 'TaggedItem'
db.create_table('community_taggeditem', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('tag_label',
self.gf('django.db.models.fields.related.ForeignKey')(
related_name='items', to=orm['community.TagLabel'])),
('content_type',
self.gf('django.db.models.fields.related.ForeignKey')(
related_name='sph_taggeditem_set',
to=orm['contenttypes.ContentType'])),
('object_id',
self.gf('django.db.models.fields.PositiveIntegerField')(
db_index=True)),
))
db.send_create_signal('community', ['TaggedItem'])
# Adding unique constraint on 'TaggedItem', fields ['tag_label', 'content_type', 'object_id']
db.create_unique('community_taggeditem',
['tag_label_id', 'content_type_id', 'object_id'])
def forwards(self, orm):
# Adding model 'IdPOptionsSPPolicy'
db.create_table('saml_idpoptionssppolicy', (
('http_method_for_slo_request',
self.gf('django.db.models.fields.IntegerField')(default=4,
max_length=60)),
('enable_http_method_for_defederation_request',
self.gf('django.db.models.fields.BooleanField')(default=False,
blank=True)),
('name', self.gf('django.db.models.fields.CharField')(
unique=True, max_length=80)),
('http_method_for_defederation_request',
self.gf('django.db.models.fields.IntegerField')(default=5,
max_length=60)),
('binding_for_sso_response',
self.gf('django.db.models.fields.CharField')(
default='urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Artifact',
max_length=60)),
('enabled', self.gf('django.db.models.fields.BooleanField')(
default=False, blank=True)),
('allow_create', self.gf('django.db.models.fields.BooleanField')(
default=False, blank=True)),
('want_authn_request_signed',
self.gf('django.db.models.fields.BooleanField')(default=False,
blank=True)),
('enable_http_method_for_slo_request',
self.gf('django.db.models.fields.BooleanField')(default=False,
blank=True)),
('requested_name_id_format',
self.gf('django.db.models.fields.CharField')(default='none',
max_length=20)),
('user_consent', self.gf('django.db.models.fields.CharField')(
default='urn:oasis:names:tc:SAML:2.0:consent:current-implicit',
max_length=60)),
('no_nameid_policy',
self.gf('django.db.models.fields.BooleanField')(default=False,
blank=True)),
('transient_is_persistent',
self.gf('django.db.models.fields.BooleanField')(default=False,
blank=True)),
('want_is_passive_authn_request',
self.gf('django.db.models.fields.BooleanField')(default=False,
blank=True)),
('enable_binding_for_sso_response',
self.gf('django.db.models.fields.BooleanField')(default=False,
blank=True)),
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('want_force_authn_request',
self.gf('django.db.models.fields.BooleanField')(default=False,
blank=True)),
))
db.send_create_signal('saml', ['IdPOptionsSPPolicy'])
# Adding model 'AuthorizationAttributeMapping'
db.create_table('saml_authorizationattributemapping', (
('map', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['saml.AuthorizationAttributeMap'])),
('attribute_name',
self.gf('django.db.models.fields.CharField')(max_length=40)),
('source_attribute_name',
self.gf('django.db.models.fields.CharField')(max_length=40)),
('attribute_value_format',
self.gf('django.db.models.fields.CharField')(max_length=40)),
('attribute_value',
self.gf('django.db.models.fields.CharField')(max_length=40)),
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
))
db.send_create_signal('saml', ['AuthorizationAttributeMapping'])
# Adding model 'AuthorizationSPPolicy'
db.create_table('saml_authorizationsppolicy', (
('ext_function', self.gf('django.db.models.fields.CharField')(
max_length=80, blank=True)),
('enabled', self.gf('django.db.models.fields.BooleanField')(
default=False, blank=True)),
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('attribute_map',
self.gf('django.db.models.fields.related.ForeignKey')(
blank=True,
related_name='authorization_attributes',
null=True,
to=orm['saml.AuthorizationAttributeMap'])),
('name', self.gf('django.db.models.fields.CharField')(
unique=True, max_length=80)),
))
db.send_create_signal('saml', ['AuthorizationSPPolicy'])
# Adding model 'AuthorizationAttributeMap'
db.create_table('saml_authorizationattributemap', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(
unique=True, max_length=40)),
))
db.send_create_signal('saml', ['AuthorizationAttributeMap'])
# Changing field 'LibertyServiceProvider.ask_user_consent'
db.alter_column(
'saml_libertyserviceprovider', 'ask_user_consent',
self.gf('django.db.models.fields.BooleanField')(blank=True))
# Changing field 'LibertyServiceProvider.encrypt_nameid'
db.alter_column(
'saml_libertyserviceprovider', 'encrypt_nameid',
self.gf('django.db.models.fields.BooleanField')(blank=True))
# Changing field 'LibertyServiceProvider.enabled'
db.alter_column(
'saml_libertyserviceprovider', 'enabled',
self.gf('django.db.models.fields.BooleanField')(blank=True))
# Changing field 'LibertyServiceProvider.authn_request_signed'
db.alter_column(
'saml_libertyserviceprovider', 'authn_request_signed',
self.gf('django.db.models.fields.BooleanField')(blank=True))
# Changing field 'LibertyServiceProvider.idp_initiated_sso'
db.alter_column(
'saml_libertyserviceprovider', 'idp_initiated_sso',
self.gf('django.db.models.fields.BooleanField')(blank=True))
# Changing field 'LibertyServiceProvider.encrypt_assertion'
db.alter_column(
'saml_libertyserviceprovider', 'encrypt_assertion',
self.gf('django.db.models.fields.BooleanField')(blank=True))
# Deleting field 'LibertyIdentityProvider.enable_http_method_for_defederation_request'
db.delete_column('saml_libertyidentityprovider',
'enable_http_method_for_defederation_request')
# Deleting field 'LibertyIdentityProvider.want_force_authn_request'
db.delete_column('saml_libertyidentityprovider',
'want_force_authn_request')
# Deleting field 'LibertyIdentityProvider.http_method_for_defederation_request'
db.delete_column('saml_libertyidentityprovider',
'http_method_for_defederation_request')
# Deleting field 'LibertyIdentityProvider.binding_for_sso_response'
db.delete_column('saml_libertyidentityprovider',
'binding_for_sso_response')
# Deleting field 'LibertyIdentityProvider.allow_create'
db.delete_column('saml_libertyidentityprovider', 'allow_create')
# Deleting field 'LibertyIdentityProvider.enable_http_method_for_slo_request'
db.delete_column('saml_libertyidentityprovider',
'enable_http_method_for_slo_request')
# Deleting field 'LibertyIdentityProvider.requested_name_id_format'
db.delete_column('saml_libertyidentityprovider',
'requested_name_id_format')
# Deleting field 'LibertyIdentityProvider.attribute_map'
db.delete_column('saml_libertyidentityprovider', 'attribute_map_id')
# Deleting field 'LibertyIdentityProvider.user_consent'
db.delete_column('saml_libertyidentityprovider', 'user_consent')
# Deleting field 'LibertyIdentityProvider.no_nameid_policy'
db.delete_column('saml_libertyidentityprovider', 'no_nameid_policy')
# Deleting field 'LibertyIdentityProvider.http_method_for_slo_request'
db.delete_column('saml_libertyidentityprovider',
'http_method_for_slo_request')
# Deleting field 'LibertyIdentityProvider.want_authn_request_signed'
db.delete_column('saml_libertyidentityprovider',
'want_authn_request_signed')
# Deleting field 'LibertyIdentityProvider.want_is_passive_authn_request'
db.delete_column('saml_libertyidentityprovider',
'want_is_passive_authn_request')
# Deleting field 'LibertyIdentityProvider.enable_binding_for_sso_response'
db.delete_column('saml_libertyidentityprovider',
'enable_binding_for_sso_response')
# Deleting field 'LibertyIdentityProvider.enable_following_policy'
db.delete_column('saml_libertyidentityprovider',
'enable_following_policy')
# Adding field 'LibertyIdentityProvider.idp_options_policy'
db.add_column('saml_libertyidentityprovider',
'idp_options_policy',
self.gf('django.db.models.fields.related.ForeignKey')(
blank=True,
related_name='idp_options_policy',
null=True,
to=orm['saml.IdPOptionsSPPolicy']),
keep_default=False)
# Adding field 'LibertyIdentityProvider.enable_following_idp_options_policy'
db.add_column('saml_libertyidentityprovider',
'enable_following_idp_options_policy',
self.gf('django.db.models.fields.BooleanField')(
default=False, blank=True),
keep_default=False)
# Adding field 'LibertyIdentityProvider.enable_following_authorization_policy'
db.add_column('saml_libertyidentityprovider',
'enable_following_authorization_policy',
self.gf('django.db.models.fields.BooleanField')(
default=False, blank=True),
keep_default=False)
# Adding field 'LibertyIdentityProvider.authorization_policy'
db.add_column('saml_libertyidentityprovider',
'authorization_policy',
self.gf('django.db.models.fields.related.ForeignKey')(
blank=True,
related_name='authorization_policy',
null=True,
to=orm['saml.AuthorizationSPPolicy']),
keep_default=False)
# Changing field 'LibertyIdentityProvider.enabled'
db.alter_column(
'saml_libertyidentityprovider', 'enabled',
self.gf('django.db.models.fields.BooleanField')(blank=True))
def forwards(self, orm):
# Adding model 'ReportStrategy'
db.create_table(u'report_reportstrategy', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('bid', self.gf('django.db.models.fields.BigIntegerField')(
default=0, db_index=True)),
('bid_value', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('winbid', self.gf('django.db.models.fields.BigIntegerField')(
default=0, db_index=True)),
('winbid_value', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('imp', self.gf('django.db.models.fields.BigIntegerField')(
default=0, db_index=True)),
('clk', self.gf('django.db.models.fields.PositiveIntegerField')(
default=0, db_index=True)),
('conv', self.gf('django.db.models.fields.PositiveIntegerField')(
default=0, db_index=True)),
('conv_value', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('ecpm', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('ctr', self.gf('django.db.models.fields.FloatField')(
default=0, db_index=True)),
('ecpc', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('conv_rate', self.gf('django.db.models.fields.FloatField')(
default=0, db_index=True)),
('ecpa', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('net_earned', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('roi', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('won_bid_ratio', self.gf('django.db.models.fields.FloatField')(
default=0, db_index=True)),
('avg_bid', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('avg_winbid', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('bids_lost', self.gf('django.db.models.fields.BigIntegerField')(
default=0, db_index=True)),
('related',
self.gf('django.db.models.fields.related.OneToOneField')(
to=orm['campaign.Strategy'],
to_field='id_random',
unique=True)),
))
db.send_create_signal(u'report', ['ReportStrategy'])
# Adding model 'ReportAdvert'
db.create_table(u'report_reportadvert', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('bid', self.gf('django.db.models.fields.BigIntegerField')(
default=0, db_index=True)),
('bid_value', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('winbid', self.gf('django.db.models.fields.BigIntegerField')(
default=0, db_index=True)),
('winbid_value', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('imp', self.gf('django.db.models.fields.BigIntegerField')(
default=0, db_index=True)),
('clk', self.gf('django.db.models.fields.PositiveIntegerField')(
default=0, db_index=True)),
('conv', self.gf('django.db.models.fields.PositiveIntegerField')(
default=0, db_index=True)),
('conv_value', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('ecpm', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('ctr', self.gf('django.db.models.fields.FloatField')(
default=0, db_index=True)),
('ecpc', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('conv_rate', self.gf('django.db.models.fields.FloatField')(
default=0, db_index=True)),
('ecpa', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('net_earned', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('roi', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('won_bid_ratio', self.gf('django.db.models.fields.FloatField')(
default=0, db_index=True)),
('avg_bid', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('avg_winbid', self.gf('ui.fields.BudgetSpentDecimalField')(
default=0, db_index=True)),
('bids_lost', self.gf('django.db.models.fields.BigIntegerField')(
default=0, db_index=True)),
('related',
self.gf('django.db.models.fields.related.OneToOneField')(
to=orm['campaign.Advert'], to_field='id_random',
unique=True)),
))
db.send_create_signal(u'report', ['ReportAdvert'])
def forwards(self, orm):
# Adding model 'Service'
db.create_table('main_service', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=256)),
('pagerduty_key', self.gf('django.db.models.fields.CharField')(
max_length=128, null=True, blank=True)),
('email_contact', self.gf('django.db.models.fields.EmailField')(
max_length=75, null=True, blank=True)),
('silenced',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('frequency', self.gf('django.db.models.fields.CharField')(
default='*/5 * * * *', max_length=128)),
('failures_before_alert',
self.gf('django.db.models.fields.IntegerField')(default=1)),
('umpire_range',
self.gf('django.db.models.fields.IntegerField')(default=300)),
('alert_type', self.gf('django.db.models.fields.CharField')(
default='none', max_length=64)),
))
db.send_create_signal('main', ['Service'])
# Adding model 'SimpleServiceCheck'
db.create_table('main_simpleservicecheck', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=256)),
('description', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('service', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='simpleservicecheck', to=orm['main.Service'])),
('silenced',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('alert_type', self.gf('django.db.models.fields.CharField')(
max_length=64, null=True, blank=True)),
('frequency', self.gf('django.db.models.fields.CharField')(
max_length=128, null=True, blank=True)),
('failures_before_alert',
self.gf('django.db.models.fields.IntegerField')(null=True,
blank=True)),
('endpoint',
self.gf('django.db.models.fields.URLField')(max_length=256)),
('timeout', self.gf('django.db.models.fields.IntegerField')(
null=True, blank=True)),
))
db.send_create_signal('main', ['SimpleServiceCheck'])
# Adding model 'CompareServiceCheck'
db.create_table('main_compareservicecheck', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=256)),
('description', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('service', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='compareservicecheck', to=orm['main.Service'])),
('silenced',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('alert_type', self.gf('django.db.models.fields.CharField')(
max_length=64, null=True, blank=True)),
('frequency', self.gf('django.db.models.fields.CharField')(
max_length=128, null=True, blank=True)),
('failures_before_alert',
self.gf('django.db.models.fields.IntegerField')(null=True,
blank=True)),
('endpoint',
self.gf('django.db.models.fields.URLField')(max_length=256)),
('serialization', self.gf('django.db.models.fields.CharField')(
default='json', max_length=128)),
('field',
self.gf('django.db.models.fields.CharField')(max_length=256)),
('comparator', self.gf('django.db.models.fields.CharField')(
default='==', max_length=128)),
('compared_value',
self.gf('django.db.models.fields.CharField')(max_length=512)),
))
db.send_create_signal('main', ['CompareServiceCheck'])
# Adding model 'SensuServiceCheck'
db.create_table('main_sensuservicecheck', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=256)),
('description', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('service', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='sensuservicecheck', to=orm['main.Service'])),
('silenced',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('alert_type', self.gf('django.db.models.fields.CharField')(
max_length=64, null=True, blank=True)),
('frequency', self.gf('django.db.models.fields.CharField')(
max_length=128, null=True, blank=True)),
('failures_before_alert',
self.gf('django.db.models.fields.IntegerField')(null=True,
blank=True)),
('sensu_check_name',
self.gf('django.db.models.fields.CharField')(max_length=256)),
))
db.send_create_signal('main', ['SensuServiceCheck'])
# Adding model 'CodeServiceCheck'
db.create_table('main_codeservicecheck', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=256)),
('description', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('service', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='codeservicecheck', to=orm['main.Service'])),
('silenced',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('alert_type', self.gf('django.db.models.fields.CharField')(
max_length=64, null=True, blank=True)),
('frequency', self.gf('django.db.models.fields.CharField')(
max_length=128, null=True, blank=True)),
('failures_before_alert',
self.gf('django.db.models.fields.IntegerField')(null=True,
blank=True)),
('code_file', self.gf('django.db.models.fields.files.FileField')(
max_length=100)),
))
db.send_create_signal('main', ['CodeServiceCheck'])
# Adding model 'UmpireServiceCheck'
db.create_table('main_umpireservicecheck', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=256)),
('description', self.gf('django.db.models.fields.TextField')(
null=True, blank=True)),
('service', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='umpireservicecheck', to=orm['main.Service'])),
('silenced',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('alert_type', self.gf('django.db.models.fields.CharField')(
max_length=64, null=True, blank=True)),
('frequency', self.gf('django.db.models.fields.CharField')(
max_length=128, null=True, blank=True)),
('failures_before_alert',
self.gf('django.db.models.fields.IntegerField')(null=True,
blank=True)),
('umpire_metric',
self.gf('django.db.models.fields.CharField')(max_length=256)),
('umpire_min',
self.gf('django.db.models.fields.FloatField')(default=0)),
('umpire_max',
self.gf('django.db.models.fields.FloatField')(default=0)),
('umpire_range', self.gf('django.db.models.fields.IntegerField')(
null=True, blank=True)),
('umpire_check_type', self.gf('django.db.models.fields.CharField')(
default='static', max_length=64)),
('umpire_range_type', self.gf('django.db.models.fields.CharField')(
default='current', max_length=64)),
('umpire_percent_error',
self.gf('django.db.models.fields.FloatField')(default=0.25)),
))
db.send_create_signal('main', ['UmpireServiceCheck'])
def forwards(self, orm):
# Adding model 'Profile'
db.create_table(u'app_profile', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.OneToOneField')(
to=orm['auth.User'], unique=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=200)),
))
db.send_create_signal(u'app', ['Profile'])
# Adding model 'ExternalTeacher'
db.create_table(u'app_externalteacher', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('ist_id',
self.gf('django.db.models.fields.CharField')(max_length=20)),
('is_closed',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('close_date',
self.gf('django.db.models.fields.DateTimeField')(null=True)),
('professional_category',
self.gf('django.db.models.fields.CharField')(max_length=1)),
('hours_per_week', self.gf('django.db.models.fields.DecimalField')(
max_digits=5, decimal_places=2)),
('park',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('card',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('department',
self.gf('django.db.models.fields.CharField')(max_length=200)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=200)),
('degree',
self.gf('django.db.models.fields.CharField')(max_length=200)),
('course',
self.gf('django.db.models.fields.CharField')(max_length=200)),
('course_manager',
self.gf('django.db.models.fields.CharField')(max_length=200)),
('notes', self.gf('django.db.models.fields.CharField')(
max_length=200, blank=True)),
))
db.send_create_signal(u'app', ['ExternalTeacher'])
# Adding model 'FenixAPIUserInfo'
db.create_table(u'app_fenixapiuserinfo', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.OneToOneField')(
to=orm['auth.User'], unique=True)),
('code', self.gf('django.db.models.fields.CharField')(
max_length=200, null=True)),
('access_token', self.gf('django.db.models.fields.CharField')(
max_length=200, blank=True)),
('refresh_token', self.gf('django.db.models.fields.CharField')(
max_length=200, blank=True)),
('token_expires',
self.gf('django.db.models.fields.IntegerField')(default=0)),
))
db.send_create_signal(u'app', ['FenixAPIUserInfo'])
def forwards(self, orm):
# Removing unique constraint on 'Site', fields ['code']
db.delete_unique(u'recordings_site', ['code'])
# Adding model 'Analysis'
db.create_table(u'recordings_analysis', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=32)),
('code',
self.gf('django.db.models.fields.SlugField')(max_length=32)),
('description',
self.gf('django.db.models.fields.TextField')(default='')),
('datetime', self.gf('django.db.models.fields.DateTimeField')(
auto_now=True, blank=True)),
('ubertag', self.gf('django.db.models.fields.related.ForeignKey')(
blank=True,
related_name='ubertags',
null=True,
to=orm['recordings.Tag'])),
('organisation',
self.gf('django.db.models.fields.related.ForeignKey')(
related_name='analyses', to=orm['recordings.Organisation'])),
))
db.send_create_signal(u'recordings', ['Analysis'])
# Adding M2M table for field tags on 'Analysis'
db.create_table(
u'recordings_analysis_tags',
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('analysis',
models.ForeignKey(orm[u'recordings.analysis'], null=False)),
('tag', models.ForeignKey(orm[u'recordings.tag'], null=False))))
db.create_unique(u'recordings_analysis_tags',
['analysis_id', 'tag_id'])
# Adding M2M table for field deployments on 'Analysis'
db.create_table(
u'recordings_analysis_deployments',
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('analysis',
models.ForeignKey(orm[u'recordings.analysis'], null=False)),
('deployment',
models.ForeignKey(orm[u'recordings.deployment'], null=False))))
db.create_unique(u'recordings_analysis_deployments',
['analysis_id', 'deployment_id'])
# Adding M2M table for field detectors on 'Analysis'
db.create_table(
u'recordings_analysis_detectors',
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('analysis',
models.ForeignKey(orm[u'recordings.analysis'], null=False)),
('detector',
models.ForeignKey(orm[u'recordings.detector'], null=False))))
db.create_unique(u'recordings_analysis_detectors',
['analysis_id', 'detector_id'])
# Adding unique constraint on 'Analysis', fields ['organisation', 'code']
db.create_unique(u'recordings_analysis', ['organisation_id', 'code'])
# Adding model 'Tag'
db.create_table(u'recordings_tag', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('code', self.gf('django.db.models.fields.SlugField')(
unique=True, max_length=32)),
('name',
self.gf('django.db.models.fields.CharField')(max_length=32)),
))
db.send_create_signal(u'recordings', ['Tag'])
# Adding model 'Identification'
db.create_table(u'recordings_identification', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['auth.User'])),
('analysis', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['recordings.Analysis'])),
('snippet', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['recordings.Snippet'])),
('comment',
self.gf('django.db.models.fields.TextField')(default='')),
))
db.send_create_signal(u'recordings', ['Identification'])
# Adding M2M table for field scores on 'Identification'
db.create_table(
u'recordings_identification_scores',
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('identification',
models.ForeignKey(orm[u'recordings.identification'],
null=False)),
('score', models.ForeignKey(orm[u'recordings.score'],
null=False))))
db.create_unique(u'recordings_identification_scores',
['identification_id', 'score_id'])
# Adding M2M table for field tags on 'Identification'
db.create_table(
u'recordings_identification_tags',
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('identification',
models.ForeignKey(orm[u'recordings.identification'],
null=False)),
('tag', models.ForeignKey(orm[u'recordings.tag'], null=False))))
db.create_unique(u'recordings_identification_tags',
['identification_id', 'tag_id'])
# Changing field 'Detector.code'
db.alter_column(
u'recordings_detector', 'code',
self.gf('django.db.models.fields.SlugField')(max_length=32))
# Adding field 'Deployment.owner'
db.add_column(u'recordings_deployment',
'owner',
self.gf('django.db.models.fields.related.ForeignKey')(
default=1,
related_name='deployments',
to=orm['recordings.Organisation']),
keep_default=False)
# Changing field 'Signal.code'
db.alter_column(
u'recordings_signal', 'code',
self.gf('django.db.models.fields.SlugField')(unique=True,
max_length=32))
# Adding unique constraint on 'Signal', fields ['code']
db.create_unique(u'recordings_signal', ['code'])
# Adding field 'Site.organisation'
db.add_column(u'recordings_site',
'organisation',
self.gf('django.db.models.fields.related.ForeignKey')(
default=1,
related_name='sites',
to=orm['recordings.Organisation']),
keep_default=False)
# Changing field 'Site.code'
db.alter_column(
u'recordings_site', 'code',
self.gf('django.db.models.fields.SlugField')(max_length=32))
# Adding unique constraint on 'Site', fields ['organisation', 'code']
db.create_unique(u'recordings_site', ['organisation_id', 'code'])
# Changing field 'Recorder.code'
db.alter_column(
u'recordings_recorder', 'code',
self.gf('django.db.models.fields.SlugField')(max_length=32))
# Changing field 'Organisation.code'
db.alter_column(
u'recordings_organisation', 'code',
self.gf('django.db.models.fields.SlugField')(unique=True,
max_length=32))
def forwards(self, orm):
# Adding model 'Form'
db.create_table('forms_form', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('title',
self.gf('django.db.models.fields.CharField')(max_length=50)),
('slug', self.gf('django.db.models.fields.SlugField')(
unique=True, max_length=100, db_index=True)),
('intro',
self.gf('django.db.models.fields.TextField')(blank=True)),
('button_text', self.gf('django.db.models.fields.CharField')(
default=u'Submit', max_length=50)),
('response',
self.gf('django.db.models.fields.TextField')(blank=True)),
('status',
self.gf('django.db.models.fields.IntegerField')(default=2)),
('publish_date', self.gf('django.db.models.fields.DateTimeField')(
null=True, blank=True)),
('expiry_date', self.gf('django.db.models.fields.DateTimeField')(
null=True, blank=True)),
('login_required',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('send_email',
self.gf('django.db.models.fields.BooleanField')(default=True)),
('email_from', self.gf('django.db.models.fields.EmailField')(
max_length=75, blank=True)),
('email_copies', self.gf('django.db.models.fields.CharField')(
max_length=200, blank=True)),
('email_subject', self.gf('django.db.models.fields.CharField')(
max_length=200, blank=True)),
('email_message',
self.gf('django.db.models.fields.TextField')(blank=True)),
))
db.send_create_signal('forms', ['Form'])
# Adding M2M table for field sites on 'Form'
db.create_table(
'forms_form_sites',
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('form', models.ForeignKey(orm['forms.form'], null=False)),
('site', models.ForeignKey(orm['sites.site'], null=False))))
db.create_unique('forms_form_sites', ['form_id', 'site_id'])
# Adding model 'Field'
db.create_table('forms_field', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('label',
self.gf('django.db.models.fields.CharField')(max_length=200)),
('field_type', self.gf('django.db.models.fields.IntegerField')()),
('required',
self.gf('django.db.models.fields.BooleanField')(default=True)),
('visible',
self.gf('django.db.models.fields.BooleanField')(default=True)),
('choices', self.gf('django.db.models.fields.CharField')(
max_length=1000, blank=True)),
('default', self.gf('django.db.models.fields.CharField')(
max_length=2000, blank=True)),
('placeholder_text', self.gf('django.db.models.fields.CharField')(
max_length=100, blank=True)),
('help_text', self.gf('django.db.models.fields.CharField')(
max_length=100, blank=True)),
('form', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='fields', to=orm['forms.Form'])),
('_order',
self.gf('django.db.models.fields.IntegerField')(default=0)),
))
db.send_create_signal('forms', ['Field'])
# Adding model 'FormEntry'
db.create_table('forms_formentry', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('entry_time', self.gf('django.db.models.fields.DateTimeField')()),
('form', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='entries', to=orm['forms.Form'])),
))
db.send_create_signal('forms', ['FormEntry'])
# Adding model 'FieldEntry'
db.create_table('forms_fieldentry', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('field_id', self.gf('django.db.models.fields.IntegerField')()),
('value',
self.gf('django.db.models.fields.CharField')(max_length=2000)),
('entry', self.gf('django.db.models.fields.related.ForeignKey')(
related_name='fields', to=orm['forms.FormEntry'])),
))
db.send_create_signal('forms', ['FieldEntry'])
def forwards(self, orm):
# Adding model 'Entry'
db.create_table(u'feed_entry', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('created', self.gf('model_utils.fields.AutoCreatedField')(
default=datetime.datetime.now)),
('modified', self.gf('model_utils.fields.AutoLastModifiedField')(
default=datetime.datetime.now)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['user_app.CustomUser'])),
('text',
self.gf('django.db.models.fields.CharField')(max_length=300)),
))
db.send_create_signal(u'feed', ['Entry'])
# Adding model 'TextEntry'
db.create_table(
u'feed_textentry',
((u'entry_ptr',
self.gf('django.db.models.fields.related.OneToOneField')(
to=orm['feed.Entry'], unique=True, primary_key=True)), ))
db.send_create_signal(u'feed', ['TextEntry'])
# Adding model 'PictureEntry'
db.create_table(u'feed_pictureentry', (
(u'entry_ptr',
self.gf('django.db.models.fields.related.OneToOneField')(
to=orm['feed.Entry'], unique=True, primary_key=True)),
('img', self.gf('django.db.models.fields.files.ImageField')(
max_length=100)),
))
db.send_create_signal(u'feed', ['PictureEntry'])
# Adding model 'VideoEntry'
db.create_table(u'feed_videoentry', (
(u'entry_ptr',
self.gf('django.db.models.fields.related.OneToOneField')(
to=orm['feed.Entry'], unique=True, primary_key=True)),
('img', self.gf('django.db.models.fields.files.ImageField')(
max_length=100)),
))
db.send_create_signal(u'feed', ['VideoEntry'])
# Adding model 'EventEntry'
db.create_table(u'feed_evententry', (
(u'entry_ptr',
self.gf('django.db.models.fields.related.OneToOneField')(
to=orm['feed.Entry'], unique=True, primary_key=True)),
('start', self.gf('django.db.models.fields.DateTimeField')(
null=True, blank=True)),
('end', self.gf('django.db.models.fields.DateTimeField')(
null=True, blank=True)),
))
db.send_create_signal(u'feed', ['EventEntry'])
# Adding model 'BlogEntry'
db.create_table(
u'feed_blogentry',
((u'entry_ptr',
self.gf('django.db.models.fields.related.OneToOneField')(
to=orm['feed.Entry'], unique=True, primary_key=True)), ))
db.send_create_signal(u'feed', ['BlogEntry'])
