diff options
| author | Jeffrey Armstrong <jeff@approximatrix.com> | 2021-06-22 17:04:59 -0400 |
|---|---|---|
| committer | Jeffrey Armstrong <jeff@approximatrix.com> | 2021-06-22 17:04:59 -0400 |
| commit | d6f9ce81e4fd27c94cf656699ef4952956dff608 (patch) | |
| tree | e3d3abab4b22b271b0886dc49830691f9f3f4c3e /captain/sql | |
| parent | 660235928d1dd57d85cb7bd986c5036783a6073f (diff) | |
| download | levitating-d6f9ce81e4fd27c94cf656699ef4952956dff608.tar.gz levitating-d6f9ce81e4fd27c94cf656699ef4952956dff608.zip | |
Added new database table for tracking last player checkin with requisite Fortran procedures.
Diffstat (limited to 'captain/sql')
| -rw-r--r-- | captain/sql/create.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/captain/sql/create.sql b/captain/sql/create.sql index 6457296..e4a944c 100644 --- a/captain/sql/create.sql +++ b/captain/sql/create.sql @@ -12,3 +12,5 @@ CREATE TABLE available(instruction INTEGER, player INTEGER, FOREIGN KEY(instruct CREATE TABLE groups(id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL); CREATE TABLE group_instructions(group_id INTEGER, instruction INTEGER, player INTEGER, FOREIGN KEY(group_id) REFERENCES groups(id) ON DELETE CASCADE, FOREIGN KEY(instruction) REFERENCES instructions(id) ON DELETE CASCADE, FOREIGN KEY(player) REFERENCES players(id) ON DELETE CASCADE); + +CREATE TABLE checkin(player INTEGER PRIMARY KEY, year INTEGER, month INTEGER, day INTEGER, hour INTEGER, minute INTEGER, second INTEGER, os TEXT DEFAULT NULL, FOREIGN KEY(player) REFERENCES players(id) ON DELETE CASCADE); |