This data as json, CSV (advanced)
| id | name |
|---|---|
| 1 | text/html; charset=utf-8 |
| 2 | text/css |
| 3 | text/plain |
| 4 | application/javascript |
| 5 | application/json; charset=utf-8 |
| 6 | text/plain; charset=utf-8 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE [content_types] (
[id] INTEGER PRIMARY KEY,
[name] TEXT
);
CREATE UNIQUE INDEX idx_content_types_name
ON content_types (name);