text: DROP TABLE IF EXISTS `phpcms_tag`;
  CREATE TABLE IF NOT EXISTS `phpcms_tag` (
    `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    `siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
    `tag` text NOT NULL,
    `name` char(40) NOT NULL,
    `type` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `module` char(20) NOT NULL,
    `action` char(20) NOT NULL,
    `data` text NOT NULL,
    `page` char(15) NOT NULL,
    `return` char(20) NOT NULL,
    `cache` mediumint(8) unsigned NOT NULL DEFAULT '0',
    `num` smallint(5) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB ;