From 769032ebbbc2bf8f72dbfce13b39cf0e450f17c7 Mon Sep 17 00:00:00 2001
From: Andreas Baumann <abaumann@yahoo.com>
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

