// scripts/init-db.ts
import Database from 'better-sqlite3';
import { mkdirSync, existsSync } from 'fs';

if (!existsSync('data')) {
  mkdirSync('data');
}

const db = new Database('data.db');

db.exec(`
  DROP TABLE IF EXISTS tasks;
  DROP TABLE IF EXISTS links;

  CREATE TABLE tasks (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    text TEXT NOT NULL,
    start TEXT NOT NULL,
    end TEXT NOT NULL,
    duration INTEGER,
    progress INTEGER,
    type TEXT,
    parent INTEGER,
    assignedTo TEXT,
    lazy_loading BOOLEAN DEFAULT 0
  );

  CREATE TABLE links (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    source INTEGER,
    target INTEGER,
    type TEXT
  );
`);
  // table pour les ressources
  db.exec(`
  CREATE TABLE IF NOT EXISTS resource_planning (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    ressource TEXT NOT NULL,
    profil TEXT NOT NULL,
    date TEXT NOT NULL,
    disponibilite REAL NOT NULL
  );
`);


console.log('✅ Base de données initialisée avec succès.');