-- -- Table structure for table `mm_approval_users` -- CREATE TABLE `mm_approval_users` ( `aid` int(10) NOT NULL auto_increment, `name` varchar(45) NOT NULL default '', `email` varchar(55) NOT NULL default '', `username` varchar(55) NOT NULL default '', `password` varchar(25) NOT NULL default '', `html` smallint(1) NOT NULL default '1', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` timestamp(14) NOT NULL, `expires` varchar(5) NOT NULL default '', `lists` varchar(100) NOT NULL default '', `verify_code` varchar(45) NOT NULL default '', `FIELD1` mediumtext NOT NULL, `FIELD2` mediumtext NOT NULL, `FIELD3` mediumtext NOT NULL, `FIELD4` mediumtext NOT NULL, `FIELD5` mediumtext NOT NULL, `FIELD6` mediumtext NOT NULL, `FIELD7` mediumtext NOT NULL, `FIELD8` mediumtext NOT NULL, `FIELD9` mediumtext NOT NULL, `FIELD10` mediumtext NOT NULL, `FIELD11` mediumtext NOT NULL, `FIELD12` mediumtext NOT NULL, `FIELD13` mediumtext NOT NULL, `FIELD14` mediumtext NOT NULL, `FIELD15` mediumtext NOT NULL, `FIELD16` mediumtext NOT NULL, `FIELD17` mediumtext NOT NULL, `FIELD18` mediumtext NOT NULL, `FIELD19` mediumtext NOT NULL, `FIELD20` mediumtext NOT NULL, `FIELD21` mediumtext NOT NULL, `FIELD22` mediumtext NOT NULL, `FIELD23` mediumtext NOT NULL, `FIELD24` mediumtext NOT NULL, `FIELD25` mediumtext NOT NULL, `FIELD26` mediumtext NOT NULL, `FIELD27` mediumtext NOT NULL, `FIELD28` mediumtext NOT NULL, `FIELD29` mediumtext NOT NULL, `FIELD30` mediumtext NOT NULL, `FIELD31` mediumtext NOT NULL, `FIELD32` mediumtext NOT NULL, `FIELD33` mediumtext NOT NULL, `FIELD34` mediumtext NOT NULL, `FIELD35` mediumtext NOT NULL, `FIELD36` mediumtext NOT NULL, `FIELD37` mediumtext NOT NULL, `FIELD38` mediumtext NOT NULL, `FIELD39` mediumtext NOT NULL, `FIELD40` mediumtext NOT NULL, `FIELD41` mediumtext NOT NULL, `FIELD42` mediumtext NOT NULL, `FIELD43` mediumtext NOT NULL, `FIELD44` mediumtext NOT NULL, `FIELD45` mediumtext NOT NULL, `FIELD46` mediumtext NOT NULL, `FIELD47` mediumtext NOT NULL, `FIELD48` mediumtext NOT NULL, `FIELD49` mediumtext NOT NULL, `FIELD50` mediumtext NOT NULL, PRIMARY KEY (`aid`), UNIQUE KEY `username` (`username`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Dumping data for table `mm_approval_users` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_custom_fields` -- CREATE TABLE `mm_custom_fields` ( `fid` int(10) NOT NULL auto_increment, `type` varchar(15) NOT NULL default '', `question` varchar(100) NOT NULL default '', `answers` varchar(255) NOT NULL default '', `default_value` varchar(50) NOT NULL default '', `sort` tinyint(2) NOT NULL default '0', `required` smallint(1) NOT NULL default '1', `required_description` varchar(255) NOT NULL default '', `editable` tinyint(1) NOT NULL default '1', `viewable` tinyint(1) NOT NULL default '1', `searchable` tinyint(1) NOT NULL default '1', `on_registration` tinyint(1) NOT NULL default '1', `in_profile` tinyint(1) NOT NULL default '0', `in_popup` tinyint(1) NOT NULL default '1', UNIQUE KEY `fid` (`fid`), KEY `sort` (`sort`) ) TYPE=MyISAM AUTO_INCREMENT=51 ; -- -- Dumping data for table `mm_custom_fields` -- INSERT INTO `mm_custom_fields` (`fid`, `type`, `question`, `answers`, `default_value`, `sort`, `required`, `required_description`, `editable`, `viewable`, `searchable`, `on_registration`, `in_profile`, `in_popup`) VALUES (1, '', '', '', '', 1, 0, '', 0, 0, 0, 0, 0, 0), (2, '', '', '', '', 2, 0, '', 0, 0, 0, 0, 0, 0), (3, '', '', '', '', 3, 0, '', 0, 0, 0, 0, 0, 0), (4, '', '', '', '', 4, 0, '', 0, 0, 0, 0, 0, 0), (5, '', '', '', '', 5, 0, '', 0, 0, 0, 0, 0, 0), (6, '', '', '', '', 6, 0, '', 0, 0, 0, 0, 0, 0), (7, '', '', '', '', 7, 0, '', 0, 0, 0, 0, 0, 0), (8, '', '', '', '', 8, 0, '', 0, 0, 0, 0, 0, 0), (9, '', '', '', '', 9, 0, '', 0, 0, 0, 0, 0, 0), (10, '', '', '', '', 10, 0, '', 0, 0, 0, 0, 0, 0), (11, '', '', '', '', 11, 0, '', 0, 0, 0, 0, 0, 1), (12, '', '', '', '', 12, 0, '', 0, 0, 0, 0, 0, 1), (13, '', '', '', '', 13, 0, '', 0, 0, 0, 0, 0, 1), (14, '', '', '', '', 14, 0, '', 0, 0, 0, 0, 0, 1), (15, '', '', '', '', 15, 0, '', 0, 0, 0, 0, 0, 1), (16, '', '', '', '', 16, 0, '', 0, 0, 0, 0, 0, 1), (17, '', '', '', '', 17, 0, '', 0, 0, 0, 0, 0, 1), (18, '', '', '', '', 18, 0, '', 0, 0, 0, 0, 0, 1), (19, '', '', '', '', 19, 0, '', 0, 0, 0, 0, 0, 1), (20, '', '', '', '', 20, 0, '', 0, 0, 0, 0, 0, 1), (21, '', '', '', '', 21, 1, '', 1, 1, 1, 0, 0, 1), (22, '', '', '', '', 22, 1, '', 1, 1, 1, 0, 0, 1), (23, '', '', '', '', 23, 1, '', 1, 1, 1, 0, 0, 1), (24, '', '', '', '', 24, 1, '', 1, 1, 1, 0, 0, 1), (25, '', '', '', '', 25, 1, '', 1, 1, 1, 0, 0, 1), (26, '', '', '', '', 26, 1, '', 1, 1, 1, 0, 0, 1), (27, '', '', '', '', 27, 1, '', 1, 1, 1, 0, 0, 1), (28, '', '', '', '', 28, 1, '', 1, 1, 1, 0, 0, 1), (29, '', '', '', '', 29, 1, '', 1, 1, 1, 0, 0, 1), (30, '', '', '', '', 30, 1, '', 1, 1, 1, 0, 0, 1), (31, '', '', '', '', 31, 1, '', 1, 1, 1, 0, 0, 1), (32, '', '', '', '', 32, 1, '', 1, 1, 1, 0, 0, 1), (33, '', '', '', '', 33, 1, '', 1, 1, 1, 0, 0, 1), (34, '', '', '', '', 34, 1, '', 1, 1, 1, 0, 0, 1), (35, '', '', '', '', 35, 1, '', 1, 1, 1, 0, 0, 1), (36, '', '', '', '', 36, 1, '', 1, 1, 1, 0, 0, 1), (37, '', '', '', '', 37, 1, '', 1, 1, 1, 0, 0, 1), (38, '', '', '', '', 38, 1, '', 1, 1, 1, 0, 0, 1), (39, '', '', '', '', 39, 1, '', 1, 1, 1, 0, 0, 1), (40, '', '', '', '', 40, 1, '', 1, 1, 1, 0, 0, 1), (41, '', '', '', '', 41, 1, '', 1, 1, 1, 0, 0, 1), (42, '', '', '', '', 42, 1, '', 1, 1, 1, 0, 0, 1), (43, '', '', '', '', 43, 1, '', 1, 1, 1, 0, 0, 1), (44, '', '', '', '', 44, 1, '', 1, 1, 1, 0, 0, 1), (45, '', '', '', '', 45, 1, '', 1, 1, 1, 0, 0, 1), (46, '', '', '', '', 46, 1, '', 1, 1, 1, 0, 0, 1), (47, '', '', '', '', 47, 1, '', 1, 1, 1, 0, 0, 1), (48, '', '', '', '', 48, 1, '', 1, 1, 1, 0, 0, 1), (49, '', '', '', '', 49, 1, '', 1, 1, 1, 0, 0, 1), (50, '', '', '', '', 50, 0, '', 1, 1, 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `mm_daily_log` -- CREATE TABLE `mm_daily_log` ( `username` varchar(55) NOT NULL default '', `ip` varchar(25) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table `mm_daily_log` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_daily_reports` -- CREATE TABLE `mm_daily_reports` ( `rid` int(10) NOT NULL auto_increment, `report` mediumtext NOT NULL, `report_date` date NOT NULL default '0000-00-00', UNIQUE KEY `rid` (`rid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Dumping data for table `mm_daily_reports` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_emails` -- CREATE TABLE `mm_emails` ( `name` varchar(255) NOT NULL default '', `description` varchar(45) NOT NULL default '', `subject` varchar(255) NOT NULL default '', `body` mediumtext NOT NULL, `html` smallint(1) NOT NULL default '1', `sort` tinyint(3) NOT NULL default '1', `cc_email` varchar(55) NOT NULL default '', `enabled` smallint(1) NOT NULL default '1', UNIQUE KEY `name` (`name`) ) TYPE=MyISAM; -- -- Dumping data for table `mm_emails` -- INSERT INTO `mm_emails` (`name`, `description`, `subject`, `body`, `html`, `sort`, `cc_email`, `enabled`) VALUES ('expired', 'Account Expired', 'Your Account has Expired', '

%name%,

Your account has expired. You no longer have access to our members only area.

Expired on: %expires%

%signature%

 

', 1, 10, '', 1), ('group_warning', 'User Group Expiration Warning', 'Upcoming Access Changes for Your Account', '

%name%,

Your account will no longer have access to %group_name% on %group_exp_date%

You can access your account using the link below:

%cp_url%?email_address=%email%&pass=%password%

%signature%

', 1, 9, '', 1), ('max_ips', 'Max Unique IP Logins Exceeded', 'Account inactived due to potential login abuse', '

Admin,

An account has been inactivated / flagged for potential abuse.

Account Owner: %name%

Username: %username%

e-Mail: %email%

Visit the administration back-end to view the logs and account.

 

', 1, 12, '', 1), ('warning', 'Expiration Warning', 'Your Account is Nearing Expiration', '

%name%,

Your account is set to expire on %expires%.

You can access your account using the link below:

%cp_url%?email_address=%email%&pass=%password%

%signature%

', 1, 8, 'jason@i2-services.com', 1), ('forgotten_pw', 'Forgotten Password', 'Your Requested Account Password', '

%name%,

You have requested your password for your account with us.

%signature%

 

', 1, 7, '', 1), ('approval', 'New Account to Approve', 'New Account Waiting Approval', '

PHP MM Administrator,

A new account has registered.

Membership Type: %membership_type%

Name: %name%

e-Mail: %email%

Username: %username%

Administration Link:   %admin_url%?_p=_approval_users

IP: %ip%
Host: %host%

 

', 1, 11, '', 1), ('created', 'Account Created', 'Your New Membership Account', '

Welcome %name%,

Your Account has been created.

Your e-Mail:  %email%
Your Username: %username%
Your Password: %password%
Account Expires: %expires%

You may access your account anytime at the following address:

%cp_url%?email_address=%email%&pass=%password%

%signature%

IP: %ip%
Host: %host%

', 1, 2, '', 1), ('user_unsubscribed', 'User Canceled', 'Confirmation: Your account has been canceled', '

%name%,

Your account has been successfully canceled. You no longer have access to our members only area.

Reason:

%unsubscribe_reason%

%signature%

', 1, 5, '', 1), ('confirm', 'Confirm / Verify Your Account', 'Please verify your account to complete registration', '

%name%,

We have received your registration.  Please click the link below to activate your account.

%cp_url%?verify=%verify_code%

Thanks and Welcome!

%signature%

 

', 1, 1, '', 1), ('inactivate', 'Account Inactivated', 'Your account has been Inactivated', '

%name%,

Your account has been inactivated.

%signature%

 

', 1, 4, '', 1), ('deleted', 'Account Canceled by Admin', 'Your Account has been canceled', '%name%,

You account has been canceled.

%signature%

 

 

', 1, 6, '', 1), ('updated', 'Account Updated', 'Your account has been updated', '

%name%,

Your account has been updated...

%cp_url% 

%signature%

', 1, 3, '', 1); -- -------------------------------------------------------- -- -- Table structure for table `mm_group_expirations` -- CREATE TABLE `mm_group_expirations` ( `ge_id` int(10) NOT NULL auto_increment, `username` varchar(55) NOT NULL default '', `groups` int(5) NOT NULL default '0', `expires` date NOT NULL default '0000-00-00', PRIMARY KEY (`ge_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Dumping data for table `mm_group_expirations` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_groups` -- CREATE TABLE `mm_groups` ( `username` char(55) NOT NULL default '0', `groups` smallint(3) NOT NULL default '0' ) TYPE=MyISAM; -- -- Dumping data for table `mm_groups` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_inactive_users` -- CREATE TABLE `mm_inactive_users` ( `iid` int(10) NOT NULL auto_increment, `name` varchar(45) NOT NULL default '', `email` varchar(55) NOT NULL default '', `username` varchar(55) NOT NULL default '', `password` varchar(25) NOT NULL default '', `html` smallint(1) NOT NULL default '1', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` timestamp(14) NOT NULL, `expires` date NOT NULL default '0000-00-00', `lists` varchar(100) NOT NULL default '', `inactive_reason` varchar(255) NOT NULL default '', `FIELD1` mediumtext NOT NULL, `FIELD2` mediumtext NOT NULL, `FIELD3` mediumtext NOT NULL, `FIELD4` mediumtext NOT NULL, `FIELD5` mediumtext NOT NULL, `FIELD6` mediumtext NOT NULL, `FIELD7` mediumtext NOT NULL, `FIELD8` mediumtext NOT NULL, `FIELD9` mediumtext NOT NULL, `FIELD10` mediumtext NOT NULL, `FIELD11` mediumtext NOT NULL, `FIELD12` mediumtext NOT NULL, `FIELD13` mediumtext NOT NULL, `FIELD14` mediumtext NOT NULL, `FIELD15` mediumtext NOT NULL, `FIELD16` mediumtext NOT NULL, `FIELD17` mediumtext NOT NULL, `FIELD18` mediumtext NOT NULL, `FIELD19` mediumtext NOT NULL, `FIELD20` mediumtext NOT NULL, `FIELD21` mediumtext NOT NULL, `FIELD22` mediumtext NOT NULL, `FIELD23` mediumtext NOT NULL, `FIELD24` mediumtext NOT NULL, `FIELD25` mediumtext NOT NULL, `FIELD26` mediumtext NOT NULL, `FIELD27` mediumtext NOT NULL, `FIELD28` mediumtext NOT NULL, `FIELD29` mediumtext NOT NULL, `FIELD30` mediumtext NOT NULL, `FIELD31` mediumtext NOT NULL, `FIELD32` mediumtext NOT NULL, `FIELD33` mediumtext NOT NULL, `FIELD34` mediumtext NOT NULL, `FIELD35` mediumtext NOT NULL, `FIELD36` mediumtext NOT NULL, `FIELD37` mediumtext NOT NULL, `FIELD38` mediumtext NOT NULL, `FIELD39` mediumtext NOT NULL, `FIELD40` mediumtext NOT NULL, `FIELD41` mediumtext NOT NULL, `FIELD42` mediumtext NOT NULL, `FIELD43` mediumtext NOT NULL, `FIELD44` mediumtext NOT NULL, `FIELD45` mediumtext NOT NULL, `FIELD46` mediumtext NOT NULL, `FIELD47` mediumtext NOT NULL, `FIELD48` mediumtext NOT NULL, `FIELD49` mediumtext NOT NULL, `FIELD50` mediumtext NOT NULL, PRIMARY KEY (`iid`), UNIQUE KEY `username` (`username`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Dumping data for table `mm_inactive_users` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_lists` -- CREATE TABLE `mm_lists` ( `id` int(10) NOT NULL auto_increment, `created` datetime NOT NULL default '0000-00-00 00:00:00', `name` varchar(180) NOT NULL default '', `description` mediumtext NOT NULL, `from_address` varchar(45) NOT NULL default '', `subject` varchar(180) NOT NULL default '', `body` mediumtext NOT NULL, `hidden` smallint(1) NOT NULL default '0', `html` smallint(1) NOT NULL default '1', `enable` char(1) NOT NULL default '', `group_exp_days` varchar(5) NOT NULL default '', `sort` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Dumping data for table `mm_lists` -- INSERT INTO `mm_lists` (`id`, `created`, `name`, `description`, `from_address`, `subject`, `body`, `hidden`, `html`, `enable`, `group_exp_days`, `sort`) VALUES (1, '2007-10-05 12:09:02', 'Premium Access', 'Access to premium areas of our web site.', 'your@email-address.com', 'Your Membership Account: Premium Access', '

%name%,

 Thanks for joining our premium package.  You have access to our entire site.

 e-Mail:  %email%

 Username: %username%

 Password: %password%

 Login at:  %cp_url%

 

', 0, 1, '1', '30', 0); -- -------------------------------------------------------- -- -- Table structure for table `mm_membership_types` -- CREATE TABLE `mm_membership_types` ( `pid` int(11) NOT NULL auto_increment, `name` mediumtext NOT NULL, `description` mediumtext NOT NULL, `price` varchar(10) NOT NULL default '', `groups` varchar(25) NOT NULL default '', `enabled` tinyint(1) NOT NULL default '0', `sort` tinyint(3) NOT NULL default '0', `gateway` varchar(50) NOT NULL default '', `type` varchar(20) NOT NULL default '', `account_days` varchar(5) NOT NULL default '', UNIQUE KEY `pid` (`pid`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Dumping data for table `mm_membership_types` -- INSERT INTO `mm_membership_types` (`pid`, `name`, `description`, `price`, `groups`, `enabled`, `sort`, `gateway`, `type`, `account_days`) VALUES (1, 'Free Membership', 'Join our site at no charge!', '', '', 1, 1, '', 'new', '0'); -- -------------------------------------------------------- -- -- Table structure for table `mm_payments` -- CREATE TABLE `mm_payments` ( `pid` int(11) NOT NULL auto_increment, `amount` decimal(10,2) NOT NULL default '0.00', `payment_date` date NOT NULL default '0000-00-00', `timestamp` timestamp(14) NOT NULL, `transaction_id` varchar(255) NOT NULL default '', `username` varchar(255) NOT NULL default '0', `processor` varchar(25) NOT NULL default '', PRIMARY KEY (`pid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Dumping data for table `mm_payments` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_pending_users` -- CREATE TABLE `mm_pending_users` ( `pid` int(10) NOT NULL auto_increment, `type_id` int(10) NOT NULL default '0', `type_code` varchar(40) NOT NULL default '', `name` varchar(45) NOT NULL default '', `email` varchar(55) NOT NULL default '', `username` varchar(55) NOT NULL default '', `password` varchar(25) NOT NULL default '', `html` smallint(1) NOT NULL default '1', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` timestamp(14) NOT NULL, `expires` varchar(5) NOT NULL default '', `lists` varchar(100) NOT NULL default '', `verify_code` varchar(45) NOT NULL default '', `FIELD1` mediumtext NOT NULL, `FIELD2` mediumtext NOT NULL, `FIELD3` mediumtext NOT NULL, `FIELD4` mediumtext NOT NULL, `FIELD5` mediumtext NOT NULL, `FIELD6` mediumtext NOT NULL, `FIELD7` mediumtext NOT NULL, `FIELD8` mediumtext NOT NULL, `FIELD9` mediumtext NOT NULL, `FIELD10` mediumtext NOT NULL, `FIELD11` mediumtext NOT NULL, `FIELD12` mediumtext NOT NULL, `FIELD13` mediumtext NOT NULL, `FIELD14` mediumtext NOT NULL, `FIELD15` mediumtext NOT NULL, `FIELD16` mediumtext NOT NULL, `FIELD17` mediumtext NOT NULL, `FIELD18` mediumtext NOT NULL, `FIELD19` mediumtext NOT NULL, `FIELD20` mediumtext NOT NULL, `FIELD21` mediumtext NOT NULL, `FIELD22` mediumtext NOT NULL, `FIELD23` mediumtext NOT NULL, `FIELD24` mediumtext NOT NULL, `FIELD25` mediumtext NOT NULL, `FIELD26` mediumtext NOT NULL, `FIELD27` mediumtext NOT NULL, `FIELD28` mediumtext NOT NULL, `FIELD29` mediumtext NOT NULL, `FIELD30` mediumtext NOT NULL, `FIELD31` mediumtext NOT NULL, `FIELD32` mediumtext NOT NULL, `FIELD33` mediumtext NOT NULL, `FIELD34` mediumtext NOT NULL, `FIELD35` mediumtext NOT NULL, `FIELD36` mediumtext NOT NULL, `FIELD37` mediumtext NOT NULL, `FIELD38` mediumtext NOT NULL, `FIELD39` mediumtext NOT NULL, `FIELD40` mediumtext NOT NULL, `FIELD41` mediumtext NOT NULL, `FIELD42` mediumtext NOT NULL, `FIELD43` mediumtext NOT NULL, `FIELD44` mediumtext NOT NULL, `FIELD45` mediumtext NOT NULL, `FIELD46` mediumtext NOT NULL, `FIELD47` mediumtext NOT NULL, `FIELD48` mediumtext NOT NULL, `FIELD49` mediumtext NOT NULL, `FIELD50` mediumtext NOT NULL, PRIMARY KEY (`pid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Dumping data for table `mm_pending_users` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_settings` -- CREATE TABLE `mm_settings` ( `name` varchar(255) NOT NULL default '', `setting` mediumtext NOT NULL, UNIQUE KEY `name` (`name`) ) TYPE=MyISAM; -- -- Dumping data for table `mm_settings` -- INSERT INTO `mm_settings` (`name`, `setting`) VALUES ('admin_url', 'http://www.your-domain.com/mm2/admin.php'), ('username', 'username'), ('password', 'password'), ('remember', '2592000'), ('cp_url', 'http://www.your-domain.com/mm2/control_panel.php'), ('org', 'PHP Membership Manager v2'), ('admin_email', 'your@your-domain.com'), ('batch_number', '1'), ('wait_time', '5'), ('html_email', '

Hi %name%,

  You live at %FIELD1%

 

'), ('group_warning_days', '5'), ('text_email', 'BYE'), ('default_days', ''), ('subscriber_options', '3'), ('wysiwyg', '1'), ('duplicate', '1'), ('warning_days', '2'), ('cycle_last_ran', '2007-10-04'), ('max_ips', '2'), ('signature', 'Your Company, Inc.
\r\nPhn: (###) ###-####
\r\nFax: (###) ###-####
\r\nWeb: http://www.your-company.com
\r\n'), ('install_url', 'http://www.your-domain.com/mm2'), ('attachment_email', 'putty.exe'), ('auth_profiles', '0'), ('request_username', '1'); -- -------------------------------------------------------- -- -- Table structure for table `mm_user_log` -- CREATE TABLE `mm_user_log` ( `username` varchar(55) NOT NULL default '', `ip` varchar(25) NOT NULL default '', `date` date NOT NULL default '0000-00-00', `timestamp` timestamp(14) NOT NULL ) TYPE=MyISAM; -- -- Dumping data for table `mm_user_log` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_users` -- CREATE TABLE `mm_users` ( `id` int(10) NOT NULL auto_increment, `name` varchar(45) NOT NULL default '', `email` varchar(55) NOT NULL default '', `username` varchar(55) NOT NULL default '', `password` varchar(25) NOT NULL default '', `html` smallint(1) NOT NULL default '1', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` timestamp(14) NOT NULL, `expires` date NOT NULL default '0000-00-00', `lists` varchar(100) NOT NULL default '', `FIELD1` mediumtext NOT NULL, `FIELD2` mediumtext NOT NULL, `FIELD3` mediumtext NOT NULL, `FIELD4` mediumtext NOT NULL, `FIELD5` mediumtext NOT NULL, `FIELD6` mediumtext NOT NULL, `FIELD7` mediumtext NOT NULL, `FIELD8` mediumtext NOT NULL, `FIELD9` mediumtext NOT NULL, `FIELD10` mediumtext NOT NULL, `FIELD11` mediumtext NOT NULL, `FIELD12` mediumtext NOT NULL, `FIELD13` mediumtext NOT NULL, `FIELD14` mediumtext NOT NULL, `FIELD15` mediumtext NOT NULL, `FIELD16` mediumtext NOT NULL, `FIELD17` mediumtext NOT NULL, `FIELD18` mediumtext NOT NULL, `FIELD19` mediumtext NOT NULL, `FIELD20` mediumtext NOT NULL, `FIELD21` mediumtext NOT NULL, `FIELD22` mediumtext NOT NULL, `FIELD23` mediumtext NOT NULL, `FIELD24` mediumtext NOT NULL, `FIELD25` mediumtext NOT NULL, `FIELD26` mediumtext NOT NULL, `FIELD27` mediumtext NOT NULL, `FIELD28` mediumtext NOT NULL, `FIELD29` mediumtext NOT NULL, `FIELD30` mediumtext NOT NULL, `FIELD31` mediumtext NOT NULL, `FIELD32` mediumtext NOT NULL, `FIELD33` mediumtext NOT NULL, `FIELD34` mediumtext NOT NULL, `FIELD35` mediumtext NOT NULL, `FIELD36` mediumtext NOT NULL, `FIELD37` mediumtext NOT NULL, `FIELD38` mediumtext NOT NULL, `FIELD39` mediumtext NOT NULL, `FIELD40` mediumtext NOT NULL, `FIELD41` mediumtext NOT NULL, `FIELD42` mediumtext NOT NULL, `FIELD43` mediumtext NOT NULL, `FIELD44` mediumtext NOT NULL, `FIELD45` mediumtext NOT NULL, `FIELD46` mediumtext NOT NULL, `FIELD47` mediumtext NOT NULL, `FIELD48` mediumtext NOT NULL, `FIELD49` mediumtext NOT NULL, `FIELD50` mediumtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Dumping data for table `mm_users` -- -- -------------------------------------------------------- -- -- Table structure for table `mm_users_extra_info` -- CREATE TABLE `mm_users_extra_info` ( `name` varchar(255) NOT NULL default '', `setting` mediumtext NOT NULL, `username` varchar(55) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table `mm_users_extra_info` -- -- -------------------------------------------------------- -- -- Table structure for table `session_data` -- CREATE TABLE `session_data` ( `session_id` varchar(32) NOT NULL default '', `http_user_agent` text NOT NULL, `session_data` blob NOT NULL, `session_expire` int(11) NOT NULL default '0', PRIMARY KEY (`session_id`) ) TYPE=MyISAM;