文章
由 starfox0307 »
#
#-----[ SQL ]--------------------------------------------
#
ALTER TABLE phpbb_users ADD user_money mediumint(8) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_points mediumint(8) DEFAULT '0' NOT NULL;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('icash_money', '金錢');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('icash_points', '積分');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('icash_money_reply', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('icash_points_reply', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('icash_money_newtopic', '10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('icash_points_newtopic', '2');
CREATE TABLE phpbb_icash_log (
log_id mediumint(8) NOT NULL auto_increment,
log_affort mediumint(8) NOT NULL default '0',
log_value mediumint(8) NOT NULL default '0',
log_reason varchar(255) NOT NULL default '',
log_user mediumint(8) NOT NULL default '0',
log_time varchar(255) NOT NULL default '',
log_to mediumint(8) NOT NULL default '0',
log_cash mediumint(8) NOT NULL default '0',
PRIMARY KEY (log_id)
);
紅色字那一段有做嗎?