· 9 years ago · Jan 29, 2017, 12:48 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas wygenerowania: 29 Sty 2017, 13:44
7-- Wersja serwera: 5.5.32-cll
8-- Wersja PHP: 5.3.17
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Baza danych: `p484876_new`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `hia_members`
27--
28
29CREATE TABLE IF NOT EXISTS `hia_members` (
30 `member_id` mediumint(8) NOT NULL AUTO_INCREMENT,
31 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
32 `member_group_id` smallint(3) NOT NULL DEFAULT '0',
33 `email` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
34 `joined` int(10) NOT NULL DEFAULT '0',
35 `ip_address` varchar(46) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
36 `posts` mediumint(7) DEFAULT '0',
37 `title` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
38 `allow_admin_mails` tinyint(1) DEFAULT NULL,
39 `time_offset` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
40 `skin` smallint(5) DEFAULT NULL,
41 `warn_level` int(10) DEFAULT NULL,
42 `warn_lastwarn` int(10) NOT NULL DEFAULT '0',
43 `language` mediumint(4) DEFAULT NULL,
44 `last_post` int(10) DEFAULT NULL,
45 `restrict_post` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
46 `view_sigs` tinyint(1) DEFAULT '1',
47 `view_img` tinyint(1) DEFAULT '1',
48 `bday_day` int(2) DEFAULT NULL,
49 `bday_month` int(2) DEFAULT NULL,
50 `bday_year` int(4) DEFAULT NULL,
51 `msg_count_new` int(2) NOT NULL DEFAULT '0',
52 `msg_count_total` int(3) NOT NULL DEFAULT '0',
53 `msg_count_reset` int(1) NOT NULL DEFAULT '0',
54 `msg_show_notification` int(1) NOT NULL DEFAULT '0',
55 `misc` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
56 `last_visit` int(10) DEFAULT '0',
57 `last_activity` int(10) DEFAULT '0',
58 `dst_in_use` tinyint(1) DEFAULT '0',
59 `coppa_user` tinyint(1) DEFAULT '0',
60 `mod_posts` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
61 `auto_track` varchar(50) COLLATE utf8_unicode_ci DEFAULT '0',
62 `temp_ban` varchar(100) COLLATE utf8_unicode_ci DEFAULT '0',
63 `login_anonymous` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0&0',
64 `ignored_users` text COLLATE utf8_unicode_ci,
65 `mgroup_others` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
66 `org_perm_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
67 `member_login_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
68 `member_login_key_expire` int(10) NOT NULL DEFAULT '0',
69 `has_blog` text COLLATE utf8_unicode_ci,
70 `blogs_recache` tinyint(1) DEFAULT NULL,
71 `has_gallery` tinyint(1) NOT NULL DEFAULT '0',
72 `members_auto_dst` tinyint(1) NOT NULL DEFAULT '1',
73 `members_display_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
74 `members_seo_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
75 `members_created_remote` tinyint(1) NOT NULL DEFAULT '0',
76 `members_cache` mediumtext COLLATE utf8_unicode_ci,
77 `members_disable_pm` int(1) NOT NULL DEFAULT '0',
78 `members_l_display_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
79 `members_l_username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
80 `failed_logins` text COLLATE utf8_unicode_ci,
81 `failed_login_count` smallint(3) NOT NULL DEFAULT '0',
82 `members_profile_views` int(10) unsigned NOT NULL DEFAULT '0',
83 `members_pass_hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
84 `members_pass_salt` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
85 `member_banned` tinyint(1) NOT NULL DEFAULT '0',
86 `member_uploader` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
87 `members_bitoptions` int(10) unsigned NOT NULL DEFAULT '0',
88 `fb_uid` bigint(20) unsigned NOT NULL DEFAULT '0',
89 `fb_emailhash` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
90 `fb_lastsync` int(10) NOT NULL DEFAULT '0',
91 `members_day_posts` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0,0',
92 `live_id` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
93 `twitter_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
94 `twitter_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
95 `twitter_secret` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
96 `notification_cnt` mediumint(9) NOT NULL DEFAULT '0',
97 `tc_lastsync` int(10) NOT NULL DEFAULT '0',
98 `fb_session` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
99 `fb_token` text COLLATE utf8_unicode_ci,
100 `ips_mobile_token` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
101 `unacknowledged_warnings` tinyint(1) DEFAULT NULL,
102 `ipsconnect_id` int(10) NOT NULL DEFAULT '0',
103 `ipsconnect_revalidate_url` text COLLATE utf8_unicode_ci,
104 `desc` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Nie przydzielono ',
105 PRIMARY KEY (`member_id`),
106 KEY `members_l_display_name` (`members_l_display_name`),
107 KEY `members_l_username` (`members_l_username`),
108 KEY `mgroup` (`member_group_id`,`member_id`),
109 KEY `member_groups` (`member_group_id`,`mgroup_others`),
110 KEY `bday_day` (`bday_day`),
111 KEY `bday_month` (`bday_month`),
112 KEY `member_banned` (`member_banned`),
113 KEY `members_bitoptions` (`members_bitoptions`),
114 KEY `ip_address` (`ip_address`),
115 KEY `failed_login_count` (`failed_login_count`),
116 KEY `joined` (`joined`),
117 KEY `fb_uid` (`fb_uid`),
118 KEY `twitter_id` (`twitter_id`),
119 KEY `email` (`email`),
120 KEY `blogs_recache` (`blogs_recache`)
121) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=28 ;
122
123/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
124/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
125/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
126