setting default value while creating table in SQLite

I am working on SQLite. I want to create a table namely user_role with two column role_id and role_name. And there is an another table namely default that contain role_name and default_val.

I want to set Default value of role_id in the time of creating the table user_role and the Default value have to be retrieved from the table default.

I am new to SQLite and have to idea about the way to doing such recursive query. Please help.