-- phpMyAdmin SQL Dump
-- version 2.9.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 27, 2007 at 09:02 AM
-- Server version: 5.0.27
-- PHP Version: 5.2.1
-- 
-- Database: `strwa43`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `airplane`
-- 

CREATE TABLE `airplane` (
  `airid` int(11) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL,
  `de1` varchar(40) NOT NULL,
  `de2` varchar(40) NOT NULL,
  `de3` varchar(40) NOT NULL,
  `aliases` varchar(255) NOT NULL,
  PRIMARY KEY  (`airid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED AUTO_INCREMENT=28 ;

-- 
-- Table structure for table `airplane`
-- 
-- --------------------------------------------------------

-- 
-- Table structure for table `airplane_link`
-- 

CREATE TABLE `airplane_link` (
  `airid` int(11) NOT NULL,
  `linkid` int(11) NOT NULL auto_increment,
  `description` varchar(128) NOT NULL,
  `url` varchar(1024) NOT NULL,
  `sort` int(11) NOT NULL,
  `created` date NOT NULL,
  `custid` int(11) NOT NULL,
  `tshow` int(11) default '0',
  PRIMARY KEY  (`linkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `ata_chapter`
-- 

CREATE TABLE `ata_chapter` (
  `ataid` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  PRIMARY KEY  (`ataid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `car_fleet`
-- 

CREATE TABLE `car_fleet` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(45) collate latin1_german1_ci NOT NULL,
  `usage` varchar(45) collate latin1_german1_ci NOT NULL,
  `number` varchar(45) collate latin1_german1_ci NOT NULL,
  `status` char(12) collate latin1_german1_ci NOT NULL default 'bereit',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=18 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `category`
-- 

CREATE TABLE `category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(128) NOT NULL,
  `sort` int(3) NOT NULL default '0',
  `type` int(2) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `categorysub`
-- 

CREATE TABLE `categorysub` (
  `id` int(11) NOT NULL,
  `subid` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL,
  `sort` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY  (`subid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `check_link`
-- 

CREATE TABLE `check_link` (
  `checkid` int(11) NOT NULL default '0',
  `linkid` int(11) NOT NULL auto_increment,
  `description` varchar(128) NOT NULL default '',
  `url` varchar(1024) NOT NULL,
  `sort` int(11) NOT NULL default '0',
  `created` date NOT NULL default '0000-00-00',
  `custid` int(11) NOT NULL default '0',
  `airid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`linkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `checktype`
-- 

CREATE TABLE `checktype` (
  `checkid` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  `custid` int(11) NOT NULL,
  PRIMARY KEY  (`checkid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `checktype_link`
-- 

CREATE TABLE `checktype_link` (
  `checkid` int(11) NOT NULL,
  `linkid` int(11) NOT NULL auto_increment,
  `description` varchar(128) NOT NULL,
  `url` varchar(1024) NOT NULL,
  `sort` int(11) NOT NULL,
  `created` date NOT NULL,
  `custid` int(11) NOT NULL,
  PRIMARY KEY  (`linkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `complaint`
-- 

CREATE TABLE `complaint` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cid` int(10) unsigned NOT NULL,
  `csubid` int(10) NOT NULL,
  `complaint` longtext NOT NULL,
  `created` date NOT NULL,
  `clock` time NOT NULL,
  `prio` int(10) unsigned NOT NULL,
  `status` char(10) NOT NULL default 'open',
  `name` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `cuair`
-- 

CREATE TABLE `cuair` (
  `custid` int(11) NOT NULL,
  `airid` int(11) NOT NULL,
  KEY `custid` (`custid`,`airid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='implement n:m Relation between customers and airplanes';

-- --------------------------------------------------------

-- 
-- Table structure for table `cuairch`
-- 

CREATE TABLE `cuairch` (
  `custid` int(11) NOT NULL,
  `airid` int(11) NOT NULL,
  `checkid` int(11) NOT NULL,
  `code` varchar(45) NOT NULL,
  `p9key` varchar(45) NOT NULL,
  PRIMARY KEY  (`custid`,`airid`,`checkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `customer`
-- 

CREATE TABLE `customer` (
  `custid` int(11) NOT NULL auto_increment,
  `name` varchar(40) character set latin1 collate latin1_german1_ci NOT NULL,
  `description` varchar(256) character set latin1 collate latin1_german2_ci NOT NULL,
  `created` date NOT NULL,
  `sort` int(11) NOT NULL,
  `catid` int(11) default '1',
  `token` char(6) default NULL,
  `seal` int(10) unsigned NOT NULL,
  `pkorr` decimal(7,2) NOT NULL default '0.00',
  PRIMARY KEY  (`custid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `customer_categorie`
-- 

CREATE TABLE `customer_categorie` (
  `catid` int(11) NOT NULL auto_increment,
  `description` varchar(128) NOT NULL,
  `sort` int(11) NOT NULL,
  PRIMARY KEY  (`catid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `customer_info`
-- 

CREATE TABLE `customer_info` (
  `custid` int(11) NOT NULL,
  `infoid` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `headline` varchar(128) character set latin1 collate latin1_german2_ci NOT NULL,
  `location` varchar(512) character set latin1 collate latin1_german2_ci NOT NULL,
  `enddate` date default NULL,
  `archived` tinyint(1) NOT NULL,
  `tshow` int(11) NOT NULL default '0',
  PRIMARY KEY  (`infoid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `customer_link`
-- 

CREATE TABLE `customer_link` (
  `custid` int(11) NOT NULL,
  `linkid` int(11) NOT NULL auto_increment,
  `description` varchar(128) character set latin1 collate latin1_german2_ci NOT NULL,
  `url` varchar(1024) character set latin1 collate latin1_german2_ci default NULL,
  `sort` int(11) NOT NULL,
  `created` date NOT NULL,
  `tshow` int(11) NOT NULL default '0',
  PRIMARY KEY  (`linkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='keeps links to customer related documentation' AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `empfunc`
-- 

CREATE TABLE `empfunc` (
  `funcid` int(11) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL,
  `sort` int(11) NOT NULL,
  `created` date NOT NULL,
  `row` int(11) NOT NULL,
  `col` int(11) NOT NULL,
  PRIMARY KEY  (`funcid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `employee`
-- 

CREATE TABLE `employee` (
  `empid` int(11) NOT NULL auto_increment,
  `lastname` varchar(40) character set latin1 collate latin1_german2_ci NOT NULL,
  `firstname` varchar(40) character set latin1 collate latin1_german2_ci NOT NULL,
  `phone` varchar(40) character set latin1 collate latin1_german2_ci NOT NULL,
  `mobile` varchar(40) character set latin1 collate latin1_german2_ci NOT NULL,
  `picturepath` varchar(256) character set latin1 collate latin1_german2_ci NOT NULL,
  `funcid` int(11) NOT NULL,
  `email` varchar(128) NOT NULL,
  `subfuncid` int(11) NOT NULL,
  `mag` date NOT NULL,
  `asi` date NOT NULL,
  `wk` date NOT NULL,
  `titel` varchar(80) NOT NULL,
  `rank` int(11) NOT NULL,
  PRIMARY KEY  (`empid`),
  UNIQUE KEY `lastname` (`lastname`,`firstname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `feedback`
-- 

CREATE TABLE `feedback` (
  `feedid` int(11) NOT NULL auto_increment,
  `text` varchar(255) NOT NULL,
  `created` date NOT NULL,
  `hour` time NOT NULL,
  PRIMARY KEY  (`feedid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `hotlinks`
-- 

CREATE TABLE `hotlinks` (
  `hotid` int(11) NOT NULL auto_increment,
  `url` varchar(1024) NOT NULL,
  `description` varchar(128) NOT NULL,
  `sort` int(11) default '0',
  `created` date NOT NULL,
  PRIMARY KEY  (`hotid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `lgroup`
-- 

CREATE TABLE `lgroup` (
  `lgroupid` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `description` varchar(128) NOT NULL,
  `sort` int(11) NOT NULL,
  PRIMARY KEY  (`lgroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `mailbox`
-- 

CREATE TABLE `mailbox` (
  `id` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `whoid` int(2) NOT NULL default '0',
  `action` int(2) NOT NULL,
  `p1` varchar(32) NOT NULL,
  `p2` varchar(32) NOT NULL,
  `p3` varchar(32) NOT NULL,
  `p4` varchar(32) NOT NULL,
  `text` varchar(255) NOT NULL,
  `ipadr` char(25) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `neue tabelle`
-- 

CREATE TABLE `neue tabelle` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `p9id` int(10) unsigned NOT NULL,
  `location` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `newsticker`
-- 

CREATE TABLE `newsticker` (
  `newsid` int(11) NOT NULL auto_increment,
  `text` varchar(1024) NOT NULL,
  `url` varchar(1024) NOT NULL,
  `updated` date NOT NULL,
  PRIMARY KEY  (`newsid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `p9_airplane`
-- 

CREATE TABLE `p9_airplane` (
  `airid` int(11) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL,
  `aliases` varchar(255) NOT NULL,
  PRIMARY KEY  (`airid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED AUTO_INCREMENT=35 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `p9_checks`
-- 

CREATE TABLE `p9_checks` (
  `checkid` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY  (`checkid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `p9_checktype`
-- 

CREATE TABLE `p9_checktype` (
  `checkid` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  `custid` int(11) NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`checkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=95 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `p9_cuair`
-- 

CREATE TABLE `p9_cuair` (
  `custid` int(11) NOT NULL,
  `airid` int(11) NOT NULL,
  KEY `custid` (`custid`,`airid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='implement n:m Relation between customers and airplanes';

-- --------------------------------------------------------

-- 
-- Table structure for table `p9_cuairch`
-- 

CREATE TABLE `p9_cuairch` (
  `custid` int(11) NOT NULL,
  `airid` int(11) NOT NULL,
  `checkid` int(11) NOT NULL,
  `code` varchar(45) NOT NULL,
  `p9key` varchar(45) NOT NULL,
  PRIMARY KEY  (`custid`,`airid`,`checkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `p9_customer`
-- 

CREATE TABLE `p9_customer` (
  `custid` int(11) NOT NULL auto_increment,
  `name` varchar(40) collate latin1_german1_ci NOT NULL,
  `token` char(6) collate latin1_german1_ci default NULL,
  `pkorr` decimal(7,2) NOT NULL default '0.00',
  `p9sort` int(11) NOT NULL default '999999',
  `text` text collate latin1_german1_ci,
  `free` decimal(7,2) NOT NULL,
  `heat` int(1) NOT NULL default '0',
  PRIMARY KEY  (`custid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=22 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `p9_ipadr_allowed`
-- 

CREATE TABLE `p9_ipadr_allowed` (
  `id` int(11) NOT NULL auto_increment,
  `ipadr` varchar(16) NOT NULL default '',
  `who` varchar(45) NOT NULL default '',
  `master` int(1) NOT NULL default '0',
  `created` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ipadr` (`ipadr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `p9feedback`
-- 

CREATE TABLE `p9feedback` (
  `feedid` int(11) NOT NULL auto_increment,
  `text` varchar(255) NOT NULL,
  `created` date NOT NULL,
  `hour` time NOT NULL,
  PRIMARY KEY  (`feedid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `p9work_load_protocol`
-- 

CREATE TABLE `p9work_load_protocol` (
  `id` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `shift` int(1) NOT NULL,
  `text` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9`
-- 

CREATE TABLE `plan9` (
  `id` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `cu1` char(4) collate latin1_german1_ci NOT NULL,
  `gpu` char(4) collate latin1_german1_ci NOT NULL,
  `ac` char(5) collate latin1_german1_ci NOT NULL,
  `cu2` char(4) collate latin1_german1_ci NOT NULL,
  `STA` time NOT NULL,
  `fl_nr_arrive` int(4) NOT NULL,
  `registration` char(5) collate latin1_german1_ci NOT NULL,
  `fl_nr_depart` int(4) NOT NULL,
  `STD` time NOT NULL,
  `Hallinout` decimal(4,2) NOT NULL default '0.00',
  `T` decimal(4,2) NOT NULL default '0.00',
  `R` decimal(4,2) NOT NULL default '0.00',
  `S` decimal(4,2) NOT NULL default '0.00',
  `orders` varchar(255) collate latin1_german1_ci NOT NULL,
  `ohour` decimal(4,2) NOT NULL default '0.00',
  `tasks` varchar(255) collate latin1_german1_ci NOT NULL,
  `thour` decimal(4,2) NOT NULL default '0.00',
  `totalhour` decimal(4,2) NOT NULL default '0.00',
  `late` decimal(4,2) NOT NULL default '0.00',
  `night` decimal(4,2) NOT NULL default '0.00',
  `Name` varchar(40) collate latin1_german1_ci NOT NULL,
  `wash` decimal(4,2) NOT NULL default '0.00',
  `clean` decimal(4,2) NOT NULL default '0.00',
  `A` decimal(4,2) NOT NULL default '0.00',
  `status` int(1) NOT NULL default '0',
  `deice` int(1) NOT NULL default '0',
  `nightday` int(1) NOT NULL default '0',
  `aog` int(1) unsigned NOT NULL default '0',
  `delay` int(1) unsigned NOT NULL default '0',
  `closed` int(1) NOT NULL default '0' COMMENT '0=open 1=closed',
  `dayout` int(1) NOT NULL default '0' COMMENT '0=keep 1=out',
  `Tcode` int(3) NOT NULL default '0',
  `Rcode` int(3) NOT NULL default '0',
  `Scode` int(3) NOT NULL default '0',
  `Acode` int(3) NOT NULL default '0' COMMENT 'A check',
  `cleancode` int(3) NOT NULL default '0' COMMENT 'Clean',
  `washcode` int(3) NOT NULL default '0' COMMENT 'Wash',
  `Hallinoutcode` int(3) NOT NULL default '0' COMMENT 'Hall In Out',
  `p9sort` int(11) NOT NULL default '999999',
  `done` int(1) NOT NULL default '0',
  `plantype` int(1) NOT NULL default '0' COMMENT '0=regular plna 1=planned  for future',
  PRIMARY KEY  (`id`),
  KEY `datum` (`created`,`nightday`),
  KEY `regist` (`registration`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='main planing sheet for all shifts' AUTO_INCREMENT=6164 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_deice`
-- 

CREATE TABLE `plan9_deice` (
  `id` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `cu1` char(4) collate latin1_german1_ci NOT NULL,
  `gpu` char(4) collate latin1_german1_ci NOT NULL,
  `ac` char(5) collate latin1_german1_ci NOT NULL,
  `cu2` char(4) collate latin1_german1_ci NOT NULL,
  `STA` time NOT NULL,
  `fl_nr_arrive` int(4) unsigned NOT NULL,
  `registration` char(5) collate latin1_german1_ci NOT NULL,
  `fl_nr_depart` int(4) unsigned NOT NULL,
  `STD` time NOT NULL,
  `park` int(3) unsigned NOT NULL,
  `safewin` char(10) collate latin1_german1_ci NOT NULL,
  `mix` char(10) collate latin1_german1_ci NOT NULL,
  `hot` time NOT NULL,
  `2step` int(1) unsigned NOT NULL default '0',
  `remark` text collate latin1_german1_ci NOT NULL,
  `park2` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `datum` USING BTREE (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='data for deicing ' AUTO_INCREMENT=417 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_delay`
-- 

CREATE TABLE `plan9_delay` (
  `id` int(11) NOT NULL auto_increment,
  `idp9` int(11) NOT NULL COMMENT 'id from plan9',
  `created` date NOT NULL,
  `token` varchar(5) NOT NULL,
  `registration` char(6) NOT NULL,
  `ac` char(12) NOT NULL,
  `STA` time NOT NULL,
  `STD` time NOT NULL,
  `fdp` int(4) NOT NULL COMMENT 'flight number depart',
  `ATA` time NOT NULL,
  `ATA_Chapter` int(3) NOT NULL,
  `code` int(11) NOT NULL,
  `duration` int(2) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `action` text character set latin1 collate latin1_german2_ci NOT NULL,
  `url` text NOT NULL,
  `status` int(1) NOT NULL default '0' COMMENT '0=open 1=closed',
  `type` int(1) NOT NULL default '0' COMMENT '0=delay 1=AOG',
  `closed` date NOT NULL default '3000-01-01',
  `ended` date NOT NULL,
  `idp9ended` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='delayreport or AOG header data' AUTO_INCREMENT=43 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_delay_picture`
-- 

CREATE TABLE `plan9_delay_picture` (
  `id` int(11) NOT NULL auto_increment,
  `p9id` int(11) NOT NULL,
  `created` date NOT NULL,
  `location` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_handover`
-- 

CREATE TABLE `plan9_handover` (
  `id` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `cu1` char(4) collate latin1_german1_ci NOT NULL,
  `ac` char(5) collate latin1_german1_ci NOT NULL,
  `STA` time default NULL,
  `fl_nr_arrive` int(4) default NULL,
  `registration` char(5) collate latin1_german1_ci NOT NULL,
  `fl_nr_depart` int(4) NOT NULL,
  `STD` time NOT NULL,
  `service` char(10) collate latin1_german1_ci NOT NULL default 'WA',
  `heating` char(1) collate latin1_german1_ci NOT NULL,
  `oneh` char(1) collate latin1_german1_ci NOT NULL,
  `comment` varchar(255) collate latin1_german1_ci NOT NULL,
  `name1` char(60) collate latin1_german1_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `datum` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='main planing sheet for all shifts' AUTO_INCREMENT=734 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_highlight`
-- 

CREATE TABLE `plan9_highlight` (
  `id` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `shift` int(1) NOT NULL,
  `text` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_mail_flag`
-- 

CREATE TABLE `plan9_mail_flag` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `created` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_protocol`
-- 

CREATE TABLE `plan9_protocol` (
  `id` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `shift` int(1) NOT NULL COMMENT '0=night 1=day',
  `from1` varchar(32) NOT NULL COMMENT 'shift leader',
  `from2` varchar(32) NOT NULL COMMENT 'first worker',
  `to1` varchar(32) NOT NULL COMMENT 'shift leader',
  `to2` varchar(32) NOT NULL COMMENT 'first worker',
  `text` text NOT NULL COMMENT 'free text',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='holds journal for each shift' AUTO_INCREMENT=20 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_protocol_tasks`
-- 

CREATE TABLE `plan9_protocol_tasks` (
  `id` int(11) NOT NULL auto_increment,
  `idp` int(11) NOT NULL COMMENT 'id from plan9_protocol',
  `task` varchar(255) NOT NULL COMMENT 'free text',
  `status` int(1) NOT NULL default '0' COMMENT '0=open 1=done',
  `iscopy` int(1) NOT NULL default '0' COMMENT '0=original 1=iscopied',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='holds journal for each shift' AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_resource`
-- 

CREATE TABLE `plan9_resource` (
  `id` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `ma` int(3) NOT NULL default '0' COMMENT 'Number of employess ',
  `shift` int(1) NOT NULL default '0' COMMENT '1= frue 2=spaet 3=superspaet 4=nacht',
  `celsius` int(3) default NULL COMMENT 'outside tempreture in celsius',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `created` (`created`,`shift`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='resources available per shift' AUTO_INCREMENT=694 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_standard`
-- 

CREATE TABLE `plan9_standard` (
  `name` varchar(45) NOT NULL,
  `seq` int(1) NOT NULL default '0',
  `wotext` varchar(45) NOT NULL,
  `code` int(3) NOT NULL default '0',
  `hours` decimal(4,2) NOT NULL default '0.00',
  `id` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `u1` (`name`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_wo_cover`
-- 

CREATE TABLE `plan9_wo_cover` (
  `id` int(11) NOT NULL auto_increment,
  `p9id` int(11) NOT NULL default '0',
  `created` date NOT NULL default '0000-00-00',
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=115 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_wo_head`
-- 

CREATE TABLE `plan9_wo_head` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `p9id` int(10) unsigned NOT NULL COMMENT 'id from plan9 record',
  `created` date NOT NULL,
  `status` int(1) unsigned NOT NULL COMMENT '0=open 1=closed',
  `nightday` int(1) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `p9` (`p9id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=333 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_wo_sections`
-- 

CREATE TABLE `plan9_wo_sections` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `woid` int(10) unsigned NOT NULL COMMENT 'id from plan9_wo_head',
  `what` int(1) NOT NULL COMMENT '0=mainatin 1=non rout 2=equip 3=fluid 4=deice 5=material 6=towing 7=hangar 8=apron',
  `code` char(10) NOT NULL,
  `descrip` varchar(128) NOT NULL,
  `units` decimal(4,2) NOT NULL,
  `department` char(20) NOT NULL,
  `in` time NOT NULL,
  `out` time NOT NULL,
  `seq` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `woid` (`woid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Aircraft maintenance' AUTO_INCREMENT=2271 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `plan9_wo_sections_bde`
-- 

CREATE TABLE `plan9_wo_sections_bde` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `woid` int(10) unsigned NOT NULL COMMENT 'id from plan9_wo_head',
  `what` int(1) NOT NULL COMMENT '0=mainatin 1=non rout 2=equip 3=fluid 4=deice 5=material 6=towing 7=hangar 8=apron',
  `code` char(10) NOT NULL,
  `descrip` varchar(128) NOT NULL,
  `units` decimal(4,2) NOT NULL,
  `department` char(20) NOT NULL,
  `in` time NOT NULL,
  `out` time NOT NULL,
  `seq` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `woid` (`woid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Aircraft maintenance' AUTO_INCREMENT=2262 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `role`
-- 

CREATE TABLE `role` (
  `roleid` int(11) NOT NULL auto_increment,
  `name` varchar(40) character set latin1 collate latin1_german2_ci NOT NULL,
  `description` varchar(512) character set latin1 collate latin1_german2_ci NOT NULL,
  `seq` int(11) NOT NULL,
  PRIMARY KEY  (`roleid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `role_link`
-- 

CREATE TABLE `role_link` (
  `roleid` int(11) NOT NULL,
  `linkid` int(11) NOT NULL auto_increment,
  `description` varchar(128) character set latin1 collate latin1_german2_ci NOT NULL,
  `url` varchar(1024) character set latin1 collate latin1_german2_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `created` date NOT NULL,
  `lgroup` int(11) NOT NULL,
  PRIMARY KEY  (`linkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `seal`
-- 

CREATE TABLE `seal` (
  `sealid` int(10) unsigned NOT NULL auto_increment,
  `custid` int(10) unsigned NOT NULL,
  `start` int(10) unsigned NOT NULL,
  `count` int(10) unsigned NOT NULL,
  `maxout` int(10) unsigned NOT NULL,
  `warn` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `active` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`sealid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `seal_count`
-- 

CREATE TABLE `seal_count` (
  `sealid` int(10) unsigned default NULL,
  `custid` int(10) unsigned NOT NULL,
  `start` int(10) unsigned NOT NULL,
  `end` int(10) unsigned default NULL,
  `sealout` int(10) unsigned default NULL,
  `created` datetime NOT NULL,
  `active` int(10) unsigned NOT NULL,
  `checkid` int(11) NOT NULL,
  `registration` varchar(45) NOT NULL,
  `who` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `seal_order`
-- 

CREATE TABLE `seal_order` (
  `sealid` int(10) unsigned NOT NULL auto_increment,
  `custid` int(10) unsigned NOT NULL,
  `description` text NOT NULL,
  `email` varchar(128) NOT NULL,
  PRIMARY KEY  (`sealid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `strwadata`
-- 

CREATE TABLE `strwadata` (
  `strwaitem` int(11) NOT NULL,
  `strwadata` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `url` varchar(512) default NULL,
  `sort` int(11) default NULL,
  `created` date default NULL,
  `strwaindex` int(11) NOT NULL,
  PRIMARY KEY  (`strwadata`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `strwaindex`
-- 

CREATE TABLE `strwaindex` (
  `strwaitem` int(11) NOT NULL,
  `strwaindex` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `sort` int(11) default NULL,
  `created` date default NULL,
  PRIMARY KEY  (`strwaindex`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `strwaitem`
-- 

CREATE TABLE `strwaitem` (
  `strwaitem` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `sort` int(11) default NULL,
  `created` date default NULL,
  PRIMARY KEY  (`strwaitem`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `subfunc`
-- 

CREATE TABLE `subfunc` (
  `id` int(11) NOT NULL,
  `subfuncid` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL,
  `sort` int(11) NOT NULL,
  `created` date NOT NULL,
  `row` int(11) NOT NULL,
  `col` int(11) NOT NULL,
  PRIMARY KEY  (`subfuncid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `utilities`
-- 

CREATE TABLE `utilities` (
  `utid` int(11) NOT NULL auto_increment,
  `utnumber` varchar(20) collate latin1_german1_ci NOT NULL,
  `name` varchar(60) collate latin1_german1_ci default NULL,
  `description` varchar(255) collate latin1_german1_ci default NULL,
  `picturepath` varchar(255) collate latin1_german1_ci default NULL,
  `ata` int(11) NOT NULL,
  `state` int(11) NOT NULL,
  `first` datetime default NULL,
  `out` datetime default NULL,
  `in` datetime default NULL,
  `location` varchar(128) collate latin1_german1_ci NOT NULL,
  `count` int(11) NOT NULL,
  PRIMARY KEY  (`utid`),
  UNIQUE KEY `utnumber` (`utnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=26 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `utilities_info`
-- 

CREATE TABLE `utilities_info` (
  `utid` int(11) NOT NULL,
  `infoid` int(11) NOT NULL auto_increment,
  `created` date NOT NULL,
  `headline` varchar(128) character set latin1 collate latin1_german2_ci NOT NULL,
  `location` varchar(512) character set latin1 collate latin1_german2_ci NOT NULL,
  `enddate` date default NULL,
  `archived` tinyint(1) NOT NULL,
  `tshow` int(11) NOT NULL default '0',
  PRIMARY KEY  (`infoid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `utilities_link`
-- 

CREATE TABLE `utilities_link` (
  `utid` int(11) NOT NULL,
  `linkid` int(11) NOT NULL auto_increment,
  `description` varchar(128) character set latin1 collate latin1_german2_ci NOT NULL,
  `url` varchar(1024) character set latin1 collate latin1_german2_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `created` date NOT NULL,
  `tshow` int(11) NOT NULL,
  PRIMARY KEY  (`linkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `utilities_state`
-- 

CREATE TABLE `utilities_state` (
  `stateid` int(11) NOT NULL auto_increment,
  `name` varchar(40) collate latin1_german1_ci NOT NULL,
  PRIMARY KEY  (`stateid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `work`
-- 

CREATE TABLE `work` (
  `id` int(11) NOT NULL auto_increment,
  `datum` date NOT NULL,
  `ac` char(6) character set latin1 NOT NULL,
  `al0` char(7) collate latin1_german2_ci default 'YOYO',
  `al` char(3) character set latin1 NOT NULL,
  `sta` int(4) unsigned NOT NULL,
  `arrive` int(4) unsigned NOT NULL,
  `registration` char(6) character set latin1 NOT NULL,
  `depart` int(4) unsigned NOT NULL,
  `std` int(4) unsigned NOT NULL,
  `hour` decimal(5,2) NOT NULL,
  `code` int(4) unsigned NOT NULL,
  `text` text character set latin1 NOT NULL,
  `nightday` int(1) NOT NULL default '0',
  `c1` decimal(7,2) default '0.00',
  `c2` decimal(7,2) default '0.00',
  `name` varchar(45) collate latin1_german2_ci NOT NULL,
  `zt` decimal(7,2) NOT NULL default '0.00',
  `zi` decimal(7,2) NOT NULL default '0.00',
  `ze` decimal(7,2) NOT NULL default '0.00',
  `units` decimal(4,2) NOT NULL default '0.00',
  PRIMARY KEY  (`id`),
  KEY `master` (`al0`),
  KEY `da_master` USING BTREE (`datum`,`al0`),
  KEY `master_da` (`al0`,`datum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=18188 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `work_other`
-- 

CREATE TABLE `work_other` (
  `id` int(11) NOT NULL auto_increment,
  `code` int(11) NOT NULL,
  `text` varchar(45) collate latin1_german1_ci NOT NULL,
  `hour` decimal(7,2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=101 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `work_protocol`
-- 

CREATE TABLE `work_protocol` (
  `id` int(11) NOT NULL auto_increment,
  `datum` date NOT NULL default '0000-00-00',
  `what` text collate latin1_german1_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `work_resource`
-- 

CREATE TABLE `work_resource` (
  `id` int(11) NOT NULL auto_increment,
  `datum` date NOT NULL default '0000-00-00',
  `ma` int(11) NOT NULL default '0',
  `hour` decimal(7,2) NOT NULL default '0.00',
  `shift` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=98 ;