Door System/doorsys.sql

aus Metalab Wiki, dem offenen Zentrum für meta-disziplinäre Magier und technisch-kreative Enthusiasten.
Version vom 18. April 2008, 17:05 Uhr von Naxx (Diskussion | Beiträge) (Die Seite wurde neu angelegt: <pre> CREATE TABLE `door_acl` ( `username` varchar(180) NOT NULL, `permission` varchar(60) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `door_acl` ...)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Zur Navigation springenZur Suche springen

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');