/* ---------------------------------------------------------------*/
/* bookmarker                                                     */
/* A WWW based bookmark management, retrieval, and search tool.   */
/* Copyright (C) 1998  Padraic Renaghan                           */
/* Licensed under terms of GNU General Public License             */
/* (see http://www.renaghan.com/bookmarker/source/LICENSE)        */
/* ---------------------------------------------------------------*/
/* Database create script for mysql databases.                    */
/* $Id: create_db.mssql,v 1.1 2000/07/17 23:16:03 prenagha Exp $  */
/* ---------------------------------------------------------------*/

/*                                                                */
/* Table structure for table 'active_sessions'                    */
/*                                                                */
CREATE TABLE active_sessions (
  sid  varchar(32) NOT NULL,
  name varchar(32) NOT NULL,
  val text,
  changed varchar(14) DEFAULT '' NOT NULL,
  PRIMARY KEY (name,sid)
);

/*                                                                */
/* CREATE INDEX replaces KEY index on changed                     */
/*                                                                */
CREATE INDEX changed ON active_sessions(changed);

/*                                                                */
/* Table structure for table 'auth_user'                          */
/*                                                                */
CREATE TABLE auth_user (
  user_id  varchar(32) DEFAULT '' NOT NULL,
  username varchar(32) DEFAULT '' NOT NULL,
  password varchar(32) DEFAULT '' NOT NULL,
  perm_auth_cookie varchar(32) DEFAULT '' NULL,
  perms varchar(255),
  name varchar(50) DEFAULT '' NOT NULL,
  email varchar(50) DEFAULT '' NOT NULL,
  default_public char(1) DEFAULT 'N' NOT NULL,
  include_public char(1) DEFAULT 'Y' NOT NULL,
  total_public_bookmarks int DEFAULT 0 NOT NULL, /* int(6) -> int */
  PRIMARY KEY (user_id)
);

/*                                                                */
/* CREATE UNIQUE INDEX replaces UNIQUE index on username          */
/*                                                                */
CREATE UNIQUE INDEX k_username ON auth_user(username);

/*                                                                */
/* sample data for table 'auth_user'                              */
/*                                                                */
INSERT INTO auth_user (user_id, username, password, perms, name, email, default_public, include_public, perm_auth_cookie) VALUES ('5647980gfdsjklgfduiyo78','bk','7e7ec59d1f4b21021577ff562dc3d48b','admin', 'Bookmarker Admin', 'bookmarker@myhost.com', 'N', 
'N', 'rthjgf7refiur8y7g5syerd6');
INSERT INTO auth_user (user_id, username, password, perms, name, email, default_public, include_public, perm_auth_cookie) VALUES ('7947980abcsjklgfduiyo78','guest','084e0343a0486ff05530df6c705c8bb4','guest', 'Guest User', 'bk-guest@myhost.com', 'N', 'Y', 
'57436eq3547yfshjksfddyrt45');

/*                                                                */
/* Table structure for table 'bookmark'                           */
/*                                                                */
CREATE TABLE bookmark (
  id numeric(10,0) NOT NULL,                    /* int unsigned -> numeric(10,0) */
  url varchar(255) DEFAULT '' NOT NULL,
  name varchar(255) DEFAULT '' NOT NULL,
  ldesc varchar(255) DEFAULT '' NOT NULL,
  keywords varchar(255),
  category_id tinyint DEFAULT '0' NOT NULL,     /* tinyint(4) -> tinyint */
  subcategory_id tinyint DEFAULT '0' NOT NULL,  /* tinyint(4) -> tinyint */
  rating_id tinyint DEFAULT '0' NOT NULL,       /* tinyint(4) -> tinyint */
  username varchar(32) DEFAULT '' NOT NULL,
  added datetime DEFAULT '1998-01-01' NOT NULL, /* date -> datetime */
  public_f char(1) DEFAULT 'N' NOT NULL,
  PRIMARY KEY (id)
);

/*                                                                */
/* CREATE INDEX replaces KEY index on username                    */
/*                                                                */
CREATE INDEX username ON bookmark(username);

/*                                                                */
/* sample data for table 'bookmark'                               */
/*                                                                */
INSERT INTO bookmark (id, url, name, ldesc, keywords, category_id, subcategory_id, rating_id, username, public_f) VALUES (1,'http://www.php.net/','PHP','PHP: Hypertext Preprocessor','php',1,1,3,'bk', 'Y');
INSERT INTO bookmark (id, url, name, ldesc, keywords, category_id, subcategory_id, rating_id, username, public_f) VALUES (2,'http://phplib.netuse.de/','PHPLIB','PHPLIB: Class Library for PHP','php library',1,1,3,'bk', 'Y');
INSERT INTO bookmark (id, url, name, ldesc, keywords, category_id, subcategory_id, rating_id, username, public_f) VALUES (3,'http://www.mysql.net/','MySQL','MySQL Relational Database','db sql php',1,1,3,'bk', 'Y');
INSERT INTO bookmark (id, url, name, ldesc, category_id, subcategory_id, rating_id, username, public_f) VALUES (4,'http://www.apache.org/','Apache','Apache Web Server',1,1,3,'bk', 'Y');
INSERT INTO bookmark (id, url, name, ldesc, category_id, subcategory_id, rating_id, username, public_f) VALUES (5,'http://renaghan.com/bookmarker/','bookmarker','bookmarker Web based bookmark mangement tool',1,1,3,'bk', 'Y');
INSERT INTO bookmark (id, url, name, ldesc, category_id, subcategory_id, rating_id, username, public_f) VALUES (6,'http://www.postgresql.org/','PostgreSQL','PostgreSQL Relational Database',1,1,3,'bk', 'Y');

/*                                                                */
/* Table structure for table 'category'                           */
/*                                                                */
CREATE TABLE category (
  id tinyint DEFAULT '0' NOT NULL,           /* tinyint(3) unsigned [0-255] -> tinyint [0-255] */
  name varchar(30) DEFAULT '' NOT NULL,
  username varchar(32) DEFAULT '' NOT NULL,
  PRIMARY KEY (id,username)
);

/*                                                                */
/* sample data for table 'category'                               */
/*                                                                */
INSERT INTO category (id, name, username) VALUES (0,'unassigned','bk');
INSERT INTO category (id, name, username) VALUES (1,'linux','bk');

/*                                                                */
/* Table structure for table 'rating'                             */
/*                                                                */
CREATE TABLE rating (
  id tinyint DEFAULT '0' NOT NULL,           /* tinyint(3) unsigned [0-255] -> tinyint [0-255] */
  name varchar(30) DEFAULT '' NOT NULL,
  username varchar(32) DEFAULT '' NOT NULL,
  list_tag varchar(255),
  PRIMARY KEY (id,username)
);

/*                                                                */
/* sample data for table 'rating'                                 */
/*                                                                */
INSERT INTO rating (id, name, username, list_tag) VALUES (0,'not rated','bk','');
INSERT INTO rating (id, name, username, list_tag) VALUES (1,'weak','bk',NULL);
INSERT INTO rating (id, name, username, list_tag) VALUES (2,'good','bk',NULL);
INSERT INTO rating (id, name, username, list_tag) VALUES (3,'excellent','bk',NULL);

/*                                                                */
/* Table structure for table 'subcategory'                        */
/*                                                                */
CREATE TABLE subcategory (
  id tinyint DEFAULT '0' NOT NULL,           /* tinyint(3) unsigned [0-255] -> tinyint [0-255] */
  name varchar(30) DEFAULT '' NOT NULL,
  username varchar(32) DEFAULT '' NOT NULL,
  PRIMARY KEY (id,username)
);

/*                                                                */
/* sample data for table 'subcategory'                            */
/*                                                                */
INSERT INTO subcategory (id, name, username) VALUES (0,'unassigned','bk');
INSERT INTO subcategory (id, name, username) VALUES (1,'development','bk');

/*                                                                */
/* Table structure for table 'search'                             */
/*                                                                */
CREATE TABLE search (
  id numeric(10,0) NOT NULL,                 /* int(10) unsigned -> numeric(10,0) */
  name varchar(30) DEFAULT '' NOT NULL,
  query varchar(255) DEFAULT '' NOT NULL,
  username varchar(32) DEFAULT '' NOT NULL,
  PRIMARY KEY (id,username)
);

/*                                                                */
/* Table structure for table 'db_sequence'                        */
/*                                                                */
CREATE TABLE db_sequence (
  seq_name varchar(30)    DEFAULT '' NOT NULL,
  nextid numeric(10,0) DEFAULT '0' NOT NULL,     /* int(10) unsigned -> numeric(10,0) */
  PRIMARY KEY (seq_name)
);
INSERT INTO db_sequence (seq_name, nextid) VALUES ('bookmark', 7);
INSERT INTO db_sequence (seq_name, nextid) VALUES ('search'  , 0);