发一张后台管理的截图

后台管理的截图,今天好无聊啊,我自己设计的

 

 

 

评论

2 楼 vb2005xu 2009-12-03  

create_table :citys_comments, :id=>false do |t|
		t.column :city_id, :integer, :null => false
		t.column :comment_id , :integer, :null => false
	end
	
	say_with_time 'add FOREIGN KEY citys_comments(city_id,comment_id)' do            
		execute 'ALTER TABLE citys_comments ADD CONSTRAINT fk_tb_cc_citys FOREIGN KEY(city_id) REFERENCES citys(id) ON DELETE CASCADE'
		
		execute 'ALTER TABLE citys_comments ADD CONSTRAINT fk_tb_cc_comments FOREIGN KEY(comment_id) REFERENCES comments(id) ON DELETE CASCADE'
	end

1 楼 vb2005xu 2009-12-03  

唉,还以为自己sql还行,谁知道就一垃圾,居然忘了 MYSQL表外键名称必须唯一,郁闷,找了1个小时,真废物啊