CREATE TABLE `group` (
  `id` INT(12) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) DEFAULT NULL,
  `enabled` INT(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO `group` VALUES ('1', 'Player', '1');
INSERT INTO `group` VALUES ('2', 'Owner', '1');

DROP TABLE IF EXISTS `group_right`;
CREATE TABLE `group_right` (
  `id` INT(12) NOT NULL AUTO_INCREMENT,
  `group_id` INT(12) DEFAULT NULL,
  `right_id` INT(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `group_right` VALUES ('1', '1', '1');
INSERT INTO `group_right` VALUES ('2', '1', '2');
INSERT INTO `group_right` VALUES ('3', '2', '3');

CREATE TABLE `right` (
  `id` INT(12) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(250) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO `right` VALUES ('1', 'command.deagle', 'Command: /deagle');
INSERT INTO `right` VALUES ('2', 'command.deagle2', 'Command: /deagle2');
INSERT INTO `right` VALUES ('3', 'command.gmx', 'Command: /gmx');
INSERT INTO `right` VALUES ('4', 'command.givegun', 'Command: /givegun');

CREATE TABLE `user` (
  `id` INT(12) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(25) DEFAULT NULL,
  `password` VARCHAR(40) DEFAULT NULL,
  `email` VARCHAR(200) DEFAULT NULL,
  `activated` INT(1) DEFAULT NULL,
  `locked` INT(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `user` VALUES ('1', 'Dominik', 'sha1 hash', 'email', '1', '1');

CREATE TABLE `user_group` (
  `id` INT(12) NOT NULL AUTO_INCREMENT,
  `user_id` INT(12) DEFAULT NULL,
  `group_id` INT(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO `user_group` VALUES ('1', '1', '1');
INSERT INTO `user_group` VALUES ('2', '1', '2');

CREATE TABLE `user_right` (
  `id` INT(12) NOT NULL AUTO_INCREMENT,
  `user_id` INT(12) DEFAULT NULL,
  `right_id` INT(12) DEFAULT NULL,
  `mode` INT(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO `user_right` VALUES ('1', '1', '4', '1');
INSERT INTO `user_right` VALUES ('2', '1', '2', '0');