Hi ...
Code: Alles auswählen
#
#-----[ SQL ]-------------------------------------------------
#
CREATE TABLE `phpbb_xdata_fields` (
field_id smallint(5) UNSIGNED NOT NULL,
field_name varchar(255) NOT NULL default '',
field_desc text NOT NULL default '',
field_type varchar(255) NOT NULL default '',
field_order smallint(5) UNSIGNED NOT NULL default '0',
code_name varchar(255) NOT NULL default '',
field_length mediumint(8) UNSIGNED NOT NULL default '0',
field_values text NOT NULL default '',
field_regexp text NOT NULL default '',
default_auth tinyint(1) NOT NULL default '1',
display_register tinyint(1) NOT NULL default '1',
display_viewprofile tinyint(1) NOT NULL default '0',
display_posting tinyint(1) NOT NULL default '0',
handle_input tinyint(1) NOT NULL default '0',
allow_html tinyint(1) NOT NULL default '0',
allow_bbcode tinyint(1) NOT NULL default '0',
allow_smilies tinyint(1) NOT NULL default '0',
PRIMARY KEY (field_id),
UNIQUE KEY code_name (code_name)
);
CREATE TABLE `phpbb_xdata_data` (
field_id smallint(5) UNSIGNED NOT NULL,
user_id mediumint(8) UNSIGNED NOT NULL,
xdata_value text NOT NULL
);
CREATE TABLE `phpbb_xdata_auth` (
field_id smallint(5) UNSIGNED NOT NULL,
group_id mediumint(8) UNSIGNED NOT NULL,
auth_value tinyint(1) NOT NULL
);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(1, 'ICQ Number', 'special', '1', 'icq', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(2, 'AIM Address', 'special', '2', 'aim', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(3, 'MSN Messenger', 'special', '3', 'msn', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(4, 'Yahoo Messenger', 'special', '4', 'yim', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(5, 'Website', 'special', '5', 'website', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(6, 'Location', 'special', '6', 'location', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(7, 'Occupation', 'special', '7', 'occupation', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(8, 'Interests', 'special', '8', 'interests', 2);
INSERT INTO `phpbb_xdata_fields`
(field_id, field_name, field_type, field_order, code_name, display_register)
VALUES
(9, 'Signature', 'special', '9', 'signature', 2);
#
