Edit File by line
/home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../presta
File: presta.sql
[0] Fix | Delete
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
[1] Fix | Delete
SET time_zone = "+00:00";
[2] Fix | Delete
[3] Fix | Delete
[4] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[6] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[7] Fix | Delete
/*!40101 SET NAMES utf8 */;
[8] Fix | Delete
[9] Fix | Delete
--
[10] Fix | Delete
-- Database: `presta1624`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `[[dbprefix]]access`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `[[dbprefix]]access` (
[20] Fix | Delete
`id_profile` int(10) unsigned NOT NULL,
[21] Fix | Delete
`id_tab` int(10) unsigned NOT NULL,
[22] Fix | Delete
`view` int(11) NOT NULL,
[23] Fix | Delete
`add` int(11) NOT NULL,
[24] Fix | Delete
`edit` int(11) NOT NULL,
[25] Fix | Delete
`delete` int(11) NOT NULL,
[26] Fix | Delete
PRIMARY KEY (`id_profile`,`id_tab`)
[27] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[28] Fix | Delete
[29] Fix | Delete
--
[30] Fix | Delete
-- Dumping data for table `[[dbprefix]]access`
[31] Fix | Delete
--
[32] Fix | Delete
[33] Fix | Delete
INSERT INTO `[[dbprefix]]access` VALUES
[34] Fix | Delete
(1, 0, 1, 1, 1, 1),
[35] Fix | Delete
(1, 1, 1, 1, 1, 1),
[36] Fix | Delete
(1, 5, 1, 1, 1, 1),
[37] Fix | Delete
(1, 7, 1, 1, 1, 1),
[38] Fix | Delete
(1, 9, 1, 1, 1, 1),
[39] Fix | Delete
(1, 10, 1, 1, 1, 1),
[40] Fix | Delete
(1, 11, 1, 1, 1, 1),
[41] Fix | Delete
(1, 13, 1, 1, 1, 1),
[42] Fix | Delete
(1, 14, 1, 1, 1, 1),
[43] Fix | Delete
(1, 15, 1, 1, 1, 1),
[44] Fix | Delete
(1, 16, 1, 1, 1, 1),
[45] Fix | Delete
(1, 19, 1, 1, 1, 1),
[46] Fix | Delete
(1, 20, 1, 1, 1, 1),
[47] Fix | Delete
(1, 21, 1, 1, 1, 1),
[48] Fix | Delete
(1, 22, 1, 1, 1, 1),
[49] Fix | Delete
(1, 23, 1, 1, 1, 1),
[50] Fix | Delete
(1, 24, 1, 1, 1, 1),
[51] Fix | Delete
(1, 25, 1, 1, 1, 1),
[52] Fix | Delete
(1, 26, 1, 1, 1, 1),
[53] Fix | Delete
(1, 27, 1, 1, 1, 1),
[54] Fix | Delete
(1, 28, 1, 1, 1, 1),
[55] Fix | Delete
(1, 29, 1, 1, 1, 1),
[56] Fix | Delete
(1, 31, 1, 1, 1, 1),
[57] Fix | Delete
(1, 32, 1, 1, 1, 1),
[58] Fix | Delete
(1, 33, 1, 1, 1, 1),
[59] Fix | Delete
(1, 34, 1, 1, 1, 1),
[60] Fix | Delete
(1, 35, 1, 1, 1, 1),
[61] Fix | Delete
(1, 36, 1, 1, 1, 1),
[62] Fix | Delete
(1, 38, 1, 1, 1, 1),
[63] Fix | Delete
(1, 39, 1, 1, 1, 1),
[64] Fix | Delete
(1, 40, 1, 1, 1, 1),
[65] Fix | Delete
(1, 41, 1, 1, 1, 1),
[66] Fix | Delete
(1, 42, 1, 1, 1, 1),
[67] Fix | Delete
(1, 44, 1, 1, 1, 1),
[68] Fix | Delete
(1, 45, 1, 1, 1, 1),
[69] Fix | Delete
(1, 48, 1, 1, 1, 1),
[70] Fix | Delete
(1, 50, 1, 1, 1, 1),
[71] Fix | Delete
(1, 52, 1, 1, 1, 1),
[72] Fix | Delete
(1, 53, 1, 1, 1, 1),
[73] Fix | Delete
(1, 54, 1, 1, 1, 1),
[74] Fix | Delete
(1, 55, 1, 1, 1, 1),
[75] Fix | Delete
(1, 56, 1, 1, 1, 1),
[76] Fix | Delete
(1, 57, 1, 1, 1, 1),
[77] Fix | Delete
(1, 58, 1, 1, 1, 1),
[78] Fix | Delete
(1, 59, 1, 1, 1, 1),
[79] Fix | Delete
(1, 61, 1, 1, 1, 1),
[80] Fix | Delete
(1, 62, 1, 1, 1, 1),
[81] Fix | Delete
(1, 63, 1, 1, 1, 1),
[82] Fix | Delete
(1, 66, 1, 1, 1, 1),
[83] Fix | Delete
(1, 67, 1, 1, 1, 1),
[84] Fix | Delete
(1, 68, 1, 1, 1, 1),
[85] Fix | Delete
(1, 69, 1, 1, 1, 1),
[86] Fix | Delete
(1, 70, 1, 1, 1, 1),
[87] Fix | Delete
(1, 71, 1, 1, 1, 1),
[88] Fix | Delete
(1, 73, 1, 1, 1, 1),
[89] Fix | Delete
(1, 74, 1, 1, 1, 1),
[90] Fix | Delete
(1, 75, 1, 1, 1, 1),
[91] Fix | Delete
(1, 76, 1, 1, 1, 1),
[92] Fix | Delete
(1, 77, 1, 1, 1, 1),
[93] Fix | Delete
(1, 78, 1, 1, 1, 1),
[94] Fix | Delete
(1, 80, 1, 1, 1, 1),
[95] Fix | Delete
(1, 81, 1, 1, 1, 1),
[96] Fix | Delete
(1, 82, 1, 1, 1, 1),
[97] Fix | Delete
(1, 83, 1, 1, 1, 1),
[98] Fix | Delete
(1, 84, 1, 1, 1, 1),
[99] Fix | Delete
(1, 86, 1, 1, 1, 1),
[100] Fix | Delete
(1, 87, 1, 1, 1, 1),
[101] Fix | Delete
(1, 88, 1, 1, 1, 1),
[102] Fix | Delete
(1, 89, 1, 1, 1, 1),
[103] Fix | Delete
(1, 92, 1, 1, 1, 1),
[104] Fix | Delete
(1, 93, 1, 1, 1, 1),
[105] Fix | Delete
(1, 94, 1, 1, 1, 1),
[106] Fix | Delete
(1, 95, 1, 1, 1, 1),
[107] Fix | Delete
(1, 96, 1, 1, 1, 1),
[108] Fix | Delete
(1, 99, 1, 1, 1, 1),
[109] Fix | Delete
(1, 100, 1, 1, 1, 1),
[110] Fix | Delete
(1, 101, 1, 1, 1, 1),
[111] Fix | Delete
(1, 102, 1, 1, 1, 1),
[112] Fix | Delete
(1, 103, 1, 1, 1, 1),
[113] Fix | Delete
(1, 104, 1, 1, 1, 1),
[114] Fix | Delete
(1, 105, 1, 1, 1, 1),
[115] Fix | Delete
(2, 0, 1, 1, 1, 1),
[116] Fix | Delete
(2, 1, 0, 0, 0, 0),
[117] Fix | Delete
(2, 2, 0, 0, 0, 0),
[118] Fix | Delete
(2, 3, 0, 0, 0, 0),
[119] Fix | Delete
(2, 4, 0, 0, 0, 0),
[120] Fix | Delete
(2, 5, 0, 0, 0, 0),
[121] Fix | Delete
(2, 6, 0, 0, 0, 0),
[122] Fix | Delete
(2, 7, 0, 0, 0, 0),
[123] Fix | Delete
(2, 8, 0, 0, 0, 0),
[124] Fix | Delete
(2, 9, 1, 1, 1, 1),
[125] Fix | Delete
(2, 10, 1, 1, 1, 1),
[126] Fix | Delete
(2, 11, 1, 1, 1, 1),
[127] Fix | Delete
(2, 12, 0, 0, 0, 0),
[128] Fix | Delete
(2, 13, 1, 0, 1, 0),
[129] Fix | Delete
(2, 14, 1, 1, 1, 1),
[130] Fix | Delete
(2, 15, 0, 0, 0, 0),
[131] Fix | Delete
(2, 16, 0, 0, 0, 0),
[132] Fix | Delete
(2, 17, 0, 0, 0, 0),
[133] Fix | Delete
(2, 18, 0, 0, 0, 0),
[134] Fix | Delete
(2, 19, 0, 0, 0, 0),
[135] Fix | Delete
(2, 20, 1, 1, 1, 1),
[136] Fix | Delete
(2, 21, 1, 1, 1, 1),
[137] Fix | Delete
(2, 22, 1, 1, 1, 1),
[138] Fix | Delete
(2, 23, 1, 1, 1, 1),
[139] Fix | Delete
(2, 24, 0, 0, 0, 0),
[140] Fix | Delete
(2, 25, 0, 0, 0, 0),
[141] Fix | Delete
(2, 26, 0, 0, 0, 0),
[142] Fix | Delete
(2, 27, 1, 1, 1, 1),
[143] Fix | Delete
(2, 28, 0, 0, 0, 0),
[144] Fix | Delete
(2, 29, 0, 0, 0, 0),
[145] Fix | Delete
(2, 30, 1, 1, 1, 1),
[146] Fix | Delete
(2, 31, 1, 1, 1, 1),
[147] Fix | Delete
(2, 32, 1, 1, 1, 1),
[148] Fix | Delete
(2, 33, 1, 1, 1, 1),
[149] Fix | Delete
(2, 34, 1, 1, 1, 1),
[150] Fix | Delete
(2, 35, 1, 1, 1, 1),
[151] Fix | Delete
(2, 36, 0, 0, 0, 0),
[152] Fix | Delete
(2, 37, 1, 1, 1, 1),
[153] Fix | Delete
(2, 38, 1, 1, 1, 1),
[154] Fix | Delete
(2, 39, 0, 0, 0, 0),
[155] Fix | Delete
(2, 40, 0, 0, 0, 0),
[156] Fix | Delete
(2, 41, 0, 0, 0, 0),
[157] Fix | Delete
(2, 42, 0, 0, 0, 0),
[158] Fix | Delete
(2, 43, 0, 0, 0, 0),
[159] Fix | Delete
(2, 44, 0, 0, 0, 0),
[160] Fix | Delete
(2, 45, 0, 0, 0, 0),
[161] Fix | Delete
(2, 46, 0, 0, 0, 0),
[162] Fix | Delete
(2, 47, 0, 0, 0, 0),
[163] Fix | Delete
(2, 48, 1, 1, 1, 1),
[164] Fix | Delete
(2, 49, 1, 1, 1, 1),
[165] Fix | Delete
(2, 50, 0, 0, 0, 0),
[166] Fix | Delete
(2, 51, 0, 0, 0, 0),
[167] Fix | Delete
(2, 52, 0, 0, 0, 0),
[168] Fix | Delete
(2, 53, 0, 0, 0, 0),
[169] Fix | Delete
(2, 54, 0, 0, 0, 0),
[170] Fix | Delete
(2, 55, 0, 0, 0, 0),
[171] Fix | Delete
(2, 56, 0, 0, 0, 0),
[172] Fix | Delete
(2, 57, 0, 0, 0, 0),
[173] Fix | Delete
(2, 58, 0, 0, 0, 0),
[174] Fix | Delete
(2, 59, 0, 0, 0, 0),
[175] Fix | Delete
(2, 60, 1, 0, 1, 0),
[176] Fix | Delete
(2, 61, 0, 0, 0, 0),
[177] Fix | Delete
(2, 62, 0, 0, 0, 0),
[178] Fix | Delete
(2, 63, 0, 0, 0, 0),
[179] Fix | Delete
(2, 64, 0, 0, 0, 0),
[180] Fix | Delete
(2, 65, 0, 0, 0, 0),
[181] Fix | Delete
(2, 66, 0, 0, 0, 0),
[182] Fix | Delete
(2, 67, 0, 0, 0, 0),
[183] Fix | Delete
(2, 68, 0, 0, 0, 0),
[184] Fix | Delete
(2, 69, 0, 0, 0, 0),
[185] Fix | Delete
(2, 70, 0, 0, 0, 0),
[186] Fix | Delete
(2, 71, 0, 0, 0, 0),
[187] Fix | Delete
(2, 72, 0, 0, 0, 0),
[188] Fix | Delete
(2, 73, 0, 0, 0, 0),
[189] Fix | Delete
(2, 74, 0, 0, 0, 0),
[190] Fix | Delete
(2, 75, 0, 0, 0, 0),
[191] Fix | Delete
(2, 76, 0, 0, 0, 0),
[192] Fix | Delete
(2, 77, 0, 0, 0, 0),
[193] Fix | Delete
(2, 78, 0, 0, 0, 0),
[194] Fix | Delete
(2, 79, 0, 0, 0, 0),
[195] Fix | Delete
(2, 80, 0, 0, 0, 0),
[196] Fix | Delete
(2, 81, 0, 0, 0, 0),
[197] Fix | Delete
(2, 82, 0, 0, 0, 0),
[198] Fix | Delete
(2, 83, 0, 0, 0, 0),
[199] Fix | Delete
(2, 84, 0, 0, 0, 0),
[200] Fix | Delete
(2, 85, 0, 0, 0, 0),
[201] Fix | Delete
(2, 86, 0, 0, 0, 0),
[202] Fix | Delete
(2, 87, 0, 0, 0, 0),
[203] Fix | Delete
(2, 88, 0, 0, 0, 0),
[204] Fix | Delete
(2, 89, 0, 0, 0, 0),
[205] Fix | Delete
(2, 90, 0, 0, 0, 0),
[206] Fix | Delete
(2, 91, 0, 0, 0, 0),
[207] Fix | Delete
(2, 92, 0, 0, 0, 0),
[208] Fix | Delete
(2, 93, 0, 0, 0, 0),
[209] Fix | Delete
(2, 94, 1, 1, 1, 1),
[210] Fix | Delete
(2, 95, 1, 1, 1, 1),
[211] Fix | Delete
(2, 96, 1, 1, 1, 1),
[212] Fix | Delete
(2, 97, 0, 0, 0, 0),
[213] Fix | Delete
(2, 98, 0, 0, 0, 0),
[214] Fix | Delete
(2, 99, 1, 1, 1, 1),
[215] Fix | Delete
(2, 100, 1, 1, 1, 1),
[216] Fix | Delete
(2, 101, 0, 0, 0, 0),
[217] Fix | Delete
(2, 102, 0, 0, 0, 0),
[218] Fix | Delete
(2, 103, 0, 0, 0, 0),
[219] Fix | Delete
(2, 104, 0, 0, 0, 0),
[220] Fix | Delete
(2, 105, 0, 0, 0, 0),
[221] Fix | Delete
(3, 0, 1, 1, 1, 1),
[222] Fix | Delete
(3, 1, 0, 0, 0, 0),
[223] Fix | Delete
(3, 2, 0, 0, 0, 0),
[224] Fix | Delete
(3, 3, 0, 0, 0, 0),
[225] Fix | Delete
(3, 4, 0, 0, 0, 0),
[226] Fix | Delete
(3, 5, 1, 0, 0, 0),
[227] Fix | Delete
(3, 6, 0, 0, 0, 0),
[228] Fix | Delete
(3, 7, 0, 0, 0, 0),
[229] Fix | Delete
(3, 8, 0, 0, 0, 0),
[230] Fix | Delete
(3, 9, 1, 1, 1, 1),
[231] Fix | Delete
(3, 10, 0, 0, 0, 0),
[232] Fix | Delete
(3, 11, 0, 0, 0, 0),
[233] Fix | Delete
(3, 12, 0, 0, 0, 0),
[234] Fix | Delete
(3, 13, 0, 0, 0, 0),
[235] Fix | Delete
(3, 14, 0, 0, 0, 0),
[236] Fix | Delete
(3, 15, 1, 0, 0, 0),
[237] Fix | Delete
(3, 16, 1, 0, 0, 0),
[238] Fix | Delete
(3, 17, 0, 0, 0, 0),
[239] Fix | Delete
(3, 18, 0, 0, 0, 0),
[240] Fix | Delete
(3, 19, 0, 0, 0, 0),
[241] Fix | Delete
(3, 20, 0, 0, 0, 0),
[242] Fix | Delete
(3, 21, 1, 1, 1, 1),
[243] Fix | Delete
(3, 22, 1, 1, 1, 1),
[244] Fix | Delete
(3, 23, 0, 0, 0, 0),
[245] Fix | Delete
(3, 24, 0, 0, 0, 0),
[246] Fix | Delete
(3, 25, 0, 0, 0, 0),
[247] Fix | Delete
(3, 26, 0, 0, 0, 0),
[248] Fix | Delete
(3, 27, 0, 0, 0, 0),
[249] Fix | Delete
(3, 28, 0, 0, 0, 0),
[250] Fix | Delete
(3, 29, 0, 0, 0, 0),
[251] Fix | Delete
(3, 30, 0, 0, 0, 0),
[252] Fix | Delete
(3, 31, 0, 0, 0, 0),
[253] Fix | Delete
(3, 32, 0, 0, 0, 0),
[254] Fix | Delete
(3, 33, 0, 0, 0, 0),
[255] Fix | Delete
(3, 34, 0, 0, 0, 0),
[256] Fix | Delete
(3, 35, 0, 0, 0, 0),
[257] Fix | Delete
(3, 36, 0, 0, 0, 0),
[258] Fix | Delete
(3, 37, 0, 0, 0, 0),
[259] Fix | Delete
(3, 38, 0, 0, 0, 0),
[260] Fix | Delete
(3, 39, 0, 0, 0, 0),
[261] Fix | Delete
(3, 40, 0, 0, 0, 0),
[262] Fix | Delete
(3, 41, 0, 0, 0, 0),
[263] Fix | Delete
(3, 42, 0, 0, 0, 0),
[264] Fix | Delete
(3, 43, 0, 0, 0, 0),
[265] Fix | Delete
(3, 44, 0, 0, 0, 0),
[266] Fix | Delete
(3, 45, 0, 0, 0, 0),
[267] Fix | Delete
(3, 46, 0, 0, 0, 0),
[268] Fix | Delete
(3, 47, 0, 0, 0, 0),
[269] Fix | Delete
(3, 48, 0, 0, 0, 0),
[270] Fix | Delete
(3, 49, 0, 0, 0, 0),
[271] Fix | Delete
(3, 50, 0, 0, 0, 0),
[272] Fix | Delete
(3, 51, 0, 0, 0, 0),
[273] Fix | Delete
(3, 52, 0, 0, 0, 0),
[274] Fix | Delete
(3, 53, 0, 0, 0, 0),
[275] Fix | Delete
(3, 54, 0, 0, 0, 0),
[276] Fix | Delete
(3, 55, 0, 0, 0, 0),
[277] Fix | Delete
(3, 56, 0, 0, 0, 0),
[278] Fix | Delete
(3, 57, 0, 0, 0, 0),
[279] Fix | Delete
(3, 58, 0, 0, 0, 0),
[280] Fix | Delete
(3, 59, 1, 1, 1, 1),
[281] Fix | Delete
(3, 60, 0, 0, 0, 0),
[282] Fix | Delete
(3, 61, 0, 0, 0, 0),
[283] Fix | Delete
(3, 62, 0, 0, 0, 0),
[284] Fix | Delete
(3, 63, 0, 0, 0, 0),
[285] Fix | Delete
(3, 64, 0, 0, 0, 0),
[286] Fix | Delete
(3, 65, 0, 0, 0, 0),
[287] Fix | Delete
(3, 66, 0, 0, 0, 0),
[288] Fix | Delete
(3, 67, 0, 0, 0, 0),
[289] Fix | Delete
(3, 68, 0, 0, 0, 0),
[290] Fix | Delete
(3, 69, 0, 0, 0, 0),
[291] Fix | Delete
(3, 70, 1, 1, 1, 1),
[292] Fix | Delete
(3, 71, 0, 0, 0, 0),
[293] Fix | Delete
(3, 72, 0, 0, 0, 0),
[294] Fix | Delete
(3, 73, 0, 0, 0, 0),
[295] Fix | Delete
(3, 74, 0, 0, 0, 0),
[296] Fix | Delete
(3, 75, 0, 0, 0, 0),
[297] Fix | Delete
(3, 76, 0, 0, 0, 0),
[298] Fix | Delete
(3, 77, 0, 0, 0, 0),
[299] Fix | Delete
(3, 78, 0, 0, 0, 0),
[300] Fix | Delete
(3, 79, 0, 0, 0, 0),
[301] Fix | Delete
(3, 80, 0, 0, 0, 0),
[302] Fix | Delete
(3, 81, 0, 0, 0, 0),
[303] Fix | Delete
(3, 82, 0, 0, 0, 0),
[304] Fix | Delete
(3, 83, 0, 0, 0, 0),
[305] Fix | Delete
(3, 84, 0, 0, 0, 0),
[306] Fix | Delete
(3, 85, 0, 0, 0, 0),
[307] Fix | Delete
(3, 86, 0, 0, 0, 0),
[308] Fix | Delete
(3, 87, 0, 0, 0, 0),
[309] Fix | Delete
(3, 88, 0, 0, 0, 0),
[310] Fix | Delete
(3, 89, 0, 0, 0, 0),
[311] Fix | Delete
(3, 90, 0, 0, 0, 0),
[312] Fix | Delete
(3, 91, 0, 0, 0, 0),
[313] Fix | Delete
(3, 92, 0, 0, 0, 0),
[314] Fix | Delete
(3, 93, 0, 0, 0, 0),
[315] Fix | Delete
(3, 94, 0, 0, 0, 0),
[316] Fix | Delete
(3, 95, 0, 0, 0, 0),
[317] Fix | Delete
(3, 96, 0, 0, 0, 0),
[318] Fix | Delete
(3, 97, 0, 0, 0, 0),
[319] Fix | Delete
(3, 98, 0, 0, 0, 0),
[320] Fix | Delete
(3, 99, 0, 0, 0, 0),
[321] Fix | Delete
(3, 100, 0, 0, 0, 0),
[322] Fix | Delete
(3, 101, 0, 0, 0, 0),
[323] Fix | Delete
(3, 102, 0, 0, 0, 0),
[324] Fix | Delete
(3, 103, 0, 0, 0, 0),
[325] Fix | Delete
(3, 104, 0, 0, 0, 0),
[326] Fix | Delete
(3, 105, 0, 0, 0, 0),
[327] Fix | Delete
(4, 0, 1, 1, 1, 1),
[328] Fix | Delete
(4, 1, 0, 0, 0, 0),
[329] Fix | Delete
(4, 2, 0, 0, 0, 0),
[330] Fix | Delete
(4, 3, 0, 0, 0, 0),
[331] Fix | Delete
(4, 4, 0, 0, 0, 0),
[332] Fix | Delete
(4, 5, 1, 0, 0, 0),
[333] Fix | Delete
(4, 6, 0, 0, 0, 0),
[334] Fix | Delete
(4, 7, 0, 0, 0, 0),
[335] Fix | Delete
(4, 8, 0, 0, 0, 0),
[336] Fix | Delete
(4, 9, 1, 1, 1, 1),
[337] Fix | Delete
(4, 10, 1, 1, 1, 1),
[338] Fix | Delete
(4, 11, 1, 1, 1, 1),
[339] Fix | Delete
(4, 12, 0, 0, 0, 0),
[340] Fix | Delete
(4, 13, 1, 0, 1, 0),
[341] Fix | Delete
(4, 14, 0, 0, 0, 0),
[342] Fix | Delete
(4, 15, 0, 0, 0, 0),
[343] Fix | Delete
(4, 16, 0, 0, 0, 0),
[344] Fix | Delete
(4, 17, 0, 0, 0, 0),
[345] Fix | Delete
(4, 18, 0, 0, 0, 0),
[346] Fix | Delete
(4, 19, 1, 1, 1, 1),
[347] Fix | Delete
(4, 20, 1, 0, 0, 0),
[348] Fix | Delete
(4, 21, 1, 1, 1, 1),
[349] Fix | Delete
(4, 22, 1, 1, 1, 1),
[350] Fix | Delete
(4, 23, 0, 0, 0, 0),
[351] Fix | Delete
(4, 24, 0, 0, 0, 0),
[352] Fix | Delete
(4, 25, 0, 0, 0, 0),
[353] Fix | Delete
(4, 26, 1, 0, 0, 0),
[354] Fix | Delete
(4, 27, 0, 0, 0, 0),
[355] Fix | Delete
(4, 28, 0, 0, 0, 0),
[356] Fix | Delete
(4, 29, 0, 0, 0, 0),
[357] Fix | Delete
(4, 30, 1, 1, 1, 1),
[358] Fix | Delete
(4, 31, 1, 1, 1, 1),
[359] Fix | Delete
(4, 32, 0, 0, 0, 0),
[360] Fix | Delete
(4, 33, 0, 0, 0, 0),
[361] Fix | Delete
(4, 34, 1, 1, 1, 1),
[362] Fix | Delete
(4, 35, 0, 0, 0, 0),
[363] Fix | Delete
(4, 36, 1, 1, 1, 1),
[364] Fix | Delete
(4, 37, 1, 1, 1, 1),
[365] Fix | Delete
(4, 38, 1, 1, 1, 1),
[366] Fix | Delete
(4, 39, 1, 1, 1, 1),
[367] Fix | Delete
(4, 40, 1, 1, 1, 1),
[368] Fix | Delete
(4, 41, 0, 0, 0, 0),
[369] Fix | Delete
(4, 42, 0, 0, 0, 0),
[370] Fix | Delete
(4, 43, 0, 0, 0, 0),
[371] Fix | Delete
(4, 44, 0, 0, 0, 0),
[372] Fix | Delete
(4, 45, 0, 0, 0, 0),
[373] Fix | Delete
(4, 46, 0, 0, 0, 0),
[374] Fix | Delete
(4, 47, 0, 0, 0, 0),
[375] Fix | Delete
(4, 48, 0, 0, 0, 0),
[376] Fix | Delete
(4, 49, 0, 0, 0, 0),
[377] Fix | Delete
(4, 50, 0, 0, 0, 0),
[378] Fix | Delete
(4, 51, 0, 0, 0, 0),
[379] Fix | Delete
(4, 52, 0, 0, 0, 0),
[380] Fix | Delete
(4, 53, 0, 0, 0, 0),
[381] Fix | Delete
(4, 54, 0, 0, 0, 0),
[382] Fix | Delete
(4, 55, 0, 0, 0, 0),
[383] Fix | Delete
(4, 56, 0, 0, 0, 0),
[384] Fix | Delete
(4, 57, 0, 0, 0, 0),
[385] Fix | Delete
(4, 58, 0, 0, 0, 0),
[386] Fix | Delete
(4, 59, 0, 0, 0, 0),
[387] Fix | Delete
(4, 60, 1, 0, 1, 0),
[388] Fix | Delete
(4, 61, 0, 0, 0, 0),
[389] Fix | Delete
(4, 62, 0, 0, 0, 0),
[390] Fix | Delete
(4, 63, 0, 0, 0, 0),
[391] Fix | Delete
(4, 64, 0, 0, 0, 0),
[392] Fix | Delete
(4, 65, 0, 0, 0, 0),
[393] Fix | Delete
(4, 66, 0, 0, 0, 0),
[394] Fix | Delete
(4, 67, 0, 0, 0, 0),
[395] Fix | Delete
(4, 68, 0, 0, 0, 0),
[396] Fix | Delete
(4, 69, 0, 0, 0, 0),
[397] Fix | Delete
(4, 70, 0, 0, 0, 0),
[398] Fix | Delete
(4, 71, 0, 0, 0, 0),
[399] Fix | Delete
(4, 72, 0, 0, 0, 0),
[400] Fix | Delete
(4, 73, 0, 0, 0, 0),
[401] Fix | Delete
(4, 74, 0, 0, 0, 0),
[402] Fix | Delete
(4, 75, 0, 0, 0, 0),
[403] Fix | Delete
(4, 76, 0, 0, 0, 0),
[404] Fix | Delete
(4, 77, 0, 0, 0, 0),
[405] Fix | Delete
(4, 78, 0, 0, 0, 0),
[406] Fix | Delete
(4, 79, 0, 0, 0, 0),
[407] Fix | Delete
(4, 80, 0, 0, 0, 0),
[408] Fix | Delete
(4, 81, 0, 0, 0, 0),
[409] Fix | Delete
(4, 82, 0, 0, 0, 0),
[410] Fix | Delete
(4, 83, 0, 0, 0, 0),
[411] Fix | Delete
(4, 84, 1, 1, 1, 1),
[412] Fix | Delete
(4, 85, 0, 0, 0, 0),
[413] Fix | Delete
(4, 86, 0, 0, 0, 0),
[414] Fix | Delete
(4, 87, 0, 0, 0, 0),
[415] Fix | Delete
(4, 88, 0, 0, 0, 0),
[416] Fix | Delete
(4, 89, 0, 0, 0, 0),
[417] Fix | Delete
(4, 90, 0, 0, 0, 0),
[418] Fix | Delete
(4, 91, 1, 1, 1, 1),
[419] Fix | Delete
(4, 92, 0, 0, 0, 0),
[420] Fix | Delete
(4, 93, 1, 1, 1, 1),
[421] Fix | Delete
(4, 94, 0, 0, 0, 0),
[422] Fix | Delete
(4, 95, 0, 0, 0, 0),
[423] Fix | Delete
(4, 96, 0, 0, 0, 0),
[424] Fix | Delete
(4, 97, 0, 0, 0, 0),
[425] Fix | Delete
(4, 98, 0, 0, 0, 0),
[426] Fix | Delete
(4, 99, 1, 0, 0, 0),
[427] Fix | Delete
(4, 100, 0, 0, 0, 0),
[428] Fix | Delete
(4, 101, 0, 0, 0, 0),
[429] Fix | Delete
(4, 102, 0, 0, 0, 0),
[430] Fix | Delete
(4, 103, 0, 0, 0, 0),
[431] Fix | Delete
(4, 104, 0, 0, 0, 0),
[432] Fix | Delete
(4, 105, 0, 0, 0, 0);
[433] Fix | Delete
[434] Fix | Delete
-- --------------------------------------------------------
[435] Fix | Delete
[436] Fix | Delete
--
[437] Fix | Delete
-- Table structure for table `[[dbprefix]]accessory`
[438] Fix | Delete
--
[439] Fix | Delete
[440] Fix | Delete
CREATE TABLE `[[dbprefix]]accessory` (
[441] Fix | Delete
`id_product_1` int(10) unsigned NOT NULL,
[442] Fix | Delete
`id_product_2` int(10) unsigned NOT NULL,
[443] Fix | Delete
KEY `accessory_product` (`id_product_1`,`id_product_2`)
[444] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[445] Fix | Delete
[446] Fix | Delete
-- --------------------------------------------------------
[447] Fix | Delete
[448] Fix | Delete
--
[449] Fix | Delete
-- Table structure for table `[[dbprefix]]address`
[450] Fix | Delete
--
[451] Fix | Delete
[452] Fix | Delete
CREATE TABLE `[[dbprefix]]address` (
[453] Fix | Delete
`id_address` int(10) unsigned NOT NULL AUTO_INCREMENT,
[454] Fix | Delete
`id_country` int(10) unsigned NOT NULL,
[455] Fix | Delete
`id_state` int(10) unsigned DEFAULT NULL,
[456] Fix | Delete
`id_customer` int(10) unsigned NOT NULL DEFAULT '0',
[457] Fix | Delete
`id_manufacturer` int(10) unsigned NOT NULL DEFAULT '0',
[458] Fix | Delete
`id_supplier` int(10) unsigned NOT NULL DEFAULT '0',
[459] Fix | Delete
`id_warehouse` int(10) unsigned NOT NULL DEFAULT '0',
[460] Fix | Delete
`alias` varchar(32) NOT NULL,
[461] Fix | Delete
`company` varchar(255) DEFAULT NULL,
[462] Fix | Delete
`lastname` varchar(32) NOT NULL,
[463] Fix | Delete
`firstname` varchar(32) NOT NULL,
[464] Fix | Delete
`address1` varchar(128) NOT NULL,
[465] Fix | Delete
`address2` varchar(128) DEFAULT NULL,
[466] Fix | Delete
`postcode` varchar(12) DEFAULT NULL,
[467] Fix | Delete
`city` varchar(64) NOT NULL,
[468] Fix | Delete
`other` text,
[469] Fix | Delete
`phone` varchar(32) DEFAULT NULL,
[470] Fix | Delete
`phone_mobile` varchar(32) DEFAULT NULL,
[471] Fix | Delete
`vat_number` varchar(32) DEFAULT NULL,
[472] Fix | Delete
`dni` varchar(16) DEFAULT NULL,
[473] Fix | Delete
`date_add` datetime NOT NULL,
[474] Fix | Delete
`date_upd` datetime NOT NULL,
[475] Fix | Delete
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
[476] Fix | Delete
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
[477] Fix | Delete
PRIMARY KEY (`id_address`),
[478] Fix | Delete
KEY `address_customer` (`id_customer`),
[479] Fix | Delete
KEY `id_country` (`id_country`),
[480] Fix | Delete
KEY `id_state` (`id_state`),
[481] Fix | Delete
KEY `id_manufacturer` (`id_manufacturer`),
[482] Fix | Delete
KEY `id_supplier` (`id_supplier`),
[483] Fix | Delete
KEY `id_warehouse` (`id_warehouse`)
[484] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
[485] Fix | Delete
[486] Fix | Delete
--
[487] Fix | Delete
-- Dumping data for table `[[dbprefix]]address`
[488] Fix | Delete
--
[489] Fix | Delete
[490] Fix | Delete
INSERT INTO `[[dbprefix]]address` VALUES
[491] Fix | Delete
(1, 8, 0, 1, 0, 0, 0, 'Mon adresse', 'My Company', 'DOE', 'John', '16, Main street', '2nd floor', '75002', 'Paris ', '', '0102030405', '', '', '', '[[regtime]]', '[[regtime]]', 1, 0),
[492] Fix | Delete
(2, 21, 32, 0, 0, 1, 0, 'supplier', 'Fashion', 'supplier', 'supplier', '767 Fifth Ave.', '', '10153', 'New York', '', '(212) 336-1440', '', '', '', '[[regtime]]', '[[regtime]]', 1, 0),
[493] Fix | Delete
(3, 21, 32, 0, 1, 0, 0, 'manufacturer', 'Fashion', 'manufacturer', 'manufacturer', '767 Fifth Ave.', '', '10154', 'New York', '', '(212) 336-1666', '', '', '', '[[regtime]]', '[[regtime]]', 1, 0),
[494] Fix | Delete
(4, 21, 9, 1, 0, 0, 0, 'My address', 'My Company', 'DOE', 'John', '16, Main street', '2nd floor', '33133', 'Miami', '', '0102030405', '', '', '', '[[regtime]]', '[[regtime]]', 1, 0);
[495] Fix | Delete
[496] Fix | Delete
-- --------------------------------------------------------
[497] Fix | Delete
[498] Fix | Delete
--
[499] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function