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'])
Example #2
0
    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'])
Example #4
0
    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'])
Example #5
0
    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'])
Example #7
0
    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))
Example #11
0
    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'])
Example #14
0
    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'])
Example #19
0
    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'])
Example #20
0
    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'])
Example #21
0
    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'])
Example #25
0
    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'])
Example #29
0
    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'])
Example #33
0
    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'])
Example #35
0
    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))
Example #39
0
    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'])
Example #41
0
    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'])
Example #42
0
    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'])
Example #43
0
    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'])
Example #44
0
 def forwards(self, orm):
     # Adding unique constraint on 'School', fields ['name']
     db.create_unique('bowls_school', ['name'])
Example #45
0
    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'])
Example #46
0
    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'])
Example #48
0
    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'])
Example #49
0
    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'])
Example #51
0
    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'])
Example #53
0
    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'])
Example #54
0
 def backwards(self, orm):
     # Adding unique constraint on 'RatingUser', fields ['email']
     db.create_unique(u'ratinguser_ratinguser', ['email'])
Example #55
0
    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'])
Example #57
0
    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'])
Example #58
0
    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'])
Example #60
0
    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'])