DROP TABLE IF EXISTS wbconfig;
CREATE TABLE wbconfig (
  pathcs char(32) NOT NULL DEFAULT '',
  path varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  branch varchar(255) NOT NULL DEFAULT '',
  uid varchar(255) NOT NULL,
  created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  changed datetime NOT NULL,
  config text NOT NULL,
  PRIMARY KEY (pathcs),
  KEY path (path)
) COMMENT='XML config';

DROP TABLE IF EXISTS wbmenu;
CREATE TABLE wbmenu (
  menu varchar(255) NOT NULL DEFAULT '',
  menuid int(11) NOT NULL AUTO_INCREMENT,
  path varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  changed datetime NOT NULL,
  position smallint(3) NOT NULL DEFAULT '0',
  urlid int(11) NOT NULL DEFAULT '0',
  linktext varchar(255) NOT NULL DEFAULT '',
  tooltip text NOT NULL,
  class varchar(255) NOT NULL DEFAULT '',
  icon varchar(255) NOT NULL DEFAULT '',
  requiremaster tinyint(4) NOT NULL DEFAULT 0,
  requireuser enum('anybody','anonymous','user') NOT NULL DEFAULT 'anybody',
  requiregroup int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (menuid),
  KEY path (path)
) AUTO_INCREMENT=1000 COMMENT='page menu';


DROP TABLE IF EXISTS wbpagemetatag;
CREATE TABLE wbpagemetatag (
  pagemetatagid int(10) unsigned NOT NULL AUTO_INCREMENT,
  pagepath varchar(128) NOT NULL DEFAULT '',
  title varchar(255) NOT NULL DEFAULT '',
  description varchar(255) NOT NULL DEFAULT '',
  keywords varchar(255) NOT NULL DEFAULT '',
  created datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  changed datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  enabled tinyint(4) NOT NULL DEFAULT 0,
  deleted tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (pagemetatagid),
  KEY (pagepath)
) AUTO_INCREMENT=10000 COMMENT='Wombat Metatag data';

DROP TABLE IF EXISTS `wbxmlarticle`;
CREATE TABLE `wbxmlarticle` (
  `cs` char(32) NOT NULL ,
  `urlid` int(10) unsigned NOT NULL DEFAULT '0',
  `status` enum('public', 'draft') NOT NULL default 'public',
  `revision` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `created` datetime default NULL,
  `body` text NOT NULL,
  KEY  (`cs`),
  KEY `uid` (`uid`),
  KEY `urlid` (`urlid`)
) COMMENT='Wombat XML Articles';

DROP TABLE IF EXISTS `wbxmlarticletranslation`;
CREATE TABLE `wbxmlarticletranslation` (
  `cs` char(32) NOT NULL,
  `lang` char(5) NOT NULL,
  `revision` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `created` datetime default NULL,
  `body` text NOT NULL,
  KEY  (`cs`),
  KEY `uid` (`uid`)
) COMMENT='Wombat XML Article translations';

DROP TABLE IF EXISTS wbkeyvaluepairkey;
CREATE TABLE wbkeyvaluepairkey (
    keyid int(11) unsigned NOT NULL auto_increment,
    `domain` varchar(128) NOT NULL DEFAULT '',
    word varchar(128) NOT NULL DEFAULT '',
    PRIMARY KEY keyid (keyid),
    KEY word (`domain`, word)
) AUTO_INCREMENT=1000 COMMENT='Key Value Pair Key';

DROP TABLE IF EXISTS wbkeyvaluepairvalue;
CREATE TABLE wbkeyvaluepairvalue (
    valueid int(11) unsigned NOT NULL auto_increment,
    word text NOT NULL DEFAULT '',
    PRIMARY KEY valueid (valueid)
) AUTO_INCREMENT=1000 COMMENT='Key Value Pair Value';

DROP TABLE IF EXISTS wbkeyvaluepairkeyvalueid;
CREATE TABLE wbkeyvaluepairkeyvalueid (
    keyvalueid int(11) unsigned NOT NULL auto_increment,
    created datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY keyvalueid (keyvalueid)
) AUTO_INCREMENT=1000 COMMENT='Key Value Pair Key/Value Pair';

DROP TABLE IF EXISTS wbkeyvaluepairkeyvalue;
CREATE TABLE wbkeyvaluepairkeyvalue (
    keyvalueid int(11) unsigned NOT NULL,
    keyid int(11) unsigned NOT NULL,
    valueid int(11) unsigned NOT NULL,
    KEY keyvalueid (keyvalueid)
) COMMENT='Key Value Pair Key/Value relation';

DROP TABLE IF EXISTS wbtablesheet;
CREATE TABLE `wbtablesheet` (
  `mandatorid` int(11) unsigned NOT NULL DEFAULT 0,
  `tablesheetid` int(11) unsigned NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `changed` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `title` varchar(255) NOT NULL DEFAULT '',
  `blurb` text NOT NULL,
  `template` varchar(255) NOT NULL DEFAULT '',
  `class` varchar(255) NOT NULL DEFAULT '',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mandatorid`, `tablesheetid`)
) AUTO_INCREMENT=10000 COMMENT='Generic table sheets' ;

DROP TABLE IF EXISTS wbtablesheetcell;
CREATE TABLE `wbtablesheetcell` (
  `mandatorid` int(11) unsigned NOT NULL DEFAULT 0,
  `tablesheetid` int(11) unsigned NOT NULL,
  `rowno` int(11) unsigned NOT NULL DEFAULT '0',
  `columnno` int(11) unsigned NOT NULL DEFAULT '0',
  `body` text NOT NULL,
  `class` varchar(255) NOT NULL DEFAULT '',
  KEY `tablesheetid` (`tablesheetid`)
) COMMENT='Generic table sheets cells';

DROP TABLE IF EXISTS wbcontactrequest;
CREATE TABLE `wbcontactrequest` (
  `mandatorid` int(11) unsigned NOT NULL DEFAULT 0,
  `contactrequestid` int(11) unsigned NOT NULL DEFAULT 0,
  `namespace` char(64) NOT NULL DEFAULT '',
  `xid` int(11) unsigned NOT NULL DEFAULT 0,
  `lang` char(12) NOT NULL DEFAULT 'C',

  `persongenderid` int(11) unsigned NOT NULL DEFAULT 0,
  `uid` int(11) unsigned NOT NULL DEFAULT 0,
  `emaillocal` varchar(200) NOT NULL,
  `emaildomain` varchar(125) NOT NULL,
  `phone` varchar(255) NOT NULL DEFAULT '',
  `company` varchar(255) NOT NULL DEFAULT '',
  `forename` varchar(255) NOT NULL DEFAULT '',
  `surname` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `request` blob NOT NULL DEFAULT '',

  `message` text NOT NULL DEFAULT '',
  `spam` tinyint(4) NOT NULL DEFAULT 0,
  `assigneduid` int(11) unsigned NOT NULL DEFAULT 0,
  `read` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `done` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `changed` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`mandatorid`, `contactrequestid`),
  KEY `namespace` (`namespace`),
  KEY `xid` (`xid`),
  KEY `created` (`created`),
  KEY `company` (`company`),
  KEY `surname` (`surname`),
  KEY `emaillocal` (`emaillocal`),
  KEY `uid` (`uid`)
) AUTO_INCREMENT=1000 COMMENT='Contact requests';

DROP TABLE IF EXISTS wbbanner;
CREATE TABLE `wbbanner` (
  `bannerid` int(11) NOT NULL AUTO_INCREMENT,
  `position` int(11) NOT NULL DEFAULT 0,
  `namespace` char(32) NOT NULL DEFAULT '',
  `uid` int(11) NOT NULL DEFAULT 0,
  `vfsfid` int(11) NOT NULL DEFAULT 0,
  `urlid` int(11) NOT NULL DEFAULT 0,
  `urltext` varchar(255) NOT NULL DEFAULT '',
  `class` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `brief` text NOT NULL DEFAULT '',
  `blurb` text NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`bannerid`),
  KEY (position),
  KEY (namespace)
) AUTO_INCREMENT=10000 COMMENT='List of Banner';

DROP TABLE IF EXISTS wbbannernamespace;
CREATE TABLE `wbbannernamespace` (
  `bannernsid` int(11) NOT NULL AUTO_INCREMENT,
  `namespace` char(32) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`bannernsid`),
  KEY (namespace)
) AUTO_INCREMENT=10000 COMMENT='List of Banner Namespaces';

INSERT INTO wbbannernamespace (bannernsid, namespace, title) VALUES
(100, "homepage", "Startseite");
UPDATE wbbannernamespace SET created=now(), changed=now();

DROP TABLE IF EXISTS wbbannerclass;
CREATE TABLE `wbbannerclass` (
  `bannerclassid` int(11) NOT NULL AUTO_INCREMENT,
  `class` char(32) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`bannerclassid`),
  KEY (`class`)
) AUTO_INCREMENT=10000 COMMENT='List of Banner Classes';

INSERT INTO wbbannerclass (bannerclassid, class, title) VALUES
(100, "wb-banner-left", "links"),
(101, "wb-banner-center", "zentriert"),
(102, "wb-banner-right", "rechts");
UPDATE wbbannerclass SET created=now(), changed=now();

DROP TABLE IF EXISTS wblandingpagevfsfile;
DROP TABLE IF EXISTS wblandingpagearticlerelation;
DROP TABLE IF EXISTS wblandingpagearticle;
DROP TABLE IF EXISTS wblandingpage;
CREATE TABLE wblandingpage (
    landingpageid int(11) unsigned NOT NULL AUTO_INCREMENT,
    vfsfid int(11) unsigned NOT NULL DEFAULT 0,
    urlpath varchar(128) NOT NULL DEFAULT '',
    uid int(11) unsigned NOT NULL DEFAULT 0,
    urlid int(11) unsigned NOT NULL DEFAULT 0,
    urltext varchar(255) NOT NULL DEFAULT '',
    title varchar(256) NOT NULL DEFAULT '',
    keywords varchar(256) NOT NULL DEFAULT '',
    brief text NOT NULL DEFAULT '',
    blurb text NOT NULL DEFAULT '',
    template varchar(128) NOT NULL DEFAULT 'standard',
    enabled tinyint(4) unsigned NOT NULL DEFAULT 0,
    withcontactform tinyint(4) unsigned NOT NULL DEFAULT 0,
    deleted tinyint(4) unsigned NOT NULL DEFAULT 0,
    created datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
    changed datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
    PRIMARY KEY (landingpageid),
    KEY (urlpath)
)  AUTO_INCREMENT=1000 COMMENT='Landing page';

CREATE TABLE wblandingpagearticle (
    landingpagearticleid int(11) unsigned NOT NULL AUTO_INCREMENT,
    vfsfid int(11) unsigned NOT NULL DEFAULT 0,
    uid int(11) unsigned NOT NULL DEFAULT 0,
    urlid int(11) unsigned NOT NULL DEFAULT 0,
    urltext varchar(255) NOT NULL DEFAULT '',
    orderpos int(11) unsigned NOT NULL DEFAULT 0,
    title varchar(256) NOT NULL DEFAULT '',
    brief text NOT NULL DEFAULT '',
    blurb text NOT NULL DEFAULT '',
    enabled tinyint(4) unsigned NOT NULL DEFAULT 0,
    deleted tinyint(4) unsigned NOT NULL DEFAULT 0,
    created datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
    changed datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
    PRIMARY KEY (landingpagearticleid)
)  AUTO_INCREMENT=1000 COMMENT='Landing page Article';

CREATE TABLE wblandingpagearticlerelation (
    landingpageid int(11) unsigned NOT NULL DEFAULT '0',
    landingpagearticleid int(11) unsigned NOT NULL DEFAULT '0',
    KEY (landingpageid)
) COMMENT='Landing page article relation';

CREATE TABLE wblandingpagevfsfile (
    landingpageid int(11) unsigned NOT NULL DEFAULT '0',
    vfsfid int(11) unsigned NOT NULL DEFAULT '0',
    KEY (landingpageid)
) COMMENT='Landing page media files';

DROP TABLE IF EXISTS wbfaq;
CREATE TABLE wbfaq (
  mandatorid int(11) unsigned NOT NULL DEFAULT 0,
  faqid int(11) unsigned NOT NULL AUTO_INCREMENT,
  faqtid int(11) unsigned NOT NULL DEFAULT 0,
  enabled tinyint(1) NOT NULL DEFAULT 1,
  question varchar(255) NOT NULL DEFAULT '',
  answer text NOT NULL,
  note text NOT NULL,
  created datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  changed datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  deleted tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (faqid),
  KEY (mandatorid)
) AUTO_INCREMENT=1000  COMMENT='FAQ items';

DROP TABLE IF EXISTS wbfaqtype;
CREATE TABLE wbfaqtype (
  mandatorid int(11) unsigned NOT NULL DEFAULT 0,
  faqtid int(11) unsigned NOT NULL AUTO_INCREMENT,
  title varchar(255) NOT NULL DEFAULT '',
  requireuser enum('anybody','anonymous','user') NOT NULL DEFAULT 'anybody',
  requiregroup int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (faqtid),
  KEY (mandatorid)
) AUTO_INCREMENT=1000 COMMENT='FAQ item types';

INSERT INTO wbfaqtype (faqtid, title) VALUES
(100, "Miscellaneous");

DROP TABLE IF EXISTS wbfaqreference;
CREATE TABLE wbfaqreference (
  mandatorid int(11) unsigned NOT NULL DEFAULT 0,
  faqid int(11) unsigned NOT NULL DEFAULT 0,
  otherid int(11) unsigned NOT NULL DEFAULT 0,
  KEY (faqid),
  KEY (mandatorid),
  KEY (otherid)
) COMMENT='FAQ item references';

DROP TABLE IF EXISTS wbteaser;
CREATE TABLE wbteaser (
    teaserid  int(11) unsigned NOT NULL AUTO_INCREMENT,
    position int(11) NOT NULL DEFAULT 0,
    namespace varchar(64) NOT NULL DEFAULT "general",
    uid int(11) unsigned NOT NULL DEFAULT 0,
    vfsfid int(11) unsigned NOT NULL DEFAULT 0,
    title varchar(255) NOT NULL DEFAULT '',
    brief text NOT NULL,
    blurb text NOT NULL,
    urlid int(11) unsigned NOT NULL DEFAULT 0,
    urltext varchar(255) NOT NULL DEFAULT '',
    class varchar(255) NOT NULL DEFAULT '',
    created datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
    changed datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
    enabled tinyint(4) NOT NULL DEFAULT 0,
    deleted tinyint(4) NOT NULL DEFAULT 0,
    PRIMARY KEY (teaserid),
    KEY (position),
    KEY (namespace)
) AUTO_INCREMENT=1000 COMMENT='Teaser';

DROP TABLE IF EXISTS wbteasernamespace;
CREATE TABLE `wbteasernamespace` (
  `teasernsid` int(11) NOT NULL AUTO_INCREMENT,
  `namespace` char(32) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`teasernsid`),
  KEY (namespace)
) AUTO_INCREMENT=10000 COMMENT='List of Teaser Namespaces';

INSERT INTO wbteasernamespace (teasernsid, namespace, title) VALUES
(100, "homepage", "Startseite");
UPDATE wbteasernamespace SET created=now(), changed=now();

DROP TABLE IF EXISTS wbteaserclass;
CREATE TABLE `wbteaserclass` (
  `teaserclassid` int(11) NOT NULL AUTO_INCREMENT,
  `class` char(32) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`teaserclassid`),
  KEY (`class`)
) AUTO_INCREMENT=10000 COMMENT='List of Banner Classes';

INSERT INTO wbteaserclass (teaserclassid, class, title) VALUES
(100, "wb-teaser-left", "links"),
(101, "wb-teaser-center", "zentriert"),
(102, "wb-teaser-right", "rechts");
UPDATE wbteaserclass SET created=now(), changed=now();

DROP TABLE IF EXISTS `wbtestimonial`;
CREATE TABLE wbtestimonial (
    testimonialid  int(11) unsigned NOT NULL AUTO_INCREMENT,
    namespace varchar(64) NOT NULL DEFAULT "general",
    uid int(11) unsigned NOT NULL DEFAULT 0,
    vfsfid int(11) unsigned NOT NULL DEFAULT 0,
    emaillocal varchar(200) NOT NULL,
    emaildomain varchar(125) NOT NULL,
    persongenderid int(11) unsigned NOT NULL DEFAULT 0,
    forename varchar(255) NOT NULL DEFAULT '',
    surname varchar(255) NOT NULL DEFAULT '',
    company varchar(255) NOT NULL DEFAULT '',
    title varchar(255) NOT NULL DEFAULT '',
    brief text NOT NULL,
    urlid int(11) unsigned NOT NULL DEFAULT 0,
    created datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
    changed datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
    enabled tinyint(4) NOT NULL DEFAULT 0,
    deleted tinyint(4) NOT NULL DEFAULT 0,
    PRIMARY KEY (testimonialid),
    KEY (namespace)
) AUTO_INCREMENT=1000 COMMENT='Testimonials';

INSERT INTO `wbtestimonial` VALUES (1000,'general',1,0,'','',1,'Tommy','Atkins','ACME ltd','',"<p>This actually changed my live! I\'m not kidding, I did not expect that this service works so good.</p><p>Gorgeous!</p>",0,'2021-11-04 21:48:06','2021-11-04 21:52:57',1,0);

DROP TABLE IF EXISTS wbcalendar;
CREATE TABLE `wbcalendar` (
  `mandatorid` int(11) unsigned NOT NULL DEFAULT 0,
  `calendarid` int(11) unsigned NOT NULL DEFAULT 0,
  `uid` int(11) unsigned NOT NULL DEFAULT 0,
  `title` varchar(256) NOT NULL DEFAULT '',
  `brief` text NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `changed` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`mandatorid`,`calendarid`),
  KEY `title` (`title`)
) COMMENT='Calendars';

INSERT INTO wbcalendar (calendarid, title, brief, created, changed) VALUES
(1, "allgemein", "Allgemeiner Kalender", now(), now());

DROP TABLE IF EXISTS wbcalendarevent;
CREATE TABLE `wbcalendarevent` (
  `mandatorid` int(11) unsigned NOT NULL DEFAULT 0,
  `calendareventid` int(11) unsigned NOT NULL DEFAULT 0,
  `origincalendareventid` int(11) unsigned NOT NULL DEFAULT 0,
  `calendareventrepeattypeid` int(11) unsigned NOT NULL DEFAULT 0,
  `calendarid` int(11) unsigned NOT NULL DEFAULT 0,
  `uid` int(11) unsigned NOT NULL DEFAULT 0,
  `urlid` int(11) unsigned NOT NULL DEFAULT 0,
  `timestampstart` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `timestampend` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `title` varchar(256) NOT NULL DEFAULT '',
  `brief` text NOT NULL DEFAULT '',
  `blurb` text NOT NULL DEFAULT '',
  `shopurlid` int(11) unsigned NOT NULL DEFAULT 0,
  `shopurltext` varchar(256) NOT NULL DEFAULT '',
  `requireuser` enum('anybody','anonymous','user') NOT NULL DEFAULT 'anybody',
  `requiregroup` int(11) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `changed` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `enabled` tinyint(4) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`mandatorid`,`calendareventid`),
  KEY `origincalendareventid` (`mandatorid`,`origincalendareventid`),
  KEY `calendarid` (`calendarid`),
  KEY `timestampstart` (`timestampstart`)
) COMMENT='Calendarevents';

DROP TABLE IF EXISTS wbcalendareventrepeattype;
CREATE TABLE `wbcalendareventrepeattype` (
  `calendareventrepeattypeid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(256) NOT NULL DEFAULT '',
  `brief` text NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `changed` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`calendareventrepeattypeid`)
) AUTO_INCREMENT=1000 COMMENT='Calendar Event Repeat Type';

INSERT INTO `wbcalendareventrepeattype` (calendareventrepeattypeid, title) VALUES
(1, "never"),
(2, "daily"),
(3, "weekly"),
(4, "fortnight"),
(5, "monthly - same day and week"),
(6, "monthly - same date"),
(7, "yearly");
UPDATE `wbcalendareventrepeattype` SET created=now(), changed=now();

