Select Code to Download

create table users (
    user_id    varchar(10) primary key,
...
go
insert misc (tag, val) values ('Turns_Per_Day', '5')
insert misc (tag, val) values ('Max_Turns_Allowed', '15')

create proc compute_turns_left
    @user_id varchar(10)
...
    update turns_left = @max_turns
        from users where user_id=@user_id and turns_left > @max_turns
go

create proc consume_turn
    @user_id varchar(10)
...
    update users set turns_left = turns_left-1, last_turn=getdate()
        where user_id=@user_id
go