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

#
# Table structure for table 'companies'
#

CREATE TABLE companies (
   id int(11) NOT NULL auto_increment,
   companyname char(128) NOT NULL,
   bod char(255) NOT NULL,
   rank2001 int(11) DEFAULT '0' NOT NULL,
   url char(255) NOT NULL,
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id)
);

#
# Dumping data for table 'companies'
#

INSERT INTO companies VALUES ( '1', 'Exxon-Mobil', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', '1', 'http://www.exxon.mobil.com');
INSERT INTO companies VALUES ( '2', 'Wal-Mart Stores', '17,18,19,20,21,22,23,24,25,26,27,28,29,30,31', '2', 'http://www.walmart.com');
INSERT INTO companies VALUES ( '3', 'General Motors', '32,33,34,35,36,37,38,39,40,41,42,43', '3', 'http://www.gm.com');
INSERT INTO companies VALUES ( '4', 'Ford Motor', '44,45,46,47,48,49,50,51,52,53,54,55,56,57', '4', 'http://www.ford.com');
INSERT INTO companies VALUES ( '5', 'General Electric', '58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76', '5', 'http://www.ge.com');
INSERT INTO companies VALUES ( '6', 'Citigroup', '77,78,79,80,81,82,83,84,85,86,87,88,89,91,92,93,56', '6', 'http://www.citigroup.com');
INSERT INTO companies VALUES ( '7', 'Enron', '94,95,96,97,98,99,100,101,102,103,104,105,106,108,109,110,111', '7', 'http://www.enron.com');
INSERT INTO companies VALUES ( '8', 'Intl. Business Machines', '112,113,114,115,116,117,118,119,120,121,122,123,124,125,126', '8', 'http://www.ibm.com');
INSERT INTO companies VALUES ( '9', 'AT*T', '128,129,131,132,135,136,137,138,139,141,92,77,80,35,4', '9', 'http://www.att.com');
INSERT INTO companies VALUES ( '10', 'Verizon Communications', '143,144,145,146,147,149,150,151,152,153,155,156,157,9,16', '10', 'http://www.verizon.com');
INSERT INTO companies VALUES ( '11', 'Philip Morris', '158,159,160,161,162,163,164,165,166,168,169,170,121', '11', 'http://www.philipmorris.com/');
INSERT INTO companies VALUES ( '12', 'J.P. Morgan Chase', '172,173,174,175,176,177,178,179,180,185,9,1,156,43,74', '12', 'http://www.jpmorganchase.com');
INSERT INTO companies VALUES ( '13', 'Bank of America Corp.', '186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201', '13', 'http://www.bankofamerica.com/inside/');
INSERT INTO companies VALUES ( '14', 'SBC Communications', '202,203,204,205,206,207,208,209,212,213,215,216,217,218,219,220,221,222,5,169,119', '14', 'http://www.sbc.com');
INSERT INTO companies VALUES ( '15', 'The Boeing Company', '223,224,225,226,227,228,229,230,231,232', '15', 'http://www.boeing.com');
INSERT INTO companies VALUES ( '16', 'Texaco', '233,234,235,236,237,238,239,241,242,243,244,245,70', '16', 'http://www.texaco.com');
INSERT INTO companies VALUES ( '17', 'Duke Energy', '246,247,248,250,251,252,253,254,255,256,257,258,3', '17', 'http://www.duke-energy.com');
INSERT INTO companies VALUES ( '18', 'Kroger Company', '259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275', '18', 'http://www.kroger.com');
INSERT INTO companies VALUES ( '19', 'Hewlett-Packard', '276,277,279,280,281,282,283,284,223', '19', 'http://www.hp.com');
INSERT INTO companies VALUES ( '20', 'Chevron', '285,286,287,288,289,290,291,292,293,294,280', '20', 'http://www.chevron.com');
INSERT INTO companies VALUES ( '21', 'State Farm Insurance Cos.', '296,100,298,299,300,301,302,303,304,305,306,307,308', '21', 'http://www.statefarm.com');
INSERT INTO companies VALUES ( '22', 'American International Group', '309,310,311,312,313,314,315,179,317,288,319,320,321,322,323,324,325,326,327,328', '22', 'http://www.aigcorporate.com/');
INSERT INTO companies VALUES ( '23', 'Home Depot', '329,330,331,332,263,334,335,336,337,66,339', '23', 'http://www.homedepot.com/');
INSERT INTO companies VALUES ( '24', 'Morgan Stanley Dean Witter', '1242,341,342,343,119,345,346,347,221', '24', 'http://www.morganstanley.com/');
INSERT INTO companies VALUES ( '25', 'Merrill Lynch', '349,350,351,352,353,354,355,356,357,358,359', '25', 'http://www.merrilllynch.com/');
INSERT INTO companies VALUES ( '26', 'Fannie Mae', '360,361,362,363,226,18,366,367,368,369,370,371,372,373,374,375', '26', 'http://www.fanniemae.com/');
INSERT INTO companies VALUES ( '27', 'Compaq Computer', '376,377,378,379,94,381,382,383', '27', 'http://www.compaq.com');
INSERT INTO companies VALUES ( '28', 'Lucent Technologies', '384,385,386,387,288,91,294', '28', 'http://www.lucent.com');
INSERT INTO companies VALUES ( '29', 'Sears Roebuck', '391,392,393,394,395,396,397,347,153,400', '29', 'http://www.sears.com');
INSERT INTO companies VALUES ( '30', 'Merck', '401,402,176,1287,405,406,407,276,409,172,411,412,413,414,415,416', '30', 'http://www.merck.com');
INSERT INTO companies VALUES ( '31', 'Procter and Gamble', '417,418,419,420,421,422,423,424,425,142,215,41,429,157,185,432', '31', 'http://www.pg.com/');
INSERT INTO companies VALUES ( '32', 'WorldCom', '433,434,435,436,437,438,439,440,441,442,443,444,445,446', '32', 'http://www.worldcom.com/');
INSERT INTO companies VALUES ( '33', 'TIAA-CREF', '1286,1287,674,1289,1290,1291', '33', 'http://www.TIAA-CREF.com');
INSERT INTO companies VALUES ( '34', 'Motorola', '98,178,449,450,451,195,453,417,455,456,457', '34', 'http://www.motorola.com');
INSERT INTO companies VALUES ( '35', 'McKesson HBOC', '458,459,460,461,462,463,464,465,466,467,55,469', '35', 'http://www.mckesson.com');
INSERT INTO companies VALUES ( '36', 'Kmart', '470,471,472,473,474,475,476,243,478,479', '36', 'http://www.bluelight.com');
INSERT INTO companies VALUES ( '37', 'Target', '480,481,482,483,484,485,486,487,488,489,490,199', '37', 'http://www.targetcorp.com');
INSERT INTO companies VALUES ( '38', 'Albertsons', '492,493,494,495,496,497,498,499,227,501,502,503,504,505,506,507,508,509,510', '38', 'http://www.albertsons.com');
INSERT INTO companies VALUES ( '39', 'USX', '511,512,513,514,515,516,517,142,519,520,521,155,523', '39', 'http://www.usx.com');
INSERT INTO companies VALUES ( '40', 'Berkshire Hathaway', '524,525,526,527,528,529,530', '40', 'http://www.berkshirehathaway.com');
INSERT INTO companies VALUES ( '41', 'Intel', '531,532,533,534,535,536,467,469,539,540,541', '41', 'http://www.intel.com');
INSERT INTO companies VALUES ( '42', 'Goldman Sachs Group', '542,543,57,545,533,33,486,549', '42', 'http://www.goldmansachs.com/');
INSERT INTO companies VALUES ( '43', 'J.C. Penney', '550,551,552,553,554,555,556,557,558', '43', 'http://www.jcpenney.net/');
INSERT INTO companies VALUES ( '44', 'Conoco', '559,226,561,562,563,564,565,566,91', '44', 'http://www.conoco.com');
INSERT INTO companies VALUES ( '45', 'Costco Wholesale', '568,569,570,571,572,573,574,525,576,577,578', '45', 'http://www.costco.com');
INSERT INTO companies VALUES ( '46', 'Safeway', '579,580,581,582,583,584,585,586', '46', 'http://www.safeway.com');
INSERT INTO companies VALUES ( '47', 'MetLife', '587,588,589,590,591,592,593,7,595,9,597,598,358,153,549,244', '47', 'http://www.metlife.com/index.html');
INSERT INTO companies VALUES ( '48', 'Dell Computer', '603,604,605,396,180,608,451,610,611,612,347,70,615,616', '48', 'http://www.dell.com');
INSERT INTO companies VALUES ( '49', 'Ingram Micro', '553,618,619,620,621,622,623,624', '49', 'http://www.ingrammicro.com');
INSERT INTO companies VALUES ( '50', 'Freddie Mac', '625,626,627,628,629,630,631,814,216,634,152,636,637,638,639,640', '50', 'http://www.freddiemac.com');
INSERT INTO companies VALUES ( '51', 'Cardinal Health', '641,642,643,644,645,646,647,648,649,216,651,652,653', '51', 'http://www.cardinal-health.com');
INSERT INTO companies VALUES ( '52', 'United Parcel Service', '654,655,656,657,658,659,660,661,662,663,664,665,666', '52', 'http://www.ups.com');
INSERT INTO companies VALUES ( '53', 'Pfizer', '667,668,669,551,671,353,673,674,595,676,677,360,549,680', '53', 'http://www.pfizer.com');
INSERT INTO companies VALUES ( '54', 'Dynegy', '681,682,683,684,376,686,687,688,689,286,691,692,693,694,695,696', '54', 'http://www.dynegy.com');
INSERT INTO companies VALUES ( '55', 'Reliant Energy', '697,698,699,700,701,702,703,704,705,706,707,708', '55', 'http://www.reliantenergy.com');
INSERT INTO companies VALUES ( '56', 'E.I. du Pont de Nemours', '709,78,711,712,713,714,715,716,717,564,719,126', '56', 'http://www.dupont.com/');
INSERT INTO companies VALUES ( '57', 'Delphi Automotive Systems', '721,722,723,724,725,726,727,676,729,730,731,71,733,734', '57', 'http://www.delphiauto.com/');
INSERT INTO companies VALUES ( '58', 'Johnson * Johnson', '735,736,737,738,739,740', '58', 'http://www.jnj.com');
INSERT INTO companies VALUES ( '59', 'Allstate', '267,742,743,394,342,746,397,748,347,693,751,752,615', '59', 'http://www.allstate.com');
INSERT INTO companies VALUES ( '60', 'Utilicorp', '754,755,756,757,49,674,760,761', '60', 'http://www.utilicorp.com');
INSERT INTO companies VALUES ( '61', 'International Paper', '762,237,764,212,767,476,769,137,771,555,773,242,775', '61', 'http://www.ipaper.com');
INSERT INTO companies VALUES ( '62', 'Wells Fargo', '487,777,778,779,780,781,782,10,784,785,786,787,788,789,790,292,792', '62', 'http://www.wellsfargo.com');
INSERT INTO companies VALUES ( '63', 'Aetna', '1034,794,795,796,797,798,799,800,801,608,803,804', '63', 'http://www.aetna.com');
INSERT INTO companies VALUES ( '64', 'United Technologies', '805,806,807,808', '64', 'http://www.utc.com');
INSERT INTO companies VALUES ( '65', 'Lehman Brothers Holdings', '809,810,811,812,813,814,815,816', '65', 'http://www.lehman.com');
INSERT INTO companies VALUES ( '66', 'BellSouth', '818,261,820,821,822,190,654,825,826,827,828,243,830,742', '66', 'http://www.bellsouthcorp.com');
INSERT INTO companies VALUES ( '67', 'Walt Disney', '831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846', '67', 'http://www.disney.com');
INSERT INTO companies VALUES ( '68', 'ConAgra', '847,848,849,850,851,852,55,854,855,856,857', '68', 'http://www.conagra.com');
INSERT INTO companies VALUES ( '69', 'Lockheed Martin', '858,859,419,861,862,863,864,865,828,108,868,523', '69', 'http://www.lockheedmartin.com');
INSERT INTO companies VALUES ( '70', 'Bank One Corp.', '870,871,33,873,874,875,876,877,878,412,880,881,882,883,641', '70', 'http://www.bankone.com/');
INSERT INTO companies VALUES ( '71', 'Honeywell International', '885,173,887,888,62,890,265,355,152,894,895,73,156,792', '71', 'http://www.honeywell.com');
INSERT INTO companies VALUES ( '72', 'Tosco', '899,900,901,902,903,904,905,906,907,908', '72', 'http://www.tosco.com');
INSERT INTO companies VALUES ( '73', 'First Union Corp.', '909,910,911,912,247,405,248,916,917,918,919,920,921,922,150,924,925', '73', 'http://www.firstunion.com');
INSERT INTO companies VALUES ( '74', 'American Express', '116,927,928,929,1287,931,932,554,934,935,936', '74', 'http://www.americanexpress.com');
INSERT INTO companies VALUES ( '75', 'Sprint', '3,748,939,394,49,942,943,944,945', '75', 'http://www.sprint.com');
INSERT INTO companies VALUES ( '76', 'Southern', '946,947,948,949,950,951,952,953,954,955', '76', 'http://www.southernco.com');
INSERT INTO companies VALUES ( '77', 'Alcoa', '78,957,425,959,960,961,962,384,91,185', '77', 'http://www.alcoa.com/');
INSERT INTO companies VALUES ( '78', 'Dow Chemical', '830,967,968,969,970,971,592,474,796,975,976,977,978,979', '78', 'http://www.dow.com');
INSERT INTO companies VALUES ( '79', 'Microsoft', '980,981,401,983,79,985,986', '79', 'http://www.microsoft.com');
INSERT INTO companies VALUES ( '80', 'Prudential Ins. Co. of America', '987,988,989,990,991,992,975,180,995,996,673,998,999,1000,1001,1002,1003,1004,1005,1006,1290', '80', 'http://www.prudential.com');
INSERT INTO companies VALUES ( '81', 'FleetBoston Financial', '1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,137,1032,1033,1034,1035,1036', '81', 'http://www.fleetbankbostonmerger.com');
INSERT INTO companies VALUES ( '82', 'PG*E Corp.', '1037,1038,1039,1040,1041,1042,335,1044,217,55,1047,1048', '82', 'http://www.pgecorp.com');
INSERT INTO companies VALUES ( '83', 'AutoNation', '1049,1050,1051,248,1053,1054,1055,253,1057,1058', '83', 'http://corp.autonation.com');
INSERT INTO companies VALUES ( '84', 'Georgia-Pacific', '1059,1060,1061,1062,161,4,1065,1066,1067,654,1069,1070,129', '84', 'http://www.gp.com');
INSERT INTO companies VALUES ( '85', 'TXU', '1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084', '85', 'http://www.txu.com');
INSERT INTO companies VALUES ( '86', 'El Paso Corp.', '1085,1086,1087,1088,862,1090,1091,1092,1093,1094,1095,624', '86', 'http://www.elpaso.com/');
INSERT INTO companies VALUES ( '87', 'New York Life Insurance', '1097,1098,1099,1100,1101,1102,1103,553,1105,1106,1107,1108,1109,1110', '87', 'http://www.newyorklife.com');
INSERT INTO companies VALUES ( '88', 'Bristol-Myers Squibb', '6,1112,1113,1114,1115,858,179,112,1119,1120,1121,1069', '88', 'http://www.bms.com');
INSERT INTO companies VALUES ( '89', 'Phillips Petroleum', '1123,899,419,1126,1127,1128,1129,1130,1131,1132,1133', '89', 'http://www.phillips66.com');
INSERT INTO companies VALUES ( '90', 'Walgreen', '1134,1135,1136,890,1138,1139,1140,1141,1142,1143', '90', 'http://www.walgreens.com');
INSERT INTO companies VALUES ( '91', 'UnitedHealth Group', '1144,1145,1146,1147,486,1149,1150,1151,1152,1153,1154,1155,1156', '91', 'http://www.unitedhealthgroup.com');
INSERT INTO companies VALUES ( '92', 'Loews', '1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170', '92', 'http://www.loews.com');
INSERT INTO companies VALUES ( '93', 'Coca-Cola', '1274,1275,1276,115,524,1279,137,70,1282,1121,1284,1285', '93', 'http://www.cocacola.com');
INSERT INTO companies VALUES ( '94', 'PepsiCo', '1183,811,483,1114,1187,1188,1189,1190,360,1192,91,1194,199', '94', 'http://www.pepsico.com');
INSERT INTO companies VALUES ( '95', 'Tech Data', '1196,1197,1198,1199,1200,1201,1202,1203,1204,1205', '95', 'http://www.techdata.com');
INSERT INTO companies VALUES ( '96', 'Sara Lee', '1206,691,386,1209,1210,188,873,474,554,1215,1216,231,1218,1219,129,1221,1222', '96', 'http://www.saralee.com');
INSERT INTO companies VALUES ( '97', 'Supervalu', '792,1224,1225,781,1227,1228,1229,1230,1231,1232,1233,1234', '97', 'http://www.supervalu.com');
INSERT INTO companies VALUES ( '98', 'AMR', '396,1236,1126,342,799,371,347,1242,1243,804', '98', 'http://www.amrcorp.com');
INSERT INTO companies VALUES ( '99', 'Caterpillar', '1245,472,1247,1248,762,4,1251,1066,1253,583,1255,1256,1257,1258,1259,857,1261,1262', '99', 'http://www.cat.com');
INSERT INTO companies VALUES ( '100', 'CVS', '1035,1264,671,366,1267,1028,1269,1270,1008,694,895', '100', 'http://www.cvs.com');