From 6b091dc7ab2c4fdaed0675ab57ea05e4ddb81e5b Mon Sep 17 00:00:00 2001 From: admin Date: Wed, 11 Sep 2024 11:02:32 +0200 Subject: init --- sql.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql.sql (limited to 'sql.sql') 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)); -- cgit v1.2.3