www.ugu.pl

CREATE TABLE `phpbb_ads` (
`ad_type` VARCHAR( 10 ) NOT NULL ,
`ad_id` TINYINT( 5 ) NOT NULL ,
`ad_code` TEXT NOT NULL ,
`ad_name` TINYINT( 25 ) NOT NULL,
UNIQUE (
`ad_id`
)
);

INSERT INTO `phpbb_ads` ( `ad_type` , `ad_id` , `ad_code`, `ad_name` )
VALUES (
'first_post', '1', '<script type="text/javascript"><!--
google_ad_client = "pub-2930568312118905";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_channel ="";
google_ad_type = "text_image";
google_color_link = "0000FF";
google_color_url = "008000";
google_color_text = "000000";
google_color_border = "336699";
google_color_bg = "FFFFFF";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>', 'Defualt'
);

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_after_post', '1'
);

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_every_post', '0'
);

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_who', 'all'
);

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_forums', 'all'
);

Błąd

zapytanie SQL:

CREATE TABLE `phpbb_ads` (
`ad_type` VARCHAR( 10 ) NOT NULL ,
`ad_id` TINYINT( 5 ) NOT NULL ,
`ad_code` TEXT NOT NULL ,
`ad_name` TINYINT( 25 ) NOT NULL ,
UNIQUE (
`ad_id`
)
);


MySQL zwrócił komunikat:
#1050 - Table 'phpbb_ads' already exists