| [ PHPXref.com ] | [ Generated: Sun Jul 20 20:31:03 2008 ] | [ SyntaxCMS 1.2.1 ] |
| [ Index ] [ Variables ] [ Functions ] [ Classes ] [ Constants ] [ Statistics ] | ||
[Summary view] [Print] [Text view]
1 -- MySQL dump 9.07 2 -- 3 -- Host: db.forumone.com Database: syntax_ss_test 4 --------------------------------------------------------- 5 -- Server version 4.0.20-standard-log 6 7 -- 8 -- Table structure for table 'ad_bannertypes' 9 -- 10 11 DROP TABLE IF EXISTS `ad_bannertypes`; 12 CREATE TABLE `ad_bannertypes` ( 13 `id` int(10) unsigned NOT NULL auto_increment, 14 `name` varchar(255) NOT NULL default '', 15 `weight` int(11) NOT NULL default '0', 16 PRIMARY KEY (`id`), 17 UNIQUE KEY `id_2` (`id`), 18 KEY `id` (`id`) 19 ) TYPE=MyISAM; 20 21 -- 22 -- Dumping data for table 'ad_bannertypes' 23 -- 24 25 INSERT INTO `ad_bannertypes` (`id`, `name`, `weight`) VALUES (1,'small',5); 26 INSERT INTO `ad_bannertypes` (`id`, `name`, `weight`) VALUES (2,'large',10); 27 28 -- 29 -- Table structure for table 'country' 30 -- 31 32 DROP TABLE IF EXISTS `country`; 33 CREATE TABLE `country` ( 34 `id` int(11) NOT NULL auto_increment, 35 `name` varchar(255) NOT NULL default '', 36 `fullname` varchar(255) default NULL, 37 `fips` char(3) NOT NULL default '', 38 `capital` varchar(255) default NULL, 39 PRIMARY KEY (`id`), 40 KEY `fips` (`fips`), 41 KEY `name` (`name`) 42 ) TYPE=MyISAM PACK_KEYS=1; 43 44 -- 45 -- Dumping data for table 'country' 46 -- 47 48 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (1,'Afghanistan','Islamic State of Afghanistan','AF','Kabul'); 49 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (2,'Albania','Republic of Albania','AL','Tirana'); 50 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (3,'Algeria','Democratic and Popular Republic of Algeria','AG','Algiers'); 51 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (4,'Andorra','Principality of Andorra','AN','Andorra la Vella'); 52 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (5,'Angola','Republic of Angola','AO','Luanda'); 53 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (6,'Antigua and Barbuda','','AC','Saint John\'s'); 54 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (7,'Argentina','Argentine Republic','AR','Buenos Aires'); 55 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (8,'Armenia','Republic of Armenia','AM','Yerevan'); 56 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (9,'Australia','Commonwealth of Australia','AS','Canberra'); 57 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (10,'Austria','Republic of Austria','AU','Vienna'); 58 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (11,'Azerbaijan','Azerbaijani Republic','AJ','Baku'); 59 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (12,'Bahamas, The','Commonwealth of the Bahamas','BF','Nassau'); 60 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (13,'Bahrain','State of Bahrain','BA','Manama'); 61 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (14,'Bangladesh','People\'s Republic of Bangladesh','BG','Dhaka'); 62 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (15,'Barbados','','BB','Bridgetown'); 63 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (16,'Belarus','Republic of Belarus','BO','Minsk'); 64 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (17,'Belgium','Kingdom of Belgium','BE','Brussels'); 65 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (18,'Belize','','BH','Belmopan'); 66 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (19,'Benin','Republic of Benin','BN','Porto-Novo'); 67 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (20,'Bhutan','Kingdom of Bhutan','BT','Thimphu'); 68 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (21,'Bolivia','Republic of Bolivia','BL','La Paz (administrative), Sucre ('); 69 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (22,'Bosnia and Herzegovina','','BK','Sarajevo'); 70 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (23,'Botswana','Republic of Botswana','BC','Gaborone'); 71 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (24,'Brazil','Federative Republic of Brazil','BR','Bras�lia'); 72 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (25,'Brunei','Negara Brunei Darussalam','BX','Bandar Seri Begawan'); 73 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (26,'Bulgaria','Republic of Bulgaria','BU','Sofia'); 74 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (27,'Burkina Faso','Burkina Faso','UV','Ouagadougou'); 75 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (28,'Burma','Union of Burma','BM','Rangoon'); 76 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (29,'Burundi','Republic of Burundi','BY','Bujumbura'); 77 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (30,'Cambodia','Kingdom of Cambodia','CB','Phnom Penh'); 78 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (31,'Cameroon','Republic of Cameroon','CM','Yaound�'); 79 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (32,'Canada','','CA','Ottawa'); 80 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (33,'Cape Verde','Republic of Cape Verde','CV','Praia'); 81 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (34,'Central African Republic','Central African Republic','CT','Bangui'); 82 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (35,'Chad','Republic of Chad','CD','N\'Djamena'); 83 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (36,'Chile','Republic of Chile','CI','Santiago'); 84 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (37,'China','People\'s Republic of China','CH','Beijing'); 85 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (38,'Colombia','Republic of Colombia','CO','Bogot�'); 86 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (39,'Comoros','Federal Islamic Republic of the Comoros','CN','Moroni'); 87 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (40,'Congo (Brazzaville)','Republic of the Congo','CF','Brazzaville'); 88 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (41,'Congo (Kinshasa)','Democratic Republic','CG','Kinshasa'); 89 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (42,'Costa Rica','Republic of Costa Rica','CS','San Jos�'); 90 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (43,'Cote d\'Ivoire','Republic of Cote d\'Ivoire','IV','Yamoussoukro'); 91 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (44,'Croatia','Republic of Croatia','HR','Zagreb'); 92 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (45,'Cuba','Republic of Cuba','CU','Havana'); 93 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (46,'Cyprus','Republic of Cyprus','CY','Nicosia'); 94 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (47,'Czech Republic','Czech Republic','EZ','Prague'); 95 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (48,'Denmark','Kingdom of Denmark','DA','Copenhagen'); 96 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (49,'Djibouti','Republic of Djibouti','DJ','Djibouti'); 97 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (50,'Dominica','Commonwealth of Dominica','DO','Roseau'); 98 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (51,'Dominican Republic','Dominican Republic','DR','Santo Domingo'); 99 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (52,'Ecuador','Republic of Ecuador','EC','Quito'); 100 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (53,'Egypt','Arab Republic of Egypt','EG','Cairo'); 101 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (54,'El Salvador','Republic of El Salvador','ES','San Salvador'); 102 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (55,'Equatorial Guinea','Republic of Equatorial Guinea','EK','Malabo'); 103 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (56,'Eritrea','State of Eritrea','ER','Asmara'); 104 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (57,'Estonia','Republic of Estonia','EN','Tallinn'); 105 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (58,'Ethiopia','Federal Democratic Republic of Ethiopia','ET','Addis Ababa'); 106 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (59,'Fiji','Republic of the Fiji Islands','FJ','Suva'); 107 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (60,'Finland','Republic of Finland','FI','Helsinki'); 108 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (61,'France','French Republic','FR','Paris'); 109 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (62,'Gabon','Gabonese Republic','GB','Libreville'); 110 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (63,'Gambia, The','Republic of The Gambia','GA','Banjul'); 111 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (64,'Georgia','','GG','T\'bilisi'); 112 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (65,'Germany','Federal Republic of Germany','GM','Berlin'); 113 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (66,'Ghana','Republic of Ghana','GH','Accra'); 114 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (67,'Greece','Hellenic Republic','GR','Athens'); 115 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (68,'Grenada','','GJ','Saint George\'s'); 116 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (69,'Guatemala','Republic of Guatemala','GT','Guatemala'); 117 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (70,'Guinea','Republic of Guinea','GV','Conakry'); 118 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (71,'Guinea-Bissau','Republic of Guinea-Bissau','PU','Bissau'); 119 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (72,'Guyana','Co-operative Republic of Guyana','GY','Georgetown'); 120 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (73,'Haiti','Republic of Haiti','HA','Port-au-Prince'); 121 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (74,'Holy See','Holy See','VT','Vatican City'); 122 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (75,'Honduras','Republic of Honduras','HO','Tegucigalpa'); 123 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (76,'Hungary','Republic of Hungary','HU','Budapest'); 124 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (77,'Iceland','Republic of Iceland','IC','Reykjav�k'); 125 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (78,'India','Republic of India','IN','New Delhi'); 126 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (79,'Indonesia','Republic of Indonesia','ID','Jakarta'); 127 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (80,'Iran','Islamic Republic of Iran','IR','Tehran'); 128 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (81,'Iraq','Republic of Iraq','IZ','Baghdad'); 129 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (82,'Ireland','','EI','Dublin'); 130 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (83,'Italy','Italian Republic','IT','Rome'); 131 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (84,'Jamaica','','JM','Kingston'); 132 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (85,'Japan','','JA','Tokyo'); 133 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (86,'Jordan','Hashemite Kingdom of Jordan','JO','Amman'); 134 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (87,'Kazakhstan','Republic of Kazakhstan','KZ','! Astana'); 135 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (88,'Kenya','Republic of Kenya','KE','Nairobi'); 136 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (89,'Kiribati','Republic of Kiribati','KR','Tarawa'); 137 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (90,'Korea, North','Democratic People\'s Republic of Korea','KN','P\'yongyang'); 138 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (91,'Korea, South','Republic of Korea','KS','Seoul'); 139 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (92,'Kuwait','State of Kuwait','KU','Kuwait'); 140 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (93,'Kyrgyzstan','Kyrgyz Republic','KG','Bishkek'); 141 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (94,'Laos','Lao People\'s Democratic Republic','LA','Vientiane'); 142 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (95,'Latvia','Republic of Latvia','LG','Riga'); 143 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (96,'Lebanon','Lebanese Republic','LE','Beirut'); 144 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (97,'Lesotho','Kingdom of Lesotho','LT','Maseru'); 145 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (98,'Liberia','Republic of Liberia','LI','Monrovia'); 146 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (99,'Libya','Socialist People\'s Libyan Arab Jamahiriya','LY','Tripoli'); 147 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (100,'Liechtenstein','Principality of Liechtenstein','LS','Vaduz'); 148 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (101,'Lithuania','Republic of Lithuania','LH','Vilnius'); 149 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (102,'Luxembourg','Grand Duchy of Luxembourg','LU','Luxembourg'); 150 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (103,'Macedonia, The Former Yugoslav R','The Former Yugoslav Republic of Macedonia','MK','Skopje'); 151 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (104,'Madagascar','Republic of Madagascar','MA','Antananarivo'); 152 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (105,'Malawi','Republic of Malawi','MI','Lilongwe'); 153 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (106,'Malaysia','','MY','Kuala Lumpur'); 154 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (107,'Maldives','Republic of Maldives','MV','Male'); 155 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (108,'Mali','Republic of Mali','ML','Bamako'); 156 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (109,'Malta','','MT','Valletta'); 157 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (110,'Marshall Islands','Republic of the Marshall Islands','RM','Majuro'); 158 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (111,'Mauritania','Islamic Republic of Mauritania','MR','Nouakchott'); 159 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (112,'Mauritius','Republic of Mauritius','MP','Port Louis'); 160 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (113,'Mexico','United Mexican States','MX','Mexico'); 161 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (114,'Micronesia, Federated States of','Federated States of Micronesia','FM','Palikir'); 162 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (115,'Moldova','Republic of Moldova','MD','Chisinau'); 163 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (116,'Monaco','Principality of Monaco','MN','Monaco'); 164 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (117,'Mongolia','','MG','Ulaanbaatar'); 165 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (118,'Morocco','Kingdom of Morocco','MO','Rabat'); 166 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (119,'Mozambique','Republic of Mozambique','MZ','Maputo'); 167 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (120,'Namibia','Republic of Namibia','WA','Windhoek'); 168 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (121,'Nauru','Republic of Nauru','NR','Yaren District'); 169 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (122,'Nepal','Kingdom of Nepal','NP','Kathmandu'); 170 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (123,'Netherlands','Kingdom of the Netherlands','NL','Amsterdam'); 171 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (124,'New Zealand','','NZ','Wellington'); 172 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (125,'Nicaragua','Republic of Nicaragua','NU','Managua'); 173 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (126,'Niger','Republic of Niger','NG','Niamey'); 174 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (127,'Nigeria','Federal Republic of Nigeria','NI','Abuja'); 175 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (128,'Norway','Kingdom of Norway','NO','Oslo'); 176 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (129,'Oman','Sultanate of Oman','MU','Muscat'); 177 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (130,'Pakistan','Islamic Republic of Pakistan','PK','Islamabad'); 178 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (131,'Palau','Republic of Palau','PS','Koror'); 179 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (132,'Panama','Republic of Panama','PM','Panama'); 180 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (133,'Papua New Guinea','Independent State of Papua New Guinea','PP','Port Moresby'); 181 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (134,'Paraguay','Republic of Paraguay','PA','Asunci�n'); 182 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (135,'Peru','Republic of Peru','PE','Lima'); 183 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (136,'Philippines','Republic of the Philippines','RP','Manila'); 184 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (137,'Poland','Republic of Poland','PL','Warsaw'); 185 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (138,'Portugal','Portuguese Republic','PO','Lisbon'); 186 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (139,'Qatar','State of Qatar','QA','Doha'); 187 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (140,'Romania','','RO','Bucharest'); 188 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (141,'Russia','Russian Federation','RS','Moscow'); 189 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (142,'Rwanda','Rwandese Republic','RW','Kigali'); 190 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (143,'Saint Kitts and Nevis','Federation of Saint Kitts and Nevis','SC','Basseterre'); 191 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (144,'Saint Lucia','','ST','Castries'); 192 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (145,'Saint Vincent and the Grenadines','','VC','Kingstown'); 193 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (146,'Samoa','Independent State of Samoa','WS','Apia'); 194 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (147,'San Marino','Republic of San Marino','SM','San Marino'); 195 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (148,'Sao Tome and Principe','Democratic Republic of Sao Tome and Principe','TP','Sao Tome'); 196 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (149,'Saudi Arabia','Kingdom of Saudi Arabia','SA','Riyadh'); 197 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (150,'Senegal','Republic of Senegal','SG','Dakar'); 198 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (151,'Seychelles','Republic of Seychelles','SE','Victoria'); 199 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (152,'Sierra Leone','Republic of Sierra Leone','SL','Freetown'); 200 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (153,'Singapore','Republic of Singapore','SN','Singapore'); 201 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (154,'Slovakia','Slovak Republic','LO','Bratislava'); 202 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (155,'Slovenia','Republic of Slovenia','SI','Ljubljana'); 203 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (156,'Solomon Islands','','BP','Honiara'); 204 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (157,'Somalia','','SO','Mogadishu'); 205 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (158,'South Africa','Republic of South Africa','SF','Pretoria (administrative), Cape'); 206 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (159,'Spain','Kingdom of Spain','SP','Madrid'); 207 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (160,'Sri Lanka','Democratic Socialist Republic of Sri Lanka','CE','Colombo'); 208 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (161,'Sudan','Republic of the Sudan','SU','Khartoum'); 209 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (162,'Suriname','Republic of Suriname','NS','Paramaribo'); 210 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (163,'Swaziland','Kingdom of Swaziland','WZ','Mbabane (administrative), Lobamb'); 211 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (164,'Sweden','Kingdom of Sweden','SW','Stockholm'); 212 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (165,'Switzerland','Swiss Confederation','SZ','Bern'); 213 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (166,'Syria','Syrian Arab Republic','SY','Damascus'); 214 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (167,'Tajikistan','Republic of Tajikistan','TI','Dushanbe'); 215 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (168,'Tanzania','United Republic of Tanzania','TZ','Dar es Salaam, Dodoma (legislati'); 216 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (169,'Thailand','Kingdom of Thailand','TH','Bangkok'); 217 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (170,'Togo','Togolese Republic','TO','Lom�'); 218 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (171,'Tonga','Kingdom of Tonga','TN','Nuku\'alofa'); 219 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (172,'Trinidad and Tobago','Republic of Trinidad and Tobago','TD','Port-of-Spain'); 220 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (173,'Tunisia','Republic of Tunisia','TS','Tunis'); 221 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (174,'Turkey','Republic of Turkey','TU','Ankara'); 222 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (175,'Turkmenistan','','TX','Ashgabat'); 223 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (176,'Tuvalu','','TV','Funafuti'); 224 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (177,'Uganda','Republic of Uganda','UG','Kampala'); 225 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (178,'Ukraine','','UP','Kiev'); 226 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (179,'United Arab Emirates','United Arab Emirates','TC','Abu Dhabi'); 227 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (180,'United Kingdom','United Kingdom of Great Britain and Northern Ireland','UK','London'); 228 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (181,'United States','United States of America','US','Washington, DC'); 229 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (182,'Uruguay','Oriental Republic of Uruguay','UY','Montevideo'); 230 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (183,'Uzbekistan','Republic of Uzbekistan','UZ','Tashkent'); 231 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (184,'Vanuatu','Republic of Vanuatu','NH','Port-Vila'); 232 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (185,'Venezuela','Republic of Venezuela','VE','Caracas'); 233 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (186,'Vietnam','Socialist Republic of Vietnam','VM','Hanoi'); 234 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (187,'Yemen','Republic of Yemen','YM','Sanaa'); 235 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (188,'Zambia','Republic of Zambia','ZA','Lusaka'); 236 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (189,'Zimbabwe','Republic of Zimbabwe','ZI','Harare'); 237 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (190,'Serbia','','SR','Belgrade'); 238 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (191,'Montenegro','','MW','Podgorica'); 239 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (192,'Taiwan','','TW','T\'ai-pei'); 240 INSERT INTO `country` (`id`, `name`, `fullname`, `fips`, `capital`) VALUES (193,'Israel','State of Israel','IS','Jerusalem'); 241 242 -- 243 -- Table structure for table 'datatype_privs' 244 -- 245 246 DROP TABLE IF EXISTS `datatype_privs`; 247 CREATE TABLE `datatype_privs` ( 248 `id` int(10) unsigned NOT NULL auto_increment, 249 `datatype_id` tinyint(3) unsigned NOT NULL default '0', 250 `ugid` int(10) unsigned NOT NULL default '0', 251 `priv_view` tinyint(3) unsigned NOT NULL default '0', 252 `priv_add` tinyint(3) unsigned NOT NULL default '0', 253 `priv_edit` tinyint(3) unsigned NOT NULL default '0', 254 `priv_approve` tinyint(3) unsigned NOT NULL default '0', 255 `priv_delete` tinyint(3) unsigned NOT NULL default '0', 256 PRIMARY KEY (`id`), 257 KEY `datatype_id` (`datatype_id`,`ugid`), 258 KEY `datatype_ugid` (`datatype_id`,`ugid`) 259 ) TYPE=MyISAM; 260 261 -- 262 -- Dumping data for table 'datatype_privs' 263 -- 264 265 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (1,1,1,1,1,1,1,1); 266 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (2,13,1,1,1,1,1,1); 267 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (3,5,1,1,1,1,1,1); 268 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (4,7,1,1,1,1,1,1); 269 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (5,11,1,1,1,1,1,1); 270 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (6,12,1,1,1,1,1,1); 271 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (7,14,1,1,1,1,1,1); 272 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (8,15,1,1,1,1,1,1); 273 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (9,16,1,1,1,1,1,1); 274 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (10,18,1,1,1,1,1,1); 275 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (11,19,1,1,1,1,1,1); 276 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (12,1,1,1,1,1,1,1); 277 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (13,13,1,1,1,1,1,1); 278 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (14,5,1,1,1,1,1,1); 279 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (15,7,1,1,1,1,1,1); 280 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (16,11,1,1,1,1,1,1); 281 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (17,12,1,1,1,1,1,1); 282 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (18,14,1,1,1,1,1,1); 283 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (19,15,1,1,1,1,1,1); 284 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (20,16,1,1,1,1,1,1); 285 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (21,18,1,1,1,1,1,1); 286 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (22,19,1,1,1,1,1,1); 287 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (23,9,1,1,1,1,1,1); 288 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (24,1,1,1,1,1,1,1); 289 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (25,13,1,1,1,1,1,1); 290 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (26,5,1,1,1,1,1,1); 291 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (27,7,1,1,1,1,1,1); 292 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (28,11,1,1,1,1,1,1); 293 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (29,12,1,1,1,1,1,1); 294 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (30,14,1,1,1,1,1,1); 295 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (31,15,1,1,1,1,1,1); 296 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (32,16,1,1,1,1,1,1); 297 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (33,18,1,1,1,1,1,1); 298 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (34,19,1,1,1,1,1,1); 299 INSERT INTO `datatype_privs` (`id`, `datatype_id`, `ugid`, `priv_view`, `priv_add`, `priv_edit`, `priv_approve`, `priv_delete`) VALUES (35,9,1,1,1,1,1,1); 300 301 -- 302 -- Table structure for table 'datatypes' 303 -- 304 305 DROP TABLE IF EXISTS `datatypes`; 306 CREATE TABLE `datatypes` ( 307 `id` int(11) NOT NULL auto_increment, 308 `type` varchar(128) NOT NULL default '', 309 `expose` enum('Y','N') NOT NULL default 'Y', 310 `weight` int(6) unsigned NOT NULL default '0', 311 `label` varchar(50) NOT NULL default '', 312 `description` varchar(255) NOT NULL default '', 313 `parent_relid` int(11) NOT NULL default '0', 314 `weighted` enum('Y','N') NOT NULL default 'N', 315 PRIMARY KEY (`id`), 316 KEY `type` (`type`), 317 KEY `weight` (`weight`) 318 ) TYPE=MyISAM PACK_KEYS=1; 319 320 -- 321 -- Dumping data for table 'datatypes' 322 -- 323 324 INSERT INTO `datatypes` (`id`, `type`, `expose`, `weight`, `label`, `description`, `parent_relid`, `weighted`) VALUES (1,'administrator','Y',20,'Site Administrator','A content administrator',0,'N'); 325 INSERT INTO `datatypes` (`id`, `type`, `expose`, `weight`, `label`, `description`, `parent_relid`, `weighted`) VALUES (2,'group','N',25,'Group','',0,'N'); 326 INSERT INTO `datatypes` (`id`, `type`, `expose`, `weight`, `label`, `description`, `parent_relid`, `weighted`) VALUES (13,'general_article','Y',10,'General Article','A document that is displayed as content within the site (i.e. fulltext).',0,''); 327 INSERT INTO `datatypes` (`id`, `type`, `expose`, `weight`, `label`, `description`, `parent_relid`, `weighted`) VALUES (5,'document','Y',15,'Document','An uploaded / local document.',0,'N'); 328 INSERT INTO `datatypes` (`id`, `type`, `expose`, `weight`, `label`, `description`, `parent_relid`, `weighted`) VALUES (9,'section','N',30,'Site Section','The section of a site.',0,'N'); 329 INSERT INTO `datatypes` (`id`, `type`, `expose`, `weight`, `label`, `description`, `parent_relid`, `weighted`) VALUES (11,'event','Y',35,'Event','A calendar event.',0,'N'); 330 INSERT INTO `datatypes` (`id`, `type`, `expose`, `weight`, `label`, `description`, `parent_relid`, `weighted`) VALUES (12,'resource','Y',5,'3rd Party Link','A link to a web site or remote document.',0,''); 331 INSERT INTO `datatypes` (`id`, `type`, `expose`, `weight`, `label`, `description`, `parent_relid`, `weighted`) VALUES (14,'ad_banner','Y',0,'Ad Banner','A banner advertisement.',0,''); 332 INSERT INTO `datatypes` (`id`, `type`, `expose`, `weight`, `label`, `description`, `parent_relid`, `weighted`) VALUES (21,'feedback','N',40,'Feedback','A feedback collection form.',0,''); 333 334 -- 335 -- Table structure for table 'datatypesrel' 336 -- 337 338 DROP TABLE IF EXISTS `datatypesrel`; 339 CREATE TABLE `datatypesrel` ( 340 `relid` int(11) NOT NULL default '0', 341 `dt1` int(11) NOT NULL default '0', 342 `dt2` int(11) NOT NULL default '0', 343 PRIMARY KEY (`relid`,`dt1`,`dt2`) 344 ) TYPE=MyISAM; 345 346 -- 347 -- Dumping data for table 'datatypesrel' 348 -- 349 350 INSERT INTO `datatypesrel` (`relid`, `dt1`, `dt2`) VALUES (8,1,1); 351 INSERT INTO `datatypesrel` (`relid`, `dt1`, `dt2`) VALUES (8,1,2); 352 INSERT INTO `datatypesrel` (`relid`, `dt1`, `dt2`) VALUES (8,2,1); 353 INSERT INTO `datatypesrel` (`relid`, `dt1`, `dt2`) VALUES (8,2,2); 354 355 -- 356 -- Table structure for table 'dbfields' 357 -- 358 359 DROP TABLE IF EXISTS `dbfields`; 360 CREATE TABLE `dbfields` ( 361 `id` int(11) NOT NULL auto_increment, 362 `fname` varchar(255) NOT NULL default '', 363 `ftype` varchar(255) NOT NULL default '', 364 PRIMARY KEY (`id`), 365 KEY `fname` (`fname`), 366 KEY `ftype` (`ftype`) 367 ) TYPE=MyISAM PACK_KEYS=1; 368 369 -- 370 -- Dumping data for table 'dbfields' 371 -- 372 373 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (1,'idnum','txt'); 374 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (2,'name','txt'); 375 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (3,'title','txt'); 376 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (4,'fname','txt'); 377 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (65,'salutation','pick salutations'); 378 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (6,'lname','txt'); 379 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (7,'email','email'); 380 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (68,'bool5','boolean'); 381 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (9,'address1','txt'); 382 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (10,'address2','txt'); 383 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (11,'city','txt'); 384 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (67,'bool4','boolean'); 385 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (13,'zip','txt'); 386 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (14,'country','pick country'); 387 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (15,'phone','phone'); 388 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (16,'fax','phone'); 389 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (17,'url','url'); 390 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (18,'desc1','ltxt'); 391 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (66,'bool3','boolean'); 392 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (20,'date1','date'); 393 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (21,'date2','date'); 394 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (22,'password','pass2'); 395 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (63,'num3','num'); 396 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (25,'type','pickid $(objecttype)types'); 397 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (32,'weight','num'); 398 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (28,'file','upload'); 399 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (30,'desc2','ltxt'); 400 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (35,'bool1','boolean'); 401 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (36,'bool2','boolean'); 402 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (62,'num2','num'); 403 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (38,'phone2','phone'); 404 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (61,'num1','num'); 405 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (41,'text1','txt'); 406 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (42,'url2','url'); 407 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (47,'sunrise','date'); 408 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (48,'sunset','date'); 409 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (51,'topic','pickid topics'); 410 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (50,'issue','pickid issues'); 411 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (52,'image','upload'); 412 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (53,'text2','txt'); 413 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (54,'text3','txt'); 414 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (55,'text4','txt'); 415 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (56,'text5','txt'); 416 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (57,'url3','url'); 417 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (58,'url5','url'); 418 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (59,'url4','url'); 419 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (60,'desc3','ltxt'); 420 INSERT INTO `dbfields` (`id`, `fname`, `ftype`) VALUES (69,'state','pick state abbrev'); 421 422 -- 423 -- Table structure for table 'documenttypes' 424 -- 425 426 DROP TABLE IF EXISTS `documenttypes`; 427 CREATE TABLE `documenttypes` ( 428 `id` int(10) unsigned NOT NULL auto_increment, 429 `name` varchar(255) NOT NULL default '', 430 `orderby` int(10) unsigned NOT NULL default '0', 431 PRIMARY KEY (`id`), 432 KEY `name` (`name`), 433 KEY `orderby` (`orderby`) 434 ) TYPE=MyISAM PACK_KEYS=1; 435 436 -- 437 -- Dumping data for table 'documenttypes' 438 -- 439 440 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (23,'Analysis',5); 441 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (24,'Conference Agenda',10); 442 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (25,'Conference Proceedings',15); 443 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (26,'Directive',20); 444 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (27,'Editorial',25); 445 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (28,'Green Paper',30); 446 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (29,'Infrastructure Financing',35); 447 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (30,'Interview',40); 448 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (31,'Judgment',45); 449 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (32,'Legislation',50); 450 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (33,'News',55); 451 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (34,'Newsletter',60); 452 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (35,'Official Document',65); 453 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (36,'Position Paper',70); 454 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (37,'Press Release',75); 455 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (38,'Regulation',80); 456 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (39,'Statistics',85); 457 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (40,'White Paper',90); 458 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (41,'Other',95); 459 INSERT INTO `documenttypes` (`id`, `name`, `orderby`) VALUES (46,'Form',100); 460 461 -- 462 -- Table structure for table 'eventtypes' 463 -- 464 465 DROP TABLE IF EXISTS `eventtypes`; 466 CREATE TABLE `eventtypes` ( 467 `id` int(10) unsigned NOT NULL auto_increment, 468 `name` varchar(255) NOT NULL default '', 469 `weight` int(11) NOT NULL default '0', 470 PRIMARY KEY (`id`), 471 UNIQUE KEY `id_2` (`id`), 472 KEY `id` (`id`) 473 ) TYPE=MyISAM; 474 475 -- 476 -- Dumping data for table 'eventtypes' 477 -- 478 479 INSERT INTO `eventtypes` (`id`, `name`, `weight`) VALUES (1,'Industry Event',5); 480 INSERT INTO `eventtypes` (`id`, `name`, `weight`) VALUES (2,'National/Regional Event',10); 481 INSERT INTO `eventtypes` (`id`, `name`, `weight`) VALUES (3,'Research Event',15); 482 INSERT INTO `eventtypes` (`id`, `name`, `weight`) VALUES (4,'Other',20); 483 484 -- 485 -- Table structure for table 'feedbacktypes' 486 -- 487 488 DROP TABLE IF EXISTS `feedbacktypes`; 489 CREATE TABLE `feedbacktypes` ( 490 `id` int(10) unsigned NOT NULL auto_increment, 491 `name` varchar(255) NOT NULL default '', 492 `weight` int(11) NOT NULL default '0', 493 PRIMARY KEY (`id`), 494 UNIQUE KEY `id_2` (`id`), 495 KEY `id` (`id`) 496 ) TYPE=MyISAM; 497 498 -- 499 -- Dumping data for table 'feedbacktypes' 500 -- 501 502 INSERT INTO `feedbacktypes` (`id`, `name`, `weight`) VALUES (1,'Inquiry',5); 503 INSERT INTO `feedbacktypes` (`id`, `name`, `weight`) VALUES (2,'Report broken link',10); 504 505 -- 506 -- Table structure for table 'field_priv' 507 -- 508 509 DROP TABLE IF EXISTS `field_priv`; 510 CREATE TABLE `field_priv` ( 511 `fid` int(11) NOT NULL default '0', 512 `ugid` int(11) NOT NULL default '0', 513 `priv_read` tinyint(4) default NULL, 514 `priv_write` tinyint(4) default NULL, 515 PRIMARY KEY (`fid`,`ugid`), 516 KEY `fid` (`fid`), 517 KEY `ugid` (`ugid`), 518 KEY `priv_read` (`priv_read`), 519 KEY `priv_write` (`priv_write`) 520 ) TYPE=MyISAM PACK_KEYS=1; 521 522 -- 523 -- Dumping data for table 'field_priv' 524 -- 525 526 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (1,1,1,1); 527 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (2,0,1,1); 528 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (3,0,1,1); 529 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (4,0,1,1); 530 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (165,1,1,1); 531 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (6,0,1,1); 532 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (7,0,1,1); 533 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (167,0,1,1); 534 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (9,0,1,1); 535 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (10,0,1,1); 536 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (11,0,1,1); 537 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (171,0,1,1); 538 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (13,0,1,1); 539 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (180,0,1,1); 540 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (173,0,1,1); 541 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (172,0,1,1); 542 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (35,0,1,1); 543 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (36,0,1,1); 544 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (37,0,1,1); 545 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (38,0,1,1); 546 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (39,0,1,1); 547 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (47,0,1,1); 548 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (50,0,1,1); 549 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (51,0,1,1); 550 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (52,0,1,1); 551 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (54,0,1,1); 552 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (55,0,1,1); 553 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (57,0,1,1); 554 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (59,0,1,1); 555 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (60,0,1,1); 556 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (61,1,1,1); 557 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (62,0,1,1); 558 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (65,0,1,1); 559 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (66,0,1,1); 560 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (237,0,1,1); 561 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (68,0,1,1); 562 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (69,0,1,1); 563 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (73,0,1,1); 564 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (75,0,1,1); 565 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (160,0,1,1); 566 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (175,0,1,1); 567 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (179,0,1,1); 568 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (83,0,1,1); 569 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (84,0,1,1); 570 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (174,0,1,1); 571 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (178,0,1,1); 572 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (177,0,1,1); 573 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (169,0,1,1); 574 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (106,0,1,1); 575 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (117,0,1,1); 576 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (123,0,1,1); 577 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (133,0,1,1); 578 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (132,0,1,1); 579 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (131,0,1,1); 580 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (235,0,1,1); 581 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (134,0,1,1); 582 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (135,0,1,1); 583 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (136,0,1,1); 584 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (137,0,1,1); 585 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (139,21,1,1); 586 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (238,0,1,1); 587 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (236,0,1,1); 588 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (142,0,1,1); 589 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (143,0,1,1); 590 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (144,0,1,1); 591 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (168,0,1,1); 592 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (163,1,1,1); 593 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (158,0,1,1); 594 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (161,0,1,1); 595 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (162,0,1,1); 596 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (181,0,1,1); 597 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (182,0,1,1); 598 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (183,0,1,1); 599 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (184,0,1,1); 600 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (185,0,1,1); 601 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (186,0,1,1); 602 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (187,0,1,1); 603 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (188,0,1,1); 604 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (189,0,1,1); 605 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (190,0,1,1); 606 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (191,0,1,1); 607 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (192,0,1,1); 608 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (193,0,1,1); 609 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (194,0,1,1); 610 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (195,0,1,1); 611 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (196,0,1,1); 612 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (197,0,1,1); 613 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (198,0,1,1); 614 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (199,0,1,1); 615 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (200,0,1,1); 616 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (201,0,1,1); 617 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (202,0,1,1); 618 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (203,0,1,1); 619 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (204,0,1,1); 620 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (205,0,1,1); 621 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (206,0,1,1); 622 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (207,0,1,1); 623 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (208,0,1,1); 624 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (209,0,1,1); 625 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (210,0,1,1); 626 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (211,0,1,1); 627 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (212,0,1,1); 628 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (213,0,1,1); 629 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (214,0,1,1); 630 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (215,0,1,1); 631 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (216,0,1,1); 632 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (217,0,1,1); 633 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (218,0,1,1); 634 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (219,0,1,1); 635 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (220,0,1,1); 636 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (221,0,1,1); 637 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (222,0,1,1); 638 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (223,0,1,1); 639 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (224,0,1,1); 640 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (225,0,1,1); 641 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (227,0,1,1); 642 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (228,0,1,1); 643 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (229,0,1,1); 644 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (230,0,1,1); 645 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (231,0,1,1); 646 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (232,0,1,1); 647 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (233,0,1,1); 648 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (234,0,1,1); 649 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (239,0,1,1); 650 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (240,0,1,1); 651 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (241,0,1,1); 652 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (251,0,1,1); 653 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (252,0,1,1); 654 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (263,0,1,1); 655 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (264,0,1,1); 656 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (265,0,1,1); 657 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (266,0,1,1); 658 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (267,0,1,1); 659 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (268,0,1,1); 660 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (269,0,1,1); 661 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (270,0,1,1); 662 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (272,0,1,1); 663 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (273,0,1,1); 664 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (281,0,1,1); 665 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (2,1,1,1); 666 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (282,0,1,1); 667 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (283,0,1,1); 668 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (284,0,1,1); 669 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (285,0,1,1); 670 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (286,0,1,1); 671 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (316,0,1,1); 672 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (315,0,1,1); 673 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (297,0,1,1); 674 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (311,0,1,1); 675 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (317,0,1,1); 676 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (318,0,1,1); 677 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (319,0,1,1); 678 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (320,0,1,1); 679 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (321,0,1,1); 680 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (322,0,1,1); 681 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (323,0,1,1); 682 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (324,0,1,1); 683 INSERT INTO `field_priv` (`fid`, `ugid`, `priv_read`, `priv_write`) VALUES (325,0,1,1); 684 685 -- 686 -- Table structure for table 'general_articletypes' 687 -- 688 689 DROP TABLE IF EXISTS `general_articletypes`; 690 CREATE TABLE `general_articletypes` ( 691 `id` int(10) unsigned NOT NULL auto_increment, 692 `name` varchar(255) NOT NULL default '', 693 `weight` int(11) NOT NULL default '0', 694 PRIMARY KEY (`id`), 695 UNIQUE KEY `id_2` (`id`), 696 KEY `id` (`id`) 697 ) TYPE=MyISAM; 698 699 -- 700 -- Dumping data for table 'general_articletypes' 701 -- 702 703 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (1,'Analysis',5); 704 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (2,'Conference Agenda',10); 705 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (3,'Conference Proceedings',15); 706 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (4,'Directive',20); 707 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (5,'Editorial',25); 708 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (6,'Green Paper',30); 709 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (7,'Infrastructure Financing',35); 710 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (8,'Interview',40); 711 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (9,'Judgment',45); 712 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (10,'Legislation',50); 713 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (11,'News',55); 714 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (12,'Newsletter',60); 715 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (13,'Official Document',65); 716 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (14,'Position Paper',70); 717 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (15,'Press Release',75); 718 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (16,'Regulation',80); 719 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (17,'Statistics',85); 720 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (18,'White Paper',90); 721 INSERT INTO `general_articletypes` (`id`, `name`, `weight`) VALUES (19,'Other',95); 722 723 -- 724 -- Table structure for table 'issues' 725 -- 726 727 DROP TABLE IF EXISTS `issues`; 728 CREATE TABLE `issues` ( 729 `id` int(10) unsigned NOT NULL auto_increment, 730 `name` varchar(255) NOT NULL default '', 731 `weight` int(11) NOT NULL default '0', 732 PRIMARY KEY (`id`), 733 UNIQUE KEY `id_2` (`id`), 734 KEY `id` (`id`) 735 ) TYPE=MyISAM; 736 737 -- 738 -- Dumping data for table 'issues' 739 -- 740 741 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (1,'International Development',5); 742 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (2,'Health/AIDS/Family Planning',10); 743 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (3,'Government & Governmental Affairs',15); 744 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (4,'Environment & Conservation',20); 745 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (5,'Education & Social Action',25); 746 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (14,'Other',55); 747 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (15,'Association/Foundation',30); 748 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (16,'Advocacy/Action',35); 749 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (17,'Research',40); 750 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (18,'Consulting',45); 751 INSERT INTO `issues` (`id`, `name`, `weight`) VALUES (19,'International Issues',50); 752 753 -- 754 -- Table structure for table 'noderel' 755 -- 756 757 DROP TABLE IF EXISTS `noderel`; 758 CREATE TABLE `noderel` ( 759 `parent` int(11) NOT NULL default '0', 760 `child` int(11) NOT NULL default '0', 761 `noderelid` tinyint(3) unsigned default NULL, 762 `weight` int(10) unsigned default '0', 763 KEY `child` (`child`), 764 KEY `parent` (`parent`), 765 KEY `add_child` (`parent`,`noderelid`), 766 KEY `add_parent` (`child`,`noderelid`), 767 KEY `relid` (`noderelid`), 768 KEY `relweight` (`parent`,`noderelid`,`weight`), 769 KEY `weight` (`weight`) 770 ) TYPE=MyISAM PACK_KEYS=1; 771 772 -- 773 -- Dumping data for table 'noderel' 774 -- 775 776 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,3,NULL,0); 777 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,8,NULL,0); 778 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,11,NULL,0); 779 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,12,NULL,0); 780 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,16,NULL,0); 781 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,17,NULL,0); 782 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,20,NULL,0); 783 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,22,NULL,0); 784 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,25,NULL,0); 785 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,27,NULL,0); 786 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,28,NULL,0); 787 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,31,NULL,0); 788 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,40,NULL,0); 789 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,44,NULL,0); 790 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,57,1,0); 791 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,60,NULL,0); 792 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,66,NULL,0); 793 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,73,NULL,0); 794 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,81,NULL,0); 795 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,82,NULL,0); 796 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,83,NULL,0); 797 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,84,NULL,0); 798 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,85,NULL,0); 799 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,86,NULL,0); 800 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,87,NULL,0); 801 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,88,NULL,0); 802 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,89,NULL,0); 803 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,90,NULL,0); 804 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,91,NULL,0); 805 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,102,NULL,0); 806 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,104,NULL,0); 807 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,106,NULL,0); 808 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,107,NULL,0); 809 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,108,NULL,0); 810 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,109,NULL,0); 811 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,115,0,0); 812 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,121,NULL,0); 813 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,126,NULL,0); 814 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,266,NULL,0); 815 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,268,NULL,0); 816 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,270,NULL,0); 817 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,271,NULL,0); 818 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,275,1,0); 819 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,279,NULL,0); 820 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,280,NULL,0); 821 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,282,NULL,0); 822 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,283,NULL,0); 823 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,285,1,0); 824 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,296,0,0); 825 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,297,NULL,0); 826 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,299,NULL,0); 827 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,302,NULL,0); 828 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,303,NULL,0); 829 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,304,NULL,0); 830 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,307,NULL,0); 831 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,316,NULL,0); 832 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,317,NULL,0); 833 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,318,NULL,0); 834 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,319,NULL,0); 835 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,320,NULL,0); 836 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,321,NULL,0); 837 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,355,NULL,0); 838 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,357,NULL,0); 839 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,358,NULL,0); 840 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,364,NULL,0); 841 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,378,NULL,0); 842 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,381,NULL,0); 843 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,382,NULL,0); 844 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,393,NULL,0); 845 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,395,NULL,0); 846 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,401,NULL,0); 847 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,404,NULL,0); 848 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,412,1,0); 849 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,431,NULL,0); 850 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,432,NULL,0); 851 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,433,NULL,0); 852 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,434,NULL,0); 853 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,436,NULL,0); 854 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,437,NULL,0); 855 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,438,0,0); 856 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,439,0,0); 857 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,440,NULL,0); 858 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,448,NULL,0); 859 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,456,NULL,0); 860 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,459,0,0); 861 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,469,0,0); 862 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,471,NULL,0); 863 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,475,NULL,0); 864 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (21,6,NULL,0); 865 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (21,66,NULL,0); 866 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (21,67,NULL,0); 867 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (21,111,NULL,0); 868 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,81,NULL,0); 869 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,82,NULL,0); 870 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,83,NULL,0); 871 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,117,NULL,0); 872 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,118,NULL,0); 873 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,120,NULL,0); 874 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,121,NULL,0); 875 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,127,NULL,0); 876 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,277,NULL,0); 877 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (79,329,1,0); 878 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (115,121,NULL,0); 879 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (115,269,NULL,0); 880 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (296,79,0,0); 881 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (296,81,NULL,0); 882 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (296,297,NULL,0); 883 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (296,318,NULL,0); 884 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (296,325,0,0); 885 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (296,329,1,0); 886 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (296,382,NULL,0); 887 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (325,318,NULL,0); 888 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (325,329,1,0); 889 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (459,460,0,0); 890 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (459,461,0,0); 891 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (459,463,NULL,0); 892 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (459,474,0,0); 893 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (469,378,NULL,0); 894 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (469,470,0,0); 895 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (474,403,NULL,0); 896 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (474,471,NULL,0); 897 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,479,1,0); 898 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,479,2,0); 899 INSERT INTO `noderel` (`parent`, `child`, `noderelid`, `weight`) VALUES (9,480,0,0); 900 901 -- 902 -- Table structure for table 'pickrel' 903 -- 904 905 DROP TABLE IF EXISTS `pickrel`; 906 CREATE TABLE `pickrel` ( 907 `f_id` int(10) unsigned NOT NULL default '0', 908 `p_id` int(10) unsigned NOT NULL default '0', 909 `recid` int(10) unsigned NOT NULL default '0', 910 PRIMARY KEY (`f_id`,`p_id`,`recid`), 911 KEY `f_id` (`f_id`,`recid`), 912 KEY `f_id_2` (`f_id`), 913 KEY `p_id` (`p_id`), 914 KEY `recid` (`recid`) 915 ) TYPE=MyISAM PACK_KEYS=1; 916 917 -- 918 -- Dumping data for table 'pickrel' 919 -- 920 921 INSERT INTO `pickrel` (`f_id`, `p_id`, `recid`) VALUES (25,2,479); 922 INSERT INTO `pickrel` (`f_id`, `p_id`, `recid`) VALUES (25,17,275); 923 INSERT INTO `pickrel` (`f_id`, `p_id`, `recid`) VALUES (50,1,412); 924 INSERT INTO `pickrel` (`f_id`, `p_id`, `recid`) VALUES (50,14,275); 925 INSERT INTO `pickrel` (`f_id`, `p_id`, `recid`) VALUES (50,19,479); 926 INSERT INTO `pickrel` (`f_id`, `p_id`, `recid`) VALUES (51,2,412); 927 INSERT INTO `pickrel` (`f_id`, `p_id`, `recid`) VALUES (51,3,275); 928 INSERT INTO `pickrel` (`f_id`, `p_id`, `recid`) VALUES (51,6,479); 929 930 -- 931 -- Table structure for table 'primaryrel' 932 -- 933 934 DROP TABLE IF EXISTS `primaryrel`; 935 CREATE TABLE `primaryrel` ( 936 `id1` int(10) unsigned NOT NULL default '0', 937 `id2` int(10) unsigned NOT NULL default '0', 938 `relid` int(10) unsigned NOT NULL default '0', 939 PRIMARY