Location: PHPKode > projects > OpenDomains > SQL/sql.txt
-- --------------------------------------------------------

-- 
-- Table structure for table `cl_country`
-- 

DROP TABLE IF EXISTS `cl_country`;
CREATE TABLE `cl_country` (
  `ma` varchar(3) NOT NULL,
  `ten` varchar(60) NOT NULL,
  `soluong` varchar(20) NOT NULL,
  PRIMARY KEY  (`ma`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `cl_country`
-- 

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

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

-- 
-- Table structure for table `cl_domains`
-- 

DROP TABLE IF EXISTS `cl_domains`;
CREATE TABLE `cl_domains` (
  `id` int(11) NOT NULL auto_increment,
  `wdomain` varchar(40) NOT NULL,
  `wexe` varchar(40) NOT NULL,
  `wurl` varchar(250) NOT NULL,
  `wemail` varchar(80) NOT NULL,
  `wpass` varchar(40) NOT NULL,
  `wname` varchar(40) NOT NULL,
  `wtitle` varchar(40) NOT NULL,
  `wdes` varchar(80) NOT NULL,
  `wkey` varchar(80) NOT NULL,
  `wcloak` varchar(3) NOT NULL default '1',
  `wfav` varchar(150) NOT NULL default 'http://',
  `wvisit` varchar(15) NOT NULL,
  `wdate` varchar(15) NOT NULL,
  `wonline` varchar(20) NOT NULL,
  `wact` varchar(2) NOT NULL default '0',
  `wcountry` varchar(3) NOT NULL,
  `wcus1` varchar(60) NOT NULL,
  `wcus2` varchar(60) NOT NULL,
  `wcus3` varchar(60) NOT NULL,
  `wcus4` varchar(60) NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `wdomain` (`wdomain`),
  KEY `wexe` (`wexe`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `cl_domains`
-- 


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

-- 
-- Table structure for table `cl_exe`
-- 

DROP TABLE IF EXISTS `cl_exe`;
CREATE TABLE `cl_exe` (
  `id` int(11) NOT NULL auto_increment,
  `exe` varchar(40) NOT NULL,
  `ads` varchar(5) NOT NULL default 'yes',
  `act` varchar(2) NOT NULL default '0',
  PRIMARY KEY  (`exe`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `cl_exe`
-- 


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

-- 
-- Table structure for table `cl_options`
-- 

DROP TABLE IF EXISTS `cl_options`;
CREATE TABLE `cl_options` (
  `opt` varchar(20) NOT NULL,
  `vl` varchar(80) NOT NULL,
  PRIMARY KEY  (`opt`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `cl_options`
-- 

INSERT INTO `cl_options` VALUES ('email', 'hide@address.com');
INSERT INTO `cl_options` VALUES ('website', 'http://may1/domain/host/');
INSERT INTO `cl_options` VALUES ('active', 'none');
INSERT INTO `cl_options` VALUES ('language', 'english');
INSERT INTO `cl_options` VALUES ('template', 'opendomains');
INSERT INTO `cl_options` VALUES ('dnsuser', '');
INSERT INTO `cl_options` VALUES ('dnspass', '');
INSERT INTO `cl_options` VALUES ('cus1', 'Yahoo');
INSERT INTO `cl_options` VALUES ('cus2', '');
INSERT INTO `cl_options` VALUES ('cus3', '');
INSERT INTO `cl_options` VALUES ('cus4', '');
INSERT INTO `cl_options` VALUES ('cus2require', 'no');
INSERT INTO `cl_options` VALUES ('cus1require', 'yes');
INSERT INTO `cl_options` VALUES ('cus3require', 'no');
INSERT INTO `cl_options` VALUES ('cus4require', 'no');

ALTER TABLE `cl_country` CHANGE `soluong` `soluong` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `cl_domains` CHANGE `wvisit` `wvisit` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `cl_domains` CHANGE `wonline` `wonline` INT NOT NULL DEFAULT '20060101';
Return current item: OpenDomains