sql_update_arcive.sql

CREATE TABLE `archive` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fahrt_id` int(11) NOT NULL,
  `fahrt_name` text CHARACTER SET utf8 NOT NULL,
  `tab1` text CHARACTER SET utf8 NOT NULL,
  `tab2` text CHARACTER SET utf8 NOT NULL,
  `tab3` text CHARACTER SET utf8 NOT NULL,
  `moniTab1` text CHARACTER SET utf8 NOT NULL,
  `moniTab2` text CHARACTER SET utf8 NOT NULL,
  `moniTab3` text CHARACTER SET utf8 NOT NULL,
  `moniTabIO` text CHARACTER SET utf8 NOT NULL,
  `moniTabIOExtra` text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;