phpBB.de

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;