Skip to content

Instantly share code, notes, and snippets.

@munroebot
Created April 21, 2016 18:01
Show Gist options
  • Save munroebot/7cc8b11c99a624b25f831f3e6f8e6987 to your computer and use it in GitHub Desktop.
Save munroebot/7cc8b11c99a624b25f831f3e6f8e6987 to your computer and use it in GitHub Desktop.
Teh SQL
create table shopidentifyer.badges (
badge_serial varchar (255) unique,
stripe_id varchar(255),
badge_status ENUM('ACTIVE','INACTIVE','LOST','BROKEN') DEFAULT 'ACTIVE',
created_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
changed_on TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment