summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorAndreas Baumann <abaumann@yahoo.com>2012-05-01 08:59:49 +0200
committerAndreas Baumann <abaumann@yahoo.com>2012-05-01 08:59:49 +0200
commit769032ebbbc2bf8f72dbfce13b39cf0e450f17c7 (patch)
treec1a08840b5d9245654846484031afc30ae7bfba5 /schema.sql
parent6297d437585be15616a47802c84f592447ed5cdd (diff)
downloadpgfuse-769032ebbbc2bf8f72dbfce13b39cf0e450f17c7.tar.gz
pgfuse-769032ebbbc2bf8f72dbfce13b39cf0e450f17c7.tar.bz2
ids and block numbers are bigints too now
fixed a UMR in psql_read_buf
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql8
1 files changed, 4 insertions, 4 deletions
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 )