gistfile1.txt

CREATE TABLE `auth_userprofile` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `user_id` integer NOT NULL UNIQUE,
    `name` varchar(255) NOT NULL,
    `meta` longtext NOT NULL,
    `courseware` varchar(255) NOT NULL,
    `language` varchar(255) NOT NULL,
    `location` varchar(255) NOT NULL,
    `year_of_birth` integer,
    `gender` varchar(6),
    `level_of_education` varchar(6),
    `mailing_address` longtext,
    `country` varchar(2),
    `goals` longtext,
    `allow_certificate` bool NOT NULL,
    `cedula` varchar(32),
    `city_id` integer
)
;
ALTER TABLE `auth_userprofile` ADD CONSTRAINT `user_id_refs_id_628b4c11` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
ALTER TABLE `auth_userprofile` ADD CONSTRAINT `city_id_refs_id_8516bb16` FOREIGN KEY (`city_id`) REFERENCES `cities_city` (`id`);