# HG changeset patch # User ymh # Date 1378115101 -7200 # Node ID be595253ced5611fd9ec17f2cd9b57e6ae413602 # Parent 52fa6990e0bbf67d98186d4c2cbd32a500fa7991 Migration file diff -r 52fa6990e0bb -r be595253ced5 src/p4l/migrations/0001_initial.py --- a/src/p4l/migrations/0001_initial.py Sat Aug 31 19:20:46 2013 +0200 +++ b/src/p4l/migrations/0001_initial.py Mon Sep 02 11:45:01 2013 +0200 @@ -32,6 +32,7 @@ # Adding model 'ProjectName' db.create_table(u'p4l_projectname', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('uri', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), ('label', self.gf('django.db.models.fields.CharField')(max_length=2048, db_index=True)), ('acronym', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=2048, null=True, blank=True)), )) @@ -43,12 +44,15 @@ # Adding model 'CorporateAuthor' db.create_table(u'p4l_corporateauthor', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('record', self.gf('django.db.models.fields.related.ForeignKey')(related_name='corporateAuthors', to=orm['p4l.Record'])), - ('label', self.gf('django.db.models.fields.CharField')(max_length=2048, db_index=True)), + ('uri', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), + ('label', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=2048, null=True, blank=True)), ('acronym', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=2048, null=True, blank=True)), )) db.send_create_signal('p4l', ['CorporateAuthor']) + # Adding unique constraint on 'CorporateAuthor', fields ['label', 'acronym'] + db.create_unique(u'p4l_corporateauthor', ['label', 'acronym']) + # Adding model 'Url' db.create_table(u'p4l_url', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), @@ -62,7 +66,7 @@ # Adding model 'Subject' db.create_table(u'p4l_subject', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('subject', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), + ('uri', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), ('label', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=2048, null=True, blank=True)), )) db.send_create_signal('p4l', ['Subject']) @@ -70,7 +74,7 @@ # Adding model 'Theme' db.create_table(u'p4l_theme', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('theme', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), + ('uri', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), ('label', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=2048, null=True, blank=True)), )) db.send_create_signal('p4l', ['Theme']) @@ -78,7 +82,7 @@ # Adding model 'Country' db.create_table(u'p4l_country', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('country', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), + ('uri', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), ('label', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=2048, null=True, blank=True)), )) db.send_create_signal('p4l', ['Country']) @@ -113,7 +117,7 @@ # Adding model 'Language' db.create_table(u'p4l_language', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('language', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), + ('uri', self.gf('django.db.models.fields.URLField')(unique=True, max_length=2048, db_index=True)), ('label', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=2048, null=True, blank=True)), )) db.send_create_signal('p4l', ['Language']) @@ -223,17 +227,6 @@ )) db.send_create_signal('p4l', ['SubjectMeeting']) - # Adding model 'CorporateBody' - db.create_table(u'p4l_corporatebody', ( - (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), - ('label', self.gf('django.db.models.fields.CharField')(max_length=2048, db_index=True)), - ('acronym', self.gf('django.db.models.fields.CharField')(db_index=True, max_length=2048, null=True, blank=True)), - )) - db.send_create_signal('p4l', ['CorporateBody']) - - # Adding unique constraint on 'CorporateBody', fields ['label', 'acronym'] - db.create_unique(u'p4l_corporatebody', ['label', 'acronym']) - # Adding model 'Record' db.create_table(u'p4l_record', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), @@ -244,6 +237,7 @@ ('editionStatement', self.gf('django.db.models.fields.CharField')(max_length=1024, null=True, blank=True)), ('recordType', self.gf('django.db.models.fields.URLField')(max_length=2048)), ('isDocumentPart', self.gf('django.db.models.fields.BooleanField')(default=False)), + ('isMultilingual', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal('p4l', ['Record']) @@ -291,9 +285,17 @@ db.create_table(u'p4l_record_subjectCorporateBodies', ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('record', models.ForeignKey(orm['p4l.record'], null=False)), - ('corporatebody', models.ForeignKey(orm['p4l.corporatebody'], null=False)) + ('corporateauthor', models.ForeignKey(orm['p4l.corporateauthor'], null=False)) )) - db.create_unique(u'p4l_record_subjectCorporateBodies', ['record_id', 'corporatebody_id']) + db.create_unique(u'p4l_record_subjectCorporateBodies', ['record_id', 'corporateauthor_id']) + + # Adding M2M table for field corporateAuthors on 'Record' + db.create_table(u'p4l_record_corporateAuthors', ( + ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), + ('record', models.ForeignKey(orm['p4l.record'], null=False)), + ('corporateauthor', models.ForeignKey(orm['p4l.corporateauthor'], null=False)) + )) + db.create_unique(u'p4l_record_corporateAuthors', ['record_id', 'corporateauthor_id']) # Adding model 'User' db.create_table(u'p4l_user', ( @@ -330,8 +332,8 @@ def backwards(self, orm): - # Removing unique constraint on 'CorporateBody', fields ['label', 'acronym'] - db.delete_unique(u'p4l_corporatebody', ['label', 'acronym']) + # Removing unique constraint on 'CorporateAuthor', fields ['label', 'acronym'] + db.delete_unique(u'p4l_corporateauthor', ['label', 'acronym']) # Removing unique constraint on 'ProjectName', fields ['label', 'acronym'] db.delete_unique(u'p4l_projectname', ['label', 'acronym']) @@ -405,9 +407,6 @@ # Deleting model 'SubjectMeeting' db.delete_table(u'p4l_subjectmeeting') - # Deleting model 'CorporateBody' - db.delete_table(u'p4l_corporatebody') - # Deleting model 'Record' db.delete_table(u'p4l_record') @@ -429,6 +428,9 @@ # Removing M2M table for field subjectCorporateBodies on 'Record' db.delete_table('p4l_record_subjectCorporateBodies') + # Removing M2M table for field corporateAuthors on 'Record' + db.delete_table('p4l_record_corporateAuthors') + # Deleting model 'User' db.delete_table(u'p4l_user') @@ -488,23 +490,17 @@ 'record': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'collations'", 'to': "orm['p4l.Record']"}) }, 'p4l.corporateauthor': { - 'Meta': {'object_name': 'CorporateAuthor'}, + 'Meta': {'unique_together': "(['label', 'acronym'],)", 'object_name': 'CorporateAuthor'}, 'acronym': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}), u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'label': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'db_index': 'True'}), - 'record': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'corporateAuthors'", 'to': "orm['p4l.Record']"}) - }, - 'p4l.corporatebody': { - 'Meta': {'unique_together': "(['label', 'acronym'],)", 'object_name': 'CorporateBody'}, - 'acronym': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}), - u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'label': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'db_index': 'True'}) + 'label': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}), + 'uri': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) }, 'p4l.country': { 'Meta': {'object_name': 'Country'}, - 'country': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}), u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'label': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}) + 'label': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}), + 'uri': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) }, 'p4l.documentcode': { 'Meta': {'object_name': 'DocumentCode'}, @@ -540,7 +536,7 @@ 'Meta': {'object_name': 'Language'}, u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'label': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}), - 'language': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) + 'uri': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) }, 'p4l.meeting': { 'Meta': {'object_name': 'Meeting'}, @@ -564,21 +560,24 @@ 'Meta': {'unique_together': "(['label', 'acronym'],)", 'object_name': 'ProjectName'}, 'acronym': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}), u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), - 'label': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'db_index': 'True'}) + 'label': ('django.db.models.fields.CharField', [], {'max_length': '2048', 'db_index': 'True'}), + 'uri': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) }, 'p4l.record': { 'Meta': {'object_name': 'Record'}, + 'corporateAuthors': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'recordsCorporateAuthor'", 'symmetrical': 'False', 'to': "orm['p4l.CorporateAuthor']"}), 'countries': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['p4l.Country']", 'symmetrical': 'False'}), 'editionStatement': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'null': 'True', 'blank': 'True'}), u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'identifier': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128', 'db_index': 'True'}), 'isDocumentPart': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), + 'isMultilingual': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), 'language': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['p4l.Language']", 'null': 'True', 'blank': 'True'}), 'notes': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), 'otherLanguages': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'otherLanguage_record'", 'symmetrical': 'False', 'to': "orm['p4l.Language']"}), 'projectNames': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['p4l.ProjectName']", 'symmetrical': 'False'}), 'recordType': ('django.db.models.fields.URLField', [], {'max_length': '2048'}), - 'subjectCorporateBodies': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['p4l.CorporateBody']", 'symmetrical': 'False'}), + 'subjectCorporateBodies': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'recordsSubjectCorporateBody'", 'symmetrical': 'False', 'to': "orm['p4l.CorporateAuthor']"}), 'subjects': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['p4l.Subject']", 'symmetrical': 'False'}), 'themes': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['p4l.Theme']", 'symmetrical': 'False'}), 'uri': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) @@ -595,7 +594,7 @@ 'Meta': {'object_name': 'Subject'}, u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'label': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}), - 'subject': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) + 'uri': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) }, 'p4l.subjectmeeting': { 'Meta': {'object_name': 'SubjectMeeting'}, @@ -617,7 +616,7 @@ 'Meta': {'object_name': 'Theme'}, u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'label': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '2048', 'null': 'True', 'blank': 'True'}), - 'theme': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) + 'uri': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '2048', 'db_index': 'True'}) }, 'p4l.title': { 'Meta': {'object_name': 'Title'},