CREATE TABLE IF NOT EXISTS plugins (
  id          INT AUTO_INCREMENT PRIMARY KEY,
  name        VARCHAR(100)  NOT NULL,
  icon        VARCHAR(10)   DEFAULT '🧩',
  description TEXT,
  long_desc   TEXT,
  price       VARCHAR(30)   DEFAULT 'Free',
  platform    VARCHAR(30)   DEFAULT 'Spigot',
  spigot_url  VARCHAR(255),
  bbb_url     VARCHAR(255),
  features    TEXT,
  created_at  TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS developers (
  id          INT AUTO_INCREMENT PRIMARY KEY,
  username    VARCHAR(50)  NOT NULL,
  github_url  VARCHAR(255),
  discord_tag VARCHAR(100),
  instagram   VARCHAR(255),
  youtube     VARCHAR(255)
);