src/hdalab/migrations/0002_dataviz.py
changeset 271 8f77cf71ab02
parent 119 e3ebe3545f72
equal deleted inserted replaced
265:73f19fa4f997 271:8f77cf71ab02
       
     1 # encoding: utf-8
       
     2 import datetime
       
     3 from south.db import db
       
     4 from south.v2 import SchemaMigration
       
     5 from django.db import models
       
     6 
       
     7 class Migration(SchemaMigration):
       
     8 
       
     9     def forwards(self, orm):
       
    10         
       
    11         # Adding model 'DbpediaFields'
       
    12         db.create_table('hdalab_dbpediafields', (
       
    13             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
       
    14             ('dbpedia_uri', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)),
       
    15             ('tag', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='dbpedia_fields', null=True, to=orm['hdabo.Tag'])),
       
    16             ('abstract', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
       
    17             ('label', self.gf('django.db.models.fields.CharField')(max_length=2048, null=True, blank=True)),
       
    18             ('thumbnail', self.gf('django.db.models.fields.URLField')(max_length=2048, null=True, blank=True)),
       
    19         ))
       
    20         db.send_create_signal('hdalab', ['DbpediaFields'])
       
    21 
       
    22         # Adding model 'TagLinks'
       
    23         db.create_table('hdalab_taglinks', (
       
    24             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
       
    25             ('subject', self.gf('django.db.models.fields.related.ForeignKey')(related_name='taglinks_subjects', to=orm['hdabo.Tag'])),
       
    26             ('object', self.gf('django.db.models.fields.related.ForeignKey')(related_name='taglinks_objects', to=orm['hdabo.Tag'])),
       
    27         ))
       
    28         db.send_create_signal('hdalab', ['TagLinks'])
       
    29 
       
    30         # Adding model 'CountryCode'
       
    31         db.create_table('hdalab_countrycode', (
       
    32             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
       
    33             ('label', self.gf('django.db.models.fields.CharField')(unique=True, max_length=1024, db_index=True)),
       
    34             ('isocode', self.gf('django.db.models.fields.CharField')(unique=True, max_length=3, db_index=True)),
       
    35         ))
       
    36         db.send_create_signal('hdalab', ['CountryCode'])
       
    37 
       
    38         # Adding model 'TagYears'
       
    39         db.create_table('hdalab_tagyears', (
       
    40             ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
       
    41             ('tag', self.gf('django.db.models.fields.related.ForeignKey')(related_name='years', to=orm['hdabo.Tag'])),
       
    42             ('start_year', self.gf('django.db.models.fields.IntegerField')(db_index=True)),
       
    43             ('end_yar', self.gf('django.db.models.fields.IntegerField')(db_index=True)),
       
    44         ))
       
    45         db.send_create_signal('hdalab', ['TagYears'])
       
    46 
       
    47 
       
    48     def backwards(self, orm):
       
    49         
       
    50         # Deleting model 'DbpediaFields'
       
    51         db.delete_table('hdalab_dbpediafields')
       
    52 
       
    53         # Deleting model 'TagLinks'
       
    54         db.delete_table('hdalab_taglinks')
       
    55 
       
    56         # Deleting model 'CountryCode'
       
    57         db.delete_table('hdalab_countrycode')
       
    58 
       
    59         # Deleting model 'TagYears'
       
    60         db.delete_table('hdalab_tagyears')
       
    61 
       
    62 
       
    63     models = {
       
    64         'hdabo.tag': {
       
    65             'Meta': {'unique_together': "(('label', 'original_label', 'url_status'),)", 'object_name': 'Tag'},
       
    66             'alias': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),
       
    67             'alternative_label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}),
       
    68             'alternative_wikipedia_pageid': ('django.db.models.fields.BigIntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),
       
    69             'alternative_wikipedia_url': ('django.db.models.fields.URLField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}),
       
    70             'category': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdabo.TagCategory']", 'null': 'True', 'blank': 'True'}),
       
    71             'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
       
    72             'dbpedia_uri': ('django.db.models.fields.URLField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}),
       
    73             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
    74             'label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}),
       
    75             'normalized_label': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}),
       
    76             'original_label': ('django.db.models.fields.CharField', [], {'max_length': '1024'}),
       
    77             'popularity': ('django.db.models.fields.IntegerField', [], {'default': '0', 'db_index': 'True'}),
       
    78             'url_status': ('django.db.models.fields.IntegerField', [], {'default': 'None', 'null': 'True', 'db_index': 'True', 'blank': 'True'}),
       
    79             'wikipedia_pageid': ('django.db.models.fields.BigIntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),
       
    80             'wikipedia_url': ('django.db.models.fields.URLField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'})
       
    81         },
       
    82         'hdabo.tagcategory': {
       
    83             'Meta': {'object_name': 'TagCategory'},
       
    84             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
    85             'label': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '512'})
       
    86         },
       
    87         'hdalab.countrycode': {
       
    88             'Meta': {'object_name': 'CountryCode'},
       
    89             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
    90             'isocode': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3', 'db_index': 'True'}),
       
    91             'label': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '1024', 'db_index': 'True'})
       
    92         },
       
    93         'hdalab.dbpediafields': {
       
    94             'Meta': {'object_name': 'DbpediaFields'},
       
    95             'abstract': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
       
    96             'dbpedia_uri': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}),
       
    97             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
    98             'label': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'}),
       
    99             'tag': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'dbpedia_fields'", 'null': 'True', 'to': "orm['hdabo.Tag']"}),
       
   100             'thumbnail': ('django.db.models.fields.URLField', [], {'max_length': '2048', 'null': 'True', 'blank': 'True'})
       
   101         },
       
   102         'hdalab.infoboxparameter': {
       
   103             'Meta': {'unique_together': "(('tag_infobox', 'param_name'),)", 'object_name': 'InfoboxParameter'},
       
   104             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
   105             'param_name': ('django.db.models.fields.CharField', [], {'max_length': '2048'}),
       
   106             'param_value': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
       
   107             'tag_infobox': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdalab.TagInfobox']"})
       
   108         },
       
   109         'hdalab.taginfobox': {
       
   110             'Meta': {'unique_together': "(('tag', 'name', 'revision_id'),)", 'object_name': 'TagInfobox'},
       
   111             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
   112             'name': ('django.db.models.fields.CharField', [], {'max_length': '2048'}),
       
   113             'revision_id': ('django.db.models.fields.BigIntegerField', [], {'null': 'True', 'blank': 'True'}),
       
   114             'source': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
       
   115             'tag': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'infoboxes'", 'to': "orm['hdabo.Tag']"})
       
   116         },
       
   117         'hdalab.taglinks': {
       
   118             'Meta': {'object_name': 'TagLinks'},
       
   119             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
   120             'object': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'taglinks_objects'", 'to': "orm['hdabo.Tag']"}),
       
   121             'subject': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'taglinks_subjects'", 'to': "orm['hdabo.Tag']"})
       
   122         },
       
   123         'hdalab.tagwpcategory': {
       
   124             'Meta': {'unique_together': "(('tag', 'wp_category', 'hidden'),)", 'object_name': 'TagWpCategory'},
       
   125             'hidden': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
       
   126             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
   127             'tag': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'wp_categories'", 'to': "orm['hdabo.Tag']"}),
       
   128             'wp_category': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['hdalab.WpCategory']"})
       
   129         },
       
   130         'hdalab.tagyears': {
       
   131             'Meta': {'object_name': 'TagYears'},
       
   132             'end_yar': ('django.db.models.fields.IntegerField', [], {'db_index': 'True'}),
       
   133             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
   134             'start_year': ('django.db.models.fields.IntegerField', [], {'db_index': 'True'}),
       
   135             'tag': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'years'", 'to': "orm['hdabo.Tag']"})
       
   136         },
       
   137         'hdalab.wpcategory': {
       
   138             'Meta': {'object_name': 'WpCategory'},
       
   139             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
       
   140             'label': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2048'})
       
   141         }
       
   142     }
       
   143 
       
   144     complete_apps = ['hdalab']