-- -----------------------------------------------------
-- Table os
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS os (
  id SERIAL,
  name TEXT NOT NULL,
  PRIMARY KEY (id));

-- -----------------------------------------------------
-- Table inode
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS inode (
  os_id SERIAL,
  fs_inode BIGINT NOT NULL,
  PRIMARY KEY (os_id, fs_inode),
  CONSTRAINT fk_inode_filesystem1
    FOREIGN KEY (os_id , fs_inode)
    REFERENCES filesystem (os_id , inode)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);