ToastFreeware
/
debian
/
confclerk.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
c13a488
)
Add comment for day_change field in conference table definition.
author
Philipp Spitzer
<philipp@spitzer.priv.at>
Wed, 21 Jul 2021 18:16:12 +0000
(20:16 +0200)
committer
Philipp Spitzer
<philipp@spitzer.priv.at>
Wed, 21 Jul 2021 18:16:12 +0000
(20:16 +0200)
src/dbschema002.sql
patch
|
blob
|
history
diff --git
a/src/dbschema002.sql
b/src/dbschema002.sql
index c0a3d17f7a7a8851494cfde9f91c5a7f0f0c84b1..d933761604cf0307f793395edbb9798c1a9867ef 100644
(file)
--- a/
src/dbschema002.sql
+++ b/
src/dbschema002.sql
@@
-8,7
+8,7
@@
CREATE TABLE conference (
city VARCHAR,
start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
end INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
- day_change INTEGER,
+ day_change INTEGER,
-- in seconds after midnight
timeslot_duration INTEGER,
utc_offset INTEGER DEFAULT NULL, -- if known, conference UTC offset in seconds (e.g. CET = +3600)
display_time_shift INTEGER DEFAULT NULL, -- if not null, add number in seconds to conference times when showing times