summaryrefslogtreecommitdiff
path: root/program/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'program/migrations')
-rw-r--r--program/migrations/0001_initial.py228
-rw-r--r--program/migrations/0002_host_is_always_visible.py19
-rw-r--r--program/migrations/0003_host_is_active.py19
-rw-r--r--program/migrations/0004_show_is_active.py19
-rw-r--r--program/migrations/0005_programslot_is_active.py19
-rw-r--r--program/migrations/__init__.py0
6 files changed, 304 insertions, 0 deletions
diff --git a/program/migrations/0001_initial.py b/program/migrations/0001_initial.py
new file mode 100644
index 0000000..bb417c9
--- /dev/null
+++ b/program/migrations/0001_initial.py
@@ -0,0 +1,228 @@
+# -*- coding: utf-8 -*-
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+import tinymce.models
+from django.conf import settings
+
+
+class Migration(migrations.Migration):
+
+ dependencies = [
+ migrations.swappable_dependency(settings.AUTH_USER_MODEL),
+ ]
+
+ operations = [
+ migrations.CreateModel(
+ name='BroadcastFormat',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('format', models.CharField(max_length=32, verbose_name='Format')),
+ ('slug', models.SlugField(unique=True, max_length=32, verbose_name='Slug')),
+ ('color', models.CharField(default=b'#ffffff', max_length=7, verbose_name='Color')),
+ ('text_color', models.CharField(default=b'#000000', max_length=7, verbose_name='Text color')),
+ ('enabled', models.BooleanField(default=True, verbose_name='Enabled')),
+ ],
+ options={
+ 'ordering': ('format',),
+ 'verbose_name': 'Broadcast format',
+ 'verbose_name_plural': 'Broadcast formats',
+ },
+ ),
+ migrations.CreateModel(
+ name='Host',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('name', models.CharField(max_length=128, verbose_name='Name')),
+ ('email', models.EmailField(max_length=254, verbose_name='E-Mail', blank=True)),
+ ('website', models.URLField(verbose_name='Website', blank=True)),
+ ],
+ options={
+ 'ordering': ('name',),
+ 'verbose_name': 'Host',
+ 'verbose_name_plural': 'Hosts',
+ },
+ ),
+ migrations.CreateModel(
+ name='MusicFocus',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('focus', models.CharField(max_length=32, verbose_name='Focus')),
+ ('abbrev', models.CharField(unique=True, max_length=4, verbose_name='Abbreviation')),
+ ('slug', models.SlugField(unique=True, max_length=32, verbose_name='Slug')),
+ ('button', models.ImageField(upload_to=b'buttons', null=True, verbose_name='Button image', blank=True)),
+ ('button_hover', models.ImageField(upload_to=b'buttons', null=True, verbose_name='Button image (hover)', blank=True)),
+ ('big_button', models.ImageField(upload_to=b'buttons', null=True, verbose_name='Big button image', blank=True)),
+ ],
+ options={
+ 'ordering': ('focus',),
+ 'verbose_name': 'Music focus',
+ 'verbose_name_plural': 'Music focus',
+ },
+ ),
+ migrations.CreateModel(
+ name='Note',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('title', models.CharField(max_length=128, verbose_name='Title')),
+ ('content', tinymce.models.HTMLField(verbose_name='Content')),
+ ('status', models.IntegerField(default=1, verbose_name='Status', choices=[(0, 'Cancellation'), (1, 'Recommendation'), (2, 'Repetition')])),
+ ('cba_entry_id', models.IntegerField(null=True, verbose_name='CBA entry ID', blank=True)),
+ ('start', models.DateTimeField(editable=False)),
+ ('created', models.DateTimeField(auto_now_add=True)),
+ ('last_updated', models.DateTimeField(auto_now=True)),
+ ],
+ options={
+ 'ordering': ('timeslot',),
+ 'verbose_name': 'Note',
+ 'verbose_name_plural': 'Notes',
+ },
+ ),
+ migrations.CreateModel(
+ name='ProgramSlot',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('byweekday', models.IntegerField(verbose_name='Weekday', choices=[(0, 'Monday'), (1, 'Tuesday'), (2, 'Wednesday'), (3, 'Thursday'), (4, 'Friday'), (5, 'Saturday'), (6, 'Sunday')])),
+ ('dstart', models.DateField(verbose_name='First date')),
+ ('tstart', models.TimeField(verbose_name='Start time')),
+ ('tend', models.TimeField(verbose_name='End time')),
+ ('until', models.DateField(verbose_name='Last date')),
+ ('is_repetition', models.BooleanField(default=False, verbose_name='Is repetition')),
+ ('automation_id', models.IntegerField(blank=True, null=True, verbose_name='Automation ID', choices=[])),
+ ('created', models.DateTimeField(auto_now_add=True)),
+ ('last_updated', models.DateTimeField(auto_now=True)),
+ ],
+ options={
+ 'ordering': ('dstart', 'tstart'),
+ 'verbose_name': 'Program slot',
+ 'verbose_name_plural': 'Program slots',
+ },
+ ),
+ migrations.CreateModel(
+ name='RRule',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('name', models.CharField(unique=True, max_length=32, verbose_name='Name')),
+ ('freq', models.IntegerField(verbose_name='Frequency', choices=[(1, 'Monthly'), (2, 'Weekly'), (3, 'Daily')])),
+ ('interval', models.IntegerField(default=1, verbose_name='Interval')),
+ ('bysetpos', models.IntegerField(blank=True, null=True, verbose_name='Set position', choices=[(1, 'First'), (2, 'Second'), (3, 'Third'), (4, 'Fourth'), (5, 'Fifth'), (-1, 'Last')])),
+ ('count', models.IntegerField(null=True, verbose_name='Count', blank=True)),
+ ],
+ options={
+ 'ordering': ('-freq', 'interval', 'bysetpos'),
+ 'verbose_name': 'Recurrence rule',
+ 'verbose_name_plural': 'Recurrence rules',
+ },
+ ),
+ migrations.CreateModel(
+ name='Show',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('name', models.CharField(max_length=255, verbose_name='Name')),
+ ('slug', models.CharField(unique=True, max_length=255, verbose_name='Slug')),
+ ('image', models.ImageField(upload_to=b'show_images', null=True, verbose_name='Image', blank=True)),
+ ('image_enabled', models.BooleanField(default=True, verbose_name='show Image')),
+ ('short_description', models.CharField(max_length=64, verbose_name='Short description')),
+ ('description', tinymce.models.HTMLField(null=True, verbose_name='Description', blank=True)),
+ ('email', models.EmailField(max_length=254, null=True, verbose_name='E-Mail', blank=True)),
+ ('website', models.URLField(null=True, verbose_name='Website', blank=True)),
+ ('cba_series_id', models.IntegerField(null=True, verbose_name='CBA series ID', blank=True)),
+ ('automation_id', models.IntegerField(blank=True, null=True, verbose_name='Automation ID', choices=[])),
+ ('created', models.DateTimeField(auto_now_add=True)),
+ ('last_updated', models.DateTimeField(auto_now=True)),
+ ('broadcastformat', models.ForeignKey(related_name='shows', verbose_name='Broadcast format', to='program.BroadcastFormat')),
+ ('hosts', models.ManyToManyField(related_name='shows', verbose_name='Hosts', to='program.Host', blank=True)),
+ ('musicfocus', models.ManyToManyField(related_name='shows', verbose_name='Music focus', to='program.MusicFocus', blank=True)),
+ ('owners', models.ManyToManyField(related_name='shows', verbose_name='Owners', to=settings.AUTH_USER_MODEL, blank=True)),
+ ('predecessor', models.ForeignKey(related_name='successors', verbose_name='Predecessor', blank=True, to='program.Show', null=True)),
+ ],
+ options={
+ 'ordering': ('slug',),
+ 'verbose_name': 'Show',
+ 'verbose_name_plural': 'Shows',
+ },
+ ),
+ migrations.CreateModel(
+ name='ShowInformation',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('information', models.CharField(max_length=32, verbose_name='Information')),
+ ('abbrev', models.CharField(unique=True, max_length=4, verbose_name='Abbreviation')),
+ ('slug', models.SlugField(unique=True, max_length=32, verbose_name='Slug')),
+ ('button', models.ImageField(upload_to=b'buttons', null=True, verbose_name='Button image', blank=True)),
+ ('button_hover', models.ImageField(upload_to=b'buttons', null=True, verbose_name='Button image (hover)', blank=True)),
+ ('big_button', models.ImageField(upload_to=b'buttons', null=True, verbose_name='Big button image', blank=True)),
+ ],
+ options={
+ 'ordering': ('information',),
+ 'verbose_name': 'Show information',
+ 'verbose_name_plural': 'Show information',
+ },
+ ),
+ migrations.CreateModel(
+ name='ShowTopic',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('topic', models.CharField(max_length=32, verbose_name='Show topic')),
+ ('abbrev', models.CharField(unique=True, max_length=4, verbose_name='Abbreviation')),
+ ('slug', models.SlugField(unique=True, max_length=32, verbose_name='Slug')),
+ ('button', models.ImageField(upload_to=b'buttons', null=True, verbose_name='Button image', blank=True)),
+ ('button_hover', models.ImageField(upload_to=b'buttons', null=True, verbose_name='Button image (hover)', blank=True)),
+ ('big_button', models.ImageField(upload_to=b'buttons', null=True, verbose_name='Big button image', blank=True)),
+ ],
+ options={
+ 'ordering': ('topic',),
+ 'verbose_name': 'Show topic',
+ 'verbose_name_plural': 'Show topics',
+ },
+ ),
+ migrations.CreateModel(
+ name='TimeSlot',
+ fields=[
+ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
+ ('start', models.DateTimeField(unique=True, verbose_name='Start time')),
+ ('end', models.DateTimeField(verbose_name='End time')),
+ ('programslot', models.ForeignKey(related_name='timeslots', verbose_name='Program slot', to='program.ProgramSlot')),
+ ('show', models.ForeignKey(related_name='timeslots', editable=False, to='program.Show')),
+ ],
+ options={
+ 'ordering': ('start', 'end'),
+ 'verbose_name': 'Time slot',
+ 'verbose_name_plural': 'Time slots',
+ },
+ ),
+ migrations.AddField(
+ model_name='show',
+ name='showinformation',
+ field=models.ManyToManyField(related_name='shows', verbose_name='Show information', to='program.ShowInformation', blank=True),
+ ),
+ migrations.AddField(
+ model_name='show',
+ name='showtopic',
+ field=models.ManyToManyField(related_name='shows', verbose_name='Show topic', to='program.ShowTopic', blank=True),
+ ),
+ migrations.AddField(
+ model_name='programslot',
+ name='rrule',
+ field=models.ForeignKey(related_name='programslots', verbose_name='Recurrence rule', to='program.RRule'),
+ ),
+ migrations.AddField(
+ model_name='programslot',
+ name='show',
+ field=models.ForeignKey(related_name='programslots', verbose_name='Show', to='program.Show'),
+ ),
+ migrations.AddField(
+ model_name='note',
+ name='show',
+ field=models.ForeignKey(related_name='notes', editable=False, to='program.Show'),
+ ),
+ migrations.AddField(
+ model_name='note',
+ name='timeslot',
+ field=models.OneToOneField(verbose_name='Time slot', to='program.TimeSlot'),
+ ),
+ migrations.AlterUniqueTogether(
+ name='programslot',
+ unique_together=set([('rrule', 'byweekday', 'dstart', 'tstart')]),
+ ),
+ ]
diff --git a/program/migrations/0002_host_is_always_visible.py b/program/migrations/0002_host_is_always_visible.py
new file mode 100644
index 0000000..9abf2bd
--- /dev/null
+++ b/program/migrations/0002_host_is_always_visible.py
@@ -0,0 +1,19 @@
+# -*- coding: utf-8 -*-
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+ dependencies = [
+ ('program', '0001_initial'),
+ ]
+
+ operations = [
+ migrations.AddField(
+ model_name='host',
+ name='is_always_visible',
+ field=models.BooleanField(default=False, verbose_name='Is always visible'),
+ ),
+ ]
diff --git a/program/migrations/0003_host_is_active.py b/program/migrations/0003_host_is_active.py
new file mode 100644
index 0000000..28c1049
--- /dev/null
+++ b/program/migrations/0003_host_is_active.py
@@ -0,0 +1,19 @@
+# -*- coding: utf-8 -*-
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+ dependencies = [
+ ('program', '0002_host_is_always_visible'),
+ ]
+
+ operations = [
+ migrations.AddField(
+ model_name='host',
+ name='is_active',
+ field=models.BooleanField(default=True, verbose_name='Is active', editable=False),
+ ),
+ ]
diff --git a/program/migrations/0004_show_is_active.py b/program/migrations/0004_show_is_active.py
new file mode 100644
index 0000000..26e3205
--- /dev/null
+++ b/program/migrations/0004_show_is_active.py
@@ -0,0 +1,19 @@
+# -*- coding: utf-8 -*-
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+ dependencies = [
+ ('program', '0003_host_is_active'),
+ ]
+
+ operations = [
+ migrations.AddField(
+ model_name='show',
+ name='is_active',
+ field=models.BooleanField(default=True, verbose_name='Is active', editable=False),
+ ),
+ ]
diff --git a/program/migrations/0005_programslot_is_active.py b/program/migrations/0005_programslot_is_active.py
new file mode 100644
index 0000000..31975c8
--- /dev/null
+++ b/program/migrations/0005_programslot_is_active.py
@@ -0,0 +1,19 @@
+# -*- coding: utf-8 -*-
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+ dependencies = [
+ ('program', '0004_show_is_active'),
+ ]
+
+ operations = [
+ migrations.AddField(
+ model_name='programslot',
+ name='is_active',
+ field=models.BooleanField(default=True, verbose_name='Is active', editable=False),
+ ),
+ ]
diff --git a/program/migrations/__init__.py b/program/migrations/__init__.py
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/program/migrations/__init__.py