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 |