str0kem_db.sql 456 B

123456789101112
  1. CREATE DATABASE IF NOT EXISTS `str0kem` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  2. USE `str0kem`;
  3. CREATE TABLE IF NOT EXISTS `keymouse` (
  4. `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  5. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  6. `keypress` int(11) NOT NULL,
  7. `leftmouse` int(11) NOT NULL,
  8. `rightmouse` int(11) NOT NULL
  9. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  10. ALTER TABLE `keymouse` ADD KEY `date` (`date`);