djhotcurse 29.07.2006, 13:09
[syntax="sql"]CREATE TABLE phpbb_smilies_pages (
id BIGINT auto_increment NOT NULL,
title VARCHAR( 50 ) DEFAULT 'unknown' NOT NULL,
access TINYINT DEFAULT '0' NOT NULL,
theme TINYINT DEFAULT '0' NOT NULL,
column_count TINYINT DEFAULT '8' NOT NULL ,
column_width TINYINT DEFAULT '30' NOT NULL ,
width SMALLINT DEFAULT '330' NOT NULL ,
height SMALLINT DEFAULT '550' NOT NULL ,
show_titles TINYINT DEFAULT '0' NOT NULL,
default_page TINYINT DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO phpbb_smilies_pages VALUES ('', 'General', 0, 0, 8, 30, 330, 550, 0, 1);
CREATE TABLE phpbb_smilies_bak (
smilies_id smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT,
code varchar( 50 ) default NULL,
smile_url varchar( 100 ) default NULL,
emoticon varchar( 75 ) default NULL,
PRIMARY KEY (smilies_id)
) ;
INSERT INTO phpbb_smilies_bak SELECT smilies_id, code, smile_url, emoticon FROM phpbb_smilies;
ALTER TABLE phpbb_smilies ADD page TINYINT DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_smilies ADD number TINYINT DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_smilies ADD colspan TINYINT DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_smilies ADD inline TINYINT DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_smilies ADD align TINYINT DEFAULT '0' NOT NULL;[/syntax]
Yukarıdaki Tablolarla Manuel Olarak Ekleyebilirsin..