def forwards(self, orm): # Adding model 'PazzosTest' db.create_table(u'ARK_pazzostest', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('takenBy', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['ARK.PazzosUser'])), ('timeStarted', self.gf('django.db.models.fields.TimeField')( default=datetime.time(16, 16, 32, 40000))), ('timeCompleted', self.gf('django.db.models.fields.TimeField')( default=datetime.time(16, 16, 32, 40000))), )) db.send_create_signal(u'ARK', ['PazzosTest'])
def backwards(self, orm): # Adding field 'COMaster.peh_time' db.add_column('mara_comaster', 'peh_time', self.gf('django.db.models.fields.TimeField')( default=datetime.time(1, 0)), keep_default=False)
def forwards(self, orm): # Adding model 'DayModel' db.create_table(u'datebook_daymodel', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('content', self.gf('django.db.models.fields.TextField')(max_length=500, blank=True)), ('start', self.gf('django.db.models.fields.DateTimeField')()), ('stop', self.gf('django.db.models.fields.DateTimeField')()), ('pause', self.gf('django.db.models.fields.TimeField')(default=datetime.time(0, 0))), ('overtime', self.gf('django.db.models.fields.TimeField')(default=datetime.time(0, 0))), ('author', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'])), ('title', self.gf('django.db.models.fields.CharField')(max_length=255)), )) db.send_create_signal(u'datebook', ['DayModel']) # Adding unique constraint on 'DayModel', fields ['author', 'title'] db.create_unique(u'datebook_daymodel', ['author_id', 'title'])
def forwards(self, orm): # Adding model 'Datebook' db.create_table( u"datebook_datebook", ( (u"id", self.gf("django.db.models.fields.AutoField")(primary_key=True)), ("author", self.gf("django.db.models.fields.related.ForeignKey")(to=orm["auth.User"])), ("created", self.gf("django.db.models.fields.DateTimeField")(blank=True)), ("modified", self.gf("django.db.models.fields.DateTimeField")(auto_now=True, blank=True)), ("period", self.gf("django.db.models.fields.DateField")()), ), ) db.send_create_signal(u"datebook", ["Datebook"]) # Adding unique constraint on 'Datebook', fields ['author', 'period'] db.create_unique(u"datebook_datebook", ["author_id", "period"]) # Adding model 'DayEntry' db.create_table( u"datebook_dayentry", ( (u"id", self.gf("django.db.models.fields.AutoField")(primary_key=True)), ("datebook", self.gf("django.db.models.fields.related.ForeignKey")(to=orm["datebook.Datebook"])), ("activity_date", self.gf("django.db.models.fields.DateField")()), ("vacation", self.gf("django.db.models.fields.BooleanField")(default=False)), ("content", self.gf("django.db.models.fields.TextField")(max_length=500, blank=True)), ("start", self.gf("django.db.models.fields.DateTimeField")()), ("stop", self.gf("django.db.models.fields.DateTimeField")()), ("pause", self.gf("django.db.models.fields.TimeField")(default=datetime.time(0, 0))), ), ) db.send_create_signal(u"datebook", ["DayEntry"]) # Adding unique constraint on 'DayEntry', fields ['datebook', 'activity_date'] db.create_unique(u"datebook_dayentry", ["datebook_id", "activity_date"])
def forwards(self, orm): # Adding model 'Course' db.create_table(u'course_course', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=100)), ('heure_depart', self.gf('django.db.models.fields.TimeField')( default=datetime.time(16, 0))), )) db.send_create_signal(u'course', ['Course']) # Adding model 'Inscrit' db.create_table(u'course_inscrit', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('numero', self.gf('django.db.models.fields.IntegerField')(default=0)), ('course', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['course.Course'])), ('nom', self.gf('django.db.models.fields.CharField')(max_length=100)), ('prenom', self.gf('django.db.models.fields.CharField')(max_length=100)), ('gender', self.gf('django.db.models.fields.IntegerField')()), ('birth_date', self.gf('django.db.models.fields.DateField')()), ('category', self.gf('django.db.models.fields.related.ForeignKey')( default=None, to=orm['course.Category'], null=True, blank=True)), ('arrivee', self.gf('django.db.models.fields.DateTimeField')( default=None, null=True, blank=True)), ('contact', self.gf('django.db.models.fields.related.ForeignKey')( default=None, to=orm['Crm.Contact'], null=True, blank=True)), )) db.send_create_signal(u'course', ['Inscrit'])
def forwards(self, orm): # Adding field 'Position.default_time_start' db.add_column('scheduler_position', 'default_time_start', self.gf('django.db.models.fields.TimeField')(default=datetime.time(13, 30)), keep_default=False) # Adding field 'Position.default_time_end' db.add_column('scheduler_position', 'default_time_end', self.gf('django.db.models.fields.TimeField')(default=datetime.time(16, 30)), keep_default=False) # Changing field 'Shift.time_end' db.alter_column('scheduler_shift', 'time_end', self.gf('django.db.models.fields.TimeField')(null=True)) # Changing field 'Shift.time_start' db.alter_column('scheduler_shift', 'time_start', self.gf('django.db.models.fields.TimeField')(null=True))
def backwards(self, orm): # Adding field 'COMaster.peh_time' db.add_column( "mara_comaster", "peh_time", self.gf("django.db.models.fields.TimeField")(default=datetime.time(1, 0)), keep_default=False, )
def forwards(self, orm): # Deleting field 'PazzosTest.correctCount' db.delete_column('ARK_pazzostest', 'correctCount') # Adding field 'PazzosTest.timeStarted' db.add_column('ARK_pazzostest', 'timeStarted', self.gf('django.db.models.fields.TimeField')(default=datetime.time(9, 43, 51, 510038)), keep_default=False)
def forwards(self, orm): # Adding field 'Comment.time' db.add_column(u'mainapp_comment', 'time', self.gf('django.db.models.fields.TimeField')(default=datetime.time(9, 56, 12, 990281)), keep_default=False) # Adding field 'Comment.day' db.add_column(u'mainapp_comment', 'day', self.gf('django.db.models.fields.DateField')(default=datetime.datetime(2014, 8, 8, 0, 0)), keep_default=False)
def forwards(self, orm): # Adding field 'Position.default_time_start' db.add_column('scheduler_position', 'default_time_start', self.gf('django.db.models.fields.TimeField')( default=datetime.time(13, 30)), keep_default=False) # Adding field 'Position.default_time_end' db.add_column('scheduler_position', 'default_time_end', self.gf('django.db.models.fields.TimeField')( default=datetime.time(16, 30)), keep_default=False) # Changing field 'Shift.time_end' db.alter_column( 'scheduler_shift', 'time_end', self.gf('django.db.models.fields.TimeField')(null=True)) # Changing field 'Shift.time_start' db.alter_column( 'scheduler_shift', 'time_start', self.gf('django.db.models.fields.TimeField')(null=True))
def forwards(self, orm): # Adding model 'Way' db.create_table(u'track_way', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('station_id_from', self.gf('django.db.models.fields.IntegerField')()), ('station_from', self.gf('django.db.models.fields.CharField')(max_length=30)), ('station_id_to', self.gf('django.db.models.fields.IntegerField')()), ('station_to', self.gf('django.db.models.fields.CharField')(max_length=30)), )) db.send_create_signal(u'track', ['Way']) # Adding unique constraint on 'Way', fields ['station_id_from', 'station_id_to'] db.create_unique(u'track_way', ['station_id_from', 'station_id_to']) # Adding model 'TrackedWay' db.create_table(u'track_trackedway', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('way', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['track.Way'])), ('days', self.gf('django.db.models.fields.BigIntegerField')(default=None)), ('start_time', self.gf('django.db.models.fields.TimeField')(default=datetime.time(0, 0))), )) db.send_create_signal(u'track', ['TrackedWay']) # Adding model 'TrackedWayDayHistory' db.create_table(u'track_trackedwaydayhistory', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('tracked_way', self.gf('django.db.models.fields.related.ForeignKey')(related_name='histories', to=orm['track.TrackedWay'])), ('departure_date', self.gf('django.db.models.fields.DateField')()), ('places_appeared', self.gf('django.db.models.fields.related.OneToOneField')(related_name='marks_appear', unique=True, null=True, to=orm['track.TrackedWayDayHistorySnapshot'])), ('places_disappeared', self.gf('django.db.models.fields.related.OneToOneField')(related_name='marks_disappear', unique=True, null=True, to=orm['track.TrackedWayDayHistorySnapshot'])), )) db.send_create_signal(u'track', ['TrackedWayDayHistory']) # Adding unique constraint on 'TrackedWayDayHistory', fields ['tracked_way', 'departure_date'] db.create_unique(u'track_trackedwaydayhistory', ['tracked_way_id', 'departure_date']) # Adding model 'TrackedWayDayHistorySnapshot' db.create_table(u'track_trackedwaydayhistorysnapshot', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('history', self.gf('django.db.models.fields.related.ForeignKey')(related_name='snapshots', to=orm['track.TrackedWayDayHistory'])), ('made_on', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), ('total_places_count', self.gf('django.db.models.fields.IntegerField')()), ('snapshot_data', self.gf('jsonfield.fields.JSONField')()), )) db.send_create_signal(u'track', ['TrackedWayDayHistorySnapshot'])
def forwards(self, orm): # Adding model 'Terminal' db.create_table(u'main_terminal', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('text', self.gf('django.db.models.fields.TextField')()), ('config', self.gf('django.db.models.fields.TextField')( null=True, blank=True)), )) db.send_create_signal(u'main', ['Terminal']) # Adding model 'Partner' db.create_table(u'main_partner', ( (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'main', ['Partner']) # Adding model 'VideoAd' db.create_table(u'main_videoad', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('datelist', self.gf('main.fields.DateArrayField')()), ('file_video', self.gf('filebrowser.fields.FileBrowseField')( max_length=255, null=True, blank=True)), ('partner', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['main.Partner'])), ('prolongation', self.gf('django.db.models.fields.TimeField')( null=True, blank=True)), )) db.send_create_signal(u'main', ['VideoAd']) # Adding M2M table for field terminals on 'VideoAd' m2m_table_name = db.shorten_name(u'main_videoad_terminals') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('videoad', models.ForeignKey(orm[u'main.videoad'], null=False)), ('terminal', models.ForeignKey(orm[u'main.terminal'], null=False)))) db.create_unique(m2m_table_name, ['videoad_id', 'terminal_id']) # Adding model 'ImageAd' db.create_table(u'main_imagead', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('datelist', self.gf('main.fields.DateArrayField')()), ('image', self.gf('filebrowser.fields.FileBrowseField')(max_length=255)), ('prolongation', self.gf('django.db.models.fields.TimeField')()), ('partner', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['main.Partner'])), )) db.send_create_signal(u'main', ['ImageAd']) # Adding M2M table for field terminals on 'ImageAd' m2m_table_name = db.shorten_name(u'main_imagead_terminals') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('imagead', models.ForeignKey(orm[u'main.imagead'], null=False)), ('terminal', models.ForeignKey(orm[u'main.terminal'], null=False)))) db.create_unique(m2m_table_name, ['imagead_id', 'terminal_id']) # Adding model 'TextAd' db.create_table(u'main_textad', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('datelist', self.gf('main.fields.DateArrayField')()), ('text', self.gf('django.db.models.fields.TextField')()), ('partner', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['main.Partner'])), )) db.send_create_signal(u'main', ['TextAd']) # Adding M2M table for field terminals on 'TextAd' m2m_table_name = db.shorten_name(u'main_textad_terminals') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('textad', models.ForeignKey(orm[u'main.textad'], null=False)), ('terminal', models.ForeignKey(orm[u'main.terminal'], null=False)))) db.create_unique(m2m_table_name, ['textad_id', 'terminal_id']) # Adding model 'Days' db.create_table(u'main_days', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('date', self.gf('django.db.models.fields.DateField')()), ('video_count', self.gf('django.db.models.fields.PositiveIntegerField')( default=0)), ('show_text', self.gf('django.db.models.fields.BooleanField')()), ('text_count', self.gf('django.db.models.fields.PositiveIntegerField')( default=0)), ('show_video', self.gf('django.db.models.fields.BooleanField')()), ('start_time', self.gf('django.db.models.fields.TimeField')( default=datetime.time(8, 0))), ('stop_time', self.gf('django.db.models.fields.TimeField')( default=datetime.time(22, 0))), ('terminal', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['main.Terminal'])), )) db.send_create_signal(u'main', ['Days']) # Adding M2M table for field video_ad on 'Days' m2m_table_name = db.shorten_name(u'main_days_video_ad') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('days', models.ForeignKey(orm[u'main.days'], null=False)), ('videoad', models.ForeignKey(orm[u'main.videoad'], null=False)))) db.create_unique(m2m_table_name, ['days_id', 'videoad_id']) # Adding M2M table for field image_ad on 'Days' m2m_table_name = db.shorten_name(u'main_days_image_ad') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('days', models.ForeignKey(orm[u'main.days'], null=False)), ('imagead', models.ForeignKey(orm[u'main.imagead'], null=False)))) db.create_unique(m2m_table_name, ['days_id', 'imagead_id']) # Adding M2M table for field text_ad on 'Days' m2m_table_name = db.shorten_name(u'main_days_text_ad') db.create_table( m2m_table_name, (('id', models.AutoField( verbose_name='ID', primary_key=True, auto_created=True)), ('days', models.ForeignKey(orm[u'main.days'], null=False)), ('textad', models.ForeignKey(orm[u'main.textad'], null=False)))) db.create_unique(m2m_table_name, ['days_id', 'textad_id']) # Adding model 'ImmediatelyAd' db.create_table(u'main_immediatelyad', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('day', self.gf('django.db.models.fields.related.ForeignKey')( related_name=u'immediatelies', to=orm['main.Days'])), ('time', self.gf('django.db.models.fields.TimeField')()), ('content_type', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['contenttypes.ContentType'])), ('object_id', self.gf('django.db.models.fields.PositiveIntegerField')()), )) db.send_create_signal(u'main', ['ImmediatelyAd'])
def forwards(self, orm): # Adding model 'Buffer' db.create_table(u'aps_process_buffer', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('lft', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('rght', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('lvl', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=60, primary_key=True)), ('owner', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='xchildren', null=True, to=orm['aps_process.Buffer'])), ('description', self.gf('django.db.models.fields.CharField')(max_length=200, blank=True)), ('category', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('subcategory', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('type', self.gf('django.db.models.fields.CharField')(default='default', max_length=20, blank=True)), ('location', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='buffers', null=True, to=orm['aps_process.Location'])), ('item', self.gf('django.db.models.fields.related.ForeignKey')(related_name='buffers', to=orm['aps_process.Item'])), ('onhand', self.gf('django.db.models.fields.DecimalField')(default='0.0', null=True, max_digits=15, decimal_places=4, blank=True)), ('minimum', self.gf('django.db.models.fields.DecimalField')(default='0.0', null=True, max_digits=15, decimal_places=4, blank=True)), ('minimum_calendar', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='buffers', null=True, to=orm['aps_process.Calendar'])), ('producing', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='buffers', null=True, to=orm['aps_process.Operation'])), ('carrying_cost', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('leadtime', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('fence', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('min_inventory', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('max_inventory', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('size_minimum', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('size_multiple', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('size_maximum', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), )) db.send_create_signal(u'aps_process', ['Buffer']) # Adding model 'Calendar' db.create_table(u'aps_process_calendar', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=60, primary_key=True)), ('description', self.gf('django.db.models.fields.CharField')(max_length=200, blank=True)), ('category', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('subcategory', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('defaultvalue', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), )) db.send_create_signal(u'aps_process', ['Calendar']) # Adding model 'CalendarBucket' db.create_table(u'aps_process_calendarbucket', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('calendar', self.gf('django.db.models.fields.related.ForeignKey')(related_name='buckets', to=orm['aps_process.Calendar'])), ('startdate', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), ('enddate', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime(2050, 12, 30, 0, 0), null=True, blank=True)), ('value', self.gf('django.db.models.fields.DecimalField')(default='0.0', null=True, max_digits=15, decimal_places=4, blank=True)), ('priority', self.gf('django.db.models.fields.IntegerField')(default=1, null=True, blank=True)), ('monday', self.gf('django.db.models.fields.BooleanField')(default=True)), ('tuesday', self.gf('django.db.models.fields.BooleanField')(default=True)), ('wednesday', self.gf('django.db.models.fields.BooleanField')(default=True)), ('thursday', self.gf('django.db.models.fields.BooleanField')(default=True)), ('friday', self.gf('django.db.models.fields.BooleanField')(default=True)), ('saturday', self.gf('django.db.models.fields.BooleanField')(default=True)), ('sunday', self.gf('django.db.models.fields.BooleanField')(default=True)), ('starttime', self.gf('django.db.models.fields.TimeField')(default=datetime.time(0, 0), null=True, blank=True)), ('endtime', self.gf('django.db.models.fields.TimeField')(default=datetime.time(23, 59, 59), null=True, blank=True)), )) db.send_create_signal(u'aps_process', ['CalendarBucket']) # Adding model 'Flow' db.create_table(u'aps_process_flow', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('operation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='flows', to=orm['aps_process.Operation'])), ('thebuffer', self.gf('django.db.models.fields.related.ForeignKey')(related_name='flows', to=orm['aps_process.Buffer'])), ('quantity', self.gf('django.db.models.fields.DecimalField')(default='1.0', max_digits=15, decimal_places=4)), ('type', self.gf('django.db.models.fields.CharField')(default='start', max_length=20)), ('effective_start', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), ('effective_end', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=60, null=True, blank=True)), ('alternate', self.gf('django.db.models.fields.CharField')(max_length=60, blank=True)), ('priority', self.gf('django.db.models.fields.IntegerField')(default=1, null=True, blank=True)), )) db.send_create_signal(u'aps_process', ['Flow']) # Adding unique constraint on 'Flow', fields ['operation', 'thebuffer'] db.create_unique(u'aps_process_flow', ['operation_id', 'thebuffer_id']) # Adding model 'Item' db.create_table(u'aps_process_item', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('lft', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('rght', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('lvl', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=60, primary_key=True)), ('owner', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='xchildren', null=True, to=orm['aps_process.Item'])), ('description', self.gf('django.db.models.fields.CharField')(max_length=200, blank=True)), ('category', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('subcategory', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('operation', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='items', null=True, to=orm['aps_process.Operation'])), ('price', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), )) db.send_create_signal(u'aps_process', ['Item']) # Adding model 'Location' db.create_table(u'aps_process_location', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('lft', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('rght', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('lvl', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=60, primary_key=True)), ('owner', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='xchildren', null=True, to=orm['aps_process.Location'])), ('description', self.gf('django.db.models.fields.CharField')(max_length=200, blank=True)), ('category', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('subcategory', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('available', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='locations', null=True, to=orm['aps_process.Calendar'])), )) db.send_create_signal(u'aps_process', ['Location']) # Adding model 'Operation' db.create_table(u'aps_process_operation', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=60, primary_key=True)), ('type', self.gf('django.db.models.fields.CharField')(default='fixed_time', max_length=20, blank=True)), ('description', self.gf('django.db.models.fields.CharField')(max_length=200, blank=True)), ('category', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('subcategory', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('location', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='operations', null=True, to=orm['aps_process.Location'])), ('setup', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('batchqty', self.gf('django.db.models.fields.IntegerField')(default=1, null=True, blank=True)), ('batchtime', self.gf('django.db.models.fields.DecimalField')(default='1.0', null=True, max_digits=15, decimal_places=4, blank=True)), ('setdown', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), )) db.send_create_signal(u'aps_process', ['Operation']) # Adding model 'Resource' db.create_table(u'aps_process_resource', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('lft', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('rght', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('lvl', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=60, primary_key=True)), ('owner', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='xchildren', null=True, to=orm['aps_process.Resource'])), ('description', self.gf('django.db.models.fields.CharField')(max_length=200, blank=True)), ('category', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('subcategory', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('maximum', self.gf('django.db.models.fields.DecimalField')(default='1.0', null=True, max_digits=15, decimal_places=4, blank=True)), ('maximum_calendar', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='resources', null=True, to=orm['aps_process.Calendar'])), ('location', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='resources', null=True, to=orm['aps_process.Location'])), ('cost', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('maxearly', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), ('setupmatrix', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='resources', null=True, to=orm['aps_process.SetupMatrix'])), ('setup', self.gf('django.db.models.fields.CharField')(max_length=60, blank=True)), )) db.send_create_signal(u'aps_process', ['Resource']) # Adding model 'ResourceLoad' db.create_table(u'aps_process_resourceload', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('operation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='loads', to=orm['aps_process.Operation'])), ('resource', self.gf('django.db.models.fields.related.ForeignKey')(related_name='loads', to=orm['aps_process.Resource'])), ('quantity', self.gf('django.db.models.fields.DecimalField')(default='1.0', max_digits=15, decimal_places=4)), ('effective_start', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), ('effective_end', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=60, blank=True)), ('alternate', self.gf('django.db.models.fields.CharField')(max_length=60, blank=True)), ('priority', self.gf('django.db.models.fields.IntegerField')(default=1, null=True, blank=True)), ('setup', self.gf('django.db.models.fields.CharField')(max_length=60, blank=True)), ('search', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), )) db.send_create_signal(u'aps_process', ['ResourceLoad']) # Adding unique constraint on 'ResourceLoad', fields ['operation', 'resource'] db.create_unique(u'aps_process_resourceload', ['operation_id', 'resource_id']) # Adding model 'SetupMatrix' db.create_table(u'aps_process_setupmatrix', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=60, primary_key=True)), )) db.send_create_signal(u'aps_process', ['SetupMatrix']) # Adding model 'SetupRule' db.create_table(u'aps_process_setuprule', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('setupmatrix', self.gf('django.db.models.fields.related.ForeignKey')(related_name='rules', to=orm['aps_process.SetupMatrix'])), ('priority', self.gf('django.db.models.fields.IntegerField')(default=1)), ('fromsetup', self.gf('django.db.models.fields.CharField')(max_length=60, blank=True)), ('tosetup', self.gf('django.db.models.fields.CharField')(max_length=60, blank=True)), ('duration', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=0, blank=True)), ('cost', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=15, decimal_places=4, blank=True)), )) db.send_create_signal(u'aps_process', ['SetupRule']) # Adding unique constraint on 'SetupRule', fields ['setupmatrix', 'priority'] db.create_unique(u'aps_process_setuprule', ['setupmatrix_id', 'priority']) # Adding model 'SubOperation' db.create_table(u'aps_process_suboperation', ( ('source', self.gf('django.db.models.fields.CharField')(max_length=20, blank=True)), ('lastmodified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('operation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='suboperations', to=orm['aps_process.Operation'])), ('priority', self.gf('django.db.models.fields.IntegerField')(default=1)), ('suboperation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='superoperations', to=orm['aps_process.Operation'])), ('effective_start', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), ('effective_end', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)), )) db.send_create_signal(u'aps_process', ['SubOperation'])
def forwards(self, orm): # Adding model 'Terminal' db.create_table(u'main_terminal', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('text', self.gf('django.db.models.fields.TextField')()), ('config', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), )) db.send_create_signal(u'main', ['Terminal']) # Adding model 'Partner' db.create_table(u'main_partner', ( (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'main', ['Partner']) # Adding model 'VideoAd' db.create_table(u'main_videoad', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('datelist', self.gf('main.fields.DateArrayField')()), ('file_video', self.gf('filebrowser.fields.FileBrowseField')(max_length=255, null=True, blank=True)), ('partner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['main.Partner'])), ('prolongation', self.gf('django.db.models.fields.TimeField')(null=True, blank=True)), )) db.send_create_signal(u'main', ['VideoAd']) # Adding M2M table for field terminals on 'VideoAd' m2m_table_name = db.shorten_name(u'main_videoad_terminals') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('videoad', models.ForeignKey(orm[u'main.videoad'], null=False)), ('terminal', models.ForeignKey(orm[u'main.terminal'], null=False)) )) db.create_unique(m2m_table_name, ['videoad_id', 'terminal_id']) # Adding model 'ImageAd' db.create_table(u'main_imagead', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('datelist', self.gf('main.fields.DateArrayField')()), ('image', self.gf('filebrowser.fields.FileBrowseField')(max_length=255)), ('prolongation', self.gf('django.db.models.fields.TimeField')()), ('partner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['main.Partner'])), )) db.send_create_signal(u'main', ['ImageAd']) # Adding M2M table for field terminals on 'ImageAd' m2m_table_name = db.shorten_name(u'main_imagead_terminals') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('imagead', models.ForeignKey(orm[u'main.imagead'], null=False)), ('terminal', models.ForeignKey(orm[u'main.terminal'], null=False)) )) db.create_unique(m2m_table_name, ['imagead_id', 'terminal_id']) # Adding model 'TextAd' db.create_table(u'main_textad', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('datelist', self.gf('main.fields.DateArrayField')()), ('text', self.gf('django.db.models.fields.TextField')()), ('partner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['main.Partner'])), )) db.send_create_signal(u'main', ['TextAd']) # Adding M2M table for field terminals on 'TextAd' m2m_table_name = db.shorten_name(u'main_textad_terminals') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('textad', models.ForeignKey(orm[u'main.textad'], null=False)), ('terminal', models.ForeignKey(orm[u'main.terminal'], null=False)) )) db.create_unique(m2m_table_name, ['textad_id', 'terminal_id']) # Adding model 'Days' db.create_table(u'main_days', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('date', self.gf('django.db.models.fields.DateField')()), ('video_count', self.gf('django.db.models.fields.PositiveIntegerField')(default=0)), ('show_text', self.gf('django.db.models.fields.BooleanField')()), ('text_count', self.gf('django.db.models.fields.PositiveIntegerField')(default=0)), ('show_video', self.gf('django.db.models.fields.BooleanField')()), ('start_time', self.gf('django.db.models.fields.TimeField')(default=datetime.time(8, 0))), ('stop_time', self.gf('django.db.models.fields.TimeField')(default=datetime.time(22, 0))), ('terminal', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['main.Terminal'])), )) db.send_create_signal(u'main', ['Days']) # Adding M2M table for field video_ad on 'Days' m2m_table_name = db.shorten_name(u'main_days_video_ad') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('days', models.ForeignKey(orm[u'main.days'], null=False)), ('videoad', models.ForeignKey(orm[u'main.videoad'], null=False)) )) db.create_unique(m2m_table_name, ['days_id', 'videoad_id']) # Adding M2M table for field image_ad on 'Days' m2m_table_name = db.shorten_name(u'main_days_image_ad') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('days', models.ForeignKey(orm[u'main.days'], null=False)), ('imagead', models.ForeignKey(orm[u'main.imagead'], null=False)) )) db.create_unique(m2m_table_name, ['days_id', 'imagead_id']) # Adding M2M table for field text_ad on 'Days' m2m_table_name = db.shorten_name(u'main_days_text_ad') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('days', models.ForeignKey(orm[u'main.days'], null=False)), ('textad', models.ForeignKey(orm[u'main.textad'], null=False)) )) db.create_unique(m2m_table_name, ['days_id', 'textad_id']) # Adding model 'ImmediatelyAd' db.create_table(u'main_immediatelyad', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('day', self.gf('django.db.models.fields.related.ForeignKey')(related_name=u'immediatelies', to=orm['main.Days'])), ('time', self.gf('django.db.models.fields.TimeField')()), ('content_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['contenttypes.ContentType'])), ('object_id', self.gf('django.db.models.fields.PositiveIntegerField')()), )) db.send_create_signal(u'main', ['ImmediatelyAd'])
def forwards(self, orm): # Adding model 'Event' db.create_table(u'app_event', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('date', self.gf('django.db.models.fields.DateField')()), ('time_location', self.gf('django.db.models.fields.TimeField')(null=True, blank=True)), ('info', self.gf('django.db.models.fields.TextField')(blank=True)), ('last_modified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), )) db.send_create_signal('app', ['Event']) # Adding model 'Rehearsal' db.create_table(u'app_rehearsal', ( (u'event_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['app.Event'], unique=True, primary_key=True)), ('fika', self.gf('django.db.models.fields.CharField')(max_length=2)), ('location', self.gf('django.db.models.fields.CharField')(default=u'H\xe5lan', max_length=128)), ('time_hole', self.gf('django.db.models.fields.TimeField')(default=datetime.time(19, 0))), ('signup', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal('app', ['Rehearsal']) # Adding model 'Gig' db.create_table(u'app_gig', ( (u'event_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['app.Event'], unique=True, primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=128)), ('time_playing', self.gf('django.db.models.fields.TimeField')(null=True, blank=True)), ('location', self.gf('django.db.models.fields.CharField')(max_length=128, null=True, blank=True)), ('time_hole', self.gf('django.db.models.fields.TimeField')(null=True, blank=True)), ('signup', self.gf('django.db.models.fields.BooleanField')(default=True)), ('public_info', self.gf('django.db.models.fields.TextField')(blank=True)), ('secret', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal('app', ['Gig']) # Adding model 'Signup' db.create_table(u'app_signup', ( (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'])), ('event', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['app.Event'])), ('coming', self.gf('django.db.models.fields.CharField')(default='H', max_length=1)), ('car', self.gf('django.db.models.fields.BooleanField')()), ('comment', self.gf('django.db.models.fields.CharField')(max_length=128, blank=True)), ('last_modified', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), )) db.send_create_signal('app', ['Signup']) # Adding unique constraint on 'Signup', fields ['user', 'event'] db.create_unique(u'app_signup', ['user_id', 'event_id']) # Adding model 'Album' db.create_table(u'app_album', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=128)), ('image', self.gf('django.db.models.fields.related.ForeignKey')(related_name='image', to=orm['medialibrary.MediaFile'])), ('description', self.gf('django.db.models.fields.TextField')(blank=True)), ('year', self.gf('django.db.models.fields.IntegerField')()), )) db.send_create_signal('app', ['Album']) # Adding model 'Tune' db.create_table(u'app_album_tune', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('audio', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['medialibrary.MediaFile'])), ('parent', self.gf('django.db.models.fields.related.ForeignKey')(related_name='tune_set', to=orm['app.Album'])), ('region', self.gf('django.db.models.fields.CharField')(max_length=255)), ('ordering', self.gf('django.db.models.fields.IntegerField')(default=0)), )) db.send_create_signal('app', ['Tune']) # Adding model 'MailVerificationSent' db.create_table(u'app_mailverificationsent', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('email', self.gf('django.db.models.fields.CharField')(max_length=128)), ('sent', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), )) db.send_create_signal(u'app', ['MailVerificationSent'])
def forwards(self, orm): # Adding model 'ResourceSetting' db.create_table(u'resource_mgr_resourcesetting', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=20)), ('unit', self.gf('django.db.models.fields.CharField')(max_length=20)), ('conversion_rate', self.gf('django.db.models.fields.IntegerField')(default=1)), ('winning_order', self.gf('django.db.models.fields.CharField')(max_length=10)), )) db.send_create_signal(u'resource_mgr', ['ResourceSetting']) # Adding unique constraint on 'ResourceSetting', fields ['name'] db.create_unique(u'resource_mgr_resourcesetting', ['name']) # Adding model 'ResourceBlackoutDate' db.create_table(u'resource_mgr_resourceblackoutdate', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('date', self.gf('django.db.models.fields.DateField')()), ('description', self.gf('django.db.models.fields.CharField')( max_length=20, null=True, blank=True)), )) db.send_create_signal(u'resource_mgr', ['ResourceBlackoutDate']) # Adding model 'EnergyUsage' db.create_table(u'resource_mgr_energyusage', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('team', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['team_mgr.Team'])), ('date', self.gf('django.db.models.fields.DateField')( default=datetime.datetime(2013, 11, 21, 0, 0))), ('time', self.gf('django.db.models.fields.TimeField')( default=datetime.time(23, 19, 22, 836630))), ('manual_meter_reading', self.gf('django.db.models.fields.IntegerField')(default=0)), ('usage', self.gf('django.db.models.fields.IntegerField')(default=0)), ('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(u'resource_mgr', ['EnergyUsage']) # Adding unique constraint on 'EnergyUsage', fields ['date', 'team'] db.create_unique(u'resource_mgr_energyusage', ['date', 'team_id']) # Adding model 'WaterUsage' db.create_table(u'resource_mgr_waterusage', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('team', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['team_mgr.Team'])), ('date', self.gf('django.db.models.fields.DateField')( default=datetime.datetime(2013, 11, 21, 0, 0))), ('time', self.gf('django.db.models.fields.TimeField')( default=datetime.time(23, 19, 22, 836630))), ('manual_meter_reading', self.gf('django.db.models.fields.IntegerField')(default=0)), ('usage', self.gf('django.db.models.fields.IntegerField')(default=0)), ('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(u'resource_mgr', ['WaterUsage']) # Adding unique constraint on 'WaterUsage', fields ['date', 'team'] db.create_unique(u'resource_mgr_waterusage', ['date', 'team_id']) # Adding model 'WasteUsage' db.create_table(u'resource_mgr_wasteusage', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('team', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['team_mgr.Team'])), ('date', self.gf('django.db.models.fields.DateField')( default=datetime.datetime(2013, 11, 21, 0, 0))), ('time', self.gf('django.db.models.fields.TimeField')( default=datetime.time(23, 19, 22, 836630))), ('manual_meter_reading', self.gf('django.db.models.fields.IntegerField')(default=0)), ('usage', self.gf('django.db.models.fields.IntegerField')(default=0)), ('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(u'resource_mgr', ['WasteUsage']) # Adding unique constraint on 'WasteUsage', fields ['date', 'team'] db.create_unique(u'resource_mgr_wasteusage', ['date', 'team_id'])
def forwards(self, orm): # Adding field 'DayEntry.overtime' db.add_column(u'datebook_dayentry', 'overtime', self.gf('django.db.models.fields.TimeField')(default=datetime.time(0, 0)), keep_default=False)
def forwards(self, orm): # Adding model 'ResourceSetting' db.create_table(u'resource_mgr_resourcesetting', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=20)), ('unit', self.gf('django.db.models.fields.CharField')(max_length=20)), ('conversion_rate', self.gf('django.db.models.fields.IntegerField')(default=1)), ('winning_order', self.gf('django.db.models.fields.CharField')(max_length=10)), )) db.send_create_signal(u'resource_mgr', ['ResourceSetting']) # Adding unique constraint on 'ResourceSetting', fields ['name'] db.create_unique(u'resource_mgr_resourcesetting', ['name']) # Adding model 'ResourceBlackoutDate' db.create_table(u'resource_mgr_resourceblackoutdate', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('date', self.gf('django.db.models.fields.DateField')()), ('description', self.gf('django.db.models.fields.CharField')(max_length=20, null=True, blank=True)), )) db.send_create_signal(u'resource_mgr', ['ResourceBlackoutDate']) # Adding model 'EnergyUsage' db.create_table(u'resource_mgr_energyusage', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('team', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['team_mgr.Team'])), ('date', self.gf('django.db.models.fields.DateField')(default=datetime.datetime(2013, 11, 21, 0, 0))), ('time', self.gf('django.db.models.fields.TimeField')(default=datetime.time(23, 19, 22, 836630))), ('manual_meter_reading', self.gf('django.db.models.fields.IntegerField')(default=0)), ('usage', self.gf('django.db.models.fields.IntegerField')(default=0)), ('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(u'resource_mgr', ['EnergyUsage']) # Adding unique constraint on 'EnergyUsage', fields ['date', 'team'] db.create_unique(u'resource_mgr_energyusage', ['date', 'team_id']) # Adding model 'WaterUsage' db.create_table(u'resource_mgr_waterusage', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('team', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['team_mgr.Team'])), ('date', self.gf('django.db.models.fields.DateField')(default=datetime.datetime(2013, 11, 21, 0, 0))), ('time', self.gf('django.db.models.fields.TimeField')(default=datetime.time(23, 19, 22, 836630))), ('manual_meter_reading', self.gf('django.db.models.fields.IntegerField')(default=0)), ('usage', self.gf('django.db.models.fields.IntegerField')(default=0)), ('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(u'resource_mgr', ['WaterUsage']) # Adding unique constraint on 'WaterUsage', fields ['date', 'team'] db.create_unique(u'resource_mgr_waterusage', ['date', 'team_id']) # Adding model 'WasteUsage' db.create_table(u'resource_mgr_wasteusage', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('team', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['team_mgr.Team'])), ('date', self.gf('django.db.models.fields.DateField')(default=datetime.datetime(2013, 11, 21, 0, 0))), ('time', self.gf('django.db.models.fields.TimeField')(default=datetime.time(23, 19, 22, 836630))), ('manual_meter_reading', self.gf('django.db.models.fields.IntegerField')(default=0)), ('usage', self.gf('django.db.models.fields.IntegerField')(default=0)), ('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(u'resource_mgr', ['WasteUsage']) # Adding unique constraint on 'WasteUsage', fields ['date', 'team'] db.create_unique(u'resource_mgr_wasteusage', ['date', 'team_id'])
def forwards(self, orm): "Write your forwards methods here." # Note: Don't use "from appname.models import ModelName". # Use orm.ModelName to refer to models in this application, # and orm['appname.ModelName'] for models in other applications. if not db.dry_run: t = datetime.time() print 'Updating End Date of 18th Knesset to Start Date of 19th Knesset' new_end_date = orm['mks.Knesset'].objects.get(number=19).start_date knesset18 = orm['mks.Knesset'].objects.get(number=18) old_end_date = knesset18.end_date knesset18.end_date = new_end_date knesset18.save() print 'Updating End Date of Party Memberships for Membership ending on 18th knesset' old_memberships = orm['mks.Membership'].objects.filter(end_date = old_end_date) for m in old_memberships: m.end_date = new_end_date m.save() print 'Caching mk parties...' mkPartyLookup = {} for mk in orm['mks.Member'].objects.all(): mkPartyLookup[mk.id] = [(o.party_id, o.start_date, o.end_date) for o in mk.membership_set.all()] cnt = 0 print 'Caching votes...' voteLookup = {} for vote in orm.Vote.objects.all().only('id','time'): voteLookup[vote.id] = vote print 'This might take a while, there are %d VoteAction objects' % orm.VoteAction.objects.count() for i,action in enumerate(orm.VoteAction.objects.all()): parties = mkPartyLookup[action.member_id] action_time = voteLookup[action.vote_id].time cnt+=1 for party_id, start_date, end_date in parties: start_time = datetime.datetime.combine(start_date, t) if start_date else None end_time = datetime.datetime.combine(end_date, t) if end_date else None if (start_time is None and action_time < end_time) or \ (start_time <= action_time and end_time is None) or \ (start_time <= action_time and action_time < end_time): action.party_id = party_id action.save() break if action.party_id is None: print 'Could not find party for va %d at %s' % (action.id, str(action_time)) print 'Parties was:' pprint(parties) if cnt%5000 == 0: transaction.commit() print '%s: Migration At VoteAction %d' % (str(datetime.datetime.now()), cnt) transaction.commit() print 'Migration complete, validating results' print 'Caching mks membership...' membershipsLookup = {} for m in orm['mks.Membership'].objects.all(): if m.member_id in membershipsLookup: membershipsLookup[m.member_id].append(m) else: membershipsLookup[m.member_id] = [m] #copied from mks/models.py because orm.VoteAction objects are #frozen, not actual instance def party_at(mk_id, date): """Returns the party this memeber was at given date """ memberships = membershipsLookup.get(mk_id, []) for membership in memberships: if (not membership.start_date or membership.start_date <= date) and\ (not membership.end_date or membership.end_date > date): return membership.party_id return None print 'Caching party ids...' partyIds = set(orm['mks.Party'].objects.values_list('id', flat=True)) print 'Validating...' # validate results cnt = 0 for va in orm.VoteAction.objects.all(): cnt+=1 if not va.party_id in partyIds: print "VA %d party does not exist" % va.id continue p1 = va.party_id p2 = party_at(va.member_id, voteLookup[va.vote_id].time.date()) if p1 != p2: print "mismatch in VA %d, %d vs %d" % (va.id, p1, p2) if cnt%10000 == 0: print '%s: Validation At VoteAction %d' % (str(datetime.datetime.now()), cnt)
def forwards(self, orm): # Adding field 'WebRequest.time' db.add_column(u'my_middleware_webrequest', 'time', self.gf('django.db.models.fields.TimeField')(auto_now_add=True, default=datetime.time(21, 13, 38, 123712), blank=True), keep_default=False)