sql

portage-sqlite-init-db.sql (text/plain), 584 bytes, created by Karol Wojtaszek (RETIRED) on 2004-05-29 00:23:24 UTC

CREATE TABLE path_table (
  name varchar(255) NOT NULL UNIQUE,
  p_id INTEGER PRIMARY KEY
);

CREATE TABLE category_table (
  name varchar(255) NOT NULL UNIQUE,
  c_id INTEGER PRIMARY KEY
);

CREATE TABLE package_name (
  name varchar(255) NOT NULL,
  cat_id  int NOT NULL,
  path_id int NOT NULL,

  data text,

  FOREIGN KEY (cat_id) 
  REFERENCES category_table (c_id) 
  ON DELETE CASCADE,

  FOREIGN KEY (path_id)  
  REFERENCES path_table (p_id) 
  ON DELETE CASCADE,
  
  primary key (name, cat_id, path_id)
  
);

CREATE INDEX p_index ON package_name (name, cat_id, path_id);