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