diff options
Diffstat (limited to 'experimental/webtry/DESIGN.md')
| -rw-r--r-- | experimental/webtry/DESIGN.md | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/experimental/webtry/DESIGN.md b/experimental/webtry/DESIGN.md index 349a10e495..0c4f3a1b87 100644 --- a/experimental/webtry/DESIGN.md +++ b/experimental/webtry/DESIGN.md @@ -138,6 +138,8 @@ Initial setup of the database, the user, and the only table: CREATE USER 'webtry'@'%' IDENTIFIED BY '<password is in valentine>'; GRANT SELECT, INSERT, UPDATE ON webtry.webtry TO 'webtry'@'%'; + // If this gets changed also update the sqlite create statement in webtry.go. + CREATE TABLE webtry ( code TEXT DEFAULT '' NOT NULL, create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, |