diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 32 |
1 files changed, 16 insertions, 16 deletions
@@ -1,28 +1,28 @@ drop table if exists users; create table users ( id integer primary key autoincrement, - user_name string not null, - password string not null, + user_name text not null, + password text not null, last_seen timestamp default CURRENT_TIMESTAMP, - birthday string, - nameday string, + birthday text, + nameday text, notify boolean default 1, - email string, - phone string, - address_line1, - address_line2, - address_city_line, - timezone string, - kado string + email text, + phone text, + address_line1 text, + address_line2 text, + address_city_line text, + timezone text, + kado text ); drop table if exists news; create table news ( id integer primary key autoincrement, - title string not null, + title text not null, date timestamp default CURRENT_TIMESTAMP, - content string not null, - content_cache string not null, + content text not null, + content_cache text not null, user_id integer, FOREIGN KEY(user_id) REFERENCES users(id) ); @@ -31,8 +31,8 @@ drop table if exists comments; create table comments ( id integer primary key autoincrement, date timestamp default CURRENT_TIMESTAMP, - content string, - content_cache string not null, + content text, + content_cache text not null, user_id integer, news_id integer, FOREIGN KEY(user_id) REFERENCES users(id), |
