



CREATE TABLE IF NOT EXISTS  `dateien` (
   `pid` int(10) unsigned not null default '0',
   `dateiname` varchar(255) not null,
   `erw` varchar(4) not null,
   `dateigroesse` int(10) unsigned not null default '0',
   `dateityp` enum('Bild','Musik','Video','Dokument','Sonstiges') not null default 'Bild',
   `breite` int(4),
   `hoehe` int(4),
   KEY `pid` (`pid`),
   KEY `dateiname` (`dateiname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;





CREATE TABLE IF NOT EXISTS `internet` (
  `pid` int(10) unsigned NOT NULL default '0',
  `id_internet` int(6) unsigned NOT NULL auto_increment,
  `parent` int(6) unsigned NOT NULL default '0',
  `orderr` int(2) unsigned default NULL,
  `hide_from_navi` enum('0','1') NOT NULL default '0',
  `public` enum('0','1') NOT NULL default '0',
  `dname` varchar(255) default NULL,
  `lchange` int(10) unsigned default NULL,
  `lgen` int(10) unsigned default NULL,
  `bezeichnung` varchar(255) NOT NULL,
  `metakeys` varchar(255) default NULL,
  `metadescription` varchar(255) default NULL,
  `redirect_to` varchar(255) default NULL,
  PRIMARY KEY  (`id_internet`),
  KEY `pid` (`pid`,`orderr`),
  KEY `dname` (`dname`),
  KEY `parent` (`parent`),
  KEY `parent_2` (`parent`),
  KEY `parent_3` (`parent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS  `praesenz` (
   `pid` int(10) unsigned not null auto_increment,
   `domain` varchar(255) not null,
   `disabled` enum('0','1') not null default '0',
   PRIMARY KEY (`pid`),
   UNIQUE KEY (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS  `rechte` (
   `internet` int(6) unsigned not null default '0',
   `user` int(6) unsigned not null default '0',
   KEY `internet` (`internet`,`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS  `user` (
   `pid` int(10) unsigned not null default '0',
   `id_user` int(11) unsigned not null auto_increment,
   `loginname` varchar(255) not null,
   `loginpasswort` varchar(255) not null,
   `vorname` varchar(25),
   `nachname` varchar(25),
   `rechte` int(10) unsigned not null default '1',
   PRIMARY KEY (`id_user`),
   UNIQUE KEY (`loginname`),
   KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
