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