Code: Alles auswählen
#
#-----[ SQL ]---------------------------------------------
#
CREATE TABLE phpbb_gb_config (
config_id int(10) NOT NULL auto_increment,
back_ground_color varchar(25) NOT NULL default '#cfd9ff',
min_entrylength int(10) NOT NULL default '15',
max_entrylength int(10) NOT NULL default '750',
font_color varchar(25) NOT NULL default 'black',
font_size_one int(2) NOT NULL default '11',
font_size_two int(2) NOT NULL default '14',
font_size_three int(2) NOT NULL default '15',
link_size int(2) NOT NULL default '10',
design_gb_links varchar(50) NOT NULL default 'no',
design_t_links varchar(50) NOT NULL default 'no',
checkbox_gb_links int(1) NOT NULL default '0',
checkbox_t_links int(1) NOT NULL default '0',
entries_per_site int(3) NOT NULL default '5',
PRIMARY KEY (config_id)
);
INSERT INTO phpbb_gb_config (config_id, back_ground_color, min_entrylength, max_entrylength, font_color, font_size_one, font_size_two, font_size_three, link_size, design_gb_links, design_t_links, checkbox_gb_links, checkbox_t_links, entries_per_site) VALUES
(1, '#cfd9ff', 15, 750, 'black', 11, 14, 15, 10, 'no', 'no', 0, 0, 5);
CREATE TABLE phpbb_gb_entries (
entry_id int(10) NOT NULL auto_increment,
ip varchar(15) NOT NULL,
user_id int(10) NOT NULL default '0',
author varchar(255) NOT NULL,
website varchar(255) NOT NULL,
entry_time varchar(50) NOT NULL,
entry_text longtext NOT NULL,
PRIMARY KEY (entry_id)
);
INSERT INTO phpbb_gb_entries (entry_id, ip, user_id, author, website, entry_time, entry_text) VALUES
(1, '127.0.0.1', 0, 'System', '', '**.**.**** - **:**', 'Willkommen in unserem Gästebuch! - Welcome to our guestbook!');
CREATE TABLE phpbb_gb_sessions (
session_id int(10) NOT NULL auto_increment,
gbd varchar(255) NOT NULL default '0',
code varchar(50) NOT NULL default '0',
lang varchar(50) NOT NULL default '0',
PRIMARY KEY (session_id)
);