summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/schema.sql b/schema.sql
index 2f5c202..555fb25 100644
--- a/schema.sql
+++ b/schema.sql
@@ -24,12 +24,12 @@ CREATE TABLE data (
);
-- create indexes for fast data access
-CREATE INDEX data_dir_id_idx ON data( dir_id );
-CREATE INDEX data_block_no_idx ON data( block_no );
+CREATE INDEX data_dir_id_idx ON data( dir_id ) tablespace test2;
+CREATE INDEX data_block_no_idx ON data( block_no ) tablespace test2;
-- create an index on the parent_id for
-- directory listings
-CREATE INDEX dir_parent_id_idx ON dir( parent_id );
+CREATE INDEX dir_parent_id_idx ON dir( parent_id ) tablespace test2;
-- 16384 == S_IFDIR (S_IFDIR)
-- TODO: should be created by the program after checking the OS