Created
May 30, 2020 12:11
-
-
Save sarful/ac24554b9e07e4d06c05c23c3f71d222 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table attendance( | |
id INT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, | |
user_id INT UNSIGNED NOT NULL, | |
clock_in TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
PRIMARY KEY ( id ) | |
); | |
create table users( | |
id INT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, | |
rfid_uid VARCHAR(255) NOT NULL, | |
name VARCHAR(255) NOT NULL, | |
created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
PRIMARY KEY ( id ) | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment