For the production Data View\/Download screen<\/a>, data is being fetched from a MySQL database. We are using the same MySQL instance that was installed as part of WordPress. The schema is different (jordanio). The creation and initialization of this database is a one-time process, so it is not covered here. What is given is the schema of the tables used as part of SQL CREATE statements. These commands need to be run within MySQL to create the database schema and tables for a new installation.<\/p>\n\n\n Once the schema and tables are created, the simplest way to initialize the tables is to run the administrator Data Update<\/a> operation for UNIDO data (UN Comtrade data is already part of the jordan.zip file, so it does not need to be initialized; the update operation can be run later to bring the trade data up to date).<\/p>\n","protected":false},"excerpt":{"rendered":" Shared MySQL instance For the production Data View\/Download screen, data is being fetched from a MySQL database. We are using the same MySQL instance that was installed as part of WordPress. The schema is different (jordanio). The creation and initialization of this database is a one-time process, so it is not covered here. What is …<\/p>\nCREATE DATABASE IF NOT EXISTS jordanio CHARACTER SET \"utf8\";\nUSE jordanio;\nDROP TABLE IF EXISTS users;\nDROP TABLE IF EXISTS mva;\nDROP TABLE IF EXISTS indstat2;\nDROP TABLE IF EXISTS indstat4;\nCREATE TABLE mva (\n\tyear smallint NOT NULL,\n\tiso char(3) NOT NULL,\n\tvar varchar(7),\n\tvalue bigint NULL,\n\tPRIMARY KEY (year, iso, var)\n);\nCREATE TABLE indstat2 (\n\tyear smallint NOT NULL,\n\tiso char(3) NOT NULL,\n\tvar varchar(3),\n\tisic2 char(2),\n\tvalue bigint,\n\tPRIMARY KEY (year, iso, var, isic2)\n);\nCREATE TABLE indstat4 (\n\tyear smallint NOT NULL,\n\tiso char(3) NOT NULL,\n\tvar varchar(3),\n\tisic4 char(4),\n\tvalue bigint,\n\tPRIMARY KEY (year, iso, var, isic4)\n);\nCREATE TABLE indstat4_4 (\n\tyear smallint NOT NULL,\n\tiso char(3) NOT NULL,\n\tvar varchar(3),\n\tisic4 char(4),\n\tvalue bigint,\n\tPRIMARY KEY (year, iso, var, isic4)\n);\nCREATE TABLE users (\n\tuserid varchar(20) NOT NULL DEFAULT \"\",\n\tfullname varchar(60) DEFAULT NULL,\n\tpassword varchar(8) DEFAULT NULL,\n\tuserlvl smallint(6) DEFAULT NULL,\n\tPRIMARY KEY (`userid`)\n);\nCREATE USER jordanio IDENTIFIED BY 'jordaniopwd';\nGRANT ALL PRIVILEGES ON jordanio.* TO jordanio;<\/code><\/pre>\n\n\n