bemicromax 10 - sdram CKE pinout needed or not ?

Instead of using an example for a different chip, try out some of the examples on http://www.alterawiki.com/wiki/bemicro_max_10 You will have better luck with these. I don't recommend porting a design to a different chip as a first project for a beginner. Start with an example written for your board and modify it in small steps. Save previous versions so you can go back if something doesn't turn out right.