Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

27 lines (23 sloc) 0.885 kb
--
-- Tables for taggit app
--
DROP TABLE IF EXISTS `taggit_taggeditem`;
DROP TABLE IF EXISTS `taggit_tag`;
CREATE TABLE `taggit_tag` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`slug` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `taggit_taggeditem` (
`id` int(11) NOT NULL auto_increment,
`tag_id` int(11) NOT NULL,
`object_id` int(11) NOT NULL,
`content_type_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `taggit_taggeditem_3747b463` (`tag_id`),
KEY `taggit_taggeditem_e4470c6e` (`content_type_id`),
CONSTRAINT `content_type_id_refs_id_5a2b7711` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
CONSTRAINT `tag_id_refs_id_c87e3f85` FOREIGN KEY (`tag_id`) REFERENCES `taggit_tag` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Jump to Line
Something went wrong with that request. Please try again.