CREATE TABLE IF NOT EXISTS folder (
  folder_id TEXT PRIMARY KEY NOT NULL,
  folder_name TEXT NOT NULL UNIQUE,
  parent_folder_id TEXT NULL
);

CREATE TABLE IF NOT EXISTS image (
  image_id TEXT PRIMARY KEY NOT NULL,
  image_name TEXT NOT NULL,
  folder_id TEXT,
  FOREIGN KEY (folder_id) REFERENCES folder(folder_id)
);

INSERT INTO folder ( folder_id, folder_name ) VALUES ( "019bbbd3-656c-70a8-8049-29213bf0e958", "partner" );
INSERT INTO folder ( folder_id, folder_name ) VALUES ( "019bbbd4-c67f-701b-937c-1e66108d72f9", "portrait");
INSERT INTO folder ( folder_id, folder_name ) VALUES ( "019bbbd6-14f4-7d81-818c-64b398034953", "divers" );



