CREATE TABLE IF NOT EXISTS ajxp_users (
  login varchar(255) NOT NULL,
  password varchar(255) NOT NULL,
  groupPath varchar(255) NULL,
  PRIMARY KEY  (login)
);

CREATE TABLE IF NOT EXISTS ajxp_user_rights (
	rid INTEGER PRIMARY KEY AUTO_INCREMENT, 
	login VARCHAR(255) NOT NULL, 
	repo_uuid VARCHAR(33) NOT NULL, 
	rights MEDIUMTEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS ajxp_user_prefs (
	rid INTEGER PRIMARY KEY AUTO_INCREMENT, 
	login VARCHAR(255) NOT NULL, 
	name VARCHAR(255) NOT NULL, 
	val VARCHAR(2000)
);

CREATE TABLE IF NOT EXISTS ajxp_user_bookmarks (
	rid INTEGER PRIMARY KEY AUTO_INCREMENT, 
	login VARCHAR(255) NOT NULL, 
	repo_uuid VARCHAR(33) NOT NULL, 
	path VARCHAR(255), 
	title VARCHAR(255)
);

CREATE TABLE IF NOT EXISTS ajxp_repo (
	uuid VARCHAR(33) PRIMARY KEY, 
	parent_uuid VARCHAR(33) default NULL,
	owner_user_id VARCHAR(50) default NULL,
	child_user_id VARCHAR(50) default NULL,	
 	path VARCHAR(255), 
 	display VARCHAR(255), 
 	accessType VARCHAR(20), 
 	recycle VARCHAR(255), 
 	bcreate BOOLEAN,
 	writeable BOOLEAN, 
 	enabled BOOLEAN ,
 	isTemplate BOOLEAN,
 	inferOptionsFromParent BOOLEAN,
 	slug VARCHAR(255),
  groupPath VARCHAR(255)
);
 
CREATE TABLE IF NOT EXISTS ajxp_repo_options (
	oid INTEGER PRIMARY KEY AUTO_INCREMENT, 
	uuid VARCHAR(33) NOT NULL, 
	name VARCHAR(50) NOT NULL, 
	val VARCHAR(2000),
	INDEX (uuid)
);

CREATE TABLE IF NOT EXISTS ajxp_roles (
	role_id VARCHAR(255) PRIMARY KEY,
	serial_role TEXT(500) NOT NULL
);

CREATE TABLE IF NOT EXISTS ajxp_groups (
    groupPath VARCHAR(255) PRIMARY KEY,
    groupLabel VARCHAR(255) NOT NULL
);

CREATE TABLE IF NOT EXISTS ajxp_plugin_configs (
  id VARCHAR(50) NOT NULL,
  configs LONGTEXT NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS ajxp_simple_store (
   object_id VARCHAR(255) NOT NULL,
   store_id VARCHAR(50) NOT NULL,
   serialized_data LONGTEXT NULL,
   binary_data LONGBLOB NULL,
   related_object_id VARCHAR(255) NULL,
   PRIMARY KEY(object_id, store_id)
);