| 1 |
lars |
1 |
CREATE TABLE article (id INTEGER PRIMARY KEY AUTOINCREMENT, author_id INTEGER, is_on_homepage INTEGER, views INTEGER, type VARCHAR(255), created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL);
|
|
|
2 |
CREATE TABLE attachment (id INTEGER PRIMARY KEY AUTOINCREMENT, file_path VARCHAR(255));
|
|
|
3 |
CREATE TABLE author (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255), type VARCHAR(255));
|
|
|
4 |
CREATE TABLE author_inheritance_concrete (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255), type VARCHAR(255), additional VARCHAR(255));
|
|
|
5 |
CREATE TABLE camel_case (id INTEGER PRIMARY KEY AUTOINCREMENT, article_id INTEGER, testcamelcase VARCHAR(255));
|
|
|
6 |
CREATE TABLE default_value_test (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255) DEFAULT '' NOT NULL);
|
|
|
7 |
CREATE TABLE form_generator_test (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255));
|
|
|
8 |
CREATE TABLE form_generator_test2 (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255));
|
|
|
9 |
CREATE TABLE form_generator_test3 (id INTEGER PRIMARY KEY AUTOINCREMENT);
|
|
|
10 |
CREATE TABLE groups (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255));
|
|
|
11 |
CREATE TABLE group_permission (group_id INTEGER, permission_id INTEGER, PRIMARY KEY(group_id, permission_id));
|
|
|
12 |
CREATE TABLE model_from_linked_schema (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255));
|
|
|
13 |
CREATE TABLE model_with_number_in_column (id INTEGER PRIMARY KEY AUTOINCREMENT, column_1 VARCHAR(255), column2 VARCHAR(255), column__3 VARCHAR(255));
|
|
|
14 |
CREATE TABLE permission (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255));
|
|
|
15 |
CREATE TABLE profile (id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER, first_name VARCHAR(255), last_name VARCHAR(255));
|
|
|
16 |
CREATE TABLE resource_type (id VARCHAR(255), name VARCHAR(255), PRIMARY KEY(id));
|
|
|
17 |
CREATE TABLE setting (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255) NOT NULL, value TEXT, weight DOUBLE, created_at DATETIME NOT NULL);
|
|
|
18 |
CREATE TABLE unique_test (id INTEGER PRIMARY KEY AUTOINCREMENT, unique_test1 VARCHAR(255) UNIQUE, unique_test2 VARCHAR(255), unique_test3 VARCHAR(255), unique_test4 VARCHAR(255));
|
|
|
19 |
CREATE TABLE user (id INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(255) UNIQUE, password VARCHAR(255), test VARCHAR(255));
|
|
|
20 |
CREATE TABLE user_group (user_id INTEGER, group_id INTEGER, PRIMARY KEY(user_id, group_id));
|
|
|
21 |
CREATE TABLE user_permission (user_id INTEGER, permission_id INTEGER, PRIMARY KEY(user_id, permission_id));
|
|
|
22 |
CREATE INDEX article_type_idx ON article (type);
|
|
|
23 |
CREATE INDEX author_type_idx ON author (type);
|
|
|
24 |
CREATE INDEX author_type_idx ON author_inheritance_concrete (type);
|
|
|
25 |
CREATE UNIQUE INDEX unique_test_idx ON unique_test (unique_test1, unique_test2);
|
|
|
26 |
CREATE UNIQUE INDEX unique_test2_idx ON unique_test (unique_test4 ASC);
|
|
|
27 |
CREATE TABLE subscription (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255), status VARCHAR(255));
|