Jay Brown
c10fa98d0a
Restore original migrations (001-120) to fix schema_migrations version mismatch * Restore original migrations (001-120) to fix schema_migrations version mismatch The previous migration collapse broke deployed databases because: - Dev database was at version 120 (the real remove_text_extraction migration) - Main had collapsed migrations (001-012) + stub files (119_stub, 120_stub) - The migrate tool couldn't find version 119/120 with matching content This commit restores the original 27 migrations (versions 001-120) from before the collapse, ensuring backward compatibility with existing databases.
19 lines
669 B
SQL
19 lines
669 B
SQL
-- Create folders table for hierarchical document organization
|
|
CREATE TABLE folders (
|
|
id uuid PRIMARY KEY DEFAULT uuid_generate_v7(),
|
|
path text NOT NULL,
|
|
parentId uuid,
|
|
clientId varchar(255) NOT NULL,
|
|
createdAt timestamp NOT NULL DEFAULT NOW(),
|
|
createdBy varchar(255) NOT NULL,
|
|
FOREIGN KEY (parentId) REFERENCES folders(id),
|
|
FOREIGN KEY (clientId) REFERENCES clients(clientId),
|
|
UNIQUE(clientId, path),
|
|
CHECK (id != parentId)
|
|
);
|
|
|
|
-- Indexes for efficient folder queries
|
|
CREATE INDEX idx_folders_parentid ON folders(parentId);
|
|
CREATE INDEX idx_folders_clientid ON folders(clientId);
|
|
CREATE INDEX idx_folders_path ON folders(path);
|