| OLD | NEW |
| 1 Design | 1 Design |
| 2 ====== | 2 ====== |
| 3 | 3 |
| 4 | 4 |
| 5 Overview | 5 Overview |
| 6 -------- | 6 -------- |
| 7 Allows trying out Skia code in the browser. | 7 Allows trying out Skia code in the browser. |
| 8 | 8 |
| 9 | 9 |
| 10 Security | 10 Security |
| (...skipping 116 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 127 | 127 |
| 128 To connect to the database from the skia-webtry-b server: | 128 To connect to the database from the skia-webtry-b server: |
| 129 | 129 |
| 130 $ mysql --host=173.194.83.52 --user=root --password | 130 $ mysql --host=173.194.83.52 --user=root --password |
| 131 | 131 |
| 132 Initial setup of the database, the user, and the only table: | 132 Initial setup of the database, the user, and the only table: |
| 133 | 133 |
| 134 CREATE DATABASE webtry; | 134 CREATE DATABASE webtry; |
| 135 USE webtry; | 135 USE webtry; |
| 136 CREATE USER 'webtry'@'%' IDENTIFIED BY '<password is in valentine>'; | 136 CREATE USER 'webtry'@'%' IDENTIFIED BY '<password is in valentine>'; |
| 137 GRANT SELECT, INSERT, UPDATE ON webtry.webtry TO 'webtry'@'%'; | 137 GRANT SELECT, INSERT, UPDATE ON webtry.webtry TO 'webtry'@'%'; |
| 138 GRANT SELECT, INSERT, UPDATE ON webtry.workspace TO 'webtry'@'%'; |
| 139 GRANT SELECT, INSERT, UPDATE ON webtry.workspacetry TO 'webtry'@'%'; |
| 138 | 140 |
| 139 // If this gets changed also update the sqlite create statement in webtry.go
. | 141 // If this gets changed also update the sqlite create statement in webtry.go
. |
| 140 | 142 |
| 141 CREATE TABLE webtry ( | 143 CREATE TABLE webtry ( |
| 142 code TEXT DEFAULT '' NOT NULL, | 144 code TEXT DEFAULT '' NOT NULL, |
| 143 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, | 145 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, |
| 144 hash CHAR(64) DEFAULT '' NOT NULL, | 146 hash CHAR(64) DEFAULT '' NOT NULL, |
| 145 PRIMARY KEY(hash) | 147 PRIMARY KEY(hash) |
| 146 ); | 148 ); |
| 147 | 149 |
| (...skipping 59 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 207 Workspaces are implemented by the workspace and workspacetry tables. The | 209 Workspaces are implemented by the workspace and workspacetry tables. The |
| 208 workspace table keeps the unique list of all workspaces. The workspacetry table | 210 workspace table keeps the unique list of all workspaces. The workspacetry table |
| 209 keeps track of all the tries that have occured in a workspace. Right now the | 211 keeps track of all the tries that have occured in a workspace. Right now the |
| 210 hidden column of workspacetry is not used, it's for future functionality. | 212 hidden column of workspacetry is not used, it's for future functionality. |
| 211 | 213 |
| 212 Installation | 214 Installation |
| 213 ------------ | 215 ------------ |
| 214 See the README file. | 216 See the README file. |
| 215 | 217 |
| 216 | 218 |
| OLD | NEW |