maxcelos

drop table if exists folder;

create table folder (
	id INTEGER primary key AUTOINCREMENT, -- Primary key for the folder, automatically incremented
	name TEXT not null, -- Name of the folder
	parent_id INTEGER, -- Foreign key referencing the parent folder
	foreign key (parent_id) references folder (id) -- Self-referencing foreign key
);