· 7 years ago · Jan 14, 2019, 12:46 PM
1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version 5.1.48-community
5
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17--
18-- Create schema smf
19--
20
21CREATE DATABASE IF NOT EXISTS smf;
22USE smf;
23
24--
25-- Definition of table `zsmf_members`
26--
27
28DROP TABLE IF EXISTS `zsmf_members`;
29CREATE TABLE `zsmf_members` (
30 `id_member` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
31 `member_name` varchar(80) NOT NULL DEFAULT '',
32 `date_registered` int(10) unsigned NOT NULL DEFAULT '0',
33 `posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
34 `id_group` smallint(5) unsigned NOT NULL DEFAULT '0',
35 `lngfile` varchar(255) NOT NULL DEFAULT '',
36 `last_login` int(10) unsigned NOT NULL DEFAULT '0',
37 `real_name` varchar(255) NOT NULL DEFAULT '',
38 `instant_messages` smallint(5) NOT NULL DEFAULT '0',
39 `unread_messages` smallint(5) NOT NULL DEFAULT '0',
40 `new_pm` tinyint(3) unsigned NOT NULL DEFAULT '0',
41 `buddy_list` text NOT NULL,
42 `pm_ignore_list` varchar(255) NOT NULL DEFAULT '',
43 `pm_prefs` mediumint(8) NOT NULL DEFAULT '0',
44 `mod_prefs` varchar(20) NOT NULL DEFAULT '',
45 `message_labels` text NOT NULL,
46 `passwd` varchar(64) NOT NULL DEFAULT '',
47 `openid_uri` text NOT NULL,
48 `email_address` varchar(255) NOT NULL DEFAULT '',
49 `personal_text` varchar(255) NOT NULL DEFAULT '',
50 `gender` tinyint(4) unsigned NOT NULL DEFAULT '0',
51 `birthdate` date NOT NULL DEFAULT '0001-01-01',
52 `website_title` varchar(255) NOT NULL DEFAULT '',
53 `website_url` varchar(255) NOT NULL DEFAULT '',
54 `location` varchar(255) NOT NULL DEFAULT '',
55 `icq` varchar(255) NOT NULL DEFAULT '',
56 `aim` varchar(16) NOT NULL DEFAULT '',
57 `yim` varchar(32) NOT NULL DEFAULT '',
58 `msn` varchar(255) NOT NULL DEFAULT '',
59 `hide_email` tinyint(4) NOT NULL DEFAULT '0',
60 `show_online` tinyint(4) NOT NULL DEFAULT '1',
61 `time_format` varchar(80) NOT NULL DEFAULT '',
62 `signature` text NOT NULL,
63 `time_offset` float NOT NULL DEFAULT '0',
64 `avatar` varchar(255) NOT NULL DEFAULT '',
65 `pm_email_notify` tinyint(4) NOT NULL DEFAULT '0',
66 `karma_bad` smallint(5) unsigned NOT NULL DEFAULT '0',
67 `karma_good` smallint(5) unsigned NOT NULL DEFAULT '0',
68 `usertitle` varchar(255) NOT NULL DEFAULT '',
69 `notify_announcements` tinyint(4) NOT NULL DEFAULT '1',
70 `notify_regularity` tinyint(4) NOT NULL DEFAULT '1',
71 `notify_send_body` tinyint(4) NOT NULL DEFAULT '0',
72 `notify_types` tinyint(4) NOT NULL DEFAULT '2',
73 `member_ip` varchar(255) NOT NULL DEFAULT '',
74 `member_ip2` varchar(255) NOT NULL DEFAULT '',
75 `secret_question` varchar(255) NOT NULL DEFAULT '',
76 `secret_answer` varchar(64) NOT NULL DEFAULT '',
77 `id_theme` tinyint(4) unsigned NOT NULL DEFAULT '0',
78 `is_activated` tinyint(3) unsigned NOT NULL DEFAULT '1',
79 `validation_code` varchar(10) NOT NULL DEFAULT '',
80 `id_msg_last_visit` int(10) unsigned NOT NULL DEFAULT '0',
81 `additional_groups` varchar(255) NOT NULL DEFAULT '',
82 `smiley_set` varchar(48) NOT NULL DEFAULT '',
83 `id_post_group` smallint(5) unsigned NOT NULL DEFAULT '0',
84 `total_time_logged_in` int(10) unsigned NOT NULL DEFAULT '0',
85 `password_salt` varchar(255) NOT NULL DEFAULT '',
86 `ignore_boards` text NOT NULL,
87 `warning` tinyint(4) NOT NULL DEFAULT '0',
88 `passwd_flood` varchar(12) NOT NULL DEFAULT '',
89 `pm_receive_from` tinyint(3) unsigned NOT NULL DEFAULT '1',
90 PRIMARY KEY (`id_member`),
91 KEY `memberName` (`member_name`(30)),
92 KEY `date_registered` (`date_registered`),
93 KEY `id_group` (`id_group`),
94 KEY `birthdate` (`birthdate`),
95 KEY `posts` (`posts`),
96 KEY `last_login` (`last_login`),
97 KEY `lngfile` (`lngfile`(30)),
98 KEY `id_post_group` (`id_post_group`),
99 KEY `warning` (`warning`),
100 KEY `total_time_logged_in` (`total_time_logged_in`),
101 KEY `id_theme` (`id_theme`),
102 KEY `real_name` (`real_name`),
103 KEY `member_name` (`member_name`)
104) ENGINE=MyISAM AUTO_INCREMENT=24768 DEFAULT CHARSET=latin1;
105
106--
107-- Dumping data for table `zsmf_members`
108--
109
110/*!40000 ALTER TABLE `zsmf_members` DISABLE KEYS */;
111INSERT INTO `zsmf_members` (`id_member`,`member_name`,`date_registered`,`posts`,`id_group`,`lngfile`,`last_login`,`real_name`,`instant_messages`,`unread_messages`,`new_pm`,`buddy_list`,`pm_ignore_list`,`pm_prefs`,`mod_prefs`,`message_labels`,`passwd`,`openid_uri`,`email_address`,`personal_text`,`gender`,`birthdate`,`website_title`,`website_url`,`location`,`icq`,`aim`,`yim`,`msn`,`hide_email`,`show_online`,`time_format`,`signature`,`time_offset`,`avatar`,`pm_email_notify`,`karma_bad`,`karma_good`,`usertitle`,`notify_announcements`,`notify_regularity`,`notify_send_body`,`notify_types`,`member_ip`,`member_ip2`,`secret_question`,`secret_answer`,`id_theme`,`is_activated`,`validation_code`,`id_msg_last_visit`,`additional_groups`,`smiley_set`,`id_post_group`,`total_time_logged_in`,`password_salt`,`ignore_boards`,`warning`,`passwd_flood`,`pm_receive_from`) VALUES
112 (2,'thomy',1250442061,948,1,'',1312569307,'Thomy',11,1,1,'','',0,'','','344135759e02edb11eb2e327c6707863292ee02a','','emps@aon.at','',1,'0001-01-01','','','Austria','','','','',1,1,'','Don't send me private messages about your problems - Post in the appropriate forum section instead!',0,'',0,0,363,'Server Developer',1,1,0,2,'178.190.83.103','178.190.83.103','','',1,1,'ec99fb558e',665555,'17','',14,927605,'2cce','',0,'',0);
113/*!40000 ALTER TABLE `zsmf_members` ENABLE KEYS */;
114
115
116
117
118/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
119/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
120/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
121/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
122/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
123/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
124/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;