0

hello everyone Richard here
i have a script that im having some issues with and was hoping to find someone here who can help me figure out the problem ok the script in php i get a notice when tryng to create an admin passowrd

"User not verified" im using tukanas freelance script
i can send the code if anybody interested
thanks

2
Contributors
3
Replies
5
Views
6 Years
Discussion Span
Last Post by smartmedia
0

heres the database thanks in advance

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 06, 2007 at 07:50 AM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
-- 
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `dbmastermain`
-- 

CREATE TABLE `dbmastermain` (
  `id` int(6) NOT NULL auto_increment,
  `mastername` varchar(255) NOT NULL default '',
  `tablename` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;

-- 
-- Dumping data for table `dbmastermain`
-- 

INSERT INTO `dbmastermain` VALUES (25, 'Gender', 'mast_gender');
INSERT INTO `dbmastermain` VALUES (24, 'Countries', 'mast_countryname');
INSERT INTO `dbmastermain` VALUES (21, 'Status', 'mast_status');
INSERT INTO `dbmastermain` VALUES (32, 'Nationality', 'mast_nationality');
INSERT INTO `dbmastermain` VALUES (34, 'Yes NO', 'mast_yesno');
INSERT INTO `dbmastermain` VALUES (67, 'Escrow Fee', 'mast_escrowfee');
INSERT INTO `dbmastermain` VALUES (66, 'Cancel Reason', 'mast_cancelreason');
INSERT INTO `dbmastermain` VALUES (65, 'Rating', 'mast_rating');
INSERT INTO `dbmastermain` VALUES (64, 'Reason', 'mast_reason');
INSERT INTO `dbmastermain` VALUES (63, 'Payment Type', 'mast_paymenttype');
INSERT INTO `dbmastermain` VALUES (62, 'provider Status', 'mast_pickproviderstatus');
INSERT INTO `dbmastermain` VALUES (61, 'Hide Option', 'mast_hideoption');
INSERT INTO `dbmastermain` VALUES (60, 'Database Type', 'mast_databasetype');
INSERT INTO `dbmastermain` VALUES (59, 'Budget Range', 'mast_budgetrange');
INSERT INTO `dbmastermain` VALUES (58, 'Email Notofication Type', 'mast_emailnotification');
INSERT INTO `dbmastermain` VALUES (57, 'Project Category Type', 'mast_pcategorytype');
INSERT INTO `dbmastermain` VALUES (68, 'Operating System', 'mast_opsystype');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_budgetrange`
-- 

CREATE TABLE `mast_budgetrange` (
  `id` int(6) NOT NULL auto_increment,
  `budgetrange` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `mast_budgetrange`
-- 

INSERT INTO `mast_budgetrange` VALUES (1, '200-300');
INSERT INTO `mast_budgetrange` VALUES (2, '400-500');
INSERT INTO `mast_budgetrange` VALUES (3, '$ 20-100');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_cancelreason`
-- 

CREATE TABLE `mast_cancelreason` (
  `id` int(6) NOT NULL auto_increment,
  `cancelreason` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `mast_cancelreason`
-- 

INSERT INTO `mast_cancelreason` VALUES (1, 'Mutual aggrement by both parties to cancel project.');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_countryname`
-- 

CREATE TABLE `mast_countryname` (
  `id` int(11) NOT NULL auto_increment,
  `countryname` text NOT NULL,
  `isdcode` int(11) NOT NULL default '0',
  `cr_rate` float NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=247 ;

-- 
-- Dumping data for table `mast_countryname`
-- 

INSERT INTO `mast_countryname` VALUES (39, 'Canada', 1, 1.5);
INSERT INTO `mast_countryname` VALUES (230, 'United States of America', 1, 1.5);
INSERT INTO `mast_countryname` VALUES (234, 'US Virgin Islands', 1, 1);
INSERT INTO `mast_countryname` VALUES (113, 'Kazakhstan', 7, 1.5);
INSERT INTO `mast_countryname` VALUES (183, 'Russia', 7, 1.5);
INSERT INTO `mast_countryname` VALUES (221, 'Tajikistan', 7, 1.5);
INSERT INTO `mast_countryname` VALUES (67, 'Egypt', 20, 1);
INSERT INTO `mast_countryname` VALUES (195, 'South Africa', 27, 1);
INSERT INTO `mast_countryname` VALUES (85, 'Greece', 30, 2.5);
INSERT INTO `mast_countryname` VALUES (161, 'Netherlands', 31, 2.5);
INSERT INTO `mast_countryname` VALUES (19, 'Belgium', 32, 1.5);
INSERT INTO `mast_countryname` VALUES (76, 'France', 33, 2.5);
INSERT INTO `mast_countryname` VALUES (196, 'Spain', 34, 2);
INSERT INTO `mast_countryname` VALUES (101, 'Hungary', 36, 2.5);
INSERT INTO `mast_countryname` VALUES (110, 'Italy', 39, 2);
INSERT INTO `mast_countryname` VALUES (182, 'Romania', 40, 1);
INSERT INTO `mast_countryname` VALUES (123, 'Liechtenstein', 41, 1.5);
INSERT INTO `mast_countryname` VALUES (199, 'Switzerland', 41, 1.5);
INSERT INTO `mast_countryname` VALUES (8, 'Austria', 43, 1);
INSERT INTO `mast_countryname` VALUES (233, 'United Kingdom', 44, 2);
INSERT INTO `mast_countryname` VALUES (61, 'Denmark', 45, 1);
INSERT INTO `mast_countryname` VALUES (212, 'Sweden', 46, 3);
INSERT INTO `mast_countryname` VALUES (159, 'Norway', 47, 1);
INSERT INTO `mast_countryname` VALUES (176, 'Poland', 48, 1);
INSERT INTO `mast_countryname` VALUES (91, 'Germany', 49, 2);
INSERT INTO `mast_countryname` VALUES (175, 'Peru', 51, 1.5);
INSERT INTO `mast_countryname` VALUES (147, 'Mexico', 52, 1);
INSERT INTO `mast_countryname` VALUES (59, 'Cuba', 53, 1);
INSERT INTO `mast_countryname` VALUES (12, 'Argentina', 54, 2.5);
INSERT INTO `mast_countryname` VALUES (23, 'Brazil', 55, 1.5);
INSERT INTO `mast_countryname` VALUES (42, 'Chile', 56, 1);
INSERT INTO `mast_countryname` VALUES (66, 'Easter Island', 56, 1);
INSERT INTO `mast_countryname` VALUES (44, 'Colombia', 57, 1.5);
INSERT INTO `mast_countryname` VALUES (237, 'Venezuela', 58, 1.5);
INSERT INTO `mast_countryname` VALUES (131, 'Malaysia', 60, 1);
INSERT INTO `mast_countryname` VALUES (14, 'Australia', 61, 3);
INSERT INTO `mast_countryname` VALUES (43, 'Christmas Island', 61, 1);
INSERT INTO `mast_countryname` VALUES (55, 'Cocos-Keeling Islands', 61, 1);
INSERT INTO `mast_countryname` VALUES (103, 'Indonesia', 62, 1);
INSERT INTO `mast_countryname` VALUES (171, 'Philippines', 63, 1);
INSERT INTO `mast_countryname` VALUES (53, 'Chatham Island (NewZealand)', 64, 3);
INSERT INTO `mast_countryname` VALUES (163, 'New Zealand', 64, 1);
INSERT INTO `mast_countryname` VALUES (206, 'Singapore', 65, 1);
INSERT INTO `mast_countryname` VALUES (222, 'Thailand', 66, 1);
INSERT INTO `mast_countryname` VALUES (115, 'Korea (South)', 82, 1);
INSERT INTO `mast_countryname` VALUES (209, 'South Korea', 82, 1.5);
INSERT INTO `mast_countryname` VALUES (239, 'Vietnam', 84, 1.5);
INSERT INTO `mast_countryname` VALUES (54, 'China (PRC)', 86, 1);
INSERT INTO `mast_countryname` VALUES (219, 'Turkey', 90, 2);
INSERT INTO `mast_countryname` VALUES (107, 'India', 91, 1);
INSERT INTO `mast_countryname` VALUES (168, 'Pakistan', 92, 1.5);
INSERT INTO `mast_countryname` VALUES (1, 'Afghanistan', 93, 1.5);
INSERT INTO `mast_countryname` VALUES (210, 'Sri Lanka', 94, 1);
INSERT INTO `mast_countryname` VALUES (36, 'Burma (Myanmar)', 95, 1);
INSERT INTO `mast_countryname` VALUES (140, 'Myanmar', 95, 1);
INSERT INTO `mast_countryname` VALUES (108, 'Iran', 98, 3);
INSERT INTO `mast_countryname` VALUES (139, 'Morocco', 212, 1);
INSERT INTO `mast_countryname` VALUES (2, 'Algeria', 213, 1.5);
INSERT INTO `mast_countryname` VALUES (225, 'Tunisia', 216, 2);
INSERT INTO `mast_countryname` VALUES (127, 'Libya', 218, 3);
INSERT INTO `mast_countryname` VALUES (90, 'Gambia', 220, 1);
INSERT INTO `mast_countryname` VALUES (204, 'Senegal', 221, 1.5);
INSERT INTO `mast_countryname` VALUES (134, 'Mauritania', 222, 1);
INSERT INTO `mast_countryname` VALUES (132, 'Mali Republic', 223, 1);
INSERT INTO `mast_countryname` VALUES (89, 'Guinea (PRP)', 224, 1);
INSERT INTO `mast_countryname` VALUES (106, 'Ivory Coast(C?ted''Ivoire)', 225, 1);
INSERT INTO `mast_countryname` VALUES (25, 'Burkina Faso', 226, 2);
INSERT INTO `mast_countryname` VALUES (164, 'Niger', 227, 1);
INSERT INTO `mast_countryname` VALUES (223, 'Togo', 228, 1);
INSERT INTO `mast_countryname` VALUES (20, 'Benin', 229, 2);
INSERT INTO `mast_countryname` VALUES (146, 'Mauritius', 230, 1);
INSERT INTO `mast_countryname` VALUES (122, 'Liberia', 231, 1);
INSERT INTO `mast_countryname` VALUES (192, 'Sierra Leone', 232, 2);
INSERT INTO `mast_countryname` VALUES (84, 'Ghana', 233, 1);
INSERT INTO `mast_countryname` VALUES (157, 'Nigeria', 234, 2);
INSERT INTO `mast_countryname` VALUES (41, 'Chad', 235, 1);
INSERT INTO `mast_countryname` VALUES (52, 'Central African Republic', 236, 1);
INSERT INTO `mast_countryname` VALUES (50, 'Cameroon', 237, 1);
INSERT INTO `mast_countryname` VALUES (51, 'Cape Verde Islands', 238, 1);
INSERT INTO `mast_countryname` VALUES (203, 'S?o Tom?and Principe', 239, 1);
INSERT INTO `mast_countryname` VALUES (68, 'Equatorial Guinea', 240, 1);
INSERT INTO `mast_countryname` VALUES (82, 'Gabon', 241, 2);
INSERT INTO `mast_countryname` VALUES (16, 'Bahamas', 242, 1);
INSERT INTO `mast_countryname` VALUES (37, 'Bahamas', 242, 1);
INSERT INTO `mast_countryname` VALUES (45, 'Congo', 242, 1);
INSERT INTO `mast_countryname` VALUES (10, 'Angola', 244, 1);
INSERT INTO `mast_countryname` VALUES (96, 'Guinea-Bissau', 245, 1);
INSERT INTO `mast_countryname` VALUES (28, 'Barbados', 246, 1);
INSERT INTO `mast_countryname` VALUES (64, 'Diego Garcia', 246, 1);
INSERT INTO `mast_countryname` VALUES (7, 'Ascension Island', 247, 1);
INSERT INTO `mast_countryname` VALUES (205, 'Seychelles Islands', 248, 1);
INSERT INTO `mast_countryname` VALUES (197, 'Sudan', 249, 1);
INSERT INTO `mast_countryname` VALUES (181, 'Rwanda', 250, 1);
INSERT INTO `mast_countryname` VALUES (73, 'Ethiopia', 251, 1);
INSERT INTO `mast_countryname` VALUES (208, 'Somalia', 252, 1);
INSERT INTO `mast_countryname` VALUES (62, 'Djibouti', 253, 1);
INSERT INTO `mast_countryname` VALUES (117, 'Kenya', 254, 1);
INSERT INTO `mast_countryname` VALUES (215, 'Tanzania', 255, 1);
INSERT INTO `mast_countryname` VALUES (228, 'Uganda', 256, 1);
INSERT INTO `mast_countryname` VALUES (26, 'Burundi', 257, 2);
INSERT INTO `mast_countryname` VALUES (151, 'Mozambique', 258, 1);
INSERT INTO `mast_countryname` VALUES (245, 'Zambia', 260, 1);
INSERT INTO `mast_countryname` VALUES (130, 'Madagascar', 261, 1);
INSERT INTO `mast_countryname` VALUES (179, 'R?union Island', 262, 3);
INSERT INTO `mast_countryname` VALUES (246, 'Zimbabwe', 263, 1.5);
INSERT INTO `mast_countryname` VALUES (4, 'Anguilla', 264, 1);
INSERT INTO `mast_countryname` VALUES (152, 'Namibia', 264, 1);
INSERT INTO `mast_countryname` VALUES (142, 'Malawi', 265, 1);
INSERT INTO `mast_countryname` VALUES (126, 'Lesotho', 266, 2);
INSERT INTO `mast_countryname` VALUES (33, 'Botswana', 267, 1);
INSERT INTO `mast_countryname` VALUES (5, 'Antigua', 268, 1);
INSERT INTO `mast_countryname` VALUES (18, 'Barbuda', 268, 1);
INSERT INTO `mast_countryname` VALUES (198, 'Swaziland', 268, 1);
INSERT INTO `mast_countryname` VALUES (56, 'Comoros', 269, 1);
INSERT INTO `mast_countryname` VALUES (135, 'Mayotte Island', 269, 1);
INSERT INTO `mast_countryname` VALUES (34, 'British Virgin Islands', 284, 1);
INSERT INTO `mast_countryname` VALUES (72, 'Eritrea', 291, 1);
INSERT INTO `mast_countryname` VALUES (13, 'Aruba', 297, 1.5);
INSERT INTO `mast_countryname` VALUES (74, 'Faeroe Islands', 298, 1);
INSERT INTO `mast_countryname` VALUES (93, 'Greenland', 299, 1);
INSERT INTO `mast_countryname` VALUES (40, 'Cayman Islands', 345, 1);
INSERT INTO `mast_countryname` VALUES (92, 'Gibraltar', 350, 1);
INSERT INTO `mast_countryname` VALUES (172, 'Portugal', 351, 1.5);
INSERT INTO `mast_countryname` VALUES (124, 'Luxembourg', 352, 1);
INSERT INTO `mast_countryname` VALUES (109, 'Ireland', 353, 1);
INSERT INTO `mast_countryname` VALUES (102, 'Iceland', 354, 1);
INSERT INTO `mast_countryname` VALUES (144, 'Malta', 356, 1);
INSERT INTO `mast_countryname` VALUES (60, 'Cyprus', 357, 1);
INSERT INTO `mast_countryname` VALUES (79, 'Finland', 358, 2);
INSERT INTO `mast_countryname` VALUES (35, 'Bulgaria', 359, 1);
INSERT INTO `mast_countryname` VALUES (128, 'Lithuania', 370, 1);
INSERT INTO `mast_countryname` VALUES (125, 'Latvia', 371, 1);
INSERT INTO `mast_countryname` VALUES (69, 'Estonia', 372, 1);
INSERT INTO `mast_countryname` VALUES (137, 'Moldova', 373, 1);
INSERT INTO `mast_countryname` VALUES (6, 'Armenia', 374, 1);
INSERT INTO `mast_countryname` VALUES (29, 'Belarus', 375, 1);
INSERT INTO `mast_countryname` VALUES (3, 'Andorra', 376, 1);
INSERT INTO `mast_countryname` VALUES (238, 'Vatican City', 376, 1);
INSERT INTO `mast_countryname` VALUES (149, 'Monaco', 377, 1);
INSERT INTO `mast_countryname` VALUES (189, 'San Marino', 378, 1);
INSERT INTO `mast_countryname` VALUES (232, 'Ukraine', 380, 1.5);
INSERT INTO `mast_countryname` VALUES (191, 'Serbia', 381, 1.5);
INSERT INTO `mast_countryname` VALUES (244, 'Yugoslavia', 381, 1);
INSERT INTO `mast_countryname` VALUES (47, 'Croatia', 385, 1);
INSERT INTO `mast_countryname` VALUES (207, 'Slovenia', 386, 1);
INSERT INTO `mast_countryname` VALUES (22, 'Bosnia & Herzogovina', 387, 1);
INSERT INTO `mast_countryname` VALUES (141, 'Macedonia (former Yugoslav Rep.)', 389, 1.5);
INSERT INTO `mast_countryname` VALUES (49, 'Czech Republic', 420, 1);
INSERT INTO `mast_countryname` VALUES (193, 'Slovak Republic', 421, 1);
INSERT INTO `mast_countryname` VALUES (31, 'Bermuda', 441, 1);
INSERT INTO `mast_countryname` VALUES (86, 'Grenada', 473, 1);
INSERT INTO `mast_countryname` VALUES (78, 'Falkland Islands', 500, 1);
INSERT INTO `mast_countryname` VALUES (30, 'Belize', 501, 1.5);
INSERT INTO `mast_countryname` VALUES (88, 'Guatemala', 502, 1);
INSERT INTO `mast_countryname` VALUES (71, 'El Salvador', 503, 1.5);
INSERT INTO `mast_countryname` VALUES (100, 'Honduras', 504, 1);
INSERT INTO `mast_countryname` VALUES (156, 'Nicaragua', 505, 1);
INSERT INTO `mast_countryname` VALUES (58, 'Costa Rica', 506, 1);
INSERT INTO `mast_countryname` VALUES (169, 'Panama', 507, 1);
INSERT INTO `mast_countryname` VALUES (201, 'St.Pierre & Miquelon', 508, 1);
INSERT INTO `mast_countryname` VALUES (98, 'Haiti', 509, 1);
INSERT INTO `mast_countryname` VALUES (94, 'Guadeloupe', 590, 1);
INSERT INTO `mast_countryname` VALUES (32, 'Bolivia', 591, 1);
INSERT INTO `mast_countryname` VALUES (97, 'Guyana', 592, 2.5);
INSERT INTO `mast_countryname` VALUES (70, 'Ecuador', 593, 1);
INSERT INTO `mast_countryname` VALUES (77, 'French Guiana', 594, 1);
INSERT INTO `mast_countryname` VALUES (170, 'Paraguay', 595, 1);
INSERT INTO `mast_countryname` VALUES (80, 'French Antilles', 596, 1);
INSERT INTO `mast_countryname` VALUES (145, 'Martinique', 596, 1);
INSERT INTO `mast_countryname` VALUES (211, 'Suriname', 597, 1);
INSERT INTO `mast_countryname` VALUES (231, 'Uruguay', 598, 1);
INSERT INTO `mast_countryname` VALUES (154, 'Netherlands Antilles', 599, 1);
INSERT INTO `mast_countryname` VALUES (220, 'Turksand Caicos Islands', 649, 1);
INSERT INTO `mast_countryname` VALUES (150, 'Montserrat', 664, 1);
INSERT INTO `mast_countryname` VALUES (87, 'Guam', 670, 1);
INSERT INTO `mast_countryname` VALUES (180, 'Rota Island', 670, 1);
INSERT INTO `mast_countryname` VALUES (202, 'Saipan Island', 670, 1);
INSERT INTO `mast_countryname` VALUES (216, 'Tinian Island', 670, 1);
INSERT INTO `mast_countryname` VALUES (11, 'Antarctica', 672, 1);
INSERT INTO `mast_countryname` VALUES (158, 'Norfolk Island', 672, 1);
INSERT INTO `mast_countryname` VALUES (24, 'Brunei', 673, 1);
INSERT INTO `mast_countryname` VALUES (160, 'Nauru', 674, 1);
INSERT INTO `mast_countryname` VALUES (174, 'Papua New Guinea', 675, 1);
INSERT INTO `mast_countryname` VALUES (224, 'Tonga Islands', 676, 1);
INSERT INTO `mast_countryname` VALUES (194, 'Solomon Islands', 677, 1);
INSERT INTO `mast_countryname` VALUES (236, 'Vanuatu', 678, 1);
INSERT INTO `mast_countryname` VALUES (75, 'Fiji Islands', 679, 1);
INSERT INTO `mast_countryname` VALUES (173, 'Palau', 680, 1);
INSERT INTO `mast_countryname` VALUES (242, 'Wallisand Futuna Islands', 681, 1);
INSERT INTO `mast_countryname` VALUES (46, 'Cook Islands', 682, 1);
INSERT INTO `mast_countryname` VALUES (165, 'Niue', 683, 1);
INSERT INTO `mast_countryname` VALUES (9, 'American Samoa', 684, 1);
INSERT INTO `mast_countryname` VALUES (241, 'Western Samoa', 685, 1);
INSERT INTO `mast_countryname` VALUES (114, 'Kiribati', 686, 1);
INSERT INTO `mast_countryname` VALUES (155, 'New Caledonia', 687, 3);
INSERT INTO `mast_countryname` VALUES (227, 'Tuvalu', 688, 1);
INSERT INTO `mast_countryname` VALUES (81, 'French Polynesia', 689, 1);
INSERT INTO `mast_countryname` VALUES (217, 'Tokelau', 690, 1);
INSERT INTO `mast_countryname` VALUES (136, 'Micronesia', 691, 1);
INSERT INTO `mast_countryname` VALUES (133, 'Marshall Islands', 692, 1);
INSERT INTO `mast_countryname` VALUES (65, 'Dominica', 767, 1);
INSERT INTO `mast_countryname` VALUES (177, 'Puerto Rico', 787, 1);
INSERT INTO `mast_countryname` VALUES (148, 'Midway Island', 808, 1);
INSERT INTO `mast_countryname` VALUES (240, 'Wake Island', 808, 1);
INSERT INTO `mast_countryname` VALUES (63, 'Dominican Republic', 809, 1);
INSERT INTO `mast_countryname` VALUES (188, 'St. Vincent & Grenadines', 809, 1);
INSERT INTO `mast_countryname` VALUES (118, 'Korea (North)', 850, 1);
INSERT INTO `mast_countryname` VALUES (166, 'North Korea', 850, 1);
INSERT INTO `mast_countryname` VALUES (99, 'Hong Kong', 852, 1);
INSERT INTO `mast_countryname` VALUES (129, 'Macau', 853, 1);
INSERT INTO `mast_countryname` VALUES (38, 'Cambodia', 855, 1);
INSERT INTO `mast_countryname` VALUES (120, 'Laos', 856, 1);
INSERT INTO `mast_countryname` VALUES (218, 'Trinidad & Tobago', 868, 1);
INSERT INTO `mast_countryname` VALUES (162, 'Nevis', 869, 1);
INSERT INTO `mast_countryname` VALUES (200, 'St.Kitts/Nevis', 869, 1);
INSERT INTO `mast_countryname` VALUES (111, 'Jamaica', 876, 1);
INSERT INTO `mast_countryname` VALUES (17, 'Bangladesh', 880, 2);
INSERT INTO `mast_countryname` VALUES (214, 'Taiwan', 886, 1);
INSERT INTO `mast_countryname` VALUES (143, 'Maldives', 960, 1);
INSERT INTO `mast_countryname` VALUES (121, 'Lebanon', 961, 1);
INSERT INTO `mast_countryname` VALUES (112, 'Jordan', 962, 1);
INSERT INTO `mast_countryname` VALUES (213, 'Syria', 963, 1);
INSERT INTO `mast_countryname` VALUES (104, 'Iraq', 964, 1.5);
INSERT INTO `mast_countryname` VALUES (119, 'Kuwait', 965, 1);
INSERT INTO `mast_countryname` VALUES (190, 'Saudi Arabia', 966, 1);
INSERT INTO `mast_countryname` VALUES (243, 'Yemen', 967, 1);
INSERT INTO `mast_countryname` VALUES (167, 'Oman', 968, 1);
INSERT INTO `mast_countryname` VALUES (229, 'United Arab Emirates', 971, 1);
INSERT INTO `mast_countryname` VALUES (105, 'Israel', 972, 1);
INSERT INTO `mast_countryname` VALUES (27, 'Bahrain', 973, 1);
INSERT INTO `mast_countryname` VALUES (178, 'Qatar', 974, 1);
INSERT INTO `mast_countryname` VALUES (21, 'Bhutan', 975, 1);
INSERT INTO `mast_countryname` VALUES (138, 'Mongolia', 976, 1);
INSERT INTO `mast_countryname` VALUES (153, 'Nepal', 977, 1);
INSERT INTO `mast_countryname` VALUES (226, 'Turkmenistan', 993, 1);
INSERT INTO `mast_countryname` VALUES (15, 'Azerbaijan', 994, 1);
INSERT INTO `mast_countryname` VALUES (83, 'Georgia', 995, 1);
INSERT INTO `mast_countryname` VALUES (116, 'Kyrgyz Republic', 996, 1);
INSERT INTO `mast_countryname` VALUES (235, 'Uzbekistan', 998, 1);
INSERT INTO `mast_countryname` VALUES (48, 'Cuba (GuantanamoBay)', 5399, 1);
INSERT INTO `mast_countryname` VALUES (95, 'Guantanamo Bay', 5399, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_databasetype`
-- 

CREATE TABLE `mast_databasetype` (
  `id` int(6) NOT NULL auto_increment,
  `databasetype` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- 
-- Dumping data for table `mast_databasetype`
-- 

INSERT INTO `mast_databasetype` VALUES (1, 'MYSQL');
INSERT INTO `mast_databasetype` VALUES (2, 'MS-SQL');
INSERT INTO `mast_databasetype` VALUES (4, 'Postgres');
INSERT INTO `mast_databasetype` VALUES (6, 'mysql');
INSERT INTO `mast_databasetype` VALUES (9, '-Uncertain-');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_emailnotification`
-- 

CREATE TABLE `mast_emailnotification` (
  `id` int(6) NOT NULL auto_increment,
  `emailnotification` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `mast_emailnotification`
-- 

INSERT INTO `mast_emailnotification` VALUES (1, 'HTML');
INSERT INTO `mast_emailnotification` VALUES (2, 'TEXT');
INSERT INTO `mast_emailnotification` VALUES (3, 'Sheetal project');
INSERT INTO `mast_emailnotification` VALUES (4, 'SonalV');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_escrowfee`
-- 

CREATE TABLE `mast_escrowfee` (
  `id` int(6) NOT NULL auto_increment,
  `escrowfee` varchar(20) NOT NULL default '',
  `url` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `mast_escrowfee`
-- 

INSERT INTO `mast_escrowfee` VALUES (1, 'Paypal', 'http://www.paypal.com');
INSERT INTO `mast_escrowfee` VALUES (2, 'Moneybookers', 'http://www.moneybookers.com');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_gender`
-- 

CREATE TABLE `mast_gender` (
  `id` int(6) NOT NULL auto_increment,
  `gender` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `mast_gender`
-- 

INSERT INTO `mast_gender` VALUES (1, 'Male');
INSERT INTO `mast_gender` VALUES (2, 'Female');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_hideoption`
-- 

CREATE TABLE `mast_hideoption` (
  `id` int(6) NOT NULL auto_increment,
  `hideoption` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `mast_hideoption`
-- 

INSERT INTO `mast_hideoption` VALUES (1, 'I want my project to be listed as a featured project. ($25 cost). Recommended!');
INSERT INTO `mast_hideoption` VALUES (2, 'I want to hide all bids on my project from other users. To view bids you must login.($3 cost)');
INSERT INTO `mast_hideoption` VALUES (3, 'I want my project to be for gold  members only.');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_memshiptype`
-- 

CREATE TABLE `mast_memshiptype` (
  `id` int(6) NOT NULL auto_increment,
  `memshiptype` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `mast_memshiptype`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `mast_nationality`
-- 

CREATE TABLE `mast_nationality` (
  `id` int(6) NOT NULL auto_increment,
  `nationality` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `mast_nationality`
-- 

INSERT INTO `mast_nationality` VALUES (1, 'Indian');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_opsystype`
-- 

CREATE TABLE `mast_opsystype` (
  `id` int(6) NOT NULL auto_increment,
  `opsystype` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `mast_opsystype`
-- 

INSERT INTO `mast_opsystype` VALUES (1, 'WinNT');
INSERT INTO `mast_opsystype` VALUES (2, 'Linux');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_paymenttype`
-- 

CREATE TABLE `mast_paymenttype` (
  `id` int(6) NOT NULL auto_increment,
  `paymenttype` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `mast_paymenttype`
-- 

INSERT INTO `mast_paymenttype` VALUES (1, 'cpm');
INSERT INTO `mast_paymenttype` VALUES (2, 'cpc');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_pcategorytype`
-- 

CREATE TABLE `mast_pcategorytype` (
  `id` int(11) NOT NULL auto_increment,
  `pcategorytype` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

-- 
-- Dumping data for table `mast_pcategorytype`
-- 

INSERT INTO `mast_pcategorytype` VALUES (8, '.NET');
INSERT INTO `mast_pcategorytype` VALUES (9, 'AudioServices');
INSERT INTO `mast_pcategorytype` VALUES (10, 'Banner Design');
INSERT INTO `mast_pcategorytype` VALUES (11, 'C/C++');
INSERT INTO `mast_pcategorytype` VALUES (12, 'Cold  Fusion');
INSERT INTO `mast_pcategorytype` VALUES (13, 'Copywriting');
INSERT INTO `mast_pcategorytype` VALUES (14, 'Data Entry');
INSERT INTO `mast_pcategorytype` VALUES (15, 'Data Processing');
INSERT INTO `mast_pcategorytype` VALUES (16, 'Delphi');
INSERT INTO `mast_pcategorytype` VALUES (17, 'Flash');
INSERT INTO `mast_pcategorytype` VALUES (18, 'Graphic Design');
INSERT INTO `mast_pcategorytype` VALUES (19, 'Java');
INSERT INTO `mast_pcategorytype` VALUES (20, 'Javascript');
INSERT INTO `mast_pcategorytype` VALUES (21, 'JSP');
INSERT INTO `mast_pcategorytype` VALUES (22, 'Legal Advice');
INSERT INTO `mast_pcategorytype` VALUES (23, 'Link Building');
INSERT INTO `mast_pcategorytype` VALUES (24, 'Linux');
INSERT INTO `mast_pcategorytype` VALUES (25, 'Logo Design');
INSERT INTO `mast_pcategorytype` VALUES (26, 'Perl/CGI');
INSERT INTO `mast_pcategorytype` VALUES (27, 'Photography');
INSERT INTO `mast_pcategorytype` VALUES (28, 'PHP');
INSERT INTO `mast_pcategorytype` VALUES (29, 'Project Management');
INSERT INTO `mast_pcategorytype` VALUES (30, 'Python');
INSERT INTO `mast_pcategorytype` VALUES (31, 'Script Installation');
INSERT INTO `mast_pcategorytype` VALUES (32, 'SEO');
INSERT INTO `mast_pcategorytype` VALUES (33, 'System Admin');
INSERT INTO `mast_pcategorytype` VALUES (34, 'Website Design');
INSERT INTO `mast_pcategorytype` VALUES (35, 'Website Security');
INSERT INTO `mast_pcategorytype` VALUES (36, 'Windows');
INSERT INTO `mast_pcategorytype` VALUES (37, 'Web Promotion');
INSERT INTO `mast_pcategorytype` VALUES (38, 'Wireless');
INSERT INTO `mast_pcategorytype` VALUES (39, 'XML');
INSERT INTO `mast_pcategorytype` VALUES (40, 'ASP');
INSERT INTO `mast_pcategorytype` VALUES (41, 'PHP');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_pickproviderstatus`
-- 

CREATE TABLE `mast_pickproviderstatus` (
  `id` int(6) NOT NULL auto_increment,
  `pickproviderstatus` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `mast_pickproviderstatus`
-- 

INSERT INTO `mast_pickproviderstatus` VALUES (1, 'Waiting');
INSERT INTO `mast_pickproviderstatus` VALUES (2, 'Accept');
INSERT INTO `mast_pickproviderstatus` VALUES (3, 'Deny');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_rating`
-- 

CREATE TABLE `mast_rating` (
  `id` int(6) NOT NULL auto_increment,
  `rating` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- 
-- Dumping data for table `mast_rating`
-- 

INSERT INTO `mast_rating` VALUES (1, '1');
INSERT INTO `mast_rating` VALUES (2, '2');
INSERT INTO `mast_rating` VALUES (3, '3');
INSERT INTO `mast_rating` VALUES (4, '4');
INSERT INTO `mast_rating` VALUES (5, '5');
INSERT INTO `mast_rating` VALUES (6, '6');
INSERT INTO `mast_rating` VALUES (7, '7');
INSERT INTO `mast_rating` VALUES (8, '8');
INSERT INTO `mast_rating` VALUES (9, '9');
INSERT INTO `mast_rating` VALUES (10, '10');
INSERT INTO `mast_rating` VALUES (11, '11');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_reason`
-- 

CREATE TABLE `mast_reason` (
  `id` int(6) NOT NULL auto_increment,
  `reason` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `mast_reason`
-- 

INSERT INTO `mast_reason` VALUES (1, 'Posting contact information');
INSERT INTO `mast_reason` VALUES (2, 'Advertising another website');
INSERT INTO `mast_reason` VALUES (3, 'Non-featured project posted requiring abnormal bidding');
INSERT INTO `mast_reason` VALUES (4, 'Other');

-- --------------------------------------------------------

-- 
-- Table structure for table `mast_status`
-- 

CREATE TABLE `mast_status` (
  `id` int(11) NOT NULL auto_increment,
  `status` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- 
-- Dumping data for table `mast_status`
-- 

INSERT INTO `mast_status` VALUES (1, 'OPEN');
INSERT INTO `mast_status` VALUES (2, 'CLOSED');
INSERT INTO `mast_status` VALUES (9, 'FROZEN');
INSERT INTO `mast_status` VALUES (8, 'CANCEL');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_additionalprojectupload`
-- 

CREATE TABLE `tbl_additionalprojectupload` (
  `id` int(6) NOT NULL auto_increment,
  `userid` int(6) NOT NULL default '0',
  `projectid` int(6) NOT NULL default '0',
  `addtional_desc` varchar(255) default NULL,
  `uploadfilename` varchar(250) NOT NULL default '',
  `posteddate` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `tbl_additionalprojectupload`
-- 

INSERT INTO `tbl_additionalprojectupload` VALUES (1, 1, 15, NULL, '20060131101135.jpg', '2006-01-31 10:11:35');
INSERT INTO `tbl_additionalprojectupload` VALUES (2, 1, 15, NULL, '20060131102058.jpg', '2006-01-31 10:20:58');
INSERT INTO `tbl_additionalprojectupload` VALUES (3, 1, 15, NULL, '20060131102116.jpg', '2006-01-31 10:21:16');
INSERT INTO `tbl_additionalprojectupload` VALUES (4, 1, 15, NULL, '20060131102223.jpg', '2006-01-31 10:22:23');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_administrator`
-- 

CREATE TABLE `tbl_administrator` (
  `userid` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `first_name` varchar(100) default NULL,
  `last_name` varchar(100) default NULL,
  `email` varchar(150) default NULL,
  `regular_admin` enum('yes','no') NOT NULL default 'yes',
  `status` enum('active','inactive') NOT NULL default 'active',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`userid`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

-- 
-- Dumping data for table `tbl_administrator`
-- 

INSERT INTO `tbl_administrator` VALUES (17, '', '', 'Administrator', 'Manage', 'admin@yahoo.com', 'yes', 'active', '2006-12-19 21:11:36');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_advertise`
-- 

CREATE TABLE `tbl_advertise` (
  `id` int(11) NOT NULL auto_increment,
  `advertisename` varchar(255) NOT NULL default '',
  `paymenttypeid` int(4) NOT NULL default '0',
  `crt` varchar(255) NOT NULL default '',
  `minbid` int(4) NOT NULL default '0',
  `bidincrement` int(4) NOT NULL default '0',
  `topbid` int(4) NOT NULL default '0',
  `createddate` datetime NOT NULL default '0000-00-00 00:00:00',
  `adddesc` varchar(255) NOT NULL default '',
  `statusid` int(10) default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- 
-- Dumping data for table `tbl_advertise`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_advertiseplacebid`
-- 

CREATE TABLE `tbl_advertiseplacebid` (
  `placebidid` int(6) NOT NULL auto_increment,
  `advertiseid` int(6) NOT NULL default '0',
  `userid` int(10) NOT NULL default '0',
  `bid` int(10) NOT NULL default '0',
  `maxamt` int(10) NOT NULL default '0',
  `emailnotiication` enum('yes','no') NOT NULL default 'no',
  `createddt` datetime default NULL,
  `url` varchar(255) NOT NULL default '',
  `adtext` varchar(255) NOT NULL default '',
  `pickid` varchar(100) NOT NULL default '0',
  `paystatus` enum('yes','no') NOT NULL default 'no',
  `aprovalstatus` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`placebidid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

-- 
-- Dumping data for table `tbl_advertiseplacebid`
-- 

INSERT INTO `tbl_advertiseplacebid` VALUES (23, 5, 97, 0, 0, 'no', NULL, '', '', '0', 'no', 'no');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_bueryrating`
-- 

CREATE TABLE `tbl_bueryrating` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(4) NOT NULL default '0',
  `buyer_userid` int(4) NOT NULL default '0',
  `rating` int(4) NOT NULL default '0',
  `createddate` datetime NOT NULL default '0000-00-00 00:00:00',
  `ratedesc` text,
  `projectid` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- 
-- Dumping data for table `tbl_bueryrating`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_deposit`
-- 

CREATE TABLE `tbl_deposit` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(4) NOT NULL default '0',
  `total_amt` varchar(50) NOT NULL default '0',
  `depositdt` datetime NOT NULL default '0000-00-00 00:00:00',
  `paymenttype` int(4) NOT NULL default '0',
  `status` varchar(255) NOT NULL default '',
  `fee_amt` varchar(50) NOT NULL default '0',
  `amt_added` varchar(50) NOT NULL default '0',
  `taken_fee` varchar(50) NOT NULL default '0',
  `taken_fee_reasion` varchar(100) default NULL,
  `country` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;

-- 
-- Dumping data for table `tbl_deposit`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_escrow`
-- 

CREATE TABLE `tbl_escrow` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(4) NOT NULL default '0',
  `amt` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- 
-- Dumping data for table `tbl_escrow`
-- 

INSERT INTO `tbl_escrow` VALUES (5, 1, '40.64');
INSERT INTO `tbl_escrow` VALUES (4, 97, '990');
INSERT INTO `tbl_escrow` VALUES (6, 110, '16');
INSERT INTO `tbl_escrow` VALUES (7, 115, '4');
INSERT INTO `tbl_escrow` VALUES (8, 119, '0');
INSERT INTO `tbl_escrow` VALUES (9, 120, '-80');
INSERT INTO `tbl_escrow` VALUES (10, 118, '-15');
INSERT INTO `tbl_escrow` VALUES (11, 136, '0');
INSERT INTO `tbl_escrow` VALUES (12, 137, '0');
INSERT INTO `tbl_escrow` VALUES (13, 117, '1000');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_escrowfee`
-- 

CREATE TABLE `tbl_escrowfee` (
  `id` int(6) NOT NULL auto_increment,
  `escrowfeemethodid` int(4) NOT NULL default '0',
  `takenfee` varchar(10) NOT NULL default '',
  `fixedfee` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `tbl_escrowfee`
-- 

INSERT INTO `tbl_escrowfee` VALUES (2, 1, '5', '5');
INSERT INTO `tbl_escrowfee` VALUES (6, 2, '10', '10');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_escrowincoming`
-- 

CREATE TABLE `tbl_escrowincoming` (
  `id` int(11) NOT NULL auto_increment,
  `fromuserid` int(4) NOT NULL default '0',
  `touserid` int(4) NOT NULL default '0',
  `total_amt` varchar(10) NOT NULL default '0',
  `status` varchar(255) NOT NULL default '',
  `icogid` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `tbl_escrowincoming`
-- 

INSERT INTO `tbl_escrowincoming` VALUES (5, 97, 120, '10', 'no', 'c6deaz7e');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_escrowoutgoing`
-- 

CREATE TABLE `tbl_escrowoutgoing` (
  `id` int(11) NOT NULL auto_increment,
  `fromuserid` int(4) NOT NULL default '0',
  `touserid` int(4) NOT NULL default '0',
  `total_amt` varchar(10) NOT NULL default '0',
  `status` varchar(255) NOT NULL default '',
  `icogid` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `tbl_escrowoutgoing`
-- 

INSERT INTO `tbl_escrowoutgoing` VALUES (5, 97, 120, '10', 'no', 'c6deaz7e');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_pickaprovider`
-- 

CREATE TABLE `tbl_pickaprovider` (
  `id` int(6) NOT NULL auto_increment,
  `buyerid` int(6) NOT NULL default '0',
  `providerid` int(6) NOT NULL default '0',
  `projectid` int(6) NOT NULL default '0',
  `pickdate` datetime default NULL,
  `providerstatus` int(10) NOT NULL default '0',
  `rated` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=106 ;

-- 
-- Dumping data for table `tbl_pickaprovider`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_placebid`
-- 

CREATE TABLE `tbl_placebid` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(4) NOT NULL default '0',
  `userid` int(4) NOT NULL default '0',
  `bidfortotalproject` int(11) NOT NULL default '0',
  `deliverydays` int(4) NOT NULL default '0',
  `biddetails` text NOT NULL,
  `emailnotify` enum('yes','no') default 'no',
  `createddate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;

-- 
-- Dumping data for table `tbl_placebid`
-- 

INSERT INTO `tbl_placebid` VALUES (67, 103, 97, 34, 0, 'sdf', '', '2007-01-11 09:04:26');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_portfolio`
-- 

CREATE TABLE `tbl_portfolio` (
  `id` tinyint(11) NOT NULL auto_increment,
  `userid` tinyint(11) NOT NULL default '0',
  `template_path` varchar(200) default NULL,
  `link` varchar(200) default NULL,
  `description` text,
  `date` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `tbl_portfolio`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_postproject`
-- 

CREATE TABLE `tbl_postproject` (
  `pid` int(11) NOT NULL auto_increment,
  `pname` varchar(50) NOT NULL default '',
  `bid` int(11) default '0',
  `avgbid` int(11) default '0',
  `statusid` int(11) default '1',
  `pcattype` varchar(100) NOT NULL default '0',
  `userid` int(4) NOT NULL default '0',
  `pdesc` blob NOT NULL,
  `databasetypeid` int(4) NOT NULL default '0',
  `ostypeid` int(4) NOT NULL default '0',
  `pstartdt` varchar(100) NOT NULL default '0000-00-00 00:00:00',
  `penddate` varchar(100) NOT NULL default '0000-00-00 00:00:00',
  `uploadfile` varchar(50) NOT NULL default '0',
  `budgetrangeid` int(4) NOT NULL default '0',
  `openbidmaxdays` int(4) NOT NULL default '0',
  `hide` varchar(50) NOT NULL default '0',
  `createddate` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment` text,
  `cancelreasonid` int(11) default '0',
  PRIMARY KEY  (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=183 ;

-- 
-- Dumping data for table `tbl_postproject`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_privatemsg`
-- 

CREATE TABLE `tbl_privatemsg` (
  `pmid` int(11) NOT NULL auto_increment,
  `pmprojectid` int(4) NOT NULL default '0',
  `pmdesc` text NOT NULL,
  `pmattachedoc` blob NOT NULL,
  `pmfromuserid` int(4) NOT NULL default '0',
  `pmtouserid` int(4) NOT NULL default '0',
  `pmposteddate` datetime NOT NULL default '0000-00-00 00:00:00',
  `pmparentid` int(4) NOT NULL default '0',
  PRIMARY KEY  (`pmid`),
  KEY `pmparentid` (`pmparentid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=66 ;

-- 
-- Dumping data for table `tbl_privatemsg`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_providerrating`
-- 

CREATE TABLE `tbl_providerrating` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(4) NOT NULL default '0',
  `provider_userid` int(4) NOT NULL default '0',
  `rating` int(4) NOT NULL default '0',
  `createddate` datetime NOT NULL default '0000-00-00 00:00:00',
  `ratedesc` text NOT NULL,
  `projectid` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- 
-- Dumping data for table `tbl_providerrating`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_publicmsg`
-- 

CREATE TABLE `tbl_publicmsg` (
  `publicmid` int(11) NOT NULL auto_increment,
  `publicmprojectid` int(4) NOT NULL default '0',
  `publicmdesc` varchar(255) NOT NULL default '',
  `publicmattachedoc` varchar(255) NOT NULL default '',
  `publicmfromuserid` int(4) NOT NULL default '0',
  `publicmposteddate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`publicmid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=143 ;

-- 
-- Dumping data for table `tbl_publicmsg`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_ref_userd`
-- 

CREATE TABLE `tbl_ref_userd` (
  `id` tinyint(11) NOT NULL auto_increment,
  `refuserid` tinyint(11) default NULL,
  `sendtouserid` tinyint(11) default NULL,
  `sendtomailid` varchar(150) default NULL,
  `earnmoney` varchar(150) default NULL,
  `date` date default NULL,
  `signup` enum('Yes','No') default 'No',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `tbl_ref_userd`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_refamount`
-- 

CREATE TABLE `tbl_refamount` (
  `id` tinyint(11) NOT NULL auto_increment,
  `refamt` tinyint(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `tbl_refamount`
-- 

INSERT INTO `tbl_refamount` VALUES (1, 5);

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_reportviolation`
-- 

CREATE TABLE `tbl_reportviolation` (
  `id` int(11) NOT NULL auto_increment,
  `vbyuserid` tinyint(11) default NULL,
  `touserid` tinyint(11) default NULL,
  `projectid` tinyint(11) default NULL,
  `violationurl` varchar(255) NOT NULL default '',
  `reasonid` int(4) NOT NULL default '0',
  `comments` varchar(255) NOT NULL default '',
  `createddate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

-- 
-- Dumping data for table `tbl_reportviolation`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_sitecontent`
-- 

CREATE TABLE `tbl_sitecontent` (
  `content_id` int(11) NOT NULL auto_increment,
  `content_pagename` varchar(100) NOT NULL default '',
  `pageurl` varchar(255) NOT NULL default '',
  `content_showpagetitle` varchar(100) NOT NULL default '',
  `content_actcontent` text,
  PRIMARY KEY  (`content_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

-- 
-- Dumping data for table `tbl_sitecontent`
-- 

INSERT INTO `tbl_sitecontent` VALUES (1, 'Home', 'Home Page', 'Home Page', '<p>NITIN N BANDICHOODE</p>\r\n<p>&nbsp;</p>');
INSERT INTO `tbl_sitecontent` VALUES (2, 'Sam is HAPPY', 'About', 'About Us', 'nitinsdfsdffsd');
INSERT INTO `tbl_sitecontent` VALUES (3, 'General', 'general info', 'Travel general information', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (16, 'faq', 'faq', 'faq', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (14, 'resources', 'resources submit site', 'resources', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (15, 'contact', 'contact', 'contact', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (13, 'Affiliates', 'Affiliates', 'Affiliates', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (8, 'Company', 'Company Info', 'Company Info', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (9, 'Privacy', 'Privacy Policy', 'Privacy Policy', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (10, 'Terms', 'Terms Of Service', 'Terms Of Service', '<p>Information here </p>');
INSERT INTO `tbl_sitecontent` VALUES (11, 'Advertise', 'Advertise With Us', 'Advertise With Us', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (12, 'Help', 'Help', 'Help', '<p>Information here</p>');
INSERT INTO `tbl_sitecontent` VALUES (17, 'Articles', 'Articles', 'show Articles', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (18, 'Advertiser', 'Advertiser', 'Advertiser', '<p>Information here</p>');
INSERT INTO `tbl_sitecontent` VALUES (19, 'Service Provider', 'Serivce Provider', 'Service Provider', '');
INSERT INTO `tbl_sitecontent` VALUES (20, 'Service', 'Serivce Buyer', 'Service Buyer', 'Information here');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_transaction`
-- 

CREATE TABLE `tbl_transaction` (
  `id` int(11) NOT NULL auto_increment,
  `fromuserid` int(4) NOT NULL default '0',
  `touserid` int(4) NOT NULL default '0',
  `transdt` datetime NOT NULL default '0000-00-00 00:00:00',
  `projectid` int(4) NOT NULL default '0',
  `transdesc` varchar(255) NOT NULL default '',
  `paymenttype` int(4) NOT NULL default '0',
  `fee_amt` int(11) NOT NULL default '0',
  `amt_added` int(11) NOT NULL default '0',
  `token_fee` int(11) NOT NULL default '0',
  `total_amt` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_transaction`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_userhideoption`
-- 

CREATE TABLE `tbl_userhideoption` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(4) NOT NULL default '0',
  `hideid` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_userhideoption`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_userpcattype`
-- 

CREATE TABLE `tbl_userpcattype` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(4) NOT NULL default '0',
  `pcattypeid` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

-- 
-- Dumping data for table `tbl_userpcattype`
-- 

INSERT INTO `tbl_userpcattype` VALUES (1, 18, 8);
INSERT INTO `tbl_userpcattype` VALUES (7, 1, 15);
INSERT INTO `tbl_userpcattype` VALUES (6, 1, 12);
INSERT INTO `tbl_userpcattype` VALUES (5, 1, 9);
INSERT INTO `tbl_userpcattype` VALUES (8, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (9, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (10, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (11, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (12, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (13, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (14, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (15, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (16, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (17, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (18, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (19, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (20, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (21, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (22, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (23, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (24, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (25, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (26, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (27, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (28, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (29, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (30, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (31, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (32, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (33, 1, 20);
INSERT INTO `tbl_userpcattype` VALUES (34, 1, 23);

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_userquote`
-- 

CREATE TABLE `tbl_userquote` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(4) NOT NULL default '0',
  `txtquote` text,
  `url` varchar(255) default NULL,
  `createddate` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` enum('YES','NO') NOT NULL default 'NO',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

-- 
-- Dumping data for table `tbl_userquote`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_users`
-- 

CREATE TABLE `tbl_users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `signupdt` datetime NOT NULL default '0000-00-00 00:00:00',
  `first_name` varchar(100) NOT NULL default '',
  `last_name` varchar(50) NOT NULL default '',
  `gender` varchar(20) NOT NULL default '',
  `phone` varchar(50) default NULL,
  `emai_addrs` varchar(150) NOT NULL default '',
  `city` varchar(100) NOT NULL default '',
  `country` varchar(50) NOT NULL default '',
  `areaofexpertise` varchar(100) NOT NULL default '0',
  `skills` varchar(255) NOT NULL default '',
  `vision` varchar(255) NOT NULL default '',
  `keyword` varchar(255) NOT NULL default '',
  `avghourlyrate` int(4) NOT NULL default '0',
  `companyname` varchar(255) NOT NULL default '',
  `companylogo` varchar(255) NOT NULL default '',
  `address1` varchar(200) default NULL,
  `address2` varchar(200) default NULL,
  `state` varchar(100) default NULL,
  `postalcode` varchar(20) default NULL,
  `profiledesc` varchar(255) NOT NULL default '',
  `user_activation` enum('yes','no') NOT NULL default 'no',
  `user_adminapproval` enum('active','inactive','suspend') NOT NULL default 'inactive',
  `web` varchar(255) NOT NULL default '',
  `notifytype` varchar(50) NOT NULL default '',
  `pdetails` enum('yes','no') NOT NULL default 'no',
  `pannouncement` enum('yes','no') NOT NULL default 'no',
  `verifycode` varchar(100) NOT NULL default '',
  `memshiptype` int(11) NOT NULL default '0',
  `isactive_mail` enum('yes','no') NOT NULL default 'no',
  `refid` tinyint(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=146 ;

-- 
-- Dumping data for table `tbl_users`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_useruploadedfile`
-- 

CREATE TABLE `tbl_useruploadedfile` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(4) NOT NULL default '0',
  `filename` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `tbl_useruploadedfile`
-- 

INSERT INTO `tbl_useruploadedfile` VALUES (1, 1, 'a.jpg');

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_withdrawmoney`
-- 

CREATE TABLE `tbl_withdrawmoney` (
  `id` int(6) NOT NULL auto_increment,
  `userid` int(4) NOT NULL default '0',
  `wamt` varchar(10) NOT NULL default '',
  `paypalemail` varchar(35) NOT NULL default '',
  `wdt` datetime NOT NULL default '0000-00-00 00:00:00',
  `paymenttypeid` int(10) NOT NULL default '0',
  `status` enum('YES','NO') NOT NULL default 'NO',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

-- 
-- Dumping data for table `tbl_withdrawmoney`
--

Edited by smartmedia: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.