Python Migration Beispiele

Beispiel #1

Datei: 039_gareth53_apps_podcast_models.py Projekt: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(
    sql_up=[
        """
    CREATE TABLE `podcast_tracklisting` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `track_number` integer NOT NULL,
        `track_id` integer NOT NULL,
        `episode_id` integer NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `podcast_tracklisting` ADD CONSTRAINT `episode_id_refs_id_b58e318` FOREIGN KEY (`episode_id`) REFERENCES `podcast_episode` (`id`);
"""
    ],
    sql_down=["""
    DROP TABLE `podcast_tracklisting`;
"""])

Beispiel #2

Datei: 056_blog_category_make_nullable.py Projekt: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=[
    """
    ALTER TABLE `blog_blogcategory` MODIFY `use_count` integer NULL 
"""
],
                        sql_down=["""
    """])

Beispiel #3

migration = m.Migration(sql_up=["""
    CREATE TABLE `lastfm_user` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `lastfm_username` varchar(255) NOT NULL,
        `profile_url` varchar(200) NOT NULL,
        `profile_pic` varchar(255) NOT NULL,
        `feed_url` varchar(200) NOT NULL,
        `slug` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `lastfm_scrobble` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL,
        `date_time` datetime NULL,
        `date_retrieved` datetime NULL,
        `track_id` integer NULL,
        `lastfm_track_title` varchar(255) NOT NULL,
        `lastfm_artist` varchar(255) NOT NULL,
        `lastfm_track_url` varchar(200)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `lastfm_scrobble` ADD CONSTRAINT `user_id_refs_id_310f68d8` FOREIGN KEY (`user_id`) REFERENCES `lastfm_user` (`id`);
""", """
    -- The following references should be added but depend on non-existent tables:
""", """
    -- ALTER TABLE `lastfm_scrobble` ADD CONSTRAINT `track_id_refs_id_1c3f4127` FOREIGN KEY (`track_id`) REFERENCES `musicartists_track` (`id`);
"""], sql_down=["""
    DROP TABLE `lastfm_scrobble`;
""", """
    DROP TABLE `lastfm_user`;
"""])

Beispiel #4

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(
    sql_up=[
        """
    CREATE TABLE `articles_articlecategory` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `title` varchar(200) NOT NULL,
        `slug` varchar(50) NOT NULL,
        `description` longtext NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
    ],
    sql_down=["""
    DROP TABLE `articles_articlecategory`;
"""])

Beispiel #5

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=[
    """
    CREATE TABLE `articles_promo` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(200) NOT NULL,
        `headline` varchar(200) NOT NULL,
        `headline_link` varchar(200) NULL,
        `body_html` longtext NOT NULL,
        `article_link_id` integer NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
],
                        sql_down=["""
    DROP TABLE `articles_promo`;
"""])

Beispiel #6

Datei: 063_django_contrib_comments_models.py Projekt: gareth53/gareth53_v1

migration = m.Migration(sql_up=[
    """
    CREATE TABLE `django_comments` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `content_type_id` integer NOT NULL,
        `object_pk` longtext NOT NULL,
        `site_id` integer NOT NULL,
        `user_id` integer,
        `user_name` varchar(50) NOT NULL,
        `user_email` varchar(75) NOT NULL,
        `user_url` varchar(200) NOT NULL,
        `comment` longtext NOT NULL,
        `submit_date` datetime NOT NULL,
        `ip_address` char(15),
        `is_public` bool NOT NULL,
        `is_removed` bool NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `django_comments` ADD CONSTRAINT `content_type_id_refs_id_d5868a5` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);
""", """
    ALTER TABLE `django_comments` ADD CONSTRAINT `site_id_refs_id_7248df08` FOREIGN KEY (`site_id`) REFERENCES `django_site` (`id`);
""", """
    ALTER TABLE `django_comments` ADD CONSTRAINT `user_id_refs_id_7e9ddfef` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    CREATE TABLE `django_comment_flags` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL,
        `comment_id` integer NOT NULL,
        `flag` varchar(30) NOT NULL,
        `flag_date` datetime NOT NULL,
        UNIQUE (`user_id`, `comment_id`, `flag`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `django_comment_flags` ADD CONSTRAINT `user_id_refs_id_603c4dcb` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    ALTER TABLE `django_comment_flags` ADD CONSTRAINT `comment_id_refs_id_373a05f7` FOREIGN KEY (`comment_id`) REFERENCES `django_comments` (`id`);
"""
],
                        sql_down=[
                            """
    DROP TABLE `django_comment_flags`;
""", """
    DROP TABLE `django_comments`;
"""
                        ])

Beispiel #7

migration = m.Migration(sql_up=[
    """
    CREATE TABLE `navigation_navigationlink` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `text` varchar(200) NOT NULL,
        `link` varchar(75) NOT NULL,
        `rank` integer NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `navigation_navigation` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(100) NOT NULL,
        `description` longtext NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `navigation_navigation_links` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `navigation_id` integer NOT NULL,
        `navigationlink_id` integer NOT NULL,
        UNIQUE (`navigation_id`, `navigationlink_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `navigation_navigation_links` ADD CONSTRAINT `navigation_id_refs_id_24c3ba3d` FOREIGN KEY (`navigation_id`) REFERENCES `navigation_navigation` (`id`);
""", """
    ALTER TABLE `navigation_navigation_links` ADD CONSTRAINT `navigationlink_id_refs_id_28278353` FOREIGN KEY (`navigationlink_id`) REFERENCES `navigation_navigationlink` (`id`);
"""
],
                        sql_down=[
                            """
    DROP TABLE `navigation_navigation_links`;
""", """
    DROP TABLE `navigation_navigation`;
""", """
    DROP TABLE `navigation_navigationlink`;
"""
                        ])

Beispiel #8

Datei: 010_gareth53_apps_podcast_models.py Projekt: gareth53/gareth53_v1

migration = m.Migration(sql_up=[
    """
    CREATE TABLE `podcast_artist` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(50) NOT NULL,
        `official_URL` varchar(200) NULL,
        `wikipedia_URL` varchar(200) NULL,
        `slug` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `podcast_album` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `album_artist_id` integer NOT NULL,
        `title` varchar(100) NOT NULL,
        `amazon_URL` varchar(200) NULL,
        `slug` varchar(50) NOT NULL,
        `release_year` varchar(4) NOT NULL,
        `artwork` varchar(100) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `podcast_album` ADD CONSTRAINT `album_artist_id_refs_id_5defcdba` FOREIGN KEY (`album_artist_id`) REFERENCES `podcast_artist` (`id`);
""", """
    CREATE TABLE `podcast_track` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `track_title` varchar(30) NOT NULL,
        `album_id` integer NULL,
        `artist_id` integer NOT NULL,
        `track_number` integer NOT NULL,
        `track_year` varchar(4) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `podcast_track` ADD CONSTRAINT `album_id_refs_id_45ec5c5` FOREIGN KEY (`album_id`) REFERENCES `podcast_album` (`id`);
""", """
    ALTER TABLE `podcast_track` ADD CONSTRAINT `artist_id_refs_id_70cd4dfa` FOREIGN KEY (`artist_id`) REFERENCES `podcast_artist` (`id`);
""", """
    CREATE TABLE `podcast_episode` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `title` varchar(50) NOT NULL,
        `subtitle` varchar(200) NULL,
        `cover_image` varchar(100) NOT NULL,
        `episode_number` integer NOT NULL,
        `season_number` integer NOT NULL,
        `description` varchar(200) NOT NULL,
        `media_URL` varchar(200) NULL,
        `primary_keywords` varchar(100) NULL,
        `secondary_keywords` longtext NULL,
        `author_name` varchar(50) NOT NULL,
        `author_email` varchar(75) NOT NULL,
        `body_html` longtext NOT NULL,
        `notes_and_errata` longtext NULL,
        `pub_date` datetime NOT NULL,
        `enable_comments` bool NOT NULL,
        `slug` varchar(50) NULL,
        `status` integer NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `podcast_episode_tracks` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `episode_id` integer NOT NULL,
        `track_id` integer NOT NULL,
        UNIQUE (`episode_id`, `track_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `podcast_episode_tracks` ADD CONSTRAINT `episode_id_refs_id_76837f6d` FOREIGN KEY (`episode_id`) REFERENCES `podcast_episode` (`id`);
""", """
    ALTER TABLE `podcast_episode_tracks` ADD CONSTRAINT `track_id_refs_id_485e58a5` FOREIGN KEY (`track_id`) REFERENCES `podcast_track` (`id`);
"""
],
                        sql_down=[
                            """
    DROP TABLE `podcast_episode_tracks`;
""", """
    DROP TABLE `podcast_episode`;
""", """
    DROP TABLE `podcast_track`;
""", """
    DROP TABLE `podcast_album`;
""", """
    DROP TABLE `podcast_artist`;
"""
                        ])

Beispiel #9

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=["""
    CREATE TABLE `articles_article` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `title` varchar(200) NOT NULL,
        `slug` varchar(50) NOT NULL,
        `body_html` longtext NOT NULL,
        `pub_date` datetime NOT NULL,
        `status` integer NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""], sql_down=["""
    DROP TABLE `articles_article`;
"""])

Beispiel #10

migration = m.Migration(sql_up=["""
    CREATE TABLE `auth_permission` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(50) NOT NULL,
        `content_type_id` integer NOT NULL,
        `codename` varchar(100) NOT NULL,
        UNIQUE (`content_type_id`, `codename`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `auth_group` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(80) NOT NULL UNIQUE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `auth_user` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `username` varchar(30) NOT NULL UNIQUE,
        `first_name` varchar(30) NOT NULL,
        `last_name` varchar(30) NOT NULL,
        `email` varchar(75) NOT NULL,
        `password` varchar(128) NOT NULL,
        `is_staff` bool NOT NULL,
        `is_active` bool NOT NULL,
        `is_superuser` bool NOT NULL,
        `last_login` datetime NOT NULL,
        `date_joined` datetime NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `auth_message` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL,
        `message` longtext NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `auth_message` ADD CONSTRAINT `user_id_refs_id_650f49a6` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    CREATE TABLE `auth_group_permissions` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `group_id` integer NOT NULL,
        `permission_id` integer NOT NULL,
        UNIQUE (`group_id`, `permission_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `auth_group_permissions` ADD CONSTRAINT `group_id_refs_id_3cea63fe` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);
""", """
    ALTER TABLE `auth_group_permissions` ADD CONSTRAINT `permission_id_refs_id_5886d21f` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`);
""", """
    CREATE TABLE `auth_user_groups` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL,
        `group_id` integer NOT NULL,
        UNIQUE (`user_id`, `group_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `auth_user_groups` ADD CONSTRAINT `user_id_refs_id_7ceef80f` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    ALTER TABLE `auth_user_groups` ADD CONSTRAINT `group_id_refs_id_f116770` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);
""", """
    CREATE TABLE `auth_user_user_permissions` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL,
        `permission_id` integer NOT NULL,
        UNIQUE (`user_id`, `permission_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `auth_user_user_permissions` ADD CONSTRAINT `user_id_refs_id_dfbab7d` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    ALTER TABLE `auth_user_user_permissions` ADD CONSTRAINT `permission_id_refs_id_67e79cb` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`);
""", """
    -- The following references should be added but depend on non-existent tables:
""", """
    -- ALTER TABLE `auth_permission` ADD CONSTRAINT `content_type_id_refs_id_728de91f` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);
"""], sql_down=["""
    DROP TABLE `auth_user_user_permissions`;
""", """
    DROP TABLE `auth_user_groups`;
""", """
    DROP TABLE `auth_group_permissions`;
""", """
    DROP TABLE `auth_message`;
""", """
    DROP TABLE `auth_user`;
""", """
    DROP TABLE `auth_group`;
""", """
    DROP TABLE `auth_permission`;
"""])

Beispiel #11

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=[
    """
    CREATE TABLE `django_site` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `domain` varchar(100) NOT NULL,
        `name` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
],
                        sql_down=["""
    DROP TABLE `django_site`;
"""])

Beispiel #12

Datei: 054_remove_column_tracks_from_episode.py Projekt: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(
    sql_up=["""
    DROP TABLE `podcast_episode_tracks`;
"""],
    sql_down=[
        """
        CREATE TABLE `podcast_episode_tracks` (
            `id` integer AUTO_INCREMENT NULL PRIMARY KEY,
            `episode_id` integer NULL,
            `track_id` integer NULL,
            UNIQUE (`episode_id`, `track_id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
        ;
    """
    ])

Beispiel #13

Datei: 003_django_contrib_sessions_models.py Projekt: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=["""
    CREATE TABLE `django_session` (
        `session_key` varchar(40) NOT NULL PRIMARY KEY,
        `session_data` longtext NOT NULL,
        `expire_date` datetime NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""], sql_down=["""
    DROP TABLE `django_session`;
"""])

Beispiel #14

migration = m.Migration(sql_up=[
    """
    CREATE TABLE `flickr_user` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(50) NOT NULL,
        `profile_url` varchar(200),
        `profile_pic` varchar(255),
        `feed_url` varchar(200) NOT NULL,
        `slug` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `flickr_image` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `date_retrieved` datetime NOT NULL,
        `photo_id` varchar(100) NOT NULL,
        `photo_secret` varchar(100) NOT NULL,
        `server` varchar(100) NOT NULL,
        `server_farm` varchar(100) NOT NULL,
        `title` varchar(255) NOT NULL,
        `description` varchar(255) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
],
                        sql_down=[
                            """
    DROP TABLE `flickr_image`;
""", """
    DROP TABLE `flickr_user`;
"""
                        ])

Beispiel #15

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=[
    """
    ALTER TABLE `podcast_track` MODIFY `artist_id` integer NULL; 
    ALTER TABLE `podcast_album` MODIFY `album_artist_id` integer NULL; 
    UPDATE podcast_album SET album_artist_id=NULL WHERE album_artist_id=59;
    DELETE FROM podcast_artist WHERE name='Various';
"""
],
                        sql_down=[
                            """
    INSERT INTO podcast_artist (id, name, slug) VALUES (999, 'Various', 'various');
    UPDATE podcast_album SET album_artist_id=999 WHERE album_artist_id=NULL;
    ALTER TABLE `podcast_track` MODIFY `artist_id` integer NOT NULL; 
    ALTER TABLE `podcast_album` MODIFY `album_artist_id` integer NOT NULL; 

    """
                        ])

Beispiel #16

Datei: 006_gareth53_apps_blog_models.py Projekt: gareth53/gareth53_v1

migration = m.Migration(sql_up=[
    """
    CREATE TABLE `blog_blogcategory` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `title` varchar(200) NOT NULL,
        `slug` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `blog_entry` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `title` varchar(200) NOT NULL,
        `slug` varchar(50) NOT NULL,
        `body_html` longtext NOT NULL,
        `pub_date` datetime NOT NULL,
        `enable_comments` bool NOT NULL,
        `category_id` integer NULL,
        `status` integer NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `blog_entry` ADD CONSTRAINT `category_id_refs_id_7f27fd1e` FOREIGN KEY (`category_id`) REFERENCES `blog_blogcategory` (`id`);
"""
],
                        sql_down=[
                            """
    DROP TABLE `blog_entry`;
""", """
    DROP TABLE `blog_blogcategory`;
"""
                        ])

Beispiel #17

Datei: 002_django_contrib_contenttypes_models.py Projekt: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(
    sql_up=[
        """
    CREATE TABLE `django_content_type` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(100) NOT NULL,
        `app_label` varchar(100) NOT NULL,
        `model` varchar(100) NOT NULL,
        UNIQUE (`app_label`, `model`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
    ],
    sql_down=["""
    DROP TABLE `django_content_type`;
"""])

Beispiel #18

Datei: 055_remove_track_number_from_podcast_track.py Projekt: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=["""
    ALTER TABLE `podcast_track` DROP `track_number`;
"""], sql_down=["""
        ALTER TABLE podcast_track ADD track_number INTEGER NULL AFTER artist_id;
    """])

Beispiel #19

migration = m.Migration(sql_up=["""
    CREATE TABLE `musicartists_artist` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(255) NOT NULL,
        `official_URL` varchar(255),
        `wikipedia_URL` varchar(255),
        `slug` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `musicartists_album` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `album_artist_id` integer,
        `title` varchar(255) NOT NULL,
        `amazon_URL` varchar(255),
        `slug` varchar(50) NOT NULL,
        `release_year` varchar(4) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `musicartists_album` ADD CONSTRAINT `album_artist_id_refs_id_3dd1f5e6` FOREIGN KEY (`album_artist_id`) REFERENCES `musicartists_artist` (`id`);
""", """
    CREATE TABLE `musicartists_track` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `track_title` varchar(255) NOT NULL,
        `album_id` integer,
        `artist_id` integer,
        `track_year` varchar(4) NOT NULL,
        `image_large` varchar(255),
        `image_medium` varchar(255),
        `image_small` varchar(255)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `musicartists_track` ADD CONSTRAINT `album_id_refs_id_6ac3c11b` FOREIGN KEY (`album_id`) REFERENCES `musicartists_album` (`id`);
""", """
    ALTER TABLE `musicartists_track` ADD CONSTRAINT `artist_id_refs_id_1d8c6786` FOREIGN KEY (`artist_id`) REFERENCES `musicartists_artist` (`id`);
"""], sql_down=["""
    DROP TABLE `musicartists_track`;
""", """
    DROP TABLE `musicartists_album`;
""", """
    DROP TABLE `musicartists_artist`;
"""])

Beispiel #20

Datei: 051_django_contrib_redirects_models.py Projekt: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=[
    """
    CREATE TABLE `django_redirect` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `site_id` integer NOT NULL,
        `old_path` varchar(200) NOT NULL,
        `new_path` varchar(200) NOT NULL,
        UNIQUE (`site_id`, `old_path`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `django_redirect` ADD CONSTRAINT `site_id_refs_id_4aa27aa6` FOREIGN KEY (`site_id`) REFERENCES `django_site` (`id`);
"""
],
                        sql_down=["""
    DROP TABLE `django_redirect`;
"""])

Beispiel #21

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime

migration = m.Migration(sql_up=[
    """
    CREATE TABLE `django_admin_log` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `action_time` datetime NOT NULL,
        `user_id` integer NOT NULL,
        `content_type_id` integer NULL,
        `object_id` longtext NULL,
        `object_repr` varchar(200) NOT NULL,
        `action_flag` smallint UNSIGNED NOT NULL,
        `change_message` longtext NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    -- The following references should be added but depend on non-existent tables:
""", """
    -- ALTER TABLE `django_admin_log` ADD CONSTRAINT `user_id_refs_id_c8665aa` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    -- ALTER TABLE `django_admin_log` ADD CONSTRAINT `content_type_id_refs_id_288599e6` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);
"""
],
                        sql_down=["""
    DROP TABLE `django_admin_log`;
"""])