database.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594
  1. <?php
  2. /* For license terms, see /license.txt */
  3. /**
  4. * Plugin database installation script. Can only be executed if included
  5. * inside another script loading global.inc.php
  6. * @package chamilo.plugin.buycourses
  7. */
  8. /**
  9. * Check if script can be called
  10. */
  11. if (!function_exists('api_get_path')) {
  12. die('This script must be loaded through the Chamilo plugin installer sequence');
  13. }
  14. $entityManager = Database::getManager();
  15. $pluginSchema = new \Doctrine\DBAL\Schema\Schema();
  16. $connection = $entityManager->getConnection();
  17. $platform = $connection->getDatabasePlatform();
  18. //Create tables
  19. $paypalTable = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_PAYPAL);
  20. $paypalTable->addColumn(
  21. 'id',
  22. \Doctrine\DBAL\Types\Type::INTEGER,
  23. ['autoincrement' => true, 'unsigned' => true]
  24. );
  25. $paypalTable->addColumn('username', \Doctrine\DBAL\Types\Type::STRING);
  26. $paypalTable->addColumn('password', \Doctrine\DBAL\Types\Type::STRING);
  27. $paypalTable->addColumn('signature', \Doctrine\DBAL\Types\Type::STRING);
  28. $paypalTable->addColumn('sandbox', \Doctrine\DBAL\Types\Type::BOOLEAN);
  29. $paypalTable->setPrimaryKey(['id']);
  30. $transferTable = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_TRANSFER);
  31. $transferTable->addColumn(
  32. 'id',
  33. \Doctrine\DBAL\Types\Type::INTEGER,
  34. ['autoincrement' => true, 'unsigned' => true]
  35. );
  36. $transferTable->addColumn('name', \Doctrine\DBAL\Types\Type::STRING);
  37. $transferTable->addColumn('account', \Doctrine\DBAL\Types\Type::STRING);
  38. $transferTable->addColumn('swift', \Doctrine\DBAL\Types\Type::STRING);
  39. $transferTable->setPrimaryKey(['id']);
  40. $currencyTable = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_CURRENCY);
  41. $currencyTable->addColumn(
  42. 'id',
  43. \Doctrine\DBAL\Types\Type::INTEGER,
  44. ['autoincrement' => true, 'unsigned' => true]
  45. );
  46. $currencyTable->addColumn(
  47. 'country_code',
  48. \Doctrine\DBAL\Types\Type::STRING,
  49. ['length' => 2]
  50. );
  51. $currencyTable->addColumn(
  52. 'country_name',
  53. \Doctrine\DBAL\Types\Type::STRING,
  54. ['length' => 255]
  55. );
  56. $currencyTable->addColumn(
  57. 'iso_code',
  58. \Doctrine\DBAL\Types\Type::STRING,
  59. ['length' => 3]
  60. );
  61. $currencyTable->addColumn('status', \Doctrine\DBAL\Types\Type::BOOLEAN);
  62. $currencyTable->addUniqueIndex(['country_code']);
  63. $currencyTable->addIndex(['iso_code']);
  64. $currencyTable->setPrimaryKey(['id']);
  65. $itemTable = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_ITEM);
  66. $itemTable->addColumn(
  67. 'id',
  68. \Doctrine\DBAL\Types\Type::INTEGER,
  69. ['autoincrement' => true, 'unsigned' => true]
  70. );
  71. $itemTable->addColumn('product_type', \Doctrine\DBAL\Types\Type::INTEGER);
  72. $itemTable->addColumn(
  73. 'product_id',
  74. \Doctrine\DBAL\Types\Type::INTEGER,
  75. ['unsigned' => true]
  76. );
  77. $itemTable->addColumn(
  78. 'price',
  79. \Doctrine\DBAL\Types\Type::DECIMAL,
  80. ['scale' => 2]
  81. );
  82. $itemTable->addColumn(
  83. 'currency_id',
  84. \Doctrine\DBAL\Types\Type::INTEGER,
  85. ['unsigned' => true]
  86. );
  87. $itemTable->setPrimaryKey(['id']);
  88. $itemTable->addForeignKeyConstraint(
  89. $currencyTable,
  90. ['currency_id'],
  91. ['id'],
  92. ['onDelete' => 'CASCADE']
  93. );
  94. $itemBeneficiary = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_ITEM_BENEFICIARY);
  95. $itemBeneficiary->addColumn(
  96. 'id',
  97. \Doctrine\DBAL\Types\Type::INTEGER,
  98. ['autoincrement' => true, 'unsigned' => true]
  99. );
  100. $itemBeneficiary->addColumn(
  101. 'item_id',
  102. \Doctrine\DBAL\Types\Type::INTEGER,
  103. ['unsigned' => true]
  104. );
  105. $itemBeneficiary->addColumn(
  106. 'user_id',
  107. \Doctrine\DBAL\Types\Type::INTEGER,
  108. ['unsigned' => true]
  109. );
  110. $itemBeneficiary->addColumn(
  111. 'commissions',
  112. \Doctrine\DBAL\Types\Type::INTEGER,
  113. ['unsigned' => true]
  114. );
  115. $itemBeneficiary->setPrimaryKey(['id']);
  116. $itemBeneficiary->addForeignKeyConstraint(
  117. $itemTable,
  118. ['item_id'],
  119. ['id'],
  120. ['onDelete' => 'CASCADE']
  121. );
  122. $commissions = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_COMMISSION);
  123. $commissions->addColumn(
  124. 'id',
  125. \Doctrine\DBAL\Types\Type::INTEGER,
  126. ['autoincrement' => true, 'unsigned' => true]
  127. );
  128. $commissions->addColumn(
  129. 'commission',
  130. \Doctrine\DBAL\Types\Type::INTEGER,
  131. ['unsigned' => true]
  132. );
  133. $commissions->setPrimaryKey(['id']);
  134. $saleCommissions = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_PAYPAL_PAYOUTS);
  135. $saleCommissions->addColumn(
  136. 'id',
  137. \Doctrine\DBAL\Types\Type::INTEGER,
  138. ['autoincrement' => true, 'unsigned' => true]
  139. );
  140. $saleCommissions->addColumn('date', \Doctrine\DBAL\Types\Type::DATETIME);
  141. $saleCommissions->addColumn('payout_date', \Doctrine\DBAL\Types\Type::DATETIME);
  142. $saleCommissions->addColumn(
  143. 'sale_id',
  144. \Doctrine\DBAL\Types\Type::INTEGER,
  145. ['unsigned' => true]
  146. );
  147. $saleCommissions->addColumn(
  148. 'user_id',
  149. \Doctrine\DBAL\Types\Type::INTEGER,
  150. ['unsigned' => true]
  151. );
  152. $saleCommissions->addColumn(
  153. 'commission',
  154. \Doctrine\DBAL\Types\Type::DECIMAL,
  155. ['scale' => 2]
  156. );
  157. $saleCommissions->addColumn(
  158. 'status',
  159. \Doctrine\DBAL\Types\Type::INTEGER,
  160. ['unsigned' => true]
  161. );
  162. $saleCommissions->setPrimaryKey(['id']);
  163. $saleTable = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_SALE);
  164. $saleTable->addColumn(
  165. 'id',
  166. \Doctrine\DBAL\Types\Type::INTEGER,
  167. ['autoincrement' => true, 'unsigned' => true]
  168. );
  169. $saleTable->addColumn('reference', \Doctrine\DBAL\Types\Type::STRING);
  170. $saleTable->addColumn('date', \Doctrine\DBAL\Types\Type::DATETIME);
  171. $saleTable->addColumn(
  172. 'user_id',
  173. \Doctrine\DBAL\Types\Type::INTEGER,
  174. ['unsigned' => true]
  175. );
  176. $saleTable->addColumn('product_type', \Doctrine\DBAL\Types\Type::INTEGER);
  177. $saleTable->addColumn('product_name', \Doctrine\DBAL\Types\Type::STRING);
  178. $saleTable->addColumn(
  179. 'product_id',
  180. \Doctrine\DBAL\Types\Type::INTEGER,
  181. ['unsigned' => true]
  182. );
  183. $saleTable->addColumn(
  184. 'price',
  185. \Doctrine\DBAL\Types\Type::DECIMAL,
  186. ['scale' => 2]
  187. );
  188. $saleTable->addColumn(
  189. 'currency_id',
  190. \Doctrine\DBAL\Types\Type::INTEGER,
  191. ['unsigned' => true]
  192. );
  193. $saleTable->addColumn('status', \Doctrine\DBAL\Types\Type::INTEGER);
  194. $saleTable->addColumn('payment_type', \Doctrine\DBAL\Types\Type::INTEGER);
  195. $saleTable->setPrimaryKey(['id']);
  196. $saleTable->addForeignKeyConstraint(
  197. $currencyTable,
  198. ['currency_id'],
  199. ['id'],
  200. ['onDelete' => 'CASCADE']
  201. );
  202. $servicesTable = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_SERVICES);
  203. $servicesTable->addColumn(
  204. 'id',
  205. \Doctrine\DBAL\Types\Type::INTEGER,
  206. ['autoincrement' => true, 'unsigned' => true]
  207. );
  208. $servicesTable->addColumn('name', \Doctrine\DBAL\Types\Type::STRING);
  209. $servicesTable->addColumn('description', \Doctrine\DBAL\Types\Type::TEXT);
  210. $servicesTable->addColumn(
  211. 'price',
  212. \Doctrine\DBAL\Types\Type::DECIMAL,
  213. ['scale' => 2]
  214. );
  215. $servicesTable->addColumn('duration_days', \Doctrine\DBAL\Types\Type::INTEGER);
  216. $servicesTable->addColumn('applies_to', \Doctrine\DBAL\Types\Type::INTEGER);
  217. $servicesTable->addColumn('owner_id', \Doctrine\DBAL\Types\Type::INTEGER);
  218. $servicesTable->addColumn('visibility', \Doctrine\DBAL\Types\Type::INTEGER);
  219. $servicesTable->addColumn('video_url', \Doctrine\DBAL\Types\Type::STRING);
  220. $servicesTable->addColumn('image', \Doctrine\DBAL\Types\Type::STRING);
  221. $servicesTable->addColumn('service_information', \Doctrine\DBAL\Types\Type::TEXT);
  222. $servicesTable->setPrimaryKey(['id']);
  223. $servicesNodeTable = $pluginSchema->createTable(BuyCoursesPlugin::TABLE_SERVICES_SALE);
  224. $servicesNodeTable->addColumn(
  225. 'id',
  226. \Doctrine\DBAL\Types\Type::INTEGER,
  227. ['autoincrement' => true, 'unsigned' => true]
  228. );
  229. $servicesNodeTable->addColumn(
  230. 'service_id',
  231. \Doctrine\DBAL\Types\Type::INTEGER,
  232. ['unsigned' => true]
  233. );
  234. $servicesNodeTable->addColumn('reference', \Doctrine\DBAL\Types\Type::STRING);
  235. $servicesNodeTable->addColumn('currency_id', \Doctrine\DBAL\Types\Type::INTEGER);
  236. $servicesNodeTable->addColumn(
  237. 'price',
  238. \Doctrine\DBAL\Types\Type::DECIMAL,
  239. ['scale' => 2]
  240. );
  241. $servicesNodeTable->addColumn('node_type', \Doctrine\DBAL\Types\Type::INTEGER);
  242. $servicesNodeTable->addColumn('node_id', \Doctrine\DBAL\Types\Type::INTEGER);
  243. $servicesNodeTable->addColumn('buyer_id', \Doctrine\DBAL\Types\Type::INTEGER);
  244. $servicesNodeTable->addColumn('buy_date', \Doctrine\DBAL\Types\Type::DATETIME);
  245. $servicesNodeTable->addColumn(
  246. 'date_start',
  247. \Doctrine\DBAL\Types\Type::DATETIME,
  248. ['notnull' => false]
  249. );
  250. $servicesNodeTable->addColumn(
  251. 'date_end',
  252. \Doctrine\DBAL\Types\Type::DATETIME
  253. );
  254. $servicesNodeTable->addColumn('status', \Doctrine\DBAL\Types\Type::INTEGER);
  255. $servicesNodeTable->addColumn('payment_type', \Doctrine\DBAL\Types\Type::INTEGER);
  256. $servicesNodeTable->setPrimaryKey(['id']);
  257. $servicesNodeTable->addForeignKeyConstraint(
  258. $servicesTable,
  259. ['service_id'],
  260. ['id'],
  261. ['onDelete' => 'CASCADE']
  262. );
  263. $queries = $pluginSchema->toSql($platform);
  264. foreach ($queries as $query) {
  265. Database::query($query);
  266. }
  267. //Insert data
  268. $paypalTable = Database::get_main_table(BuyCoursesPlugin::TABLE_PAYPAL);
  269. $currencyTable = Database::get_main_table(BuyCoursesPlugin::TABLE_CURRENCY);
  270. $itemTable = Database::get_main_table(BuyCoursesPlugin::TABLE_ITEM);
  271. $saleTable = Database::get_main_table(BuyCoursesPlugin::TABLE_SALE);
  272. $commissionTable = Database::get_main_table(BuyCoursesPlugin::TABLE_COMMISSION);
  273. $extraFieldTable = Database::get_main_table(TABLE_EXTRA_FIELD);
  274. $paypalExtraField = Database::select(
  275. "*",
  276. $extraFieldTable,
  277. [
  278. 'where' => ['variable = ?' => 'paypal']
  279. ],
  280. 'first'
  281. );
  282. if (!$paypalExtraField) {
  283. Database::insert(
  284. $extraFieldTable,
  285. [
  286. 'extra_field_type' => 1,
  287. 'field_type' => 1,
  288. 'variable' => 'paypal',
  289. 'display_text' => 'Paypal',
  290. 'default_value' => '',
  291. 'field_order' => 0,
  292. 'visible_to_self' => 1,
  293. 'changeable' => 1,
  294. 'filter' => 0,
  295. 'created_at' => api_get_utc_datetime()
  296. ]
  297. );
  298. }
  299. Database::insert(
  300. $paypalTable,
  301. [
  302. 'username' => '',
  303. 'password' => '',
  304. 'signature' => '',
  305. 'sandbox' => true
  306. ]
  307. );
  308. Database::insert(
  309. $commissionTable,
  310. [
  311. 'commission' => 0
  312. ]
  313. );
  314. $currencies = [
  315. ['AD', 'Andorra', 'EUR', 'AND'],
  316. ['AE', 'United Arab Emirates', 'AED', 'ARE'],
  317. ['AF', 'Afghanistan', 'AFN', 'AFG'],
  318. ['AG', 'Antigua and Barbuda', 'XCD', 'ATG'],
  319. ['AI', 'Anguilla', 'XCD', 'AIA'],
  320. ['AL', 'Albania', 'ALL', 'ALB'],
  321. ['AM', 'Armenia', 'AMD', 'ARM'],
  322. ['AO', 'Angola', 'AOA', 'AGO'],
  323. ['AR', 'Argentina', 'ARS', 'ARG'],
  324. ['AS', 'American Samoa', 'USD', 'ASM'],
  325. ['AT', 'Austria', 'EUR', 'AUT'],
  326. ['AU', 'Australia', 'AUD', 'AUS'],
  327. ['AW', 'Aruba', 'AWG', 'ABW'],
  328. ['AX', '&Aring;land', 'EUR', 'ALA'],
  329. ['AZ', 'Azerbaijan', 'AZN', 'AZE'],
  330. ['BA', 'Bosnia and Herzegovina', 'BAM', 'BIH'],
  331. ['BB', 'Barbados', 'BBD', 'BRB'],
  332. ['BD', 'Bangladesh', 'BDT', 'BGD'],
  333. ['BE', 'Belgium', 'EUR', 'BEL'],
  334. ['BF', 'Burkina Faso', 'XOF', 'BFA'],
  335. ['BG', 'Bulgaria', 'BGN', 'BGR'],
  336. ['BH', 'Bahrain', 'BHD', 'BHR'],
  337. ['BI', 'Burundi', 'BIF', 'BDI'],
  338. ['BJ', 'Benin', 'XOF', 'BEN'],
  339. ['BL', 'Saint Barth&eacute;lemy', 'EUR', 'BLM'],
  340. ['BM', 'Bermuda', 'BMD', 'BMU'],
  341. ['BN', 'Brunei', 'BND', 'BRN'],
  342. ['BO', 'Bolivia', 'BOB', 'BOL'],
  343. ['BQ', 'Bonaire', 'USD', 'BES'],
  344. ['BR', 'Brazil', 'BRL', 'BRA'],
  345. ['BS', 'Bahamas', 'BSD', 'BHS'],
  346. ['BT', 'Bhutan', 'BTN', 'BTN'],
  347. ['BV', 'Bouvet Island', 'NOK', 'BVT'],
  348. ['BW', 'Botswana', 'BWP', 'BWA'],
  349. ['BY', 'Belarus', 'BYR', 'BLR'],
  350. ['BZ', 'Belize', 'BZD', 'BLZ'],
  351. ['CA', 'Canada', 'CAD', 'CAN'],
  352. ['CC', 'Cocos [Keeling] Islands', 'AUD', 'CCK'],
  353. ['CD', 'Congo', 'CDF', 'COD'],
  354. ['CF', 'Central African Republic', 'XAF', 'CAF'],
  355. ['CG', 'Republic of the Congo', 'XAF', 'COG'],
  356. ['CH', 'Switzerland', 'CHF', 'CHE'],
  357. ['CI', 'Ivory Coast', 'XOF', 'CIV'],
  358. ['CK', 'Cook Islands', 'NZD', 'COK'],
  359. ['CL', 'Chile', 'CLP', 'CHL'],
  360. ['CM', 'Cameroon', 'XAF', 'CMR'],
  361. ['CN', 'China', 'CNY', 'CHN'],
  362. ['CO', 'Colombia', 'COP', 'COL'],
  363. ['CR', 'Costa Rica', 'CRC', 'CRI'],
  364. ['CU', 'Cuba', 'CUP', 'CUB'],
  365. ['CV', 'Cape Verde', 'CVE', 'CPV'],
  366. ['CW', 'Curacao', 'ANG', 'CUW'],
  367. ['CX', 'Christmas Island', 'AUD', 'CXR'],
  368. ['CY', 'Cyprus', 'EUR', 'CYP'],
  369. ['CZ', 'Czechia', 'CZK', 'CZE'],
  370. ['DE', 'Germany', 'EUR', 'DEU'],
  371. ['DJ', 'Djibouti', 'DJF', 'DJI'],
  372. ['DK', 'Denmark', 'DKK', 'DNK'],
  373. ['DM', 'Dominica', 'XCD', 'DMA'],
  374. ['DO', 'Dominican Republic', 'DOP', 'DOM'],
  375. ['DZ', 'Algeria', 'DZD', 'DZA'],
  376. ['EC', 'Ecuador', 'USD', 'ECU'],
  377. ['EE', 'Estonia', 'EUR', 'EST'],
  378. ['EG', 'Egypt', 'EGP', 'EGY'],
  379. ['EH', 'Western Sahara', 'MAD', 'ESH'],
  380. ['ER', 'Eritrea', 'ERN', 'ERI'],
  381. ['ES', 'Spain', 'EUR', 'ESP'],
  382. ['ET', 'Ethiopia', 'ETB', 'ETH'],
  383. ['FI', 'Finland', 'EUR', 'FIN'],
  384. ['FJ', 'Fiji', 'FJD', 'FJI'],
  385. ['FK', 'Falkland Islands', 'FKP', 'FLK'],
  386. ['FM', 'Micronesia', 'USD', 'FSM'],
  387. ['FO', 'Faroe Islands', 'DKK', 'FRO'],
  388. ['FR', 'France', 'EUR', 'FRA'],
  389. ['GA', 'Gabon', 'XAF', 'GAB'],
  390. ['GB', 'United Kingdom', 'GBP', 'GBR'],
  391. ['GD', 'Grenada', 'XCD', 'GRD'],
  392. ['GE', 'Georgia', 'GEL', 'GEO'],
  393. ['GF', 'French Guiana', 'EUR', 'GUF'],
  394. ['GG', 'Guernsey', 'GBP', 'GGY'],
  395. ['GH', 'Ghana', 'GHS', 'GHA'],
  396. ['GI', 'Gibraltar', 'GIP', 'GIB'],
  397. ['GL', 'Greenland', 'DKK', 'GRL'],
  398. ['GM', 'Gambia', 'GMD', 'GMB'],
  399. ['GN', 'Guinea', 'GNF', 'GIN'],
  400. ['GP', 'Guadeloupe', 'EUR', 'GLP'],
  401. ['GQ', 'Equatorial Guinea', 'XAF', 'GNQ'],
  402. ['GR', 'Greece', 'EUR', 'GRC'],
  403. ['GS', 'South Georgia and the South Sandwich Islands', 'GBP', 'SGS'],
  404. ['GT', 'Guatemala', 'GTQ', 'GTM'],
  405. ['GU', 'Guam', 'USD', 'GUM'],
  406. ['GW', 'Guinea-Bissau', 'XOF', 'GNB'],
  407. ['GY', 'Guyana', 'GYD', 'GUY'],
  408. ['HK', 'Hong Kong', 'HKD', 'HKG'],
  409. ['HM', 'Heard Island and McDonald Islands', 'AUD', 'HMD'],
  410. ['HN', 'Honduras', 'HNL', 'HND'],
  411. ['HR', 'Croatia', 'HRK', 'HRV'],
  412. ['HT', 'Haiti', 'HTG', 'HTI'],
  413. ['HU', 'Hungary', 'HUF', 'HUN'],
  414. ['ID', 'Indonesia', 'IDR', 'IDN'],
  415. ['IE', 'Ireland', 'EUR', 'IRL'],
  416. ['IL', 'Israel', 'ILS', 'ISR'],
  417. ['IM', 'Isle of Man', 'GBP', 'IMN'],
  418. ['IN', 'India', 'INR', 'IND'],
  419. ['IO', 'British Indian Ocean Territory', 'USD', 'IOT'],
  420. ['IQ', 'Iraq', 'IQD', 'IRQ'],
  421. ['IR', 'Iran', 'IRR', 'IRN'],
  422. ['IS', 'Iceland', 'ISK', 'ISL'],
  423. ['IT', 'Italy', 'EUR', 'ITA'],
  424. ['JE', 'Jersey', 'GBP', 'JEY'],
  425. ['JM', 'Jamaica', 'JMD', 'JAM'],
  426. ['JO', 'Jordan', 'JOD', 'JOR'],
  427. ['JP', 'Japan', 'JPY', 'JPN'],
  428. ['KE', 'Kenya', 'KES', 'KEN'],
  429. ['KG', 'Kyrgyzstan', 'KGS', 'KGZ'],
  430. ['KH', 'Cambodia', 'KHR', 'KHM'],
  431. ['KI', 'Kiribati', 'AUD', 'KIR'],
  432. ['KM', 'Comoros', 'KMF', 'COM'],
  433. ['KN', 'Saint Kitts and Nevis', 'XCD', 'KNA'],
  434. ['KP', 'North Korea', 'KPW', 'PRK'],
  435. ['KR', 'South Korea', 'KRW', 'KOR'],
  436. ['KW', 'Kuwait', 'KWD', 'KWT'],
  437. ['KY', 'Cayman Islands', 'KYD', 'CYM'],
  438. ['KZ', 'Kazakhstan', 'KZT', 'KAZ'],
  439. ['LA', 'Laos', 'LAK', 'LAO'],
  440. ['LB', 'Lebanon', 'LBP', 'LBN'],
  441. ['LC', 'Saint Lucia', 'XCD', 'LCA'],
  442. ['LI', 'Liechtenstein', 'CHF', 'LIE'],
  443. ['LK', 'Sri Lanka', 'LKR', 'LKA'],
  444. ['LR', 'Liberia', 'LRD', 'LBR'],
  445. ['LS', 'Lesotho', 'LSL', 'LSO'],
  446. ['LT', 'Lithuania', 'LTL', 'LTU'],
  447. ['LU', 'Luxembourg', 'EUR', 'LUX'],
  448. ['LV', 'Latvia', 'LVL', 'LVA'],
  449. ['LY', 'Libya', 'LYD', 'LBY'],
  450. ['MA', 'Morocco', 'MAD', 'MAR'],
  451. ['MC', 'Monaco', 'EUR', 'MCO'],
  452. ['MD', 'Moldova', 'MDL', 'MDA'],
  453. ['ME', 'Montenegro', 'EUR', 'MNE'],
  454. ['MF', 'Saint Martin', 'EUR', 'MAF'],
  455. ['MG', 'Madagascar', 'MGA', 'MDG'],
  456. ['MH', 'Marshall Islands', 'USD', 'MHL'],
  457. ['MK', 'Macedonia', 'MKD', 'MKD'],
  458. ['ML', 'Mali', 'XOF', 'MLI'],
  459. ['MM', 'Myanmar [Burma]', 'MMK', 'MMR'],
  460. ['MN', 'Mongolia', 'MNT', 'MNG'],
  461. ['MO', 'Macao', 'MOP', 'MAC'],
  462. ['MP', 'Northern Mariana Islands', 'USD', 'MNP'],
  463. ['MQ', 'Martinique', 'EUR', 'MTQ'],
  464. ['MR', 'Mauritania', 'MRO', 'MRT'],
  465. ['MS', 'Montserrat', 'XCD', 'MSR'],
  466. ['MT', 'Malta', 'EUR', 'MLT'],
  467. ['MU', 'Mauritius', 'MUR', 'MUS'],
  468. ['MV', 'Maldives', 'MVR', 'MDV'],
  469. ['MW', 'Malawi', 'MWK', 'MWI'],
  470. ['MX', 'Mexico', 'MXN', 'MEX'],
  471. ['MY', 'Malaysia', 'MYR', 'MYS'],
  472. ['MZ', 'Mozambique', 'MZN', 'MOZ'],
  473. ['NA', 'Namibia', 'NAD', 'NAM'],
  474. ['NC', 'New Caledonia', 'XPF', 'NCL'],
  475. ['NE', 'Niger', 'XOF', 'NER'],
  476. ['NF', 'Norfolk Island', 'AUD', 'NFK'],
  477. ['NG', 'Nigeria', 'NGN', 'NGA'],
  478. ['NI', 'Nicaragua', 'NIO', 'NIC'],
  479. ['NL', 'Netherlands', 'EUR', 'NLD'],
  480. ['NO', 'Norway', 'NOK', 'NOR'],
  481. ['NP', 'Nepal', 'NPR', 'NPL'],
  482. ['NR', 'Nauru', 'AUD', 'NRU'],
  483. ['NU', 'Niue', 'NZD', 'NIU'],
  484. ['NZ', 'New Zealand', 'NZD', 'NZL'],
  485. ['OM', 'Oman', 'OMR', 'OMN'],
  486. ['PA', 'Panama', 'PAB', 'PAN'],
  487. ['PE', 'Peru', 'PEN', 'PER'],
  488. ['PF', 'French Polynesia', 'XPF', 'PYF'],
  489. ['PG', 'Papua New Guinea', 'PGK', 'PNG'],
  490. ['PH', 'Philippines', 'PHP', 'PHL'],
  491. ['PK', 'Pakistan', 'PKR', 'PAK'],
  492. ['PL', 'Poland', 'PLN', 'POL'],
  493. ['PM', 'Saint Pierre and Miquelon', 'EUR', 'SPM'],
  494. ['PN', 'Pitcairn Islands', 'NZD', 'PCN'],
  495. ['PR', 'Puerto Rico', 'USD', 'PRI'],
  496. ['PS', 'Palestine', 'ILS', 'PSE'],
  497. ['PT', 'Portugal', 'EUR', 'PRT'],
  498. ['PW', 'Palau', 'USD', 'PLW'],
  499. ['PY', 'Paraguay', 'PYG', 'PRY'],
  500. ['QA', 'Qatar', 'QAR', 'QAT'],
  501. ['RE', 'R&eacute;union', 'EUR', 'REU'],
  502. ['RO', 'Romania', 'RON', 'ROU'],
  503. ['RS', 'Serbia', 'RSD', 'SRB'],
  504. ['RU', 'Russia', 'RUB', 'RUS'],
  505. ['RW', 'Rwanda', 'RWF', 'RWA'],
  506. ['SA', 'Saudi Arabia', 'SAR', 'SAU'],
  507. ['SB', 'Solomon Islands', 'SBD', 'SLB'],
  508. ['SC', 'Seychelles', 'SCR', 'SYC'],
  509. ['SD', 'Sudan', 'SDG', 'SDN'],
  510. ['SE', 'Sweden', 'SEK', 'SWE'],
  511. ['SG', 'Singapore', 'SGD', 'SGP'],
  512. ['SH', 'Saint Helena', 'SHP', 'SHN'],
  513. ['SI', 'Slovenia', 'EUR', 'SVN'],
  514. ['SJ', 'Svalbard and Jan Mayen', 'NOK', 'SJM'],
  515. ['SK', 'Slovakia', 'EUR', 'SVK'],
  516. ['SL', 'Sierra Leone', 'SLL', 'SLE'],
  517. ['SM', 'San Marino', 'EUR', 'SMR'],
  518. ['SN', 'Senegal', 'XOF', 'SEN'],
  519. ['SO', 'Somalia', 'SOS', 'SOM'],
  520. ['SR', 'Suriname', 'SRD', 'SUR'],
  521. ['SS', 'South Sudan', 'SSP', 'SSD'],
  522. ['ST', 'S&atilde;o Tom&eacute; and Pr&iacute;ncipe', 'STD', 'STP'],
  523. ['SV', 'El Salvador', 'USD', 'SLV'],
  524. ['SX', 'Sint Maarten', 'ANG', 'SXM'],
  525. ['SY', 'Syria', 'SYP', 'SYR'],
  526. ['SZ', 'Swaziland', 'SZL', 'SWZ'],
  527. ['TC', 'Turks and Caicos Islands', 'USD', 'TCA'],
  528. ['TD', 'Chad', 'XAF', 'TCD'],
  529. ['TF', 'French Southern Territories', 'EUR', 'ATF'],
  530. ['TG', 'Togo', 'XOF', 'TGO'],
  531. ['TH', 'Thailand', 'THB', 'THA'],
  532. ['TJ', 'Tajikistan', 'TJS', 'TJK'],
  533. ['TK', 'Tokelau', 'NZD', 'TKL'],
  534. ['TL', 'East Timor', 'USD', 'TLS'],
  535. ['TM', 'Turkmenistan', 'TMT', 'TKM'],
  536. ['TN', 'Tunisia', 'TND', 'TUN'],
  537. ['TO', 'Tonga', 'TOP', 'TON'],
  538. ['TR', 'Turkey', 'TRY', 'TUR'],
  539. ['TT', 'Trinidad and Tobago', 'TTD', 'TTO'],
  540. ['TV', 'Tuvalu', 'AUD', 'TUV'],
  541. ['TW', 'Taiwan', 'TWD', 'TWN'],
  542. ['TZ', 'Tanzania', 'TZS', 'TZA'],
  543. ['UA', 'Ukraine', 'UAH', 'UKR'],
  544. ['UG', 'Uganda', 'UGX', 'UGA'],
  545. ['UM', 'U.S. Minor Outlying Islands', 'USD', 'UMI'],
  546. ['US', 'United States', 'USD', 'USA'],
  547. ['UY', 'Uruguay', 'UYU', 'URY'],
  548. ['UZ', 'Uzbekistan', 'UZS', 'UZB'],
  549. ['VA', 'Vatican City', 'EUR', 'VAT'],
  550. ['VC', 'Saint Vincent and the Grenadines', 'XCD', 'VCT'],
  551. ['VE', 'Venezuela', 'VEF', 'VEN'],
  552. ['VG', 'British Virgin Islands', 'USD', 'VGB'],
  553. ['VI', 'U.S. Virgin Islands', 'USD', 'VIR'],
  554. ['VN', 'Vietnam', 'VND', 'VNM'],
  555. ['VU', 'Vanuatu', 'VUV', 'VUT'],
  556. ['WF', 'Wallis and Futuna', 'XPF', 'WLF'],
  557. ['WS', 'Samoa', 'WST', 'WSM'],
  558. ['XK', 'Kosovo', 'EUR', 'XKX'],
  559. ['YE', 'Yemen', 'YER', 'YEM'],
  560. ['YT', 'Mayotte', 'EUR', 'MYT'],
  561. ['ZA', 'South Africa', 'ZAR', 'ZAF'],
  562. ['ZM', 'Zambia', 'ZMK', 'ZMB'],
  563. ['ZW', 'Zimbabwe', 'ZWL', 'ZWE']
  564. ];
  565. foreach ($currencies as $currency) {
  566. Database::insert(
  567. $currencyTable,
  568. [
  569. 'country_code' => $currency[0],
  570. 'country_name' => $currency[1],
  571. 'iso_code' => $currency[2]
  572. ]
  573. );
  574. }