#__matukio_bookings

CREATE TABLE IF NOT EXISTS `#__matukio_bookings` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `sid` int(11) NOT NULL DEFAULT '0',
  `semid` int(11) NOT NULL DEFAULT '1',
  `userid` int(11) NOT NULL DEFAULT '1',
  `certificated` tinyint(1) NOT NULL DEFAULT '0',
  `bookingdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `grade` tinyint(1) NOT NULL DEFAULT '0',
  `comment` varchar(200) NOT NULL DEFAULT '',
  `paid` tinyint(1) NOT NULL DEFAULT '0',
  `nrbooked` int(11) NOT NULL DEFAULT '1',
  `zusatz1` text NOT NULL,
  `zusatz2` text NOT NULL,
  `zusatz3` text NOT NULL,
  `zusatz4` text NOT NULL,
  `zusatz5` text NOT NULL,
  `zusatz6` text NOT NULL,
  `zusatz7` text NOT NULL,
  `zusatz8` text NOT NULL,
  `zusatz9` text NOT NULL,
  `zusatz10` text NOT NULL,
  `zusatz11` text NOT NULL,
  `zusatz12` text NOT NULL,
  `zusatz13` text NOT NULL,
  `zusatz14` text NOT NULL,
  `zusatz15` text NOT NULL,
  `zusatz16` text NOT NULL,
  `zusatz17` text NOT NULL,
  `zusatz18` text NOT NULL,
  `zusatz19` text NOT NULL,
  `zusatz20` text NOT NULL,
  `newfields` text,
  `uuid` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT 'cash',
  `payment_number` varchar(255) DEFAULT NULL,
  `payment_netto` float(11,2) DEFAULT '0.00',
  `payment_tax` float(11,2) DEFAULT '0.00',
  `payment_brutto` float(11,2) DEFAULT '0.00',
  `coupon_code` varchar(255) DEFAULT NULL,
  `checked_in` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)  COMMENT='Bookings';