From 769032ebbbc2bf8f72dbfce13b39cf0e450f17c7 Mon Sep 17 00:00:00 2001 From: Andreas Baumann Date: Tue, 1 May 2012 08:59:49 +0200 Subject: ids and block numbers are bigints too now fixed a UMR in psql_read_buf --- schema.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 87a5219..7822205 100644 --- a/schema.sql +++ b/schema.sql @@ -1,6 +1,6 @@ CREATE TABLE dir ( - id SERIAL, - parent_id INTEGER, + id BIGSERIAL, + parent_id BIGINT, name TEXT, size BIGINT DEFAULT 0, mode INTEGER NOT NULL DEFAULT 0, @@ -16,8 +16,8 @@ CREATE TABLE dir ( -- TODO: 4096 is STANDARD_BLOCK_SIZE in config.h, must be in sync! CREATE TABLE data ( - dir_id INTEGER, - block_no INTEGER NOT NULL DEFAULT 0, + dir_id BIGINT, + block_no BIGINT NOT NULL DEFAULT 0, data BYTEA NOT NULL DEFAULT repeat(E'\\000',4096)::bytea, PRIMARY KEY( dir_id, block_no ), FOREIGN KEY( dir_id ) REFERENCES dir( id ) -- cgit v1.2.3-54-g00ecf