· 6 years ago · Sep 18, 2019, 07:10 AM
1DROP TABLE IF EXISTS smartphones;
2CREATE TABLE IF NOT EXISTS smartphones (
3 id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
4 os TEXT,
5 chip TEXT,
6 wlan TEXT,
7 bluetooth TEXT,
8 resolution INTEGER,
9 formatId INTEGER,
10 price NUMERIC
11);
12DROP TABLE IF EXISTS comments;
13CREATE TABLE IF NOT EXISTS comments (
14 id INTEGER,
15 commenterId INTEGER,
16 comment INTEGER,
17 createdAt NUMERIC
18);
19DROP TABLE IF EXISTS users;
20CREATE TABLE IF NOT EXISTS users (
21 id INTEGER,
22 name TEXT
23);
24DROP TABLE IF EXISTS reports;
25CREATE TABLE IF NOT EXISTS reports (
26 smartphoneId INTEGER,
27 id INTEGER,
28 reporterId INTEGER,
29 topic INTEGER,
30 report INTEGER,
31 rating NUMERIC
32);
33DROP TABLE IF EXISTS formats;
34CREATE TABLE IF NOT EXISTS formats (
35 smartphoneId INTEGER,
36 width NUMERIC,
37 height NUMERIC,
38 length NUMERIC
39);