summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2009-07-22 21:39:53 +1200
committerBrenda Wallace <shiny@cpan.org>2009-07-22 21:39:53 +1200
commit57f53869e20a61cb8adfdbe5e607bb07c9ea685f (patch)
treeef838a46c8472d171d3df3ced0f21fb11f251ab8
parent91f3ddca55ae3ea32aeeb75c797e6c81bb9fd1a0 (diff)
more changes to file_id copied from mysql schema change in 05e51228020fecaa894523b5159bc412d48e5b19
-rw-r--r--db/laconica_pg.sql6
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 (