-- MySQL dump 8.22 -- -- Host: localhost Database: weristda --------------------------------------------------------- -- Server version 3.23.52-log use weristda; -- -- Table structure for table 'log' -- CREATE TABLE log ( zeitstempel timestamp(14) NOT NULL, wer varchar(200) NOT NULL default '', was text NOT NULL ) TYPE=MyISAM COMMENT='Logdatei'; -- -- Dumping data for table 'log' -- -- -- Table structure for table 'termine' -- CREATE TABLE termine ( id int(11) NOT NULL auto_increment, zeitstempel timestamp(14) NOT NULL, user_id int(11) NOT NULL default '0', start date NOT NULL default '0000-00-00', ende date NOT NULL default '0000-00-00', folgeid int(11) NOT NULL default '0', wo varchar(20) NOT NULL default '', text text NOT NULL, PRIMARY KEY (id), KEY user_id (user_id,start), KEY folgeid (folgeid), KEY start (start) ) TYPE=MyISAM COMMENT='Termine'; -- -- Dumping data for table 'termine' -- -- -- Table structure for table 'user' -- CREATE TABLE user ( id int(11) NOT NULL auto_increment, account varchar(10) NOT NULL default '', name varchar(20) NOT NULL default '', vorname varchar(20) NOT NULL default '', bemerkung text NOT NULL, deleted char(1) NOT NULL default '0', PRIMARY KEY (id), KEY account (account) ) TYPE=MyISAM COMMENT='Verfuegbare User';