| Index: trunk/extensions/SocialProfile/UserStats/user_stats.postgres.sql |
| — | — | @@ -0,0 +1,49 @@ |
| | 2 | +-- |
| | 3 | +-- Table structure for table `user_stats` |
| | 4 | +-- |
| | 5 | + |
| | 6 | +CREATE TABLE user_stats ( |
| | 7 | + stats_user_id INTEGER PRIMARY KEY NOT NULL DEFAULT 0, |
| | 8 | + stats_year_id INTEGER NOT NULL DEFAULT 0, |
| | 9 | + stats_user_name TEXT NOT NULL DEFAULT '', |
| | 10 | + stats_user_image_count INTEGER NOT NULL DEFAULT 0, |
| | 11 | + stats_comment_count INTEGER NOT NULL DEFAULT 0, |
| | 12 | + stats_comment_score INTEGER NOT NULL DEFAULT 0, |
| | 13 | + stats_comment_score_positive_rec INTEGER NOT NULL DEFAULT 0, |
| | 14 | + stats_comment_score_negative_rec INTEGER NOT NULL DEFAULT 0, |
| | 15 | + stats_comment_score_positive_given INTEGER NOT NULL DEFAULT 0, |
| | 16 | + stats_comment_score_negative_given INTEGER NOT NULL DEFAULT 0, |
| | 17 | + stats_comment_blocked INTEGER NOT NULL DEFAULT 0, |
| | 18 | + stats_vote_count INTEGER NOT NULL DEFAULT 0, |
| | 19 | + stats_edit_count INTEGER NOT NULL DEFAULT 0, |
| | 20 | + stats_opinions_created INTEGER NOT NULL DEFAULT 0, |
| | 21 | + stats_opinions_published INTEGER NOT NULL DEFAULT 0, |
| | 22 | + stats_referrals INTEGER NOT NULL DEFAULT 0, |
| | 23 | + stats_referrals_completed INTEGER NOT NULL DEFAULT 0, |
| | 24 | + stats_challenges_count INTEGER NOT NULL DEFAULT 0, |
| | 25 | + stats_challenges_won INTEGER NOT NULL DEFAULT 0, |
| | 26 | + stats_challenges_rating_positive INTEGER NOT NULL DEFAULT 0, |
| | 27 | + stats_challenges_rating_negative INTEGER NOT NULL DEFAULT 0, |
| | 28 | + stats_friends_count INTEGER NOT NULL DEFAULT 0, |
| | 29 | + stats_foe_count INTEGER NOT NULL DEFAULT 0, |
| | 30 | + stats_gifts_rec_count INTEGER NOT NULL DEFAULT 0, |
| | 31 | + stats_gifts_sent_count INTEGER NOT NULL DEFAULT 0, |
| | 32 | + stats_weekly_winner_count INTEGER NOT NULL DEFAULT 0, |
| | 33 | + stats_monthly_winner_count INTEGER NOT NULL DEFAULT 0, |
| | 34 | + stats_total_points INTEGER DEFAULT 0, |
| | 35 | + stats_overall_rank INTEGER NOT NULL DEFAULT 0, |
| | 36 | + up_complete INTEGER, |
| | 37 | + user_board_count INTEGER DEFAULT 0, |
| | 38 | + user_board_sent INTEGER DEFAULT 0, |
| | 39 | + user_board_count_priv INTEGER DEFAULT 0, |
| | 40 | + stats_picturegame_votes INTEGER DEFAULT 0, |
| | 41 | + stats_picturegame_created INTEGER DEFAULT 0, |
| | 42 | + user_status_count INTEGER DEFAULT 0, |
| | 43 | + stats_poll_votes INTEGER DEFAULT 0, |
| | 44 | + user_status_agree INTEGER DEFAULT 0, |
| | 45 | + stats_quiz_questions_answered INTEGER DEFAULT 0, |
| | 46 | + stats_quiz_questions_correct INTEGER DEFAULT 0, |
| | 47 | + stats_quiz_points INTEGER DEFAULT 0, |
| | 48 | + stats_quiz_questions_created INTEGER DEFAULT 0, |
| | 49 | + stats_quiz_questions_correct_percent FLOAT DEFAULT 0t |
| | 50 | +); |