more changes to file_id copied from mysql schema change in 05e51228020fecaa894523b5159bc412d48e5b19

1 files changed, 2 insertions, 4 deletions

diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index de4fab03e..1059da3c9 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -488,8 +488,7 @@ create table file_redirection (
 

 create sequence file_thumbnail_seq;

 create table file_thumbnail (

-    id bigint default nextval('file_thumbnail_seq') primary key /* comment 'unique identifier' */,

-    file_id bigint unique, 

+    file_id bigint primary key, 

     url varchar(255) unique, 

     width integer, 

     height integer 

@@ -497,11 +496,10 @@ create table file_thumbnail (
 

 create sequence file_to_post_seq;

 create table file_to_post (

-    id bigint default nextval('file_to_post_seq') primary key /* comment 'unique identifier' */,

     file_id bigint, 

     post_id bigint, 

 

-    unique(file_id, post_id)

+    primary key (file_id, post_id)

 );

 

 create table group_block (