added media app and migrations to move photo data

1 files changed, 70 insertions, 0 deletions

diff --git a/app/media/migrations/0006_auto_20201201_2145.py b/app/media/migrations/0006_auto_20201201_2145.py
new file mode 100644
index 0000000..9827416
--- /dev/null
+++ b/app/media/migrations/0006_auto_20201201_2145.py
@@ -0,0 +1,70 @@
+# Generated by Django 3.1 on 2020-12-01 21:45
+
+from django.db import migrations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('media', '0005_auto_20201201_2141'),
+    ]
+
+    operations = [
+        migrations.RunSQL("""
+            INSERT INTO media_luxaudio (
+                id,
+                title,
+                subtitle,
+                slug,
+                body_html,
+                body_markdown,
+                pub_date,
+                mp3,
+                ogg,
+                point,
+                location_id
+            )
+            SELECT 
+                id,
+                title,
+                subtitle,
+                slug,
+                body_html,
+                body_markdown,
+                pub_date,
+                mp3,
+                ogg,
+                point,
+                location_id
+            FROM
+                recordings_audio;
+        """, reverse_sql="""
+            INSERT INTO recordings_audio (
+                id,
+                title,
+                subtitle,
+                slug,
+                body_html,
+                body_markdown,
+                pub_date,
+                mp3,
+                ogg,
+                point,
+                location_id
+            )
+            SELECT
+                id,
+                title,
+                subtitle,
+                slug,
+                body_html,
+                body_markdown,
+                pub_date,
+                mp3,
+                ogg,
+                point,
+                location_id
+            FROM
+                media_luxaudio;
+        """)
+    ]