--
-- Host: localhost    Database: AMOL316_KMS
-- ------------------------------------------------------


--
-- Table structure for table `account_information`
--

CREATE TABLE `account_information` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `stb_no` varchar(14) NOT NULL,
  `command_id` int(11) NOT NULL,
  `user_name` varchar(100) NOT NULL,
  `group_id` int(11) NOT NULL,
  `lco_id` int(11) NOT NULL,
  `region_pin` int(11) NOT NULL,
  `RTN` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `msg_expiry_date` int(11) NOT NULL DEFAULT '0',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  UNIQUE KEY `transaction_id` (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account_information`
--


--
-- Table structure for table `api_request`
--

CREATE TABLE `api_request` (
  `operator_id` int(20) NOT NULL,
  `count` int(20) NOT NULL,
  `api_type` varchar(20) NOT NULL,
  `req_date` date NOT NULL,
  `max_count` int(11) NOT NULL,
  PRIMARY KEY (`operator_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `api_request`
--

INSERT INTO `api_request` VALUES (44,1039,'POST','2018-05-09',1000000);

--
-- Table structure for table `blacklist_stb`
--

CREATE TABLE `blacklist_stb` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `stb_id` int(11) NOT NULL,
  `chip_no` varchar(16) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blacklist_stb`
--


--
-- Table structure for table `bmail`
--

CREATE TABLE `bmail` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `target_level` int(11) NOT NULL,
  `target` int(11) NOT NULL,
  `display_type` int(11) NOT NULL,
  `subject` varchar(800) CHARACTER SET utf8 NOT NULL,
  `message` varchar(800) CHARACTER SET utf8 NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` int(11) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bmail`
--


--
-- Table structure for table `box_pairing`
--

CREATE TABLE `box_pairing` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `cas_id` int(11) NOT NULL DEFAULT '0',
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `box_pairing`
--


--
-- Table structure for table `box_reset`
--

CREATE TABLE `box_reset` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL,
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `box_reset`
--


--
-- Table structure for table `cas_commands`
--

CREATE TABLE `cas_commands` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmd_id` int(11) NOT NULL,
  `target_level` int(11) DEFAULT '0',
  `stb_no` varchar(30) DEFAULT NULL,
  `trigger_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `payload` varchar(500) NOT NULL,
  `status` varchar(55) NOT NULL DEFAULT 'NACK',
  `msg_expiry_date` bigint(10) NOT NULL,
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cas_commands`
--


--
-- Table structure for table `cas_op_transactions`
--

CREATE TABLE `cas_op_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tx_id` int(11) NOT NULL,
  `cmd_id` int(11) NOT NULL,
  `target_level` int(11) NOT NULL,
  `target` int(11) NOT NULL,
  `stbno` varchar(14) DEFAULT NULL,
  `ack_ctr` int(11) NOT NULL DEFAULT '-1',
  `nack_ctr` int(11) NOT NULL DEFAULT '-1',
  `nack_type` int(11) NOT NULL DEFAULT '0',
  `modify_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `expiry_date` datetime DEFAULT NULL,
  `exp_date` date DEFAULT NULL,
  `initiated_by` varchar(50) NOT NULL,
  `payload` varchar(800) CHARACTER SET utf8 NOT NULL,
  `cmd_type` int(11) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `Unique` (`tx_id`,`cmd_id`),
  KEY `iTarget` (`target`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cas_op_transactions`
--


--
-- Table structure for table `counter`
--

CREATE TABLE `counter` (
  `n` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `counter`
--

INSERT INTO `counter` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),(31),(32),(33),(34),(35),(36),(37),(38),(39),(40),(41),(42),(43),(44),(45),(46),(47),(48),(49),(50),(51),(52),(53),(54),(55),(56),(57),(58),(59),(60),(61),(62),(63),(64),(65),(66),(67),(68),(69),(70),(71),(72),(73),(74),(75),(76),(77),(78),(79),(80),(81),(82),(83),(84),(85),(86),(87),(88),(89),(90),(91),(92),(93),(94),(95),(96),(97),(98),(99),(100),(101),(102),(103),(104),(105),(106),(107),(108),(109),(110),(111),(112),(113),(114),(115),(116),(117),(118),(119),(120),(121),(122),(123),(124),(125),(126),(127),(128),(129),(130),(131),(132),(133),(134),(135),(136),(137),(138),(139),(140),(141),(142),(143),(144),(145),(146),(147),(148),(149),(150),(151),(152),(153),(154),(155),(156),(157),(158),(159),(160),(161),(162),(163),(164),(165),(166),(167),(168),(169),(170),(171),(172),(173),(174),(175),(176),(177),(178),(179),(180),(181),(182),(183),(184),(185),(186),(187),(188),(189),(190),(191),(192),(193),(194),(195),(196),(197),(198),(199),(200),(201),(202),(203),(204),(205),(206),(207),(208),(209),(210),(211),(212),(213),(214),(215),(216),(217),(218),(219),(220),(221),(222),(223),(224),(225),(226),(227),(228),(229),(230),(231),(232),(233),(234),(235),(236),(237),(238),(239),(240),(241),(242),(243),(244),(245),(246),(247),(248),(249),(250),(251),(252),(253),(254),(255),(256),(257),(258),(259),(260),(261),(262),(263),(264),(265),(266),(267),(268),(269),(270),(271),(272),(273),(274),(275),(276),(277),(278),(279),(280),(281),(282),(283),(284),(285),(286),(287),(288),(289),(290),(291),(292),(293),(294),(295),(296),(297),(298),(299),(300),(301),(302),(303),(304),(305),(306),(307),(308),(309),(310),(311),(312),(313),(314),(315),(316),(317),(318),(319),(320),(321),(322),(323),(324),(325),(326),(327),(328),(329),(330),(331),(332),(333),(334),(335),(336),(337),(338),(339),(340),(341),(342),(343),(344),(345),(346),(347),(348),(349),(350),(351),(352),(353),(354),(355),(356),(357),(358),(359),(360),(361),(362),(363),(364),(365),(366),(367),(368),(369),(370),(371),(372),(373),(374),(375),(376),(377),(378),(379),(380),(381),(382),(383),(384),(385),(386),(387),(388),(389),(390),(391),(392),(393),(394),(395),(396),(397),(398),(399),(400),(401),(402),(403),(404),(405),(406),(407),(408),(409),(410),(411),(412),(413),(414),(415),(416),(417),(418),(419),(420),(421),(422),(423),(424),(425),(426),(427),(428),(429),(430),(431),(432),(433),(434),(435),(436),(437),(438),(439),(440),(441),(442),(443),(444),(445),(446),(447),(448),(449),(450),(451),(452),(453),(454),(455),(456),(457),(458),(459),(460),(461),(462),(463),(464),(465),(466),(467),(468),(469),(470),(471),(472),(473),(474),(475),(476),(477),(478),(479),(480),(481),(482),(483),(484),(485),(486),(487),(488),(489),(490),(491),(492),(493),(494),(495),(496),(497),(498),(499),(500),(501),(502),(503),(504),(505),(506),(507),(508),(509),(510),(511),(512),(513),(514),(515),(516),(517),(518),(519),(520),(521),(522),(523),(524),(525),(526),(527),(528),(529),(530),(531),(532),(533),(534),(535),(536),(537),(538),(539),(540),(541),(542),(543),(544),(545),(546),(547),(548),(549),(550),(551),(552),(553),(554),(555),(556),(557),(558),(559),(560),(561),(562),(563),(564),(565),(566),(567),(568),(569),(570),(571),(572),(573),(574),(575),(576),(577),(578),(579),(580),(581),(582),(583),(584),(585),(586),(587),(588),(589),(590),(591),(592),(593),(594),(595),(596),(597),(598),(599),(600),(601),(602),(603),(604),(605),(606),(607),(608),(609),(610),(611),(612),(613),(614),(615),(616),(617),(618),(619),(620),(621),(622),(623),(624),(625),(626),(627),(628),(629),(630),(631),(632),(633),(634),(635),(636),(637),(638),(639),(640),(641),(642),(643),(644),(645),(646),(647),(648),(649),(650),(651),(652),(653),(654),(655),(656),(657),(658),(659),(660),(661),(662),(663),(664),(665),(666),(667),(668),(669),(670),(671),(672),(673),(674),(675),(676),(677),(678),(679),(680),(681),(682),(683),(684),(685),(686),(687),(688),(689),(690),(691),(692),(693),(694),(695),(696),(697),(698),(699),(700),(701),(702),(703),(704),(705),(706),(707),(708),(709),(710),(711),(712),(713),(714),(715),(716),(717),(718),(719),(720),(721),(722),(723),(724),(725),(726),(727),(728),(729),(730),(731),(732),(733),(734),(735),(736),(737),(738),(739),(740),(741),(742),(743),(744),(745),(746),(747),(748),(749),(750),(751),(752),(753),(754),(755),(756),(757),(758),(759),(760),(761),(762),(763),(764),(765),(766),(767),(768),(769),(770),(771),(772),(773),(774),(775),(776),(777),(778),(779),(780),(781),(782),(783),(784),(785),(786),(787),(788),(789),(790),(791),(792),(793),(794),(795),(796),(797),(798),(799),(800),(801),(802),(803),(804),(805),(806),(807),(808),(809),(810),(811),(812),(813),(814),(815),(816),(817),(818),(819),(820),(821),(822),(823),(824),(825),(826),(827),(828),(829),(830),(831),(832),(833),(834),(835),(836),(837),(838),(839),(840),(841),(842),(843),(844),(845),(846),(847),(848),(849),(850),(851),(852),(853),(854),(855),(856),(857),(858),(859),(860),(861),(862),(863),(864),(865),(866),(867),(868),(869),(870),(871),(872),(873),(874),(875),(876),(877),(878),(879),(880),(881),(882),(883),(884),(885),(886),(887),(888),(889),(890),(891),(892),(893),(894),(895),(896),(897),(898),(899),(900),(901),(902),(903),(904),(905),(906),(907),(908),(909),(910),(911),(912),(913),(914),(915),(916),(917),(918),(919),(920),(921),(922),(923),(924),(925),(926),(927),(928),(929),(930),(931),(932),(933),(934),(935),(936),(937),(938),(939),(940),(941),(942),(943),(944),(945),(946),(947),(948),(949),(950),(951),(952),(953),(954),(955),(956),(957),(958),(959),(960),(961),(962),(963),(964),(965),(966),(967),(968),(969),(970),(971),(972),(973),(974),(975),(976),(977),(978),(979),(980),(981),(982),(983),(984),(985),(986),(987),(988),(989),(990),(991),(992),(993),(994),(995),(996),(997),(998),(999),(1000),(1001),(1002),(1003),(1004),(1005),(1006),(1007),(1008),(1009),(1010),(1011),(1012),(1013),(1014),(1015),(1016),(1017),(1018),(1019),(1020),(1021),(1022),(1023),(1024),(1025),(1026),(1027),(1028),(1029),(1030),(1031),(1032),(1033),(1034),(1035),(1036),(1037),(1038),(1039),(1040),(1041),(1042),(1043),(1044),(1045),(1046),(1047),(1048),(1049),(1050),(1051),(1052),(1053),(1054),(1055),(1056),(1057),(1058),(1059),(1060),(1061),(1062),(1063),(1064),(1065),(1066),(1067),(1068),(1069),(1070),(1071),(1072),(1073),(1074),(1075),(1076),(1077),(1078),(1079),(1080),(1081),(1082),(1083),(1084),(1085),(1086),(1087),(1088),(1089),(1090),(1091),(1092),(1093),(1094),(1095),(1096),(1097),(1098),(1099),(1100),(1101),(1102),(1103),(1104),(1105),(1106),(1107),(1108),(1109),(1110),(1111),(1112),(1113),(1114),(1115),(1116),(1117),(1118),(1119),(1120),(1121),(1122),(1123),(1124),(1125),(1126),(1127),(1128),(1129),(1130),(1131),(1132),(1133),(1134),(1135),(1136),(1137),(1138),(1139),(1140),(1141),(1142),(1143),(1144),(1145),(1146),(1147),(1148),(1149),(1150),(1151),(1152),(1153),(1154),(1155),(1156),(1157),(1158),(1159),(1160),(1161),(1162),(1163),(1164),(1165),(1166),(1167),(1168),(1169),(1170),(1171),(1172),(1173),(1174),(1175),(1176),(1177),(1178),(1179),(1180),(1181),(1182),(1183),(1184),(1185),(1186),(1187),(1188),(1189),(1190),(1191),(1192),(1193),(1194),(1195),(1196),(1197),(1198),(1199),(1200),(1201),(1202),(1203),(1204),(1205),(1206),(1207),(1208),(1209),(1210),(1211),(1212),(1213),(1214),(1215),(1216),(1217),(1218),(1219),(1220),(1221),(1222),(1223),(1224),(1225),(1226),(1227),(1228),(1229),(1230),(1231),(1232),(1233),(1234),(1235),(1236),(1237),(1238),(1239),(1240),(1241),(1242),(1243),(1244),(1245),(1246),(1247),(1248),(1249),(1250),(1251),(1252),(1253),(1254),(1255),(1256),(1257),(1258),(1259),(1260),(1261),(1262),(1263),(1264),(1265),(1266),(1267),(1268),(1269),(1270),(1271),(1272),(1273),(1274),(1275),(1276),(1277),(1278),(1279),(1280),(1281),(1282),(1283),(1284),(1285),(1286),(1287),(1288),(1289),(1290),(1291),(1292),(1293),(1294),(1295),(1296),(1297),(1298),(1299),(1300),(1301),(1302),(1303),(1304),(1305),(1306),(1307),(1308),(1309),(1310),(1311),(1312),(1313),(1314),(1315),(1316),(1317),(1318),(1319),(1320),(1321),(1322),(1323),(1324),(1325),(1326),(1327),(1328),(1329),(1330),(1331),(1332),(1333),(1334),(1335),(1336),(1337),(1338),(1339),(1340),(1341),(1342),(1343),(1344),(1345),(1346),(1347),(1348),(1349),(1350),(1351),(1352),(1353),(1354),(1355),(1356),(1357),(1358),(1359),(1360),(1361),(1362),(1363),(1364),(1365),(1366),(1367),(1368),(1369),(1370),(1371),(1372),(1373),(1374),(1375),(1376),(1377),(1378),(1379),(1380),(1381),(1382),(1383),(1384),(1385),(1386),(1387),(1388),(1389),(1390),(1391),(1392),(1393),(1394),(1395),(1396),(1397),(1398),(1399),(1400),(1401),(1402),(1403),(1404),(1405),(1406),(1407),(1408),(1409),(1410),(1411),(1412),(1413),(1414),(1415),(1416),(1417),(1418),(1419),(1420),(1421),(1422),(1423),(1424),(1425),(1426),(1427),(1428),(1429),(1430),(1431),(1432),(1433),(1434),(1435),(1436),(1437),(1438),(1439),(1440),(1441),(1442),(1443),(1444),(1445),(1446),(1447),(1448),(1449),(1450),(1451),(1452),(1453),(1454),(1455),(1456),(1457),(1458),(1459),(1460),(1461),(1462),(1463),(1464),(1465),(1466),(1467),(1468),(1469),(1470),(1471),(1472),(1473),(1474),(1475),(1476),(1477),(1478),(1479),(1480),(1481),(1482),(1483),(1484),(1485),(1486),(1487),(1488),(1489),(1490),(1491),(1492),(1493),(1494),(1495),(1496),(1497),(1498),(1499),(1500),(1501),(1502),(1503),(1504),(1505),(1506),(1507),(1508),(1509),(1510),(1511),(1512),(1513),(1514),(1515),(1516),(1517),(1518),(1519),(1520),(1521),(1522),(1523),(1524),(1525),(1526),(1527),(1528),(1529),(1530),(1531),(1532),(1533),(1534),(1535),(1536),(1537),(1538),(1539),(1540),(1541),(1542),(1543),(1544),(1545),(1546),(1547),(1548),(1549),(1550),(1551),(1552),(1553),(1554),(1555),(1556),(1557),(1558),(1559),(1560),(1561),(1562),(1563),(1564),(1565),(1566),(1567),(1568),(1569),(1570),(1571),(1572),(1573),(1574),(1575),(1576),(1577),(1578),(1579),(1580),(1581),(1582),(1583),(1584),(1585),(1586),(1587),(1588),(1589),(1590),(1591),(1592),(1593),(1594),(1595),(1596),(1597),(1598),(1599),(1600),(1601),(1602),(1603),(1604),(1605),(1606),(1607),(1608),(1609),(1610),(1611),(1612),(1613),(1614),(1615),(1616),(1617),(1618),(1619),(1620),(1621),(1622),(1623),(1624),(1625),(1626),(1627),(1628),(1629),(1630),(1631),(1632),(1633),(1634),(1635),(1636),(1637),(1638),(1639),(1640),(1641),(1642),(1643),(1644),(1645),(1646),(1647),(1648),(1649),(1650),(1651),(1652),(1653),(1654),(1655),(1656),(1657),(1658),(1659),(1660),(1661),(1662),(1663),(1664),(1665),(1666),(1667),(1668),(1669),(1670),(1671),(1672),(1673),(1674),(1675),(1676),(1677),(1678),(1679),(1680),(1681),(1682),(1683),(1684),(1685),(1686),(1687),(1688),(1689),(1690),(1691),(1692),(1693),(1694),(1695),(1696),(1697),(1698),(1699),(1700),(1701),(1702),(1703),(1704),(1705),(1706),(1707),(1708),(1709),(1710),(1711),(1712),(1713),(1714),(1715),(1716),(1717),(1718),(1719),(1720),(1721),(1722),(1723),(1724),(1725),(1726),(1727),(1728),(1729),(1730),(1731),(1732),(1733),(1734),(1735),(1736),(1737),(1738),(1739),(1740),(1741),(1742),(1743),(1744),(1745),(1746),(1747),(1748),(1749),(1750),(1751),(1752),(1753),(1754),(1755),(1756),(1757),(1758),(1759),(1760),(1761),(1762),(1763),(1764),(1765),(1766),(1767),(1768),(1769),(1770),(1771),(1772),(1773),(1774),(1775),(1776),(1777),(1778),(1779),(1780),(1781),(1782),(1783),(1784),(1785),(1786),(1787),(1788),(1789),(1790),(1791),(1792),(1793),(1794),(1795),(1796),(1797),(1798),(1799),(1800),(1801),(1802),(1803),(1804),(1805),(1806),(1807),(1808),(1809),(1810),(1811),(1812),(1813),(1814),(1815),(1816),(1817),(1818),(1819),(1820),(1821),(1822),(1823),(1824),(1825),(1826),(1827),(1828),(1829),(1830),(1831),(1832),(1833),(1834),(1835),(1836),(1837),(1838),(1839),(1840),(1841),(1842),(1843),(1844),(1845),(1846),(1847),(1848),(1849),(1850),(1851),(1852),(1853),(1854),(1855),(1856),(1857),(1858),(1859),(1860),(1861),(1862),(1863),(1864),(1865),(1866),(1867),(1868),(1869),(1870),(1871),(1872),(1873),(1874),(1875),(1876),(1877),(1878),(1879),(1880),(1881),(1882),(1883),(1884),(1885),(1886),(1887),(1888),(1889),(1890),(1891),(1892),(1893),(1894),(1895),(1896),(1897),(1898),(1899),(1900),(1901),(1902),(1903),(1904),(1905),(1906),(1907),(1908),(1909),(1910),(1911),(1912),(1913),(1914),(1915),(1916),(1917),(1918),(1919),(1920),(1921),(1922),(1923),(1924),(1925),(1926),(1927),(1928),(1929),(1930),(1931),(1932),(1933),(1934),(1935),(1936),(1937),(1938),(1939),(1940),(1941),(1942),(1943),(1944),(1945),(1946),(1947),(1948),(1949),(1950),(1951),(1952),(1953),(1954),(1955),(1956),(1957),(1958),(1959),(1960),(1961),(1962),(1963),(1964),(1965),(1966),(1967),(1968),(1969),(1970),(1971),(1972),(1973),(1974),(1975),(1976),(1977),(1978),(1979),(1980),(1981),(1982),(1983),(1984),(1985),(1986),(1987),(1988),(1989),(1990),(1991),(1992),(1993),(1994),(1995),(1996),(1997),(1998),(1999),(2000),(2001),(2002),(2003),(2004),(2005),(2006),(2007),(2008),(2009),(2010),(2011),(2012),(2013),(2014),(2015),(2016),(2017),(2018),(2019),(2020),(2021),(2022),(2023),(2024),(2025),(2026),(2027),(2028),(2029),(2030),(2031),(2032),(2033),(2034),(2035),(2036),(2037),(2038),(2039),(2040),(2041),(2042),(2043),(2044),(2045),(2046),(2047),(2048),(2049),(2050),(2051),(2052),(2053),(2054),(2055),(2056),(2057),(2058),(2059),(2060),(2061),(2062),(2063),(2064),(2065),(2066),(2067),(2068),(2069),(2070),(2071),(2072),(2073),(2074),(2075),(2076),(2077),(2078),(2079),(2080),(2081),(2082),(2083),(2084),(2085),(2086),(2087),(2088),(2089),(2090),(2091),(2092),(2093),(2094),(2095),(2096),(2097),(2098),(2099),(2100),(2101),(2102),(2103),(2104),(2105),(2106),(2107),(2108),(2109),(2110),(2111),(2112),(2113),(2114),(2115),(2116),(2117),(2118),(2119),(2120),(2121),(2122),(2123),(2124),(2125),(2126),(2127),(2128),(2129),(2130),(2131),(2132),(2133),(2134),(2135),(2136),(2137),(2138),(2139),(2140),(2141),(2142),(2143),(2144),(2145),(2146),(2147),(2148),(2149),(2150),(2151),(2152),(2153),(2154),(2155),(2156),(2157),(2158),(2159),(2160),(2161),(2162),(2163),(2164),(2165),(2166),(2167),(2168),(2169),(2170),(2171),(2172),(2173),(2174),(2175),(2176),(2177),(2178),(2179),(2180),(2181),(2182),(2183),(2184),(2185),(2186),(2187),(2188),(2189),(2190),(2191),(2192),(2193),(2194),(2195),(2196),(2197),(2198),(2199),(2200),(2201),(2202),(2203),(2204),(2205),(2206),(2207),(2208),(2209),(2210),(2211),(2212),(2213),(2214),(2215),(2216),(2217),(2218),(2219),(2220),(2221),(2222),(2223),(2224),(2225),(2226),(2227),(2228),(2229),(2230),(2231),(2232),(2233),(2234),(2235),(2236),(2237),(2238),(2239),(2240),(2241),(2242),(2243),(2244),(2245),(2246),(2247),(2248),(2249),(2250),(2251),(2252),(2253),(2254),(2255),(2256),(2257),(2258),(2259),(2260),(2261),(2262),(2263),(2264),(2265),(2266),(2267),(2268),(2269),(2270),(2271),(2272),(2273),(2274),(2275),(2276),(2277),(2278),(2279),(2280),(2281),(2282),(2283),(2284),(2285),(2286),(2287),(2288),(2289),(2290),(2291),(2292),(2293),(2294),(2295),(2296),(2297),(2298),(2299),(2300),(2301),(2302),(2303),(2304),(2305),(2306),(2307),(2308),(2309),(2310),(2311),(2312),(2313),(2314),(2315),(2316),(2317),(2318),(2319),(2320),(2321),(2322),(2323),(2324),(2325),(2326),(2327),(2328),(2329),(2330),(2331),(2332),(2333),(2334),(2335),(2336),(2337),(2338),(2339),(2340),(2341),(2342),(2343),(2344),(2345),(2346),(2347),(2348),(2349),(2350),(2351),(2352),(2353),(2354),(2355),(2356),(2357),(2358),(2359),(2360),(2361),(2362),(2363),(2364),(2365),(2366),(2367),(2368),(2369),(2370),(2371),(2372),(2373),(2374),(2375),(2376),(2377),(2378),(2379),(2380),(2381),(2382),(2383),(2384),(2385),(2386),(2387),(2388),(2389),(2390),(2391),(2392),(2393),(2394),(2395),(2396),(2397),(2398),(2399),(2400),(2401),(2402),(2403),(2404),(2405),(2406),(2407),(2408),(2409),(2410),(2411),(2412),(2413),(2414),(2415),(2416),(2417),(2418),(2419),(2420),(2421),(2422),(2423),(2424),(2425),(2426),(2427),(2428),(2429),(2430),(2431),(2432),(2433),(2434),(2435),(2436),(2437),(2438),(2439),(2440),(2441),(2442),(2443),(2444),(2445),(2446),(2447),(2448),(2449),(2450),(2451),(2452),(2453),(2454),(2455),(2456),(2457),(2458),(2459),(2460),(2461),(2462),(2463),(2464),(2465),(2466),(2467),(2468),(2469),(2470),(2471),(2472),(2473),(2474),(2475),(2476),(2477),(2478),(2479),(2480),(2481),(2482),(2483),(2484),(2485),(2486),(2487),(2488),(2489),(2490),(2491),(2492),(2493),(2494),(2495),(2496),(2497),(2498),(2499),(2500),(2501),(2502),(2503),(2504),(2505),(2506),(2507),(2508),(2509),(2510),(2511),(2512),(2513),(2514),(2515),(2516),(2517),(2518),(2519),(2520),(2521),(2522),(2523),(2524),(2525),(2526),(2527),(2528),(2529),(2530),(2531),(2532),(2533),(2534),(2535),(2536),(2537),(2538),(2539),(2540),(2541),(2542),(2543),(2544),(2545),(2546),(2547),(2548),(2549),(2550),(2551),(2552),(2553),(2554),(2555),(2556),(2557),(2558),(2559),(2560),(2561),(2562),(2563),(2564),(2565),(2566),(2567),(2568),(2569),(2570),(2571),(2572),(2573),(2574),(2575),(2576),(2577),(2578),(2579),(2580),(2581),(2582),(2583),(2584),(2585),(2586),(2587),(2588),(2589),(2590),(2591),(2592),(2593),(2594),(2595),(2596),(2597),(2598),(2599),(2600),(2601),(2602),(2603),(2604),(2605),(2606),(2607),(2608),(2609),(2610),(2611),(2612),(2613),(2614),(2615),(2616),(2617),(2618),(2619),(2620),(2621),(2622),(2623),(2624),(2625),(2626),(2627),(2628),(2629),(2630),(2631),(2632),(2633),(2634),(2635),(2636),(2637),(2638),(2639),(2640),(2641),(2642),(2643),(2644),(2645),(2646),(2647),(2648),(2649),(2650),(2651),(2652),(2653),(2654),(2655),(2656),(2657),(2658),(2659),(2660),(2661),(2662),(2663),(2664),(2665),(2666),(2667),(2668),(2669),(2670),(2671),(2672),(2673),(2674),(2675),(2676),(2677),(2678),(2679),(2680),(2681),(2682),(2683),(2684),(2685),(2686),(2687),(2688),(2689),(2690),(2691),(2692),(2693),(2694),(2695),(2696),(2697),(2698),(2699),(2700),(2701),(2702),(2703),(2704),(2705),(2706),(2707),(2708),(2709),(2710),(2711),(2712),(2713),(2714),(2715),(2716),(2717),(2718),(2719),(2720),(2721),(2722),(2723),(2724),(2725),(2726),(2727),(2728),(2729),(2730),(2731),(2732),(2733),(2734),(2735),(2736),(2737),(2738),(2739),(2740),(2741),(2742),(2743),(2744),(2745),(2746),(2747),(2748),(2749),(2750),(2751),(2752),(2753),(2754),(2755),(2756),(2757),(2758),(2759),(2760),(2761),(2762),(2763),(2764),(2765),(2766),(2767),(2768),(2769),(2770),(2771),(2772),(2773),(2774),(2775),(2776),(2777),(2778),(2779),(2780),(2781),(2782),(2783),(2784),(2785),(2786),(2787),(2788),(2789),(2790),(2791),(2792),(2793),(2794),(2795),(2796),(2797),(2798),(2799),(2800),(2801),(2802),(2803),(2804),(2805),(2806),(2807),(2808),(2809),(2810),(2811),(2812),(2813),(2814),(2815),(2816),(2817),(2818),(2819),(2820),(2821),(2822),(2823),(2824),(2825),(2826),(2827),(2828),(2829),(2830),(2831),(2832),(2833),(2834),(2835),(2836),(2837),(2838),(2839),(2840),(2841),(2842),(2843),(2844),(2845),(2846),(2847),(2848),(2849),(2850),(2851),(2852),(2853),(2854),(2855),(2856),(2857),(2858),(2859),(2860),(2861),(2862),(2863),(2864),(2865),(2866),(2867),(2868),(2869),(2870),(2871),(2872),(2873),(2874),(2875),(2876),(2877),(2878),(2879),(2880),(2881),(2882),(2883),(2884),(2885),(2886),(2887),(2888),(2889),(2890),(2891),(2892),(2893),(2894),(2895),(2896),(2897),(2898),(2899),(2900),(2901),(2902),(2903),(2904),(2905),(2906),(2907),(2908),(2909),(2910),(2911),(2912),(2913),(2914),(2915),(2916),(2917),(2918),(2919),(2920),(2921),(2922),(2923),(2924),(2925),(2926),(2927),(2928),(2929),(2930),(2931),(2932),(2933),(2934),(2935),(2936),(2937),(2938),(2939),(2940),(2941),(2942),(2943),(2944),(2945),(2946),(2947),(2948),(2949),(2950),(2951),(2952),(2953),(2954),(2955),(2956),(2957),(2958),(2959),(2960),(2961),(2962),(2963),(2964),(2965),(2966),(2967),(2968),(2969),(2970),(2971),(2972),(2973),(2974),(2975),(2976),(2977),(2978),(2979),(2980),(2981),(2982),(2983),(2984),(2985),(2986),(2987),(2988),(2989),(2990),(2991),(2992),(2993),(2994),(2995),(2996),(2997),(2998),(2999),(3000),(3001),(3002),(3003),(3004),(3005),(3006),(3007),(3008),(3009),(3010),(3011),(3012),(3013),(3014),(3015),(3016),(3017),(3018),(3019),(3020),(3021),(3022),(3023),(3024),(3025),(3026),(3027),(3028),(3029),(3030),(3031),(3032),(3033),(3034),(3035),(3036),(3037),(3038),(3039),(3040),(3041),(3042),(3043),(3044),(3045),(3046),(3047),(3048),(3049),(3050),(3051),(3052),(3053),(3054),(3055),(3056),(3057),(3058),(3059),(3060),(3061),(3062),(3063),(3064),(3065),(3066),(3067),(3068),(3069),(3070),(3071),(3072),(3073),(3074),(3075),(3076),(3077),(3078),(3079),(3080),(3081),(3082),(3083),(3084),(3085),(3086),(3087),(3088),(3089),(3090),(3091),(3092),(3093),(3094),(3095),(3096),(3097),(3098),(3099),(3100),(3101),(3102),(3103),(3104),(3105),(3106),(3107),(3108),(3109),(3110),(3111),(3112),(3113),(3114),(3115),(3116),(3117),(3118),(3119),(3120),(3121),(3122),(3123),(3124),(3125),(3126),(3127),(3128),(3129),(3130),(3131),(3132),(3133),(3134),(3135),(3136),(3137),(3138),(3139),(3140),(3141),(3142),(3143),(3144),(3145),(3146),(3147),(3148),(3149),(3150),(3151),(3152),(3153),(3154),(3155),(3156),(3157),(3158),(3159),(3160),(3161),(3162),(3163),(3164),(3165),(3166),(3167),(3168),(3169),(3170),(3171),(3172),(3173),(3174),(3175),(3176),(3177),(3178),(3179),(3180),(3181),(3182),(3183),(3184),(3185),(3186),(3187),(3188),(3189),(3190),(3191),(3192),(3193),(3194),(3195),(3196),(3197),(3198),(3199),(3200),(3201),(3202),(3203),(3204),(3205),(3206),(3207),(3208),(3209),(3210),(3211),(3212),(3213),(3214),(3215),(3216),(3217),(3218),(3219),(3220),(3221),(3222),(3223),(3224),(3225),(3226),(3227),(3228),(3229),(3230),(3231),(3232),(3233),(3234),(3235),(3236),(3237),(3238),(3239),(3240),(3241),(3242),(3243),(3244),(3245),(3246),(3247),(3248),(3249),(3250),(3251),(3252),(3253),(3254),(3255),(3256),(3257),(3258),(3259),(3260),(3261),(3262),(3263),(3264),(3265),(3266),(3267),(3268),(3269),(3270),(3271),(3272),(3273),(3274),(3275),(3276),(3277),(3278),(3279),(3280),(3281),(3282),(3283),(3284),(3285),(3286),(3287),(3288),(3289),(3290),(3291),(3292),(3293),(3294),(3295),(3296),(3297),(3298),(3299),(3300),(3301),(3302),(3303),(3304),(3305),(3306),(3307),(3308),(3309),(3310),(3311),(3312),(3313),(3314),(3315),(3316),(3317),(3318),(3319),(3320),(3321),(3322),(3323),(3324),(3325),(3326),(3327),(3328),(3329),(3330),(3331),(3332),(3333),(3334),(3335),(3336),(3337),(3338),(3339),(3340),(3341),(3342),(3343),(3344),(3345),(3346),(3347),(3348),(3349),(3350),(3351),(3352),(3353),(3354),(3355),(3356),(3357),(3358),(3359),(3360),(3361),(3362),(3363),(3364),(3365),(3366),(3367),(3368),(3369),(3370),(3371),(3372),(3373),(3374),(3375),(3376),(3377),(3378),(3379),(3380),(3381),(3382),(3383),(3384),(3385),(3386),(3387),(3388),(3389),(3390),(3391),(3392),(3393),(3394),(3395),(3396),(3397),(3398),(3399),(3400),(3401),(3402),(3403),(3404),(3405),(3406),(3407),(3408),(3409),(3410),(3411),(3412),(3413),(3414),(3415),(3416),(3417),(3418),(3419),(3420),(3421),(3422),(3423),(3424),(3425),(3426),(3427),(3428),(3429),(3430),(3431),(3432),(3433),(3434),(3435),(3436),(3437),(3438),(3439),(3440),(3441),(3442),(3443),(3444),(3445),(3446),(3447),(3448),(3449),(3450),(3451),(3452),(3453),(3454),(3455),(3456),(3457),(3458),(3459),(3460),(3461),(3462),(3463),(3464),(3465),(3466),(3467),(3468),(3469),(3470),(3471),(3472),(3473),(3474),(3475),(3476),(3477),(3478),(3479),(3480),(3481),(3482),(3483),(3484),(3485),(3486),(3487),(3488),(3489),(3490),(3491),(3492),(3493),(3494),(3495),(3496),(3497),(3498),(3499),(3500),(3501),(3502),(3503),(3504),(3505),(3506),(3507),(3508),(3509),(3510),(3511),(3512),(3513),(3514),(3515),(3516),(3517),(3518),(3519),(3520),(3521),(3522),(3523),(3524),(3525),(3526),(3527),(3528),(3529),(3530),(3531),(3532),(3533),(3534),(3535),(3536),(3537),(3538),(3539),(3540),(3541),(3542),(3543),(3544),(3545),(3546),(3547),(3548),(3549),(3550),(3551),(3552),(3553),(3554),(3555),(3556),(3557),(3558),(3559),(3560),(3561),(3562),(3563),(3564),(3565),(3566),(3567),(3568),(3569),(3570),(3571),(3572),(3573),(3574),(3575),(3576),(3577),(3578),(3579),(3580),(3581),(3582),(3583),(3584),(3585),(3586),(3587),(3588),(3589),(3590),(3591),(3592),(3593),(3594),(3595),(3596),(3597),(3598),(3599),(3600),(3601),(3602),(3603),(3604),(3605),(3606),(3607),(3608),(3609),(3610),(3611),(3612),(3613),(3614),(3615),(3616),(3617),(3618),(3619),(3620),(3621),(3622),(3623),(3624),(3625),(3626),(3627),(3628),(3629),(3630),(3631),(3632),(3633),(3634),(3635),(3636),(3637),(3638),(3639),(3640),(3641),(3642),(3643),(3644),(3645),(3646),(3647),(3648),(3649),(3650),(3651),(3652),(3653),(3654),(3655),(3656),(3657),(3658),(3659),(3660),(3661),(3662),(3663),(3664),(3665),(3666),(3667),(3668),(3669),(3670),(3671),(3672),(3673),(3674),(3675),(3676),(3677),(3678),(3679),(3680),(3681),(3682),(3683),(3684),(3685),(3686),(3687),(3688),(3689),(3690),(3691),(3692),(3693),(3694),(3695),(3696),(3697),(3698),(3699),(3700),(3701),(3702),(3703),(3704),(3705),(3706),(3707),(3708),(3709),(3710),(3711),(3712),(3713),(3714),(3715),(3716),(3717),(3718),(3719),(3720),(3721),(3722),(3723),(3724),(3725),(3726),(3727),(3728),(3729),(3730),(3731),(3732),(3733),(3734),(3735),(3736),(3737),(3738),(3739),(3740),(3741),(3742),(3743),(3744),(3745),(3746),(3747),(3748),(3749),(3750),(3751),(3752),(3753),(3754),(3755),(3756),(3757),(3758),(3759),(3760),(3761),(3762),(3763),(3764),(3765),(3766),(3767),(3768),(3769),(3770),(3771),(3772),(3773),(3774),(3775),(3776),(3777),(3778),(3779),(3780),(3781),(3782),(3783),(3784),(3785),(3786),(3787),(3788),(3789),(3790),(3791),(3792),(3793),(3794),(3795),(3796),(3797),(3798),(3799),(3800),(3801),(3802),(3803),(3804),(3805),(3806),(3807),(3808),(3809),(3810),(3811),(3812),(3813),(3814),(3815),(3816),(3817),(3818),(3819),(3820),(3821),(3822),(3823),(3824),(3825),(3826),(3827),(3828),(3829),(3830),(3831),(3832),(3833),(3834),(3835),(3836),(3837),(3838),(3839),(3840),(3841),(3842),(3843),(3844),(3845),(3846),(3847),(3848),(3849),(3850),(3851),(3852),(3853),(3854),(3855),(3856),(3857),(3858),(3859),(3860),(3861),(3862),(3863),(3864),(3865),(3866),(3867),(3868),(3869),(3870),(3871),(3872),(3873),(3874),(3875),(3876),(3877),(3878),(3879),(3880),(3881),(3882),(3883),(3884),(3885),(3886),(3887),(3888),(3889),(3890),(3891),(3892),(3893),(3894),(3895),(3896),(3897),(3898),(3899),(3900),(3901),(3902),(3903),(3904),(3905),(3906),(3907),(3908),(3909),(3910),(3911),(3912),(3913),(3914),(3915),(3916),(3917),(3918),(3919),(3920),(3921),(3922),(3923),(3924),(3925),(3926),(3927),(3928),(3929),(3930),(3931),(3932),(3933),(3934),(3935),(3936),(3937),(3938),(3939),(3940),(3941),(3942),(3943),(3944),(3945),(3946),(3947),(3948),(3949),(3950),(3951),(3952),(3953),(3954),(3955),(3956),(3957),(3958),(3959),(3960),(3961),(3962),(3963),(3964),(3965),(3966),(3967),(3968),(3969),(3970),(3971),(3972),(3973),(3974),(3975),(3976),(3977),(3978),(3979),(3980),(3981),(3982),(3983),(3984),(3985),(3986),(3987),(3988),(3989),(3990),(3991),(3992),(3993),(3994),(3995),(3996),(3997),(3998),(3999),(4000),(4001),(4002),(4003),(4004),(4005),(4006),(4007),(4008),(4009),(4010),(4011),(4012),(4013),(4014),(4015),(4016),(4017),(4018),(4019),(4020),(4021),(4022),(4023),(4024),(4025),(4026),(4027),(4028),(4029),(4030),(4031),(4032),(4033),(4034),(4035),(4036),(4037),(4038),(4039),(4040),(4041),(4042),(4043),(4044),(4045),(4046),(4047),(4048),(4049),(4050),(4051),(4052),(4053),(4054),(4055),(4056),(4057),(4058),(4059),(4060),(4061),(4062),(4063),(4064),(4065),(4066),(4067),(4068),(4069),(4070),(4071),(4072),(4073),(4074),(4075),(4076),(4077),(4078),(4079),(4080),(4081),(4082),(4083),(4084),(4085),(4086),(4087),(4088),(4089),(4090),(4091),(4092),(4093),(4094),(4095),(4096),(4097),(4098),(4099),(4100),(4101),(4102),(4103),(4104),(4105),(4106),(4107),(4108),(4109),(4110),(4111),(4112),(4113),(4114),(4115),(4116),(4117),(4118),(4119),(4120),(4121),(4122),(4123),(4124),(4125),(4126),(4127),(4128),(4129),(4130),(4131),(4132),(4133),(4134),(4135),(4136),(4137),(4138),(4139),(4140),(4141),(4142),(4143),(4144),(4145),(4146),(4147),(4148),(4149),(4150),(4151),(4152),(4153),(4154),(4155),(4156),(4157),(4158),(4159),(4160),(4161),(4162),(4163),(4164),(4165),(4166),(4167),(4168),(4169),(4170),(4171),(4172),(4173),(4174),(4175),(4176),(4177),(4178),(4179),(4180),(4181),(4182),(4183),(4184),(4185),(4186),(4187),(4188),(4189),(4190),(4191),(4192),(4193),(4194),(4195),(4196),(4197),(4198),(4199),(4200),(4201),(4202),(4203),(4204),(4205),(4206),(4207),(4208),(4209),(4210),(4211),(4212),(4213),(4214),(4215),(4216),(4217),(4218),(4219),(4220),(4221),(4222),(4223),(4224),(4225),(4226),(4227),(4228),(4229),(4230),(4231),(4232),(4233),(4234),(4235),(4236),(4237),(4238),(4239),(4240),(4241),(4242),(4243),(4244),(4245),(4246),(4247),(4248),(4249),(4250),(4251),(4252),(4253),(4254),(4255),(4256),(4257),(4258),(4259),(4260),(4261),(4262),(4263),(4264),(4265),(4266),(4267),(4268),(4269),(4270),(4271),(4272),(4273),(4274),(4275),(4276),(4277),(4278),(4279),(4280),(4281),(4282),(4283),(4284),(4285),(4286),(4287),(4288),(4289),(4290),(4291),(4292),(4293),(4294),(4295),(4296),(4297),(4298),(4299),(4300),(4301),(4302),(4303),(4304),(4305),(4306),(4307),(4308),(4309),(4310),(4311),(4312),(4313),(4314),(4315),(4316),(4317),(4318),(4319),(4320),(4321),(4322),(4323),(4324),(4325),(4326),(4327),(4328),(4329),(4330),(4331),(4332),(4333),(4334),(4335),(4336),(4337),(4338),(4339),(4340),(4341),(4342),(4343),(4344),(4345),(4346),(4347),(4348),(4349),(4350),(4351),(4352),(4353),(4354),(4355),(4356),(4357),(4358),(4359),(4360),(4361),(4362),(4363),(4364),(4365),(4366),(4367),(4368),(4369),(4370),(4371),(4372),(4373),(4374),(4375),(4376),(4377),(4378),(4379),(4380),(4381),(4382),(4383),(4384),(4385),(4386),(4387),(4388),(4389),(4390),(4391),(4392),(4393),(4394),(4395),(4396),(4397),(4398),(4399),(4400),(4401),(4402),(4403),(4404),(4405),(4406),(4407),(4408),(4409),(4410),(4411),(4412),(4413),(4414),(4415),(4416),(4417),(4418),(4419),(4420),(4421),(4422),(4423),(4424),(4425),(4426),(4427),(4428),(4429),(4430),(4431),(4432),(4433),(4434),(4435),(4436),(4437),(4438),(4439),(4440),(4441),(4442),(4443),(4444),(4445),(4446),(4447),(4448),(4449),(4450),(4451),(4452),(4453),(4454),(4455),(4456),(4457),(4458),(4459),(4460),(4461),(4462),(4463),(4464),(4465),(4466),(4467),(4468),(4469),(4470),(4471),(4472),(4473),(4474),(4475),(4476),(4477),(4478),(4479),(4480),(4481),(4482),(4483),(4484),(4485),(4486),(4487),(4488),(4489),(4490),(4491),(4492),(4493),(4494),(4495),(4496),(4497),(4498),(4499),(4500),(4501),(4502),(4503),(4504),(4505),(4506),(4507),(4508),(4509),(4510),(4511),(4512),(4513),(4514),(4515),(4516),(4517),(4518),(4519),(4520),(4521),(4522),(4523),(4524),(4525),(4526),(4527),(4528),(4529),(4530),(4531),(4532),(4533),(4534),(4535),(4536),(4537),(4538),(4539),(4540),(4541),(4542),(4543),(4544),(4545),(4546),(4547),(4548),(4549),(4550),(4551),(4552),(4553),(4554),(4555),(4556),(4557),(4558),(4559),(4560),(4561),(4562),(4563),(4564),(4565),(4566),(4567),(4568),(4569),(4570),(4571),(4572),(4573),(4574),(4575),(4576),(4577),(4578),(4579),(4580),(4581),(4582),(4583),(4584),(4585),(4586),(4587),(4588),(4589),(4590),(4591),(4592),(4593),(4594),(4595),(4596),(4597),(4598),(4599),(4600),(4601),(4602),(4603),(4604),(4605),(4606),(4607),(4608),(4609),(4610),(4611),(4612),(4613),(4614),(4615),(4616),(4617),(4618),(4619),(4620),(4621),(4622),(4623),(4624),(4625),(4626),(4627),(4628),(4629),(4630),(4631),(4632),(4633),(4634),(4635),(4636),(4637),(4638),(4639),(4640),(4641),(4642),(4643),(4644),(4645),(4646),(4647),(4648),(4649),(4650),(4651),(4652),(4653),(4654),(4655),(4656),(4657),(4658),(4659),(4660),(4661),(4662),(4663),(4664),(4665),(4666),(4667),(4668),(4669),(4670),(4671),(4672),(4673),(4674),(4675),(4676),(4677),(4678),(4679),(4680),(4681),(4682),(4683),(4684),(4685),(4686),(4687),(4688),(4689),(4690),(4691),(4692),(4693),(4694),(4695),(4696),(4697),(4698),(4699),(4700),(4701),(4702),(4703),(4704),(4705),(4706),(4707),(4708),(4709),(4710),(4711),(4712),(4713),(4714),(4715),(4716),(4717),(4718),(4719),(4720),(4721),(4722),(4723),(4724),(4725),(4726),(4727),(4728),(4729),(4730),(4731),(4732),(4733),(4734),(4735),(4736),(4737),(4738),(4739),(4740),(4741),(4742),(4743),(4744),(4745),(4746),(4747),(4748),(4749),(4750),(4751),(4752),(4753),(4754),(4755),(4756),(4757),(4758),(4759),(4760),(4761),(4762),(4763),(4764),(4765),(4766),(4767),(4768),(4769),(4770),(4771),(4772),(4773),(4774),(4775),(4776),(4777),(4778),(4779),(4780),(4781),(4782),(4783),(4784),(4785),(4786),(4787),(4788),(4789),(4790),(4791),(4792),(4793),(4794),(4795),(4796),(4797),(4798),(4799),(4800),(4801),(4802),(4803),(4804),(4805),(4806),(4807),(4808),(4809),(4810),(4811),(4812),(4813),(4814),(4815),(4816),(4817),(4818),(4819),(4820),(4821),(4822),(4823),(4824),(4825),(4826),(4827),(4828),(4829),(4830),(4831),(4832),(4833),(4834),(4835),(4836),(4837),(4838),(4839),(4840),(4841),(4842),(4843),(4844),(4845),(4846),(4847),(4848),(4849),(4850),(4851),(4852),(4853),(4854),(4855),(4856),(4857),(4858),(4859),(4860),(4861),(4862),(4863),(4864),(4865),(4866),(4867),(4868),(4869),(4870),(4871),(4872),(4873),(4874),(4875),(4876),(4877),(4878),(4879),(4880),(4881),(4882),(4883),(4884),(4885),(4886),(4887),(4888),(4889),(4890),(4891),(4892),(4893),(4894),(4895),(4896),(4897),(4898),(4899),(4900),(4901),(4902),(4903),(4904),(4905),(4906),(4907),(4908),(4909),(4910),(4911),(4912),(4913),(4914),(4915),(4916),(4917),(4918),(4919),(4920),(4921),(4922),(4923),(4924),(4925),(4926),(4927),(4928),(4929),(4930),(4931),(4932),(4933),(4934),(4935),(4936),(4937),(4938),(4939),(4940),(4941),(4942),(4943),(4944),(4945),(4946),(4947),(4948),(4949),(4950),(4951),(4952),(4953),(4954),(4955),(4956),(4957),(4958),(4959),(4960),(4961),(4962),(4963),(4964),(4965),(4966),(4967),(4968),(4969),(4970),(4971),(4972),(4973),(4974),(4975),(4976),(4977),(4978),(4979),(4980),(4981),(4982),(4983),(4984),(4985),(4986),(4987),(4988),(4989),(4990),(4991),(4992),(4993),(4994),(4995),(4996),(4997),(4998),(4999),(5000);

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `country_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `iso_code_2` varchar(2) NOT NULL,
  `iso_code_3` varchar(3) NOT NULL,
  `address_format` text NOT NULL,
  `postcode_required` tinyint(1) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`country_id`)
) ENGINE=MyISAM AUTO_INCREMENT=258 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `country`
--

INSERT INTO `country` VALUES (1,'Afghanistan','AF','AFG','',0,1),(2,'Albania','AL','ALB','',0,1),(3,'Algeria','DZ','DZA','',0,1),(4,'American Samoa','AS','ASM','',0,1),(5,'Andorra','AD','AND','',0,1),(6,'Angola','AO','AGO','',0,1),(7,'Anguilla','AI','AIA','',0,1),(8,'Antarctica','AQ','ATA','',0,1),(9,'Antigua and Barbuda','AG','ATG','',0,1),(10,'Argentina','AR','ARG','',0,1),(11,'Armenia','AM','ARM','',0,1),(12,'Aruba','AW','ABW','',0,1),(13,'Australia','AU','AUS','',0,1),(14,'Austria','AT','AUT','',0,1),(15,'Azerbaijan','AZ','AZE','',0,1),(16,'Bahamas','BS','BHS','',0,1),(17,'Bahrain','BH','BHR','',0,1),(18,'Bangladesh','BD','BGD','',0,1),(19,'Barbados','BB','BRB','',0,1),(20,'Belarus','BY','BLR','',0,1),(21,'Belgium','BE','BEL','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{postcode} {city}\r\n{country}',0,1),(22,'Belize','BZ','BLZ','',0,1),(23,'Benin','BJ','BEN','',0,1),(24,'Bermuda','BM','BMU','',0,1),(25,'Bhutan','BT','BTN','',0,1),(26,'Bolivia','BO','BOL','',0,1),(27,'Bosnia and Herzegovina','BA','BIH','',0,1),(28,'Botswana','BW','BWA','',0,1),(29,'Bouvet Island','BV','BVT','',0,1),(30,'Brazil','BR','BRA','',0,1),(31,'British Indian Ocean Territory','IO','IOT','',0,1),(32,'Brunei Darussalam','BN','BRN','',0,1),(33,'Bulgaria','BG','BGR','',0,1),(34,'Burkina Faso','BF','BFA','',0,1),(35,'Burundi','BI','BDI','',0,1),(36,'Cambodia','KH','KHM','',0,1),(37,'Cameroon','CM','CMR','',0,1),(38,'Canada','CA','CAN','',0,1),(39,'Cape Verde','CV','CPV','',0,1),(40,'Cayman Islands','KY','CYM','',0,1),(41,'Central African Republic','CF','CAF','',0,1),(42,'Chad','TD','TCD','',0,1),(43,'Chile','CL','CHL','',0,1),(44,'China','CN','CHN','',0,1),(45,'Christmas Island','CX','CXR','',0,1),(46,'Cocos (Keeling) Islands','CC','CCK','',0,1),(47,'Colombia','CO','COL','',0,1),(48,'Comoros','KM','COM','',0,1),(49,'Congo','CG','COG','',0,1),(50,'Cook Islands','CK','COK','',0,1),(51,'Costa Rica','CR','CRI','',0,1),(52,'Cote D\'Ivoire','CI','CIV','',0,1),(53,'Croatia','HR','HRV','',0,1),(54,'Cuba','CU','CUB','',0,1),(55,'Cyprus','CY','CYP','',0,1),(56,'Czech Republic','CZ','CZE','',0,1),(57,'Denmark','DK','DNK','',0,1),(58,'Djibouti','DJ','DJI','',0,1),(59,'Dominica','DM','DMA','',0,1),(60,'Dominican Republic','DO','DOM','',0,1),(61,'East Timor','TL','TLS','',0,1),(62,'Ecuador','EC','ECU','',0,1),(63,'Egypt','EG','EGY','',0,1),(64,'El Salvador','SV','SLV','',0,1),(65,'Equatorial Guinea','GQ','GNQ','',0,1),(66,'Eritrea','ER','ERI','',0,1),(67,'Estonia','EE','EST','',0,1),(68,'Ethiopia','ET','ETH','',0,1),(69,'Falkland Islands (Malvinas)','FK','FLK','',0,1),(70,'Faroe Islands','FO','FRO','',0,1),(71,'Fiji','FJ','FJI','',0,1),(72,'Finland','FI','FIN','',0,1),(74,'France, Metropolitan','FR','FRA','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{postcode} {city}\r\n{country}',1,1),(75,'French Guiana','GF','GUF','',0,1),(76,'French Polynesia','PF','PYF','',0,1),(77,'French Southern Territories','TF','ATF','',0,1),(78,'Gabon','GA','GAB','',0,1),(79,'Gambia','GM','GMB','',0,1),(80,'Georgia','GE','GEO','',0,1),(81,'Germany','DE','DEU','{company}\r\n{firstname} {lastname}\r\n{address_1}\r\n{address_2}\r\n{postcode} {city}\r\n{country}',1,1),(82,'Ghana','GH','GHA','',0,1),(83,'Gibraltar','GI','GIB','',0,1),(84,'Greece','GR','GRC','',0,1),(85,'Greenland','GL','GRL','',0,1),(86,'Grenada','GD','GRD','',0,1),(87,'Guadeloupe','GP','GLP','',0,1),(88,'Guam','GU','GUM','',0,1),(89,'Guatemala','GT','GTM','',0,1),(90,'Guinea','GN','GIN','',0,1),(91,'Guinea-Bissau','GW','GNB','',0,1),(92,'Guyana','GY','GUY','',0,1),(93,'Haiti','HT','HTI','',0,1),(94,'Heard and Mc Donald Islands','HM','HMD','',0,1),(95,'Honduras','HN','HND','',0,1),(96,'Hong Kong','HK','HKG','',0,1),(97,'Hungary','HU','HUN','',0,1),(98,'Iceland','IS','ISL','',0,1),(99,'India','IN','IND','',0,1),(100,'Indonesia','ID','IDN','',0,1),(101,'Iran (Islamic Republic of)','IR','IRN','',0,1),(102,'Iraq','IQ','IRQ','',0,1),(103,'Ireland','IE','IRL','',0,1),(104,'Israel','IL','ISR','',0,1),(105,'Italy','IT','ITA','',0,1),(106,'Jamaica','JM','JAM','',0,1),(107,'Japan','JP','JPN','',0,1),(108,'Jordan','JO','JOR','',0,1),(109,'Kazakhstan','KZ','KAZ','',0,1),(110,'Kenya','KE','KEN','',0,1),(111,'Kiribati','KI','KIR','',0,1),(112,'North Korea','KP','PRK','',0,1),(113,'South Korea','KR','KOR','',0,1),(114,'Kuwait','KW','KWT','',0,1),(115,'Kyrgyzstan','KG','KGZ','',0,1),(116,'Lao People\'s Democratic Republic','LA','LAO','',0,1),(117,'Latvia','LV','LVA','',0,1),(118,'Lebanon','LB','LBN','',0,1),(119,'Lesotho','LS','LSO','',0,1),(120,'Liberia','LR','LBR','',0,1),(121,'Libyan Arab Jamahiriya','LY','LBY','',0,1),(122,'Liechtenstein','LI','LIE','',0,1),(123,'Lithuania','LT','LTU','',0,1),(124,'Luxembourg','LU','LUX','',0,1),(125,'Macau','MO','MAC','',0,1),(126,'FYROM','MK','MKD','',0,1),(127,'Madagascar','MG','MDG','',0,1),(128,'Malawi','MW','MWI','',0,1),(129,'Malaysia','MY','MYS','',0,1),(130,'Maldives','MV','MDV','',0,1),(131,'Mali','ML','MLI','',0,1),(132,'Malta','MT','MLT','',0,1),(133,'Marshall Islands','MH','MHL','',0,1),(134,'Martinique','MQ','MTQ','',0,1),(135,'Mauritania','MR','MRT','',0,1),(136,'Mauritius','MU','MUS','',0,1),(137,'Mayotte','YT','MYT','',0,1),(138,'Mexico','MX','MEX','',0,1),(139,'Micronesia, Federated States of','FM','FSM','',0,1),(140,'Moldova, Republic of','MD','MDA','',0,1),(141,'Monaco','MC','MCO','',0,1),(142,'Mongolia','MN','MNG','',0,1),(143,'Montserrat','MS','MSR','',0,1),(144,'Morocco','MA','MAR','',0,1),(145,'Mozambique','MZ','MOZ','',0,1),(146,'Myanmar','MM','MMR','',0,1),(147,'Namibia','NA','NAM','',0,1),(148,'Nauru','NR','NRU','',0,1),(149,'Nepal','NP','NPL','',0,1),(150,'Netherlands','NL','NLD','',0,1),(151,'Netherlands Antilles','AN','ANT','',0,1),(152,'New Caledonia','NC','NCL','',0,1),(153,'New Zealand','NZ','NZL','',0,1),(154,'Nicaragua','NI','NIC','',0,1),(155,'Niger','NE','NER','',0,1),(156,'Nigeria','NG','NGA','',0,1),(157,'Niue','NU','NIU','',0,1),(158,'Norfolk Island','NF','NFK','',0,1),(159,'Northern Mariana Islands','MP','MNP','',0,1),(160,'Norway','NO','NOR','',0,1),(161,'Oman','OM','OMN','',0,1),(162,'Pakistan','PK','PAK','',0,1),(163,'Palau','PW','PLW','',0,1),(164,'Panama','PA','PAN','',0,1),(165,'Papua New Guinea','PG','PNG','',0,1),(166,'Paraguay','PY','PRY','',0,1),(167,'Peru','PE','PER','',0,1),(168,'Philippines','PH','PHL','',0,1),(169,'Pitcairn','PN','PCN','',0,1),(170,'Poland','PL','POL','',0,1),(171,'Portugal','PT','PRT','',0,1),(172,'Puerto Rico','PR','PRI','',0,1),(173,'Qatar','QA','QAT','',0,1),(174,'Reunion','RE','REU','',0,1),(175,'Romania','RO','ROM','',0,1),(176,'Russian Federation','RU','RUS','',0,1),(177,'Rwanda','RW','RWA','',0,1),(178,'Saint Kitts and Nevis','KN','KNA','',0,1),(179,'Saint Lucia','LC','LCA','',0,1),(180,'Saint Vincent and the Grenadines','VC','VCT','',0,1),(181,'Samoa','WS','WSM','',0,1),(182,'San Marino','SM','SMR','',0,1),(183,'Sao Tome and Principe','ST','STP','',0,1),(184,'Saudi Arabia','SA','SAU','',0,1),(185,'Senegal','SN','SEN','',0,1),(186,'Seychelles','SC','SYC','',0,1),(187,'Sierra Leone','SL','SLE','',0,1),(188,'Singapore','SG','SGP','',0,1),(189,'Slovak Republic','SK','SVK','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}',0,1),(190,'Slovenia','SI','SVN','',0,1),(191,'Solomon Islands','SB','SLB','',0,1),(192,'Somalia','SO','SOM','',0,1),(193,'South Africa','ZA','ZAF','',0,1),(194,'South Georgia &amp; South Sandwich Islands','GS','SGS','',0,1),(195,'Spain','ES','ESP','',0,1),(196,'Sri Lanka','LK','LKA','',0,1),(197,'St. Helena','SH','SHN','',0,1),(198,'St. Pierre and Miquelon','PM','SPM','',0,1),(199,'Sudan','SD','SDN','',0,1),(200,'Suriname','SR','SUR','',0,1),(201,'Svalbard and Jan Mayen Islands','SJ','SJM','',0,1),(202,'Swaziland','SZ','SWZ','',0,1),(203,'Sweden','SE','SWE','{company}\r\n{firstname} {lastname}\r\n{address_1}\r\n{address_2}\r\n{postcode} {city}\r\n{country}',1,1),(204,'Switzerland','CH','CHE','',0,1),(205,'Syrian Arab Republic','SY','SYR','',0,1),(206,'Taiwan','TW','TWN','',0,1),(207,'Tajikistan','TJ','TJK','',0,1),(208,'Tanzania, United Republic of','TZ','TZA','',0,1),(209,'Thailand','TH','THA','',0,1),(210,'Togo','TG','TGO','',0,1),(211,'Tokelau','TK','TKL','',0,1),(212,'Tonga','TO','TON','',0,1),(213,'Trinidad and Tobago','TT','TTO','',0,1),(214,'Tunisia','TN','TUN','',0,1),(215,'Turkey','TR','TUR','',0,1),(216,'Turkmenistan','TM','TKM','',0,1),(217,'Turks and Caicos Islands','TC','TCA','',0,1),(218,'Tuvalu','TV','TUV','',0,1),(219,'Uganda','UG','UGA','',0,1),(220,'Ukraine','UA','UKR','',0,1),(221,'United Arab Emirates','AE','ARE','',0,1),(222,'United Kingdom','GB','GBR','',1,1),(223,'United States','US','USA','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city}, {zone} {postcode}\r\n{country}',0,1),(224,'United States Minor Outlying Islands','UM','UMI','',0,1),(225,'Uruguay','UY','URY','',0,1),(226,'Uzbekistan','UZ','UZB','',0,1),(227,'Vanuatu','VU','VUT','',0,1),(228,'Vatican City State (Holy See)','VA','VAT','',0,1),(229,'Venezuela','VE','VEN','',0,1),(230,'Viet Nam','VN','VNM','',0,1),(231,'Virgin Islands (British)','VG','VGB','',0,1),(232,'Virgin Islands (U.S.)','VI','VIR','',0,1),(233,'Wallis and Futuna Islands','WF','WLF','',0,1),(234,'Western Sahara','EH','ESH','',0,1),(235,'Yemen','YE','YEM','',0,1),(237,'Democratic Republic of Congo','CD','COD','',0,1),(238,'Zambia','ZM','ZMB','',0,1),(239,'Zimbabwe','ZW','ZWE','',0,1),(242,'Montenegro','ME','MNE','',0,1),(243,'Serbia','RS','SRB','',0,1),(244,'Aaland Islands','AX','ALA','',0,1),(245,'Bonaire, Sint Eustatius and Saba','BQ','BES','',0,1),(246,'Curacao','CW','CUW','',0,1),(247,'Palestinian Territory, Occupied','PS','PSE','',0,1),(248,'South Sudan','SS','SSD','',0,1),(249,'St. Barthelemy','BL','BLM','',0,1),(250,'St. Martin (French part)','MF','MAF','',0,1),(251,'Canary Islands','IC','ICA','',0,1),(252,'Ascension Island (British)','AC','ASC','',0,1),(253,'Kosovo, Republic of','XK','UNK','',0,1),(254,'Isle of Man','IM','IMN','',0,1),(255,'Tristan da Cunha','TA','SHN','',0,1),(256,'Guernsey','GG','GGY','',0,1),(257,'Jersey','JE','JEY','',0,1);

--
-- Table structure for table `db_upgradation_version`
--

CREATE TABLE `db_upgradation_version` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `prev_version` varchar(15) NOT NULL DEFAULT '0',
  `current_version` varchar(15) NOT NULL DEFAULT '0',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `db_upgradation_version`
--

INSERT INTO `db_upgradation_version` VALUES (1,'3.3','3.3','2017-06-17 11:37:46');

--
-- Table structure for table `fingerprint_ecm`
--

CREATE TABLE `fingerprint_ecm` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `is_random` tinyint(1) NOT NULL,
  `is_covert` tinyint(1) NOT NULL,
  `display_duration` int(11) NOT NULL,
  `location_x` int(11) NOT NULL,
  `location_y` int(11) NOT NULL,
  `font_style` int(11) NOT NULL,
  `font_size` int(11) NOT NULL,
  `text_color` varchar(6) NOT NULL,
  `background_color` varchar(6) NOT NULL,
  `content_identifier` int(11) NOT NULL,
  `covert_pattern` int(11) NOT NULL,
  `gap` int(11) NOT NULL DEFAULT '10',
  `end_time` bigint(10) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` int(11) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fingerprint_ecm`
--


--
-- Table structure for table `fingerprint_emm`
--

CREATE TABLE `fingerprint_emm` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `target_level` int(11) NOT NULL,
  `target` int(11) NOT NULL,
  `is_random` tinyint(1) NOT NULL,
  `is_covert` tinyint(1) NOT NULL,
  `display_duration` int(11) NOT NULL,
  `location_x` int(11) NOT NULL,
  `location_y` int(11) NOT NULL,
  `font_style` int(11) NOT NULL,
  `font_size` int(11) NOT NULL,
  `text_color` varchar(6) NOT NULL,
  `background_color` varchar(6) NOT NULL,
  `content_identifier` int(8) NOT NULL,
  `covert_pattern` int(11) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fingerprint_emm`
--


--
-- Table structure for table `force_nit_tunning`
--

CREATE TABLE `force_nit_tunning` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `target_level` int(11) NOT NULL,
  `target` int(11) NOT NULL,
  `uri` varchar(255) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` int(11) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `force_nit_tunning`
--


--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(100) NOT NULL,
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `groups`
--


--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `language_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `code` varchar(5) NOT NULL,
  `locale` varchar(255) NOT NULL,
  `image` varchar(64) NOT NULL,
  `directory` varchar(32) NOT NULL,
  `sort_order` int(3) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`language_id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `language`
--

INSERT INTO `language` VALUES (1,'English','en-gb','en-US,en_US.UTF-8,en_US,en-gb,english','gb.png','english',1,1);

--
-- Table structure for table `lco`
--

CREATE TABLE `lco` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lco_id` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `firstname` varchar(32) NOT NULL,
  `lastname` varchar(32) NOT NULL,
  `mobile_no` bigint(10) DEFAULT '0',
  `email` varchar(50) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `is_suspend` tinyint(1) NOT NULL DEFAULT '0',
  `date_added` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lco_id` (`lco_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lco`
--

INSERT INTO `lco` VALUES (1,1,'admin','admin  ','admin ',0,'bydesign@gmail.com','',1,0,'2016-09-07 16:26:28');

--
-- Table structure for table `logCasCommands`
--

CREATE TABLE `logCasCommands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tx_id` int(11) NOT NULL,
  `command_id` int(11) NOT NULL,
  `target` varchar(30) NOT NULL,
  `target_level` int(11) NOT NULL,
  `datetime` datetime DEFAULT NULL,
  `status` varchar(30) NOT NULL,
  `resend` tinyint(1) NOT NULL DEFAULT '0',
  `targetNo` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logCasCommands`
--


--
-- Table structure for table `logDescription`
--

CREATE TABLE `logDescription` (
  `command_id` int(11) NOT NULL,
  `description` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logDescription`
--

INSERT INTO `logDescription` VALUES (0,'STB ACTIVATION'),(1,'STB DEACTIVATION'),(2,'OTA'),(3,'ENABLE OSD'),(4,'INSERT WATERMARK'),(5,'DISPLAY INFO MESSAGE'),(6,'PACKAGE ENTITLEMENT'),(7,'PACKAGE DEENTITLEMENT'),(8,'PACKAGE INCLUSION LIST'),(9,'PACKAGE EXCLUSION LIST'),(10,'SERVICE ENTITLEMENT'),(11,'SERVICE DEENTITLEMENT'),(12,'ACCOUNT INFORMATION'),(15,'SERVICE TUNNING'),(16,'SPECIAL COMMANDS'),(17,'FORCE NIT TUNNING'),(18,'PPV ENTITLEMENT'),(19,'PPV DEENTITLEMENT'),(20,'MULITILINGUAL BMAIL'),(200,'DELETE FROM PLAYOUT QUEUE'),(201,'RECOVERY PLAYOUT QUEUE'),(252,'DELETE ECM ACCESS CRITERIA'),(253,'ECM ACCESS CRITERIA'),(254,'ECM PARENTAL RATING'),(255,'ECM FINGERPRINT'),(256,'ECM EVENT INSERTION'),(257,'ECM PPV DELETION'),(258,'ECM RECOVER FROM DB'),(5001,'STB ENABLE'),(5002,'STB DISABLE'),(5003,'REGION ENABLE'),(5004,'REGION DISBALE'),(5005,'GROUP ENABLE'),(5006,'GROUP DISBALE'),(5007,'USER ENABLE'),(5008,'USER DISABLE'),(5009,'USER UPDATE'),(5010,'USER UNPAIR'),(5011,'PRODUCT ENABLE'),(5012,'PRODUCT DISABLE'),(5013,'PPV ENABLE'),(5014,'PPV DISABLE'),(5015,'PACKAGE ENABLE'),(5016,'PACKAGE DISABLE'),(5017,'ADD PRODUCT TO PACKAGE'),(5018,'DELETE PRODUCT FROM PACKAGE'),(5019,'ENABLE LCO'),(5020,'STB MOVE'),(23,'SUSPEND/RESUME');

--
-- Table structure for table `logKmsCommands`
--

CREATE TABLE `logKmsCommands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) DEFAULT '-1',
  `payload` varchar(200) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logKmsCommands`
--


--
-- Table structure for table `logPackageModification`
--

CREATE TABLE `logPackageModification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_number` int(11) NOT NULL,
  `package_name` varchar(30) NOT NULL,
  `startdate` datetime DEFAULT NULL,
  `enddate` datetime DEFAULT NULL,
  `batchno` bigint(10) NOT NULL,
  `status` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logPackageModification`
--


--
-- Table structure for table `logPkgProductModification`
--

CREATE TABLE `logPkgProductModification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `batchno` bigint(10) NOT NULL,
  `product_number` int(11) NOT NULL,
  `product_name` varchar(30) NOT NULL,
  `status` varchar(30) NOT NULL,
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logPkgProductModification`
--


--
-- Table structure for table `logProductModification`
--

CREATE TABLE `logProductModification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_number` int(11) NOT NULL,
  `product_name` varchar(50) DEFAULT NULL,
  `lcn` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `access_criteria` int(11) NOT NULL,
  `startdate` datetime DEFAULT NULL,
  `enddate` datetime DEFAULT NULL,
  `action` varchar(30) DEFAULT NULL,
  `status` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logProductModification`
--


--
-- Table structure for table `logStbModification`
--

CREATE TABLE `logStbModification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stbno` varchar(14) DEFAULT NULL,
  `oldChipNo` varchar(32) DEFAULT NULL,
  `newChipNo` varchar(32) DEFAULT NULL,
  `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logStbModification`
--


--
-- Table structure for table `logTargetLevel`
--

CREATE TABLE `logTargetLevel` (
  `target_level` int(11) NOT NULL,
  `target_description` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logTargetLevel`
--

INSERT INTO `logTargetLevel` VALUES (1,'Individual'),(2,'Global'),(3,'Region'),(4,'Group'),(5,'LCO');

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login`
--

INSERT INTO `login` VALUES (1,'admin','admin');

--
-- Table structure for table `login_attempt`
--

CREATE TABLE `login_attempt` (
  `attempts` int(1) NOT NULL,
  `lastlogin` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login_attempt`
--


--
-- Table structure for table `mass_package_entitle`
--

CREATE TABLE `mass_package_entitle` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `service_key_list` varchar(3000) NOT NULL,
  `end_time` bigint(10) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mass_package_entitle`
--


--
-- Table structure for table `multilanguage_bmail`
--

CREATE TABLE `multilanguage_bmail` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `target_level` int(11) NOT NULL,
  `target` int(11) NOT NULL,
  `bmail_id` int(11) NOT NULL,
  `display_type` int(11) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` int(11) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `multilanguage_bmail`
--


--
-- Table structure for table `osd`
--

CREATE TABLE `osd` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `target_level` int(11) NOT NULL,
  `target` int(11) NOT NULL,
  `display_type` int(11) NOT NULL,
  `language` varchar(64) NOT NULL,
  `content_identifier` int(8) NOT NULL,
  `expiry` bigint(10) NOT NULL,
  `transparency` int(5) NOT NULL,
  `message` varchar(800) CHARACTER SET utf8 NOT NULL,
  `background_color` varchar(20) NOT NULL,
  `foreground_color` varchar(20) NOT NULL,
  `forced` int(2) NOT NULL,
  `is_scrolling` tinyint(1) NOT NULL DEFAULT '0',
  `start_time` datetime DEFAULT NULL,
  `polarization` int(1) NOT NULL,
  `marque` int(1) NOT NULL ,
  `width` int(11) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` int(11) NOT NULL,
  `trigger_from` int(1) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `osd`
--


--
-- Table structure for table `package_exclusion_list`
--

CREATE TABLE `package_exclusion_list` (
  `package_id` int(11) NOT NULL,
  `channel_list` varchar(3000) NOT NULL,
  PRIMARY KEY (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `package_exclusion_list`
--


--
-- Table structure for table `package_subscription`
--

CREATE TABLE `package_subscription` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `stbno` varchar(14) DEFAULT NULL,
  `package_id` int(11) NOT NULL,
  `package_key_id` int(11) NOT NULL DEFAULT '0',
  `start_time` bigint(20) NOT NULL DEFAULT '0',
  `end_time` bigint(20) NOT NULL DEFAULT '0',
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`transaction_id`),
  KEY `iPackUserid` (`user_id`),
  KEY `MQ_msg_id` (`MQ_msg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `package_subscription`
--


--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `package_id` int(11) NOT NULL AUTO_INCREMENT,
  `package_name` varchar(100) NOT NULL,
  `package_number` int(11) NOT NULL,
  `is_enabled` tinyint(1) NOT NULL,
  `package_key_id` int(11) NOT NULL,
  PRIMARY KEY (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `packages`
--


--
-- Table structure for table `parental_lock`
--

CREATE TABLE `parental_lock` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `age` int(11) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` int(11) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `parental_lock`
--


--
-- Table structure for table `pin_reset`
--

CREATE TABLE `pin_reset` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `pin` int(5) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pin_reset`
--


--
-- Table structure for table `ping`
--

CREATE TABLE `ping` (
  `sr_no` int(11) NOT NULL AUTO_INCREMENT,
  `serial_no` int(10) NOT NULL,
  `ping_res` int(10) NOT NULL,
  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `up_time` varchar(40) NOT NULL,
  `cpu` varchar(20) NOT NULL,
  `mem` varchar(20) NOT NULL,
  PRIMARY KEY (`sr_no`),
  KEY `serial_no` (`serial_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ping`
--


--
-- Table structure for table `ppv`
--

CREATE TABLE `ppv` (
  `ppv_id` int(11) NOT NULL AUTO_INCREMENT,
  `ppv_name` varchar(30) NOT NULL,
  `is_enable` tinyint(4) NOT NULL,
  `product_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `start_time` int(11) NOT NULL,
  `end_time` int(11) NOT NULL,
  UNIQUE KEY `ppv_id` (`ppv_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ppv`
--


--
-- Table structure for table `ppv_subscription`
--

CREATE TABLE `ppv_subscription` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ppv_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `service_key_id` int(11) NOT NULL DEFAULT '0',
  `start_time` bigint(20) NOT NULL DEFAULT '0',
  `end_time` bigint(20) NOT NULL DEFAULT '0',
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_Msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enable` tinyint(1) NOT NULL,
  UNIQUE KEY `transaction_id` (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ppv_subscription`
--


--
-- Table structure for table `product_subscription`
--

CREATE TABLE `product_subscription` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `stbno` varchar(14) DEFAULT NULL,
  `product_id` int(11) NOT NULL,
  `service_key_id` int(11) NOT NULL DEFAULT '0',
  `start_time` bigint(20) NOT NULL DEFAULT '0',
  `end_time` bigint(20) NOT NULL DEFAULT '0',
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_subscription`
--


--
-- Table structure for table `product_to_package`
--

CREATE TABLE `product_to_package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `package_id` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_to_package`
--


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(100) NOT NULL,
  `product_number` int(6) DEFAULT '0',
  `lcn` int(6) DEFAULT '0',
  `access_criteria` int(6) DEFAULT '0',
  `is_enabled` tinyint(1) NOT NULL,
  `service_id` int(6) DEFAULT '0',
  `service_key_id` int(11) NOT NULL,
  `is_nvod` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `region`
--

CREATE TABLE `region` (
  `region_id` int(11) NOT NULL AUTO_INCREMENT,
  `region_name` varchar(100) NOT NULL,
  `pin` int(11) NOT NULL,
  `region_no` int(11) NOT NULL DEFAULT '0',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`region_id`),
  UNIQUE KEY `pin` (`pin`),
  UNIQUE KEY `pin_2` (`pin`),
  UNIQUE KEY `pin_3` (`pin`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `region`
--


--
-- Table structure for table `service_tunning`
--

CREATE TABLE `service_tunning` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `target_level` int(11) NOT NULL,
  `target` int(11) NOT NULL,
  `lcn` int(11) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `service_tunning`
--


--
-- Table structure for table `set_uri`
--

CREATE TABLE `set_uri` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `uri_data` varchar(255) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) DEFAULT NULL,
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `set_uri`
--


--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) NOT NULL DEFAULT '0',
  `code` varchar(32) NOT NULL,
  `key` varchar(64) NOT NULL,
  `value` text NOT NULL,
  `serialized` tinyint(1) NOT NULL,
  PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=265 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` VALUES (254,0,'config','config_compression','0',0),(255,0,'config','config_secure','0',0),(256,0,'config','config_password','1',0),(257,0,'config','config_shared','0',0),(258,0,'config','config_encryption','esf9URoXd7TAjIVKGzk6RUvGPTjJOqTMZZkfRzoOZ9fcFI2SfmIvdfRnF7A5mYNvJeE9SAJ7FzsY0C8KkxinoNC1MECykTNnHRyIlnocyiqy5iQ5v1asLFHUEvm44NwpPLkQd4ylprtsUwUoXJwhIEJqwVxJwDvdfKWxigbJCjOwYGGQfUEE9FFahslO7ZSeDa0gYIGdOjqQ4VFyGKBfAfo5wewV8oroCdHM1ZCGJIenw3cUlq377E7hPxhjz0SRe4Z0jbuZsm0eS6Y0SE0TLaZvpp4dMng1JZxRJTGEt4XC3S51I5bqxrTqw4LZvAz5ZHT8ETAxWqHrFixhL5VMtxqsD16Pnb32CFJ6rQZH3XwUbGGTvYrsRxxr0ZsyPi06zXLhAxJlEK02WVxKZjn894LSoDCUcubuXa0joEcyQPi4oGBZZaVX4uqmzC54WXYpYRShC2VuYgKETQtccq7kpnHZdsy47kFdluXyAGCldiCpxF643T8yH93r5Gm47lP0w1YK5Obzi7fNic4Dv7DG5Ufw6FFZ6ZBmesty7XMnjp6Ne4scsG8PuqODbbpJahyNxIGQLmIrGpbO2r5ptCwr6ry0Ms6e1Lp08z1ZOsCB2dsURpA73xqaiNuirqXbbEGHoeelKAiFoHRAwD3c134m2fFVBkhUSzQBdtVAnHu6VUPq9Ntfhaprmckp0atNQz2aAeZ4ZxWjmWSobOmSiZZVpqYS7BxKuSQRy4Y4OxjC1h7iHkN4s5LDkzU6sjP5j9ValEbMNtNQUCmxcw6tpUBkdwWbQIAgS6RKJEWaSZyZMUr9nLh6YTRoN2IpY7foCj6CPekNANs7CRo6E27IaeGAkTgWmEauh3h9DcG3zxI6XNwi8vWUCfK6024k8PmHXkRw3yXVniQHlWQ91PE5750bWXLleAX0vmBHjJzxLyVTKRsZfA4k8MpZZiGdpkcPrZCELYbtzGioto9aLRl4gwBEoFMEviDuaeMeMYQxBxx1l5FRvlLUIGRFEK56hHktFZYp',0),(4,0,'voucher','voucher_sort_order','8',0),(5,0,'voucher','voucher_status','1',0),(253,0,'config','config_robots','abot\r\ndbot\r\nebot\r\nhbot\r\nkbot\r\nlbot\r\nmbot\r\nnbot\r\nobot\r\npbot\r\nrbot\r\nsbot\r\ntbot\r\nvbot\r\nybot\r\nzbot\r\nbot.\r\nbot/\r\n_bot\r\n.bot\r\n/bot\r\n-bot\r\n:bot\r\n(bot\r\ncrawl\r\nslurp\r\nspider\r\nseek\r\naccoona\r\nacoon\r\nadressendeutschland\r\nah-ha.com\r\nahoy\r\naltavista\r\nananzi\r\nanthill\r\nappie\r\narachnophilia\r\narale\r\naraneo\r\naranha\r\narchitext\r\naretha\r\narks\r\nasterias\r\natlocal\r\natn\r\natomz\r\naugurfind\r\nbackrub\r\nbannana_bot\r\nbaypup\r\nbdfetch\r\nbig brother\r\nbiglotron\r\nbjaaland\r\nblackwidow\r\nblaiz\r\nblog\r\nblo.\r\nbloodhound\r\nboitho\r\nbooch\r\nbradley\r\nbutterfly\r\ncalif\r\ncassandra\r\nccubee\r\ncfetch\r\ncharlotte\r\nchurl\r\ncienciaficcion\r\ncmc\r\ncollective\r\ncomagent\r\ncombine\r\ncomputingsite\r\ncsci\r\ncurl\r\ncusco\r\ndaumoa\r\ndeepindex\r\ndelorie\r\ndepspid\r\ndeweb\r\ndie blinde kuh\r\ndigger\r\nditto\r\ndmoz\r\ndocomo\r\ndownload express\r\ndtaagent\r\ndwcp\r\nebiness\r\nebingbong\r\ne-collector\r\nejupiter\r\nemacs-w3 search engine\r\nesther\r\nevliya celebi\r\nezresult\r\nfalcon\r\nfelix ide\r\nferret\r\nfetchrover\r\nfido\r\nfindlinks\r\nfireball\r\nfish search\r\nfouineur\r\nfunnelweb\r\ngazz\r\ngcreep\r\ngenieknows\r\ngetterroboplus\r\ngeturl\r\nglx\r\ngoforit\r\ngolem\r\ngrabber\r\ngrapnel\r\ngralon\r\ngriffon\r\ngromit\r\ngrub\r\ngulliver\r\nhamahakki\r\nharvest\r\nhavindex\r\nhelix\r\nheritrix\r\nhku www octopus\r\nhomerweb\r\nhtdig\r\nhtml index\r\nhtml_analyzer\r\nhtmlgobble\r\nhubater\r\nhyper-decontextualizer\r\nia_archiver\r\nibm_planetwide\r\nichiro\r\niconsurf\r\niltrovatore\r\nimage.kapsi.net\r\nimagelock\r\nincywincy\r\nindexer\r\ninfobee\r\ninformant\r\ningrid\r\ninktomisearch.com\r\ninspector web\r\nintelliagent\r\ninternet shinchakubin\r\nip3000\r\niron33\r\nisraeli-search\r\nivia\r\njack\r\njakarta\r\njavabee\r\njetbot\r\njumpstation\r\nkatipo\r\nkdd-explorer\r\nkilroy\r\nknowledge\r\nkototoi\r\nkretrieve\r\nlabelgrabber\r\nlachesis\r\nlarbin\r\nlegs\r\nlibwww\r\nlinkalarm\r\nlink validator\r\nlinkscan\r\nlockon\r\nlwp\r\nlycos\r\nmagpie\r\nmantraagent\r\nmapoftheinternet\r\nmarvin/\r\nmattie\r\nmediafox\r\nmediapartners\r\nmercator\r\nmerzscope\r\nmicrosoft url control\r\nminirank\r\nmiva\r\nmj12\r\nmnogosearch\r\nmoget\r\nmonster\r\nmoose\r\nmotor\r\nmultitext\r\nmuncher\r\nmuscatferret\r\nmwd.search\r\nmyweb\r\nnajdi\r\nnameprotect\r\nnationaldirectory\r\nnazilla\r\nncsa beta\r\nnec-meshexplorer\r\nnederland.zoek\r\nnetcarta webmap engine\r\nnetmechanic\r\nnetresearchserver\r\nnetscoop\r\nnewscan-online\r\nnhse\r\nnokia6682/\r\nnomad\r\nnoyona\r\nnutch\r\nnzexplorer\r\nobjectssearch\r\noccam\r\nomni\r\nopen text\r\nopenfind\r\nopenintelligencedata\r\norb search\r\nosis-project\r\npack rat\r\npageboy\r\npagebull\r\npage_verifier\r\npanscient\r\nparasite\r\npartnersite\r\npatric\r\npear.\r\npegasus\r\nperegrinator\r\npgp key agent\r\nphantom\r\nphpdig\r\npicosearch\r\npiltdownman\r\npimptrain\r\npinpoint\r\npioneer\r\npiranha\r\nplumtreewebaccessor\r\npogodak\r\npoirot\r\npompos\r\npoppelsdorf\r\npoppi\r\npopular iconoclast\r\npsycheclone\r\npublisher\r\npython\r\nrambler\r\nraven search\r\nroach\r\nroad runner\r\nroadhouse\r\nrobbie\r\nrobofox\r\nrobozilla\r\nrules\r\nsalty\r\nsbider\r\nscooter\r\nscoutjet\r\nscrubby\r\nsearch.\r\nsearchprocess\r\nsemanticdiscovery\r\nsenrigan\r\nsg-scout\r\nshai\'hulud\r\nshark\r\nshopwiki\r\nsidewinder\r\nsift\r\nsilk\r\nsimmany\r\nsite searcher\r\nsite valet\r\nsitetech-rover\r\nskymob.com\r\nsleek\r\nsmartwit\r\nsna-\r\nsnappy\r\nsnooper\r\nsohu\r\nspeedfind\r\nsphere\r\nsphider\r\nspinner\r\nspyder\r\nsteeler/\r\nsuke\r\nsuntek\r\nsupersnooper\r\nsurfnomore\r\nsven\r\nsygol\r\nszukacz\r\ntach black widow\r\ntarantula\r\ntempleton\r\n/teoma\r\nt-h-u-n-d-e-r-s-t-o-n-e\r\ntheophrastus\r\ntitan\r\ntitin\r\ntkwww\r\ntoutatis\r\nt-rex\r\ntutorgig\r\ntwiceler\r\ntwisted\r\nucsd\r\nudmsearch\r\nurl check\r\nupdated\r\nvagabondo\r\nvalkyrie\r\nverticrawl\r\nvictoria\r\nvision-search\r\nvolcano\r\nvoyager/\r\nvoyager-hc\r\nw3c_validator\r\nw3m2\r\nw3mir\r\nwalker\r\nwallpaper\r\nwanderer\r\nwauuu\r\nwavefire\r\nweb core\r\nweb hopper\r\nweb wombat\r\nwebbandit\r\nwebcatcher\r\nwebcopy\r\nwebfoot\r\nweblayers\r\nweblinker\r\nweblog monitor\r\nwebmirror\r\nwebmonkey\r\nwebquest\r\nwebreaper\r\nwebsitepulse\r\nwebsnarf\r\nwebstolperer\r\nwebvac\r\nwebwalk\r\nwebwatch\r\nwebwombat\r\nwebzinger\r\nwhizbang\r\nwhowhere\r\nwild ferret\r\nworldlight\r\nwwwc\r\nwwwster\r\nxenu\r\nxget\r\nxift\r\nxirq\r\nyandex\r\nyanga\r\nyeti\r\nyodao\r\nzao\r\nzippp\r\nzyborg',0),(252,0,'config','config_seo_url','0',0),(251,0,'config','config_maintenance','0',0),(250,0,'config','config_mail_alert_email','',0),(249,0,'config','config_mail_alert','[\"order\"]',1),(248,0,'config','config_mail_smtp_timeout','5',0),(247,0,'config','config_mail_smtp_port','25',0),(246,0,'config','config_mail_smtp_password','',0),(245,0,'config','config_mail_smtp_username','',0),(244,0,'config','config_mail_smtp_hostname','',0),(243,0,'config','config_mail_parameter','',0),(242,0,'config','config_mail_protocol','mail',0),(241,0,'config','config_ftp_status','0',0),(240,0,'config','config_ftp_root','',0),(239,0,'config','config_ftp_password','',0),(238,0,'config','config_ftp_username','',0),(237,0,'config','config_ftp_port','21',0),(236,0,'config','config_ftp_hostname','localhost',0),(235,0,'config','config_icon','catalog/cart.png',0),(234,0,'config','config_logo','catalog/logo.png',0),(233,0,'config','config_captcha_page','[\"review\",\"return\",\"contact\"]',1),(232,0,'config','config_captcha','',0),(231,0,'config','config_return_status_id','2',0),(230,0,'config','config_return_id','0',0),(229,0,'config','config_affiliate_id','0',0),(228,0,'config','config_affiliate_commission','5',0),(227,0,'config','config_affiliate_auto','0',0),(226,0,'config','config_affiliate_approval','0',0),(225,0,'config','config_stock_checkout','0',0),(224,0,'config','config_stock_warning','0',0),(223,0,'config','config_stock_display','0',0),(220,0,'config','config_complete_status','[\"5\",\"3\"]',1),(221,0,'config','config_fraud_status_id','7',0),(222,0,'config','config_api_id','1',0),(211,0,'config','config_customer_price','0',0),(212,0,'config','config_login_attempts','5',0),(213,0,'config','config_account_id','0',0),(214,0,'config','config_invoice_prefix','INV-2013-00',0),(215,0,'config','config_cart_weight','1',0),(216,0,'config','config_checkout_guest','1',0),(217,0,'config','config_checkout_id','0',0),(218,0,'config','config_order_status_id','1',0),(219,0,'config','config_processing_status','[\"5\",\"1\",\"2\",\"12\",\"3\"]',1),(210,0,'config','config_customer_search','0',0),(190,0,'config','config_comment','',0),(191,0,'config','config_country_id','222',0),(192,0,'config','config_zone_id','3563',0),(193,0,'config','config_language','en-gb',0),(194,0,'config','config_admin_language','en-gb',0),(195,0,'config','config_currency','USD',0),(196,0,'config','config_currency_auto','1',0),(197,0,'config','config_length_class_id','1',0),(198,0,'config','config_weight_class_id','1',0),(199,0,'config','config_product_count','1',0),(200,0,'config','config_limit_admin','500',0),(201,0,'config','config_review_status','1',0),(202,0,'config','config_review_guest','1',0),(203,0,'config','config_voucher_min','1',0),(204,0,'config','config_voucher_max','1000',0),(205,0,'config','config_tax','1',0),(206,0,'config','config_tax_default','shipping',0),(207,0,'config','config_tax_customer','shipping',0),(208,0,'config','config_customer_online','0',0),(209,0,'config','config_customer_activity','0',0),(189,0,'config','config_open','',0),(188,0,'config','config_image','',0),(187,0,'config','config_fax','',0),(186,0,'config','config_telephone','123456789',0),(185,0,'config','config_email','jotiba@velankanigroup.com',0),(184,0,'config','config_geocode','',0),(183,0,'config','config_address','Address 1',0),(182,0,'config','config_owner','Your Name',0),(181,0,'config','config_name','Your Store',0),(180,0,'config','config_theme','theme_default',0),(179,0,'config','config_meta_keyword','',0),(178,0,'config','config_meta_description','My Store',0),(177,0,'config','config_meta_title','Your Store',0),(95,0,'free_checkout','free_checkout_status','1',0),(96,0,'free_checkout','free_checkout_order_status_id','1',0),(97,0,'shipping','shipping_sort_order','3',0),(98,0,'sub_total','sub_total_sort_order','1',0),(99,0,'sub_total','sub_total_status','1',0),(100,0,'tax','tax_status','1',0),(101,0,'total','total_sort_order','9',0),(102,0,'total','total_status','1',0),(103,0,'tax','tax_sort_order','5',0),(104,0,'free_checkout','free_checkout_sort_order','1',0),(105,0,'cod','cod_sort_order','5',0),(106,0,'cod','cod_total','0.01',0),(107,0,'cod','cod_order_status_id','1',0),(108,0,'cod','cod_geo_zone_id','0',0),(109,0,'cod','cod_status','1',0),(110,0,'shipping','shipping_status','1',0),(111,0,'shipping','shipping_estimator','1',0),(112,0,'coupon','coupon_sort_order','4',0),(113,0,'coupon','coupon_status','1',0),(114,0,'flat','flat_sort_order','1',0),(115,0,'flat','flat_status','1',0),(116,0,'flat','flat_geo_zone_id','0',0),(117,0,'flat','flat_tax_class_id','9',0),(118,0,'flat','flat_cost','5.00',0),(119,0,'credit','credit_sort_order','7',0),(120,0,'credit','credit_status','1',0),(121,0,'reward','reward_sort_order','2',0),(122,0,'reward','reward_status','1',0),(123,0,'category','category_status','1',0),(124,0,'account','account_status','1',0),(125,0,'affiliate','affiliate_status','1',0),(126,0,'theme_default','theme_default_product_limit','15',0),(127,0,'theme_default','theme_default_product_description_length','100',0),(128,0,'theme_default','theme_default_image_thumb_width','228',0),(129,0,'theme_default','theme_default_image_thumb_height','228',0),(130,0,'theme_default','theme_default_image_popup_width','500',0),(131,0,'theme_default','theme_default_image_popup_height','500',0),(132,0,'theme_default','theme_default_image_category_width','80',0),(133,0,'theme_default','theme_default_image_category_height','80',0),(134,0,'theme_default','theme_default_image_product_width','228',0),(135,0,'theme_default','theme_default_image_product_height','228',0),(136,0,'theme_default','theme_default_image_additional_width','74',0),(137,0,'theme_default','theme_default_image_additional_height','74',0),(138,0,'theme_default','theme_default_image_related_width','200',0),(139,0,'theme_default','theme_default_image_related_height','200',0),(140,0,'theme_default','theme_default_image_compare_width','90',0),(141,0,'theme_default','theme_default_image_compare_height','90',0),(142,0,'theme_default','theme_default_image_wishlist_width','47',0),(143,0,'theme_default','theme_default_image_wishlist_height','47',0),(144,0,'theme_default','theme_default_image_cart_height','47',0),(145,0,'theme_default','theme_default_image_cart_width','47',0),(146,0,'theme_default','theme_default_image_location_height','50',0),(147,0,'theme_default','theme_default_image_location_width','268',0),(148,0,'theme_default','theme_default_directory','default',0),(149,0,'theme_default','theme_default_status','1',0),(150,0,'dashboard_activity','dashboard_activity_status','1',0),(151,0,'dashboard_activity','dashboard_activity_sort_order','7',0),(152,0,'dashboard_sale','dashboard_sale_status','1',0),(153,0,'dashboard_sale','dashboard_sale_width','3',0),(154,0,'dashboard_chart','dashboard_chart_status','1',0),(155,0,'dashboard_chart','dashboard_chart_width','6',0),(156,0,'dashboard_customer','dashboard_customer_status','1',0),(157,0,'dashboard_customer','dashboard_customer_width','3',0),(158,0,'dashboard_map','dashboard_map_status','1',0),(159,0,'dashboard_map','dashboard_map_width','6',0),(160,0,'dashboard_online','dashboard_online_status','1',0),(161,0,'dashboard_online','dashboard_online_width','3',0),(162,0,'dashboard_order','dashboard_order_sort_order','1',0),(163,0,'dashboard_order','dashboard_order_status','1',0),(164,0,'dashboard_order','dashboard_order_width','3',0),(165,0,'dashboard_sale','dashboard_sale_sort_order','2',0),(166,0,'dashboard_customer','dashboard_customer_sort_order','3',0),(167,0,'dashboard_online','dashboard_online_sort_order','4',0),(168,0,'dashboard_map','dashboard_map_sort_order','5',0),(169,0,'dashboard_chart','dashboard_chart_sort_order','6',0),(170,0,'dashboard_recent','dashboard_recent_status','1',0),(171,0,'dashboard_recent','dashboard_recent_sort_order','8',0),(172,0,'dashboard_activity','dashboard_activity_width','4',0),(173,0,'dashboard_recent','dashboard_recent_width','8',0),(259,0,'config','config_file_max_size','300000',0),(260,0,'config','config_file_ext_allowed','zip\r\ntxt\r\npng\r\njpe\r\njpeg\r\njpg\r\ngif\r\nbmp\r\nico\r\ntiff\r\ntif\r\nsvg\r\nsvgz\r\nzip\r\nrar\r\nmsi\r\ncab\r\nmp3\r\nqt\r\nmov\r\npdf\r\npsd\r\nai\r\neps\r\nps\r\ndoc',0),(261,0,'config','config_file_mime_allowed','text/plain\r\nimage/png\r\nimage/jpeg\r\nimage/gif\r\nimage/bmp\r\nimage/tiff\r\nimage/svg+xml\r\napplication/zip\r\n&quot;application/zip&quot;\r\napplication/x-zip\r\n&quot;application/x-zip&quot;\r\napplication/x-zip-compressed\r\n&quot;application/x-zip-compressed&quot;\r\napplication/rar\r\n&quot;application/rar&quot;\r\napplication/x-rar\r\n&quot;application/x-rar&quot;\r\napplication/x-rar-compressed\r\n&quot;application/x-rar-compressed&quot;\r\napplication/octet-stream\r\n&quot;application/octet-stream&quot;\r\naudio/mpeg\r\nvideo/quicktime\r\napplication/pdf',0),(262,0,'config','config_error_display','1',0),(263,0,'config','config_error_log','1',0),(264,0,'config','config_error_filename','error.log',0);

--
-- Table structure for table `software_update`
--

CREATE TABLE `software_update` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `target_level` int(11) NOT NULL,
  `target` int(11) NOT NULL,
  `uri` varchar(255) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` int(11) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `software_update`
--


--
-- Table structure for table `special_commands`
--

CREATE TABLE `special_commands` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `target_level` int(11) DEFAULT '1',
  `target` int(11) NOT NULL,
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` tinyint(1) NOT NULL,
  `cmd_type` int(11) DEFAULT '-1',
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `special_commands`
--


--
-- Table structure for table `stb`
--

CREATE TABLE `stb` (
  `stb_id` int(11) NOT NULL AUTO_INCREMENT,
  `stb_no` varchar(14) NOT NULL,
  `chip_no` varchar(32) DEFAULT NULL,
  `sc_no` varchar(16) NOT NULL DEFAULT '-1',
  `is_sc_paired` tinyint(1) NOT NULL DEFAULT '0',
  `is_paired` tinyint(1) NOT NULL DEFAULT '0',
  `is_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_blacklist` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_suspend` tinyint(1) NOT NULL DEFAULT '0',
  `lco_id` int(11) NOT NULL DEFAULT '-1',
  `active_date` datetime DEFAULT NULL,
  PRIMARY KEY (`stb_id`),
  UNIQUE KEY `stb_no` (`stb_no`),
  UNIQUE KEY `chip_no` (`chip_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stb`
--


--
-- Table structure for table `stb_entitlement`
--

CREATE TABLE `stb_entitlement` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `chip_no` varchar(100) NOT NULL,
  `group_id` int(11) NOT NULL DEFAULT '0',
  `region_pin` int(11) NOT NULL DEFAULT '0',
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` int(11) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stb_entitlement`
--


--
-- Table structure for table `storeAuthKey`
--

CREATE TABLE `storeAuthKey` (
  `operator_id` int(11) NOT NULL AUTO_INCREMENT,
  `api_key` varchar(32) NOT NULL,
  PRIMARY KEY (`operator_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `storeAuthKey`
--

INSERT INTO `storeAuthKey` VALUES (44,'78fef98a91761cf1b171451b49289000');

--
-- Table structure for table `suspend_resume`
--

CREATE TABLE `suspend_resume` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `command_id` int(11) NOT NULL,
  `target_level` int(11) NOT NULL,
  `target` varchar(14) NOT NULL,
  `type` int(11) NOT NULL,
  `state` int(11) NOT NULL,
  `package_id` int(11) DEFAULT '0',
  `ACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_counter` int(11) NOT NULL DEFAULT '-1',
  `NACK_desc` varchar(50) DEFAULT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_expiry_date` bigint(10) NOT NULL DEFAULT '0',
  `MQ_msg_id` int(11) NOT NULL DEFAULT '-1',
  `is_enabled` int(11) NOT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `suspend_resume`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_group_id` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(40) NOT NULL,
  `salt` varchar(9) NOT NULL,
  `firstname` varchar(32) NOT NULL,
  `lastname` varchar(32) NOT NULL,
  `email` varchar(96) NOT NULL,
  `image` varchar(255) NOT NULL,
  `code` varchar(40) NOT NULL,
  `ip` varchar(40) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,1,'admin','aba39345f9ab01f1ce3552e0303b9e4bec9cd007','B12l9x8Pz','bydesign','user','bydesign@velankanigroup.com','','','::1',1,'2017-03-15 15:35:18');

--
-- Table structure for table `user_group`
--

CREATE TABLE `user_group` (
  `user_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `permission` text NOT NULL,
  PRIMARY KEY (`user_group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_group`
--

INSERT INTO `user_group` VALUES (1,'Administrator','{\"access\":[\"commands\\/blacklist\",\"commands\\/bmail\",\"commands\\/boxactivation\",\"commands\\/boxdeactivation\",\"commands\\/disable_osd\",\"commands\\/ecmfingerprint\",\"commands\\/fingerprint\",\"commands\\/osd\",\"commands\\/otaDownload\",\"commands\\/packagedesubscription\",\"commands\\/packagesubscription\",\"commands\\/productdesubscription\",\"commands\\/productsubscription\",\"common\\/column_left\",\"common\\/filemanager\",\"extension\\/dashboard\\/activity\",\"extension\\/dashboard\\/chart\",\"extension\\/dashboard\\/customer\",\"extension\\/dashboard\\/map\",\"extension\\/dashboard\\/online\",\"extension\\/dashboard\\/order\",\"extension\\/dashboard\\/recent\",\"extension\\/dashboard\\/sale\",\"localisation\\/country\",\"localisation\\/language\",\"localisation\\/zone\",\"logs\\/activationLogs\",\"logs\\/activation_log\",\"logs\\/activation_log_bck\",\"logs\\/commands_log\",\"logs\\/complete_log\",\"logs\\/monthlypkgsubslistreport\",\"logs\\/monthlyproductsubslistreport\",\"logs\\/packageModificationLogs\",\"logs\\/packagemodification_log\",\"logs\\/productModificationLogs\",\"logs\\/subscriptionLogs\",\"logs\\/subscription_log\",\"logs\\/subscription_log_bck\",\"report\\/actvdeactvsubscount\",\"report\\/actvsubslistmonthreport\",\"report\\/actvsubslistreport\",\"report\\/blacklistreport\",\"report\\/deactivesubslistreport\",\"report\\/deactvsubslistreport\",\"report\\/historicalStbActivation\",\"report\\/historicaldeactivation\",\"report\\/packagedesubscription\",\"report\\/packagesubscription\",\"report\\/pkgdetailslistreport\",\"report\\/pkgsubscriptioncount\",\"report\\/pkgsubsdesubsreport\",\"report\\/pkgsubslistasondate\",\"report\\/pkgsubslistreport\",\"report\\/ppvsubscription\",\"report\\/prdsubslistasondate\",\"report\\/productdesubscription\",\"report\\/productdetailslistreport\",\"report\\/productsubscription\",\"report\\/productsubscriptioncount\",\"report\\/productsubsdesubsreport\",\"report\\/productsubslistreport\",\"report\\/stbActiveCount\",\"report\\/stbwisechangepackagereport\",\"report\\/stbwisechangeproductreport\",\"report\\/stbwiselogpkgprod\",\"report\\/subsnetworkreport\",\"setting\\/setting\",\"setting\\/store\",\"startup\\/compatibility\",\"startup\\/error\",\"startup\\/event\",\"startup\\/login\",\"startup\\/permission\",\"startup\\/router\",\"startup\\/sass\",\"startup\\/startup\",\"stb\\/stbUpload\",\"tool\\/backup\",\"tool\\/log\",\"tool\\/upload\",\"user\\/user\",\"user\\/user_permission\"],\"modify\":[\"commands\\/blacklist\",\"commands\\/bmail\",\"commands\\/boxactivation\",\"commands\\/boxdeactivation\",\"commands\\/disable_osd\",\"commands\\/ecmfingerprint\",\"commands\\/fingerprint\",\"commands\\/osd\",\"commands\\/otaDownload\",\"commands\\/packagedesubscription\",\"commands\\/packagesubscription\",\"commands\\/productdesubscription\",\"commands\\/productsubscription\",\"common\\/column_left\",\"common\\/filemanager\",\"extension\\/dashboard\\/activity\",\"extension\\/dashboard\\/chart\",\"extension\\/dashboard\\/customer\",\"extension\\/dashboard\\/map\",\"extension\\/dashboard\\/online\",\"extension\\/dashboard\\/order\",\"extension\\/dashboard\\/recent\",\"extension\\/dashboard\\/sale\",\"localisation\\/country\",\"localisation\\/language\",\"localisation\\/zone\",\"logs\\/activationLogs\",\"logs\\/activation_log\",\"logs\\/activation_log_bck\",\"logs\\/commands_log\",\"logs\\/complete_log\",\"logs\\/monthlypkgsubslistreport\",\"logs\\/monthlyproductsubslistreport\",\"logs\\/packageModificationLogs\",\"logs\\/packagemodification_log\",\"logs\\/productModificationLogs\",\"logs\\/subscriptionLogs\",\"logs\\/subscription_log\",\"logs\\/subscription_log_bck\",\"report\\/actvdeactvsubscount\",\"report\\/actvsubslistmonthreport\",\"report\\/actvsubslistreport\",\"report\\/blacklistreport\",\"report\\/deactivesubslistreport\",\"report\\/deactvsubslistreport\",\"report\\/historicalStbActivation\",\"report\\/historicaldeactivation\",\"report\\/packagedesubscription\",\"report\\/packagesubscription\",\"report\\/pkgdetailslistreport\",\"report\\/pkgsubscriptioncount\",\"report\\/pkgsubsdesubsreport\",\"report\\/pkgsubslistasondate\",\"report\\/pkgsubslistreport\",\"report\\/ppvsubscription\",\"report\\/prdsubslistasondate\",\"report\\/productdesubscription\",\"report\\/productdetailslistreport\",\"report\\/productsubscription\",\"report\\/productsubscriptioncount\",\"report\\/productsubsdesubsreport\",\"report\\/productsubslistreport\",\"report\\/stbActiveCount\",\"report\\/stbwisechangepackagereport\",\"report\\/stbwisechangeproductreport\",\"report\\/stbwiselogpkgprod\",\"report\\/subsnetworkreport\",\"setting\\/setting\",\"setting\\/store\",\"startup\\/compatibility\",\"startup\\/error\",\"startup\\/event\",\"startup\\/login\",\"startup\\/permission\",\"startup\\/router\",\"startup\\/sass\",\"startup\\/startup\",\"stb\\/stbUpload\",\"tool\\/backup\",\"tool\\/log\",\"tool\\/upload\",\"user\\/user\",\"user\\/user_permission\"]}');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_no` bigint(20) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `stb_id` int(12) NOT NULL,
  `email` varchar(50) NOT NULL,
  `mobile_no` bigint(10) NOT NULL,
  `region_pin` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`user_id`),
  KEY `iUserMobile` (`mobile_no`),
  KEY `iUserEmail` (`email`),
  KEY `iUserCustNo` (`customer_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--


--
-- Dumping routines for database 'AMOL316_KMS'
--
/*!50003 DROP PROCEDURE IF EXISTS `casAUSTBDetails` */;
DELIMITER ;;
CREATE  PROCEDURE `casAUSTBDetails`(IN `cstb_id` INT, IN `cchip_no` VARCHAR(32))
    NO SQL
BEGIN
	INSERT INTO `logStbModification`(`stbno`, `oldChipNo`, `newChipNo`) 
	SELECT `stb_no`,`chip_no`,cchip_no FROM `stb` WHERE stb_id = cstb_id;
	UPDATE `stb` SET `chip_no`= cchip_no WHERE stb_id = cstb_id;
END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `casCustomerstbunpair` */;
DELIMITER ;;
CREATE  PROCEDURE `casCustomerstbunpair`(IN `stb_xml` LONGTEXT )
BEGIN

 SET @row_num= 1;
 SET @count = extractvalue(stb_xml,'count(//unpair_stb)'); 
 drop temporary table if exists tempUnpairstb;
 create temporary table if not exists tempUnpairstb as
 Select cast(extractvalue(stb_xml,'//unpair_stb[$@row_num]/STBNO') as char(14)) as Stbno,
 0 as errorId,
 0 as StbId,
 cast('Success' as char(500))as msg
 from counter
 where n <= @count and @row_num:=n;  
   
  
     drop temporary table if exists tempUnpairstb2;
     create temporary table if not exists tempUnpairstb2 as
     Select * FROM tempUnpairstb;

     Update tempUnpairstb INNER JOIN (Select Stbno FROM tempUnpairstb2 group by Stbno Having Count(*)>1) as tempStb ON tempStb.Stbno = tempUnpairstb.Stbno SET  errorId= 6,msg="STB no is duplicate in csv file!!" WHERE errorId=0; 




    Update tempUnpairstb x LEFT JOIN stb y ON  y.stb_no = x.Stbno SET  errorId= 1 ,
    msg="STB no does not exist in db!!" WHERE  errorId=0 and y.stb_no IS NULL;
 
    UPDATE tempUnpairstb x INNER JOIN stb y ON  y.stb_no = x.Stbno  
    SET x.StbId=y.stb_id
    WHERE errorId=0;


    Update tempUnpairstb x INNER JOIN stb s ON x.Stbno=s.stb_no LEFT JOIN users u ON  u.stb_id = x.StbId 
    SET  errorId= 2,msg="STB is already unpaired!!" WHERE  errorId=0 and u.stb_id IS NULL;

  
  
    UPDATE tempUnpairstb x INNER JOIN package_subscription pd ON x.Stbno= pd.stbno SET  errorId= 3,
    msg="User subscribed to services,please send Package desubscription first!!" 
  WHERE errorId=0  and pd.command_id=6 AND pd.end_time >= unix_timestamp(now());
 
    
    UPDATE tempUnpairstb x INNER JOIN product_subscription pr ON x.Stbno= pr.stbno SET  errorId= 4,
    msg="User subscribed to services,please send Product desubscription first!!"
  WHERE errorId=0 and pr.command_id=10 AND pr.end_time >= unix_timestamp(now());

    
    Update tempUnpairstb x INNER JOIN stb s ON x.StbId=s.stb_id INNER JOIN users u 
    ON  u.stb_id = x.StbId  INNER JOIN (select max(transaction_id) as mid,user_id 
    from stb_entitlement s group by user_id) y 
  on y.user_id = u.user_id inner join stb_entitlement et ON y.mid = et.transaction_id
  SET errorId= 5,msg="Please de-activate STB before you unpair!"  
  WHERE errorId=0 AND  et.command_id = 0;

  
   Update stb y INNER JOIN tempUnpairstb x ON y.stb_no = x.Stbno
   SET y.is_paired = 0 WHERE errorId=0;
  
  
    Update users u INNER JOIN tempUnpairstb x ON x.StbId= u.stb_id
  SET u.stb_id = -1 WHERE errorId=0;

  select * from tempUnpairstb;
  drop temporary table if exists tempUnpairstb;
    drop temporary table if exists tempUnpairstb2;
   
END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `casGetSTBDetails` */;
DELIMITER ;;
CREATE  PROCEDURE `casGetSTBDetails`(IN `wclause` TEXT, IN `sortOrder` TEXT, IN `vLimitClause` TEXT)
    NO SQL
BEGIN
	SET @query = CONCAT("SELECT * FROM `stb` s left join lco l on (s.lco_id = l.lco_id) where 1 ",wclause," ",sortOrder," ",vLimitClause);
	PREPARE stmt FROM @query;
	EXECUTE stmt;
	DEALLOCATE PREPARE stmt;

		
	SET @query1 = CONCAT("SELECT count(*) as total FROM `stb` s left join lco l on (s.lco_id = l.lco_id) WHERE 1 ",wclause," ",sortOrder);
	PREPARE stmt FROM @query1;
	EXECUTE stmt;
	DEALLOCATE PREPARE stmt;
END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `casspLogsStbModificationLogs` */;
DELIMITER ;;
CREATE  PROCEDURE `casspLogsStbModificationLogs`(IN `wclause` TEXT,IN `sortOrder` TEXT,IN `vLimitClause` TEXT,IN `vIsTot` TINYINT(1))
BEGIN
	SET @fieldsMain = CONCAT(" * ");
	SET @fromquery = CONCAT("  FROM `logStbModification` s WHERE 1 ");
	SET @fieldsCount = CONCAT(" count(*) as total ");
	SET @query = CONCAT("SELECT ",@fieldsMain,@fromquery," ",wclause," ",sortOrder," ",vLimitClause);
	PREPARE stmt FROM @query;
	EXECUTE stmt;
	DEALLOCATE PREPARE stmt;
    IF vIsTot = 1 THEN
		SET @query = CONCAT("SELECT ",@fieldsCount,@fromquery," ",wclause," ",sortOrder);
		PREPARE stmt FROM @query;
		EXECUTE stmt;
		DEALLOCATE PREPARE stmt;
   END IF;
END ;;
DELIMITER ;


