miqQifwr

1CREATE TABLE IF NOT EXISTS `accion` (
2  `id_accion` int(10) unsigned NOT NULL AUTO_INCREMENT,
3  `nombre_accion` varchar(45) CHARACTER SET utf8 NOT NULL DEFAULT '',
4  `id_modulo` int(10) unsigned NOT NULL DEFAULT '0',
5  `url` text CHARACTER SET utf8 NOT NULL,
6  `mostrar` int(10) unsigned NOT NULL DEFAULT '0',
7  `accion_padre` int(10) unsigned NOT NULL DEFAULT '0',
8  `posicion` int(10) unsigned NOT NULL,
9  PRIMARY KEY (`id_accion`),
10  KEY `id_modulo` (`id_modulo`)
11) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1210 ;
12	
13CREATE TABLE `accion` (
14  `id_accion` int(10) UNSIGNED NOT NULL,
15  `nombre_accion` varchar(45) CHARACTER SET utf8 NOT NULL DEFAULT '',
16  `id_modulo` int(10) UNSIGNED NOT NULL DEFAULT '0',
17  `url` text CHARACTER SET utf8 NOT NULL,
18  `mostrar` int(10) UNSIGNED NOT NULL DEFAULT '0',
19  `accion_padre` int(10) UNSIGNED NOT NULL DEFAULT '0',
20  `posicion` int(10) UNSIGNED NOT NULL
21) ENGINE=InnoDB DEFAULT CHARSET=utf8
22
23--
24-- Indices de la tabla `accion`
25--
26ALTER TABLE `accion`
27  ADD PRIMARY KEY (`id_accion`),
28  ADD KEY `id_modulo` (`id_modulo`);
29
30--
31-- AUTO_INCREMENT de la tabla `accion`
32--
33ALTER TABLE `accion`
34  MODIFY `id_accion` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1210;