CREATE TABLE IF NOT EXISTS `#__aimysitemap` (
    `id`         int(11) unsigned NOT NULL AUTO_INCREMENT,
    `url`        varbinary(767)   NOT NULL UNIQUE,
    `title`      varchar(255)     NOT NULL DEFAULT '',
    `priority`   float            NOT NULL DEFAULT 0.5,
    `mtime`      bigint           NOT NULL DEFAULT 0,
    `lang`       char(5)          NOT NULL DEFAULT '*',
    `state`      bool             NOT NULL DEFAULT 0,
    `lock`       bool             NOT NULL DEFAULT 0,
    `changefreq` char(7)          NOT NULL DEFAULT 'monthly',
    PRIMARY KEY( `id` )
) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `#__aimysitemap_crawl` (
    `url`        varbinary(767)   NOT NULL UNIQUE,
    `crawled`    bool             NOT NULL DEFAULT 0,
    `index`      bool             NOT NULL DEFAULT 0,
    `title`      varchar(255)     NOT NULL DEFAULT '',
    `mtime`      bigint           NOT NULL DEFAULT 0,
    `lang`       char(5)          NOT NULL DEFAULT '*',
    PRIMARY KEY( `url` )
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `#__aimysitemap_kvstore` (
    `k`          varchar(255)     NOT NULL UNIQUE
                                  COMMENT 'key',
    `v`          mediumtext       NOT NULL DEFAULT ''
                                  COMMENT 'value',
    PRIMARY KEY( `k` )
) DEFAULT CHARSET=utf8;


-- vim: sts=4 sw=4 ts=4 ai et ft=mysql:
