added media app and migrations to move photo data

1 files changed, 56 insertions, 0 deletions

diff --git a/app/media/migrations/0005_auto_20201201_2141.py b/app/media/migrations/0005_auto_20201201_2141.py
new file mode 100644
index 0000000..e211ea2
--- /dev/null
+++ b/app/media/migrations/0005_auto_20201201_2141.py
@@ -0,0 +1,56 @@
+# Generated by Django 3.1 on 2020-12-01 21:41
+
+from django.db import migrations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('media', '0004_auto_20201201_2139'),
+    ]
+
+    operations = [
+        migrations.RunSQL("""
+            INSERT INTO media_luxvideo(
+                id,
+                video_mp4,
+                video_webm,
+                video_poster,
+                title,
+                pub_date,
+                youtube_url,
+                vimeo_url
+            )
+            SELECT 
+                id,
+                video_mp4,
+                video_webm,
+                video_poster,
+                title,
+                pub_date,
+                youtube_url,
+                vimeo_url
+            FROM
+                photos_luxvideo;
+        """, reverse_sql="""
+            INSERT INTO photos_luxvideos(
+                video_mp4,
+                video_webm,
+                video_poster,
+                title,
+                pub_date,
+                youtube_url,
+                vimeo_url
+            )
+            SELECT
+                video_mp4,
+                video_webm,
+                video_poster,
+                title,
+                pub_date,
+                youtube_url,
+                vimeo_url
+            FROM
+                media_luxvideo;
+        """)
+    ]