Verfasst: 22.04.2003 13:57
eins
zwei
drei
die letzte spalte (bei screen drei) in der table_forum ist die für die events.
wenn ich die lupe klick bei der forums table kommt dies
phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
CREATE TABLE phpbb_mycalendar (
cal_id int(12) NOT NULL auto_increment,
topic_id int(20) NOT NULL default '0',
cal_date int(14) default NULL,
cal_date_end int(14) default NULL,
cal_interval tinyint(3) NOT NULL default '1',
cal_interval_units enum('DAY','WEEK','MONTH','YEAR') NOT NULL default 'DAY',
cal_repeat tinyint(3) NOT NULL default '1',
forum_id int(5) NOT NULL default '0',
PRIMARY KEY (cal_id),
UNIQUE KEY topic_id (topic_id)
) TYPE=MyISAM;
#
# Daten für Tabelle `phpbb_mycalendar`
#
INSERT INTO phpbb_mycalendar VALUES (1, 61, 2003, NULL, '1', 'DAY', '1', 15);
INSERT INTO phpbb_mycalendar VALUES (2, 62, 2003, NULL, '1', 'DAY', '1', 15);
INSERT INTO phpbb_mycalendar VALUES (3, 63, 2003, NULL, '1', 'DAY', '1', 15);
Code: Alles auswählen
CREATE TABLE phpbb_mycalendar(
cal_id int(12) NOT NULL auto_increment,
topic_id int(20) NOT NULL default '0',
cal_date datetime NOT NULL default '2000-00-00 00:00:00',
cal_interval tinyint(3) NOT NULL default '1',
cal_interval_units enum('DAY','WEEK','MONTH','YEAR') NOT NULL default 'DAY',
cal_repeat tinyint(3) NOT NULL default '1',
forum_id int(5) NOT NULL default '0',
PRIMARY KEY (cal_id),
UNIQUE KEY topic_id (topic_id)
) TYPE=MyISAM;