Attachment #87053 for bug #62197

Lines 68-74 Link Here

(-)open-xchange-0.8.2.orig/conf/admintools.conf.in (-1 / +1 lines)
68	DEFAULT_SQL_USER="@dbuser@"	68	DEFAULT_SQL_USER="@dbuser@"
69	DEFAULT_SQL_PASS="@dbpass@"	69	DEFAULT_SQL_PASS="@dbpass@"
70	### if u want to use mysql change to mysql	70	### if u want to use mysql change to mysql
71	SQL_DB_TYPE="pgsql"	71	SQL_DB_TYPE="mysql"
72		72
73		73
74	# Default Table where we store the Rights	74	# Default Table where we store the Rights




# direct_link_hostname=server

# DATABASE identifiert for SYSDATE
SYSDATE=now()

# DATABASE identifier for CURRENT_DATE
SQL_TODAY=curdate()

# Sequence SQL-String for DATABASE
# Example for POSTGRES
#seq-fid=SELECT nextval ('fid')
#seq-import_id=SELECT nextval ('import_id')
#seq-insert_id=SELECT nextval ('insert_id')
#seq-profile_id=SELECT nextval ('profile_id')
#seq-serial_id=SELECT nextval ('serial_id')

# Example for mySQL
seq-fid=SELECT select_fid()
seq-import_id=SELECT select_import_id()
seq-insert_id=SELECT select_insert_id()
seq-profile_id=SELECT select_profile_id()
seq-serial_id=SELECT select_serial_id()

# Example for ORACLE
#seq-fid="SELECT fid.nextval"
#seq-import_id=SELECT import_id.nextval

Lines 791-796 Link Here

(-)open-xchange-0.8.2.orig/configure.in (+1 lines)
791	conf/webmail/system.properties	791	conf/webmail/system.properties
792	conf/admintools.conf	792	conf/admintools.conf
793	system/setup/init_ldap.ldif	793	system/setup/init_ldap.ldif
		794	system/setup/create_mysql_database.sql
794	src/com/openexchange/server/Version.java )	795	src/com/openexchange/server/Version.java )
795		796
796	dnl here we should be able to build the complete ox solution ...	797	dnl here we should be able to build the complete ox solution ...




DROP DATABASE IF EXISTS @dbname@;

CREATE DATABASE @dbname@ DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

GRANT ALL PRIVILEGES ON @dbname@.* TO '@dbuser@'@'localhost' IDENTIFIED BY '@dbpass@' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON @dbname@.* TO '@dbuser@'@'%' IDENTIFIED BY '@dbpass@';

USE @dbname@;

DROP TABLE IF EXISTS table_fid;

CREATE TABLE table_fid (
        id INT  NOT NULL AUTO_INCREMENT,
        primary key (id)
);

DROP FUNCTION IF EXISTS select_fid;

DELIMITER //

CREATE FUNCTION select_fid () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_fid VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //

DELIMITER ;

DROP TABLE IF EXISTS table_serial_id;

CREATE TABLE table_serial_id (
        id INT  NOT NULL AUTO_INCREMENT,
        primary key (id)
) AUTO_INCREMENT = 9;

DROP FUNCTION IF EXISTS select_serial_id;

DELIMITER //

CREATE FUNCTION select_serial_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_serial_id VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //

DELIMITER ;


DROP TABLE IF EXISTS table_import_id;

CREATE TABLE table_import_id (
        id INT  NOT NULL AUTO_INCREMENT,
        primary key (id)
);

DROP FUNCTION IF EXISTS select_import_id;

DELIMITER //

CREATE FUNCTION select_import_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_import_id VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //

DELIMITER ;


DROP TABLE IF EXISTS table_insert_id;

CREATE TABLE table_insert_id (
        id INT  NOT NULL AUTO_INCREMENT,
        primary key (id)
) AUTO_INCREMENT = 101;

DROP FUNCTION IF EXISTS select_insert_id;

DELIMITER //

CREATE FUNCTION select_insert_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_insert_id VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //

DELIMITER ;

DROP TABLE IF EXISTS table_profile_id;

CREATE TABLE table_profile_id (
        id INT  NOT NULL AUTO_INCREMENT,
        primary key (id)
);

DROP FUNCTION IF EXISTS select_profile_id;

DELIMITER //

CREATE FUNCTION select_profile_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_profile_id VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //


DELIMITER ;





 
DROP TABLE IF EXISTS table_fid;

CREATE TABLE table_fid (
	id INT  NOT NULL AUTO_INCREMENT,
	primary key (id)
);

DROP FUNCTION IF EXISTS select_fid;

DELIMITER //

CREATE FUNCTION select_fid () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_fid VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //

DELIMITER ;
 
DROP TABLE IF EXISTS table_serial_id;

CREATE TABLE table_serial_id (
	id INT  NOT NULL AUTO_INCREMENT,
	primary key (id)
) AUTO_INCREMENT = 9;

DROP FUNCTION IF EXISTS select_serial_id;

DELIMITER //

CREATE FUNCTION select_serial_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_serial_id VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //

DELIMITER ;

 
DROP TABLE IF EXISTS table_import_id;

CREATE TABLE table_import_id (
	id INT  NOT NULL AUTO_INCREMENT,
	primary key (id)
);

DROP FUNCTION IF EXISTS select_import_id;

DELIMITER //

CREATE FUNCTION select_import_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_import_id VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //

DELIMITER ;

 
DROP TABLE IF EXISTS table_insert_id;

CREATE TABLE table_insert_id (
	id INT  NOT NULL AUTO_INCREMENT,
	primary key (id)
) AUTO_INCREMENT = 101;

DROP FUNCTION IF EXISTS select_insert_id;

DELIMITER //

CREATE FUNCTION select_insert_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_insert_id VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //

DELIMITER ;

DROP TABLE IF EXISTS table_profile_id;

CREATE TABLE table_profile_id (
	id INT  NOT NULL AUTO_INCREMENT,
	primary key (id)
);

DROP FUNCTION IF EXISTS select_profile_id;

DELIMITER //

CREATE FUNCTION select_profile_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
BEGIN
  DECLARE xid INT;
  INSERT into table_profile_id VALUES();
  SELECT last_insert_id() into xid;
  RETURN xid;
END //


DELIMITER ;

CREATE TABLE prg_dlist (
	intfield01 integer,
	intfield02 integer,

	order_crit text,
	timestampfield01 timestamp ,
	timestampfield02 timestamp ,
	intfield01 int PRIMARY KEY,
	intfield02 int,
	intfield03 int,
	intfield04 int,


CREATE TABLE projects_notes (
	intfield01 integer,
	note_id VARCHAR(166),
	member_id text,
	primary key (intfield01, note_id),
	foreign key (intfield01) references projects on delete cascade on update cascade


CREATE TABLE backup_projects_notes (
	intfield01 integer,
	note_id VARCHAR(166),
	member_id text,
	primary key (intfield01, note_id),
	foreign key (intfield01) references backup_projects on delete cascade on update cascade

CREATE TABLE projects_antecessors (
	intfield01 integer,
	id integer,
	antecessor VARCHAR(166),
	object_type integer,
	primary key (intfield01, id, antecessor),
	foreign key (intfield01, id) references projects_dependencies on delete cascade on update cascade

CREATE TABLE backup_projects_antecessors (
	intfield01 integer,
	id integer,
	antecessor VARCHAR(166),
	object_type integer,
	primary key (intfield01, id, antecessor),
	foreign key (intfield01, id) references backup_projects_dependencies on delete cascade on update cascade

	order_crit text,
	timestampfield01 timestamp ,
	timestampfield02 timestamp ,
	intfield01 int PRIMARY KEY,
	intfield02 int,
	intfield03 int,
	intfield04 int,
	intfield05 int,
	intfield06 int,
	field01 text NOT NULL,
	field02 text,
	field03 text,
	field04 text,
	field05 text,
	field06 text,
	field07 text,
	field08 text,
	field09 text,
	field10 text
);

CREATE TABLE del_docufolders (
	creating_date timestamp NOT NULL,
	created_from text NOT NULL,
	changing_date timestamp,
	changed_from text,
	user_right text NOT NULL,
	group_right text NOT NULL,
	sid text NOT NULL,
	tid text,
	order_crit text,
	timestampfield01 timestamp,
	timestampfield02 timestamp,
	intfield01 int PRIMARY KEY,
	intfield02 int,
	intfield03 int,
	intfield04 int,

	order_crit text,
	timestampfield01 timestamp ,
	timestampfield02 timestamp ,
	intfield01 int PRIMARY KEY,
	intfield02 int NOT NULL,
	intfield03 int,
	intfield04 int,
	intfield05 int,
	intfield06 int,
	field01 text NOT NULL,
	field02 text,
	field03 text,
	field04 text,
	field05 text,
	field06 text,
	field07 text,
	field08 text,
	field09 text,
	field10 text
);

CREATE TABLE del_documents (
	creating_date timestamp NOT NULL,
	created_from text NOT NULL,
	changing_date timestamp,
	changed_from text,
	user_right text NOT NULL,
	group_right text NOT NULL,
	sid text NOT NULL,
	tid text,
	order_crit text,
	timestampfield01 timestamp,
	timestampfield02 timestamp,
	intfield01 int PRIMARY KEY,
	intfield02 int NOT NULL,
	intfield03 int,
	intfield04 int,

	order_crit text,
	timestampfield01 timestamp ,
	timestampfield02 timestamp ,
	intfield01 int PRIMARY KEY,
	intfield02 int NOT NULL,
	intfield03 int NOT NULL,
	intfield04 int,
	intfield05 int,
	intfield06 int,
	field01 text NOT NULL,
	field02 text,
	field03 text NOT NULL,
	field04 text NOT NULL,
	field05 text,
	field06 text,
	field07 text,
	field08 text,
	field09 text,
	field10 text
);

CREATE TABLE del_documents_files (
	creating_date timestamp NOT NULL,
	created_from text,
	changing_date timestamp,
	changed_from text,
	user_right text,
	group_right text,
	sid text NOT NULL,
	tid text,
	order_crit text,
	timestampfield01 timestamp,
	timestampfield02 timestamp,
	intfield01 int PRIMARY KEY,
	intfield02 int NOT NULL,
	intfield03 int NOT NULL,
	intfield04 int,


CREATE TABLE sys_linkage (
	changing_date timestamp  NOT NULL,
	luid int PRIMARY KEY,
	source_id int NOT NULL,
	src_table text NOT NULL,
	src_field text NOT NULL,


CREATE TABLE del_linkage (
	changing_date timestamp  NOT NULL,
	luid int PRIMARY KEY,
	source_id int NOT NULL,
	src_table text NOT NULL,
	src_field text NOT NULL,

		img text
);

CREATE TABLE oxfolder_userfolders_standardfolders (
	owner text,
	module text,
	fuid int
);

CREATE TABLE del_oxfolder_tree (
        fuid int,
        parent int,

		target_object_id int
);

CREATE TABLE del_system_objects (
	object_type int,
	object_id text,
	deleting_date timestamp
);

INSERT INTO oxfolder_tree VALUES (1, 0, 'private', 'system', 'system','system', 'system', 'now', 'System', null, null);
INSERT INTO oxfolder_tree VALUES (2, 0, 'public', 'system', 'system','system', 'system', 'now', 'System', null, null);
INSERT INTO oxfolder_tree VALUES (3, 0, 'shared', 'system', 'system','system', 'system', 'now', 'System', null, null);
INSERT INTO oxfolder_tree VALUES (4, 0, 'system', 'system', 'system','system', 'system', 'now', 'System', null, null);
INSERT INTO oxfolder_tree VALUES (5, 4, 'system_global', 'contact', 'system','system', 'system', 'now', 'System', null, null);
INSERT INTO oxfolder_tree VALUES (6, 4, 'system_ldap', 'contact', 'system','system', 'system', 'now', 'System', null, null);
INSERT INTO oxfolder_tree VALUES (7, 0, 'user', 'system', 'system','system', 'system', 'now', 'System', null, null);
INSERT INTO oxfolder_tree VALUES (8, 7, 'projects', 'projects', 'system','system', 'system', 'now', 'System', null, null);

INSERT INTO oxfolder_permissions VALUES (select_serial_id(), 1, 512,'all_ox_users_and_ox_groups', 0, 8, 0, 0, 0);
INSERT INTO oxfolder_permissions VALUES (select_serial_id(), 2, 512, 'all_ox_users_and_ox_groups', 0, 8, 0, 0, 0);

Return to bug 62197

Lines 129-146 Link Here

(-)open-xchange-0.8.2.orig/conf/groupware/intranet.conf (-7 / +15 lines)
129	# direct_link_hostname=server	129	# direct_link_hostname=server
130		130
131	# DATABASE identifiert for SYSDATE	131	# DATABASE identifiert for SYSDATE
132	SYSDATE='now'	132	SYSDATE=now()
133		133
134	# DATABASE identifier for CURRENT_DATE	134	# DATABASE identifier for CURRENT_DATE
135	# SQL_TODAY='today'	135	SQL_TODAY=curdate()
136		136
137	# Sequence SQL-String for DATABASE	137	# Sequence SQL-String for DATABASE
138	# Example for POSTGRES	138	# Example for POSTGRES
139	seq-fid=SELECT nextval ('fid')	139	#seq-fid=SELECT nextval ('fid')
140	seq-import_id=SELECT nextval ('import_id')	140	#seq-import_id=SELECT nextval ('import_id')
141	seq-insert_id=SELECT nextval ('insert_id')	141	#seq-insert_id=SELECT nextval ('insert_id')
142	seq-profile_id=SELECT nextval ('profile_id')	142	#seq-profile_id=SELECT nextval ('profile_id')
143	seq-serial_id=SELECT nextval ('serial_id')	143	#seq-serial_id=SELECT nextval ('serial_id')
		144
		145	# Example for mySQL
		146	seq-fid=SELECT select_fid()
		147	seq-import_id=SELECT select_import_id()
		148	seq-insert_id=SELECT select_insert_id()
		149	seq-profile_id=SELECT select_profile_id()
		150	seq-serial_id=SELECT select_serial_id()
		151
144	# Example for ORACLE	152	# Example for ORACLE
145	#seq-fid="SELECT fid.nextval"	153	#seq-fid="SELECT fid.nextval"
146	#seq-import_id=SELECT import_id.nextval	154	#seq-import_id=SELECT import_id.nextval

Line 0 Link Here

(-)open-xchange-0.8.2.orig/system/setup/create_mysql_database.sql.in (+117 lines)
		1	DROP DATABASE IF EXISTS @dbname@;
		2
		3	CREATE DATABASE @dbname@ DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
		4
		5	GRANT ALL PRIVILEGES ON @dbname@.* TO '@dbuser@'@'localhost' IDENTIFIED BY '@dbpass@' WITH GRANT OPTION;
		6	GRANT ALL PRIVILEGES ON @dbname@.* TO '@dbuser@'@'%' IDENTIFIED BY '@dbpass@';
		7
		8	USE @dbname@;
		9
		10	DROP TABLE IF EXISTS table_fid;
		11
		12	CREATE TABLE table_fid (
		13	id INT NOT NULL AUTO_INCREMENT,
		14	primary key (id)
		15	);
		16
		17	DROP FUNCTION IF EXISTS select_fid;
		18
		19	DELIMITER //
		20
		21	CREATE FUNCTION select_fid () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
		22	BEGIN
		23	DECLARE xid INT;
		24	INSERT into table_fid VALUES();
		25	SELECT last_insert_id() into xid;
		26	RETURN xid;
		27	END //
		28
		29	DELIMITER ;
		30
		31	DROP TABLE IF EXISTS table_serial_id;
		32
		33	CREATE TABLE table_serial_id (
		34	id INT NOT NULL AUTO_INCREMENT,
		35	primary key (id)
		36	) AUTO_INCREMENT = 9;
		37
		38	DROP FUNCTION IF EXISTS select_serial_id;
		39
		40	DELIMITER //
		41
		42	CREATE FUNCTION select_serial_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
		43	BEGIN
		44	DECLARE xid INT;
		45	INSERT into table_serial_id VALUES();
		46	SELECT last_insert_id() into xid;
		47	RETURN xid;
		48	END //
		49
		50	DELIMITER ;
		51
		52
		53	DROP TABLE IF EXISTS table_import_id;
		54
		55	CREATE TABLE table_import_id (
		56	id INT NOT NULL AUTO_INCREMENT,
		57	primary key (id)
		58	);
		59
		60	DROP FUNCTION IF EXISTS select_import_id;
		61
		62	DELIMITER //
		63
		64	CREATE FUNCTION select_import_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
65	BEGIN
66	DECLARE xid INT;
67	INSERT into table_import_id VALUES();
68	SELECT last_insert_id() into xid;
69	RETURN xid;
70	END //
71
72	DELIMITER ;
73
74
75	DROP TABLE IF EXISTS table_insert_id;
76
77	CREATE TABLE table_insert_id (
78	id INT NOT NULL AUTO_INCREMENT,
79	primary key (id)
80	) AUTO_INCREMENT = 101;
81
82	DROP FUNCTION IF EXISTS select_insert_id;
83
84	DELIMITER //
85
86	CREATE FUNCTION select_insert_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
87	BEGIN
88	DECLARE xid INT;
89	INSERT into table_insert_id VALUES();
90	SELECT last_insert_id() into xid;
91	RETURN xid;
92	END //
93
94	DELIMITER ;
95
96	DROP TABLE IF EXISTS table_profile_id;
97
98	CREATE TABLE table_profile_id (
99	id INT NOT NULL AUTO_INCREMENT,
100	primary key (id)
101	);
102
103	DROP FUNCTION IF EXISTS select_profile_id;
104
105	DELIMITER //
106
107	CREATE FUNCTION select_profile_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA
108	BEGIN
109	DECLARE xid INT;
110	INSERT into table_profile_id VALUES();
111	SELECT last_insert_id() into xid;
112	RETURN xid;
113	END //
114
115
116	DELIMITER ;
117