the postgresql-schema seems to have problems on
CREATE TABLE imap_messages
some fieldnames have backticks-characters, which won't work when pasting them into postgresql. the affected file is db/schema.psql.sql and the fix is as follows:
change the CREATE TABLE imap_messages to
CREATE TABLE imap_messages (
"id" BIGSERIAL NOT NULL,
"folder_name" VARCHAR(100) NOT NULL,
"username" VARCHAR(100) NOT NULL,
"msg_id" VARCHAR(100),
"uid" BIGINT NOT NULL,
"from" VARCHAR(255),
"from_flat" VARCHAR(255),
"to" VARCHAR(255),
"to_flat" VARCHAR(255),
"subject" VARCHAR(255),
"content_type" VARCHAR(30),
"date" TIMESTAMP,
"unread" BOOL default false,
"size" BIGINT,
PRIMARY KEY (id)
);
i hope the developers will fix that soon.
|
Start New Thread
problem with db/schema.psql.sql [ reply ]