diff -r ed812f1f7592 -r c752fdee555b src/hdalab/migrations/0001_initial.py --- a/src/hdalab/migrations/0001_initial.py Tue Mar 17 22:10:17 2015 +0100 +++ b/src/hdalab/migrations/0001_initial.py Wed Mar 18 18:52:43 2015 +0100 @@ -1,135 +1,247 @@ -# encoding: utf-8 -from south.db import db -from south.v2 import SchemaMigration - -class Migration(SchemaMigration): - - depends_on = ( - ("hdabo", "0007_auto__add_folder"), - ) - - def forwards(self, orm): - - # Adding model 'WpCategory' - db.create_table('hdalab_wpcategory', ( #@UndefinedVariable - ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('label', self.gf('django.db.models.fields.CharField')(unique=True, max_length=2048)), - )) - db.send_create_signal('hdalab', ['WpCategory']) #@UndefinedVariable - - # Adding model 'TagWpCategory' - db.create_table('hdalab_tagwpcategory', ( #@UndefinedVariable - ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('tag', self.gf('django.db.models.fields.related.ForeignKey')(related_name='wp_categories', to=orm['hdabo.Tag'])), - ('wp_category', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdalab.WpCategory'])), - ('hidden', self.gf('django.db.models.fields.BooleanField')(default=False)), - )) - db.send_create_signal('hdalab', ['TagWpCategory']) #@UndefinedVariable +# -*- coding: utf-8 -*- +from __future__ import unicode_literals - # Adding unique constraint on 'TagWpCategory', fields ['tag', 'wp_category', 'hidden'] - db.create_unique('hdalab_tagwpcategory', ['tag_id', 'wp_category_id', 'hidden']) #@UndefinedVariable - - # Adding model 'TagInfobox' - db.create_table('hdalab_taginfobox', ( #@UndefinedVariable - ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('tag', self.gf('django.db.models.fields.related.ForeignKey')(related_name='infoboxes', to=orm['hdabo.Tag'])), - ('name', self.gf('django.db.models.fields.CharField')(max_length=2048)), - ('source', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), - ('revision_id', self.gf('django.db.models.fields.BigIntegerField')(null=True, blank=True)), - )) - db.send_create_signal('hdalab', ['TagInfobox']) #@UndefinedVariable - - # Adding unique constraint on 'TagInfobox', fields ['tag', 'name', 'revision_id'] - db.create_unique('hdalab_taginfobox', ['tag_id', 'name', 'revision_id']) #@UndefinedVariable - - # Adding model 'InfoboxParameter' - db.create_table('hdalab_infoboxparameter', ( #@UndefinedVariable - ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('tag_infobox', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['hdalab.TagInfobox'])), - ('param_name', self.gf('django.db.models.fields.CharField')(max_length=2048)), - ('param_value', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), - )) - db.send_create_signal('hdalab', ['InfoboxParameter']) #@UndefinedVariable - - # Adding unique constraint on 'InfoboxParameter', fields ['tag_infobox', 'param_name'] - db.create_unique('hdalab_infoboxparameter', ['tag_infobox_id', 'param_name']) #@UndefinedVariable +from django.db import models, migrations +import hdalab.fields +from django.conf import settings - def backwards(self, orm): - - # Removing unique constraint on 'InfoboxParameter', fields ['tag_infobox', 'param_name'] - db.delete_unique('hdalab_infoboxparameter', ['tag_infobox_id', 'param_name']) #@UndefinedVariable - - # Removing unique constraint on 'TagInfobox', fields ['tag', 'name', 'revision_id'] - db.delete_unique('hdalab_taginfobox', ['tag_id', 'name', 'revision_id']) #@UndefinedVariable - - # Removing unique constraint on 'TagWpCategory', fields ['tag', 'wp_category', 'hidden'] - db.delete_unique('hdalab_tagwpcategory', ['tag_id', 'wp_category_id', 'hidden']) #@UndefinedVariable +class Migration(migrations.Migration): - # Deleting model 'WpCategory' - db.delete_table('hdalab_wpcategory') #@UndefinedVariable - - # Deleting model 'TagWpCategory' - db.delete_table('hdalab_tagwpcategory') #@UndefinedVariable - - # Deleting model 'TagInfobox' - db.delete_table('hdalab_taginfobox') #@UndefinedVariable - - # Deleting model 'InfoboxParameter' - db.delete_table('hdalab_infoboxparameter') #@UndefinedVariable - + dependencies = [ + ('hdabo', '0001_initial'), + migrations.swappable_dependency(settings.AUTH_USER_MODEL), + ('renkanmanager', '0001_initial'), + ] - models = { - 'hdabo.tag': { - 'Meta': {'unique_together': "(('label', 'original_label', 'url_status'),)", 'object_name': 'Tag'}, - 'alias': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}), - 'alternative_label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}), - 'alternative_wikipedia_pageid': ('django.db.models.fields.BigIntegerField', [], {'null': 'True', 'blank': 'True'}), - 'alternative_wikipedia_url': ('django.db.models.fields.URLField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}), - 'category': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.TagCategory']", 'null': 'True', 'blank': 'True'}), - 'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), - 'dbpedia_uri': ('django.db.models.fields.URLField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}), - 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}), - 'normalized_label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}), - 'original_label': ('django.db.models.fields.CharField', [], {'max_length': '1024'}), - 'popularity': ('django.db.models.fields.IntegerField', [], {'default': '0', 'db_index': 'True'}), - 'url_status': ('django.db.models.fields.IntegerField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}), - 'wikipedia_pageid': ('django.db.models.fields.BigIntegerField', [], {'null': 'True', 'blank': 'True'}), - 'wikipedia_url': ('django.db.models.fields.URLField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}) - }, - 'hdabo.tagcategory': { - 'Meta': {'object_name': 'TagCategory'}, - 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'label': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '512'}) - }, - 'hdalab.infoboxparameter': { - 'Meta': {'unique_together': "(('tag_infobox', 'param_name'),)", 'object_name': 'InfoboxParameter'}, - 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'param_name': ('django.db.models.fields.CharField', [], {'max_length': '2048'}), - 'param_value': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), - 'tag_infobox': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdalab.TagInfobox']"}) - }, - 'hdalab.taginfobox': { - 'Meta': {'unique_together': "(('tag', 'name', 'revision_id'),)", 'object_name': 'TagInfobox'}, - 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'name': ('django.db.models.fields.CharField', [], {'max_length': '2048'}), - 'revision_id': ('django.db.models.fields.BigIntegerField', [], {'null': 'True', 'blank': 'True'}), - 'source': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), - 'tag': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'infoboxes'", 'to': "orm['hdabo.Tag']"}) - }, - 'hdalab.tagwpcategory': { - 'Meta': {'unique_together': "(('tag', 'wp_category', 'hidden'),)", 'object_name': 'TagWpCategory'}, - 'hidden': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), - 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'tag': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'wp_categories'", 'to': "orm['hdabo.Tag']"}), - 'wp_category': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdalab.WpCategory']"}) - }, - 'hdalab.wpcategory': { - 'Meta': {'object_name': 'WpCategory'}, - 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'label': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2048'}) - } - } - - complete_apps = ['hdalab'] + operations = [ + migrations.CreateModel( + name='Country', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('dbpedia_uri', models.URLField(unique=True, max_length=255, db_index=True)), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='DatasheetExtras', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('datasheet', models.OneToOneField(related_name='extras', to='hdabo.Datasheet')), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='DbpediaFields', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('dbpedia_uri', models.URLField(max_length=2048, db_index=True)), + ('abstract', models.TextField(null=True, blank=True)), + ('thumbnail', models.URLField(max_length=2048, null=True, blank=True)), + ('label', models.CharField(max_length=2048, null=True, blank=True)), + ('tag', hdalab.fields.OneToOneField(related_name='dbpedia_fields', to='hdabo.Tag', related_default=b'lambda:')), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='DbpediaFieldsTranslation', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('language_code', models.CharField(max_length=15, db_index=True)), + ('label', models.CharField(max_length=2048, blank=True)), + ('abstract', models.TextField(null=True, blank=True)), + ('is_label_translated', models.BooleanField(default=True)), + ('is_abstract_translated', models.BooleanField(default=True)), + ('master', models.ForeignKey(related_name='translations', to='hdalab.DbpediaFields')), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='GeoInclusion', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('country', models.ForeignKey(related_name='includes', to='hdalab.Country')), + ('tag', models.OneToOneField(related_name='locatedin', to='hdabo.Tag')), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='HdalabRenkan', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('state', models.IntegerField(default=1, choices=[(1, b'edition'), (2, b'moderated'), (3, b'published'), (4, b'rejected')])), + ('favorite', models.BooleanField(default=False)), + ('renkan', models.ForeignKey(to='renkanmanager.Renkan')), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='HdalabRenkanStateTransition', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('from_state', models.IntegerField(default=1, choices=[(1, b'edition'), (2, b'moderated'), (3, b'published'), (4, b'rejected')])), + ('to_state', models.IntegerField(default=1, choices=[(1, b'edition'), (2, b'moderated'), (3, b'published'), (4, b'rejected')])), + ('ts', models.DateTimeField(auto_now_add=True)), + ('message', models.TextField(null=True, blank=True)), + ('author', models.ForeignKey(to=settings.AUTH_USER_MODEL)), + ('renkan', models.ForeignKey(related_name='states', to='hdalab.HdalabRenkan')), + ], + options={ + 'ordering': ['-ts'], + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='HdaSession', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('sessionid', models.CharField(unique=True, max_length=36, db_index=True)), + ('data', models.TextField(null=True, blank=True)), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='InfoboxParameter', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('param_name', models.CharField(max_length=2048)), + ('param_value', models.TextField(null=True, blank=True)), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='InseeCoords', + fields=[ + ('insee', models.IntegerField(serialize=False, primary_key=True)), + ('city_name', models.CharField(max_length=255)), + ('latitude', models.FloatField()), + ('longitude', models.FloatField()), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='TagInfobox', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('name', models.CharField(max_length=2048)), + ('source', models.TextField(null=True, blank=True)), + ('revision_id', models.BigIntegerField(null=True, blank=True)), + ('tag', models.ForeignKey(related_name='infoboxes', to='hdabo.Tag')), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='TagLinks', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('object', models.ForeignKey(related_name='taglinks_objects', to='hdabo.Tag')), + ('subject', models.ForeignKey(related_name='taglinks_subjects', to='hdabo.Tag')), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='TagWpCategory', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('hidden', models.BooleanField(default=False)), + ('tag', models.ForeignKey(related_name='wp_categories', to='hdabo.Tag')), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='TagYears', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('start_year', models.IntegerField(db_index=True)), + ('end_year', models.IntegerField(db_index=True)), + ('tag', models.ForeignKey(related_name='years', to='hdabo.Tag', unique=True)), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='WpCategory', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('label', models.CharField(unique=True, max_length=2048)), + ], + options={ + 'verbose_name_plural': 'WpCategories', + }, + bases=(models.Model,), + ), + migrations.CreateModel( + name='WpCategoryInclusion', + fields=[ + ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), + ('child_category', models.ForeignKey(related_name='parent_categories', to='hdalab.WpCategory')), + ('parent_category', models.ForeignKey(related_name='child_categories', to='hdalab.WpCategory')), + ], + options={ + }, + bases=(models.Model,), + ), + migrations.AlterUniqueTogether( + name='wpcategoryinclusion', + unique_together=set([('parent_category', 'child_category')]), + ), + migrations.AddField( + model_name='tagwpcategory', + name='wp_category', + field=models.ForeignKey(related_name='tags', to='hdalab.WpCategory'), + preserve_default=True, + ), + migrations.AlterUniqueTogether( + name='tagwpcategory', + unique_together=set([('tag', 'wp_category', 'hidden')]), + ), + migrations.AlterUniqueTogether( + name='taginfobox', + unique_together=set([('tag', 'name', 'revision_id')]), + ), + migrations.AddField( + model_name='infoboxparameter', + name='tag_infobox', + field=models.ForeignKey(to='hdalab.TagInfobox'), + preserve_default=True, + ), + migrations.AlterUniqueTogether( + name='infoboxparameter', + unique_together=set([('tag_infobox', 'param_name')]), + ), + migrations.AlterUniqueTogether( + name='dbpediafieldstranslation', + unique_together=set([('master', 'language_code')]), + ), + migrations.AddField( + model_name='datasheetextras', + name='insee', + field=models.ForeignKey(blank=True, to='hdalab.InseeCoords', null=True), + preserve_default=True, + ), + ]