DROP TABLE IF EXISTS `%TABLE_PREFIX%wv24_urls`;

CREATE TABLE `%TABLE_PREFIX%wv24_urls` (
	`namespace`  VARCHAR(32)           NOT NULL, -- im Format "addon.subnamespace"
	`ident`      VARCHAR(32)           NOT NULL,
	`article_id` INT UNSIGNED          NOT NULL,
	`clang`      SMALLINT(4) UNSIGNED  NOT NULL,
	`path`       VARCHAR(128)          NOT NULL, -- Kategorienpfad à la "1|2|3"
	`url`        VARCHAR(2024)         NOT NULL, -- erzeugte URL
	`created`    DATETIME              NOT NULL,
	`params`     VARCHAR(4096)         NOT NULL DEFAULT '',
	PRIMARY KEY (`namespace`, `ident`),
	INDEX `path` (`path`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
