CREATE TABLE kpro_active (
  val char(15) NOT NULL default '',
  active tinyint(1) NOT NULL default '1',
  theurl varchar(255) NOT NULL default '',
  PRIMARY KEY  (val)
) TYPE=MyISAM ;#kinst#

 
CREATE TABLE kpro_adminlogs (
  id int(10) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL default '0', 
  ctime int(10) unsigned NOT NULL default '0',
  ip varchar(25) NOT NULL default '',
  action text NOT NULL,
  prior tinyint(1) NOT NULL default '2',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#
 

CREATE TABLE kpro_affiliates (
  id int(11) NOT NULL auto_increment,
  url varchar(255) NOT NULL default '',
  posi smallint(3) unsigned NOT NULL default '0',
  hits int(11) NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  image varchar(255) NOT NULL default '',
  area smallint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_areas (
  area_id smallint(3) unsigned NOT NULL auto_increment,
  area_name varchar(200) NOT NULL default '',
  area_descr text NOT NULL,
  area_template varchar(200) NOT NULL default 'standard',
  active tinyint(1) unsigned NOT NULL default '1',
  tmpl text NOT NULL,
  pass varchar(20) NOT NULL default '',
  news_startpage smallint(2) unsigned NOT NULL default '10',
  css_sheme VARCHAR( 255 ) NOT NULL DEFAULT 'css',
  img_path VARCHAR( 255 ) NOT NULL DEFAULT 'img',
  std_lang char(2) NOT NULL default 'en',
  std_lang_admin char(2) NOT NULL default 'en',
  PRIMARY KEY  (area_id),
  KEY area_id (area_id),
  KEY area_template (area_template),
  KEY active (active)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=2 ;#kinst#


CREATE TABLE kpro_articlecat (
  catid mediumint(5) unsigned NOT NULL auto_increment,
  parent_id mediumint(5) unsigned NOT NULL default '0',
  catname varchar(100) default NULL,
  catdesc text NOT NULL,
  area smallint(3) unsigned NOT NULL default '1',
  posi smallint(3) unsigned NOT NULL default '1',
  icon varchar(255) NOT NULL default '',
  PRIMARY KEY  (catid),
  KEY area (area),
  KEY catid (catid),
  KEY catname (catname)
) TYPE=MyISAM AUTO_INCREMENT=2 ;#kinst#



CREATE TABLE kpro_articlecomments (
  id mediumint(6) unsigned NOT NULL auto_increment,
  articleid mediumint(6) unsigned NOT NULL default '0',
  ctime int(10) unsigned NOT NULL default '0',
  autor mediumint(6) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  comment text NOT NULL,
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#



CREATE TABLE kpro_articles (
  id int(11) unsigned NOT NULL auto_increment,
  articlecat int(10) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  genre mediumint(5) unsigned default NULL,
  publisher mediumint(5) unsigned default NULL,
  manufacturer mediumint(5) unsigned default NULL,
  voting smallint(3) unsigned default NULL,
  artvotes text NOT NULL,
  content text,
  subtitle varchar(255) NOT NULL default '',
  asin varchar(255) NOT NULL,
  platform varchar(100) NOT NULL,
  time_release varchar(50) NOT NULL,
  price varchar(255) NOT NULL,
  shopurl varchar(255) NOT NULL,
  shop varchar(255) NOT NULL,
  boxshot varchar(255) NOT NULL default '',
  links text,
  gallery varchar(100) NOT NULL default '',
  inline_screens text NOT NULL,
  uid mediumint(5) unsigned NOT NULL default '1',
  ctime int(10) unsigned NOT NULL default '0',
  hits int(10) unsigned NOT NULL default '0',
  type enum('special','preview','review','interview','column') NOT NULL default 'review',
  area smallint(3) unsigned NOT NULL default '1',
  printed mediumint(8) unsigned NOT NULL default '0',
  active tinyint(1) NOT NULL default '1',
  top text NOT NULL,
  flop text NOT NULL,
  minimum text NOT NULL,
  optimum text NOT NULL,
  time_start int(10) unsigned NOT NULL default '0',
  time_end int(10) unsigned NOT NULL default '0',
  cansearch enum('yes','no') NOT NULL default 'yes',
  isontop enum('yes','no') NOT NULL default 'no',
  image_top varchar(255) NOT NULL default '',
  canvote tinyint(1) NOT NULL default '0',
  voting_value mediumint(5) unsigned NOT NULL default '0',
  voting_votes mediumint(5) unsigned NOT NULL default '0',
  voting_ip varchar(25) NOT NULL default '',
  voting_uid text NOT NULL,
  allareas enum('yes','no') NOT NULL default 'no',
  image_align enum('left','right') NOT NULL default 'left',
  end_top int(11) unsigned NOT NULL default '0',
  matchword varchar(255) NOT NULL default '',
  product mediumint(10) unsigned NOT NULL default '0',
  product_shop varchar(255) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  showonpage tinyint(1) NOT NULL default '1',
  votes mediumint(6) unsigned NOT NULL default '0',
  votes_data mediumint(6) unsigned NOT NULL default '0',
  votes_ip text NOT NULL,
  votes_uid text NOT NULL,
  cancomment tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1;#kinst#




 
CREATE TABLE kpro_autowords (
  id int(10) unsigned NOT NULL auto_increment,
  words varchar(200) NOT NULL default '',
  text text NOT NULL,
  hits int(10) unsigned NOT NULL default '0',
  active tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (id),
  KEY words (words)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#



CREATE TABLE kpro_banner (
  id mediumint(5) unsigned NOT NULL auto_increment,
  area mediumint(5) unsigned NOT NULL default '1',
  name varchar(255) NOT NULL default '',
  code text NOT NULL,
  active tinyint(1) unsigned NOT NULL default '1',
  weight int(10) unsigned NOT NULL default '1',
  views int(14) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_calendar (
  id int(4) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL default '0',
  datum varchar(10) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  descr text NOT NULL,
  start int(15) unsigned NOT NULL default '0',
  ende int(15) unsigned NOT NULL default '0',
  type enum('public','private') NOT NULL default 'public',
  weight tinyint(1) unsigned NOT NULL default '3',
  wd tinyint(1) unsigned NOT NULL default '0',
  tdays int(15) unsigned NOT NULL default '0',
  done tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_container (
  id smallint(3) unsigned NOT NULL default '0',
  name varchar(200) NOT NULL default '',
  tpl varchar(100) NOT NULL default 'standard_1',
  typ enum('in','out') NOT NULL default 'in',
  area smallint(5) unsigned NOT NULL default '1',
  KEY container (tpl),
  KEY id (id)
) TYPE=MyISAM PACK_KEYS=0;#kinst#


CREATE TABLE kpro_countries (
  id smallint(3) unsigned NOT NULL auto_increment,
  code char(2) NOT NULL default 'DE',
  val varchar(255) NOT NULL default '',
  active tinyint(1) NOT NULL default '1',
  eu tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=238 ;#kinst#


CREATE TABLE kpro_downloadcat (
  catid mediumint(5) unsigned NOT NULL auto_increment,
  parent_id mediumint(5) unsigned NOT NULL default '0',
  catname varchar(100) NOT NULL default '',
  catdesc text NOT NULL,
  area smallint(3) unsigned NOT NULL default '1',
  posi smallint(3) unsigned NOT NULL default '1',
  icon varchar(255) NOT NULL default '',
  group_id varchar(255) NOT NULL default '1,2,3',
  PRIMARY KEY  (catid)
) TYPE=MyISAM AUTO_INCREMENT=5 ;#kinst#



CREATE TABLE kpro_downloadcomments (
  id mediumint(6) unsigned NOT NULL auto_increment,
  dlid mediumint(6) unsigned NOT NULL default '0',
  ctime int(10) unsigned NOT NULL default '0',
  autor mediumint(6) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  comment text NOT NULL,
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_downloads (
  id int(10) NOT NULL auto_increment,
  catid int(10) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  text text NOT NULL,
  dlurl varchar(255) NOT NULL default '',
  dlurl_local varchar(255) NOT NULL default '',
  hits int(10) unsigned NOT NULL default '0',
  hits_today int(10) unsigned NOT NULL default '0',
  hits_perday int(10) unsigned NOT NULL default '0',
  size varchar(35) NOT NULL default '0',
  password varchar(255) NOT NULL default '',
  ctime int(10) unsigned NOT NULL default '0',
  today int(11) NOT NULL default '0',
  votes mediumint(6) unsigned NOT NULL default '0',
  votes_data mediumint(6) unsigned NOT NULL default '0',
  votes_ip text NOT NULL,
  votes_uid text NOT NULL,
  canvote tinyint(1) NOT NULL default '0',
  cancomment tinyint(1) NOT NULL default '0',
  area smallint(3) NOT NULL default '1',
  uid int(10) unsigned NOT NULL default '1',
  active tinyint(1) NOT NULL default '1',
  gallery tinytext NOT NULL,
  platform tinytext NOT NULL,
  end_top int(10) unsigned NOT NULL default '0',
  image varchar(255) NOT NULL default '',
  image_top varchar(255) NOT NULL default '',
  isontop tinyint(1) NOT NULL default '0',
  language varchar(255) NOT NULL default '',
  author_file tinytext NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=3 ;#kinst#



CREATE TABLE kpro_f_allowed_files (
  id tinyint(3) unsigned NOT NULL auto_increment,
  filetype varchar(200) NOT NULL default '',
  filesize int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=12 ;#kinst#


CREATE TABLE kpro_f_attachment (
  id mediumint(8) unsigned NOT NULL auto_increment,
  orig_name varchar(200) NOT NULL default '',
  filename varchar(200) NOT NULL default '',
  hits int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY filename (filename),
  FULLTEXT KEY filename_2 (filename)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_f_category (
  id int(11) NOT NULL auto_increment,
  title varchar(200) NOT NULL default '',
  position smallint(5) unsigned NOT NULL default '0',
  parent_id smallint(5) unsigned default NULL,
  comment text,
  group_id text,
  PRIMARY KEY  (id),
  KEY title (title),
  KEY position (position),
  FULLTEXT KEY title_2 (title)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;#kinst#



CREATE TABLE kpro_f_forum (
  id int(11) unsigned NOT NULL auto_increment,
  title varchar(200) NOT NULL default '',
  category_id int(11) unsigned NOT NULL default '0',
  statusicon varchar(20) default NULL,
  comment text,
  status tinyint(1) default '0',
  last_post timestamp(14) NOT NULL,
  last_post_id int(11) unsigned NOT NULL default '0',
  group_id text,
  active tinyint(3) unsigned NOT NULL default '0',
  password varchar(100) default NULL,
  password_raw varchar(255) NOT NULL default '',
  moderator int(11) default NULL,
  position smallint(6) default '0',
  moderated tinyint(1) NOT NULL default '0',
  moderated_posts tinyint(1) NOT NULL default '0',
  topic_emails text NOT NULL,
  post_emails text NOT NULL,
  PRIMARY KEY  (id),
  KEY title (title),
  KEY position (position),
  FULLTEXT KEY title_2 (title)
) TYPE=MyISAM PACK_KEYS=0 COMMENT='forum' AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_f_mods (
  forum_id int(11) NOT NULL default '0',
  user_id int(11) NOT NULL default '0'
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_f_permissions (
  forum_id int(11) NOT NULL default '0',
  group_id int(11) NOT NULL default '0',
  permissions text NOT NULL,
  PRIMARY KEY  (forum_id,group_id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_f_post (
  id bigint(20) unsigned NOT NULL auto_increment,
  title varchar(200) default NULL,
  topic_id smallint(6) NOT NULL default '0',
  datum datetime NOT NULL default '0000-00-00 00:00:00',
  uid smallint(6) NOT NULL default '0',
  use_bbcode tinyint(1) NOT NULL default '0',
  use_smilies tinyint(1) NOT NULL default '0',
  use_sig tinyint(1) NOT NULL default '0',
  message text NOT NULL,
  attachment tinytext,
  opened tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (id),
  KEY title (title),
  KEY topci_id (topic_id),
  KEY uid (uid),
  FULLTEXT KEY title_2 (title)
) TYPE=MyISAM PACK_KEYS=0 COMMENT='beitrag eines forum' AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_f_rank (
  id int(10) unsigned NOT NULL auto_increment,
  title varchar(100) NOT NULL default '',
  count int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=6 ;#kinst#


CREATE TABLE kpro_f_rating (
  topic_id int(11) NOT NULL default '0',
  rating text NOT NULL,
  ip text NOT NULL,
  uid text NOT NULL,
  PRIMARY KEY  (topic_id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_f_topic (
  id int(11) NOT NULL auto_increment,
  title varchar(200) NOT NULL default '',
  status int(11) default '0',
  views int(11) NOT NULL default '0',
  rating text,
  forum_id int(11) NOT NULL default '0',
  icon smallint(5) unsigned default NULL,
  posticon smallint(5) unsigned default NULL,
  datum datetime NOT NULL default '0000-00-00 00:00:00',
  replies int(10) unsigned NOT NULL default '0',
  uid smallint(5) unsigned NOT NULL default '0',
  notification text NOT NULL,
  type tinyint(1) NOT NULL default '0',
  last_post datetime NOT NULL default '0000-00-00 00:00:00',
  last_post_id int(11) default NULL,
  opened tinyint(4) NOT NULL default '1',
  last_post_int int(14) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY forum_id (forum_id),
  KEY opened (opened),
  KEY uid (uid)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_faq (
  id int(10) unsigned NOT NULL auto_increment,
  parent_id int(10) unsigned NOT NULL default '0',
  faq varchar(255) NOT NULL default '',
  answer text NOT NULL,
  posi smallint(3) unsigned NOT NULL default '0',
  ctime int(10) unsigned NOT NULL default '0',
  uid mediumint(5) unsigned NOT NULL default '1',
  active tinyint(1) NOT NULL default '1',
  area smallint(3) unsigned NOT NULL default '1',
  hits int(10) unsigned NOT NULL default '0',
  inline_screens text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_gallery (
  id int(10) unsigned NOT NULL auto_increment,
  parent_id int(10) unsigned NOT NULL default '0',
  area smallint(3) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  active tinyint(1) NOT NULL default '1',
  descr text NOT NULL,
  ctime int(10) unsigned NOT NULL default '0',
  posi smallint(3) unsigned NOT NULL default '0',
  uid mediumint(5) unsigned NOT NULL default '1',
  field_1 varchar(255) NOT NULL default '',
  field_2 varchar(255) NOT NULL default '',
  field_3 varchar(255) NOT NULL default '',
  field_1_text text NOT NULL,
  field_2_text text NOT NULL,
  field_3_text text NOT NULL,
  matchword varchar(255) NOT NULL default '',
  product mediumint(5) unsigned NOT NULL default '0',
  cancomment tinyint(1) NOT NULL default '1',
  maxwidth smallint(4) unsigned NOT NULL default '400',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_gallery_items (
  id int(10) unsigned NOT NULL auto_increment,
  gal_id int(10) unsigned NOT NULL default '0',
  path varchar(255) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  author varchar(255) NOT NULL default '',
  vote int(10) unsigned NOT NULL default '0',
  descr text NOT NULL,
  ctime int(10) unsigned NOT NULL default '0',
  hits int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_gallerycomments (
  id int(10) unsigned NOT NULL auto_increment,
  imgid int(10) unsigned NOT NULL default '0',
  ctime int(10) unsigned NOT NULL default '0',
  autor mediumint(6) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  comment text NOT NULL,
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_genres (
  id int(10) unsigned NOT NULL auto_increment,
  genre varchar(255) NOT NULL default '',
  area smallint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_guestbook (
  id int(11) NOT NULL auto_increment,
  ctime int(11) NOT NULL default '0',
  author varchar(255) NOT NULL default '',
  `comment` text NOT NULL,
  email varchar(255) NOT NULL default '',
  web varchar(255) NOT NULL default '',
  ip varchar(255) NOT NULL default '',
  authfrom varchar(255) NOT NULL default '',
  is_active tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM PACK_KEYS=0;#kinst#


CREATE TABLE kpro_guestbook_settings (
  id int(11) NOT NULL auto_increment,
  spamprotect tinyint(1) NOT NULL default '1',
  spamprotect_time mediumint(5) NOT NULL default '1',
  mailbycomment tinyint(1) NOT NULL default '1',
  maxpostlength mediumint(5) NOT NULL default '1000',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;#kinst#


CREATE TABLE kpro_ignore (
  uid mediumint(8) unsigned NOT NULL default '0',
  ignore_uid mediumint(8) unsigned NOT NULL default '0',
  reason varchar(75) NOT NULL default '',
  itime int(11) unsigned NOT NULL default '0',
  KEY uid (uid)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_languages (
  code char(2) NOT NULL default 'en',
  name varchar(128) NOT NULL default '',
  value text,
  value_original text,
  original tinyint(1) default '1',
  PRIMARY KEY  (code,name)
) TYPE=MyISAM;#kinst#



CREATE TABLE kpro_languages_admin (
  code char(2) NOT NULL default 'en',
  name varchar(128) NOT NULL default '',
  value text,
  value_original text,
  original tinyint(1) default '1',
  PRIMARY KEY  (code,name)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_linkcat (
  catid mediumint(5) unsigned NOT NULL auto_increment,
  parent_id mediumint(5) unsigned NOT NULL default '0',
  catname varchar(100) NOT NULL default '',
  catdesc text NOT NULL,
  area smallint(3) unsigned NOT NULL default '1',
  posi smallint(3) unsigned NOT NULL default '1',
  icon varchar(255) NOT NULL default '',
  group_id varchar(255) NOT NULL default '1,2,3',
  PRIMARY KEY  (catid)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_linkcomments (
  id mediumint(6) unsigned NOT NULL auto_increment,
  dlid mediumint(6) unsigned NOT NULL default '0',
  ctime int(10) unsigned NOT NULL default '0',
  autor mediumint(6) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  comment text NOT NULL,
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_links (
  id int(10) NOT NULL auto_increment,
  catid int(10) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  text text NOT NULL,
  url tinytext NOT NULL,
  hits int(10) unsigned NOT NULL default '0',
  hits_today int(10) unsigned NOT NULL default '0',
  ctime int(10) unsigned NOT NULL default '0',
  today int(11) NOT NULL default '0',
  votes mediumint(6) unsigned NOT NULL default '0',
  votes_data mediumint(6) unsigned NOT NULL default '0',
  votes_ip text NOT NULL,
  votes_uid text NOT NULL,
  canvote tinyint(1) NOT NULL default '0',
  cancomment tinyint(1) NOT NULL default '0',
  area smallint(3) NOT NULL default '1',
  uid int(10) unsigned NOT NULL default '1',
  active tinyint(1) NOT NULL default '1',
  image varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_manufacturer (
  id int(11) NOT NULL auto_increment,
  name varchar(255) default NULL,
  s_year int(8) default NULL,
  people int(11) NOT NULL default '0',
  hits int(11) NOT NULL default '0',
  full_name varchar(255) default NULL,
  s_country varchar(255) default NULL,
  url varchar(255) default NULL,
  email varchar(255) default NULL,
  adress text,
  descr text,
  icon varchar(255) NOT NULL default '',
  ctime int(10) unsigned NOT NULL default '1093604028',
  uid int(10) unsigned NOT NULL default '1',
  area smallint(3) NOT NULL default '1',
  PRIMARY KEY  (id) 
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#



CREATE TABLE kpro_navi (
  id int(10) unsigned NOT NULL auto_increment,
  parent_id int(10) unsigned default NULL,
  title varchar(200) NOT NULL default '',
  document tinytext NOT NULL,
  area smallint(3) unsigned NOT NULL default '1',
  openonclick tinyint(1) NOT NULL default '1',
  group_id tinytext NOT NULL,
  posi tinyint(3) unsigned default NULL,
  target varchar(10) NOT NULL default '_self',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=47 ;#kinst#



CREATE TABLE kpro_news (
  newsid int(10) unsigned NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  shortintro varchar(255) NOT NULL default '',
  text text NOT NULL,
  textmore text NOT NULL,
  area_id smallint(3) unsigned NOT NULL default '1',
  newscat smallint(3) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  ntime int(11) unsigned NOT NULL default '1',
  time_start int(11) unsigned NOT NULL default '1',
  time_end int(11) unsigned NOT NULL default '1',
  cansearch enum('yes','no') NOT NULL default 'yes',
  canvote enum('yes','no') NOT NULL default 'no',
  cancomment enum('yes','no') NOT NULL default 'yes',
  ispublic tinyint(1) NOT NULL default '1',
  isontop enum('yes','no') NOT NULL default 'no',
  end_top int(10) unsigned NOT NULL default '1',
  allareas enum('yes','no') NOT NULL default 'no',
  hits mediumint(8) unsigned NOT NULL default '0',
  printed mediumint(8) unsigned NOT NULL default '0',
  searchwords tinytext NOT NULL,
  image varchar(255) NOT NULL default '',
  image_top varchar(255) NOT NULL default '',
  image_align enum('left','right') NOT NULL default 'left',
  votes mediumint(6) unsigned NOT NULL default '0',
  votes_data mediumint(6) unsigned NOT NULL default '0',
  galids tinytext NOT NULL,
  newsids tinytext NOT NULL,
  inline_screens text NOT NULL,
  matchword tinytext NOT NULL,
  product mediumint(5) unsigned NOT NULL default '0',
  manufacturer mediumint(5) unsigned NOT NULL default '0',
  votes_ip text NOT NULL,
  votes_uid text NOT NULL,
  links tinytext NOT NULL,
  PRIMARY KEY  (newsid),
  KEY newscat (newscat),
  KEY newsid (newsid),
  KEY uid (uid),
  KEY ispublic (ispublic),
  KEY area_id (area_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_newscat (
  catid mediumint(5) unsigned NOT NULL auto_increment,
  parent_id mediumint(5) unsigned NOT NULL default '0',
  catname varchar(100) default NULL,
  catdesc tinytext NOT NULL,
  area smallint(3) unsigned NOT NULL default '1',
  posi smallint(3) unsigned NOT NULL default '1',
  icon varchar(255) NOT NULL default '',
  PRIMARY KEY  (catid),
  KEY area (area),
  KEY catid (catid),
  KEY catname (catname)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=2 ;#kinst#


CREATE TABLE kpro_newscomments (
  id mediumint(6) unsigned NOT NULL auto_increment,
  id_parent mediumint(6) unsigned NOT NULL default '0',
  newsid mediumint(6) unsigned NOT NULL default '0',
  ctime int(10) unsigned NOT NULL default '0',
  autor mediumint(6) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  comment text NOT NULL,
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_newsletter (
  id mediumint(5) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  area smallint(3) unsigned NOT NULL default '1',
  posi smallint(2) NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=3 ;#kinst#


CREATE TABLE kpro_newsletter_abos (
  id int(11) NOT NULL auto_increment,
  newsletter mediumint(6) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  ctime int(10) unsigned NOT NULL default '0',
  format enum('text','html') NOT NULL default 'text',
  securecode varchar(20) NOT NULL default '',
  active tinyint(1) NOT NULL default '0',
  area smallint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_newsletter_archiv (
  id int(10) unsigned NOT NULL auto_increment,
  ctime int(10) unsigned NOT NULL default '0',
  type enum('groups','abos') NOT NULL default 'abos',
  title varchar(255) NOT NULL default '',
  htmlv text NOT NULL,
  textv text NOT NULL,
  absmail varchar(255) NOT NULL default '',
  absname varchar(255) NOT NULL default '',
  author int(10) unsigned NOT NULL default '0',
  attachments text NOT NULL,
  groups varchar(255) NOT NULL default '',
  area smallint(3) NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_permissions (
  group_id int(11) NOT NULL default '0',
  section_id int(11) NOT NULL default '0',
  permissions text NOT NULL,
  PRIMARY KEY  (group_id,section_id)
) TYPE=MyISAM PACK_KEYS=0;#kinst#


CREATE TABLE kpro_platform (
  id int(10) unsigned NOT NULL auto_increment,
  platform varchar(255) NOT NULL default '',
  area smallint(3) NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_pn (
  pnid int(11) unsigned NOT NULL auto_increment,
  to_uid mediumint(8) unsigned default NULL,
  from_uid mediumint(8) unsigned default NULL,
  topic varchar(255) default NULL,
  message text,
  is_readed enum('yes','no') default NULL,
  pntime int(11) default '0',
  typ enum('inbox','outbox') default 'inbox',
  smilies enum('yes','no') NOT NULL default 'yes',
  parseurl enum('yes','no') NOT NULL default 'no',
  reply enum('yes','no') NOT NULL default 'no',
  forward enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (pnid),
  KEY id (pnid)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_poll (
  id int(10) unsigned NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  area_id int(11) NOT NULL default '0',
  active tinyint(1) NOT NULL default '0',
  group_id tinytext,
  ip text NOT NULL,
  uid text NOT NULL,
  can_comment tinyint(4) default '0',
  place_id tinyint(4) NOT NULL default '0',
  start int(10) unsigned NOT NULL default '0',
  end int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY title (title),
  FULLTEXT KEY title_2 (title)
) TYPE=MyISAM AUTO_INCREMENT=2 ;#kinst#


CREATE TABLE kpro_poll_item (
  id int(10) unsigned NOT NULL auto_increment,
  poll_id int(10) unsigned NOT NULL default '0',
  title tinytext NOT NULL,
  hits int(10) unsigned NOT NULL default '0',
  color varchar(10) NOT NULL default '',
  posi smallint(2) unsigned NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=5 ;#kinst#


CREATE TABLE kpro_pollcomments (
  id mediumint(6) unsigned NOT NULL auto_increment,
  pollid mediumint(6) unsigned NOT NULL default '0',
  ctime int(10) unsigned NOT NULL default '0',
  autor mediumint(6) unsigned NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  comment text NOT NULL,
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_posticons (
  id int(11) NOT NULL auto_increment,
  posi mediumint(5) NOT NULL default '1',
  active tinyint(1) NOT NULL default '1',
  path varchar(55) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=19 ;#kinst#


CREATE TABLE kpro_referer (
  id int(11) NOT NULL auto_increment,
  user_os varchar(20) default NULL,
  user_ua varchar(20) default NULL,
  user_referer varchar(255) default NULL,
  datum datetime default '0000-00-00 00:00:00',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_sessions (
  sesskey varchar(32) NOT NULL default '',
  expiry int(10) unsigned NOT NULL default '0',
  value text NOT NULL,
  PRIMARY KEY  (sesskey)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_settings (
  id int(11) NOT NULL auto_increment,
  company_name varchar(255) NOT NULL default '',
  company_website varchar(255) NOT NULL default '',
  company_street varchar(255) NOT NULL default '',
  company_city varchar(255) NOT NULL default '',
  company_zip varchar(20) NOT NULL default '',
  company_country varchar(25) NOT NULL default '',
  company_email varchar(255) NOT NULL default '',
  company_email_support varchar(255) NOT NULL default '',
  company_email_siteadmin varchar(255) NOT NULL default '',
  company_email_reply varchar(255) NOT NULL default '',
  company_phone varchar(255) NOT NULL default '',
  company_fax varchar(255) NOT NULL default '',
  company_mobile varchar(255) NOT NULL default '',
  company_owner varchar(255) NOT NULL default '',
  company_impressum text NOT NULL,
  company_agb text NOT NULL,
  tformat varchar(15) NOT NULL default 'd.m.Y',
  tformat_h varchar(15) NOT NULL default 'H:i',
  bbcodesite tinyint(1) unsigned NOT NULL default '1',
  bbcodecomments tinyint(1) NOT NULL default '1',
  imgcode tinyint(1) unsigned NOT NULL default '1',
  smilies tinyint(3) unsigned NOT NULL default '1',
  bannednames text NOT NULL,
  bannedemails text NOT NULL,
  regtype enum('norm','now','admin') NOT NULL default 'norm',
  mailbyregister tinyint(1) unsigned NOT NULL default '1',
  smileycomments tinyint(1) unsigned NOT NULL default '1',
  commentnews tinyint(1) unsigned NOT NULL default '1',
  maxlines smallint(3) unsigned NOT NULL default '50',
  boxwidthcomm varchar(10) NOT NULL default '100%',
  boxwidthforums varchar(10) NOT NULL default '100%',
  galwidth smallint(4) unsigned NOT NULL default '120',
  galheight smallint(4) unsigned NOT NULL default '110',
  nofactor tinyint(1) unsigned NOT NULL default '0',
  thumbcomp smallint(3) unsigned NOT NULL default '90',
  picspp smallint(3) unsigned NOT NULL default '12',
  picspr smallint(3) unsigned NOT NULL default '4',
  smiliebr smallint(3) unsigned NOT NULL default '4',
  admintheme varchar(25) NOT NULL default 'original',
  badwords text NOT NULL,
  badwords_replace varchar(75) NOT NULL default '!#*$&?',
  imagewatermark tinyint(1) unsigned NOT NULL default '1',
  watermark varchar(255) NOT NULL default 'uploads/galerie/watermark.png',
  watermarktrans smallint(3) unsigned NOT NULL default '100',
  spamprotect tinyint(1) NOT NULL default '1',
  spamprotect_time smallint(4) unsigned NOT NULL default '3',
  mygmt varchar(5) NOT NULL default '1',
  mailbycomment tinyint(1) NOT NULL default '0',
  maxlengthword mediumint(3) NOT NULL default '150',
  cont_allow_attach tinyint(1) unsigned NOT NULL default '1',
  cont_max_attach mediumint(4) unsigned NOT NULL default '100',
  cont_phone tinyint(1) unsigned NOT NULL default '1',
  cont_plz tinyint(1)unsigned  NOT NULL default '0',
  cont_town tinyint(1) unsigned NOT NULL default '0',
  cont_firstname tinyint(1) unsigned NOT NULL default '1',
  cont_lastname tinyint(1) unsigned NOT NULL default '1',
  cont_street tinyint(1) unsigned NOT NULL default '1',
  cont_cnumber tinyint(1) unsigned NOT NULL default '1',
  commentform_disp tinyint(1) unsigned NOT NULL default '1',
  regtype_choice enum('now','email') NOT NULL default 'now',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;#kinst#



CREATE TABLE kpro_shop_articles (
  id int(11) NOT NULL auto_increment,
  articlecat int(11) NOT NULL default '0',
  articlecat_2 int(10) unsigned NOT NULL default '0',
  artnumber varchar(25) NOT NULL default '',
  price decimal(8,2) NOT NULL default '0.00',
  price_list decimal(8,2) NOT NULL default '0.00',
  title varchar(255) NOT NULL default '',
  descr_short text NOT NULL,
  descr text NOT NULL,
  active tinyint(1) NOT NULL default '1',
  ctime int(11) NOT NULL default '0',
  hits int(10) unsigned NOT NULL default '0',
  icon varchar(255) NOT NULL default '',
  esd tinyint(1) NOT NULL default '0',
  esd_dltimes smallint(3) NOT NULL default '5',
  esd_timespan smallint(3) NOT NULL default '72',
  esd_download varchar(255) NOT NULL default '',
  ustzone smallint(3) unsigned NOT NULL default '1',
  amount_store mediumint(5) unsigned NOT NULL default '999',
  amount_min smallint(4) unsigned NOT NULL default '1',
  amount_max smallint(4) unsigned NOT NULL default '10',
  show_st tinyint(1) NOT NULL default '1',
  posi_overview smallint(4) unsigned NOT NULL default '1',
  weight int(10) unsigned NOT NULL default '0',
  manufacturer mediumint(5) unsigned NOT NULL default '0',
  galids varchar(255) NOT NULL default '',
  multiorder_deny tinyint(1) NOT NULL default '0',
  matchword1 varchar(75) NOT NULL default '',
  matchword2 varchar(75) NOT NULL default '',
  available smallint(3) NOT NULL default '1',
  fsk18 tinyint(1) unsigned NOT NULL default '0',
  esd_text text NOT NULL,
  detail_sys text NOT NULL,
  detail_press text NOT NULL,
  detail_service text NOT NULL,
  detail_programms text NOT NULL,
  unit_count decimal(8,2) NOT NULL default '1.00',
  EinheitId int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY id (id),
  KEY artnumber (artnumber),
  KEY articlecat (articlecat)
) TYPE=MyISAM;#kinst#



CREATE TABLE kpro_shop_artoptions (
  id int(10) unsigned NOT NULL auto_increment,
  artnumber varchar(255) NOT NULL default '',
  option_cat int(11) NOT NULL default '1',
  option_desc varchar(255) NOT NULL default '',
  math_operant enum('plus','minus') NOT NULL default 'plus',
  math_value decimal(8,2) NOT NULL default '0.00',
  pre_selected tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_shop_artoptions_cat (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  artnumber varchar(255) NOT NULL default '',
  artoptions_descr text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#



CREATE TABLE kpro_shop_availability (
  id int(10) unsigned NOT NULL auto_increment,
  descr varchar(255) NOT NULL default '',
  icon varchar(255) NOT NULL default '',
  pos smallint(2) NOT NULL default '10',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=11 ;#kinst#



CREATE TABLE kpro_shop_calculation_settings (
  id int(10) unsigned NOT NULL auto_increment,
  body_bg varchar(10) NOT NULL default '#ffffff',
  td_lines varchar(10) NOT NULL default '#000000',
  fontsize varchar(6) NOT NULL default '12px',
  fontfamily varchar(100) NOT NULL default 'Verdana,Arial',
  fontcolor varchar(10) NOT NULL default '#000000',
  firstrow varchar(10) NOT NULL default '#F7F7F7',
  secondrow varchar(10) NOT NULL default '#EBEBEB',
  th varchar(10) NOT NULL default '#EBEBEB',
  email_after_payment text NOT NULL,
  emailfooter text NOT NULL,
  shoplogo varchar(255) NOT NULL default '',
  shopadress text NOT NULL,
  e_type enum('text','html') NOT NULL default 'html',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;#kinst#


CREATE TABLE kpro_shop_cart (
  cartid bigint(15) unsigned NOT NULL auto_increment,
  ordertime int(10) unsigned NOT NULL default '0',
  ordernumber varchar(255) NOT NULL default '',
  artnumber varchar(255) NOT NULL default '',
  artamount mediumint(5) unsigned NOT NULL default '1',
  options tinytext NOT NULL,
  newprice decimal(8,2) NOT NULL default '0.00',
  extras_string tinytext NOT NULL,
  product_url tinytext NOT NULL,
  PRIMARY KEY  (cartid),
  KEY ordernumber (ordernumber),
  KEY artamount (artamount)
) TYPE=MyISAM AUTO_INCREMENT=2 ;#kinst#



CREATE TABLE kpro_shop_cat (
  catid mediumint(5) unsigned NOT NULL auto_increment,
  parent_id mediumint(5) unsigned NOT NULL default '0',
  catname varchar(100) default NULL,
  catdesc tinytext NOT NULL,
  posi smallint(3) unsigned NOT NULL default '1',
  icon varchar(255) NOT NULL default '',
  PRIMARY KEY  (catid),
  KEY catid (catid),
  KEY catname (catname)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=32 ;#kinst#




CREATE TABLE kpro_shop_coupons (
  id int(11) NOT NULL auto_increment,
  couponcode varchar(20) NOT NULL default '',
  uid int(11) NOT NULL default '0',
  amount decimal(8,2) NOT NULL default '0.00',
  generated int(11) NOT NULL default '0',
  redeemed int(11) NOT NULL default '0',
  ordernumber varchar(20) NOT NULL default '',
  coupon_type enum('wert','pro') NOT NULL default 'wert',
  never_expire tinyint(1) unsigned NOT NULL default '0',
  uids longtext NOT NULL,
  guilty_till varchar(15) NOT NULL default '',
  ordernumbers longtext NOT NULL,
  min_amount decimal(8,2) NOT NULL default '0.00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_shop_esd (
  id bigint(14) NOT NULL auto_increment,
  uid bigint(14) NOT NULL default '0',
  dltimes int(10) unsigned NOT NULL default '0',
  dlid varchar(255) NOT NULL default '',
  dltimespan int(14) NOT NULL default '0',
  itemkey varchar(10) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_shop_orders (
  orderid bigint(15) unsigned NOT NULL auto_increment,
  ordertime int(11) unsigned NOT NULL default '0',
  ip varchar(25) NOT NULL default '',
  uid bigint(15) unsigned NOT NULL default '0',
  ovall decimal(8,2) NOT NULL default '0.00',
  status_o enum('wait','progress','ok','failed','download') NOT NULL default 'wait',
  articles text NOT NULL,
  control varchar(255) NOT NULL default '',
  ust decimal(8,2) NOT NULL default '0.00',
  payment_id smallint(3) unsigned NOT NULL default '1',
  calculation text NOT NULL,
  calculation2 text NOT NULL,
  shipping_adress text NOT NULL,
  weight int(10) unsigned NOT NULL default '0',
  extra text NOT NULL,
  hid varchar(32) NOT NULL default '',
  extra_cost decimal(4,2) NOT NULL default '0.00',
  coupon decimal(8,2) NOT NULL default '0.00',
  coupon_id int(10) unsigned NOT NULL default '0',
  deleted tinyint(1) unsigned NOT NULL default '0',
  order_message text NOT NULL,
  shipping_country char(2) NOT NULL default 'de',
  shipping_company varchar(255) NOT NULL default '',
  shipping_company_reciever varchar(255) NOT NULL default '',
  shipping_firstname varchar(100) NOT NULL default '',
  shipping_lastname varchar(100) NOT NULL default '',
  shipping_street varchar(100) NOT NULL default '',
  shipping_streetnumber varchar(25) NOT NULL default '',
  shipping_zip varchar(20) NOT NULL default '',
  shipping_town varchar(75) NOT NULL default '',
  rng_company varchar(255) NOT NULL default '',
  rng_company_reciever varchar(255) NOT NULL default '',
  rng_firstname varchar(100) NOT NULL default '',
  rng_lastname varchar(100) NOT NULL default '',
  rng_street varchar(100) NOT NULL default '',
  rng_streetnumber varchar(25) NOT NULL default '',
  rng_zip varchar(20) NOT NULL default '',
  rng_town varchar(75) NOT NULL default '',
  rng_country char(2) NOT NULL default '',
  PRIMARY KEY  (orderid)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_shop_orders_items (
  id bigint(15) unsigned NOT NULL auto_increment,
  uid bigint(15) unsigned NOT NULL default '0',
  ordertime int(10) unsigned NOT NULL default '0',
  ordernumber varchar(255) NOT NULL default '',
  artnumber varchar(255) NOT NULL default '',
  artamount mediumint(5) unsigned NOT NULL default '1',
  options tinytext NOT NULL,
  price decimal(8,2) NOT NULL default '0.00',
  extras_string tinytext NOT NULL,
  product_url tinytext NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;#kinst#


CREATE TABLE kpro_shop_payment_methods (
  id int(10) unsigned NOT NULL auto_increment,
  active tinyint(1) unsigned NOT NULL default '1',
  name varchar(255) NOT NULL default '',
  descr text NOT NULL,
  disabled_noweight tinyint(1) unsigned NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  testmode varchar(45) NOT NULL default '0',
  inst_id varchar(75) NOT NULL default '',
  extra_cost decimal(4,2) NOT NULL default '0.00',
  extra_cost_type enum('wert','pro') NOT NULL default 'wert',
  allowed_countries text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_shop_settings (
  id smallint(2) unsigned NOT NULL auto_increment,
  shop_opener text NOT NULL,
  currency_symbol varchar(10) NOT NULL default '€',
  currency_pay varchar(10) NOT NULL default 'EUR',
  cookie_expired smallint(3) NOT NULL default '6',
  shop_country char(2) NOT NULL default 'DE',
  use_tax_default tinyint(1) NOT NULL default '1',
  agb_shop text NOT NULL,
  email_shop varchar(255) NOT NULL default '',
  email_shop_reply varchar(255) NOT NULL default '',
  email_new_order varchar(255) NOT NULL default '',
  ordersubject varchar(255) NOT NULL default '',
  ordersubject_copy varchar(255) NOT NULL default '',
  enable_preorder tinyint(1) NOT NULL default '1',
  enable_notificationlink tinyint(1) NOT NULL default '1',
  items_perpage smallint(3) unsigned NOT NULL default '10',
  shipping_free decimal(8,2) NOT NULL default '0.00',
  shop_cookiewarning text NOT NULL,
  thumb_width_middle smallint(3) unsigned NOT NULL default '75',
  thumb_width_norm smallint(3) unsigned NOT NULL default '130',
  thumb_width_small smallint(3) unsigned NOT NULL default '48',
  thumb_quality smallint(3) unsigned NOT NULL default '100',
  newest_td smallint(2) unsigned NOT NULL default '2',
  newest_max smallint(2) unsigned NOT NULL default '6',
  shop_ezeflag text NOT NULL,
  use_coupons tinyint(1) NOT NULL default '1',
  showtopnav tinyint(1) NOT NULL default '1',
  data_security text NOT NULL,
  shipping_cinfo text NOT NULL,
  shipping_countries text NOT NULL,
  cont_allow_attach tinyint(1) unsigned NOT NULL default '1',
  cont_max_attach mediumint(4) unsigned NOT NULL default '100',
  cont_phone tinyint(1) unsigned NOT NULL default '1',
  cont_plz tinyint(1) unsigned NOT NULL default '1',
  cont_town tinyint(1) unsigned NOT NULL default '1',
  cont_firstname tinyint(1) unsigned NOT NULL default '1',
  cont_lastname tinyint(1) unsigned NOT NULL default '1',
  cont_street tinyint(3) unsigned NOT NULL default '1',
  fsk_info text NOT NULL,
  NoShippingFree tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_shop_shipper (
  id int(11) NOT NULL auto_increment,
  shipper_id varchar(20) NOT NULL default '',
  enabled tinyint(1) NOT NULL default '0',
  fullname varchar(255) NOT NULL default '',
  descr text NOT NULL,
  icon varchar(255) NOT NULL default '',
  no_values tinyint(1) unsigned NOT NULL default '0',
  allowed_payments text NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY shipper_id (shipper_id)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=8 ;#kinst#

 

CREATE TABLE kpro_shop_shipping_temp (
  id int(11) NOT NULL auto_increment,
  summe decimal(8,2) NOT NULL default '0.00',
  ordernumber tinytext NOT NULL,
  shipper varchar(20) NOT NULL default '',
  uid int(10) unsigned NOT NULL default '0',
  must_refresh tinyint(1) NOT NULL default '0',
  ordertime int(10) unsigned NOT NULL default '0',
  payment smallint(3) unsigned NOT NULL default '1',
  overall decimal(8,2) NOT NULL default '0.00',
  articles text NOT NULL,
  ust decimal(8,2) NOT NULL default '0.00',
  coupon int(11) NOT NULL default '0',
  coupon_amount varchar(15) NOT NULL default '0.00',
  deduction smallint(2) NOT NULL default '0',
  coupon_type varchar(5) NOT NULL default '',
  ovall_updated tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_shop_stprices (
  id int(10) unsigned NOT NULL auto_increment,
  artnumber  varchar(50) NOT NULL default '',
  from_a mediumint(5) unsigned NOT NULL default '1',
  to_a mediumint(5) unsigned NOT NULL default '5',
  newprice decimal(8,2) NOT NULL default '0.00',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=10 ;#kinst#


CREATE TABLE kpro_shop_topseller (
  id int(10) unsigned NOT NULL auto_increment,
  artnumber varchar(100) NOT NULL default '',
  amount int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY artnumber (artnumber),
  KEY id (id)
) TYPE=MyISAM AUTO_INCREMENT=7 ;#kinst#


CREATE TABLE kpro_shop_ustzone (
  id mediumint(8) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  val varchar(6) NOT NULL default '16.00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#

CREATE TABLE kpro_sitestats (
  datum varchar(12) default NULL,
  hits int(10) unsigned default '0',
  visits int(10) unsigned default '0',
  tag smallint(2) unsigned default '0',
  monat smallint(2) unsigned default '0',
  jahr smallint(4) unsigned default '0'
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_smileys (
  id int(11) NOT NULL auto_increment,
  posi mediumint(5) NOT NULL default '1',
  active tinyint(1) NOT NULL default '1',
  code varchar(15) NOT NULL default '',
  path varchar(55) NOT NULL default '',
  area smallint(2) NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=37 ;#kinst#


CREATE TABLE kpro_speedbar (
  id int(10) unsigned NOT NULL auto_increment,
  section smallint(3) unsigned NOT NULL default '0',
  posi int(10) unsigned NOT NULL default '0',
  slink varchar(255) NOT NULL default '',
  linkname varchar(255) NOT NULL default '',
  aktiv enum('Y','N') NOT NULL default 'Y',
  target varchar(10) NOT NULL default '_self',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=6 ;#kinst#

CREATE TABLE kpro_static (
  id int(10) unsigned NOT NULL auto_increment,
  categ smallint(3) unsigned NOT NULL default '1',
  title varchar(255) NOT NULL default '',
  content text NOT NULL,
  pagename varchar(255) NOT NULL default '',
  area smallint(3) unsigned NOT NULL default '1',
  uid int(10) unsigned NOT NULL default '0',
  ctime int(11) NOT NULL default '0',
  hits int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM ;#kinst#

CREATE TABLE kpro_static_categ (
  id smallint(3) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=3 ;#kinst#


CREATE TABLE kpro_user (
  uid int(11) unsigned NOT NULL auto_increment,
  ugroup smallint(3) unsigned NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  uname varchar(25) NOT NULL default '',
  email varchar(65) NOT NULL default '',
  url varchar(200) NOT NULL default '',
  user_avatar_pref varchar(255) NOT NULL default '',
  user_regdate int(11) unsigned NOT NULL default '0',
  user_sig text NOT NULL,
  user_from varchar(75) NOT NULL default '',
  user_interests text NOT NULL,
  user_birthday varchar(10) NOT NULL default '',
  pass varchar(35) NOT NULL default '',
  passtemp varchar(35) NOT NULL default '',
  posts mediumint(8) unsigned NOT NULL default '0',
  theme varchar(75) NOT NULL default '',
  last_login int(11) unsigned NOT NULL default '0',
  user_viewemail enum('yes','no') NOT NULL default 'yes',
  user_canpn enum('yes','no') NOT NULL default 'yes',
  invisible enum('yes','no') NOT NULL default 'no',
  pntomail enum('yes','no') NOT NULL default 'yes',
  status tinyint(1) unsigned NOT NULL default '1',
  user_lastonline int(11) unsigned default NULL,
  user_lastonline_temp int(11) unsigned default NULL,
  user_posts mediumint(8) unsigned NOT NULL default '0',
  user_lastpost int(10) unsigned default NULL,
  recieve_newsletter tinyint(1) NOT NULL default '1',
  usedefault_avatar smallint(1) NOT NULL default '1',
  user_avatar varchar(255) NOT NULL default '',
  country char(2) NOT NULL default 'DE',
  group_id_misc tinytext NOT NULL,
  person enum('private','company') NOT NULL default 'private',
  phone varchar(255) NOT NULL default '',
  phone_mobile varchar(255) NOT NULL default '',
  fax varchar(255) NOT NULL default '',
  lastname varchar(255) NOT NULL default '',
  zip varchar(255) NOT NULL default '',
  street varchar(255) NOT NULL default '',
  title varchar(20) NOT NULL default '',
  show_public tinyint(1) unsigned NOT NULL default '1',
  company varchar(255) NOT NULL default '',
  ustid varchar(255) NOT NULL default '',
  fsk18 tinyint(1) unsigned NOT NULL default '0',
  user_icq VARCHAR( 30 ) NOT NULL default '',
  user_aim VARCHAR( 30 ) NOT NULL default '',
  user_skype VARCHAR( 30 ) NOT NULL default '',
  PRIMARY KEY  (uid),
  KEY uid (uid),
  KEY user_lastonline (user_lastonline),
  KEY user_lastonline_temp (user_lastonline_temp)
) TYPE=MyISAM;#kinst#



CREATE TABLE kpro_usergroup (
  ugroup mediumint(8) unsigned NOT NULL auto_increment,
  groupname_single varchar(75) NOT NULL default '',
  groupname varchar(100) NOT NULL default '',
  groupmaxpn mediumint(6) unsigned NOT NULL default '50',
  groupmaxsig mediumint(6) unsigned NOT NULL default '100',
  maxpnlength mediumint(6) unsigned NOT NULL default '1000',
  maxcommlength mediumint(6) unsigned NOT NULL default '500',
  maxpicdownload smallint(3) unsigned NOT NULL default '5',
  avatar_size int(10) unsigned NOT NULL default '15360',
  avatar_width int(11) NOT NULL default '120',
  avatar_height int(11) NOT NULL default '100',
  default_avatar varchar(255) NOT NULL default '',
  set_default_avatar tinyint(1) NOT NULL default '0',
  maxlength_post int(11) NOT NULL default '50000',
  max_attachments int(11) NOT NULL default '5',
  deductions smallint(2) NOT NULL default '0',
  PRIMARY KEY  (ugroup),
  KEY groupid (ugroup)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=7 ;#kinst#


CREATE TABLE kpro_useronline (
  ip varchar(25) NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  expire int(11) NOT NULL default '0',
  uname varchar(255) NOT NULL default '',
  invisible varchar(10) NOT NULL default ''
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_shop_images (
  id int(10) unsigned NOT NULL auto_increment,
  artnumber varchar(50) NOT NULL default '',
  path varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_private_files (
  id int(11) NOT NULL auto_increment,
  uid int(11) NOT NULL default '0',
  pname varchar(255) NOT NULL default '',
  artnumber varchar(50) NOT NULL default '',
  ptilltime int(11) NOT NULL default '0',
  plicdata varchar(20) NOT NULL default '',
  downloads int(11) NOT NULL default '0',
  url varchar(255) NOT NULL default '',
  comment_user text NOT NULL,
  comment_admin text NOT NULL,
  locked tinyint(1) NOT NULL default '0',
  locked_reason text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#

CREATE TABLE kpro_private_files_items (
  id int(11) NOT NULL auto_increment,
  artnumber varchar(50) NOT NULL default '',
  type tinyint(1) NOT NULL default '0',
  file_name varchar(200) NOT NULL default '',
  ctime int(11) NOT NULL default '0',
  posi smallint(3) NOT NULL default '0',
  text text NOT NULL,
  active tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#

CREATE TABLE kpro_f_topic_read (
  Usr int(11) NOT NULL default '0',
  Topic int(11) NOT NULL default '0',
  ReadOn timestamp NOT NULL,
  PRIMARY KEY  (Usr,Topic)
) TYPE=MyISAM;#kinst#

CREATE TABLE kpro_activation (
code VARCHAR( 25 ) NOT NULL ,
uid BIGINT( 10 ) UNSIGNED NOT NULL ,
UNIQUE (code)
)TYPE=MYISAM;#kinst#


CREATE TABLE kpro_products (
  id int(11) unsigned NOT NULL auto_increment,
  title varchar(255) default NULL,
  genre mediumint(5) unsigned default NULL,
  publisher mediumint(5) unsigned default NULL,
  manufacturer mediumint(5) unsigned default NULL,
  voting smallint(3) unsigned default NULL,
  descr text,
  subtitle varchar(255) NOT NULL default '',
  asin varchar(255) NOT NULL default '',
  platform varchar(100) default NULL,
  time_release varchar(50) default NULL,
  price varchar(255) NOT NULL default '',
  shopurl varchar(255) default NULL,
  shop varchar(255) default NULL,
  boxshot varchar(255) default NULL,
  links text,
  gallery varchar(100) default NULL,
  inline_screens text NOT NULL,
  uid mediumint(5) unsigned NOT NULL default '1',
  ctime int(10) unsigned NOT NULL default '1093884725',
  hits int(10) unsigned NOT NULL default '0',
  area smallint(3) NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=3;#kinst#


CREATE TABLE kpro_units (
  EinheitId smallint(3) unsigned NOT NULL,
  Einheit varchar(20) NOT NULL,
  EinheitMz varchar(20) NOT NULL,
  PRIMARY KEY  (EinheitId),
  UNIQUE KEY Einheit (Einheit)
) TYPE=MyISAM;#kinst#



CREATE TABLE kpro_cheats (
  CheatId int(10) NOT NULL auto_increment,
  CheatPlattformId int(10) unsigned NOT NULL default '0',
  CheatLanguage char(2) NOT NULL default 'de',
  CheatType enum('cheat','walkthrough','patch') NOT NULL default 'cheat',
  CheatAuthor int(10) unsigned NOT NULL default '0',
  CheatHits int(10) unsigned NOT NULL default '0',
  CheatTimeUpdated int(10) unsigned NOT NULL default '0',
  CheatTitle varchar(200) NOT NULL default '',
  CheatText text NOT NULL,
  CheatImage varchar(255) NOT NULL default '',
  CheatFile varchar(255) NOT NULL default '',
  CheatFileHits int(10) unsigned NOT NULL default '0',
  CheatOrderLink varchar(255) NOT NULL default '',
  CheatManufacturer int(10) unsigned NOT NULL default '0',
  CheatPublisher int(10) unsigned NOT NULL default '0',
  CheatWebsite varchar(255) NOT NULL default '',
  CheatWebsiteHits int(10) unsigned NOT NULL default '0',
  CheatMatchword varchar(255) NOT NULL default '',
  CheatGallery tinytext NOT NULL,
  CheatLinks tinytext NOT NULL,
  CheatProduct smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (CheatId)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_requiredfields (
  id smallint(5) unsigned NOT NULL auto_increment,
  name varchar(25) NOT NULL default '',
  show_field tinyint(3) unsigned NOT NULL default '1',
  required_field tinyint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_securecode (
  id int(10) unsigned NOT NULL auto_increment,
  code varchar(10) NOT NULL default '',
  ctime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;#kinst#


CREATE TABLE kpro_shop_shipping_prices (
  Id mediumint(5) unsigned NOT NULL auto_increment,
  ShippingCountry char(2) NOT NULL default '',
  ShipperId mediumint(5) unsigned NOT NULL default '0',
  WFrom decimal(6,3) NOT NULL default '0.000',
  WTill decimal(6,3) NOT NULL default '0.000',
  ShippingCost decimal(6,2) NOT NULL default '0.00',
  VolId int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (Id)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=64 ;#kinst#

CREATE TABLE kpro_shop_shipping_pricesdef (
  Id mediumint(5) unsigned NOT NULL auto_increment,
  ShipperId mediumint(5) unsigned NOT NULL default '0',
  ShippingCountry char(2) NOT NULL default 'de',
  StdVal decimal(6,2) NOT NULL default '0.00',
  PRIMARY KEY  (Id)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=22 ;#kinst#

CREATE TABLE kpro_shop_shipping_volumes (
  Id int(10) unsigned NOT NULL auto_increment,
  ShipperId int(10) unsigned NOT NULL default '0',
  VMin decimal(8,3) NOT NULL default '0.001',
  VMax decimal(8,3) NOT NULL default '10.000',
  PRIMARY KEY  (Id)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=22 ;#kinst#