diff options
author | root <root@u15356270.onlinehome-server.com> | 2009-11-13 20:18:55 -0500 |
---|---|---|
committer | root <root@u15356270.onlinehome-server.com> | 2009-11-13 20:31:40 -0500 |
commit | 7e4f1d542e00b4d3121da6ae5524e95867f2371b (patch) | |
tree | 5a3edfb81cc137dbc877f75f9bde80e9720b3ba0 /tables.sql | |
parent | 3a4b6ad43221abc0e0ff345d9368c3348b312128 (diff) | |
download | askbot-7e4f1d542e00b4d3121da6ae5524e95867f2371b.tar.gz askbot-7e4f1d542e00b4d3121da6ae5524e95867f2371b.tar.bz2 askbot-7e4f1d542e00b4d3121da6ae5524e95867f2371b.zip |
better comments, email subscriptions, corrected view counter, some ie7 issues, wiki optional with settings.WIKI_ON, site can be mounted on arbitrary url prefix, english language improvements, added feedback form, versioned css and js files to force browser cache reload when settings.RESOURCE_REVISION is incremented , other fixes
Diffstat (limited to 'tables.sql')
-rw-r--r-- | tables.sql | 440 |
1 files changed, 440 insertions, 0 deletions
diff --git a/tables.sql b/tables.sql new file mode 100644 index 00000000..6034c08c --- /dev/null +++ b/tables.sql @@ -0,0 +1,440 @@ +BEGIN; +CREATE TABLE `forum_emailfeedsetting` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `subscriber_id` integer NOT NULL, + `feed_type` varchar(16) NOT NULL, + `frequency` varchar(8) NOT NULL, + `added_at` datetime NOT NULL, + `reported_at` datetime NULL +) +; +ALTER TABLE `forum_emailfeedsetting` ADD CONSTRAINT subscriber_id_refs_id_6fee6730cc813af8 FOREIGN KEY (`subscriber_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `tag` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `name` varchar(255) NOT NULL UNIQUE, + `created_by_id` integer NOT NULL, + `deleted` bool NOT NULL, + `deleted_at` datetime NULL, + `deleted_by_id` integer NULL, + `used_count` integer UNSIGNED NOT NULL +) +; +ALTER TABLE `tag` ADD CONSTRAINT created_by_id_refs_id_6ae4d97547205d6d FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `tag` ADD CONSTRAINT deleted_by_id_refs_id_6ae4d97547205d6d FOREIGN KEY (`deleted_by_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `comment` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `content_type_id` integer NOT NULL, + `object_id` integer UNSIGNED NOT NULL, + `user_id` integer NOT NULL, + `comment` varchar(300) NOT NULL, + `added_at` datetime NOT NULL +) +; +ALTER TABLE `comment` ADD CONSTRAINT content_type_id_refs_id_89a4b13ec5a7994 FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`); +ALTER TABLE `comment` ADD CONSTRAINT user_id_refs_id_5ba842626be725e8 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `vote` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `content_type_id` integer NOT NULL, + `object_id` integer UNSIGNED NOT NULL, + `user_id` integer NOT NULL, + `vote` smallint NOT NULL, + `voted_at` datetime NOT NULL, + UNIQUE (`content_type_id`, `object_id`, `user_id`) +) +; +ALTER TABLE `vote` ADD CONSTRAINT content_type_id_refs_id_77dc6ffafedbbec FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`); +ALTER TABLE `vote` ADD CONSTRAINT user_id_refs_id_3ce5b20589f5b210 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `flagged_item` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `content_type_id` integer NOT NULL, + `object_id` integer UNSIGNED NOT NULL, + `user_id` integer NOT NULL, + `flagged_at` datetime NOT NULL, + UNIQUE (`content_type_id`, `object_id`, `user_id`) +) +; +ALTER TABLE `flagged_item` ADD CONSTRAINT content_type_id_refs_id_261d26c8891bb28c FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`); +ALTER TABLE `flagged_item` ADD CONSTRAINT user_id_refs_id_92ae9d35e3c608 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `question` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `title` varchar(300) NOT NULL, + `author_id` integer NOT NULL, + `added_at` datetime NOT NULL, + `wiki` bool NOT NULL, + `wikified_at` datetime NULL, + `answer_accepted` bool NOT NULL, + `closed` bool NOT NULL, + `closed_by_id` integer NULL, + `closed_at` datetime NULL, + `close_reason` smallint NULL, + `deleted` bool NOT NULL, + `deleted_at` datetime NULL, + `deleted_by_id` integer NULL, + `locked` bool NOT NULL, + `locked_by_id` integer NULL, + `locked_at` datetime NULL, + `score` integer NOT NULL, + `vote_up_count` integer NOT NULL, + `vote_down_count` integer NOT NULL, + `answer_count` integer UNSIGNED NOT NULL, + `comment_count` integer UNSIGNED NOT NULL, + `view_count` integer UNSIGNED NOT NULL, + `offensive_flag_count` smallint NOT NULL, + `favourite_count` integer UNSIGNED NOT NULL, + `last_edited_at` datetime NULL, + `last_edited_by_id` integer NULL, + `last_activity_at` datetime NOT NULL, + `last_activity_by_id` integer NOT NULL, + `tagnames` varchar(125) NOT NULL, + `summary` varchar(180) NOT NULL, + `html` longtext NOT NULL +) +; +ALTER TABLE `question` ADD CONSTRAINT author_id_refs_id_5159d9f3a9162ff4 FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `question` ADD CONSTRAINT closed_by_id_refs_id_5159d9f3a9162ff4 FOREIGN KEY (`closed_by_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `question` ADD CONSTRAINT deleted_by_id_refs_id_5159d9f3a9162ff4 FOREIGN KEY (`deleted_by_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `question` ADD CONSTRAINT locked_by_id_refs_id_5159d9f3a9162ff4 FOREIGN KEY (`locked_by_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `question` ADD CONSTRAINT last_edited_by_id_refs_id_5159d9f3a9162ff4 FOREIGN KEY (`last_edited_by_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `question` ADD CONSTRAINT last_activity_by_id_refs_id_5159d9f3a9162ff4 FOREIGN KEY (`last_activity_by_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `forum_questionview` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `question_id` integer NOT NULL, + `who_id` integer NOT NULL, + `when` datetime NOT NULL +) +; +ALTER TABLE `forum_questionview` ADD CONSTRAINT question_id_refs_id_fe63ebce6b3cbac FOREIGN KEY (`question_id`) REFERENCES `question` (`id`); +ALTER TABLE `forum_questionview` ADD CONSTRAINT who_id_refs_id_293b67239e957c53 FOREIGN KEY (`who_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `favorite_question` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `question_id` integer NOT NULL, + `user_id` integer NOT NULL, + `added_at` datetime NOT NULL +) +; +ALTER TABLE `favorite_question` ADD CONSTRAINT question_id_refs_id_2cafd2f21ebe1cc3 FOREIGN KEY (`question_id`) REFERENCES `question` (`id`); +ALTER TABLE `favorite_question` ADD CONSTRAINT user_id_refs_id_1632ce11ad7ac7de FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `question_revision` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `question_id` integer NOT NULL, + `revision` integer UNSIGNED NOT NULL, + `title` varchar(300) NOT NULL, + `author_id` integer NOT NULL, + `revised_at` datetime NOT NULL, + `tagnames` varchar(125) NOT NULL, + `summary` varchar(300) NOT NULL, + `text` longtext NOT NULL +) +; +ALTER TABLE `question_revision` ADD CONSTRAINT question_id_refs_id_61316ec87bef5296 FOREIGN KEY (`question_id`) REFERENCES `question` (`id`); +ALTER TABLE `question_revision` ADD CONSTRAINT author_id_refs_id_79de7cc0b077fdb1 FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `forum_anonymousanswer` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `question_id` integer NOT NULL, + `session_key` varchar(40) NOT NULL, + `wiki` bool NOT NULL, + `added_at` datetime NOT NULL, + `ip_addr` char(15) NOT NULL, + `author_id` integer NULL, + `text` longtext NOT NULL, + `summary` varchar(180) NOT NULL +) +; +ALTER TABLE `forum_anonymousanswer` ADD CONSTRAINT question_id_refs_id_17dd6b2f4cc171c7 FOREIGN KEY (`question_id`) REFERENCES `question` (`id`); +ALTER TABLE `forum_anonymousanswer` ADD CONSTRAINT author_id_refs_id_3ac41be013fb542e FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `forum_anonymousquestion` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `title` varchar(300) NOT NULL, + `session_key` varchar(40) NOT NULL, + `text` longtext NOT NULL, + `summary` varchar(180) NOT NULL, + `tagnames` varchar(125) NOT NULL, + `wiki` bool NOT NULL, + `added_at` datetime NOT NULL, + `ip_addr` char(15) NOT NULL, + `author_id` integer NULL +) +; +ALTER TABLE `forum_anonymousquestion` ADD CONSTRAINT author_id_refs_id_2a673297511a98a FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `answer` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `question_id` integer NOT NULL, + `author_id` integer NOT NULL, + `added_at` datetime NOT NULL, + `wiki` bool NOT NULL, + `wikified_at` datetime NULL, + `accepted` bool NOT NULL, + `accepted_at` datetime NULL, + `deleted` bool NOT NULL, + `deleted_by_id` integer NULL, + `locked` bool NOT NULL, + `locked_by_id` integer NULL, + `locked_at` datetime NULL, + `score` integer NOT NULL, + `vote_up_count` integer NOT NULL, + `vote_down_count` integer NOT NULL, + `comment_count` integer UNSIGNED NOT NULL, + `offensive_flag_count` smallint NOT NULL, + `last_edited_at` datetime NULL, + `last_edited_by_id` integer NULL, + `html` longtext NOT NULL +) +; +ALTER TABLE `answer` ADD CONSTRAINT question_id_refs_id_2300e0297d6550c9 FOREIGN KEY (`question_id`) REFERENCES `question` (`id`); +ALTER TABLE `answer` ADD CONSTRAINT author_id_refs_id_6573e62f192b0170 FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `answer` ADD CONSTRAINT deleted_by_id_refs_id_6573e62f192b0170 FOREIGN KEY (`deleted_by_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `answer` ADD CONSTRAINT locked_by_id_refs_id_6573e62f192b0170 FOREIGN KEY (`locked_by_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `answer` ADD CONSTRAINT last_edited_by_id_refs_id_6573e62f192b0170 FOREIGN KEY (`last_edited_by_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `answer_revision` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `answer_id` integer NOT NULL, + `revision` integer UNSIGNED NOT NULL, + `author_id` integer NOT NULL, + `revised_at` datetime NOT NULL, + `summary` varchar(300) NOT NULL, + `text` longtext NOT NULL +) +; +ALTER TABLE `answer_revision` ADD CONSTRAINT answer_id_refs_id_47145eaebe77d8fe FOREIGN KEY (`answer_id`) REFERENCES `answer` (`id`); +ALTER TABLE `answer_revision` ADD CONSTRAINT author_id_refs_id_2c17693c3ccc055f FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `badge` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `name` varchar(50) NOT NULL, + `type` smallint NOT NULL, + `slug` varchar(50) NOT NULL, + `description` varchar(300) NOT NULL, + `multiple` bool NOT NULL, + `awarded_count` integer UNSIGNED NOT NULL, + UNIQUE (`name`, `type`) +) +; +CREATE TABLE `award` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `user_id` integer NOT NULL, + `badge_id` integer NOT NULL, + `content_type_id` integer NOT NULL, + `object_id` integer UNSIGNED NOT NULL, + `awarded_at` datetime NOT NULL, + `notified` bool NOT NULL +) +; +ALTER TABLE `award` ADD CONSTRAINT user_id_refs_id_5d197ea32d83e9b6 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `award` ADD CONSTRAINT badge_id_refs_id_4237a025651af0e1 FOREIGN KEY (`badge_id`) REFERENCES `badge` (`id`); +ALTER TABLE `award` ADD CONSTRAINT content_type_id_refs_id_72f17e2d83bbde26 FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`); +CREATE TABLE `repute` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `user_id` integer NOT NULL, + `positive` smallint NOT NULL, + `negative` smallint NOT NULL, + `question_id` integer NOT NULL, + `reputed_at` datetime NOT NULL, + `reputation_type` smallint NOT NULL, + `reputation` integer NOT NULL +) +; +ALTER TABLE `repute` ADD CONSTRAINT user_id_refs_id_fcf719405a426cd FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `repute` ADD CONSTRAINT question_id_refs_id_4749166abeb39c4e FOREIGN KEY (`question_id`) REFERENCES `question` (`id`); +CREATE TABLE `activity` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `user_id` integer NOT NULL, + `activity_type` smallint NOT NULL, + `active_at` datetime NOT NULL, + `content_type_id` integer NOT NULL, + `object_id` integer UNSIGNED NOT NULL, + `is_auditted` bool NOT NULL +) +; +ALTER TABLE `activity` ADD CONSTRAINT user_id_refs_id_6015206347c8583f FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `activity` ADD CONSTRAINT content_type_id_refs_id_78877d15efa8edfd FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`); +CREATE TABLE `book` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `user_id` integer NOT NULL, + `title` varchar(255) NOT NULL, + `short_name` varchar(255) NOT NULL, + `author` varchar(255) NOT NULL, + `price` numeric(6, 2) NOT NULL, + `pages` smallint NOT NULL, + `published_at` datetime NOT NULL, + `publication` varchar(255) NOT NULL, + `cover_img` varchar(255) NOT NULL, + `tagnames` varchar(125) NOT NULL, + `added_at` datetime NOT NULL, + `last_edited_at` datetime NOT NULL +) +; +ALTER TABLE `book` ADD CONSTRAINT user_id_refs_id_607b4cfdf0283c8d FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `book_author_info` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `user_id` integer NOT NULL, + `book_id` integer NOT NULL, + `blog_url` varchar(255) NOT NULL, + `added_at` datetime NOT NULL, + `last_edited_at` datetime NOT NULL +) +; +ALTER TABLE `book_author_info` ADD CONSTRAINT user_id_refs_id_3781e2a5fbe1cfda FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `book_author_info` ADD CONSTRAINT book_id_refs_id_688c8f047c49bbf8 FOREIGN KEY (`book_id`) REFERENCES `book` (`id`); +CREATE TABLE `book_author_rss` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `user_id` integer NOT NULL, + `book_id` integer NOT NULL, + `title` varchar(255) NOT NULL, + `url` varchar(255) NOT NULL, + `rss_created_at` datetime NOT NULL, + `added_at` datetime NOT NULL +) +; +ALTER TABLE `book_author_rss` ADD CONSTRAINT user_id_refs_id_1fd25dcf3596f741 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `book_author_rss` ADD CONSTRAINT book_id_refs_id_f64066171717121 FOREIGN KEY (`book_id`) REFERENCES `book` (`id`); +CREATE TABLE `forum_anonymousemail` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `key` varchar(32) NOT NULL, + `email` varchar(75) NOT NULL UNIQUE, + `isvalid` bool NOT NULL +) +; +CREATE TABLE `question_tags` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `question_id` integer NOT NULL, + `tag_id` integer NOT NULL, + UNIQUE (`question_id`, `tag_id`) +) +; +ALTER TABLE `question_tags` ADD CONSTRAINT question_id_refs_id_35d758e3d99eb83a FOREIGN KEY (`question_id`) REFERENCES `question` (`id`); +ALTER TABLE `question_tags` ADD CONSTRAINT tag_id_refs_id_3b0ddddfbc0346ad FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`); +CREATE TABLE `question_followed_by` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `question_id` integer NOT NULL, + `user_id` integer NOT NULL, + UNIQUE (`question_id`, `user_id`) +) +; +ALTER TABLE `question_followed_by` ADD CONSTRAINT question_id_refs_id_6ea9c52125c22aae FOREIGN KEY (`question_id`) REFERENCES `question` (`id`); +ALTER TABLE `question_followed_by` ADD CONSTRAINT user_id_refs_id_49cca2976d30712d FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `book_question` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `book_id` integer NOT NULL, + `question_id` integer NOT NULL, + UNIQUE (`book_id`, `question_id`) +) +; +ALTER TABLE `book_question` ADD CONSTRAINT book_id_refs_id_535ac8946a43c4d1 FOREIGN KEY (`book_id`) REFERENCES `book` (`id`); +ALTER TABLE `book_question` ADD CONSTRAINT question_id_refs_id_372b7e81c7aff6d8 FOREIGN KEY (`question_id`) REFERENCES `question` (`id`); +CREATE TABLE `django_authopenid_nonce` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `server_url` varchar(255) NOT NULL, + `timestamp` integer NOT NULL, + `salt` varchar(40) NOT NULL +) +; +CREATE TABLE `django_authopenid_association` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `server_url` longtext NOT NULL, + `handle` varchar(255) NOT NULL, + `secret` longtext NOT NULL, + `issued` integer NOT NULL, + `lifetime` integer NOT NULL, + `assoc_type` longtext NOT NULL +) +; +CREATE TABLE `django_authopenid_userassociation` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `openid_url` varchar(255) NOT NULL, + `user_id` integer NOT NULL UNIQUE +) +; +ALTER TABLE `django_authopenid_userassociation` ADD CONSTRAINT user_id_refs_id_f63a9e7163d208d FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `django_authopenid_userpasswordqueue` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `user_id` integer NOT NULL UNIQUE, + `new_password` varchar(30) NOT NULL, + `confirm_key` varchar(40) NOT NULL +) +; +ALTER TABLE `django_authopenid_userpasswordqueue` ADD CONSTRAINT user_id_refs_id_7f488ca76bcaaa4 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +CREATE TABLE `django_authopenid_externallogindata` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `external_username` varchar(40) NOT NULL UNIQUE, + `external_session_data` longtext NOT NULL, + `user_id` integer NULL +) +; +ALTER TABLE `django_authopenid_externallogindata` ADD CONSTRAINT user_id_refs_id_462c0ee2c3e5e139 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +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`) +) +; +ALTER TABLE `auth_permission` ADD CONSTRAINT content_type_id_refs_id_6bc81a32728de91f FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`); +CREATE TABLE `auth_group` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `name` varchar(80) NOT NULL UNIQUE +) +; +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, + `is_approved` bool NOT NULL, + `email_isvalid` bool NOT NULL, + `email_key` varchar(32) NULL, + `reputation` integer UNSIGNED NOT NULL, + `gravatar` varchar(32) NOT NULL, + `gold` smallint NOT NULL, + `silver` smallint NOT NULL, + `bronze` smallint NOT NULL, + `questions_per_page` smallint NOT NULL, + `last_seen` datetime NOT NULL, + `real_name` varchar(100) NOT NULL, + `website` varchar(200) NOT NULL, + `location` varchar(100) NOT NULL, + `date_of_birth` date NULL, + `about` longtext NOT NULL +) +; +CREATE TABLE `auth_message` ( + `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, + `user_id` integer NOT NULL, + `message` longtext NOT NULL +) +; +ALTER TABLE `auth_message` ADD CONSTRAINT user_id_refs_id_7837edc69af0b65a 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`) +) +; +ALTER TABLE `auth_group_permissions` ADD CONSTRAINT group_id_refs_id_2ccea4c93cea63fe FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`); +ALTER TABLE `auth_group_permissions` ADD CONSTRAINT permission_id_refs_id_4de83ca7792de1 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`) +) +; +ALTER TABLE `auth_user_groups` ADD CONSTRAINT user_id_refs_id_1993cb70831107f1 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `auth_user_groups` ADD CONSTRAINT group_id_refs_id_321a8efef0ee9890 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`) +) +; +ALTER TABLE `auth_user_user_permissions` ADD CONSTRAINT user_id_refs_id_166738bf2045483 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); +ALTER TABLE `auth_user_user_permissions` ADD CONSTRAINT permission_id_refs_id_6d7fb3c2067e79cb FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`); +COMMIT; |