Considerations

[shimanyi]

When a user answers a question, we need to check if he is in probation so that we give him/her a redeem question. Right ? so we have to check more than just the one fact that the user is either registered or not ...

[janja-janja]

@shimanyi Not really everytime they submit a question, cuz initially everyone's probation status will be 0 and will only change if they answer 3 incorrect times, so we need to keep count of failures for each user on the submissions table. What's ur thoughts?

[shimanyi]

True true, I made some changes on the database, i should forward it to git. I will do that right away. I have made some changes on the members table then I have added another table for redemptions.

[shimanyi]

Do we really need submissions table ?

[ikosenn]

@shims it's always good to log stuff and plus I think it can be used to determine the 20 winners

On 5 Mar 2015, at 11:43, shimanyi valentino notifications@github.com wrote:

Do we really need submissions table ?

—
Reply to this email directly or view it on GitHub.

[ikosenn]

I don't see the need of a probation table though. It's much easier to add it in the member table since we are not concerned with how many times one is in probation. On member_table maybe add is_prob and redeem_code.

On 5 Mar 2015, at 11:43, shimanyi valentino notifications@github.com wrote:

Do we really need submissions table ?

—
Reply to this email directly or view it on GitHub.

[janja-janja]

@gray-hat true treu. @shimanyi could you please check this!. ama you're way way deep into probations already ;D

[shimanyi]

@gray-hat makes sense but I have finished that whole probation table thing :( I was thinking we can add the first 20 guys to the list on the move and just award them. @denisKaranja I had gone too deep with that ...

[shimanyi]

It was a job well done guys!