CREATE TABLE wikipages (
  "title_wiki" varchar(50) NOT NULL,
  "displayedtitle_wiki" varchar(50) default '',
  "heading_wiki" varchar(255) default '',
  "content_wiki" text NOT NULL,
  "author_wiki" varchar(80) default NULL,
  "keywords_wiki" varchar(255) default NULL,
  "description_wiki" varchar(255) default NULL,
  "lang_wiki" varchar (3) default NULL,
  "translatefrom_wiki" varchar(50) default NULL,
  "fromlang_wiki" varchar(3) default NULL,
  "modificationdate_wiki" varchar(14) NOT NULL,
  "creationdate_wiki" varchar(14) NOT NULL,
  "lock_wiki" varchar(1) NOT NULL default '0',
  "deleted_wiki" varchar(1) NOT NULL default '0',
   PRIMARY KEY("title_wiki","lang_wiki","modificationdate_wiki")
);

CREATE TABLE wikiimages (
  "title_wikiimage" VARCHAR( 255 ) NOT NULL ,
  "file_wikiimage" VARCHAR( 255 ) NOT NULL ,
  "page_wikiimage" VARCHAR( 50 ) NOT NULL,
  PRIMARY KEY ( "title_wikiimage" )
);

CREATE TABLE "wikiheadings" (
   "heading_wikihead" VARCHAR( 255 ) NOT NULL,
   PRIMARY KEY ("heading_wikihead") 
);