-- phpMyAdmin SQL Dump -- version 4.2.7.1 -- http://www.phpmyadmin.net -- -- Servidor: 127.0.0.1 -- Tiempo de generación: 09-02-2015 a las 11:53:12 -- Versión del servidor: 5.6.20 -- Versión de PHP: 5.5.15 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- -- Base de datos: `finalerp` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `city` -- CREATE TABLE IF NOT EXISTS `city` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `zipcode` int(11) NOT NULL, `idstate` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `country` -- CREATE TABLE IF NOT EXISTS `country` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `abbreviation` varchar(2) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `currency` -- CREATE TABLE IF NOT EXISTS `currency` ( `id` int(11) NOT NULL, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `abbreviation` varchar(3) COLLATE utf8_unicode_ci NOT NULL, `changeeuro` float NOT NULL, `idcountry` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `customer` -- CREATE TABLE IF NOT EXISTS `customer` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `address` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(10) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `delegation` -- CREATE TABLE IF NOT EXISTS `delegation` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `address` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `idcity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `department` -- CREATE TABLE IF NOT EXISTS `department` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `idemployee` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `employee` -- CREATE TABLE IF NOT EXISTS `employee` ( `id` int(11) NOT NULL, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `birthdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `phone` varchar(9) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `issue` -- CREATE TABLE IF NOT EXISTS `issue` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `idissuetype` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `issuetype` -- CREATE TABLE IF NOT EXISTS `issuetype` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `message` -- CREATE TABLE IF NOT EXISTS `message` ( `id` int(11) NOT NULL, `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `message` text COLLATE utf8_unicode_ci NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `iduser` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `payroll` -- CREATE TABLE IF NOT EXISTS `payroll` ( `id` int(11) NOT NULL, `description` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `gross` float NOT NULL, `wage` float NOT NULL, `idemployee` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `product` -- CREATE TABLE IF NOT EXISTS `product` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `price` float NOT NULL, `idtipoproduct` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `producttype` -- CREATE TABLE IF NOT EXISTS `producttype` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `register` -- CREATE TABLE IF NOT EXISTS `register` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `iduser` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `role` -- CREATE TABLE IF NOT EXISTS `role` ( `id` int(11) NOT NULL, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `sale` -- CREATE TABLE IF NOT EXISTS `sale` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `idemployee` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `state` -- CREATE TABLE IF NOT EXISTS `state` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `country` varchar(50) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `stock` -- CREATE TABLE IF NOT EXISTS `stock` ( `id` int(11) NOT NULL, `rack` int(11) NOT NULL, `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `qty` int(11) NOT NULL, `idproduct` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `supplier` -- CREATE TABLE IF NOT EXISTS `supplier` ( `id` int(11) NOT NULL, `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `address` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `idcity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `user` -- CREATE TABLE IF NOT EXISTS `user` ( `id` int(11) NOT NULL, `login` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `idrole` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -- Índices para tablas volcadas -- -- -- Indices de la tabla `city` -- ALTER TABLE `city` ADD PRIMARY KEY (`id`), ADD KEY `idstate` (`idstate`); -- -- Indices de la tabla `country` -- ALTER TABLE `country` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `currency` -- ALTER TABLE `currency` ADD PRIMARY KEY (`id`), ADD KEY `idcountry` (`idcountry`); -- -- Indices de la tabla `customer` -- ALTER TABLE `customer` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `delegation` -- ALTER TABLE `delegation` ADD PRIMARY KEY (`id`), ADD KEY `idcity` (`idcity`); -- -- Indices de la tabla `department` -- ALTER TABLE `department` ADD PRIMARY KEY (`id`), ADD KEY `idemployee` (`idemployee`); -- -- Indices de la tabla `employee` -- ALTER TABLE `employee` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `issue` -- ALTER TABLE `issue` ADD PRIMARY KEY (`id`), ADD KEY `idissuetype` (`idissuetype`); -- -- Indices de la tabla `issuetype` -- ALTER TABLE `issuetype` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `message` -- ALTER TABLE `message` ADD PRIMARY KEY (`id`), ADD KEY `iduser` (`iduser`); -- -- Indices de la tabla `payroll` -- ALTER TABLE `payroll` ADD PRIMARY KEY (`id`), ADD KEY `idemployee` (`idemployee`); -- -- Indices de la tabla `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`id`), ADD KEY `idtipoproduct` (`idtipoproduct`); -- -- Indices de la tabla `producttype` -- ALTER TABLE `producttype` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `register` -- ALTER TABLE `register` ADD PRIMARY KEY (`id`), ADD KEY `iduser` (`iduser`); -- -- Indices de la tabla `role` -- ALTER TABLE `role` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `sale` -- ALTER TABLE `sale` ADD PRIMARY KEY (`id`), ADD KEY `idemployee` (`idemployee`); -- -- Indices de la tabla `state` -- ALTER TABLE `state` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `stock` -- ALTER TABLE `stock` ADD PRIMARY KEY (`id`), ADD KEY `idproduct` (`idproduct`); -- -- Indices de la tabla `supplier` -- ALTER TABLE `supplier` ADD PRIMARY KEY (`id`), ADD KEY `idcity` (`idcity`); -- -- Indices de la tabla `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`), ADD KEY `idrole` (`idrole`), ADD KEY `idrole_2` (`idrole`); -- -- AUTO_INCREMENT de las tablas volcadas -- -- -- AUTO_INCREMENT de la tabla `city` -- ALTER TABLE `city` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `country` -- ALTER TABLE `country` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `currency` -- ALTER TABLE `currency` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `customer` -- ALTER TABLE `customer` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `delegation` -- ALTER TABLE `delegation` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `department` -- ALTER TABLE `department` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `employee` -- ALTER TABLE `employee` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `issue` -- ALTER TABLE `issue` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `issuetype` -- ALTER TABLE `issuetype` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `message` -- ALTER TABLE `message` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `payroll` -- ALTER TABLE `payroll` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `product` -- ALTER TABLE `product` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `producttype` -- ALTER TABLE `producttype` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `register` -- ALTER TABLE `register` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `role` -- ALTER TABLE `role` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `sale` -- ALTER TABLE `sale` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `state` -- ALTER TABLE `state` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `stock` -- ALTER TABLE `stock` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `supplier` -- ALTER TABLE `supplier` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- Restricciones para tablas volcadas -- -- -- Filtros para la tabla `city` -- ALTER TABLE `city` ADD CONSTRAINT `fk_idstate` FOREIGN KEY (`idstate`) REFERENCES `state` (`id`); -- -- Filtros para la tabla `currency` -- ALTER TABLE `currency` ADD CONSTRAINT `fk_idcountry` FOREIGN KEY (`idcountry`) REFERENCES `country` (`id`); -- -- Filtros para la tabla `delegation` -- ALTER TABLE `delegation` ADD CONSTRAINT `fk_idcity` FOREIGN KEY (`idcity`) REFERENCES `city` (`id`); -- -- Filtros para la tabla `department` -- ALTER TABLE `department` ADD CONSTRAINT `fk_idemployee` FOREIGN KEY (`idemployee`) REFERENCES `employee` (`id`); -- -- Filtros para la tabla `issue` -- ALTER TABLE `issue` ADD CONSTRAINT `fk_idissuetype` FOREIGN KEY (`idissuetype`) REFERENCES `issuetype` (`id`); -- -- Filtros para la tabla `message` -- ALTER TABLE `message` ADD CONSTRAINT `fk_iduser` FOREIGN KEY (`iduser`) REFERENCES `user` (`id`); -- -- Filtros para la tabla `payroll` -- ALTER TABLE `payroll` ADD CONSTRAINT `fk_idemployeepayroll` FOREIGN KEY (`idemployee`) REFERENCES `employee` (`id`); -- -- Filtros para la tabla `product` -- ALTER TABLE `product` ADD CONSTRAINT `fk_idtipoproduct` FOREIGN KEY (`idtipoproduct`) REFERENCES `producttype` (`id`); -- -- Filtros para la tabla `register` -- ALTER TABLE `register` ADD CONSTRAINT `fk_iduserregister` FOREIGN KEY (`iduser`) REFERENCES `user` (`id`); -- -- Filtros para la tabla `sale` -- ALTER TABLE `sale` ADD CONSTRAINT `fk_idemployeesale` FOREIGN KEY (`idemployee`) REFERENCES `employee` (`id`); -- -- Filtros para la tabla `stock` -- ALTER TABLE `stock` ADD CONSTRAINT `fk_idproduct` FOREIGN KEY (`idproduct`) REFERENCES `product` (`id`); -- -- Filtros para la tabla `supplier` -- ALTER TABLE `supplier` ADD CONSTRAINT `fk_idcitysupplier` FOREIGN KEY (`idcity`) REFERENCES `city` (`id`); -- -- Filtros para la tabla `user` -- ALTER TABLE `user` ADD CONSTRAINT `fk_idrole` FOREIGN KEY (`idrole`) REFERENCES `role` (`id`);