3 ms·
True, because you could always ... CREATE TABLE filesystem(inode AS BIGINT UNIQUE NOT NULL PRIMARY KEY, is_dir AS BIT(1) NOT NULL, name AS VARCHAR(4096) UN
by RiverCrochet 3y ago
True, because you could always ...
CREATE TABLE filesystem(inode AS BIGINT UNIQUE NOT NULL PRIMARY KEY, is_dir AS BIT(1) NOT NULL, name AS VARCHAR(4096) UNIQUE NOT NULL, in_this_dir_inode AS INT NOT NULL, bloblist_ptr AS INT NOT NULL, metadata_ptr AS BIGINT),
CREATE TABLE bloblist(blob_id AS INT UNIQUE NOT NULL, onwer_inode_ptr AS INT, thisblob AS LONGBLOB, prev_blob_ptr AS INT NOT NULL, next_blob_ptr AS INT NOT NULL)
CREATE TABLE file_metadata(metadata_record_id AS BIGINT UNIQUE NOT NULL, created_at AS DATETIME NOT NULL, last_accessed at AS DATETIME, last_modified_at AS DATETIME, owner_uid AS INT NOT NULL, owner_gid AS INT NOT NULL, mode AS BIT(4) NOT NULL)
or similar.