bin in MySQL noch Neuling und habe daher zur Installationsanleitung des Meeting-Mod noch eine Frage:
In der Anleitung steht am Anfang des Einbau's:
Code: Alles auswählen
#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_meeting_comment (
comment_id MEDIUMINT(8) AUTO_INCREMENT,
meeting_id MEDIUMINT(8) unsigned NOT NULL,
user_id MEDIUMINT(8) DEFAULT '0' NOT NULL,
meeting_comment TEXT NOT NULL,
meeting_edit_time INT(11) DEFAULT '0' NOT NULL,
bbcode_uid varchar(10) NOT NULL DEFAULT '',
PRIMARY KEY (comment_id));
CREATE TABLE phpbb_meeting_data (
meeting_id MEDIUMINT(8) unsigned NOT NULL,
meeting_time INT(11) DEFAULT '0' NOT NULL,
meeting_until INT(11) DEFAULT '0' NOT NULL,
meeting_location VARCHAR(255) NOT NULL,
meeting_subject VARCHAR(255) NOT NULL,
meeting_desc TEXT NOT NULL,
meeting_link VARCHAR(255) NOT NULL,
meeting_places MEDIUMINT(8) DEFAULT '0' NOT NULL,
meeting_by_user MEDIUMINT(8) DEFAULT '0' NOT NULL,
meeting_edit_by_user MEDIUMINT(8) DEFAULT '0' NOT NULL,
meeting_start_value MEDIUMINT(8) DEFAULT '0' NOT NULL,
meeting_recure_value MEDIUMINT(8) DEFAULT '5' NOT NULL,
meeting_notify TINYINT(1) NOT NULL DEFAULT '0',
meeting_guest_overall MEDIUMINT(8) NOT NULL DEFAULT '0',
meeting_guest_single MEDIUMINT(8) NOT NULL DEFAULT '0',
meeting_guest_names TINYINT(1) NOT NULL DEFAULT '0',
bbcode_uid varchar(10) NOT NULL DEFAULT '',
PRIMARY KEY (meeting_id));
CREATE TABLE phpbb_meeting_user (
meeting_id MEDIUMINT(8) unsigned NOT NULL,
user_id MEDIUMINT(8) DEFAULT '0' NOT NULL,
meeting_sure TINYINT(4) DEFAULT '0' NOT NULL,
meeting_guests MEDIUMINT(8) NOT NULL DEFAULT '0');
CREATE TABLE phpbb_meeting_usergroup (
meeting_id MEDIUMINT(8) unsigned NOT NULL,
meeting_group MEDIUMINT(8) NOT NULL);
CREATE TABLE phpbb_meeting_config (
config_name VARCHAR(255) NOT NULL DEFAULT '',
config_value VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (config_name)
);
CREATE TABLE phpbb_meeting_guestnames (
meeting_id MEDIUMINT(8) NOT NULL DEFAULT '0',
user_id MEDIUMINT(8) NOT NULL DEFAULT '0',
guest_prename VARCHAR(255) NOT NULL DEFAULT '',
guest_name VARCHAR(255) NOT NULL DEFAULT ''
);
INSERT INTO phpbb_meeting_config (config_name, config_value) VALUES ('allow_user_enter_meeting', '0');
INSERT INTO phpbb_meeting_config (config_name, config_value) VALUES ('allow_user_edit_meeting', '0');
INSERT INTO phpbb_meeting_config (config_name, config_value) VALUES ('allow_user_delete_meeting', '0');
INSERT INTO phpbb_meeting_config (config_name, config_value) VALUES ('allow_user_delete_meeting_comments', '0');
INSERT INTO phpbb_meeting_config (config_name, config_value) VALUES ('create_meeting', '1');
INSERT INTO phpbb_meeting_config (config_name, config_value) VALUES ('meeting_notify', '1');
UPDATE phpbb_meeting_data SET meeting_by_user = 2, meeting_edit_by_user = 2;
ALTER TABLE phpbb_groups ADD COLUMN allow_create_meeting TINYINT(1) DEFAULT '0' NOT NULL;Die darunter stehenden Änderungen im PHP sind ja kein Thema, aber mit dem oben zu sehenden kann ich irgendwie nix anfangen.
Schonmal Danke im Vorraus für die Hilfe.
