Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(1466)

Side by Side Diff: experimental/webtry/DESIGN.md

Issue 243013005: Update DESIGN, forgot to add new perms for the new tables. (Closed) Base URL: https://skia.googlesource.com/skia.git@master
Patch Set: Created 6 years, 8 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
« no previous file with comments | « no previous file | no next file » | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
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
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
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
OLDNEW
« no previous file with comments | « no previous file | no next file » | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698