Skip to content

Instantly share code, notes, and snippets.

@munroebot

munroebot/shopidentifyer.event_log.sql

Last active August 29, 2015 14:10
Show Gist options
  • Save munroebot/dc299431ec32b669f45c to your computer and use it in GitHub Desktop.
Save munroebot/dc299431ec32b669f45c to your computer and use it in GitHub Desktop.
Download ZIP
SQL Help
Raw
shopidentifyer.event_log.sql
create table shopidentifyer.event_log (
event_id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
badge_id int NOT NULL,
created_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
event_type ENUM('BADGE_SWIPE','MANUAL_SWIPE','ACCESS_ATTEMPT','ACCESS_GRANT','ACCESS_DENY') DEFAULT 'BADGE_SWIPE',
event_message varchar(255)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment