init-portage-db.sql

init-portage-db.sql (text/plain), 831 bytes, created by Ahmed Farid on 2004-06-04 22:32:22 UTC

CREATE DATABASE `portage`;
USE mysql;
REPLACE 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` (
  p_id int PRIMARY KEY AUTO_INCREMENT,
  name char(255) NOT NULL UNIQUE
);
CREATE TABLE `category_table` (
  c_id int(7) PRIMARY KEY AUTO_INCREMENT, 
  name char(255) NOT NULL UNIQUE
) ;
CREATE TABLE `package_name` (

  name char(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, 
  #INDEX p_index (name,cat_id,path_id),
  primary key (name, cat_id, path_id)
) MAX_ROWS=99999999;