CREATE TABLE `browsing_counter` (
    `id` INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `date` DATE,
    `period` VARCHAR(10) NOT NULL,
    `type` VARCHAR(10) NOT NULL,
    `count` INTEGER UNSIGNED NOT NULL,
    `article_id` INTEGER NOT NULL,
    UNIQUE (`article_id`, `type`, `period`, `date`, `count`)
);
CREATE INDEX `browsing_feed_a951d5d6` ON `browsing_feed` (`slug`);
CREATE INDEX `browsing_category_a951d5d6` ON `browsing_category` (`slug`);
CREATE INDEX `browsing_counter_1d08369a` ON `browsing_counter` (`period`);
CREATE INDEX `browsing_counter_f0bd6439` ON `browsing_counter` (`type`);
CREATE INDEX `browsing_counter_30525a19` ON `browsing_counter` (`article_id`);