diff options
author | Andreas Baumann <abaumann@yahoo.com> | 2012-05-01 08:59:49 +0200 |
---|---|---|
committer | Andreas Baumann <abaumann@yahoo.com> | 2012-05-01 08:59:49 +0200 |
commit | 769032ebbbc2bf8f72dbfce13b39cf0e450f17c7 (patch) | |
tree | c1a08840b5d9245654846484031afc30ae7bfba5 /schema.sql | |
parent | 6297d437585be15616a47802c84f592447ed5cdd (diff) | |
download | pgfuse-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.sql | 8 |
1 files changed, 4 insertions, 4 deletions
@@ -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 ) |