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)
