PHPMEMBER VER 0.1.0

• ChangeLog
• READ ME
• TODO
• SQL
• INSTALL
• Manifest
• Download
• Document
• Live Demo

# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : phpMember

# --------------------------------------------------------
#
# Table structure for table 'country'
#

CREATE TABLE country (
code char(2) NOT NULL,
name char(45) NOT NULL,
PRIMARY KEY (code)
);

#
# Dumping data for table 'country'
#

INSERT INTO country VALUES( 'US', 'United States');
INSERT INTO country VALUES( 'UK', 'United Kingdom');
INSERT INTO country VALUES( 'DE', 'Germany');
INSERT INTO country VALUES( 'AF', 'Afghanistan');
INSERT INTO country VALUES( 'AL', 'Albania');
INSERT INTO country VALUES( 'DZ', 'Algeria');
INSERT INTO country VALUES( 'AS', 'American Samoa');
INSERT INTO country VALUES( 'AD', 'Andorra');
INSERT INTO country VALUES( 'AO', 'Angola');
INSERT INTO country VALUES( 'AI', 'Anguilla');
INSERT INTO country VALUES( 'AQ', 'Antarctica');
INSERT INTO country VALUES( 'AG', 'Antigua And Barbuda');
INSERT INTO country VALUES( 'AR', 'Argentina');
INSERT INTO country VALUES( 'AM', 'Armenia');
INSERT INTO country VALUES( 'AW', 'Aruba');
INSERT INTO country VALUES( 'AU', 'Australia');
INSERT INTO country VALUES( 'AT', 'Austria');
INSERT INTO country VALUES( 'AZ', 'Azerbaijan');
INSERT INTO country VALUES( 'BS', 'Bahamas');
INSERT INTO country VALUES( 'BH', 'Bahrain');
INSERT INTO country VALUES( 'BD', 'Bangladesh');
INSERT INTO country VALUES( 'BB', 'Barbados');
INSERT INTO country VALUES( 'BY', 'Belarus');
INSERT INTO country VALUES( 'BE', 'Belgium');
INSERT INTO country VALUES( 'BZ', 'Belize');
INSERT INTO country VALUES( 'BJ', 'Benin');
INSERT INTO country VALUES( 'BM', 'Bermuda');
INSERT INTO country VALUES( 'BT', 'Bhutan');
INSERT INTO country VALUES( 'BO', 'Bolivia');
INSERT INTO country VALUES( 'BA', 'Bosnia Herzegowina');
INSERT INTO country VALUES( 'BW', 'Botswana');
INSERT INTO country VALUES( 'BV', 'Bouvet Island');
INSERT INTO country VALUES( 'BR', 'Brazil');
INSERT INTO country VALUES( 'IO', 'British Indian Ocean Territory');
INSERT INTO country VALUES( 'BN', 'Brunei Darussalam');
INSERT INTO country VALUES( 'BG', 'Bulgaria');
INSERT INTO country VALUES( 'BF', 'Burkina Faso');
INSERT INTO country VALUES( 'BI', 'Burundi');
INSERT INTO country VALUES( 'KH', 'Cambodia');
INSERT INTO country VALUES( 'CM', 'Cameroon');
INSERT INTO country VALUES( 'CA', 'Canada');
INSERT INTO country VALUES( 'CV', 'Cape Verde');
INSERT INTO country VALUES( 'KY', 'Cayman Islands');
INSERT INTO country VALUES( 'CF', 'Central African Republic');
INSERT INTO country VALUES( 'TD', 'Chad');
INSERT INTO country VALUES( 'CL', 'Chile');
INSERT INTO country VALUES( 'CN', 'China');
INSERT INTO country VALUES( 'CX', 'Christmas Island');
INSERT INTO country VALUES( 'CC', 'Cocos / Keeling Islands');
INSERT INTO country VALUES( 'CO', 'Colombia');
INSERT INTO country VALUES( 'KM', 'Comoros');
INSERT INTO country VALUES( 'CG', 'Congo');
INSERT INTO country VALUES( 'CD', 'Congo, the Democratic Republic of the');
INSERT INTO country VALUES( 'CK', 'Cook Islands');
INSERT INTO country VALUES( 'CR', 'Costa Rica');
INSERT INTO country VALUES( 'CI', 'Cote d\'Ivoire');
INSERT INTO country VALUES( 'HR', 'Croatia');
INSERT INTO country VALUES( 'CY', 'Cyprus');
INSERT INTO country VALUES( 'CZ', 'Czech Republic');
INSERT INTO country VALUES( 'DK', 'Denmark');
INSERT INTO country VALUES( 'DJ', 'Djibouti');
INSERT INTO country VALUES( 'DM', 'Dominica');
INSERT INTO country VALUES( 'DO', 'Dominican Republic');
INSERT INTO country VALUES( 'TP', 'East Timor');
INSERT INTO country VALUES( 'EC', 'Ecuador');
INSERT INTO country VALUES( 'EG', 'Egypt');
INSERT INTO country VALUES( 'SV', 'El Salvador');
INSERT INTO country VALUES( 'GQ', 'Equatorial Guinea');
INSERT INTO country VALUES( 'ER', 'Eritrea');
INSERT INTO country VALUES( 'EE', 'Estonia');
INSERT INTO country VALUES( 'ET', 'Ethiopia');
INSERT INTO country VALUES( 'FK', 'Falkland Islands');
INSERT INTO country VALUES( 'FO', 'Faroe Islands');
INSERT INTO country VALUES( 'FJ', 'Fiji');
INSERT INTO country VALUES( 'FI', 'Finland');
INSERT INTO country VALUES( 'FR', 'France');
INSERT INTO country VALUES( 'GF', 'French Guiana');
INSERT INTO country VALUES( 'PF', 'French Polynesia');
INSERT INTO country VALUES( 'TF', 'French Southern Territories');
INSERT INTO country VALUES( 'GA', 'Gabon');
INSERT INTO country VALUES( 'GM', 'Gambia');
INSERT INTO country VALUES( 'GE', 'Georgia');
INSERT INTO country VALUES( 'GH', 'Ghana');
INSERT INTO country VALUES( 'GI', 'Gibraltar');
INSERT INTO country VALUES( 'GR', 'Greece');
INSERT INTO country VALUES( 'GL', 'Greenland');
INSERT INTO country VALUES( 'GD', 'Grenada');
INSERT INTO country VALUES( 'GP', 'Guadeloupe');
INSERT INTO country VALUES( 'GU', 'Guam');
INSERT INTO country VALUES( 'GT', 'Guatemala');
INSERT INTO country VALUES( 'GN', 'Guinea');
INSERT INTO country VALUES( 'GW', 'Guinea-Bissau');
INSERT INTO country VALUES( 'GY', 'Guyana');
INSERT INTO country VALUES( 'HT', 'Haiti');
INSERT INTO country VALUES( 'HM', 'Heard and Mc Donald Islands');
INSERT INTO country VALUES( 'VA', 'Holy See / Vatican City State');
INSERT INTO country VALUES( 'HN', 'Honduras');
INSERT INTO country VALUES( 'HK', 'Hong Kong');
INSERT INTO country VALUES( 'HU', 'Hungary');
INSERT INTO country VALUES( 'IS', 'Iceland');
INSERT INTO country VALUES( 'IN', 'India');
INSERT INTO country VALUES( 'ID', 'Indonesia');
INSERT INTO country VALUES( 'IR', 'Iran, Islamic Republic Of');
INSERT INTO country VALUES( 'IQ', 'Iraq');
INSERT INTO country VALUES( 'IE', 'Ireland');
INSERT INTO country VALUES( 'IL', 'Israel');
INSERT INTO country VALUES( 'IT', 'Italy');
INSERT INTO country VALUES( 'JM', 'Jamaica');
INSERT INTO country VALUES( 'JP', 'Japan');
INSERT INTO country VALUES( 'JO', 'Jordan');
INSERT INTO country VALUES( 'KZ', 'Kazakhstan');
INSERT INTO country VALUES( 'KE', 'Kenya');
INSERT INTO country VALUES( 'KI', 'Kiribati');
INSERT INTO country VALUES( 'KP', 'Korea, Democratic People\'s Republic Of');
INSERT INTO country VALUES( 'KR', 'Korea, Republic of');
INSERT INTO country VALUES( 'KW', 'Kuwait');
INSERT INTO country VALUES( 'KG', 'Kyrgyzstan');
INSERT INTO country VALUES( 'LA', 'Lao People\'s Democratic Republic');
INSERT INTO country VALUES( 'LV', 'Latvia');
INSERT INTO country VALUES( 'LB', 'Lebanon');
INSERT INTO country VALUES( 'LS', 'Lesotho');
INSERT INTO country VALUES( 'LR', 'Liberia');
INSERT INTO country VALUES( 'LY', 'Libyan Arab Jamahiriya');
INSERT INTO country VALUES( 'LI', 'Liechtenstein');
INSERT INTO country VALUES( 'LT', 'Lithuania');
INSERT INTO country VALUES( 'LU', 'Luxembourg');
INSERT INTO country VALUES( 'MO', 'Macau');
INSERT INTO country VALUES( 'MK', 'Macedonia');
INSERT INTO country VALUES( 'MW', 'Malawi');
INSERT INTO country VALUES( 'MY', 'Malaysia');
INSERT INTO country VALUES( 'ML', 'Mali');
INSERT INTO country VALUES( 'MT', 'Malta');
INSERT INTO country VALUES( 'MH', 'Marshall Islands');
INSERT INTO country VALUES( 'MQ', 'Maldives');
INSERT INTO country VALUES( 'MR', 'Mauritania');
INSERT INTO country VALUES( 'MU', 'Mauritius');
INSERT INTO country VALUES( 'YT', 'Mayotte');
INSERT INTO country VALUES( 'MX', 'Mexico');
INSERT INTO country VALUES( 'FM', 'Micronesia, Federated States of');
INSERT INTO country VALUES( 'MD', 'Moldova, Republic of');
INSERT INTO country VALUES( 'MC', 'Monaco');
INSERT INTO country VALUES( 'MN', 'Mongolia');
INSERT INTO country VALUES( 'MS', 'Montserrat');
INSERT INTO country VALUES( 'MA', 'Morocco');
INSERT INTO country VALUES( 'MZ', 'Mozambique');
INSERT INTO country VALUES( 'MM', 'Myanmar');
INSERT INTO country VALUES( 'NA', 'Namibia');
INSERT INTO country VALUES( 'NR', 'Nauru');
INSERT INTO country VALUES( 'NP', 'Nepal');
INSERT INTO country VALUES( 'NL', 'Netherlands');
INSERT INTO country VALUES( 'AN', 'Netherlands Antilles');
INSERT INTO country VALUES( 'NC', 'New Caledonia');
INSERT INTO country VALUES( 'NZ', 'New Zealand');
INSERT INTO country VALUES( 'NI', 'Nicaragua');
INSERT INTO country VALUES( 'NE', 'Niger');
INSERT INTO country VALUES( 'NG', 'Nigeria');
INSERT INTO country VALUES( 'NU', 'Niue');
INSERT INTO country VALUES( 'NF', 'Norfolk Island');
INSERT INTO country VALUES( 'MP', 'Northern Mariana Islands');
INSERT INTO country VALUES( 'NO', 'Norway');
INSERT INTO country VALUES( 'OM', 'Oman');
INSERT INTO country VALUES( 'PK', 'Pakistan');
INSERT INTO country VALUES( 'PW', 'Palau');
INSERT INTO country VALUES( 'PA', 'Panama');
INSERT INTO country VALUES( 'PG', 'Papua New Guinea');
INSERT INTO country VALUES( 'PY', 'Paraguay');
INSERT INTO country VALUES( 'PE', 'Peru');
INSERT INTO country VALUES( 'PH', 'Philippines');
INSERT INTO country VALUES( 'PN', 'Pitcairn');
INSERT INTO country VALUES( 'PL', 'Poland');
INSERT INTO country VALUES( 'PT', 'Portugal');
INSERT INTO country VALUES( 'PR', 'Puerto Rico');
INSERT INTO country VALUES( 'QA', 'Qatar');
INSERT INTO country VALUES( 'RE', 'Reunion');
INSERT INTO country VALUES( 'RQ', 'Romania');
INSERT INTO country VALUES( 'RU', 'Russian Federation');
INSERT INTO country VALUES( 'RW', 'Rwanda');
INSERT INTO country VALUES( 'SH', 'Saint Helena');
INSERT INTO country VALUES( 'KN', 'Saint Kitts and Nevis');
INSERT INTO country VALUES( 'LC', 'Saint Lucia');
INSERT INTO country VALUES( 'PM', 'Saint Pierre and Miquelon');
INSERT INTO country VALUES( 'VC', 'Saint Vincent and the Grenadines');
INSERT INTO country VALUES( 'WS', 'Samoa');
INSERT INTO country VALUES( 'SM', 'San Marino');
INSERT INTO country VALUES( 'ST', 'Sao Tome and Principe');
INSERT INTO country VALUES( 'SA', 'Saudi Arabia');
INSERT INTO country VALUES( 'SN', 'Senegal');
INSERT INTO country VALUES( 'SC', 'Seychelles');
INSERT INTO country VALUES( 'SL', 'Sierra Leone');
INSERT INTO country VALUES( 'SG', 'Singapore');
INSERT INTO country VALUES( 'SK', 'Slovakia');
INSERT INTO country VALUES( 'SI', 'Solvenia');
INSERT INTO country VALUES( 'SB', 'Solomon Islands');
INSERT INTO country VALUES( 'SO', 'Somalia');
INSERT INTO country VALUES( 'ZA', 'South Africa');
INSERT INTO country VALUES( 'GS', 'South Georgia & The Sandwich Islands');
INSERT INTO country VALUES( 'ES', 'Spain');
INSERT INTO country VALUES( 'LK', 'Sri Lanka');
INSERT INTO country VALUES( 'SD', 'Sudan');
INSERT INTO country VALUES( 'SR', 'Suriname');
INSERT INTO country VALUES( 'SJ', 'Svalbard And Jan Mayen Islands');
INSERT INTO country VALUES( 'SZ', 'Swaziland');
INSERT INTO country VALUES( 'SE', 'Sweden');
INSERT INTO country VALUES( 'CH', 'Switzerland');
INSERT INTO country VALUES( 'SY', 'Syrian Arab Republic');
INSERT INTO country VALUES( 'TW', 'Taiwan, Province of China');
INSERT INTO country VALUES( 'TJ', 'Tajikistan');
INSERT INTO country VALUES( 'TZ', 'Tanzania, United Republic Of');
INSERT INTO country VALUES( 'TH', 'Thailand');
INSERT INTO country VALUES( 'TG', 'Togo');
INSERT INTO country VALUES( 'TK', 'Tokelau');
INSERT INTO country VALUES( 'TO', 'Tonga');
INSERT INTO country VALUES( 'TT', 'Trinidad and Tobago');
INSERT INTO country VALUES( 'TN', 'Tunisia');
INSERT INTO country VALUES( 'TR', 'Turkey');
INSERT INTO country VALUES( 'TM', 'Turkmenistan');
INSERT INTO country VALUES( 'TV', 'Turks and Caicos Islands');
INSERT INTO country VALUES( 'TC', 'Tuvalu');
INSERT INTO country VALUES( 'UG', 'Uganda');
INSERT INTO country VALUES( 'UA', 'Ukraine');
INSERT INTO country VALUES( 'AE', 'United Arab Emirates');

# --------------------------------------------------------
#
# Table structure for table 'member'
#

CREATE TABLE member_data (
member_id mediumint(7) unsigned DEFAULT '0' NOT NULL auto_increment,
active enum('disable','enable') DEFAULT 'disable' NOT NULL,
firstname char(24) NOT NULL,
lastname char(24) NOT NULL,
email char(32) NOT NULL,
login char(16) NOT NULL,
password char(16) NOT NULL,
occupation tinyint(2) DEFAULT '0' NOT NULL,
organization char(32) NOT NULL,
gender enum('male','female') DEFAULT 'male' NOT NULL,
birthdate date DEFAULT '0000-00-00' NOT NULL,
city char(16) NOT NULL,
zipcode char(8) NOT NULL,
state char(8) NOT NULL,
country char(2) NOT NULL,
website char(32) NOT NULL,
phone char(16) NOT NULL,
address char(64) NOT NULL,
createdate date DEFAULT '0000-00-00' NOT NULL,
PRIMARY KEY (member_id),
UNIQUE login (login),
KEY login_2 (login)
);

# --------------------------------------------------------
#
# Table structure for table 'occupation'
#

CREATE TABLE occupation (
occupation_id tinyint(2) DEFAULT '0' NOT NULL auto_increment,
occupation char(64) NOT NULL,
PRIMARY KEY (occupation_id)
);

#
# Dumping data for table 'occupation'
#

INSERT INTO occupation VALUES( '1', 'Accounting/Finance');
INSERT INTO occupation VALUES( '2', 'Computer related (IS, MIS, DP)');
INSERT INTO occupation VALUES( '3', 'Computer related (WWW)');
INSERT INTO occupation VALUES( '4', 'Consulting');
INSERT INTO occupation VALUES( '5', 'Customer service/support');
INSERT INTO occupation VALUES( '6', 'Education/training');
INSERT INTO occupation VALUES( '7', 'Engineering');
INSERT INTO occupation VALUES( '8', 'Executive/senior management');
INSERT INTO occupation VALUES( '9', 'General administrative/supervisory');
INSERT INTO occupation VALUES( '10', 'Government/Military');
INSERT INTO occupation VALUES( '11', 'Manufacturing/production/operations');
INSERT INTO occupation VALUES( '12', 'Professional services (medical, legal, etc.)');
INSERT INTO occupation VALUES( '13', 'Research and development');
INSERT INTO occupation VALUES( '14', 'Retired');
INSERT INTO occupation VALUES( '15', 'Sales/marketing/advertising');
INSERT INTO occupation VALUES( '16', 'Student');
INSERT INTO occupation VALUES( '17', 'Unemployed/Between Jobs');
INSERT INTO occupation VALUES( '18', 'Entertainer');
INSERT INTO occupation VALUES( '19', 'Artist');
INSERT INTO occupation VALUES( '20', 'Musician');
INSERT INTO occupation VALUES( '21', 'Entrepreneur');