def backwards(self, orm): # Deleting field 'OrderedProductEntity.entity' db.delete_column('core_orderedproductentity', 'entity_id') # Deleting field 'OrderedProductEntity.part_of' db.delete_column('core_orderedproductentity', 'part_of_id') # Adding M2M table for field orders on 'ProductEntity' db.create_table('core_productentity_orders', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('productentity', models.ForeignKey(orm['core.productentity'], null=False)), ('orderedproductentity', models.ForeignKey(orm['core.orderedproductentity'], null=False)) )) db.create_unique('core_productentity_orders', ['productentity_id', 'orderedproductentity_id']) # Deleting field 'ProductsOrder.target' db.delete_column('core_productsorder', 'target_id') # Adding M2M table for field products on 'ProductsOrder' db.create_table('core_productsorder_products', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('productsorder', models.ForeignKey(orm['core.productsorder'], null=False)), ('orderedproductentity', models.ForeignKey(orm['core.orderedproductentity'], null=False)) )) db.create_unique('core_productsorder_products', ['productsorder_id', 'orderedproductentity_id'])
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 'User' db.create_table('auth_user', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('password', self.gf('django.db.models.fields.CharField')(max_length=128)), ('last_login', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)), ('is_superuser', self.gf('django.db.models.fields.BooleanField')(default=False)), ('username', self.gf('django.db.models.fields.CharField')(unique=True, max_length=30)), ('first_name', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)), ('last_name', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)), ('email', self.gf('django.db.models.fields.EmailField')(max_length=75, blank=True)), ('is_staff', self.gf('django.db.models.fields.BooleanField')(default=False)), ('is_active', self.gf('django.db.models.fields.BooleanField')(default=True)), ('date_joined', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)), )) db.send_create_signal(u'accounts', ['User']) # Adding M2M table for field groups on 'User' m2m_table_name = db.shorten_name('auth_user_groups') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('user', models.ForeignKey(orm[u'accounts.user'], null=False)), ('group', models.ForeignKey(orm[u'auth.group'], null=False)) )) db.create_unique(m2m_table_name, ['user_id', 'group_id']) # Adding M2M table for field user_permissions on 'User' m2m_table_name = db.shorten_name('auth_user_user_permissions') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('user', models.ForeignKey(orm[u'accounts.user'], null=False)), ('permission', models.ForeignKey(orm[u'auth.permission'], null=False)) )) db.create_unique(m2m_table_name, ['user_id', 'permission_id'])
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 field 'Profile.subscribe_any_translation' db.add_column('accounts_profile', 'subscribe_any_translation', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False) # Adding field 'Profile.subscribe_new_string' db.add_column('accounts_profile', 'subscribe_new_string', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False) # Adding field 'Profile.subscribe_new_suggestion' db.add_column('accounts_profile', 'subscribe_new_suggestion', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False) # Adding field 'Profile.subscribe_new_contributor' db.add_column('accounts_profile', 'subscribe_new_contributor', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False) # Adding M2M table for field subscriptions on 'Profile' db.create_table('accounts_profile_subscriptions', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('profile', models.ForeignKey(orm['accounts.profile'], null=False)), ('project', models.ForeignKey(orm['trans.project'], null=False)) )) db.create_unique('accounts_profile_subscriptions', ['profile_id', 'project_id'])
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): # Deleting field 'LegAction.minutes' db.delete_column('phillyleg_legaction', 'minutes_id') # Adding unique constraint on 'LegMinutes', fields ['id'] db.create_unique('phillyleg_legminutes', ['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 'Poll' db.create_table(u'polls_poll', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('question', self.gf('django.db.models.fields.CharField')(max_length=200)), ('pub_date', self.gf('django.db.models.fields.DateTimeField')()), )) db.send_create_signal(u'polls', ['Poll']) # Adding model 'Voter' db.create_table(u'polls_voter', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('voterID', self.gf('django.db.models.fields.CharField')(max_length=200)), )) db.send_create_signal(u'polls', ['Voter']) # Adding model 'Choice' db.create_table(u'polls_choice', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('poll', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['polls.Poll'])), ('choice_text', self.gf('django.db.models.fields.CharField')(max_length=200)), ('votes', self.gf('django.db.models.fields.IntegerField')(default=0)), )) db.send_create_signal(u'polls', ['Choice']) # Adding M2M table for field voters on 'Choice' m2m_table_name = db.shorten_name(u'polls_choice_voters') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('choice', models.ForeignKey(orm[u'polls.choice'], null=False)), ('voter', models.ForeignKey(orm[u'polls.voter'], null=False)) )) db.create_unique(m2m_table_name, ['choice_id', 'voter_id'])
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 '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 backwards(self, orm): # Changing field 'Task.model_solution' db.alter_column('tasks_task', 'model_solution_id', self.gf('django.db.models.fields.related.OneToOneField')(unique=True, null=True, to=orm['solutions.Solution'])) # Adding unique constraint on 'Task', fields ['model_solution'] db.create_unique('tasks_task', ['model_solution_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): # Deleting field 'Project.private' db.delete_column('gitlog_project', 'private') # Deleting field 'Project.source' db.delete_column('gitlog_project', 'source') # Adding field 'Project.public' db.add_column('gitlog_project', 'public', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False) # Adding field 'Project.url' db.add_column('gitlog_project', 'url', self.gf('django.db.models.fields.URLField')(max_length=30, null=True, blank=True), keep_default=False) # Adding field 'Project.description' db.add_column('gitlog_project', 'description', self.gf('django.db.models.fields.TextField')(null=True, blank=True), keep_default=False) # Adding M2M table for field writable on 'Project' db.create_table('gitlog_project_writable', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('project', models.ForeignKey(orm['gitlog.project'], null=False)), ('user', models.ForeignKey(orm['auth.user'], null=False)) )) db.create_unique('gitlog_project_writable', ['project_id', 'user_id']) # Adding M2M table for field readonly on 'Project' db.create_table('gitlog_project_readonly', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('project', models.ForeignKey(orm['gitlog.project'], null=False)), ('user', models.ForeignKey(orm['auth.user'], null=False)) )) db.create_unique('gitlog_project_readonly', ['project_id', 'user_id']) # Changing field 'Project.owner' db.alter_column('gitlog_project', 'owner_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['auth.User']))
def backwards(self, orm): # Adding unique constraint on 'Feature', fields ['category', 'name'] db.create_unique('categories_feature', ['category_id', 'name']) # Adding unique constraint on 'Feature', fields ['category', 'sort_order', 'group'] db.create_unique('categories_feature', ['category_id', 'sort_order', 'group_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 '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 'Portlet' db.create_table(u'slot_portlet', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('polymorphic_ctype', self.gf('django.db.models.fields.related.ForeignKey')(related_name=u'polymorphic_slot.portlet_set', null=True, to=orm['contenttypes.ContentType'])), ('title', self.gf('django.db.models.fields.CharField')(max_length=100)), )) db.send_create_signal(u'slot', ['Portlet']) # Adding model 'Slot' db.create_table(u'slot_slot', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('key', self.gf('django.db.models.fields.CharField')(unique=True, max_length=1024, db_index=True)), ('description', self.gf('django.db.models.fields.CharField')(max_length=100, blank=True)), )) db.send_create_signal(u'slot', ['Slot']) # Adding model 'SlotPortlet' db.create_table(u'slot_slotportlet', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('slot', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['slot.Slot'])), ('portlet', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['slot.Portlet'])), ('ordering', self.gf('django.db.models.fields.PositiveIntegerField')(default=2)), )) db.send_create_signal(u'slot', ['SlotPortlet']) # Adding unique constraint on 'SlotPortlet', fields ['slot', 'portlet'] db.create_unique(u'slot_slotportlet', ['slot_id', 'portlet_id'])
def forwards(self, orm): # Adding model 'Achievement' db.create_table('attestation_achievement', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=128)), )) db.send_create_signal('attestation', ['Achievement']) # Deleting field 'Request.degree' db.delete_column('attestation_request', 'degree_id') # Adding M2M table for field degrees on 'Request' db.create_table('attestation_request_degrees', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('request', models.ForeignKey(orm['attestation.request'], null=False)), ('degree', models.ForeignKey(orm['attestation.degree'], null=False)) )) db.create_unique('attestation_request_degrees', ['request_id', 'degree_id']) # Adding M2M table for field achievements on 'Request' db.create_table('attestation_request_achievements', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('request', models.ForeignKey(orm['attestation.request'], null=False)), ('achievement', models.ForeignKey(orm['attestation.achievement'], null=False)) )) db.create_unique('attestation_request_achievements', ['request_id', 'achievement_id'])
def forwards(self, orm): # Deleting field 'SponsorshipLevel.content_type' db.delete_column(u'camp_sponsorshiplevel', 'content_type_id') # Deleting field 'SponsorshipLevel.object_id' db.delete_column(u'camp_sponsorshiplevel', 'object_id') # Adding M2M table for field events on 'SponsorshipLevel' db.create_table(u'camp_sponsorshiplevel_events', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('sponsorshiplevel', models.ForeignKey(orm[u'camp.sponsorshiplevel'], null=False)), ('event', models.ForeignKey(orm[u'sked.event'], null=False)) )) db.create_unique(u'camp_sponsorshiplevel_events', ['sponsorshiplevel_id', 'event_id']) # Deleting field 'Sponsor.content_type' db.delete_column(u'camp_sponsor', 'content_type_id') # Deleting field 'Sponsor.object_id' db.delete_column(u'camp_sponsor', 'object_id') # Adding field 'Sponsor.event' db.add_column(u'camp_sponsor', 'event', self.gf('django.db.models.fields.related.ForeignKey')(default=1, related_name='sponsors', to=orm['sked.Event']), keep_default=False)
def forwards(self, orm): # Deleting model 'SkipQuestion' db.delete_table(u'questionnaire_skipquestion') # Adding model 'MultipleResponseAnswer' db.create_table(u'questionnaire_multipleresponseanswer', ( (u'answer_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['questionnaire.Answer'], unique=True, primary_key=True)), )) db.send_create_signal('questionnaire', ['MultipleResponseAnswer']) # Adding M2M table for field response on 'MultipleResponseAnswer' db.create_table(u'questionnaire_multipleresponseanswer_response', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('multipleresponseanswer', models.ForeignKey(orm['questionnaire.multipleresponseanswer'], null=False)), ('questionoption', models.ForeignKey(orm['questionnaire.questionoption'], null=False)) )) db.create_unique(u'questionnaire_multipleresponseanswer_response', ['multipleresponseanswer_id', 'questionoption_id']) # Adding model 'SkipRule' db.create_table(u'questionnaire_skiprule', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('created', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now, blank=True)), ('modified', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now, blank=True)), ('root_question', self.gf('django.db.models.fields.related.ForeignKey')(related_name='root_skip_rules', to=orm['questionnaire.Question'])), ('response', self.gf('django.db.models.fields.related.ForeignKey')(related_name='skip_rules', to=orm['questionnaire.QuestionOption'])), ('skip_question', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='skip_rules', null=True, to=orm['questionnaire.Question'])), ('skip_subsection', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['questionnaire.SubSection'], null=True, blank=True)), ('subsection', self.gf('django.db.models.fields.related.ForeignKey')(related_name='skip_rules', to=orm['questionnaire.SubSection'])), )) db.send_create_signal('questionnaire', ['SkipRule'])
def forwards(self, orm): # Adding model 'Collection' db.create_table('collection_collection', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=100)), ('description', self.gf('django.db.models.fields.TextField')(blank=True)), ('owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'])), ('creation_date', self.gf('django.db.models.fields.DateTimeField')()), ('modified_date', self.gf('django.db.models.fields.DateTimeField')()), ('is_public', self.gf('django.db.models.fields.BooleanField')(default=False)), ('is_locked', self.gf('django.db.models.fields.BooleanField')(default=False)), ('parent', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['collection.Collection'], null=True, blank=True)), ('creation_info', self.gf('django.db.models.fields.CharField')(max_length=200)), )) db.send_create_signal('collection', ['Collection']) # Adding unique constraint on 'Collection', fields ['owner', 'name'] db.create_unique('collection_collection', ['owner_id', 'name']) # Adding M2M table for field images on 'Collection' db.create_table('collection_collection_images', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('collection', models.ForeignKey(orm['collection.collection'], null=False)), ('image', models.ForeignKey(orm['catamidb.image'], null=False)) )) db.create_unique('collection_collection_images', ['collection_id', 'image_id'])
def forwards(self, orm): # Adding model 'DesLookbook' db.create_table(u'catalogue_deslookbook', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('designer', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['designer.Designer'], null=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=128, unique=True, null=True)), ('description', self.gf('django.db.models.fields.TextField')()), )) db.send_create_signal(u'catalogue', ['DesLookbook']) # Adding M2M table for field products on 'DesLookbook' m2m_table_name = db.shorten_name(u'catalogue_deslookbook_products') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('deslookbook', models.ForeignKey(orm[u'catalogue.deslookbook'], null=False)), ('product', models.ForeignKey(orm[u'catalogue.product'], null=False)) )) db.create_unique(m2m_table_name, ['deslookbook_id', 'product_id']) # Adding field 'Product.designer' db.add_column(u'catalogue_product', 'designer', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['designer.Designer'], null=True, blank=True), keep_default=False) # Adding field 'Product.video' db.add_column(u'catalogue_product', 'video', self.gf('django.db.models.fields.files.FileField')(max_length=100, null=True, blank=True), keep_default=False)
def forwards(self, orm): # Adding model 'RaceSpeed' db.create_table('dnd_racespeed', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dnd.RaceSpeedType'])), ('speed', self.gf('django.db.models.fields.PositiveSmallIntegerField')()), )) db.send_create_signal('dnd', ['RaceSpeed']) # Adding model 'RaceSpeedType' db.create_table('dnd_racespeedtype', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=32, db_index=True)), ('extra', self.gf('django.db.models.fields.CharField')(max_length=32, null=True, blank=True)), )) db.send_create_signal('dnd', ['RaceSpeedType']) # Deleting field 'Race.base_land_speed' db.delete_column('dnd_race', 'base_land_speed') # Adding field 'Race.combat' db.add_column('dnd_race', 'combat', self.gf('django.db.models.fields.TextField')(default='', blank=True), keep_default=False) # Adding M2M table for field speeds on 'Race' db.create_table('dnd_race_speeds', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('race', models.ForeignKey(orm['dnd.race'], null=False)), ('racespeed', models.ForeignKey(orm['dnd.racespeed'], null=False)) )) db.create_unique('dnd_race_speeds', ['race_id', 'racespeed_id'])
def backwards(self, orm): # Adding field 'SMARTTest.smarttest_disk' db.add_column('system_smarttest', 'smarttest_disk', self.gf('django.db.models.fields.related.ForeignKey')(default=1, related_name='smarttestdisk', to=orm['storage.Disk']), keep_default=False) # Adding unique constraint on 'SMARTTest', fields ['smarttest_type', 'smarttest_disk'] db.create_unique('system_smarttest', ['smarttest_type', 'smarttest_disk_id'])
def forwards(self, orm): # Adding model 'EntryTranslation' db.create_table('happy_blog_entry_translation', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')(max_length=256)), ('slug', self.gf('django.db.models.fields.CharField')(max_length=256)), ('content', self.gf('tinymce.models.HTMLField')(blank=True)), ('language_code', self.gf('django.db.models.fields.CharField')(max_length=15, db_index=True)), ('master', self.gf('django.db.models.fields.related.ForeignKey')(related_name='translatable', null=True, to=orm['happy_blog.Entry'])), )) db.send_create_signal('happy_blog', ['EntryTranslation']) # Adding unique constraint on 'EntryTranslation', fields ['language_code', 'master'] db.create_unique('happy_blog_entry_translation', ['language_code', 'master_id']) # Adding model 'Entry' db.create_table('happy_blog_entry', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('pub_date', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)), ('published', self.gf('django.db.models.fields.BooleanField')(default=False)), ('author', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True, blank=True)), ('gallery', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['simplegallery.Gallery'], null=True, blank=True)), )) db.send_create_signal('happy_blog', ['Entry']) # Adding model 'LatestBlogEntriesPlugin' db.create_table('cmsplugin_latestblogentriesplugin', ( ('cmsplugin_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['cms.CMSPlugin'], unique=True, primary_key=True)), ('count', self.gf('django.db.models.fields.IntegerField')(default=25)), )) db.send_create_signal('happy_blog', ['LatestBlogEntriesPlugin'])
def backwards(self, orm): # Adding M2M table for field comment on 'Event' m2m_table_name = db.shorten_name(u'event_event_comment') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('event', models.ForeignKey(orm[u'event.event'], null=False)), ('comment', models.ForeignKey(orm[u'comment.comment'], null=False)) )) db.create_unique(m2m_table_name, ['event_id', 'comment_id']) # Changing field 'Event.category' db.alter_column(u'event_event', 'category_id', self.gf('django.db.models.fields.related.ForeignKey')(default=1, to=orm['event.EventCategory'])) # Changing field 'Event.fr' db.alter_column(u'event_event', 'fr', self.gf('django.db.models.fields.DateTimeField')(default=1)) # Changing field 'Event.cover' db.alter_column(u'event_event', 'cover', self.gf('django.db.models.fields.files.ImageField')(default=1, max_length=100)) # Changing field 'Event.to' db.alter_column(u'event_event', 'to', self.gf('django.db.models.fields.DateTimeField')(default=1)) # Changing field 'Event.place' db.alter_column(u'event_event', 'place', self.gf('django.db.models.fields.CharField')(default=1, max_length=250))
def forwards(self, orm): # Adding model 'Measure' db.create_table(u'finance_measure', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=30)), ('note', self.gf('django.db.models.fields.CharField')(max_length=100, null=True, blank=True)), )) db.send_create_signal(u'finance', ['Measure']) # Adding model 'RegisterUnits' db.create_table(u'finance_registerunits', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=30)), )) db.send_create_signal(u'finance', ['RegisterUnits']) # Adding model 'GoodsType' db.create_table(u'finance_goodstype', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=30)), ('note', self.gf('django.db.models.fields.CharField')(max_length=100, null=True, blank=True)), )) db.send_create_signal(u'finance', ['GoodsType']) # Adding model 'Goods' db.create_table(u'finance_goods', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=30)), ('provider', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['finance.Provider'], null=True, blank=True)), ('goods_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['finance.GoodsType'], null=True, blank=True)), ('measure', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['finance.Measure'], null=True, blank=True)), ('mix_measure', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='mix_measure', null=True, to=orm['finance.Measure'])), ('register_units', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['finance.RegisterUnits'], null=True, blank=True)), )) db.send_create_signal(u'finance', ['Goods']) # Adding model 'Provider' db.create_table(u'finance_provider', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=30)), ('inn', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=0, blank=True)), ('kpp', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=0, blank=True)), ('address', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)), ('activity', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)), ('note', self.gf('django.db.models.fields.CharField')(max_length=100, null=True, blank=True)), )) db.send_create_signal(u'finance', ['Provider']) # Adding model 'Price' db.create_table(u'finance_price', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('goods', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['finance.Goods'])), ('date_start', self.gf('django.db.models.fields.DateField')(default=datetime.datetime.now)), ('date_end', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), ('is_active', self.gf('django.db.models.fields.IntegerField')(default=-1)), )) db.send_create_signal(u'finance', ['Price']) # Adding unique constraint on 'Price', fields ['goods', 'is_active'] db.create_unique(u'finance_price', ['goods_id', 'is_active']) # Adding model 'BarCode' db.create_table(u'finance_barcode', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('goods', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['finance.Goods'])), ('code', self.gf('django.db.models.fields.DecimalField')(max_digits=15, decimal_places=0)), )) db.send_create_signal(u'finance', ['BarCode'])
def forwards(self, orm): # Adding model 'PageType' db.create_table(u'fancypages_pagetype', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=128)), ('slug', self.gf('django.db.models.fields.SlugField')(max_length=128)), ('template_name', self.gf('django.db.models.fields.CharField')(max_length=255)), )) db.send_create_signal('fancypages', ['PageType']) # Adding model 'VisibilityType' db.create_table(u'fancypages_visibilitytype', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=128)), ('slug', self.gf('django.db.models.fields.SlugField')( max_length=128, null=True, blank=True)), )) db.send_create_signal('fancypages', ['VisibilityType']) # Adding model 'FancyPage' db.create_table(u'fancypages_fancypage', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('path', self.gf('django.db.models.fields.CharField')( unique=True, max_length=255)), ('depth', self.gf('django.db.models.fields.PositiveIntegerField')()), ('numchild', self.gf('django.db.models.fields.PositiveIntegerField')( default=0)), ('name', self.gf('django.db.models.fields.CharField')( max_length=255, db_index=True)), ('slug', self.gf('django.db.models.fields.SlugField')(max_length=255)), ('image', self.gf('django.db.models.fields.files.ImageField')( max_length=100, null=True, blank=True)), ('description', self.gf('django.db.models.fields.TextField')(blank=True)), ('page_type', self.gf('django.db.models.fields.related.ForeignKey')( blank=True, related_name='pages', null=True, to=orm['fancypages.PageType'])), ('keywords', self.gf('django.db.models.fields.CharField')( max_length=255, blank=True)), ('status', self.gf('django.db.models.fields.CharField')( default=u'draft', max_length=15)), ('date_visible_start', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), ('date_visible_end', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), )) db.send_create_signal('fancypages', ['FancyPage']) # Adding M2M table for field visibility_types on 'FancyPage' m2m_table_name = db.shorten_name( u'fancypages_fancypage_visibility_types') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('fancypage', models.ForeignKey(orm['fancypages.fancypage'], null=False)), ('visibilitytype', models.ForeignKey(orm['fancypages.visibilitytype'], null=False)))) db.create_unique(m2m_table_name, ['fancypage_id', 'visibilitytype_id']) # Adding model 'Container' db.create_table(u'fancypages_container', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.SlugField')( max_length=50, blank=True)), ('title', self.gf('django.db.models.fields.CharField')( max_length=100, blank=True)), ('content_type', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['contenttypes.ContentType'], null=True)), ('object_id', self.gf('django.db.models.fields.PositiveIntegerField')( null=True)), )) db.send_create_signal('fancypages', ['Container']) # Adding model 'OrderedContainer' db.create_table(u'fancypages_orderedcontainer', ( (u'container_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.Container'], unique=True, primary_key=True)), ('display_order', self.gf('django.db.models.fields.PositiveIntegerField')()), )) db.send_create_signal('fancypages', ['OrderedContainer']) # Adding model 'ContentBlock' db.create_table(u'fancypages_contentblock', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('container', self.gf('django.db.models.fields.related.ForeignKey')( related_name='blocks', to=orm['fancypages.Container'])), ('display_order', self.gf('django.db.models.fields.PositiveIntegerField')()), )) db.send_create_signal('fancypages', ['ContentBlock']) # Adding model 'TextBlock' db.create_table(u'fancypages_textblock', ( (u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), ('text', self.gf('django.db.models.fields.TextField')( default='Your text goes here.')), )) db.send_create_signal('fancypages', ['TextBlock']) # Adding model 'TitleTextBlock' db.create_table(u'fancypages_titletextblock', ( (u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')( default='Your title goes here.', max_length=100)), ('text', self.gf('django.db.models.fields.TextField')( default='Your text goes here.')), )) db.send_create_signal('fancypages', ['TitleTextBlock']) # Adding model 'ImageBlock' db.create_table(u'fancypages_imageblock', ( (u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')( max_length=100, null=True, blank=True)), ('alt_text', self.gf('django.db.models.fields.CharField')( max_length=100, null=True, blank=True)), ('link', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_asset', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='image_blocks', null=True, to=orm['assets.ImageAsset'])), )) db.send_create_signal('fancypages', ['ImageBlock']) # Adding model 'ImageAndTextBlock' db.create_table(u'fancypages_imageandtextblock', ( (u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')( max_length=100, null=True, blank=True)), ('alt_text', self.gf('django.db.models.fields.CharField')( max_length=100, null=True, blank=True)), ('link', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_asset', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='image_text_blocks', null=True, to=orm['assets.ImageAsset'])), ('text', self.gf('django.db.models.fields.CharField')( default='Your text goes here.', max_length=2000)), )) db.send_create_signal('fancypages', ['ImageAndTextBlock']) # Adding model 'CarouselBlock' db.create_table(u'fancypages_carouselblock', ( (u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), ('image_1', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_1', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_2', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_2', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_3', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_3', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_4', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_4', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_5', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_5', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_6', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_6', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_7', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_7', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_8', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_8', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_9', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_9', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), ('image_10', self.gf('fancypages.assets.fields.AssetKey')( blank=True, related_name='+', null=True, to=orm['assets.ImageAsset'])), ('link_url_10', self.gf('django.db.models.fields.CharField')( max_length=500, null=True, blank=True)), )) db.send_create_signal('fancypages', ['CarouselBlock']) # Adding model 'PageNavigationBlock' db.create_table( u'fancypages_pagenavigationblock', ((u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), )) db.send_create_signal('fancypages', ['PageNavigationBlock']) # Adding model 'PrimaryNavigationBlock' db.create_table( u'fancypages_primarynavigationblock', ((u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), )) db.send_create_signal('fancypages', ['PrimaryNavigationBlock']) # Adding model 'TabBlock' db.create_table( u'fancypages_tabblock', ((u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), )) db.send_create_signal('fancypages', ['TabBlock']) # Adding model 'TwoColumnLayoutBlock' db.create_table(u'fancypages_twocolumnlayoutblock', ( (u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), ('left_width', self.gf('django.db.models.fields.PositiveIntegerField')( default=6, max_length=3)), )) db.send_create_signal('fancypages', ['TwoColumnLayoutBlock']) # Adding model 'ThreeColumnLayoutBlock' db.create_table( u'fancypages_threecolumnlayoutblock', ((u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), )) db.send_create_signal('fancypages', ['ThreeColumnLayoutBlock']) # Adding model 'FourColumnLayoutBlock' db.create_table( u'fancypages_fourcolumnlayoutblock', ((u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), )) db.send_create_signal('fancypages', ['FourColumnLayoutBlock']) # Adding model 'VideoBlock' db.create_table(u'fancypages_videoblock', ( (u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), ('source', self.gf('django.db.models.fields.CharField')(max_length=50)), ('video_code', self.gf('django.db.models.fields.CharField')(max_length=50)), )) db.send_create_signal('fancypages', ['VideoBlock']) # Adding model 'TwitterBlock' db.create_table(u'fancypages_twitterblock', ( (u'contentblock_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['fancypages.ContentBlock'], unique=True, primary_key=True)), ('username', self.gf('django.db.models.fields.CharField')(max_length=50)), ('max_tweets', self.gf('django.db.models.fields.PositiveIntegerField')( default=5)), )) db.send_create_signal('fancypages', ['TwitterBlock'])
def forwards(self, orm): # Adding unique constraint on 'BackendNetwork', fields ['network', 'backend'] db.create_unique('db_backendnetwork', ['network_id', 'backend_id'])
def forwards(self, orm): # Removing index on 'UserAuthAttempt', fields ['ip'] db.delete_index(u'secureauth_userauthattempt', ['ip']) # Adding unique constraint on 'UserAuthAttempt', fields ['ip'] db.create_unique(u'secureauth_userauthattempt', ['ip'])
def forwards(self, orm): # Adding unique constraint on 'ExternalCategory', fields ['source', 'xid'] db.create_unique('importer_externalcategory', ['source_id', 'xid'])
def backwards(self, orm): # Adding unique constraint on 'DimensionTag', fields ['name'] db.create_unique(u'dimension_dimensiontag', ['name'])
def forwards(self, orm): # Adding model 'Entry' db.create_table(u'zinnia_entry', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')(max_length=255)), ('slug', self.gf('django.db.models.fields.SlugField')(max_length=255)), ('status', self.gf('django.db.models.fields.IntegerField')( default=0, db_index=True)), ('start_publication', self.gf('django.db.models.fields.DateTimeField')( db_index=True, null=True, blank=True)), ('end_publication', self.gf('django.db.models.fields.DateTimeField')( db_index=True, null=True, blank=True)), ('creation_date', self.gf('django.db.models.fields.DateTimeField')( default=datetime.datetime.now, db_index=True)), ('last_update', self.gf('django.db.models.fields.DateTimeField')( default=datetime.datetime.now)), ('content', self.gf('django.db.models.fields.TextField')(blank=True)), ('comment_enabled', self.gf('django.db.models.fields.BooleanField')(default=True)), ('pingback_enabled', self.gf('django.db.models.fields.BooleanField')(default=True)), ('trackback_enabled', self.gf('django.db.models.fields.BooleanField')(default=True)), ('comment_count', self.gf('django.db.models.fields.IntegerField')(default=0)), ('pingback_count', self.gf('django.db.models.fields.IntegerField')(default=0)), ('trackback_count', self.gf('django.db.models.fields.IntegerField')(default=0)), ('excerpt', self.gf('django.db.models.fields.TextField')(blank=True)), ('image', self.gf('django.db.models.fields.files.ImageField')( max_length=100, blank=True)), ('featured', self.gf('django.db.models.fields.BooleanField')(default=False)), ('tags', self.gf('tagging.fields.TagField')()), ('login_required', self.gf('django.db.models.fields.BooleanField')(default=False)), ('password', self.gf('django.db.models.fields.CharField')( max_length=50, blank=True)), ('content_template', self.gf('django.db.models.fields.CharField')( default='zinnia/_entry_detail.html', max_length=250)), ('detail_template', self.gf('django.db.models.fields.CharField')( default='entry_detail.html', max_length=250)), )) db.send_create_signal('zinnia', ['Entry']) # Adding index on 'Entry', fields ['slug', 'creation_date'] db.create_index(u'zinnia_entry', ['slug', 'creation_date']) # Adding index on 'Entry', fields ['status', 'creation_date', 'start_publication', 'end_publication'] db.create_index(u'zinnia_entry', [ 'status', 'creation_date', 'start_publication', 'end_publication' ]) # Adding M2M table for field sites on 'Entry' m2m_table_name = db.shorten_name(u'zinnia_entry_sites') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('entry', models.ForeignKey(orm['zinnia.entry'], null=False)), ('site', models.ForeignKey(orm[u'sites.site'], null=False)))) db.create_unique(m2m_table_name, ['entry_id', 'site_id']) # Adding M2M table for field related on 'Entry' m2m_table_name = db.shorten_name(u'zinnia_entry_related') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('from_entry', models.ForeignKey(orm['zinnia.entry'], null=False)), ('to_entry', models.ForeignKey(orm['zinnia.entry'], null=False)))) db.create_unique(m2m_table_name, ['from_entry_id', 'to_entry_id']) # Adding M2M table for field authors on 'Entry' m2m_table_name = db.shorten_name(u'zinnia_entry_authors') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('entry', models.ForeignKey(orm['zinnia.entry'], null=False)), ('author', models.ForeignKey(orm['auth.user'], null=False)))) db.create_unique(m2m_table_name, ['entry_id', 'author_id']) # Adding M2M table for field categories on 'Entry' m2m_table_name = db.shorten_name(u'zinnia_entry_categories') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('entry', models.ForeignKey(orm['zinnia.entry'], null=False)), ('category', models.ForeignKey(orm['zinnia.category'], null=False)))) db.create_unique(m2m_table_name, ['entry_id', 'category_id']) # Adding model 'Category' db.create_table(u'zinnia_category', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')(max_length=255)), ('slug', self.gf('django.db.models.fields.SlugField')( unique=True, max_length=255)), ('description', self.gf('django.db.models.fields.TextField')(blank=True)), ('parent', self.gf('mptt.fields.TreeForeignKey')( blank=True, related_name='children', null=True, to=orm['zinnia.Category'])), (u'lft', self.gf('django.db.models.fields.PositiveIntegerField')( db_index=True)), (u'rght', self.gf('django.db.models.fields.PositiveIntegerField')( db_index=True)), (u'tree_id', self.gf('django.db.models.fields.PositiveIntegerField')( db_index=True)), (u'level', self.gf('django.db.models.fields.PositiveIntegerField')( db_index=True)), )) db.send_create_signal('zinnia', ['Category'])
def forwards(self, orm): # Removing unique constraint on 'CourseEnrollment', fields ['course', 'user', 'role'] try: db.delete_unique(u'schedule_courseenrollment', ['course_id', 'user_id', 'role']) except ValueError: # Apparently some databases never had this constraint to begin with pass # Adding model 'CourseSection' db.create_table(u'schedule_coursesection', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('course', self.gf('django.db.models.fields.related.ForeignKey')( related_name='sections', to=orm['schedule.Course'])), ('is_active', self.gf('django.db.models.fields.BooleanField')(default=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=255)), ('last_grade_submission', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), )) db.send_create_signal(u'schedule', ['CourseSection']) # Adding M2M table for field marking_period on 'CourseSection' m2m_table_name = db.shorten_name( u'schedule_coursesection_marking_period') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('coursesection', models.ForeignKey(orm[u'schedule.coursesection'], null=False)), ('markingperiod', models.ForeignKey(orm[u'schedule.markingperiod'], null=False)))) db.create_unique(m2m_table_name, ['coursesection_id', 'markingperiod_id']) # Adding M2M table for field cohorts on 'CourseSection' m2m_table_name = db.shorten_name(u'schedule_coursesection_cohorts') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('coursesection', models.ForeignKey(orm[u'schedule.coursesection'], null=False)), ('cohort', models.ForeignKey(orm[u'sis.cohort'], null=False)))) db.create_unique(m2m_table_name, ['coursesection_id', 'cohort_id']) # Adding model 'CourseSectionTeacher' db.create_table(u'schedule_coursesectionteacher', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('teacher', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['sis.Faculty'], null=True, blank=True)), ('course_section', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['schedule.CourseSection'], null=True)), ('is_primary', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal(u'schedule', ['CourseSectionTeacher']) # Adding unique constraint on 'CourseSectionTeacher', fields ['teacher', 'course_section'] db.create_unique(u'schedule_coursesectionteacher', ['teacher_id', 'course_section_id']) # Adding field 'CourseMeet.course_section' db.add_column(u'schedule_coursemeet', 'course_section', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['schedule.CourseSection'], null=True), keep_default=False) # Adding field 'Course.is_active' db.add_column( u'schedule_course', 'is_active', self.gf('django.db.models.fields.BooleanField')(default=True), keep_default=False) # Adding field 'CourseEnrollment.course_section' db.add_column(u'schedule_courseenrollment', 'course_section', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['schedule.CourseSection'], null=True), keep_default=False) # Changing field 'CourseEnrollment.course' db.alter_column( u'schedule_courseenrollment', 'course_id', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['schedule.Course'], null=True))
def forwards(self, orm): # Adding model 'AuthProviderPolicyProfile' db.create_table('im_authproviderpolicyprofile', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')( max_length=255, db_index=True)), ('provider', self.gf('django.db.models.fields.CharField')(max_length=255)), ('is_exclusive', self.gf('django.db.models.fields.BooleanField')(default=False)), ('policy_add', self.gf('django.db.models.fields.NullBooleanField')( default=None, null=True, blank=True)), ('policy_remove', self.gf('django.db.models.fields.NullBooleanField')( default=None, null=True, blank=True)), ('policy_create', self.gf('django.db.models.fields.NullBooleanField')( default=None, null=True, blank=True)), ('policy_login', self.gf('django.db.models.fields.NullBooleanField')( default=None, null=True, blank=True)), ('policy_limit', self.gf('django.db.models.fields.IntegerField')( default=None, null=True)), ('policy_required', self.gf('django.db.models.fields.NullBooleanField')( default=None, null=True, blank=True)), ('policy_automoderate', self.gf('django.db.models.fields.NullBooleanField')( default=None, null=True, blank=True)), ('policy_switch', self.gf('django.db.models.fields.NullBooleanField')( default=None, null=True, blank=True)), ('priority', self.gf('django.db.models.fields.IntegerField')(default=1)), ('active', self.gf('django.db.models.fields.BooleanField')(default=True)), )) db.send_create_signal('im', ['AuthProviderPolicyProfile']) # Adding M2M table for field groups on 'AuthProviderPolicyProfile' db.create_table( 'im_authproviderpolicyprofile_groups', (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('authproviderpolicyprofile', models.ForeignKey(orm['im.authproviderpolicyprofile'], null=False)), ('group', models.ForeignKey(orm['auth.group'], null=False)))) db.create_unique('im_authproviderpolicyprofile_groups', ['authproviderpolicyprofile_id', 'group_id']) # Adding M2M table for field users on 'AuthProviderPolicyProfile' db.create_table( 'im_authproviderpolicyprofile_users', (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('authproviderpolicyprofile', models.ForeignKey(orm['im.authproviderpolicyprofile'], null=False)), ('astakosuser', models.ForeignKey(orm['im.astakosuser'], null=False)))) db.create_unique('im_authproviderpolicyprofile_users', ['authproviderpolicyprofile_id', 'astakosuser_id'])
def backwards(self, orm): # Adding unique constraint on 'Audience', fields ['name'] db.create_unique(u'storage_audience', ['name'])
def forwards(self, orm): # Adding model 'KernelVersion' db.create_table(u'schema_kernel_kernelversion', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')( unique=True, max_length=100)), ('pretty_kernel_version_name', self.gf('django.db.models.fields.CharField')( default='kernel version', max_length=100)), )) db.send_create_signal(u'schema_kernel', ['KernelVersion']) # Adding model 'PCIModule' db.create_table(u'schema_kernel_pcimodule', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=100)), ('version', self.gf('django.db.models.fields.CharField')( max_length=100, null=True, blank=True)), ('srcversion', self.gf('django.db.models.fields.CharField')( max_length=24, null=True, blank=True)), )) db.send_create_signal(u'schema_kernel', ['PCIModule']) # Adding unique constraint on 'PCIModule', fields ['name', 'version', 'srcversion'] db.create_unique(u'schema_kernel_pcimodule', ['name', 'version', 'srcversion']) # Adding M2M table for field kernelVersionModuleConnector on 'PCIModule' m2m_table_name = db.shorten_name( u'schema_kernel_pcimodule_kernelVersionModuleConnector') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('pcimodule', models.ForeignKey(orm[u'schema_kernel.pcimodule'], null=False)), ('kernelversion', models.ForeignKey(orm[u'schema_kernel.kernelversion'], null=False)))) db.create_unique(m2m_table_name, ['pcimodule_id', 'kernelversion_id']) # Adding model 'PCIAliases' db.create_table(u'schema_kernel_pcialiases', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('vendor', self.gf('django.db.models.fields.CharField')(max_length=4)), ('subvendor', self.gf('django.db.models.fields.CharField')(max_length=4)), ('device', self.gf('django.db.models.fields.CharField')(max_length=4)), ('subdevice', self.gf('django.db.models.fields.CharField')(max_length=4)), )) db.send_create_signal(u'schema_kernel', ['PCIAliases']) # Adding unique constraint on 'PCIAliases', fields ['vendor', 'subvendor', 'device', 'subdevice'] db.create_unique(u'schema_kernel_pcialiases', ['vendor', 'subvendor', 'device', 'subdevice']) # Adding M2M table for field module on 'PCIAliases' m2m_table_name = db.shorten_name(u'schema_kernel_pcialiases_module') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('pcialiases', models.ForeignKey(orm[u'schema_kernel.pcialiases'], null=False)), ('pcimodule', models.ForeignKey(orm[u'schema_kernel.pcimodule'], null=False)))) db.create_unique(m2m_table_name, ['pcialiases_id', 'pcimodule_id'])
def forwards(self, orm): # Adding model 'DocSolicitado' db.create_table(u'principal_docsolicitado', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('alumno', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.Alumno'])), ('tipo_doc', self.gf('django.db.models.fields.CharField')(max_length=15)), ('solicitudes_hechas', self.gf('django.db.models.fields.IntegerField')(default=0)), ('alumno_kardex', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.kardex'])), )) db.send_create_signal(u'principal', ['DocSolicitado']) # Adding unique constraint on 'DocSolicitado', fields ['alumno', 'tipo_doc'] db.create_unique(u'principal_docsolicitado', ['alumno_id', 'tipo_doc']) # Adding model 'SaberesPrevios' db.create_table(u'principal_saberesprevios', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('Alumno', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.Alumno'])), ('Materia', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.Materia'])), ('Calificacion', self.gf('django.db.models.fields.IntegerField')( null=True, blank=True)), )) db.send_create_signal(u'principal', ['SaberesPrevios']) # Adding unique constraint on 'SaberesPrevios', fields ['Alumno', 'Materia'] db.create_unique(u'principal_saberesprevios', ['Alumno_id', 'Materia_id']) # Adding model 'kardex' db.create_table(u'principal_kardex', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('alumno', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.Alumno'])), ('materia', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.Materia'])), ('calificacion', self.gf('django.db.models.fields.IntegerField')( null=True, blank=True)), ('alumno_grupo', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.AlumnoTomaClaseEnGrupo'])), ('total_creditos', self.gf('django.db.models.fields.FloatField')( null=True, blank=True)), ('evaluacion', self.gf('django.db.models.fields.CharField')( max_length=4, null=True)), )) db.send_create_signal(u'principal', ['kardex']) # Adding unique constraint on 'kardex', fields ['alumno', 'materia'] db.create_unique(u'principal_kardex', ['alumno_id', 'materia_id']) # Adding model 'EvaluacionProfesor' db.create_table(u'principal_evaluacionprofesor', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('alumno', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.Alumno'])), ('profesor', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.Profesor'])), ('materia', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['principal.Materia'])), ('pregunta1', self.gf('django.db.models.fields.IntegerField')(null=True)), ('pregunta2', self.gf('django.db.models.fields.IntegerField')(null=True)), ('pregunta3', self.gf('django.db.models.fields.IntegerField')(null=True)), ('pregunta4', self.gf('django.db.models.fields.IntegerField')(null=True)), ('pregunta5', self.gf('django.db.models.fields.IntegerField')(null=True)), )) db.send_create_signal(u'principal', ['EvaluacionProfesor']) # Adding unique constraint on 'EvaluacionProfesor', fields ['alumno', 'profesor', 'materia'] db.create_unique(u'principal_evaluacionprofesor', ['alumno_id', 'profesor_id', 'materia_id'])
def forwards(self, orm): # Adding model 'SteamPlayer' db.create_table('dotastats_steamplayer', ( ('steamid', self.gf('django.db.models.fields.BigIntegerField')( unique=True, primary_key=True)), ('last_refresh', self.gf('django.db.models.fields.DateTimeField')( auto_now=True, auto_now_add=True, db_index=True, blank=True)), ('personaname', self.gf('django.db.models.fields.TextField')()), ('profileurl', self.gf('django.db.models.fields.TextField')(blank=True)), ('avatar', self.gf('django.db.models.fields.TextField')(blank=True)), ('avatarmedium', self.gf('django.db.models.fields.TextField')(blank=True)), ('avatarfull', self.gf('django.db.models.fields.TextField')(blank=True)), ('lastlogoff', self.gf('django.db.models.fields.DateTimeField')(null=True)), )) db.send_create_signal('dotastats', ['SteamPlayer']) # Adding model 'Items' db.create_table('dotastats_items', ( ('item_id', self.gf('django.db.models.fields.IntegerField')( primary_key=True)), ('client_name', self.gf('django.db.models.fields.TextField')()), )) db.send_create_signal('dotastats', ['Items']) # Adding model 'Heroes' db.create_table('dotastats_heroes', ( ('hero_id', self.gf('django.db.models.fields.IntegerField')( primary_key=True)), ('client_name', self.gf('django.db.models.fields.TextField')()), ('dota2_name', self.gf('django.db.models.fields.TextField')()), )) db.send_create_signal('dotastats', ['Heroes']) # Adding model 'MatchHistoryQueue' db.create_table('dotastats_matchhistoryqueue', ( ('match_id', self.gf('django.db.models.fields.BigIntegerField')( unique=True, primary_key=True)), ('last_refresh', self.gf('django.db.models.fields.DateTimeField')( auto_now=True, auto_now_add=True, blank=True)), ('match_seq_num', self.gf('django.db.models.fields.BigIntegerField')()), ('start_time', self.gf('django.db.models.fields.DateTimeField')()), ('lobby_type', self.gf('django.db.models.fields.IntegerField')()), )) db.send_create_signal('dotastats', ['MatchHistoryQueue']) # Adding model 'MatchHistoryQueuePlayers' db.create_table('dotastats_matchhistoryqueueplayers', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('match_history_queue', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['dotastats.MatchHistoryQueue'])), ('account_id', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', null=True, db_column='account_id', to=orm['dotastats.SteamPlayer'])), ('player_slot', self.gf('django.db.models.fields.IntegerField')()), ('hero_id', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', db_column='hero_id', to=orm['dotastats.Heroes'])), ('is_bot', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal('dotastats', ['MatchHistoryQueuePlayers']) # Adding unique constraint on 'MatchHistoryQueuePlayers', fields ['match_history_queue', 'hero_id', 'player_slot'] db.create_unique('dotastats_matchhistoryqueueplayers', ['match_history_queue_id', 'hero_id', 'player_slot']) # Adding model 'MatchDetails' db.create_table('dotastats_matchdetails', ( ('match_id', self.gf('django.db.models.fields.BigIntegerField')( unique=True, primary_key=True)), ('last_refresh', self.gf('django.db.models.fields.DateTimeField')( auto_now=True, auto_now_add=True, blank=True)), ('match_seq_num', self.gf('django.db.models.fields.BigIntegerField')()), ('season', self.gf('django.db.models.fields.IntegerField')()), ('radiant_win', self.gf('django.db.models.fields.BooleanField')(default=False)), ('duration', self.gf('django.db.models.fields.IntegerField')()), ('start_time', self.gf('django.db.models.fields.DateTimeField')()), ('tower_status_radiant', self.gf('django.db.models.fields.IntegerField')()), ('tower_status_dire', self.gf('django.db.models.fields.IntegerField')()), ('barracks_status_radiant', self.gf('django.db.models.fields.IntegerField')()), ('barracks_status_dire', self.gf('django.db.models.fields.IntegerField')()), ('cluster', self.gf('django.db.models.fields.IntegerField')()), ('first_blood_time', self.gf('django.db.models.fields.IntegerField')()), ('lobby_type', self.gf('django.db.models.fields.IntegerField')()), ('human_players', self.gf('django.db.models.fields.IntegerField')()), ('leagueid', self.gf('django.db.models.fields.IntegerField')()), ('positive_votes', self.gf('django.db.models.fields.IntegerField')()), ('negative_votes', self.gf('django.db.models.fields.IntegerField')()), ('game_mode', self.gf('django.db.models.fields.IntegerField')()), )) db.send_create_signal('dotastats', ['MatchDetails']) # Adding model 'MatchPicksBans' db.create_table('dotastats_matchpicksbans', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('match_details', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['dotastats.MatchDetails'])), ('is_pick', self.gf('django.db.models.fields.BooleanField')(default=False)), ('hero_id', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', db_column='hero_id', to=orm['dotastats.Heroes'])), ('team', self.gf('django.db.models.fields.IntegerField')()), ('order', self.gf('django.db.models.fields.IntegerField')()), )) db.send_create_signal('dotastats', ['MatchPicksBans']) # Adding unique constraint on 'MatchPicksBans', fields ['match_details', 'hero_id', 'order'] db.create_unique('dotastats_matchpicksbans', ['match_details_id', 'hero_id', 'order']) # Adding model 'MatchDetailsPlayerEntry' db.create_table('dotastats_matchdetailsplayerentry', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('match_details', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['dotastats.MatchDetails'])), ('account_id', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', null=True, db_column='account_id', to=orm['dotastats.SteamPlayer'])), ('player_slot', self.gf('django.db.models.fields.IntegerField')()), ('hero_id', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', db_column='hero_id', to=orm['dotastats.Heroes'])), ('item_0', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', null=True, db_column='item_0', to=orm['dotastats.Items'])), ('item_1', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', null=True, db_column='item_1', to=orm['dotastats.Items'])), ('item_2', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', null=True, db_column='item_2', to=orm['dotastats.Items'])), ('item_3', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', null=True, db_column='item_3', to=orm['dotastats.Items'])), ('item_4', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', null=True, db_column='item_4', to=orm['dotastats.Items'])), ('item_5', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', null=True, db_column='item_5', to=orm['dotastats.Items'])), ('kills', self.gf('django.db.models.fields.IntegerField')()), ('deaths', self.gf('django.db.models.fields.IntegerField')()), ('assists', self.gf('django.db.models.fields.IntegerField')()), ('leaver_status', self.gf('django.db.models.fields.IntegerField')(null=True)), ('gold', self.gf('django.db.models.fields.IntegerField')()), ('last_hits', self.gf('django.db.models.fields.IntegerField')()), ('denies', self.gf('django.db.models.fields.IntegerField')()), ('gold_per_min', self.gf('django.db.models.fields.IntegerField')()), ('xp_per_min', self.gf('django.db.models.fields.IntegerField')()), ('gold_spent', self.gf('django.db.models.fields.IntegerField')()), ('hero_damage', self.gf('django.db.models.fields.IntegerField')()), ('tower_damage', self.gf('django.db.models.fields.IntegerField')()), ('hero_healing', self.gf('django.db.models.fields.IntegerField')()), ('level', self.gf('django.db.models.fields.IntegerField')()), ('ability_upgrades', self.gf('django.db.models.fields.TextField')(null=True)), ('is_bot', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal('dotastats', ['MatchDetailsPlayerEntry']) # Adding unique constraint on 'MatchDetailsPlayerEntry', fields ['match_details', 'hero_id', 'player_slot'] db.create_unique('dotastats_matchdetailsplayerentry', ['match_details_id', 'hero_id', 'player_slot'])
def forwards(self, orm): # Adding unique constraint on 'School', fields ['name'] db.create_unique('bowls_school', ['name'])
def forwards(self, orm): # Adding model 'Tag' db.create_table('opendata_tag', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('tag_name', self.gf('django.db.models.fields.CharField')(max_length=150)), )) db.send_create_signal('opendata', ['Tag']) # Adding model 'DataType' db.create_table('opendata_datatype', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('data_type', self.gf('django.db.models.fields.CharField')(max_length=50)), )) db.send_create_signal('opendata', ['DataType']) # Adding model 'UrlType' db.create_table('opendata_urltype', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('url_type', self.gf('django.db.models.fields.CharField')(max_length=50)), )) db.send_create_signal('opendata', ['UrlType']) # Adding model 'UpdateFrequency' db.create_table('opendata_updatefrequency', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('update_frequency', self.gf('django.db.models.fields.CharField')(max_length=50)), )) db.send_create_signal('opendata', ['UpdateFrequency']) # Adding model 'CoordSystem' db.create_table('opendata_coordsystem', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=255)), ('description', self.gf('django.db.models.fields.TextField')()), ('EPSG_code', self.gf('django.db.models.fields.IntegerField')(blank=True)), )) db.send_create_signal('opendata', ['CoordSystem']) # Adding model 'Resource' db.create_table('opendata_resource', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=255)), ('short_description', self.gf('django.db.models.fields.CharField')(max_length=255)), ('release_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), ('time_period', self.gf('django.db.models.fields.CharField')(max_length=50, blank=True)), ('organization', self.gf('django.db.models.fields.CharField')(max_length=255)), ('division', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), ('usage', self.gf('django.db.models.fields.TextField')()), ('description', self.gf('django.db.models.fields.TextField')()), ('contact_phone', self.gf('django.db.models.fields.CharField')(max_length=50, blank=True)), ('contact_email', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), ('contact_url', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), ('updates', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['opendata.UpdateFrequency'], null=True, blank=True)), ('area_of_interest', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), ('is_published', self.gf('django.db.models.fields.BooleanField')(default=True)), ('created_by', self.gf('django.db.models.fields.related.ForeignKey')(related_name='created_by', to=orm['auth.User'])), ('last_updated_by', self.gf('django.db.models.fields.related.ForeignKey')(related_name='updated_by', to=orm['auth.User'])), ('created', self.gf('django.db.models.fields.DateTimeField')()), ('last_updated', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('metadata_contact', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), ('metadata_notes', self.gf('django.db.models.fields.TextField')(blank=True)), ('update_frequency', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), ('data_formats', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), ('proj_coord_sys', self.gf('django.db.models.fields.CharField')(max_length=255, 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('opendata', ['Resource']) # Adding M2M table for field tags on 'Resource' db.create_table('opendata_resource_tags', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('resource', models.ForeignKey(orm['opendata.resource'], null=False)), ('tag', models.ForeignKey(orm['opendata.tag'], null=False)) )) db.create_unique('opendata_resource_tags', ['resource_id', 'tag_id']) # Adding M2M table for field data_types on 'Resource' db.create_table('opendata_resource_data_types', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('resource', models.ForeignKey(orm['opendata.resource'], null=False)), ('datatype', models.ForeignKey(orm['opendata.datatype'], null=False)) )) db.create_unique('opendata_resource_data_types', ['resource_id', 'datatype_id']) # Adding M2M table for field coord_sys on 'Resource' db.create_table('opendata_resource_coord_sys', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('resource', models.ForeignKey(orm['opendata.resource'], null=False)), ('coordsystem', models.ForeignKey(orm['opendata.coordsystem'], null=False)) )) db.create_unique('opendata_resource_coord_sys', ['resource_id', 'coordsystem_id']) # Adding model 'Url' db.create_table('opendata_url', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('url', self.gf('django.db.models.fields.CharField')(max_length=255)), ('url_label', self.gf('django.db.models.fields.CharField')(max_length=255)), ('url_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['opendata.UrlType'])), ('resource', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['opendata.Resource'])), )) db.send_create_signal('opendata', ['Url']) # Adding model 'UrlImage' db.create_table('opendata_urlimage', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('url', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['opendata.Url'])), ('image', self.gf('django.db.models.fields.files.ImageField')(max_length=100)), ('title', self.gf('django.db.models.fields.CharField')(max_length=255)), ('source', self.gf('django.db.models.fields.CharField')(max_length=255)), ('source_url', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), )) db.send_create_signal('opendata', ['UrlImage']) # Adding model 'Idea' db.create_table('opendata_idea', ( ('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')()), ('author', self.gf('django.db.models.fields.CharField')(max_length=255)), ('created_by', self.gf('django.db.models.fields.related.ForeignKey')(related_name='idea_created_by', to=orm['auth.User'])), ('created_by_date', self.gf('django.db.models.fields.DateTimeField')()), ('updated_by', self.gf('django.db.models.fields.related.ForeignKey')(related_name='idea_updated_by', to=orm['auth.User'])), ('updated_by_date', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), )) db.send_create_signal('opendata', ['Idea']) # Adding M2M table for field resources on 'Idea' db.create_table('opendata_idea_resources', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('idea', models.ForeignKey(orm['opendata.idea'], null=False)), ('resource', models.ForeignKey(orm['opendata.resource'], null=False)) )) db.create_unique('opendata_idea_resources', ['idea_id', 'resource_id']) # Adding model 'IdeaImage' db.create_table('opendata_ideaimage', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('idea', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['opendata.Idea'])), ('image', self.gf('django.db.models.fields.files.ImageField')(max_length=100)), ('title', self.gf('django.db.models.fields.CharField')(max_length=255)), ('source', self.gf('django.db.models.fields.CharField')(max_length=255)), ('source_url', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), ('home_page', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal('opendata', ['IdeaImage']) # Adding model 'Submission' db.create_table('opendata_submission', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'])), ('sent_date', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('email_text', self.gf('django.db.models.fields.TextField')()), )) db.send_create_signal('opendata', ['Submission']) # Adding model 'TwitterCache' db.create_table('opendata_twittercache', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('text', self.gf('django.db.models.fields.TextField')()), )) db.send_create_signal('opendata', ['TwitterCache']) # Adding model 'ODPUserProfile' db.create_table('opendata_odpuserprofile', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('organization', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)), ('can_notify', self.gf('django.db.models.fields.BooleanField')(default=False)), ('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], unique=True)), )) db.send_create_signal('opendata', ['ODPUserProfile'])
def forwards(self, orm): # Removing unique constraint on 'iSCSITargetToExtent', fields ['iscsi_extent'] db.delete_unique(u'services_iscsitargettoextent', ['iscsi_extent_id']) # Adding unique constraint on 'iSCSITargetToExtent', fields ['iscsi_target', 'iscsi_extent'] db.create_unique(u'services_iscsitargettoextent', ['iscsi_target_id', 'iscsi_extent_id'])
def forwards(self, orm): # Adding unique constraint on 'SocialAccount', fields ['uid', 'provider'] db.create_unique('socialaccount_socialaccount', ['uid', 'provider'])
def forwards(self, orm): # Adding model 'User' db.create_table(u'cm_user', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('memory', self.gf('django.db.models.fields.IntegerField')()), ('cpu', self.gf('django.db.models.fields.IntegerField')()), ('storage', self.gf('django.db.models.fields.IntegerField')()), ('public_ip', self.gf('django.db.models.fields.IntegerField')()), ('points', self.gf('django.db.models.fields.IntegerField')()), )) db.send_create_signal('cm', ['User']) # Adding model 'Admin' db.create_table(u'cm_admin', ( ('user', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['cm.User'], unique=True, primary_key=True)), ('password', self.gf('django.db.models.fields.CharField')(max_length=256)), )) db.send_create_signal('cm', ['Admin']) # Adding model 'Lease' db.create_table(u'cm_lease', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('address', self.gf('django.db.models.fields.CharField')(max_length=20)), ('user_network', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.UserNetwork'])), ('vm', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.VM'], null=True, blank=True)), )) db.send_create_signal('cm', ['Lease']) # Adding model 'UserNetwork' db.create_table(u'cm_usernetwork', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('address', self.gf('django.db.models.fields.CharField')(max_length=20)), ('mask', self.gf('django.db.models.fields.IntegerField')()), ('available_network', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.AvailableNetwork'])), ('user', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.User'])), ('name', self.gf('django.db.models.fields.CharField')(max_length=200)), )) db.send_create_signal('cm', ['UserNetwork']) # Adding model 'AvailableNetwork' db.create_table(u'cm_availablenetwork', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('address', self.gf('django.db.models.fields.CharField')(max_length=20)), ('mask', self.gf('django.db.models.fields.IntegerField')()), ('state', self.gf('django.db.models.fields.IntegerField')()), )) db.send_create_signal('cm', ['AvailableNetwork']) # Adding model 'Node' db.create_table(u'cm_node', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('username', self.gf('django.db.models.fields.CharField')(max_length=30)), ('address', self.gf('django.db.models.fields.CharField')(max_length=45)), ('transport', self.gf('django.db.models.fields.CharField')(max_length=45)), ('driver', self.gf('django.db.models.fields.CharField')(max_length=45)), ('suffix', self.gf('django.db.models.fields.CharField')(max_length=20)), ('cpu_total', self.gf('django.db.models.fields.IntegerField')()), ('memory_total', self.gf('django.db.models.fields.IntegerField')()), ('hdd_total', self.gf('django.db.models.fields.IntegerField')()), ('state', self.gf('django.db.models.fields.IntegerField')()), ('comment', self.gf('django.db.models.fields.TextField')( null=True, blank=True)), )) db.send_create_signal('cm', ['Node']) # Adding model 'PublicIP' db.create_table(u'cm_publicip', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('address', self.gf('django.db.models.fields.IPAddressField')(max_length=15)), ('lease', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.Lease'], null=True, blank=True)), ('user', self.gf('django.db.models.fields.related.ForeignKey')( blank=True, related_name='public_ips', null=True, to=orm['cm.User'])), )) db.send_create_signal('cm', ['PublicIP']) # Adding model 'Template' db.create_table(u'cm_template', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=45)), ('description', self.gf('django.db.models.fields.CharField')(max_length=512)), ('memory', self.gf('django.db.models.fields.IntegerField')()), ('cpu', self.gf('django.db.models.fields.IntegerField')()), ('state', self.gf('django.db.models.fields.IntegerField')()), ('points', self.gf('django.db.models.fields.IntegerField')()), ('ec2name', self.gf('django.db.models.fields.IntegerField')(default=0)), )) db.send_create_signal('cm', ['Template']) # Adding model 'Farm' db.create_table(u'cm_farm', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('user', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.User'])), ('name', self.gf('django.db.models.fields.CharField')(max_length=128)), ('description', self.gf('django.db.models.fields.TextField')( null=True, blank=True)), ('state', self.gf('django.db.models.fields.IntegerField')()), ('head', self.gf('django.db.models.fields.related.ForeignKey')( related_name='+', to=orm['cm.VM'])), )) db.send_create_signal('cm', ['Farm']) # Adding model 'Storage' db.create_table(u'cm_storage', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=256)), ('capacity', self.gf('django.db.models.fields.IntegerField')()), ('state', self.gf('django.db.models.fields.IntegerField')(default=0)), ('address', self.gf('django.db.models.fields.CharField')( max_length=64, null=True)), ('dir', self.gf('django.db.models.fields.CharField')( max_length=256, null=True)), ('transport', self.gf('django.db.models.fields.CharField')( default='netfs', max_length=20)), )) db.send_create_signal('cm', ['Storage']) # Adding model 'Image' db.create_table(u'cm_image', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('type', self.gf('django.db.models.fields.CharField')( max_length=255, db_index=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=45)), ('description', self.gf('django.db.models.fields.CharField')(max_length=512)), ('user', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.User'])), ('disk_dev', self.gf('django.db.models.fields.IntegerField')( null=True, blank=True)), ('disk_controller', self.gf('django.db.models.fields.IntegerField')(default=0)), ('creation_date', self.gf('django.db.models.fields.DateTimeField')( default=datetime.datetime.now)), ('size', self.gf('django.db.models.fields.IntegerField')( null=True, blank=True)), ('state', self.gf('django.db.models.fields.SmallIntegerField')()), ('storage', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.Storage'], null=True, blank=True)), ('progress', self.gf('django.db.models.fields.IntegerField')(default=100)), ('access', self.gf('django.db.models.fields.SmallIntegerField')()), ('platform', self.gf('django.db.models.fields.IntegerField')(null=True)), ('network_device', self.gf('django.db.models.fields.IntegerField')( default=1, null=True)), ('video_device', self.gf('django.db.models.fields.IntegerField')( default=0, null=True)), ('vm', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.VM'], null=True, blank=True)), )) db.send_create_signal('cm', ['Image']) # Adding model 'VM' db.create_table(u'cm_vm', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=128)), ('node', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.Node'])), ('user', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.User'])), ('template', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.Template'])), ('system_image', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.Image'])), ('iso_image', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.Image'], null=True, blank=True)), ('libvirt_id', self.gf('django.db.models.fields.IntegerField')()), ('state', self.gf('django.db.models.fields.IntegerField')()), ('start_time', self.gf('django.db.models.fields.DateTimeField')()), ('stop_time', self.gf('django.db.models.fields.DateTimeField')( null=True, blank=True)), ('ctx_key', self.gf('django.db.models.fields.CharField')( max_length=128, null=True, blank=True)), ('ctx_api_version', self.gf('django.db.models.fields.CharField')( max_length=10, null=True, blank=True)), ('vnc_passwd', self.gf('django.db.models.fields.CharField')(max_length=45)), ('ssh_key', self.gf('django.db.models.fields.TextField')( null=True, blank=True)), ('ssh_username', self.gf('django.db.models.fields.CharField')( max_length=45, null=True, blank=True)), ('description', self.gf('django.db.models.fields.TextField')( null=True, blank=True)), ('save_vm', self.gf('django.db.models.fields.IntegerField')()), ('farm', self.gf('django.db.models.fields.related.ForeignKey')( related_name='vms', null=True, to=orm['cm.Farm'])), ('hostname', self.gf('django.db.models.fields.CharField')( max_length=256, null=True, blank=True)), ('vnc_port', self.gf('django.db.models.fields.IntegerField')()), ('vnc_enabled', self.gf('django.db.models.fields.IntegerField')(default=0)), ('reservation_id', self.gf('django.db.models.fields.IntegerField')(default=0)), ('user_data', self.gf('django.db.models.fields.CharField')( max_length=32768, null=True, blank=True)), )) db.send_create_signal('cm', ['VM']) # Adding model 'Command' db.create_table(u'cm_command', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=1000)), ('args', self.gf('django.db.models.fields.CharField')(max_length=100000)), ('state', self.gf('django.db.models.fields.IntegerField')()), ('response', self.gf('django.db.models.fields.CharField')( max_length=100000, null=True)), ('vm', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.VM'])), )) db.send_create_signal('cm', ['Command']) # Adding model 'SystemImageGroup' db.create_table(u'cm_systemimagegroup', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('group_id', self.gf('django.db.models.fields.IntegerField')()), ('image', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['cm.Image'])), )) db.send_create_signal('cm', ['SystemImageGroup']) # Adding unique constraint on 'SystemImageGroup', fields ['group_id', 'image'] db.create_unique(u'cm_systemimagegroup', ['group_id', 'image_id'])
def forwards(self, orm): # Adding model 'Artist' db.create_table('jukebox_core_artist', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('Name', self.gf('django.db.models.fields.CharField')(max_length=200)), )) db.send_create_signal('jukebox_core', ['Artist']) # Adding model 'Genre' db.create_table('jukebox_core_genre', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('Name', self.gf('django.db.models.fields.CharField')(max_length=200)), )) db.send_create_signal('jukebox_core', ['Genre']) # Adding model 'Album' db.create_table('jukebox_core_album', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('Title', self.gf('django.db.models.fields.CharField')(max_length=200)), ('Artist', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['jukebox_core.Artist'])), )) db.send_create_signal('jukebox_core', ['Album']) # Adding model 'Song' db.create_table('jukebox_core_song', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('Artist', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['jukebox_core.Artist'])), ('Album', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['jukebox_core.Album'], null=True)), ('Genre', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['jukebox_core.Genre'], null=True)), ('Title', self.gf('django.db.models.fields.CharField')(max_length=200)), ('Year', self.gf('django.db.models.fields.IntegerField')(null=True)), ('Length', self.gf('django.db.models.fields.IntegerField')()), ('Filename', self.gf('django.db.models.fields.CharField')(max_length=1000)), )) db.send_create_signal('jukebox_core', ['Song']) # Adding model 'Queue' db.create_table('jukebox_core_queue', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('Song', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['jukebox_core.Song'], unique=True)), ('Created', self.gf('django.db.models.fields.DateTimeField')( auto_now_add=True, blank=True)), )) db.send_create_signal('jukebox_core', ['Queue']) # Adding M2M table for field User on 'Queue' db.create_table( 'jukebox_core_queue_User', (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('queue', models.ForeignKey(orm['jukebox_core.queue'], null=False)), ('user', models.ForeignKey(orm['auth.user'], null=False)))) db.create_unique('jukebox_core_queue_User', ['queue_id', 'user_id']) # Adding model 'Favourite' db.create_table('jukebox_core_favourite', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('Song', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['jukebox_core.Song'])), ('User', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['auth.User'])), ('Created', self.gf('django.db.models.fields.DateTimeField')( auto_now_add=True, blank=True)), )) db.send_create_signal('jukebox_core', ['Favourite']) # Adding unique constraint on 'Favourite', fields ['Song', 'User'] db.create_unique('jukebox_core_favourite', ['Song_id', 'User_id']) # Adding model 'History' db.create_table('jukebox_core_history', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('Song', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['jukebox_core.Song'])), ('Created', self.gf('django.db.models.fields.DateTimeField')( auto_now_add=True, blank=True)), )) db.send_create_signal('jukebox_core', ['History']) # Adding M2M table for field User on 'History' db.create_table( 'jukebox_core_history_User', (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('history', models.ForeignKey(orm['jukebox_core.history'], null=False)), ('user', models.ForeignKey(orm['auth.user'], null=False)))) db.create_unique('jukebox_core_history_User', ['history_id', 'user_id']) # Adding model 'Player' db.create_table('jukebox_core_player', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('Pid', self.gf('django.db.models.fields.IntegerField')()), )) db.send_create_signal('jukebox_core', ['Player'])
def forwards(self, orm): # Adding model 'Campaign' db.create_table('banner_rotator_campaign', ( ('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)), ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), )) db.send_create_signal('banner_rotator', ['Campaign']) # Adding model 'Place' db.create_table('banner_rotator_place', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=255)), ('slug', self.gf('django.db.models.fields.SlugField')(max_length=50)), ('width', self.gf('django.db.models.fields.SmallIntegerField')(default=None, null=True, blank=True)), ('height', self.gf('django.db.models.fields.SmallIntegerField')(default=None, null=True, blank=True)), )) db.send_create_signal('banner_rotator', ['Place']) # Adding unique constraint on 'Place', fields ['slug'] db.create_unique('banner_rotator_place', ['slug']) # Adding model 'Banner' db.create_table('banner_rotator_banner', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('campaign', self.gf('django.db.models.fields.related.ForeignKey')(default=None, related_name='banners', null=True, blank=True, to=orm['banner_rotator.Campaign'])), ('name', self.gf('django.db.models.fields.CharField')(max_length=255)), ('alt', self.gf('django.db.models.fields.CharField')(default='', max_length=255, blank=True)), ('url', self.gf('django.db.models.fields.URLField')(max_length=200)), ('url_target', self.gf('django.db.models.fields.CharField')(default='', max_length=10)), ('views', self.gf('django.db.models.fields.IntegerField')(default=0)), ('clicks', self.gf('django.db.models.fields.IntegerField')(default=0)), ('max_views', self.gf('django.db.models.fields.IntegerField')(default=0)), ('max_clicks', self.gf('django.db.models.fields.IntegerField')(default=0)), ('weight', self.gf('django.db.models.fields.IntegerField')()), ('file', self.gf('django.db.models.fields.files.FileField')(max_length=100)), ('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)), ('start_at', self.gf('django.db.models.fields.DateTimeField')(default=None, null=True, blank=True)), ('finish_at', self.gf('django.db.models.fields.DateTimeField')(default=None, null=True, blank=True)), ('is_active', self.gf('django.db.models.fields.BooleanField')(default=True)), )) db.send_create_signal('banner_rotator', ['Banner']) # Adding M2M table for field places on 'Banner' db.create_table('banner_rotator_banner_places', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('banner', models.ForeignKey(orm['banner_rotator.banner'], null=False)), ('place', models.ForeignKey(orm['banner_rotator.place'], null=False)) )) db.create_unique('banner_rotator_banner_places', ['banner_id', 'place_id']) # Adding model 'Click' db.create_table('banner_rotator_click', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('banner', self.gf('django.db.models.fields.related.ForeignKey')(related_name='clicks_list', to=orm['banner_rotator.Banner'])), ('place', self.gf('django.db.models.fields.related.ForeignKey')(default=None, related_name='clicks_list', null=True, to=orm['banner_rotator.Place'])), ('user', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='banner_clicks', null=True, to=orm['auth.User'])), ('datetime', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), ('ip', self.gf('django.db.models.fields.IPAddressField')(max_length=15, null=True, blank=True)), ('user_agent', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)), ('referrer', self.gf('django.db.models.fields.URLField')(max_length=200, null=True, blank=True)), )) db.send_create_signal('banner_rotator', ['Click'])
def forwards(self, orm): # Adding model 'Page' db.create_table(u'wiki_page', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')( unique=True, max_length=255)), ('current_revision', self.gf('django.db.models.fields.related.OneToOneField')( blank=True, related_name='revision_page', unique=True, null=True, to=orm['wiki.PageRevision'])), )) db.send_create_signal(u'wiki', ['Page']) # Adding M2M table for field tags on 'Page' m2m_table_name = db.shorten_name(u'wiki_page_tags') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('page', models.ForeignKey(orm[u'wiki.page'], null=False)), ('tag', models.ForeignKey(orm[u'tags.tag'], null=False)))) db.create_unique(m2m_table_name, ['page_id', 'tag_id']) # Adding model 'PageRevision' db.create_table(u'wiki_pagerevision', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('revision_number', self.gf('django.db.models.fields.IntegerField')()), ('revision_summary', self.gf('django.db.models.fields.CharField')( max_length=20, blank=True)), ('modified_date', self.gf('django.db.models.fields.DateTimeField')( auto_now=True, blank=True)), ('author', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['users.User'])), ('content', self.gf('django.db.models.fields.TextField')(blank=True)), ('page', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['wiki.Page'])), ('total_chars', self.gf('django.db.models.fields.IntegerField')()), ('added_chars', self.gf('django.db.models.fields.IntegerField')()), ('deleted_chars', self.gf('django.db.models.fields.IntegerField')()), )) db.send_create_signal(u'wiki', ['PageRevision']) # Adding model 'PageComment' db.create_table(u'wiki_pagecomment', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('status', self.gf('django.db.models.fields.IntegerField')(default=0)), ('comment_type', self.gf('django.db.models.fields.IntegerField')( default='discuss')), ('issue', self.gf('django.db.models.fields.IntegerField')(null=True)), ('detail', self.gf('django.db.models.fields.TextField')(blank=True)), ('page', self.gf('django.db.models.fields.related.ForeignKey')( related_name='comments', to=orm['wiki.Page'])), ('init_revision', self.gf('django.db.models.fields.related.ForeignKey')( blank=True, related_name='comment_init', null=True, to=orm['wiki.PageRevision'])), ('final_revision', self.gf('django.db.models.fields.related.ForeignKey')( blank=True, related_name='comment_closed', null=True, to=orm['wiki.PageRevision'])), ('author', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['users.User'])), ('created', self.gf('django.db.models.fields.DateTimeField')()), ('modified', self.gf('django.db.models.fields.DateTimeField')( auto_now=True, blank=True)), )) db.send_create_signal(u'wiki', ['PageComment'])
def forwards(self, orm): # Adding model 'SurveyTranslation' db.create_table(u'multilingual_survey_survey_translation', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')(max_length=256)), ('language_code', self.gf('django.db.models.fields.CharField')( max_length=15, db_index=True)), ('master', self.gf('django.db.models.fields.related.ForeignKey')( related_name='translations', null=True, to=orm['multilingual_survey.Survey'])), )) db.send_create_signal(u'multilingual_survey', ['SurveyTranslation']) # Adding unique constraint on 'SurveyTranslation', fields ['language_code', 'master'] db.create_unique(u'multilingual_survey_survey_translation', ['language_code', 'master_id']) # Adding model 'Survey' db.create_table(u'multilingual_survey_survey', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('slug', self.gf('django.db.models.fields.SlugField')( unique=True, max_length=256)), )) db.send_create_signal(u'multilingual_survey', ['Survey']) # Adding model 'SurveyQuestionTranslation' db.create_table(u'multilingual_survey_surveyquestion_translation', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')(max_length=256)), ('content', self.gf('django.db.models.fields.TextField')()), ('language_code', self.gf('django.db.models.fields.CharField')( max_length=15, db_index=True)), ('master', self.gf('django.db.models.fields.related.ForeignKey')( related_name='translations', null=True, to=orm['multilingual_survey.SurveyQuestion'])), )) db.send_create_signal(u'multilingual_survey', ['SurveyQuestionTranslation']) # Adding unique constraint on 'SurveyQuestionTranslation', fields ['language_code', 'master'] db.create_unique(u'multilingual_survey_surveyquestion_translation', ['language_code', 'master_id']) # Adding model 'SurveyQuestion' db.create_table(u'multilingual_survey_surveyquestion', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('slug', self.gf('django.db.models.fields.SlugField')(max_length=256)), ('survey', self.gf('django.db.models.fields.related.ForeignKey')( related_name='questions', to=orm['multilingual_survey.Survey'])), ('is_multi_select', self.gf('django.db.models.fields.BooleanField')(default=False)), ('has_other_field', self.gf('django.db.models.fields.BooleanField')(default=False)), ('required', self.gf('django.db.models.fields.BooleanField')(default=False)), ('position', self.gf('django.db.models.fields.PositiveIntegerField')()), )) db.send_create_signal(u'multilingual_survey', ['SurveyQuestion']) # Adding unique constraint on 'SurveyQuestion', fields ['slug', 'survey'] db.create_unique(u'multilingual_survey_surveyquestion', ['slug', 'survey_id']) # Adding model 'SurveyAnswerTranslation' db.create_table(u'multilingual_survey_surveyanswer_translation', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')(max_length=256)), ('language_code', self.gf('django.db.models.fields.CharField')( max_length=15, db_index=True)), ('master', self.gf('django.db.models.fields.related.ForeignKey')( related_name='translations', null=True, to=orm['multilingual_survey.SurveyAnswer'])), )) db.send_create_signal(u'multilingual_survey', ['SurveyAnswerTranslation']) # Adding unique constraint on 'SurveyAnswerTranslation', fields ['language_code', 'master'] db.create_unique(u'multilingual_survey_surveyanswer_translation', ['language_code', 'master_id']) # Adding model 'SurveyAnswer' db.create_table(u'multilingual_survey_surveyanswer', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('slug', self.gf('django.db.models.fields.SlugField')(max_length=256)), ('question', self.gf('django.db.models.fields.related.ForeignKey')( related_name='answers', to=orm['multilingual_survey.SurveyQuestion'])), ('position', self.gf('django.db.models.fields.PositiveIntegerField')()), )) db.send_create_signal(u'multilingual_survey', ['SurveyAnswer']) # Adding unique constraint on 'SurveyAnswer', fields ['slug', 'question'] db.create_unique(u'multilingual_survey_surveyanswer', ['slug', 'question_id']) # Adding model 'SurveyResponse' db.create_table(u'multilingual_survey_surveyresponse', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('user', self.gf('django.db.models.fields.related.ForeignKey')( blank=True, related_name='responses', null=True, to=orm['auth.User'])), ('question', self.gf('django.db.models.fields.related.ForeignKey')( blank=True, related_name='responses', null=True, to=orm['multilingual_survey.SurveyQuestion'])), ('other_answer', self.gf('django.db.models.fields.CharField')( max_length=1024, blank=True)), ('date_created', self.gf('django.db.models.fields.DateTimeField')( auto_now_add=True, blank=True)), )) db.send_create_signal(u'multilingual_survey', ['SurveyResponse']) # Adding M2M table for field answer on 'SurveyResponse' m2m_table_name = db.shorten_name( u'multilingual_survey_surveyresponse_answer') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('surveyresponse', models.ForeignKey(orm[u'multilingual_survey.surveyresponse'], null=False)), ('surveyanswer', models.ForeignKey(orm[u'multilingual_survey.surveyanswer'], null=False)))) db.create_unique(m2m_table_name, ['surveyresponse_id', 'surveyanswer_id'])
def backwards(self, orm): # Adding unique constraint on 'NodeGroupInterface', fields ['ip_range_high'] db.create_unique(u'maasserver_nodegroupinterface', ['ip_range_high']) # Adding unique constraint on 'NodeGroupInterface', fields ['ip_range_low'] db.create_unique(u'maasserver_nodegroupinterface', ['ip_range_low'])
def backwards(self, orm): # Adding unique constraint on 'RatingUser', fields ['email'] db.create_unique(u'ratinguser_ratinguser', ['email'])
def test_unique(self): """ Tests creating/deleting unique constraints. """ db.create_table("test_unique2", [ ('id', models.AutoField(primary_key=True)), ]) db.create_table("test_unique", [ ('spam', models.BooleanField(default=False)), ('eggs', models.IntegerField()), ('ham', models.ForeignKey(db.mock_model('Unique2', 'test_unique2'))), ]) db.execute_deferred_sql() # Add a constraint db.create_unique("test_unique", ["spam"]) db.execute_deferred_sql() # Shouldn't do anything during dry-run db.dry_run = True db.delete_unique("test_unique", ["spam"]) db.dry_run = False db.delete_unique("test_unique", ["spam"]) db.create_unique("test_unique", ["spam"]) # Special preparations for Sql Server if db.backend_name == "pyodbc": db.execute("SET IDENTITY_INSERT test_unique2 ON;") db.execute("INSERT INTO test_unique2 (id) VALUES (1)") db.execute("INSERT INTO test_unique2 (id) VALUES (2)") db.commit_transaction() db.start_transaction() # Test it works TRUE = (True,) FALSE = (False,) db.execute("INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 0, 1)", TRUE) db.execute("INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 1, 2)", FALSE) try: db.execute("INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 2, 1)", FALSE) except: db.rollback_transaction() else: self.fail("Could insert non-unique item.") # Drop that, add one only on eggs db.delete_unique("test_unique", ["spam"]) db.execute("DELETE FROM test_unique") db.create_unique("test_unique", ["eggs"]) db.start_transaction() # Test similarly db.execute("INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 0, 1)", TRUE) db.execute("INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 1, 2)", FALSE) try: db.execute("INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 1, 1)", TRUE) except: db.rollback_transaction() else: self.fail("Could insert non-unique item.") # Drop those, test combined constraints db.delete_unique("test_unique", ["eggs"]) db.execute("DELETE FROM test_unique") db.create_unique("test_unique", ["spam", "eggs", "ham_id"]) db.start_transaction() # Test similarly db.execute("INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 0, 1)", TRUE) db.execute("INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 1, 1)", FALSE) try: db.execute("INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 0, 1)", TRUE) except: db.rollback_transaction() else: self.fail("Could insert non-unique pair.") db.delete_unique("test_unique", ["spam", "eggs", "ham_id"]) db.start_transaction()
def forwards(self, orm): # Adding unique constraint on 'Applicant', fields ['email'] db.create_unique('applications_applicant', ['email'])
def forwards(self, orm): # Adding model 'Category' db.create_table(u'webstore_category', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=50)), )) db.send_create_signal(u'webstore', ['Category']) # Adding model 'Product' db.create_table(u'webstore_product', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=100)), ('quantity', self.gf('django.db.models.fields.IntegerField')()), ('price', self.gf('django.db.models.fields.FloatField')()), ('category', self.gf('django.db.models.fields.related.ForeignKey')( related_name='products', to=orm['webstore.Category'])), ('image_url', self.gf('django.db.models.fields.URLField')(max_length=200)), )) db.send_create_signal(u'webstore', ['Product']) # Adding model 'Promotion' db.create_table(u'webstore_promotion', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=100)), ('description', self.gf('django.db.models.fields.TextField')()), ('percent', self.gf('django.db.models.fields.FloatField')()), ('start_date', self.gf('django.db.models.fields.DateField')( default=datetime.datetime(2014, 7, 8, 0, 0))), )) db.send_create_signal(u'webstore', ['Promotion']) # Adding M2M table for field products on 'Promotion' m2m_table_name = db.shorten_name(u'webstore_promotion_products') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('promotion', models.ForeignKey(orm[u'webstore.promotion'], null=False)), ('product', models.ForeignKey(orm[u'webstore.product'], null=False)))) db.create_unique(m2m_table_name, ['promotion_id', 'product_id']) # Adding model 'Discount' db.create_table(u'webstore_discount', ( (u'promotion_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['webstore.Promotion'], unique=True, primary_key=True)), ('end_date', self.gf('django.db.models.fields.DateField')( default=datetime.datetime(2014, 7, 8, 0, 0), null=True, blank=True)), )) db.send_create_signal(u'webstore', ['Discount']) # Adding model 'Coupon' db.create_table(u'webstore_coupon', ( (u'promotion_ptr', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['webstore.Promotion'], unique=True, primary_key=True)), ('code', self.gf('django.db.models.fields.CharField')(max_length=20)), ('volume', self.gf('django.db.models.fields.PositiveIntegerField')()), ('status', self.gf('django.db.models.fields.CharField')( default='1', max_length=1)), )) db.send_create_signal(u'webstore', ['Coupon']) # Adding model 'Rating' db.create_table(u'webstore_rating', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('value', self.gf('django.db.models.fields.IntegerField')()), ('product', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['webstore.Product'])), ('user', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['auth.User'])), )) db.send_create_signal(u'webstore', ['Rating']) # Adding model 'Cart' db.create_table(u'webstore_cart', ( (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'])), ('status', self.gf('django.db.models.fields.CharField')( default='0', max_length=1)), )) db.send_create_signal(u'webstore', ['Cart']) # Adding model 'Cart_Products' db.create_table(u'webstore_cart_products', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('product', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['webstore.Product'])), ('cart', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['webstore.Cart'])), ('quantity', self.gf('django.db.models.fields.IntegerField')()), ('price', self.gf('django.db.models.fields.FloatField')()), ('date_added', self.gf('django.db.models.fields.DateField')()), ('discount', self.gf('django.db.models.fields.related.ForeignKey')( default=None, to=orm['webstore.Promotion'], null=True, blank=True)), )) db.send_create_signal(u'webstore', ['Cart_Products']) # Adding model 'DeliveryDetails' db.create_table(u'webstore_deliverydetails', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('address', self.gf('django.db.models.fields.CharField')(max_length=100)), ('phonenumber', self.gf('phonenumber_field.modelfields.PhoneNumberField')( max_length=128)), ('user', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['auth.User'])), ('cart', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['webstore.Cart'])), )) db.send_create_signal(u'webstore', ['DeliveryDetails'])
def test_alter_unique(self): """ Tests that unique constraints are not affected when altering columns (that's handled by create_/delete_unique) """ db.create_table("test_alter_unique", [ ('spam', models.IntegerField()), ('eggs', models.IntegerField(unique=True)), ]) db.execute_deferred_sql() # Make sure the unique constraint is created db.execute('INSERT INTO test_alter_unique (spam, eggs) VALUES (0, 42)') db.commit_transaction() db.start_transaction() try: db.execute("INSERT INTO test_alter_unique (spam, eggs) VALUES (1, 42)") except: pass else: self.fail("Could insert the same integer twice into a unique field.") db.rollback_transaction() # Alter without unique=True (should not affect anything) db.alter_column("test_alter_unique", "eggs", models.IntegerField()) # Insertion should still fail db.start_transaction() try: db.execute("INSERT INTO test_alter_unique (spam, eggs) VALUES (1, 42)") except: pass else: self.fail("Could insert the same integer twice into a unique field after alter_column with unique=False.") db.rollback_transaction() # Delete the unique index/constraint if db.backend_name != "sqlite3": db.delete_unique("test_alter_unique", ["eggs"]) db.delete_table("test_alter_unique") db.start_transaction() # Test multi-field constraint db.create_table("test_alter_unique2", [ ('spam', models.IntegerField()), ('eggs', models.IntegerField()), ]) db.create_unique('test_alter_unique2', ('spam', 'eggs')) db.execute_deferred_sql() db.execute('INSERT INTO test_alter_unique2 (spam, eggs) VALUES (0, 42)') db.commit_transaction() # Verify that constraint works db.start_transaction() try: db.execute("INSERT INTO test_alter_unique2 (spam, eggs) VALUES (1, 42)") except: self.fail("Looks like multi-field unique constraint applied to only one field.") db.start_transaction() db.rollback_transaction() try: db.execute("INSERT INTO test_alter_unique2 (spam, eggs) VALUES (0, 43)") except: self.fail("Looks like multi-field unique constraint applied to only one field.") db.rollback_transaction() db.start_transaction() try: db.execute("INSERT INTO test_alter_unique2 (spam, eggs) VALUES (0, 42)") except: pass else: self.fail("Could insert the same integer twice into a unique field.") db.rollback_transaction() # Altering one column should not drop or modify multi-column constraint db.alter_column("test_alter_unique2", "eggs", models.CharField(max_length=10)) db.start_transaction() try: db.execute("INSERT INTO test_alter_unique2 (spam, eggs) VALUES (1, 42)") except: self.fail("Altering one column broken multi-column unique constraint.") db.start_transaction() db.rollback_transaction() try: db.execute("INSERT INTO test_alter_unique2 (spam, eggs) VALUES (0, 43)") except: self.fail("Altering one column broken multi-column unique constraint.") db.rollback_transaction() db.start_transaction() try: db.execute("INSERT INTO test_alter_unique2 (spam, eggs) VALUES (0, 42)") except: pass else: self.fail("Could insert the same integer twice into a unique field after alter_column with unique=False.") db.rollback_transaction() db.delete_table("test_alter_unique2") db.start_transaction()
def backwards(self, orm): # Adding unique constraint on 'Empresa', fields ['nombre'] db.create_unique(u'empresas_empresa', ['nombre'])
def forwards(self, orm): # Adding model 'College' db.create_table(u'alumni_college', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('code', self.gf('django.db.models.fields.CharField')( unique=True, max_length=255)), ('name', self.gf('django.db.models.fields.CharField')(max_length=255)), ('state', self.gf('localflavor.us.models.USStateField')( max_length=2, blank=True)), ('type', self.gf('django.db.models.fields.CharField')( max_length=60, blank=True)), )) db.send_create_signal(u'alumni', ['College']) # Adding model 'CollegeEnrollment' db.create_table(u'alumni_collegeenrollment', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('search_date', self.gf('django.db.models.fields.DateField')( null=True, blank=True)), ('college', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['alumni.College'])), ('program_years', self.gf('django.db.models.fields.CharField')( max_length=1, null=True, blank=True)), ('begin', self.gf('django.db.models.fields.DateField')( null=True, blank=True)), ('end', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), ('status', self.gf('django.db.models.fields.CharField')( max_length=1, null=True, blank=True)), ('graduated', self.gf('django.db.models.fields.BooleanField')(default=False)), ('graduation_date', self.gf('django.db.models.fields.DateField')( null=True, blank=True)), ('degree_title', self.gf('django.db.models.fields.CharField')( max_length=255, null=True, blank=True)), ('major', self.gf('django.db.models.fields.CharField')( max_length=255, null=True, blank=True)), ('alumni', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['alumni.Alumni'])), ('college_sequence', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), )) db.send_create_signal(u'alumni', ['CollegeEnrollment']) # Adding model 'AlumniStatus' db.create_table(u'alumni_alumnistatus', ( (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'alumni', ['AlumniStatus']) # Adding model 'Withdrawl' db.create_table(u'alumni_withdrawl', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('college', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['alumni.College'])), ('alumni', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['alumni.Alumni'])), ('date', self.gf('django.db.models.fields.DateField')( default=datetime.date.today)), ('semesters', self.gf('django.db.models.fields.DecimalField')( null=True, max_digits=5, decimal_places=3, blank=True)), ('from_enrollment', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal(u'alumni', ['Withdrawl']) # Adding model 'AlumniNoteCategory' db.create_table(u'alumni_alumninotecategory', ( (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'alumni', ['AlumniNoteCategory']) # Adding model 'AlumniNote' db.create_table(u'alumni_alumninote', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('category', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['alumni.AlumniNoteCategory'], null=True, blank=True)), ('note', self.gf('ckeditor.fields.RichTextField')()), ('alumni', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['alumni.Alumni'])), ('date', self.gf('django.db.models.fields.DateField')( auto_now_add=True, blank=True)), ('user', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['auth.User'], null=True, on_delete=models.SET_NULL, blank=True)), )) db.send_create_signal(u'alumni', ['AlumniNote']) # Adding model 'AlumniAction' db.create_table(u'alumni_alumniaction', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('title', self.gf('django.db.models.fields.CharField')(max_length=255)), ('note', self.gf('django.db.models.fields.TextField')(blank=True)), ('date', self.gf('django.db.models.fields.DateField')( default=datetime.date.today, null=True, blank=True)), ('user', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['auth.User'], null=True, on_delete=models.SET_NULL, blank=True)), )) db.send_create_signal(u'alumni', ['AlumniAction']) # Adding M2M table for field alumni on 'AlumniAction' m2m_table_name = db.shorten_name(u'alumni_alumniaction_alumni') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('alumniaction', models.ForeignKey(orm[u'alumni.alumniaction'], null=False)), ('alumni', models.ForeignKey(orm[u'alumni.alumni'], null=False)))) db.create_unique(m2m_table_name, ['alumniaction_id', 'alumni_id']) # Adding model 'AlumniEmail' db.create_table(u'alumni_alumniemail', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('email', self.gf('django.db.models.fields.EmailField')(max_length=75)), ('type', self.gf('django.db.models.fields.CharField')( max_length=255, null=True, blank=True)), ('alumni', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['alumni.Alumni'])), )) db.send_create_signal(u'alumni', ['AlumniEmail']) # Adding model 'AlumniPhoneNumber' db.create_table(u'alumni_alumniphonenumber', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('phone_number', self.gf('localflavor.us.models.PhoneNumberField')(max_length=20)), ('type', self.gf('django.db.models.fields.CharField')( max_length=255, null=True, blank=True)), ('alumni', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['alumni.Alumni'])), )) db.send_create_signal(u'alumni', ['AlumniPhoneNumber']) # Adding model 'Alumni' db.create_table(u'alumni_alumni', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('student', self.gf('django.db.models.fields.related.OneToOneField')( to=orm['sis.Student'], unique=True)), ('college', self.gf('django.db.models.fields.related.ForeignKey')( blank=True, related_name='college_student', null=True, to=orm['alumni.College'])), ('graduated', self.gf('django.db.models.fields.BooleanField')(default=False)), ('graduation_date', self.gf('django.db.models.fields.DateField')( null=True, blank=True)), ('college_override', self.gf('django.db.models.fields.BooleanField')(default=False)), ('status', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['alumni.AlumniStatus'], null=True, blank=True)), ('program_years', self.gf('django.db.models.fields.CharField')( max_length=1, null=True, blank=True)), ('semesters', self.gf('django.db.models.fields.CharField')( max_length='5', blank=True)), ('on_track', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal(u'alumni', ['Alumni'])