| Server IP : 103.243.232.44 / Your IP : 216.73.216.250 Web Server : LiteSpeed System : Linux server17213-10344.hostycare.online 5.14.0-687.38.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Aug 12 17:19:12 EDT 2026 x86_64 User : iamakash ( 1400) PHP Version : 8.1.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/iamakash/public_html/shaurya.meals28.com/sql/ |
Upload File : |
-- v1.1 migration: series linking tables
-- Run in phpMyAdmin after selecting your database (shaurya_index)
CREATE TABLE IF NOT EXISTS `comm_crosswalk` (
`new_code` VARCHAR(20) NOT NULL,
`old_code` VARCHAR(20) NOT NULL,
PRIMARY KEY (`new_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `series_links` (
`comm_code` VARCHAR(20) NOT NULL,
`old_base` VARCHAR(10) NOT NULL,
`new_base` VARCHAR(10) NOT NULL,
`old_avg` DECIMAL(10,4) NULL,
`new_avg` DECIMAL(10,4) NULL,
PRIMARY KEY (`comm_code`, `old_base`, `new_base`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT IGNORE INTO `comm_crosswalk` VALUES ('1310080002','1303020106'),('1317040006','1310020109'),('1310020003','1308030102'),('1317010009','1311100010'),('1310010005','1308020017'),('1313060001','1309040004'),('1301090003','1301050005'),('1317020004','1311070019'),('1202000007','1200020008'),('1304040002','1303030007'),('1308010011','1305020003'),('1301050003','1301010003'),('1316010001','1311100008'),('1308010007','1305020004'),('1301040006','1308110005'),('1319020015','1310030021'),('1318080001','1311050003'),('1303010001','1302040001'),('1201010001','1200010001'),('1316020003','1311110002'),('1318110007','1311030002'),('1301050001','1301010005'),('1301040010','1301060008'),('1301040011','1301060005'),('1301160004','1301070001'),('1318060001','1311020008'),('1104000001','1103030001'),('1319020014','1310030007'),('1310020002','1308030104'),('1318110008','1311060002'),('1310010001','1308020001'),('1318080004','1311020004'),('1102030008','1102030009'),('1310070010','1308010019'),('1202000008','1200020009'),('1301050002','1301010002'),('1322010001','1310030001'),('1301060006','1301030003'),('1301040005','1301060002'),('1301090004','1301050002'),('1318060003','1311020021'),('1310070007','1308010008'),('1301050004','1301010004'),('1103010005','1103010006'),('1202000003','1200020003'),('1308010006','1305010004'),('1318100003','1311040002'),('1201030001','1200010004'),('1103020002','1103020008'),('1318110004','1311030001'),('1202000001','1200020001'),('1301060001','1301030001'),('1103010004','1103010005'),('1310010014','1308020014'),('1317060008','1311090006'),('1301090002','1301050004'),('1301160005','1301070003'),('1202000006','1200020006'),('1309010001','1305030002'),('1308010001','1305010003'),('1310010002','1308020012'),('1310010023','1308010020'),('1310010013','1308100006'),('1301040008','1301060003'),('1202000002','1200020002'),('1314020001','1310010102'),('1306030004','1307020019'),('1313040001','1309020010'),('1301050005','1301010001'),('1315060008','1310030020'),('1317040001','1311080007'),('1314040003','1310010206'),('1320020004','1312030001'),('1313060003','1309040005'),('1102030006','1102030007'),('1317060001','1311050002'),('1301040007','1301060004'),('1318120001','1311020011'),('1310070012','1308100005'),('1312020004','1307030007'),('1312020002','1307030003'),('1301130002','1301090001'),('1318130002','1311060007'),('1310060010','1308070012'),('1103020004','1103020011'),('1322010002','1310030002'),('1301040003','1301060007'),('1315010005','1310030008'),('1301090001','1301050001'),('1301100002','1301050006'),('1318120005','1311020012'),('1101060004','1102030004'),('1301040004','1301060009'),('1304010002','1303020104'),('1304040006','1303050004'),('1304010005','1303020102'),('1312030009','1308080001'),('1102030004','1102030005'),('1310060001','1308070001'),('1312030016','1307020011'),('1313010002','1309020004'),('1312010002','1307010104'),('1317010004','1311070002'),('1304060001','1303040003'),('1310020001','1308030101'),('1312020001','1307020018'),('1301040001','1301060001'),('1301070001','1308020008'),('1310080003','1303020105'),('1304010003','1303020109'),('1301060003','1301030006'),('1313050006','1309030002'),('1304010004','1303030001'),('1103010003','1103010004');
INSERT IGNORE INTO `series_links` VALUES ('1000000000','2004-05','2011-12',167.6167,106.9000),('1100000000','2004-05','2011-12',219.9667,111.4417),('1101000000','2004-05','2011-12',211.8250,110.8667),('1101010000','2004-05','2011-12',207.1333,115.1417),('1101010100','2004-05','2011-12',199.8667,114.0667),('1101010101','2004-05','2011-12',194.1583,113.2167),('1101010102','2004-05','2011-12',194.3917,115.2833),('1101010103','2004-05','2011-12',235.8083,96.8083),('1101010104','2004-05','2011-12',233.4750,120.0000),('1101010105','2004-05','2011-12',234.0333,116.0000),('1101010106','2004-05','2011-12',208.0333,115.6333),('1101010107','2004-05','2011-12',278.3083,139.9417),('1101010200','2004-05','2011-12',241.3167,119.9750),('1101010201','2004-05','2011-12',266.3083,135.2750),('1101010202','2004-05','2011-12',199.3500,109.8417),('1101010203','2004-05','2011-12',259.4667,108.5833),('1101010204','2004-05','2011-12',193.8667,115.5417),('1101010205','2004-05','2011-12',227.6667,96.6167),('1101020000','2004-05','2011-12',198.4000,114.9000),('1101020100','2004-05','2011-12',210.0833,123.4833),('1101020101','2004-05','2011-12',206.9500,162.9083),('1101020102','2004-05','2011-12',198.2417,100.2250),('1101020103','2004-05','2011-12',232.5083,126.0833),('1101020104','2004-05','2011-12',286.8917,103.1167),('1101020105','2004-05','2011-12',83.2083,121.3500),('1101020106','2004-05','2011-12',5091.1833,61.4500),('1101020107','2004-05','2011-12',3448.1667,116.5417),('1101020108','2004-05','2011-12',5076.4500,73.6417),('1101020109','2004-05','2011-12',186.1833,110.2167),('1101020110','2004-05','2011-12',232.5583,101.3917),('1101020111','2004-05','2011-12',271.9583,133.1250),('1101020200','2004-05','2011-12',188.7917,104.8500),('1101020201','2004-05','2011-12',210.5250,113.1667),('1101020202','2004-05','2011-12',6739.8250,40.0083),('1101020203','2004-05','2011-12',2681.0417,106.8750),('1101020204','2004-05','2011-12',228.2917,73.6583),('1101020205','2004-05','2011-12',190.5500,99.9833),('1101020206','2004-05','2011-12',115.4417,99.0333),('1101020207','2004-05','2011-12',139.6750,67.8417),('1101020208','2004-05','2011-12',5097.8833,56.3667),('1101020209','2004-05','2011-12',233.4250,120.0167),('1101020210','2004-05','2011-12',99.8333,74.0333),('1101020211','2004-05','2011-12',9179.3250,23.5333),('1101020212','2004-05','2011-12',216.8500,119.7167),('1101020213','2004-05','2011-12',232.8083,114.9583),('1101030000','2004-05','2011-12',208.0500,107.6000),('1101030001','2004-05','2011-12',208.0500,107.6000),('1101040000','2004-05','2011-12',244.5167,113.2833),('1101040001','2004-05','2011-12',195.9917,110.5750),('1101040002','2004-05','2011-12',303.6750,115.0583),('1101040003','2004-05','2011-12',278.7500,114.6000),('1101040004','2004-05','2011-12',220.2583,109.7167),('1101040005','2004-05','2011-12',202.0167,103.5333),('1101040006','2004-05','2011-12',156.8917,118.1250),('1101040007','2004-05','2011-12',240.0583,106.9917),('1101050000','2004-05','2011-12',209.5000,87.1000),('1101050001','2004-05','2011-12',518.9833,129.6167),('1101050002','2004-05','2011-12',235.1333,83.6083),('1101050003','2004-05','2011-12',166.3250,79.8167),('1101050004','2004-05','2011-12',277.2417,109.6500),('1101050005','2004-05','2011-12',91.3083,86.7417),('1101050006','2004-05','2011-12',226.6833,103.8917),('1101050007','2004-05','2011-12',193.0417,102.5000),('1101050008','2004-05','2011-12',110.8667,38.2917),('1101050009','2004-05','2011-12',220.7000,102.5000),('1101060000','2004-05','2011-12',242.1917,102.9000),('1101060001','2004-05','2011-12',198.5583,132.2750),('1101060002','2004-05','2011-12',311.0917,96.9917),('1102000000','2004-05','2011-12',201.9250,113.3333),('1102010000','2004-05','2011-12',208.3250,99.0083),('1102010001','2004-05','2011-12',206.0417,95.0333),('1102010002','2004-05','2011-12',242.3583,110.3167),('1102010003','2004-05','2011-12',222.2333,105.7667),('1102010004','2004-05','2011-12',57.4000,100.0000),('1102010005','2004-05','2011-12',220.7583,122.8417),('1102010006','2004-05','2011-12',209.2000,108.2917),('1102020000','2004-05','2011-12',198.0167,126.8417),('1102020001','2004-05','2011-12',246.9167,120.5250),('1102020002','2004-05','2011-12',202.6500,131.0833),('1102020003','2004-05','2011-12',162.1167,108.7250),('1102020004','2004-05','2011-12',92.3583,80.7833),('1102020005','2004-05','2011-12',312.4000,139.8083),('1102020006','2004-05','2011-12',203.9250,125.3667),('1102020007','2004-05','2011-12',207.5750,84.7333),('1102020008','2004-05','2011-12',192.2917,118.4333),('1102020009','2004-05','2011-12',149.5083,114.4250),('1102020010','2004-05','2011-12',181.7167,112.0167),('1102020011','2004-05','2011-12',211.8583,149.3833),('1102030000','2004-05','2011-12',211.1250,112.0083),('1102030001','2004-05','2011-12',156.6000,103.0833),('1102030002','2004-05','2011-12',83.4000,96.0000),('1102030003','2004-05','2011-12',247.2000,100.0000),('1102030004','2004-05','2011-12',172.5083,101.5000),('1102030005','2004-05','2011-12',96.5167,186.7500),('1102030006','2004-05','2011-12',756.4417,85.1250),('1102030007','2004-05','2011-12',318.2500,111.0000),('1102030008','2004-05','2011-12',145.3000,116.8917),('1102040000','2004-05','2011-12',148.4583,111.2333),('1102040001','2004-05','2011-12',147.5167,115.1000),('1102040002','2004-05','2011-12',154.0583,100.5500),('1102040003','2004-05','2011-12',147.2750,103.8917),('1103000000','2004-05','2011-12',346.9083,118.1833),('1103010000','2004-05','2011-12',438.9500,112.0917),('1103010001','2004-05','2011-12',170.4667,109.7667),('1103010002','2004-05','2011-12',125.6833,89.9500),('1103010003','2004-05','2011-12',313.9750,109.2833),('1103010004','2004-05','2011-12',202.9250,120.0583),('1103010005','2004-05','2011-12',195.6833,103.8500),('1103010006','2004-05','2011-12',623.7167,118.4250),('1103020000','2004-05','2011-12',204.7250,139.4833),('1103020001','2004-05','2011-12',442.4167,145.6417),('1103020002','2004-05','2011-12',219.7000,130.6750),('1103020003','2004-05','2011-12',380.6250,100.5417),('1103020004','2004-05','2011-12',109.9000,86.6500),('1200000000','2004-05','2011-12',186.4917,107.0583),('1300000000','2004-05','2011-12',147.0583,105.2500),('1301000000','2004-05','2011-12',163.4917,108.6583),('1301010000','2004-05','2011-12',176.0500,111.2583),('1301010001','2004-05','2011-12',180.7250,113.6250),('1301010002','2004-05','2011-12',188.3083,106.9250),('1301010003','2004-05','2011-12',173.8417,110.1583),('1301010004','2004-05','2011-12',129.5833,108.8083),('1301020000','2004-05','2011-12',143.9583,100.7083),('1301020001','2004-05','2011-12',156.5083,95.7250),('1301020002','2004-05','2011-12',119.3500,102.9583),('1301030000','2004-05','2011-12',156.0000,104.0417),('1301030001','2004-05','2011-12',152.9167,102.9333),('1301030002','2004-05','2011-12',171.8000,104.6083),('1301030003','2004-05','2011-12',160.8417,106.0583),('1301030004','2004-05','2011-12',175.9000,103.5917),('1301040000','2004-05','2011-12',129.9667,106.2917),('1301040001','2004-05','2011-12',123.0083,103.4000),('1301040002','2004-05','2011-12',153.3083,116.9250),('1301040003','2004-05','2011-12',162.7917,110.8500),('1301050000','2004-05','2011-12',185.7417,103.2917),('1301050001','2004-05','2011-12',193.1000,110.8417),('1301050002','2004-05','2011-12',217.1417,103.7833),('1301050003','2004-05','2011-12',183.6500,102.2833),('1301050004','2004-05','2011-12',102.2833,105.5333),('1301050005','2004-05','2011-12',136.2250,103.5000),('1301060000','2004-05','2011-12',148.1083,112.2917),('1301060001','2004-05','2011-12',125.6167,116.3750),('1301060002','2004-05','2011-12',192.5833,115.2917),('1301060003','2004-05','2011-12',124.7833,119.3917),('1301060004','2004-05','2011-12',154.1167,114.4750),('1301060005','2004-05','2011-12',175.4833,133.2917),('1301060006','2004-05','2011-12',154.2250,127.8667),('1301060007','2004-05','2011-12',162.1833,112.0000),('1301060008','2004-05','2011-12',114.3917,105.5000),('1301060009','2004-05','2011-12',137.9583,108.8417),('1301070000','2004-05','2011-12',210.7500,106.0333),('1301070001','2004-05','2011-12',164.9417,106.0333),('1301080000','2004-05','2011-12',163.2833,107.3250),('1301080001','2004-05','2011-12',178.1333,106.4500),('1301080002','2004-05','2011-12',147.2333,110.3917),('1301080003','2004-05','2011-12',138.4667,108.8417),('1301090000','2004-05','2011-12',182.1500,111.7500),('1301090001','2004-05','2011-12',182.1500,111.6667),('1301100000','2004-05','2011-12',164.6083,105.1250),('1301100001','2004-05','2011-12',159.6750,104.9500),('1301100002','2004-05','2011-12',210.7667,105.3417),('1302000000','2004-05','2011-12',175.3417,104.5250),('1302010000','2004-05','2011-12',124.8333,105.2417),('1302010001','2004-05','2011-12',120.4333,105.4833),('1302010002','2004-05','2011-12',125.5500,101.7583),('1302010003','2004-05','2011-12',137.3917,108.9917),('1302020000','2004-05','2011-12',171.5250,101.7000),('1302020001','2004-05','2011-12',160.2833,101.0750),('1302020002','2004-05','2011-12',205.0750,103.3750),('1302030000','2004-05','2011-12',152.7833,105.7583),('1302030001','2004-05','2011-12',154.6667,105.8333),('1302030002','2004-05','2011-12',153.6333,104.3750),('1303000000','2004-05','2011-12',131.3500,108.4167),('1303010000','2004-05','2011-12',146.2417,108.4167),('1304000000','2004-05','2011-12',170.9583,103.9583),('1304010000','2004-05','2011-12',140.4833,103.8583),('1304010001','2004-05','2011-12',129.4000,104.7500),('1304010002','2004-05','2011-12',148.7583,103.1500),('1304020000','2004-05','2011-12',178.9000,103.6167),('1304020001','2004-05','2011-12',166.9583,101.6583),('1304020002','2004-05','2011-12',145.5000,108.4000),('1304020003','2004-05','2011-12',304.5250,103.2750),('1304020004','2004-05','2011-12',142.5750,102.9417),('1304030000','2004-05','2011-12',193.5917,105.9083),('1304030001','2004-05','2011-12',215.4250,106.0000),('1304030002','2004-05','2011-12',143.0833,104.7250),('1304040000','2004-05','2011-12',146.1250,105.3250),('1304040001','2004-05','2011-12',126.9500,104.3500),('1304040002','2004-05','2011-12',192.4833,98.0083),('1305000000','2004-05','2011-12',136.6083,112.1583),('1305010000','2004-05','2011-12',135.8250,115.2917),('1305010001','2004-05','2011-12',131.4833,122.8750),('1305010002','2004-05','2011-12',148.9417,102.0000),('1305010003','2004-05','2011-12',120.5750,101.9833),('1305010004','2004-05','2011-12',142.8500,106.7667),('1305020000','2004-05','2011-12',128.2000,103.7917),('1305020001','2004-05','2011-12',125.3250,101.2417),('1305020002','2004-05','2011-12',127.9083,110.8583),('1305020003','2004-05','2011-12',134.6250,100.0750),('1305020004','2004-05','2011-12',137.1417,103.3500),('1306000000','2004-05','2011-12',134.2000,107.3250),('1306010000','2004-05','2011-12',112.1667,112.9333),('1306010001','2004-05','2011-12',106.4917,110.5000),('1306010002','2004-05','2011-12',124.8417,112.9333),('1306020000','2004-05','2011-12',149.7917,109.0917),('1306020001','2004-05','2011-12',154.3417,110.6333),('1306020002','2004-05','2011-12',132.2083,103.6833),('1306020003','2004-05','2011-12',205.5500,114.4333),('1306020004','2004-05','2011-12',142.1917,109.1917),('1306030000','2004-05','2011-12',126.9417,104.3917),('1306030001','2004-05','2011-12',117.5500,103.3667),('1306030002','2004-05','2011-12',151.0250,102.4500),('1306030003','2004-05','2011-12',138.6000,106.3000),('1306030004','2004-05','2011-12',129.1667,105.7583),('1306030005','2004-05','2011-12',118.1000,112.0833),('1307000000','2004-05','2011-12',137.5417,110.9083),('1307010000','2004-05','2011-12',163.0833,110.6000),('1307020000','2004-05','2011-12',127.0333,109.8500),('1307020001','2004-05','2011-12',150.5750,106.2667),('1307020002','2004-05','2011-12',115.4667,107.4750),('1307020003','2004-05','2011-12',120.9833,115.1167),('1307030000','2004-05','2011-12',147.3583,110.9500),('1307030001','2004-05','2011-12',164.8250,113.2583),('1307030002','2004-05','2011-12',106.1417,103.6750),('1308000000','2004-05','2011-12',143.6417,103.5833),('1308010000','2004-05','2011-12',147.7833,103.2583),('1308010001','2004-05','2011-12',149.1583,105.0583),('1308010002','2004-05','2011-12',146.8917,102.7167),('1308010003','2004-05','2011-12',176.5167,100.0000),('1308010004','2004-05','2011-12',103.4500,107.2833),('1308010005','2004-05','2011-12',139.1500,102.0083),('1308010006','2004-05','2011-12',147.0250,109.1250),('1308010007','2004-05','2011-12',152.1750,97.0000),('1308010008','2004-05','2011-12',108.8583,103.3667),('1308010009','2004-05','2011-12',184.4667,100.2750),('1308010010','2004-05','2011-12',155.4083,102.6667),('1308010011','2004-05','2011-12',141.0417,105.2000),('1308010012','2004-05','2011-12',158.6833,102.9167),('1308010013','2004-05','2011-12',159.8000,101.8833),('1308020000','2004-05','2011-12',140.2667,107.6917),('1308020001','2004-05','2011-12',138.1667,110.8083),('1308020002','2004-05','2011-12',119.6083,100.5917),('1308020003','2004-05','2011-12',124.7667,109.2000),('1308020004','2004-05','2011-12',115.3000,100.6833),('1308030000','2004-05','2011-12',144.7250,99.9083),('1309000000','2004-05','2011-12',163.2833,110.4500),('1309010000','2004-05','2011-12',164.7083,110.4500),('1309010001','2004-05','2011-12',189.7667,109.4500),('1309010002','2004-05','2011-12',94.4583,108.2083),('1309010003','2004-05','2011-12',126.3750,111.6167),('1309010004','2004-05','2011-12',164.6000,106.5667),('1310000000','2004-05','2011-12',166.0750,108.2917),('1310010000','2004-05','2011-12',156.3333,107.1833),('1310020000','2004-05','2011-12',160.9250,113.4750),('1310030000','2004-05','2011-12',215.9750,108.9417),('1310030001','2004-05','2011-12',487.6250,109.9667),('1310030002','2004-05','2011-12',517.1083,106.4750),('1310030003','2004-05','2011-12',152.4917,109.3000),('1310030004','2004-05','2011-12',117.4333,114.4333),('1310030005','2004-05','2011-12',134.1750,95.7500),('1310030006','2004-05','2011-12',139.2833,114.5167),('1311000000','2004-05','2011-12',128.3583,104.8250),('1311010000','2004-05','2011-12',137.0167,104.8250),('1311010001','2004-05','2011-12',140.7667,100.3000),('1311010002','2004-05','2011-12',126.3583,89.0667),('1311010003','2004-05','2011-12',163.5500,102.4500),('1311010004','2004-05','2011-12',135.1500,105.5917),('1311010005','2004-05','2011-12',135.1000,100.1583),('1312000000','2004-05','2011-12',129.8333,103.7083),('1312010000','2004-05','2011-12',129.0417,103.0917),('1312010001','2004-05','2011-12',122.8833,101.4250),('1312010002','2004-05','2011-12',141.5667,100.0917),('1312010003','2004-05','2011-12',127.4167,101.7167),('1312010004','2004-05','2011-12',127.9833,102.4500),('1312010005','2004-05','2011-12',138.1750,103.3667),('1312010006','2004-05','2011-12',139.8583,101.8750),('1312020000','2004-05','2011-12',130.2417,100.3000),('1312020001','2004-05','2011-12',131.9917,102.9417),('1312020002','2004-05','2011-12',107.1417,102.8083),('1312020003','2004-05','2011-12',143.2083,99.3667),('1312020004','2004-05','2011-12',105.4333,103.6167),('1312020005','2004-05','2011-12',156.0917,107.9833),('1312020006','2004-05','2011-12',109.1250,103.9167),('1312020007','2004-05','2011-12',168.1000,104.3750),('1312020008','2004-05','2011-12',149.5417,90.7833),('1312020009','2004-05','2011-12',111.5333,103.0417),('1312020010','2004-05','2011-12',135.5917,97.1083),('1312030000','2004-05','2011-12',147.3167,104.6750),('1312030001','2004-05','2011-12',129.2750,107.6917),('1312030002','2004-05','2011-12',135.2833,103.8083),('1312030003','2004-05','2011-12',146.2667,99.7833),('1312030004','2004-05','2011-12',161.8917,105.1250),('1312030005','2004-05','2011-12',107.1333,105.0500),('1312030006','2004-05','2011-12',144.5167,108.2000);