migrations/006_registration_models.py

   1 from dmigrations.mysql import migrations as m
   2 import datetime
   3 migration = m.Migration(sql_up=["""
   4     CREATE TABLE `registration_registrationprofile` (
   5         `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
   6         `user_id` integer NOT NULL UNIQUE,
   7         `activation_key` varchar(40) NOT NULL
   8     ) ENGINE=InnoDB DEFAULT CHARSET=utf8
   9     ;
  10 """, """
  11     ALTER TABLE `registration_registrationprofile` ADD CONSTRAINT user_id_refs_id_313280c4 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
  12 """], sql_down=["""
  13     DROP TABLE `registration_registrationprofile`;
  14 """])