代碼: 選擇全部
#
#-----[ ADD SQL ]------------------------------------------
#
ALTER TABLE users ADD user_birthday INT DEFAULT '999999' not null
代碼: 選擇全部
ALTER TABLE users ADD user_birthday INT DEFAULT '999999' not null代碼: 選擇全部
錯誤
SQL 語法 :
ALTER TABLE users ADD user_birthday INT DEFAULT '999999' NOT NULL
MySQL 傳回：
Table 'news.users' doesn't exist
代碼: 選擇全部
#
#-----[ SQL ]------------------------------------------
#
# If you don't know how to execute sql queries, then copy
# mysql_install.php into your phpbb directory and run it.
# (assuming you use mysql)
#
# If you don't use mysql, you'll have to edit these queries accordingly
#
# If you have a different table prefix then change this command accordingly.
# I have used the default table prefix!
#
INSERT INTO phpbb_config (config_name, config_value) VALUES
('cash_disable',0),
('cash_display_after_posts',1),
('cash_post_message','You earned %s for that post'),
('cash_disable_spam_num',10),
('cash_disable_spam_time',24),
('cash_disable_spam_message','You have exceeded the alloted amount of posts and will not earn anything for your post'),
('cash_installed','yes'),
('cash_version','2.0.2'),
('points_name','Points')代碼: 選擇全部
INSERT INTO phpbb_config (config_name, config_value) VALUES
('cash_disable',0),
('cash_display_after_posts',1),
('cash_post_message','You earned %s for that post'),
('cash_disable_spam_num',10),
('cash_disable_spam_time',24),
('cash_disable_spam_message','You have exceeded the alloted amount of posts and will not earn anything for your post'),
('cash_installed','yes'),
('cash_version','2.0.2'),
('points_name','Points')