Door System/doorsys.sql

aus Metalab, dem offenen Zentrum für meta-disziplinäre Magier und technisch-kreative Enthusiasten.
Wechseln zu: Navigation, Suche

CREATE TABLE `door_acl` (
  `username` varchar(180) NOT NULL,
  `permission` varchar(60) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `door_acl` (`username`, `permission`) VALUES
('naxx', '0'),
('lieferant_mate', '1'),
('lost_key', '2');
CREATE TABLE `door_expires` (
  `username` varchar(180) NOT NULL,
  `dead` varchar(60) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `door_expires` (`username`, `dead`) VALUES
('lieferant_mate', 'TRUE');
CREATE TABLE `door_timeline` (
  `id` int(60) NOT NULL auto_increment,
  `who` varchar(60) NOT NULL,
  `action` varchar(180) NOT NULL,
  `timestamp` varchar(180) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
INSERT INTO `door_timeline` (`id`, `who`, `action`, `timestamp`) VALUES
(1, 'lieferant_mate', 'unlock_once', '1208214632'),
(2, 'naxx', 'unlock', '1208214638'),
(3, 'token0', 'fail', '1208214646'),
(4, 'lieferant_mate', 'unlock_once', '1208214710'),
(5, 'lieferant_mate', 'unlock_once', '1208215130'),
(6, 'lieferant_mate', 'fail_once', '1208215131'),
(7, 'lieferant_mate', 'unlock_once', '1208215421'),
(8, 'lieferant_mate', 'fail_once', '1208215424'),
(9, 'lieferant_mate', 'fail_once', '1208223185'),
(10, 'naxx', 'unlock', '1208375040'),
(11, 'token008', 'fail', '1208375061');
CREATE TABLE `door_users` (
  `username` varchar(180) NOT NULL,
  `token` varchar(180) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `door_users` (`username`, `token`) VALUES
('naxx', 'token00'),
('lieferant_mate', 'token01'),
('lost_key', 'token02');