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 126 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
137 GRANT SELECT, INSERT, UPDATE ON webtry.workspace TO 'webtry'@'%'; | 137 GRANT SELECT, INSERT, UPDATE ON webtry.workspace TO 'webtry'@'%'; |
138 GRANT SELECT, INSERT, UPDATE ON webtry.workspacetry TO 'webtry'@'%'; | 138 GRANT SELECT, INSERT, UPDATE ON webtry.workspacetry TO 'webtry'@'%'; |
139 GRANT SELECT, INSERT, UPDATE ON webtry.source_images TO 'webtry'@'%'; | 139 GRANT SELECT, INSERT, UPDATE ON webtry.source_images TO 'webtry'@'%'; |
140 | 140 |
141 // 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
. |
142 | 142 |
143 CREATE TABLE webtry ( | 143 CREATE TABLE webtry ( |
144 code TEXT DEFAULT '' NOT NULL, | 144 code TEXT DEFAULT '' NOT NULL, |
145 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, | 145 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, |
146 hash CHAR(64) DEFAULT '' NOT NULL, | 146 hash CHAR(64) DEFAULT '' NOT NULL, |
| 147 width INTEGER DEFAULT 256 NOT NULL, |
| 148 height INTEGER DEFAULT 256 NOT NULL, |
147 source_image_id INTEGER DEFAULT 0 NOT NULL, | 149 source_image_id INTEGER DEFAULT 0 NOT NULL, |
148 PRIMARY KEY(hash), | 150 PRIMARY KEY(hash), |
149 | 151 |
150 FOREIGN KEY (source) REFERENCES sources(id) | 152 FOREIGN KEY (source) REFERENCES sources(id) |
151 ); | 153 ); |
152 | 154 |
153 CREATE TABLE workspace ( | 155 CREATE TABLE workspace ( |
154 name CHAR(64) DEFAULT '' NOT NULL, | 156 name CHAR(64) DEFAULT '' NOT NULL, |
155 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, | 157 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, |
156 PRIMARY KEY(name), | 158 PRIMARY KEY(name), |
157 ); | 159 ); |
158 | 160 |
159 CREATE TABLE workspacetry ( | 161 CREATE TABLE workspacetry ( |
160 name CHAR(64) DEFAULT '' NOT NULL, | 162 name CHAR(64) DEFAULT '' NOT NULL, |
161 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, | 163 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, |
162 hash CHAR(64) DEFAULT '' NOT NULL, | 164 hash CHAR(64) DEFAULT '' NOT NULL, |
| 165 width INTEGER DEFAULT 256 NOT NULL, |
| 166 height INTEGER DEFAULT 256 NOT NULL, |
163 source_image_id INTEGER DEFAULT 0 NOT NULL, | 167 source_image_id INTEGER DEFAULT 0 NOT NULL, |
164 hidden INTEGER DEFAULT 0 NOT NULL, | 168 hidden INTEGER DEFAULT 0 NOT NULL, |
165 | 169 |
166 FOREIGN KEY (name) REFERENCES workspace(name), | 170 FOREIGN KEY (name) REFERENCES workspace(name), |
167 ); | 171 ); |
168 | 172 |
169 CREATE TABLE source_images ( | 173 CREATE TABLE source_images ( |
170 id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, | 174 id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, |
171 image MEDIUMBLOB DEFAULT '' NOT NULL, -- Stored as PN
G. | 175 image MEDIUMBLOB DEFAULT '' NOT NULL, -- Stored as PN
G. |
172 width INTEGER DEFAULT 0 NOT NULL, | 176 width INTEGER DEFAULT 0 NOT NULL, |
(...skipping 100 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
273 * clike.js - C-like syntax highlighting support | 277 * clike.js - C-like syntax highlighting support |
274 | 278 |
275 Alternatively, we may consider pulling CM as an external dependency at some | 279 Alternatively, we may consider pulling CM as an external dependency at some |
276 point. | 280 point. |
277 | 281 |
278 Installation | 282 Installation |
279 ------------ | 283 ------------ |
280 See the README file. | 284 See the README file. |
281 | 285 |
282 | 286 |
OLD | NEW |