All pastes #728253 Raw Edit

Someone

public text v1 · immutable
·published 2007-10-06 20:43 UTC
rendered paste body
users - user_id, user_name, IP, permissions, poll1 (used for rock, paper, scissors choice, etc), poll2, etc
user_history - user_id, clique_id, next_clique_id, points, move_history (this records loyal and traitor. it'll look like LLTLTL), majority_count (number of times on a majority team), minority_count (number of times on minority), next_group_vote (used to pick clique group of next round.)
user_relationships - player1, player2, number of times together (For player1 and player2, I'm thinking lower id goes in the player1 slot. That way, we don't have to search for both relationships later.)
cliques - clique_id, group_id, color_id, icon_id, current_multiplier (default 1), next_multiplier (default 1)
clique_groups - group_id, group_name
clique_names - group_id, clique_id (1-8), clique_name
clique_colors - color_id, color_hex
clique_icons - icon_id, icon_url
posts_news - news_id, news_date, news_title, news_body
posts_chat - chat_id, chat_date, user_is, user_body
awards - award_id, award_name, mult_value (in decimal. 1.0 is no change), award_history (in LLTTLT format), award_majority ( >= ), high_relationship ( >= ), low_relationship ( <= )
settings - current_round