/*
Navicat MariaDB Data Transfer

Source Server         : test-maindb01
Source Server Version : 100017
Source Host           : 192.168.243.25:3306
Source Database       : d1

Target Server Type    : MariaDB
Target Server Version : 100017
File Encoding         : 65001

Date: 2015-05-06 10:49:24
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for userhitory
-- ----------------------------
DROP TABLE IF EXISTS `userhitory`;
CREATE TABLE `userhitory` (
  `user` int(11) NOT NULL,
  `datum` date NOT NULL,
  `ereignis` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of userhitory
-- ----------------------------
INSERT INTO `userhitory` VALUES ('1', '2007-02-13', 'Eintritt Maßnahme');
INSERT INTO `userhitory` VALUES ('1', '2007-03-13', 'Eintritt');
INSERT INTO `userhitory` VALUES ('2', '2007-04-04', 'Eintritt Maßnahme');
INSERT INTO `userhitory` VALUES ('2', '2007-05-02', 'Eintritt');
INSERT INTO `userhitory` VALUES ('2', '2008-01-31', 'Kündigung am');
INSERT INTO `userhitory` VALUES ('2', '2008-02-29', 'Austritt');
INSERT INTO `userhitory` VALUES ('1', '2013-07-10', 'Kündigung');
INSERT INTO `userhitory` VALUES ('1', '2013-08-15', 'Austritt');
INSERT INTO `userhitory` VALUES ('3', '2014-07-01', 'Eintritt Maßnahme');
INSERT INTO `userhitory` VALUES ('3', '2014-07-15', 'Eintritt');
INSERT INTO `userhitory` VALUES ('4', '2014-08-27', 'Eintritt Maßnahme');
INSERT INTO `userhitory` VALUES ('4', '2014-09-10', 'Eintritt');
INSERT INTO `userhitory` VALUES ('3', '2015-01-29', 'Austritt');
INSERT INTO `userhitory` VALUES ('4', '2015-02-10', 'Kündigung');
INSERT INTO `userhitory` VALUES ('4', '2015-02-26', 'Austritt');
