CREATE DATABASE `portage`;
USE mysql;
INSERT INTO user (Host,User,Password) VALUES ('localhost','portage','');
FLUSH PRIVILEGES;
GRANT SELECT,UPDATE,DELETE,INSERT,CREATE,LOCK TABLES ON portage.* TO portage@localhost;
FLUSH PRIVILEGES;
USE portage;
CREATE TABLE `path_table` (
  name char(255) NOT NULL UNIQUE,
  p_id int(7) PRIMARY KEY AUTO_INCREMENT
) TYPE=INNODB;
CREATE TABLE `category_table` (
  name char(255) NOT NULL UNIQUE,
  c_id int(7) PRIMARY KEY AUTO_INCREMENT
) TYPE=INNODB;
CREATE TABLE `package_name` (
  name char(255) NOT NULL,
  cat_id  int(7) NOT NULL,
  path_id int(7) 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,
  INDEX p_index (name,cat_id,path_id),
  primary key (name, cat_id, path_id)
) TYPE=INNODB;