3 from south.db import db
4 from south.v2 import SchemaMigration
5 from django.db import models
7 class Migration(SchemaMigration):
9 def forwards(self, orm):
11 # Adding model 'ImageChange'
12 db.create_table('catalogue_imagechange', (
13 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
14 ('author', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True, blank=True)),
15 ('author_name', self.gf('django.db.models.fields.CharField')(max_length=128, null=True, blank=True)),
16 ('author_email', self.gf('django.db.models.fields.CharField')(max_length=128, null=True, blank=True)),
17 ('revision', self.gf('django.db.models.fields.IntegerField')(db_index=True)),
18 ('parent', self.gf('django.db.models.fields.related.ForeignKey')(default=None, related_name='children', null=True, blank=True, to=orm['catalogue.ImageChange'])),
19 ('merge_parent', self.gf('django.db.models.fields.related.ForeignKey')(default=None, related_name='merge_children', null=True, blank=True, to=orm['catalogue.ImageChange'])),
20 ('description', self.gf('django.db.models.fields.TextField')(default='', blank=True)),
21 ('created_at', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now, db_index=True)),
22 ('publishable', self.gf('django.db.models.fields.BooleanField')(default=False)),
23 ('tree', self.gf('django.db.models.fields.related.ForeignKey')(related_name='change_set', to=orm['catalogue.Image'])),
24 ('data', self.gf('django.db.models.fields.files.FileField')(max_length=100)),
26 db.send_create_signal('catalogue', ['ImageChange'])
28 # Adding M2M table for field tags on 'ImageChange'
29 db.create_table('catalogue_imagechange_tags', (
30 ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
31 ('imagechange', models.ForeignKey(orm['catalogue.imagechange'], null=False)),
32 ('imagetag', models.ForeignKey(orm['catalogue.imagetag'], null=False))
34 db.create_unique('catalogue_imagechange_tags', ['imagechange_id', 'imagetag_id'])
36 # Adding unique constraint on 'ImageChange', fields ['tree', 'revision']
37 db.create_unique('catalogue_imagechange', ['tree_id', 'revision'])
39 # Adding model 'ImagePublishRecord'
40 db.create_table('catalogue_imagepublishrecord', (
41 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
42 ('image', self.gf('django.db.models.fields.related.ForeignKey')(related_name='publish_log', to=orm['catalogue.Image'])),
43 ('timestamp', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
44 ('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'])),
45 ('change', self.gf('django.db.models.fields.related.ForeignKey')(related_name='publish_log', to=orm['catalogue.ImageChange'])),
47 db.send_create_signal('catalogue', ['ImagePublishRecord'])
49 # Adding model 'ImageTag'
50 db.create_table('catalogue_imagetag', (
51 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
52 ('name', self.gf('django.db.models.fields.CharField')(max_length=64)),
53 ('slug', self.gf('django.db.models.fields.SlugField')(db_index=True, max_length=64, unique=True, null=True, blank=True)),
54 ('ordering', self.gf('django.db.models.fields.IntegerField')()),
56 db.send_create_signal('catalogue', ['ImageTag'])
58 # Adding model 'Image'
59 db.create_table('catalogue_image', (
60 ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
61 ('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True, blank=True)),
62 ('image', self.gf('django.db.models.fields.files.FileField')(max_length=100)),
63 ('title', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
64 ('slug', self.gf('django.db.models.fields.SlugField')(unique=True, max_length=50, db_index=True)),
65 ('public', self.gf('django.db.models.fields.BooleanField')(default=True, db_index=True)),
66 ('_short_html', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
67 ('_new_publishable', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
68 ('_published', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
69 ('_changed', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)),
70 ('stage', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['catalogue.ImageTag'], null=True, blank=True)),
71 ('head', self.gf('django.db.models.fields.related.ForeignKey')(default=None, to=orm['catalogue.ImageChange'], null=True, blank=True)),
72 ('creator', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='created_image', null=True, to=orm['auth.User'])),
74 db.send_create_signal('catalogue', ['Image'])
77 def backwards(self, orm):
79 # Removing unique constraint on 'ImageChange', fields ['tree', 'revision']
80 db.delete_unique('catalogue_imagechange', ['tree_id', 'revision'])
82 # Deleting model 'ImageChange'
83 db.delete_table('catalogue_imagechange')
85 # Removing M2M table for field tags on 'ImageChange'
86 db.delete_table('catalogue_imagechange_tags')
88 # Deleting model 'ImagePublishRecord'
89 db.delete_table('catalogue_imagepublishrecord')
91 # Deleting model 'ImageTag'
92 db.delete_table('catalogue_imagetag')
94 # Deleting model 'Image'
95 db.delete_table('catalogue_image')
100 'Meta': {'object_name': 'Group'},
101 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
102 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
103 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
106 'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
107 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
108 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
109 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
110 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
113 'Meta': {'object_name': 'User'},
114 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
115 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
116 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
117 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
118 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
119 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
120 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
121 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
122 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
123 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
124 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
125 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
126 'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
129 'Meta': {'ordering': "['title', 'slug']", 'object_name': 'Book'},
130 '_new_publishable': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
131 '_published': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
132 '_short_html': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
133 '_single': ('django.db.models.fields.NullBooleanField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),
134 'dc_slug': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '128', 'null': 'True', 'blank': 'True'}),
135 'gallery': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
136 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
137 'parent': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'children'", 'null': 'True', 'to': "orm['catalogue.Book']"}),
138 'parent_number': ('django.db.models.fields.IntegerField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),
139 'public': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'db_index': 'True'}),
140 'slug': ('django.db.models.fields.SlugField', [], {'unique': 'True', 'max_length': '128', 'db_index': 'True'}),
141 'title': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'})
143 'catalogue.bookpublishrecord': {
144 'Meta': {'ordering': "['-timestamp']", 'object_name': 'BookPublishRecord'},
145 'book': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'publish_log'", 'to': "orm['catalogue.Book']"}),
146 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
147 'timestamp': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
148 'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']"})
151 'Meta': {'ordering': "['number']", 'unique_together': "[['book', 'number'], ['book', 'slug']]", 'object_name': 'Chunk'},
152 '_changed': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
153 '_hidden': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
154 '_short_html': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
155 'book': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.Book']"}),
156 'creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'created_chunk'", 'null': 'True', 'to': "orm['auth.User']"}),
157 'gallery_start': ('django.db.models.fields.IntegerField', [], {'default': '1', 'null': 'True', 'blank': 'True'}),
158 'head': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': "orm['catalogue.ChunkChange']", 'null': 'True', 'blank': 'True'}),
159 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
160 'number': ('django.db.models.fields.IntegerField', [], {}),
161 'slug': ('django.db.models.fields.SlugField', [], {'max_length': '50', 'db_index': 'True'}),
162 'stage': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.ChunkTag']", 'null': 'True', 'blank': 'True'}),
163 'title': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
164 'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'null': 'True', 'blank': 'True'})
166 'catalogue.chunkchange': {
167 'Meta': {'ordering': "('created_at',)", 'unique_together': "(['tree', 'revision'],)", 'object_name': 'ChunkChange'},
168 'author': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'null': 'True', 'blank': 'True'}),
169 'author_email': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
170 'author_name': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
171 'created_at': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now', 'db_index': 'True'}),
172 'data': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}),
173 'description': ('django.db.models.fields.TextField', [], {'default': "''", 'blank': 'True'}),
174 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
175 'merge_parent': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'related_name': "'merge_children'", 'null': 'True', 'blank': 'True', 'to': "orm['catalogue.ChunkChange']"}),
176 'parent': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'related_name': "'children'", 'null': 'True', 'blank': 'True', 'to': "orm['catalogue.ChunkChange']"}),
177 'publishable': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
178 'revision': ('django.db.models.fields.IntegerField', [], {'db_index': 'True'}),
179 'tags': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'change_set'", 'symmetrical': 'False', 'to': "orm['catalogue.ChunkTag']"}),
180 'tree': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'change_set'", 'to': "orm['catalogue.Chunk']"})
182 'catalogue.chunkpublishrecord': {
183 'Meta': {'object_name': 'ChunkPublishRecord'},
184 'book_record': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.BookPublishRecord']"}),
185 'change': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'publish_log'", 'to': "orm['catalogue.ChunkChange']"}),
186 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
188 'catalogue.chunktag': {
189 'Meta': {'ordering': "['ordering']", 'object_name': 'ChunkTag'},
190 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
191 'name': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
192 'ordering': ('django.db.models.fields.IntegerField', [], {}),
193 'slug': ('django.db.models.fields.SlugField', [], {'db_index': 'True', 'max_length': '64', 'unique': 'True', 'null': 'True', 'blank': 'True'})
196 'Meta': {'ordering': "['title']", 'object_name': 'Image'},
197 '_changed': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
198 '_new_publishable': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
199 '_published': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
200 '_short_html': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
201 'creator': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'created_image'", 'null': 'True', 'to': "orm['auth.User']"}),
202 'head': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': "orm['catalogue.ImageChange']", 'null': 'True', 'blank': 'True'}),
203 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
204 'image': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}),
205 'public': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'db_index': 'True'}),
206 'slug': ('django.db.models.fields.SlugField', [], {'unique': 'True', 'max_length': '50', 'db_index': 'True'}),
207 'stage': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.ImageTag']", 'null': 'True', 'blank': 'True'}),
208 'title': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
209 'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'null': 'True', 'blank': 'True'})
211 'catalogue.imagechange': {
212 'Meta': {'ordering': "('created_at',)", 'unique_together': "(['tree', 'revision'],)", 'object_name': 'ImageChange'},
213 'author': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'null': 'True', 'blank': 'True'}),
214 'author_email': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
215 'author_name': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
216 'created_at': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now', 'db_index': 'True'}),
217 'data': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}),
218 'description': ('django.db.models.fields.TextField', [], {'default': "''", 'blank': 'True'}),
219 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
220 'merge_parent': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'related_name': "'merge_children'", 'null': 'True', 'blank': 'True', 'to': "orm['catalogue.ImageChange']"}),
221 'parent': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'related_name': "'children'", 'null': 'True', 'blank': 'True', 'to': "orm['catalogue.ImageChange']"}),
222 'publishable': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
223 'revision': ('django.db.models.fields.IntegerField', [], {'db_index': 'True'}),
224 'tags': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'change_set'", 'symmetrical': 'False', 'to': "orm['catalogue.ImageTag']"}),
225 'tree': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'change_set'", 'to': "orm['catalogue.Image']"})
227 'catalogue.imagepublishrecord': {
228 'Meta': {'ordering': "['-timestamp']", 'object_name': 'ImagePublishRecord'},
229 'change': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'publish_log'", 'to': "orm['catalogue.ImageChange']"}),
230 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
231 'image': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'publish_log'", 'to': "orm['catalogue.Image']"}),
232 'timestamp': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
233 'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']"})
235 'catalogue.imagetag': {
236 'Meta': {'ordering': "['ordering']", 'object_name': 'ImageTag'},
237 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
238 'name': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
239 'ordering': ('django.db.models.fields.IntegerField', [], {}),
240 'slug': ('django.db.models.fields.SlugField', [], {'db_index': 'True', 'max_length': '64', 'unique': 'True', 'null': 'True', 'blank': 'True'})
242 'contenttypes.contenttype': {
243 'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
244 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
245 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
246 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
247 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
251 complete_apps = ['catalogue']