summaryrefslogtreecommitdiff
path: root/sql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql.sql')
-rw-r--r--sql.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql.sql b/sql.sql
new file mode 100644
index 0000000..3a5d8da
--- /dev/null
+++ b/sql.sql
@@ -0,0 +1,3 @@
+create table story( id int primary key auto_increment, story_id int not null unique, created_at timestamp, updated_at timestamp, type varchar(255) not null, title varchar(255) not null, text text, score int not null, descendants int not null, time int not null, poster varchar(255) not null);
+
+create table links (id int primary key auto_increment, created_at timestamp, updated_at timestamp, story_id int not null, url varchar(255) not null, field int not null, foreign key(story_id) references story(id));