/*
####################################################################################################
## Name 	: sherx.mysql.db	
##
## Type		: Relational Database for MySQL
##
## Version	: 1.0, Jan 2001 (Cheick O.COULIBALY & Yann PHILIPPOT )
##
##
##
####################################################################################################

####################################################################################################
## System user______________________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_users : Information about system users
#
*/
CREATE TABLE shx_users (
   	id 		INT(11) NOT NULL AUTO_INCREMENT ,
   	username 	VARCHAR(128) NOT NULL,   
	password 	VARCHAR(128),  		   	
	firstname	VARCHAR(100),
 	lastname	VARCHAR(100),
 	email		VARCHAR(100),
 	company		VARCHAR(100),
 	home_phone	VARCHAR(30),
 	work_phone	VARCHAR(30),
 	mobile		VARCHAR(30),
 	fax		VARCHAR(30),
 	address		VARCHAR(200), 	
 	city		VARCHAR(100),
 	state		VARCHAR(10),
 	zipcode		VARCHAR(10),
 	country		VARCHAR(100),
	job		VARCHAR(100),
	job_title	VARCHAR(20),	
	home_email	VARCHAR(100),
	home_fax	VARCHAR(100),
	PRIMARY KEY 	( id ),
	KEY 		( username ) 
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_img : Photo of the system user
#
*/
CREATE TABLE shx_usr_img (   	
   	username 	VARCHAR(128) NOT NULL,   		   		
	src_img		BLOB,
   	name_img 	VARCHAR(50),  	
  	type_img	VARCHAR(50),
	size_img 	INT,	
  	PRIMARY KEY 	( username ),
	KEY 		( username ) 
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_grps : Information about the system's groups
#
*/
CREATE TABLE shx_usr_grps (
	id		INT(11) NOT NULL AUTO_INCREMENT ,	
	groupname	VARCHAR(100),
	GID		INT,
	idparentgrp	INT DEFAULT '0' NOT NULL, 
   	PRIMARY KEY 	(id),
	KEY 		(id) 
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_memb : System users and groups membership relation 
#
*/
CREATE TABLE shx_usrgrp_memb (
	idusrgrp	INT(11) NOT NULL,
	username	VARCHAR(128) NOT NULL,
	PRIMARY KEY	( idusrgrp, username ),
	KEY 		( idusrgrp ),
	KEY 		( username )
);

/*
####################################################################################################
## Access List Management __________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_acl_grps : Groups of ACL
#
*/
CREATE TABLE shx_acl_grps (
	id		INT(11) NOT NULL AUTO_INCREMENT  ,	
	groupname	VARCHAR(100),	
   	PRIMARY KEY 	( id )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_aclgrp_usr : System's users and ACL's groups membership
#
*/
CREATE TABLE shx_aclgrp_usr (
	idaclgrp	INT(11) NOT NULL,
	username	VARCHAR(128) NOT NULL,
	PRIMARY KEY	( idaclgrp, username ),
	KEY 		( idaclgrp ),
	KEY 		( username )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_aclgrp_usrgrp : System's groups of users and ACL's groups membership
#
*/
CREATE TABLE shx_aclgrp_usrgrp (
	idaclgrp	INT(11) NOT NULL,
	idusrgrp	INT(11) NOT NULL,
	PRIMARY KEY	( idaclgrp, idusrgrp ),
	KEY 		( idaclgrp ),
	KEY 		( idusrgrp )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_acl_module : System's users and ACL's groups membership
#
*/
CREATE TABLE shx_acl_module (	
	idaclgrp	INT(11) NOT NULL,
	modname		VARCHAR(128) NOT NULL,
	acc_right	INT(11) NOT NULL,	
	PRIMARY KEY	( modname,idaclgrp ),
	KEY 		( modname ),
	KEY 		( idaclgrp )
);

/*
####################################################################################################
## User's contacts management ______________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_contacts : Information about contacts
#
*/
CREATE TABLE shx_contacts (
 	id		INT(11) NOT NULL AUTO_INCREMENT ,	 	 	 	
	title 		VARCHAR(20),
	firstname	VARCHAR(100),
 	lastname	VARCHAR(100),
 	bday 		DATE,	
	mobile		VARCHAR(30),	
	home_addr	VARCHAR(200),
	home_phone	VARCHAR(30),
	home_fax	VARCHAR(30),
	home_email 	VARCHAR(100),
	home_city	VARCHAR(100), 	
 	home_zipcode	VARCHAR(10),
	home_state	VARCHAR(10),
	home_country	VARCHAR(10),		
	company		VARCHAR(100),
	job		VARCHAR(100),
	job_title	VARCHAR(20),
	work_mobile	VARCHAR(30),
	work_addr	VARCHAR(200),
	work_phone	VARCHAR(30),
	work_fax	VARCHAR(30),
	work_email 	VARCHAR(100),
	work_city	VARCHAR(100), 	
 	work_zipcode	VARCHAR(10),
	work_state	VARCHAR(10),
	work_country	VARCHAR(10),
	othr_mobile	VARCHAR(30),
	othr_addr	VARCHAR(200),
	othr_phone	VARCHAR(30),
	othr_fax	VARCHAR(30),
	othr_email 	VARCHAR(100),
	othr_city	VARCHAR(100), 	
 	othr_zipcode	VARCHAR(10),
	othr_state	VARCHAR(10),
	othr_country	VARCHAR(10),				 					
 	description	TEXT,
 	website		TEXT,			
   	PRIMARY KEY 	( id )	
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_con_img : Photo of the contact
#
*/
CREATE TABLE shx_con_img (   	
   	id		INT(11) NOT NULL,   		   		
	src_img		BLOB,
   	name_img 	VARCHAR(50),  	
  	type_img	VARCHAR(50),
	size_img 	INT,	
  	PRIMARY KEY 	(id )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_con_grps : Information about the groups of contact
#
*/
CREATE TABLE shx_con_grps (
	id		INT(11) NOT NULL AUTO_INCREMENT ,	
	groupname	VARCHAR(100),	
	idparentgrp	INT(11) DEFAULT '0' NOT NULL, 
	top_grp		INT DEFAULT '0' NOT NULL,
	sys_grp		INT DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	( id )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_congrp_memb : Contacts and Contacts groups membership relation 
#
*/
CREATE TABLE shx_congrp_memb (
	idcongrp	INT(11) NOT NULL,
	idcontact	INT(11) NOT NULL,
	PRIMARY KEY	( idcongrp, idcontact ),
	KEY 		( idcongrp ),
	KEY 		( idcontact )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_con : Ownership relation between users and contacts
#
*/
CREATE TABLE shx_usr_con (   
   	username	VARCHAR(128) NOT NULL,
	idcontact	INT(11) NOT NULL,
   	owner		INT DEFAULT '0',
	show_bday	INT DEFAULT '0',
   	perms		INT DEFAULT '10',   	
   	PRIMARY KEY 	( username, idcontact),
	KEY 		( username ),
	KEY 		( idcontact )  	
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_con : Ownership relation between groups of users and contacts
#
*/
CREATE TABLE shx_usrgrp_con (	
	idusrgrp	INT(11) NOT NULL,
	idcontact	INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	PRIMARY KEY	( idusrgrp, idcontact),
	KEY 		( idusrgrp ),
	KEY 		( idcontact )  	
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_congrp : Ownership relation between users and groups of contacts
#
*/
CREATE TABLE shx_usr_congrp (	
	username	VARCHAR(128) NOT NULL,
	idcongrp	INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	owner		INT DEFAULT '0',
	PRIMARY KEY	( username, idcongrp),
	KEY 		( username ),
	KEY 		( idcongrp )  	
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_congrp : Ownership relation between group of users and groups of contacts
#
*/
CREATE TABLE shx_usrgrp_congrp (	
	idusrgrp	INT(11) NOT NULL,
	idcongrp	INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	PRIMARY KEY	(idusrgrp, idcongrp),
	KEY 		( idusrgrp ),
	KEY 		( idcongrp )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_con_opts : Contacts modules options
#
*/
CREATE TABLE shx_con_opts (
   	owner 		VARCHAR(128) NOT NULL,
   	sort_field 	VARCHAR(128)  NOT NULL,
   	sort_order 	INT DEFAULT '0' NOT NULL,
   	default_grp 	INT(11) DEFAULT '0' NOT NULL,   	
   	disp_grp	INT(11) DEFAULT '0' NOT NULL,
	nb_pgItems	INT DEFAULT '10' NOT NULL,
   	PRIMARY KEY 	( owner )
);

/*
####################################################################################################
## News to display _________________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_news : Information to dispatch to the system users
#
*/
CREATE TABLE shx_news (
   	id 		INT(11) NOT NULL AUTO_INCREMENT ,
   	disp_date 	TIMESTAMP,
   	owner 		VARCHAR(128) NOT NULL,
	idusrgrp	INT(11) NOT NULL DEFAULT '0',	
   	subject 	VARCHAR(128) NOT NULL,
   	content 	TEXT,
   	PRIMARY KEY 	( id ),
	KEY		( disp_date ),
	KEY		( owner )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_news_opt : Users options for the news
#
*/
CREATE TABLE shx_news_opts (   	  	
   	owner 		VARCHAR(128) NOT NULL,
	hidden		INT(11) NOT NULL DEFAULT '0',	   	
   	PRIMARY KEY 	( owner )
);
/*
####################################################################################################
## Bookmarks Management ____________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_bookmarks : Information about the system users bookmarks
#
*/
CREATE TABLE shx_bookmarks (
 	id		INT(11) NOT NULL AUTO_INCREMENT , 	
 	create_date	TIMESTAMP, 	
 	subject		TEXT,
 	description	TEXT,
 	url		TEXT,
	PRIMARY KEY 	( id )	
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_bookmarks_flds : Information about the folders of bookmarks
#
*/
CREATE TABLE shx_bookmarks_flds (
	id		INT(11) NOT NULL AUTO_INCREMENT ,	
	fld_name	VARCHAR(100),	
	idparentfld	INT(11) DEFAULT '0' NOT NULL, 
	top_fld		INT DEFAULT '0' NOT NULL, 
   	PRIMARY KEY 	(id)
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_bmfld_conts : Bookmarks and Bookmarks folds containships relation 
#
*/
CREATE TABLE shx_bmfld_conts (
	idbmfld		INT(11) NOT NULL,
	idbmarks	INT(11) NOT NULL,
	PRIMARY KEY	( idbmfld, idbmarks ),
	KEY		( idbmfld ),
	KEY		( idbmarks )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_bmarks : Ownership relation between users and bookmarks
#
*/
CREATE TABLE shx_usr_bmarks (   
   	username	VARCHAR(128) NOT NULL,
	idbmarks	INT(11) NOT NULL,
   	owner		INT DEFAULT '0',
	via_grp		INT(11) DEFAULT '0' NOT NULL,
   	perms		INT DEFAULT '10',   	
   	PRIMARY KEY 	( username, idbmarks),
	KEY		( username ),
	KEY		( idbmarks )  	
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_bmarks : Ownership relation between groups of users and bookmarks
#
*/
CREATE TABLE shx_usrgrp_bmarks (	
	idusrgrp	INT(11) NOT NULL,
	idbmarks	INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	PRIMARY KEY	(idusrgrp, idbmarks),
	KEY		( idusrgrp ),
	KEY		( idbmarks )
);
/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_bmfld : Ownership relation between users and folders of bookmarks
#
*/
CREATE TABLE shx_usr_bmfld (	
	username	VARCHAR(128) NOT NULL,
	idbmfld		INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	owner		INT DEFAULT '0',
	PRIMARY KEY	( username, idbmfld ),
	KEY		( username ),
	KEY		( idbmfld )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_bmfld : Ownership relation between group of users and folders of bookmarks
#
*/
CREATE TABLE shx_usrgrp_bmfld (	
	idusrgrp	INT(11) NOT NULL,
	idbmfld		INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	PRIMARY KEY	( idusrgrp, idbmfld),
	KEY		( idusrgrp ),
	KEY		( idbmfld )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_bookmarks_opts : Users options for their bookmarks
#
*/
CREATE TABLE shx_bookmarks_opts (   	
   	owner 		VARCHAR(128) NOT NULL,
   	sort_field 	VARCHAR(128)  NOT NULL,
   	sort_order 	INT DEFAULT '0' NOT NULL,
   	default_fold 	INT(11) DEFAULT '0' NOT NULL,   	   	
   	disp_fold	INT(11) DEFAULT '0' NOT NULL,
	disp_grp	INT(11) DEFAULT '0' NOT NULL,
	nb_pgItems	INT DEFAULT '10' NOT NULL,		
   	PRIMARY KEY 	( owner )
);

/*
####################################################################################################
## Notes Management ________________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_notes : Information to display to users of certain groups like an announcement
#
*/
CREATE TABLE shx_notes (
	id		INT(11) NOT NULL AUTO_INCREMENT ,	
	null_date	TIMESTAMP,
	create_date	TIMESTAMP,	
	subject		TEXT,
	description	TEXT,		
	PRIMARY KEY	(id)
);
/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_notes_attach : Information  about notes attachment files
#
*/
CREATE TABLE shx_notes_attach ( 
	id		INT(11) NOT NULL AUTO_INCREMENT ,  	
   	idnote 		INT(11) NOT NULL,   		   		
	src_attach	BLOB,
   	name_attach 	VARCHAR(50),  	
  	type_attach	VARCHAR(50),
	size_attach 	INT,	
  	PRIMARY KEY 	(id),
	KEY		(idnote)
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_notes_flds : Information about the folders of notes
#
*/
CREATE TABLE shx_notes_flds (
	id		INT(11) NOT NULL AUTO_INCREMENT ,	
	fld_name	VARCHAR(100),	
	idparentfld	INT(11) DEFAULT '0' NOT NULL,
	top_fld		INT DEFAULT '0' NOT NULL, 
   	PRIMARY KEY 	(id)
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_ntfld_conts : notes and notes folders containships relation 
#
*/
CREATE TABLE shx_ntfld_conts (
	idntfld		INT(11) NOT NULL,
	idnote		INT(11) NOT NULL,
	PRIMARY KEY	( idntfld, idnote ),
	KEY		( idntfld ),
	KEY		( idnote )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_notes : Ownership relation between users and notes
#
*/
CREATE TABLE shx_usr_notes (   
   	username	VARCHAR(128) NOT NULL,
	idnote		INT(11) NOT NULL,
	via_grp		INT(11) DEFAULT '0' NOT NULL,
   	owner		INT DEFAULT '0',
   	perms		INT DEFAULT '10',   	
   	PRIMARY KEY 	( username, idnote, via_grp),
	KEY		( username ),
	KEY		( idnote )  	
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_notes : Ownership relation between groups of users and notes
#
*/
CREATE TABLE shx_usrgrp_notes (	
	idusrgrp	INT(11) NOT NULL,
	idnote		INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	PRIMARY KEY	( idusrgrp, idnote ),
	KEY		( idusrgrp ),
	KEY		( idnote )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_ntfld : Ownership relation between users and folders of notes
#
*/
CREATE TABLE shx_usr_ntfld (	
	username	VARCHAR(20) NOT NULL,
	idntfld		INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	owner		INT DEFAULT '0',
	PRIMARY KEY	( username, idntfld ),
	KEY		( username ),
	KEY		( idntfld )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_ntfld : Ownership relation between group of users and folders of notes
#
*/
CREATE TABLE shx_usrgrp_ntfld (	
	idusrgrp	INT(11) NOT NULL,
	idntfld		INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	PRIMARY KEY	( idusrgrp, idntfld ),
	KEY		( idusrgrp ),
	KEY		( idntfld )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_notes_opts : Users options for module "notes" 
#
*/
CREATE TABLE shx_notes_opts (	
	owner		VARCHAR(128) NOT NULL,
	sort_field 	VARCHAR(128)  NOT NULL,
   	sort_order 	INT DEFAULT '0' NOT NULL,
	default_grp 	INT(11) DEFAULT '0' NOT NULL,
   	default_fold 	INT(11) DEFAULT '0' NOT NULL,   	
   	disp_fold	INT(11) DEFAULT '0' NOT NULL,
	disp_grp	INT(11) DEFAULT '0' NOT NULL,
	nb_pgItems	INT DEFAULT '10' NOT NULL,	   	
	PRIMARY KEY	( owner )
);

/*
####################################################################################################
## Task Management _________________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_tasks : Information about the tasks todo by some users or by some groups of users
#
*/
CREATE TABLE shx_tasks (
 	id		INT(11) NOT NULL AUTO_INCREMENT, 
	null_date	TIMESTAMP,	
 	create_date	TIMESTAMP, 	
 	subject		TEXT,
 	description	TEXT,
 	priority	INT,
 	state		INT,
	start_date	TIMESTAMP,
	due_date	TIMESTAMP,
	due_type	INT,
	PRIMARY KEY	( id )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_tasks_flds : Information about the folders of tasks
#
*/
CREATE TABLE shx_tasks_flds (
	id		INT(11) NOT NULL AUTO_INCREMENT ,	
	fld_name	VARCHAR(100),	
	idparentfld	INT(11) DEFAULT '0' NOT NULL, 
	top_fld		INT DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	(id)
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_tkfld_conts : tasks and tasks folders containships relation 
#
*/
CREATE TABLE shx_tkfld_conts (
	idtskfld		INT(11) NOT NULL,
	idtasks		INT(11) NOT NULL,
	PRIMARY KEY	( idtskfld, idtasks ),
	KEY		( idtskfld ),
	KEY		( idtasks )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_tasks : Ownership relation between users and tasks
#
*/
CREATE TABLE shx_usr_tasks (   
   	username	VARCHAR(128) NOT NULL,
	idtasks		INT(11) NOT NULL,
	via_grp		INT(11) DEFAULT '0' NOT NULL,
   	owner		INT DEFAULT '0',
   	perms		INT DEFAULT '10',   	
   	PRIMARY KEY 	( username, idtasks, via_grp ),
	KEY		( username ),
	KEY		( idtasks )  	
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_tasks : Ownership relation between groups of users and tasks
#
*/
CREATE TABLE shx_usrgrp_tasks (	
	idusrgrp	INT(11) NOT NULL,
	idtasks		INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	PRIMARY KEY	( idusrgrp, idtasks),
	KEY		( idusrgrp ),
	KEY		( idtasks )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_tkfld : Ownership relation between users and folders of tasks
#
*/
CREATE TABLE shx_usr_tkfld (	
	username	VARCHAR(128) NOT NULL,
	idtskfld		INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	owner		INT DEFAULT '0',
	PRIMARY KEY	( username, idtskfld),
	KEY		( username ),
	KEY		( idtskfld )
);
/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_tkfld : Ownership relation between group of users and folders of tasks
#
*/
CREATE TABLE shx_usrgrp_tkfld (	
	idusrgrp	INT(11) NOT NULL,
	idtskfld		INT(11) NOT NULL,
	perms		INT DEFAULT '10',
	PRIMARY KEY	( idusrgrp, idtskfld ),
	KEY		( idusrgrp ),
	KEY		( idtskfld )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_tasks_opts : Users options for "tasks" module
#
*/
CREATE TABLE shx_tasks_opts (
   	owner		VARCHAR(128) NOT NULL,
	sort_field 	VARCHAR(128)  NOT NULL,
   	sort_order 	INT DEFAULT '0' NOT NULL,
	default_grp 	INT(11) DEFAULT '0' NOT NULL,
   	default_fold 	INT(11) DEFAULT '0' NOT NULL,   	
   	disp_fold	INT(11) DEFAULT '0' NOT NULL,
	disp_grp	INT(11) DEFAULT '0' NOT NULL,
   	priority 	INT(11) DEFAULT '0' NOT NULL,   	
   	duetype		INT(11) DEFAULT '0' NOT NULL,
	nb_pgItems	INT DEFAULT '10' NOT NULL,
   	PRIMARY KEY 	( owner )

);

/*
####################################################################################################
## Forums Management _______________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_forums : Information about the forums
#
*/
CREATE TABLE shx_forums (
	id		INT(11) NOT NULL AUTO_INCREMENT ,
	owner		VARCHAR(128) NOT NULL,   	
	create_date	TIMESTAMP,
	title		TEXT,
	body		TEXT,
	idparent	INT(11) DEFAULT '0' NOT NULL,
	idusrgrp	INT(11) DEFAULT '-2' NOT NULL,
	description 	VARCHAR(50),	
	PRIMARY	KEY	( id ),
	KEY		( owner ),
	KEY		( idparent )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_forums_attach : Information  about forums attachment files
#
*/
CREATE TABLE shx_forums_attach ( 
	id		INT(11) NOT NULL AUTO_INCREMENT ,  	
   	idforums 	INT(11) NOT NULL,   		   		
	src_attach	BLOB,
   	name_attach 	VARCHAR(50),  	
  	type_attach	VARCHAR(50),
	size_attach 	INT,	
  	PRIMARY KEY 	( id ),
	KEY		( idforums )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_forums_opts : Users options for module "forums"
#
*/
CREATE TABLE shx_forums_opts (   
	owner		VARCHAR(128) NOT NULL,
	sort_field 	VARCHAR(128)  NOT NULL,
	sort_order 	INT DEFAULT '0' NOT NULL,   
	PRIMARY KEY	( owner )
);

/*
####################################################################################################
## Meetings Management _____________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_meetings : Information about the forums
#
*/
CREATE TABLE shx_meetings (
    	id 		INT(11) NOT NULL AUTO_INCREMENT ,   	  	
  	create_date 	TIMESTAMP,
  	meet_start 	TIMESTAMP,
  	meet_stop 	TIMESTAMP,
  	meet_done 	TIMESTAMP,
  	subject 	VARCHAR(100),
	location	INT(11) DEFAULT '0' NOT NULL,
	loc_addr	VARCHAR(200),
  	description 	TEXT,  	
  	conclusion 	TEXT,  		  	
  	part_maxnum 	INT(11) DEFAULT '0' NOT NULL,
  	meet_state 	INT(11) DEFAULT '0' NOT NULL,  	
  	meet_type 	INT(11) DEFAULT '0' NOT NULL,
  	PRIMARY KEY 	(id)
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_meets_opts : Meetings modules options
#
*/
CREATE TABLE shx_meets_opts (
   	owner 		VARCHAR(128) NOT NULL,   	
   	default_grp 	INT(11) DEFAULT '0' NOT NULL,
	disp_mview	INT(11) DEFAULT '0' NOT NULL,   	
   	disp_grp	INT(11) DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	( owner )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_meets_access : Meetings invitations and registrations
#
*/
CREATE TABLE shx_meets_access (
  	idmeets 	INT(11) NOT NULL,
  	username 	VARCHAR(128) NOT NULL,
	date 		TIMESTAMP,
	meet_resp	INT(11) DEFAULT '0' NOT NULL,
	acc_state	INT(11) DEFAULT '0' NOT NULL,
  	event_idx 	INT(11) DEFAULT '0' NOT NULL,
	inv_date 	TIMESTAMP,
  	reg_date 	TIMESTAMP,  
	priority	INT(11) DEFAULT '0' NOT NULL,	
  	PRIMARY KEY 	( idmeets, username),
	KEY		( idmeets ),
	KEY		( username )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_meets_access : Meetings invitations and registrations
#
*/
CREATE TABLE shx_meets_rests (	
	idmemb		INT(11) NOT NULL,
	type_memb	INT DEFAULT '0' NOT NULL,
	idmeeting	INT(11) NOT NULL,
	perms		INT DEFAULT '10',	
	PRIMARY KEY	( idmemb, type_memb, idmeeting),
	KEY		( idmemb ),
	KEY		( type_memb ),
	KEY		( idmeeting )
);

/*
####################################################################################################
## Schedule Management _____________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_sche_access : Schedule sharing between system's users
#
*/
CREATE TABLE shx_sche_access ( 	
 	sche_owner	VARCHAR(128) NOT NULL ,	
 	sche_user 	VARCHAR(128) NOT NULL , 
 	perms		INT DEFAULT '10', 	
	PRIMARY KEY	( sche_owner, sche_user ),
	KEY		( sche_owner ),
	KEY		( sche_user )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_sche_grps : Schedule sharing between system's users and groups of users
#
*/
CREATE TABLE shx_sche_grps_access ( 		
 	owner	 	VARCHAR(128) NOT NULL ,	
 	idusrgrp 	INT(11) NOT NULL , 
 	perms		INT DEFAULT '10', 	
	PRIMARY KEY	( owner, idusrgrp ),
	KEY		( owner ),
	KEY		( idusrgrp )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_sche_opts : Schedule modules options
#
*/
CREATE TABLE shx_sche_opts (
   	owner 		VARCHAR(128) NOT NULL,   	
   	default_grp 	INT(11) DEFAULT '0' NOT NULL,	   	
   	disp_grp	INT(11) DEFAULT '0' NOT NULL,
	disp_view	INT(11) DEFAULT '0' NOT NULL,
	startmyday	INT(11) DEFAULT '8' NOT NULL,
	stopmyday	INT(11) DEFAULT '17' NOT NULL,
	step		INT(11) DEFAULT '30' NOT NULL,
	showday		INT(11) DEFAULT '2' NOT NULL,
	duration	INT(11) DEFAULT '3600' NOT NULL,
	editview	INT(11) DEFAULT '1' NOT NULL,	
   	PRIMARY KEY 	( owner )
);
CREATE INDEX shx_sche_opts_usr_idx ON shx_sche_opts ( owner );

CREATE TABLE shx_sche_globalopts (   	
	id INT NOT NULL,
	add_fields 	LONGTEXT,
   	PRIMARY KEY 	( id )
);
/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_appointments : System's users appointments 
#
*/
CREATE TABLE shx_appointments (
 	id 		INT(11) NOT NULL AUTO_INCREMENT ,  
	app_create	TIMESTAMP,	 	
 	app_start	TIMESTAMP,
 	app_stop	TIMESTAMP,
 	app_subject	TEXT,
 	description	TEXT,	
	onsite		INT DEFAULT '0' NOT NULL,
	app_public	INT DEFAULT '0' NOT NULL,
	app_type	INT DEFAULT '0' NOT NULL,
	type_period	CHAR(1),
	end_period	TIMESTAMP,		
	nb_occurance	INT(11) DEFAULT '0' NOT NULL, 	
	app_orig	INT(11) DEFAULT '0' NOT NULL, 	 	
	PRIMARY KEY	( id ),
	KEY		( app_start ),
	KEY		( app_stop )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usr_apps : Relationship between system's users and appointments 
#
*/
CREATE TABLE shx_usr_apps ( 		
 	idapp		INT(11) NOT NULL, 	
 	username 	VARCHAR(128) NOT NULL,
	via_grp		INT(11) DEFAULT '0' NOT NULL,
	owner		INT DEFAULT '0' NOT NULL,	
	attendto 	INT DEFAULT '1' NOT NULL,
	sms_alert 	INT DEFAULT '0' NOT NULL,	
	rappel 		INT DEFAULT '3600', 		
	PRIMARY KEY	( idapp, username, via_grp ),
	KEY		( idapp ),
	KEY		( username )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_usrgrp_apps : Relationship between system's groups and appointments 
#
*/
CREATE TABLE shx_usrgrp_apps ( 		
 	idapp		INT(11) NOT NULL, 	
 	idusrgrp 	INT(11) NOT NULL,			
	PRIMARY KEY	(idapp, idusrgrp ),
	KEY		( idapp ),
	KEY		( idusrgrp )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_con_apps : Relationship between contacts and appointments 
#
*/
CREATE TABLE shx_con_apps ( 		
 	idapp		INT(11) NOT NULL, 	
 	idcontact 	INT(11) NOT NULL,		
	PRIMARY KEY	( idapp, idcontact),
	KEY		( idapp ),
	KEY		( idcontact )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_congrp_apps : Relationship between contacts groups and appointments 
#
*/
CREATE TABLE shx_congrp_apps ( 		
 	idapp		INT(11) NOT NULL, 	
 	idcongrp 	INT(11) NOT NULL,		
	PRIMARY KEY	(idapp, idcongrp),
	KEY		( idapp ),
	KEY		( idcongrp )
);


/*
####################################################################################################
## Mail Management ________________________________________________________________________________
##

#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_mail_folders : mail folders
#
*/
CREATE TABLE shx_mail_folders (
 	id 		INT(11) NOT NULL AUTO_INCREMENT ,  	 	 
   	owner 		VARCHAR(128) NOT NULL,   	
   	fold_name 	VARCHAR(255) NOT NULL,
	fold_path 	VARCHAR(255) NOT NULL,
	parent 		INT(11) DEFAULT '0' NOT NULL,
   	PRIMARY KEY 	( id ),
	KEY		( owner ),
	KEY		( fold_name )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_mailcheck : Email rules
#
*/

CREATE TABLE shx_mailchk (
        id              INT(11) NOT NULL AUTO_INCREMENT , 
        username        VARCHAR(128) NOT NULL,
        mod_name      	VARCHAR(64) NOT NULL,
        mod_title     	TEXT,
        mod_gen  	VARCHAR(64) DEFAULT '.procmailrc' NOT NULL,
        mod_status    	INT DEFAULT '1' NOT NULL,
        priority        INT(11) DEFAULT '0' NOT NULL,
        params          TEXT,
        PRIMARY KEY     ( id ),
	KEY		( username )       
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_mail_opts : Mail modules options
#
*/
CREATE TABLE shx_mail_opts (	
	owner		VARCHAR(128) NOT NULL, 		
	sign		TEXT, 			
	nbmessage	INT DEFAULT '20' NOT NULL,
	wrap		INT DEFAULT '80',
	cleanauto 	INT DEFAULT '0',
	storemsg 	INT DEFAULT '1',
	ack 		INT DEFAULT '0',
	requestack 	INT DEFAULT '0',
	headers 	INT DEFAULT '0',
	priority 	INT DEFAULT '1',
	diffusion 	INT DEFAULT '0',
	sort_field 	VARCHAR(20)  NOT NULL,
	sort_order 	INT DEFAULT '1' NOT NULL, 	
	PRIMARY KEY	( owner )
);

/*
####################################################################################################
## Global options Management _______________________________________________________________________
##


#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_main_opts : Options for the main modules
#
*/
CREATE TABLE shx_main_opts (   	
   	owner 		VARCHAR(128) NOT NULL,
   	disp_sche 	INT DEFAULT '1' NOT NULL,
   	disp_mails 	INT DEFAULT '1' NOT NULL,
	disp_tasks 	INT DEFAULT '1' NOT NULL,
	disp_notes 	INT DEFAULT '1' NOT NULL,
	disp_news 	INT DEFAULT '1' NOT NULL,
   	PRIMARY KEY 	( owner )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_global_opts : Global options
#
*/
CREATE TABLE shx_global_opts (   	
   	owner 		VARCHAR(128) NOT NULL,   	
   	lang	 	VARCHAR(20),
	opti	 	INT DEFAULT '0' NOT NULL,	   	
	time_format	INT(11),
   	PRIMARY KEY 	( owner )
);

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_personal_opts : Options define by the users 
#
*/
CREATE TABLE shx_personal_opts (   	
   	owner 		VARCHAR(128) NOT NULL,
	data		TEXT,
   	context		TEXT,
	PRIMARY KEY 	( owner )
);


/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# shx_personal_opts : Options define by the users 
#
*/
CREATE TABLE shx_organize_schedule (   	
   	id 		INT(11) NOT NULL AUTO_INCREMENT , 
	date		TIMESTAMP,
	subject		TEXT,
	type		INT(11),
   	start		TIMESTAMP,
	stop		TIMESTAMP,
	PRIMARY KEY 	( id )
);



/*
####################################################################################################
## Name 	: sherx.db.ini	
##
## Type		: Database initialization scripts
##
## Version	: 1.0, Jan 2001 (Cheick O.COULIBALY)
##
##
##
####################################################################################################
*/

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# Initialization of shx_acl_grps : Groups of ACL
#
# TABLE shx_acl_grps (
# 	id		INT,	
# 	groupname	VARCHAR,	
#    	PRIMARY KEY 	(id)
# );
*/

/*
#"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
# Initialization of  shx_acl_module : System's users and ACL's groups memberships
#
# TABLE shx_acl_module (	
# 	idaclgrp	INT,
# 	idmodule	INT,
# 	modname		VARCHAR,
# 	acc_right	INT,	
# 	PRIMARY KEY	( idmodule, idaclgrp )
# );
*/


INSERT INTO shx_acl_grps ( id,groupname ) VALUES ( 1,'Administrateur' );
INSERT INTO shx_acl_grps ( id,groupname ) VALUES ( 2,'Utilisateur' );
INSERT INTO shx_acl_grps ( id,groupname ) VALUES ( 3,'Invite' );

INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'mail', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'contacts', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'schedule', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'tasks', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'notes', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'bookmark', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'fax', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'sms', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'explorer', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'comrules', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'admin', '3' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '1', 'users', '3' );

INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'mail', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'contacts', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'schedule', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'tasks', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'notes', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'bookmark', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'users', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'fax', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'sms', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'explorer', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'comrules', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '2', 'admin', '1' );


INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'mail', '1' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'contacts', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'schedule', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'tasks', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'notes', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'bookmark', '2' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'fax', '1' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'sms', '1' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'explorer', '1' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'comrules', '1' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'admin', '1' );
INSERT INTO shx_acl_module ( idaclgrp, modname, acc_right ) VALUES ( '3', 'users', '1' );

INSERT INTO shx_aclgrp_usr ( idaclgrp, username ) VALUES ( '1', 'admin' );

INSERT INTO shx_aclgrp_usrgrp ( idaclgrp, idusrgrp ) VALUES ( '2', '1' );

drop table shx_bookmarks,shx_bookmarks_flds,shx_usr_bmarks,shx_usrgrp_bmarks,shx_usr_bmfld,shx_usrgrp_bmfld,shx_bookmarks_opts;

CREATE TABLE shx_bookmarks (
        id              INT(11) NOT NULL AUTO_INCREMENT ,
        create_date     TIMESTAMP,
        subject         TEXT,
        description     TEXT,
        url             TEXT,
        PRIMARY KEY     ( id )
);

CREATE TABLE shx_bookmarks_flds (
        id              INT(11) NOT NULL AUTO_INCREMENT ,
        fld_name        VARCHAR(100),
        idparentfld     INT(11) DEFAULT '0' NOT NULL,
        top_fld         INT DEFAULT '0' NOT NULL,
        PRIMARY KEY     (id)
);

CREATE TABLE shx_usr_bmarks (
        username        VARCHAR(128) NOT NULL,
        idbmarks        INT(11) NOT NULL,
        owner           INT DEFAULT '0',
        via_grp         INT(11) DEFAULT '0' NOT NULL,
        perms           INT DEFAULT '10',
        PRIMARY KEY     ( username, idbmarks),
        KEY             ( username ),
        KEY             ( idbmarks )
);

CREATE TABLE shx_usrgrp_bmarks (
        idusrgrp        INT(11) NOT NULL,
        idbmarks        INT(11) NOT NULL,
        perms           INT DEFAULT '10',
        PRIMARY KEY     (idusrgrp, idbmarks),
        KEY             ( idusrgrp ),
        KEY             ( idbmarks )
);

CREATE TABLE shx_usr_bmfld (
        username        VARCHAR(128) NOT NULL,
        idbmfld         INT(11) NOT NULL,
        perms           INT DEFAULT '10',
        owner           INT DEFAULT '0',
        PRIMARY KEY     ( username, idbmfld ),
        KEY             ( username ),
        KEY             ( idbmfld )
);

CREATE TABLE shx_usrgrp_bmfld (
        idusrgrp        INT(11) NOT NULL,
        idbmfld         INT(11) NOT NULL,
        perms           INT DEFAULT '10',
        PRIMARY KEY     ( idusrgrp, idbmfld),
        KEY             ( idusrgrp ),
        KEY             ( idbmfld )
);

CREATE TABLE shx_bookmarks_opts (
        owner           VARCHAR(128) NOT NULL,
        sort_field      VARCHAR(128)  NOT NULL,
        sort_order      INT DEFAULT '0' NOT NULL,
        default_fold    INT(11) DEFAULT '0' NOT NULL,
        disp_fold       INT(11) DEFAULT '0' NOT NULL,
        disp_grp        INT(11) DEFAULT '0' NOT NULL,
        nb_pgItems      INT DEFAULT '10' NOT NULL,
        PRIMARY KEY     ( owner )
);


# phpMyAdmin MySQL-Dump
# version 2.2.0
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: serv
# Generation Time: September 27, 2001, 3:37 pm
# Server version: 3.23.36
# PHP Version: 4.0.6
# Database : `
# --------------------------------------------------------

#
# Table structure for table `Addr_sync`
#

CREATE TABLE Addr_sync (
  id int(10) unsigned NOT NULL auto_increment,
  owner varchar(128) default NULL,
  id_local int(10) unsigned NOT NULL default '0',
  id_palm int(10) unsigned default NULL,
  dirty tinyint(3) unsigned NOT NULL default '0',
  deleted tinyint(3) unsigned NOT NULL default '0',
  md5 varchar(32) default NULL,
  private tinyint(3) unsigned default NULL,
  category varchar(16) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `Memo_sync`
#

CREATE TABLE Memo_sync (
  id int(10) unsigned NOT NULL auto_increment,
  owner varchar(128) default NULL,
  id_local int(10) unsigned NOT NULL default '0',
  id_palm int(10) unsigned default NULL,
  dirty tinyint(3) unsigned NOT NULL default '0',
  deleted tinyint(3) unsigned NOT NULL default '0',
  md5 varchar(32) default NULL,
  private tinyint(3) unsigned default NULL,
  category varchar(16) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `Todo_sync`
#

CREATE TABLE Todo_sync (
  id int(10) unsigned NOT NULL auto_increment,
  owner varchar(128) default NULL,
  id_local int(10) unsigned NOT NULL default '0',
  id_palm int(10) unsigned default NULL,
  dirty tinyint(3) unsigned NOT NULL default '0',
  deleted tinyint(3) unsigned NOT NULL default '0',
  md5 varchar(32) default NULL,
  private tinyint(3) unsigned default NULL,
  category varchar(16) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

ALTER TABLE shx_tasks ADD private TINYINT UNSIGNED DEFAULT '0' NOT NULL, ADD category VARCHAR(16);
ALTER TABLE shx_notes ADD private TINYINT UNSIGNED DEFAULT '0' NOT NULL, ADD category VARCHAR(16);
# Three pagers
ALTER TABLE shx_contacts ADD home_pager VARCHAR(30) AFTER mobile;
ALTER TABLE shx_contacts ADD work_pager VARCHAR(30) AFTER work_mobile;
ALTER TABLE shx_contacts ADD othr_pager VARCHAR(30) AFTER othr_mobile;

# Private and category
ALTER TABLE shx_contacts ADD private TINYINT UNSIGNED DEFAULT '0' NOT NULL, ADD category VARCHAR(16);

# Four custom fields
ALTER TABLE shx_contacts ADD custom1 TEXT AFTER website, ADD custom2 TEXT AFTER custom1, ADD custom3 TEXT AFTER custom2, ADD custom4 TEXT AFTER custom3;

# Contact headers
ALTER TABLE shx_contacts ADD palm_cats INT AFTER custom4;
ALTER TABLE shx_mail_opts ADD nonewmailnotify int(11) DEFAULT '0' NOT NULL;
CREATE TABLE Date_sync (
  id int(10) unsigned NOT NULL auto_increment,
  owner varchar(128) default NULL,
  id_local int(10) unsigned NOT NULL default '0',
  id_palm int(10) unsigned default NULL,
  dirty tinyint(3) unsigned NOT NULL default '0',
  deleted tinyint(3) unsigned NOT NULL default '0',
  md5 varchar(32) default NULL,
  private tinyint(3) unsigned default NULL,
  category varchar(16) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;


ALTER TABLE shx_appointments
 ADD palm_alarmadvance TINYINT UNSIGNED AFTER app_orig,
 ADD palm_alarmunit TINYINT UNSIGNED AFTER palm_alarmadvance,
 ADD palm_hasmoved TINYINT UNSIGNED DEFAULT '1' NOT NULL AFTER palm_alarmunit;
ALTER TABLE shx_appointments
 ADD private TINYINT UNSIGNED DEFAULT '0' NOT NULL AFTER palm_hasmoved,
 ADD category VARCHAR(16) AFTER private;
ALTER TABLE shx_contacts
	ADD palm_ct1 VARCHAR(64) AFTER palm_cats,
	ADD palm_ct2 VARCHAR(64) AFTER palm_ct1,
	ADD palm_ct3 VARCHAR(64) AFTER palm_ct2,
	ADD palm_ct4 VARCHAR(64) AFTER palm_ct3,
	ADD palm_ct5 VARCHAR(64) AFTER palm_ct4;

ALTER TABLE shx_users

## incoming mail hostname
##   imap://user:pass@mail.foo.com:143/mail/
##   pop3://user:pass@mail.foo.com:110
	ADD mail_host VARCHAR(255),
## outgoing mail hostname 
## smtp://smtp.foo.com:25
	ADD smtp_host VARCHAR(255),
## ftp hostname
##   ftp://user:pass@ftp.foo.bar
	ADD ftp_host VARCHAR(255),
## ftp hostname for email rules
##   ftp://user:pass@ftp.foo.bar
	ADD ftpm_host VARCHAR(255);
