JodelExtract/schema.sql at master · mrestorff/JodelExtract · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
drop table if exists posts;
create table posts (
  id integer,
  post_id text not null primary key,
  color text not null,
  created_at text not null,
  distance integer,
  location text not null,
  message text,
  image_url text,
  image_headers text,
  pin_count integer,
  post_own text not null,
  updated_at text not null,
  user_handle text not null,
  vote_count integer
);

drop table if exists comments;
create table comments (
  id integer,
  main_post_id text not null primary key,
  post_id text not null,
  color text not null,
  created_at text not null,
  distance integer,
  location text not null,
  message text,
  image_url text,
  image_headers text,
  pin_count integer,
  post_own text not null,
  updated_at text not null,
  user_handle text not null,
  vote_count integer
);