Table	Create Table
medien	CREATE TABLE `medien` (\n  `a_id` smallint(5) unsigned zerofill NOT NULL auto_increment,\n  `a_titel` varchar(255) NOT NULL,\n  `n_id` smallint(5) unsigned zerofill NOT NULL,\n  `k_id` smallint(5) unsigned zerofill NOT NULL,\n  `m_id` smallint(5) unsigned zerofill NOT NULL,\n  `a_nr` varchar(255) default NULL,\n  `a_jahr` smallint(4) default NULL,\n  `a_sterne` tinyint(3) unsigned default NULL,\n  `a_notiz` text,\n  `a_aktiv` tinyint(1) default '1',\n  `a_update` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,\n  PRIMARY KEY  (`a_id`),\n  KEY `namen_id` (`n_id`),\n  KEY `kat_id` (`k_id`),\n  KEY `med_id` (`m_id`),\n  CONSTRAINT `kat` FOREIGN KEY (`k_id`) REFERENCES `kat` (`c_id`) ON UPDATE CASCADE,\n  CONSTRAINT `med` FOREIGN KEY (`m_id`) REFERENCES `med` (`d_id`) ON UPDATE CASCADE,\n  CONSTRAINT `namen` FOREIGN KEY (`n_id`) REFERENCES `namen` (`b_id`) ON UPDATE CASCADE\n) ENGINE=InnoDB AUTO_INCREMENT=928 DEFAULT CHARSET=latin1
Table	Create Table
med	CREATE TABLE `med` (\n  `d_id` smallint(5) unsigned zerofill NOT NULL auto_increment,\n  `d_med` varchar(255) NOT NULL default '***',\n  `d_sort` smallint(5) unsigned NOT NULL,\n  `d_notiz` varchar(255) default NULL,\n  `d_aktiv` tinyint(1) default '1',\n  `d_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,\n  PRIMARY KEY  (`d_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1
Table	Create Table
kat	CREATE TABLE `kat` (\n  `c_id` smallint(5) unsigned zerofill NOT NULL auto_increment,\n  `c_kat` varchar(255) NOT NULL default '***',\n  `c_sort` smallint(5) unsigned NOT NULL,\n  `c_notiz` varchar(255) default NULL,\n  `c_aktiv` tinyint(1) default '1',\n  `c_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,\n  PRIMARY KEY  (`c_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1
Table	Create Table
namen	CREATE TABLE `namen` (\n  `b_id` smallint(5) unsigned zerofill NOT NULL auto_increment,\n  `b_vorname` varchar(255) default NULL,\n  `b_nachname` varchar(255) NOT NULL default '***',\n  `b_jahr` smallint(4) default NULL,\n  `b_notiz` text,\n  `b_aktiv` tinyint(1) default '1',\n  `b_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,\n  PRIMARY KEY  (`b_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=309 DEFAULT CHARSET=latin1