2016-08-17 12:55:35 +00:00
|
|
|
drop table if exists users;
|
|
|
|
create table users (
|
|
|
|
id integer primary key autoincrement,
|
2016-09-06 00:09:45 +00:00
|
|
|
email text not null,
|
|
|
|
name text not null,
|
2016-08-17 12:55:35 +00:00
|
|
|
password text not null,
|
2016-09-06 00:09:45 +00:00
|
|
|
uuid text not null,
|
|
|
|
phone text,
|
|
|
|
room text,
|
|
|
|
your_products text not null,
|
|
|
|
verified integer not null
|
|
|
|
);
|
|
|
|
|
|
|
|
drop table if exists products;
|
|
|
|
create table products (
|
|
|
|
id integer primary key autoincrement,
|
|
|
|
name text not null,
|
|
|
|
picture text not null,
|
|
|
|
description text not null,
|
2017-01-12 01:35:54 +00:00
|
|
|
date int not null,
|
|
|
|
price real not null,
|
2016-09-06 00:09:45 +00:00
|
|
|
seller text not null,
|
|
|
|
interested_people text not null,
|
2016-08-17 12:55:35 +00:00
|
|
|
uuid text not null
|
2017-01-12 01:35:54 +00:00
|
|
|
);
|