phpBB España Oficial

Código: Seleccionar todo

CREATE TABLE phpbb_invitations (
	invitation_id MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT ,
	invitation_code VARCHAR( 8 ) NOT NULL ,
	invitation_description TEXT NOT NULL,
	invitation_uses MEDIUMINT(8) NOT NULL DEFAULT '1',
	invitation_group MEDIUMINT(8) NOT NULL DEFAULT '0',
        invitation_email TEXT NOT NULL,
	[color=#ff0066]PRIMARY KEY ( invitation_id )[/color] 
);

CREATE TABLE phpbb_invitation_users (
	invitation_id MEDIUMINT( 8 ) NOT NULL,
	user_id MEDIUMINT( 8 ) NOT NULL,	
	[color=#ff003f]PRIMARY KEY ( user_id )[/color] 
);	

[color=#ff003f]INSERT INTO phpbb_config ( config_name , config_value ) 
	VALUES ('invite_only', '1');[/color]