Edit File by line

-- MySQL dump 10.13 Distrib 5.5.62, for Linux (x86_64)

[0] Fix | Delete

[1] Fix | Delete

-- Host: localhost Database: mage1945

[2] Fix | Delete

-- ------------------------------------------------------

[3] Fix | Delete

-- Server version 5.5.62

[4] Fix | Delete

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[6] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[7] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[8] Fix | Delete

/*!40101 SET NAMES utf8 */;

[9] Fix | Delete

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

[10] Fix | Delete

/*!40103 SET TIME_ZONE='+00:00' */;

[11] Fix | Delete

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

[12] Fix | Delete

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

[13] Fix | Delete

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

[14] Fix | Delete

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

[15] Fix | Delete

[16] Fix | Delete

[17] Fix | Delete

-- Table structure for table `[[dbprefix]]admin_assert`

[18] Fix | Delete

[19] Fix | Delete

[20] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]admin_assert`;

[21] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[22] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[23] Fix | Delete

CREATE TABLE `[[dbprefix]]admin_assert` (

[24] Fix | Delete

`assert_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Assert ID',

[25] Fix | Delete

`assert_type` varchar(20) DEFAULT NULL COMMENT 'Assert Type',

[26] Fix | Delete

`assert_data` text COMMENT 'Assert Data',

[27] Fix | Delete

PRIMARY KEY (`assert_id`)

[28] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Admin Assert Table';

[29] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[30] Fix | Delete

[31] Fix | Delete

[32] Fix | Delete

-- Dumping data for table `[[dbprefix]]admin_assert`

[33] Fix | Delete

[34] Fix | Delete

[35] Fix | Delete

LOCK TABLES `[[dbprefix]]admin_assert` WRITE;

[36] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]admin_assert` DISABLE KEYS */;

[37] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]admin_assert` ENABLE KEYS */;

[38] Fix | Delete

UNLOCK TABLES;

[39] Fix | Delete

[40] Fix | Delete

[41] Fix | Delete

-- Table structure for table `[[dbprefix]]admin_role`

[42] Fix | Delete

[43] Fix | Delete

[44] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]admin_role`;

[45] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[46] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[47] Fix | Delete

CREATE TABLE `[[dbprefix]]admin_role` (

[48] Fix | Delete

`role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Role ID',

[49] Fix | Delete

`parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent Role ID',

[50] Fix | Delete

`tree_level` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Role Tree Level',

[51] Fix | Delete

`sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Role Sort Order',

[52] Fix | Delete

`role_type` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Role Type',

[53] Fix | Delete

`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User ID',

[54] Fix | Delete

`role_name` varchar(50) DEFAULT NULL COMMENT 'Role Name',

[55] Fix | Delete

PRIMARY KEY (`role_id`),

[56] Fix | Delete

KEY `IDX_[[DBPREFIX]]ADMIN_ROLE_PARENT_ID_SORT_ORDER` (`parent_id`,`sort_order`),

[57] Fix | Delete

KEY `IDX_[[DBPREFIX]]ADMIN_ROLE_TREE_LEVEL` (`tree_level`)

[58] Fix | Delete

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Admin Role Table';

[59] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[60] Fix | Delete

[61] Fix | Delete

[62] Fix | Delete

-- Dumping data for table `[[dbprefix]]admin_role`

[63] Fix | Delete

[64] Fix | Delete

[65] Fix | Delete

LOCK TABLES `[[dbprefix]]admin_role` WRITE;

[66] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]admin_role` DISABLE KEYS */;

[67] Fix | Delete

INSERT INTO `[[dbprefix]]admin_role` VALUES (1,0,1,1,'G',0,'Administrators'),(2,1,2,0,'U',1,'[[admin_fname]]');

[68] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]admin_role` ENABLE KEYS */;

[69] Fix | Delete

UNLOCK TABLES;

[70] Fix | Delete

[71] Fix | Delete

[72] Fix | Delete

-- Table structure for table `[[dbprefix]]admin_rule`

[73] Fix | Delete

[74] Fix | Delete

[75] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]admin_rule`;

[76] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[77] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[78] Fix | Delete

CREATE TABLE `[[dbprefix]]admin_rule` (

[79] Fix | Delete

`rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule ID',

[80] Fix | Delete

`role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Role ID',

[81] Fix | Delete

`resource_id` varchar(255) DEFAULT NULL COMMENT 'Resource ID',

[82] Fix | Delete

`privileges` varchar(20) DEFAULT NULL COMMENT 'Privileges',

[83] Fix | Delete

`assert_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Assert ID',

[84] Fix | Delete

`role_type` varchar(1) DEFAULT NULL COMMENT 'Role Type',

[85] Fix | Delete

`permission` varchar(10) DEFAULT NULL COMMENT 'Permission',

[86] Fix | Delete

PRIMARY KEY (`rule_id`),

[87] Fix | Delete

KEY `IDX_[[DBPREFIX]]ADMIN_RULE_RESOURCE_ID_ROLE_ID` (`resource_id`,`role_id`),

[88] Fix | Delete

KEY `IDX_[[DBPREFIX]]ADMIN_RULE_ROLE_ID_RESOURCE_ID` (`role_id`,`resource_id`),

[89] Fix | Delete

CONSTRAINT `FK_[[DBPREFIX]]ADMIN_RULE_ROLE_ID_[[DBPREFIX]]ADMIN_ROLE_ROLE_ID` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]admin_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE

[90] Fix | Delete

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Admin Rule Table';

[91] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[92] Fix | Delete

[93] Fix | Delete

[94] Fix | Delete

-- Dumping data for table `[[dbprefix]]admin_rule`

[95] Fix | Delete

[96] Fix | Delete

[97] Fix | Delete

LOCK TABLES `[[dbprefix]]admin_rule` WRITE;

[98] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]admin_rule` DISABLE KEYS */;

[99] Fix | Delete

INSERT INTO `[[dbprefix]]admin_rule` VALUES (1,1,'all',NULL,0,'G','allow');

[100] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]admin_rule` ENABLE KEYS */;

[101] Fix | Delete

UNLOCK TABLES;

[102] Fix | Delete

[103] Fix | Delete

[104] Fix | Delete

-- Table structure for table `[[dbprefix]]admin_user`

[105] Fix | Delete

[106] Fix | Delete

[107] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]admin_user`;

[108] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[109] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[110] Fix | Delete

CREATE TABLE `[[dbprefix]]admin_user` (

[111] Fix | Delete

`user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'User ID',

[112] Fix | Delete

`firstname` varchar(32) DEFAULT NULL COMMENT 'User First Name',

[113] Fix | Delete

`lastname` varchar(32) DEFAULT NULL COMMENT 'User Last Name',

[114] Fix | Delete

`email` varchar(128) DEFAULT NULL COMMENT 'User Email',

[115] Fix | Delete

`username` varchar(40) DEFAULT NULL COMMENT 'User Login',

[116] Fix | Delete

`password` varchar(255) DEFAULT NULL COMMENT 'User Password',

[117] Fix | Delete

`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'User Created Time',

[118] Fix | Delete

`modified` timestamp NULL DEFAULT NULL COMMENT 'User Modified Time',

[119] Fix | Delete

`logdate` timestamp NULL DEFAULT NULL COMMENT 'User Last Login Time',

[120] Fix | Delete

`lognum` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'User Login Number',

[121] Fix | Delete

`reload_acl_flag` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Reload ACL',

[122] Fix | Delete

`is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'User Is Active',

[123] Fix | Delete

`extra` text COMMENT 'User Extra Data',

[124] Fix | Delete

`rp_token` text COMMENT 'Reset Password Link Token',

[125] Fix | Delete

`rp_token_created_at` timestamp NULL DEFAULT NULL COMMENT 'Reset Password Link Token Creation Date',

[126] Fix | Delete

PRIMARY KEY (`user_id`),

[127] Fix | Delete

UNIQUE KEY `UNQ_[[DBPREFIX]]ADMIN_USER_USERNAME` (`username`)

[128] Fix | Delete

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Admin User Table';

[129] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[130] Fix | Delete

[131] Fix | Delete

[132] Fix | Delete

-- Dumping data for table `[[dbprefix]]admin_user`

[133] Fix | Delete

[134] Fix | Delete

[135] Fix | Delete

LOCK TABLES `[[dbprefix]]admin_user` WRITE;

[136] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]admin_user` DISABLE KEYS */;

[137] Fix | Delete

INSERT INTO `[[dbprefix]]admin_user` VALUES (1,'[[admin_fname]]','[[admin_lname]]','[[admin_email]]','[[admin_username]]','[[admin_pass]]','[[regtime]]','[[regtime]]',NULL,0,0,1,'b:0;',NULL,NULL);

[138] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]admin_user` ENABLE KEYS */;

[139] Fix | Delete

UNLOCK TABLES;

[140] Fix | Delete

[141] Fix | Delete

[142] Fix | Delete

-- Table structure for table `[[dbprefix]]adminnotification_inbox`

[143] Fix | Delete

[144] Fix | Delete

[145] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]adminnotification_inbox`;

[146] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[147] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[148] Fix | Delete

CREATE TABLE `[[dbprefix]]adminnotification_inbox` (

[149] Fix | Delete

`notification_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Notification id',

[150] Fix | Delete

`severity` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Problem type',

[151] Fix | Delete

`date_added` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Create date',

[152] Fix | Delete

`title` varchar(255) NOT NULL COMMENT 'Title',

[153] Fix | Delete

`description` text COMMENT 'Description',

[154] Fix | Delete

`url` varchar(255) DEFAULT NULL COMMENT 'Url',

[155] Fix | Delete

`is_read` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag if notification read',

[156] Fix | Delete

`is_remove` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag if notification might be removed',

[157] Fix | Delete

PRIMARY KEY (`notification_id`),

[158] Fix | Delete

KEY `IDX_[[DBPREFIX]]ADMINNOTIFICATION_INBOX_SEVERITY` (`severity`),

[159] Fix | Delete

KEY `IDX_[[DBPREFIX]]ADMINNOTIFICATION_INBOX_IS_READ` (`is_read`),

[160] Fix | Delete

KEY `IDX_[[DBPREFIX]]ADMINNOTIFICATION_INBOX_IS_REMOVE` (`is_remove`)

[161] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Adminnotification Inbox';

[162] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[163] Fix | Delete

[164] Fix | Delete

[165] Fix | Delete

-- Dumping data for table `[[dbprefix]]adminnotification_inbox`

[166] Fix | Delete

[167] Fix | Delete

[168] Fix | Delete

LOCK TABLES `[[dbprefix]]adminnotification_inbox` WRITE;

[169] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]adminnotification_inbox` DISABLE KEYS */;

[170] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]adminnotification_inbox` ENABLE KEYS */;

[171] Fix | Delete

UNLOCK TABLES;

[172] Fix | Delete

[173] Fix | Delete

[174] Fix | Delete

-- Table structure for table `[[dbprefix]]api2_acl_attribute`

[175] Fix | Delete

[176] Fix | Delete

[177] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]api2_acl_attribute`;

[178] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[179] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[180] Fix | Delete

CREATE TABLE `[[dbprefix]]api2_acl_attribute` (

[181] Fix | Delete

`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',

[182] Fix | Delete

`user_type` varchar(20) NOT NULL COMMENT 'Type of user',

[183] Fix | Delete

`resource_id` varchar(255) NOT NULL COMMENT 'Resource ID',

[184] Fix | Delete

`operation` varchar(20) NOT NULL COMMENT 'Operation',

[185] Fix | Delete

`allowed_attributes` text COMMENT 'Allowed attributes',

[186] Fix | Delete

PRIMARY KEY (`entity_id`),

[187] Fix | Delete

UNIQUE KEY `UNQ_[[DBPREFIX]][[DBPREFIX]]API2_ACL_ATTRIBUTE_USER_TYPE_RESOURCE_ID_OPERATION` (`user_type`,`resource_id`,`operation`),

[188] Fix | Delete

KEY `IDX_[[DBPREFIX]]API2_ACL_ATTRIBUTE_USER_TYPE` (`user_type`)

[189] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api2 Filter ACL Attributes';

[190] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[191] Fix | Delete

[192] Fix | Delete

[193] Fix | Delete

-- Dumping data for table `[[dbprefix]]api2_acl_attribute`

[194] Fix | Delete

[195] Fix | Delete

[196] Fix | Delete

LOCK TABLES `[[dbprefix]]api2_acl_attribute` WRITE;

[197] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api2_acl_attribute` DISABLE KEYS */;

[198] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api2_acl_attribute` ENABLE KEYS */;

[199] Fix | Delete

UNLOCK TABLES;

[200] Fix | Delete

[201] Fix | Delete

[202] Fix | Delete

-- Table structure for table `[[dbprefix]]api2_acl_role`

[203] Fix | Delete

[204] Fix | Delete

[205] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]api2_acl_role`;

[206] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[207] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[208] Fix | Delete

CREATE TABLE `[[dbprefix]]api2_acl_role` (

[209] Fix | Delete

`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',

[210] Fix | Delete

`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',

[211] Fix | Delete

`updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',

[212] Fix | Delete

`role_name` varchar(255) NOT NULL COMMENT 'Name of role',

[213] Fix | Delete

PRIMARY KEY (`entity_id`),

[214] Fix | Delete

KEY `IDX_[[DBPREFIX]]API2_ACL_ROLE_CREATED_AT` (`created_at`),

[215] Fix | Delete

KEY `IDX_[[DBPREFIX]]API2_ACL_ROLE_UPDATED_AT` (`updated_at`)

[216] Fix | Delete

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Api2 Global ACL Roles';

[217] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[218] Fix | Delete

[219] Fix | Delete

[220] Fix | Delete

-- Dumping data for table `[[dbprefix]]api2_acl_role`

[221] Fix | Delete

[222] Fix | Delete

[223] Fix | Delete

LOCK TABLES `[[dbprefix]]api2_acl_role` WRITE;

[224] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api2_acl_role` DISABLE KEYS */;

[225] Fix | Delete

INSERT INTO `[[dbprefix]]api2_acl_role` VALUES (1,'[[regtime]]',NULL,'Guest'),(2,'[[regtime]]',NULL,'Customer');

[226] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api2_acl_role` ENABLE KEYS */;

[227] Fix | Delete

UNLOCK TABLES;

[228] Fix | Delete

[229] Fix | Delete

[230] Fix | Delete

-- Table structure for table `[[dbprefix]]api2_acl_rule`

[231] Fix | Delete

[232] Fix | Delete

[233] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]api2_acl_rule`;

[234] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[235] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[236] Fix | Delete

CREATE TABLE `[[dbprefix]]api2_acl_rule` (

[237] Fix | Delete

`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',

[238] Fix | Delete

`role_id` int(10) unsigned NOT NULL COMMENT 'Role ID',

[239] Fix | Delete

`resource_id` varchar(255) NOT NULL COMMENT 'Resource ID',

[240] Fix | Delete

`privilege` varchar(20) DEFAULT NULL COMMENT 'ACL Privilege',

[241] Fix | Delete

PRIMARY KEY (`entity_id`),

[242] Fix | Delete

UNIQUE KEY `UNQ_[[DBPREFIX]][[DBPREFIX]]API2_ACL_RULE_ROLE_ID_RESOURCE_ID_PRIVILEGE` (`role_id`,`resource_id`,`privilege`),

[243] Fix | Delete

CONSTRAINT `FK_[[DBPREFIX]]API2_ACL_RULE_ROLE_ID_[[DBPREFIX]]API2_ACL_ROLE_ENTITY_ID` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]api2_acl_role` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE

[244] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api2 Global ACL Rules';

[245] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[246] Fix | Delete

[247] Fix | Delete

[248] Fix | Delete

-- Dumping data for table `[[dbprefix]]api2_acl_rule`

[249] Fix | Delete

[250] Fix | Delete

[251] Fix | Delete

LOCK TABLES `[[dbprefix]]api2_acl_rule` WRITE;

[252] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api2_acl_rule` DISABLE KEYS */;

[253] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api2_acl_rule` ENABLE KEYS */;

[254] Fix | Delete

UNLOCK TABLES;

[255] Fix | Delete

[256] Fix | Delete

[257] Fix | Delete

-- Table structure for table `[[dbprefix]]api2_acl_user`

[258] Fix | Delete

[259] Fix | Delete

[260] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]api2_acl_user`;

[261] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[262] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[263] Fix | Delete

CREATE TABLE `[[dbprefix]]api2_acl_user` (

[264] Fix | Delete

`admin_id` int(10) unsigned NOT NULL COMMENT 'Admin ID',

[265] Fix | Delete

`role_id` int(10) unsigned NOT NULL COMMENT 'Role ID',

[266] Fix | Delete

UNIQUE KEY `UNQ_[[DBPREFIX]][[DBPREFIX]]API2_ACL_USER_ADMIN_ID` (`admin_id`),

[267] Fix | Delete

KEY `FK_[[DBPREFIX]]API2_ACL_USER_ROLE_ID_[[DBPREFIX]]API2_ACL_ROLE_ENTITY_ID` (`role_id`),

[268] Fix | Delete

CONSTRAINT `FK_[[DBPREFIX]]API2_ACL_USER_ADMIN_ID_[[DBPREFIX]]ADMIN_USER_USER_ID` FOREIGN KEY (`admin_id`) REFERENCES `[[dbprefix]]admin_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,

[269] Fix | Delete

CONSTRAINT `FK_[[DBPREFIX]]API2_ACL_USER_ROLE_ID_[[DBPREFIX]]API2_ACL_ROLE_ENTITY_ID` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]api2_acl_role` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE

[270] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api2 Global ACL Users';

[271] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[272] Fix | Delete

[273] Fix | Delete

[274] Fix | Delete

-- Dumping data for table `[[dbprefix]]api2_acl_user`

[275] Fix | Delete

[276] Fix | Delete

[277] Fix | Delete

LOCK TABLES `[[dbprefix]]api2_acl_user` WRITE;

[278] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api2_acl_user` DISABLE KEYS */;

[279] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api2_acl_user` ENABLE KEYS */;

[280] Fix | Delete

UNLOCK TABLES;

[281] Fix | Delete

[282] Fix | Delete

[283] Fix | Delete

-- Table structure for table `[[dbprefix]]api_assert`

[284] Fix | Delete

[285] Fix | Delete

[286] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]api_assert`;

[287] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[288] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[289] Fix | Delete

CREATE TABLE `[[dbprefix]]api_assert` (

[290] Fix | Delete

`assert_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Assert id',

[291] Fix | Delete

`assert_type` varchar(20) DEFAULT NULL COMMENT 'Assert type',

[292] Fix | Delete

`assert_data` text COMMENT 'Assert additional data',

[293] Fix | Delete

PRIMARY KEY (`assert_id`)

[294] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api ACL Asserts';

[295] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[296] Fix | Delete

[297] Fix | Delete

[298] Fix | Delete

-- Dumping data for table `[[dbprefix]]api_assert`

[299] Fix | Delete

[300] Fix | Delete

[301] Fix | Delete

LOCK TABLES `[[dbprefix]]api_assert` WRITE;

[302] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_assert` DISABLE KEYS */;

[303] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_assert` ENABLE KEYS */;

[304] Fix | Delete

UNLOCK TABLES;

[305] Fix | Delete

[306] Fix | Delete

[307] Fix | Delete

-- Table structure for table `[[dbprefix]]api_role`

[308] Fix | Delete

[309] Fix | Delete

[310] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]api_role`;

[311] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[312] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[313] Fix | Delete

CREATE TABLE `[[dbprefix]]api_role` (

[314] Fix | Delete

`role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Role id',

[315] Fix | Delete

`parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent role id',

[316] Fix | Delete

`tree_level` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Role level in tree',

[317] Fix | Delete

`sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort order to display on admin area',

[318] Fix | Delete

`role_type` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Role type',

[319] Fix | Delete

`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User id',

[320] Fix | Delete

`role_name` varchar(50) DEFAULT NULL COMMENT 'Role name',

[321] Fix | Delete

PRIMARY KEY (`role_id`),

[322] Fix | Delete

KEY `IDX_[[DBPREFIX]]API_ROLE_PARENT_ID_SORT_ORDER` (`parent_id`,`sort_order`),

[323] Fix | Delete

KEY `IDX_[[DBPREFIX]]API_ROLE_TREE_LEVEL` (`tree_level`)

[324] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api ACL Roles';

[325] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[326] Fix | Delete

[327] Fix | Delete

[328] Fix | Delete

-- Dumping data for table `[[dbprefix]]api_role`

[329] Fix | Delete

[330] Fix | Delete

[331] Fix | Delete

LOCK TABLES `[[dbprefix]]api_role` WRITE;

[332] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_role` DISABLE KEYS */;

[333] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_role` ENABLE KEYS */;

[334] Fix | Delete

UNLOCK TABLES;

[335] Fix | Delete

[336] Fix | Delete

[337] Fix | Delete

-- Table structure for table `[[dbprefix]]api_rule`

[338] Fix | Delete

[339] Fix | Delete

[340] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]api_rule`;

[341] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[342] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[343] Fix | Delete

CREATE TABLE `[[dbprefix]]api_rule` (

[344] Fix | Delete

`rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Api rule Id',

[345] Fix | Delete

`role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Api role Id',

[346] Fix | Delete

`resource_id` varchar(255) DEFAULT NULL COMMENT 'Module code',

[347] Fix | Delete

`api_privileges` varchar(20) DEFAULT NULL COMMENT 'Privileges',

[348] Fix | Delete

`assert_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Assert id',

[349] Fix | Delete

`role_type` varchar(1) DEFAULT NULL COMMENT 'Role type',

[350] Fix | Delete

`api_permission` varchar(10) DEFAULT NULL COMMENT 'Permission',

[351] Fix | Delete

PRIMARY KEY (`rule_id`),

[352] Fix | Delete

KEY `IDX_[[DBPREFIX]]API_RULE_RESOURCE_ID_ROLE_ID` (`resource_id`,`role_id`),

[353] Fix | Delete

KEY `IDX_[[DBPREFIX]]API_RULE_ROLE_ID_RESOURCE_ID` (`role_id`,`resource_id`),

[354] Fix | Delete

CONSTRAINT `FK_[[DBPREFIX]]API_RULE_ROLE_ID_[[DBPREFIX]]API_ROLE_ROLE_ID` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]api_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE

[355] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api ACL Rules';

[356] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[357] Fix | Delete

[358] Fix | Delete

[359] Fix | Delete

-- Dumping data for table `[[dbprefix]]api_rule`

[360] Fix | Delete

[361] Fix | Delete

[362] Fix | Delete

LOCK TABLES `[[dbprefix]]api_rule` WRITE;

[363] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_rule` DISABLE KEYS */;

[364] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_rule` ENABLE KEYS */;

[365] Fix | Delete

UNLOCK TABLES;

[366] Fix | Delete

[367] Fix | Delete

[368] Fix | Delete

-- Table structure for table `[[dbprefix]]api_session`

[369] Fix | Delete

[370] Fix | Delete

[371] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]api_session`;

[372] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[373] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[374] Fix | Delete

CREATE TABLE `[[dbprefix]]api_session` (

[375] Fix | Delete

`user_id` int(10) unsigned NOT NULL COMMENT 'User id',

[376] Fix | Delete

`logdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Login date',

[377] Fix | Delete

`sessid` varchar(40) DEFAULT NULL COMMENT 'Sessioin id',

[378] Fix | Delete

KEY `IDX_[[DBPREFIX]]API_SESSION_USER_ID` (`user_id`),

[379] Fix | Delete

KEY `IDX_[[DBPREFIX]]API_SESSION_SESSID` (`sessid`),

[380] Fix | Delete

CONSTRAINT `FK_[[DBPREFIX]]API_SESSION_USER_ID_[[DBPREFIX]]API_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]api_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE

[381] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api Sessions';

[382] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[383] Fix | Delete

[384] Fix | Delete

[385] Fix | Delete

-- Dumping data for table `[[dbprefix]]api_session`

[386] Fix | Delete

[387] Fix | Delete

[388] Fix | Delete

LOCK TABLES `[[dbprefix]]api_session` WRITE;

[389] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_session` DISABLE KEYS */;

[390] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_session` ENABLE KEYS */;

[391] Fix | Delete

UNLOCK TABLES;

[392] Fix | Delete

[393] Fix | Delete

[394] Fix | Delete

-- Table structure for table `[[dbprefix]]api_user`

[395] Fix | Delete

[396] Fix | Delete

[397] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]api_user`;

[398] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[399] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[400] Fix | Delete

CREATE TABLE `[[dbprefix]]api_user` (

[401] Fix | Delete

`user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'User id',

[402] Fix | Delete

`firstname` varchar(32) DEFAULT NULL COMMENT 'First name',

[403] Fix | Delete

`lastname` varchar(32) DEFAULT NULL COMMENT 'Last name',

[404] Fix | Delete

`email` varchar(128) DEFAULT NULL COMMENT 'Email',

[405] Fix | Delete

`username` varchar(40) DEFAULT NULL COMMENT 'Nickname',

[406] Fix | Delete

`api_key` varchar(255) DEFAULT NULL COMMENT 'Api key',

[407] Fix | Delete

`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'User record create date',

[408] Fix | Delete

`modified` timestamp NULL DEFAULT NULL COMMENT 'User record modify date',

[409] Fix | Delete

`lognum` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Quantity of log ins',

[410] Fix | Delete

`reload_acl_flag` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Refresh ACL flag',

[411] Fix | Delete

`is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Account status',

[412] Fix | Delete

PRIMARY KEY (`user_id`)

[413] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api Users';

[414] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[415] Fix | Delete

[416] Fix | Delete

[417] Fix | Delete

-- Dumping data for table `[[dbprefix]]api_user`

[418] Fix | Delete

[419] Fix | Delete

[420] Fix | Delete

LOCK TABLES `[[dbprefix]]api_user` WRITE;

[421] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_user` DISABLE KEYS */;

[422] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]api_user` ENABLE KEYS */;

[423] Fix | Delete

UNLOCK TABLES;

[424] Fix | Delete

[425] Fix | Delete

[426] Fix | Delete

-- Table structure for table `[[dbprefix]]captcha_log`

[427] Fix | Delete

[428] Fix | Delete

[429] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]captcha_log`;

[430] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[431] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[432] Fix | Delete

CREATE TABLE `[[dbprefix]]captcha_log` (

[433] Fix | Delete

`type` varchar(32) NOT NULL COMMENT 'Type',

[434] Fix | Delete

`value` varchar(32) NOT NULL COMMENT 'Value',

[435] Fix | Delete

`count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Count',

[436] Fix | Delete

`updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',

[437] Fix | Delete

PRIMARY KEY (`type`,`value`)

[438] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Count Login Attempts';

[439] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[440] Fix | Delete

[441] Fix | Delete

[442] Fix | Delete

-- Dumping data for table `[[dbprefix]]captcha_log`

[443] Fix | Delete

[444] Fix | Delete

[445] Fix | Delete

LOCK TABLES `[[dbprefix]]captcha_log` WRITE;

[446] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]captcha_log` DISABLE KEYS */;

[447] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]captcha_log` ENABLE KEYS */;

[448] Fix | Delete

UNLOCK TABLES;

[449] Fix | Delete

[450] Fix | Delete

[451] Fix | Delete

-- Table structure for table `[[dbprefix]]catalog_category_anc_categs_index_idx`

[452] Fix | Delete

[453] Fix | Delete

[454] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]catalog_category_anc_categs_index_idx`;

[455] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[456] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[457] Fix | Delete

CREATE TABLE `[[dbprefix]]catalog_category_anc_categs_index_idx` (

[458] Fix | Delete

`category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',

[459] Fix | Delete

`path` varchar(255) DEFAULT NULL COMMENT 'Path',

[460] Fix | Delete

KEY `IDX_[[DBPREFIX]]CATALOG_CATEGORY_ANC_CATEGS_INDEX_IDX_CATEGORY_ID` (`category_id`),

[461] Fix | Delete

KEY `IDX_[[DBPREFIX]]CATALOG_CATEGORY_ANC_CATEGS_INDEX_IDX_PATH_CATEGORY_ID` (`path`,`category_id`)

[462] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Anchor Indexer Index Table';

[463] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[464] Fix | Delete

[465] Fix | Delete

[466] Fix | Delete

-- Dumping data for table `[[dbprefix]]catalog_category_anc_categs_index_idx`

[467] Fix | Delete

[468] Fix | Delete

[469] Fix | Delete

LOCK TABLES `[[dbprefix]]catalog_category_anc_categs_index_idx` WRITE;

[470] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]catalog_category_anc_categs_index_idx` DISABLE KEYS */;

[471] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]catalog_category_anc_categs_index_idx` ENABLE KEYS */;

[472] Fix | Delete

UNLOCK TABLES;

[473] Fix | Delete

[474] Fix | Delete

[475] Fix | Delete

-- Table structure for table `[[dbprefix]]catalog_category_anc_categs_index_tmp`

[476] Fix | Delete

[477] Fix | Delete

[478] Fix | Delete

DROP TABLE IF EXISTS `[[dbprefix]]catalog_category_anc_categs_index_tmp`;

[479] Fix | Delete

/*!40101 SET @saved_cs_client = @@character_set_client */;

[480] Fix | Delete

/*!40101 SET character_set_client = utf8 */;

[481] Fix | Delete

CREATE TABLE `[[dbprefix]]catalog_category_anc_categs_index_tmp` (

[482] Fix | Delete

`category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',

[483] Fix | Delete

`path` varchar(255) DEFAULT NULL COMMENT 'Path',

[484] Fix | Delete

KEY `IDX_[[DBPREFIX]]CATALOG_CATEGORY_ANC_CATEGS_INDEX_TMP_CATEGORY_ID` (`category_id`),

[485] Fix | Delete

KEY `IDX_[[DBPREFIX]]CATALOG_CATEGORY_ANC_CATEGS_INDEX_TMP_PATH_CATEGORY_ID` (`path`,`category_id`)

[486] Fix | Delete

) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Catalog Category Anchor Indexer Temp Table';

[487] Fix | Delete

/*!40101 SET character_set_client = @saved_cs_client */;

[488] Fix | Delete

[489] Fix | Delete

[490] Fix | Delete

-- Dumping data for table `[[dbprefix]]catalog_category_anc_categs_index_tmp`

[491] Fix | Delete

[492] Fix | Delete

[493] Fix | Delete

LOCK TABLES `[[dbprefix]]catalog_category_anc_categs_index_tmp` WRITE;

[494] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]catalog_category_anc_categs_index_tmp` DISABLE KEYS */;

[495] Fix | Delete

/*!40000 ALTER TABLE `[[dbprefix]]catalog_category_anc_categs_index_tmp` ENABLE KEYS */;

[496] Fix | Delete

UNLOCK TABLES;

[497] Fix | Delete

[498] Fix | Delete

[499] Fix | Delete

12 3 4 5 6 ...23