¡Descarga SCRIPT MYSQL BASE INVENTARIO 20220401 y más Ejercicios en PDF de Programación de Bases de Datos solo en Docsity!
SCRIPT MYSQL BASE INVENTARIO 20220401
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00"; create database baseinventario; use baseinventario; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 */; -- -- Base de datos: baseinventario --
-- -- Estructura de tabla para la tabla inventario -- CREATE TABLE inventario ( ID_INVENTARIO int(11) NOT NULL, ID_DETALLE_MOVIMIENTO int(11) DEFAULT NULL, ID_PRODUCTO int(11) DEFAULT NULL, ENTRADAS int(11) NOT NULL, SALIDAS int(11) NOT NULL, SALDO int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='atributos\r\n\r\nid_inventario: Numero del id del inve'; -- -- Volcado de datos para la tabla inventario -- INSERT INTO inventario (ID_INVENTARIO, ID_DETALLE_MOVIMIENTO, ID_PRODUCTO, ENTRADAS, SALIDAS, SALDO) VALUES (1, 101, 1, 9000, 9, 8991), (2, 102, 2, 10000, 8, 9992), (3, 103, 3, 11000, 4, 10996), (4, 104, 4, 8000, 1, 7999), (5, 105, 5, 11000, 10, 10990), (6, 106, 6, 10000, 7, 9993), (7, 107, 7, 9000, 1, 8999), (8, 108, 8, 9000, 8, 8992), (9, 109, 9, 9000, 6, 8994), (10, 110, 10, 8000, 5, 7995), (11, 111, 11, 12000, 2, 11998), (12, 112, 12, 8000, 9, 7991), (13, 113, 13, 9000, 10, 8990), (14, 114, 14, 8000, 4, 7996), (15, 115, 15, 12000, 2, 11998), (16, 116, 16, 13000, 7, 12993), (17, 117, 17, 8000, 1, 7999), (18, 118, 18, 10000, 7, 9993), (19, 119, 19, 13000, 5, 12995), (20, 120, 20, 11000, 10, 10990), (21, 121, 21, 10000, 5, 9995), (22, 122, 22, 8000, 9, 7991), (23, 123, 23, 8000, 8, 7992),
-- Estructura de tabla para la tabla tbl_clientes
CREATE TABLE tbl_clientes ( ID_CLIENTE int(11) NOT NULL,
(10, 20, 303821631, 'MARIA TERESA', 'ANDREU CRUZ', '[email protected]', 938300025, 'JOAN MIRÓ , 10'), (11, 67, 743247653, 'ANA', 'BARALDÉS COMAS', '[email protected]', 938385567, 'JAUME GALOBART , 12'), (12, 57, 212980799, 'CRISTINA', 'BERENGUERAS CULLERÉS', '[email protected]', 937809812, 'PINTOR SERT , 12, 1R., 1A.'), (13, 82, 397740827, 'MARTA', 'LÓPEZ DE PABLO GARCIA UCEDA', '[email protected]', 936520741, 'BELLAVISTA , 30'), (14, 67, 594007126, 'MARIA ANGELES', 'ARNAU MORENO', '[email protected]', 938202456, 'MONTURIOL , 10, 1R.'), (15, 40, 575477520, 'LUCIA', 'RAYA GAVILAN', 'cabeza [email protected]', 938754554, 'JACINT VERDAGUER , 52, 2N., 4A.'), (16, 28, 166333303, 'FRANCISCA', 'ZAMBUDIO FIGULS', '[email protected]', 936875544, 'CASA NOVA , '), (17, 36, 928982944, 'MARIA ISABEL', 'BIDAULT CULLERÉS', '[email protected]', 935880712, 'DE LA CAÇA , 12, 1R., C'), (18, 6, 1015758858, 'MARIA JOSE', 'BIOSCA FONTANET', '[email protected]', 936875255, 'PINTOR SERT , 12, 2N., 1A.'), (19, 5, 314382505, 'ANTONIA', 'ZAFRA FIGULS', '[email protected]', 936542775, 'CASA SARA , '), (20, 83, 629797465, 'DOLORES', 'ALEU ICART', '[email protected]', 938773545, 'ARTÈS , 1, 1R, 1A.'), (21, 26, 821797525, 'SARA', 'BADIA TORNÉ', '[email protected]', 938200022, 'GENERAL PRIM , 11, 2N.'), (22, 37, 755776610, 'PAULA', 'MORALES GESE', '[email protected]', 936512545, 'CAU DE LA GUINEU , 4'), (23, 97, 556306303, 'ELENA', 'BLANCO FONTANET', '[email protected]', 937785655, 'JOAN SANMARTÍ , 12, 2N., 2A.'), (24, 11, 341414873, 'MARIA LUISA', 'ALVAREZ FERNÁNDEZ', 'dalí@wandoo.es', 938300385, 'PROL. PADRÓ , 1, 3R. 1A.'), (25, 23, 392770572, 'RAQUEL', 'GARCIA ALMOGUERA', 'dolç[email protected]', 936520471, 'SALLENT , 22, 2N.'), (26, 10, 215320294, 'ROSA MARIA', 'LIBORI FIGUERAS', '[email protected]', 936012445, 'JOAN MIRÓ , 3'), (27, 23, 255507313, 'PILAR', 'BIDAULT PUEYO', '[email protected]', 934500611, 'LLUÍS CASTELLS , 12, 2N.'), (28, 59, 23029121, 'MANUELA', 'BENITEZ JOSE', '[email protected]', 937885544, 'SANT VALENTÍ , 12, 1R.'),
(29, 98, 823923663, 'CONCEPCION', 'PASCUAL FLORES', '[email protected]', 936512105, 'ÀNGEL GUIMERÀ , 43, 2N'), (30, 35, 413011534, 'MARIA JESUS', 'AYALA TORNÉ', '[email protected]', 938202200, 'JAUME GALOBART , 11'), (31, 60, 664325469, 'ESTEFANIA', 'LISTAN FIGUERAS', '[email protected]', 939965585, 'AVINGUDA TRES , 3, 1R., 1A.'), (32, 11, 214743835, 'QUERALT', 'RASERO GAVILAN', '[email protected]', 936541235, 'JACINT VERDAGUER , 52, 2N., 1A.'), (33, 43, 782179842, 'JOAN', 'ARNALOT PUIG', '[email protected]', 938204054, 'DIPUTACIÓ , 10'), (34, 31, 561600961, 'JOAN', 'MOLINER GARRIDO', '[email protected]', 936584541, 'VIC , 39, 1R., 2A.'), (35, 78, 352242394, 'MARC', 'GALOBART GARCIA', '[email protected]', 934111475, 'GERMAN DURAN , 21'), (36, 82, 109750663, 'JOSEP', 'LÓPEZ GARRIGASSAIT', '[email protected]', 935687444, 'BELLAVISTA , 30'), (37, 89, 179933835, 'ESTHER', 'SÁNCHEZ GÓMEZ', '[email protected]', 936658711, 'NOU , 7, 2N.'), (38, 19, 299778203, 'LAURA', 'ALAVEDRA SUNYÉ', '[email protected]', 938773941, 'MANELIC , 1'), (39, 19, 195128885, 'RAQUEL', 'ALIGUÉ BONVEHÍ', '[email protected]', 938305295, 'DE LA PESCA , 1, 1R., 1A.'), (40, 61, 436353632, 'JOAN', 'MAS FRANCH', '[email protected]', 936524446, 'PIRINEUS , 34'), (41, 80, 584465972, 'MARIA ISABEL', 'ALOY COMPTE', 'james [email protected]', 938305551, 'PROL. JACINT VERDAGUER , 1, 2N., 2A'), (42, 3, 964828175, 'ADRIÀ', 'ASENSIO VEGA', 'jé[email protected]', 938206097, 'MALLORCA , 11'), (43, 83, 749511530, 'GERARD', 'BIDAULT PÉREZ', '[email protected]', 934500644, 'SANT BENET , 12, 2N.'), (44, 44, 580419009, 'ELIOT', 'ALOY CODINACHS', '[email protected]', 938305594, 'PROL. PADRÓ , 1, 2N., 2A.'), (45, 45, 698164550, 'JORDI', 'ALTIMIRAS ARMENTEROS', 'mata [email protected]', 938300422, 'ARTÈS , 1, 2N., 2A.'), (46, 22, 500513784, 'LLUÍS', 'BELMONTE SÁNCHEZ', '[email protected]', 938350511, 'JOAN XXIII , 12, 1R, 2A.'), (47, 2, 354981382, 'LAURA', 'BAJONA GARCIA', 'melquí[email protected]', 938727589, 'BERTRAND I SERRA , 11, 3R.'),
(67, 66, 611138838, 'MIREIA', 'RODRIGUEZ GARCÍA', '[email protected]', 936549889, 'VERGE DE FÀTIMA , 6, BX., 2A.'), (68, 6, 1016506894, 'GEMMA', 'AGUILAR SUNYÉ', '[email protected]', 938208677, 'SANT JOAN , 0, D, 3R. A'), (69, 58, 311936379, 'MARIA ISABEL', 'BARRIGA TARDÀ', '[email protected]', 938325558, 'GALILEU , 12'), (70, 93, 831216545, 'TONI', 'BARCONS LARA', '[email protected]', 938360281, 'ESPORTS , 12'), (71, 3, 315021354, 'ALEJANDRO', 'AGUILERA TATJÉ', '[email protected]', 938208380, 'JOSEP BOIXADERAS , 1'), (72, 86, 434940726, 'JOAN MARTÍ', 'ALEU PRAT', '[email protected]', 938770878, 'CERVANTES , 1, 1R.'), (73, 65, 974317561, 'INGRID', 'VALLÉS GIRVENT', '[email protected]', 936874511, 'CERVANTES , 9, 1R.'), (74, 96, 646680858, 'OLIVER', 'MOLINA GARRIDO', '[email protected]', 936548745, 'JOAN XXIII , 39'), (75, 67, 841522400, 'SANDRA', 'ARISSA HERMOSO', '[email protected]', 938755512, 'DOCTOR BARNARD , 10'), (76, 51, 389433255, 'JORDI', 'BARALDÉS PARDO', '[email protected]', 938722096, 'ESPORTS , 12'), (77, 4, 825451719, 'MARC', 'SUAREZ GARZÓN', '[email protected]', 934512544, 'DE LA PAU , 8'), (78, 42, 426737302, 'JORDINA', 'ARPA MORENO', '[email protected]', 938205011, 'SANT VALENTÍ , 11'), (79, 22, 873801624, 'MARIA JOSÉ', 'ALOY FARRANDO', '[email protected]', 938300864, 'PROL. PADRÓ , 1, 2N., 2A.'), (80, 25, 979883968, 'RAQUEL', 'LUQUE GARRIGASAIT', '[email protected]', 933256844, 'VIC , 30 (TORROELLA)'), (81, 34, 57717482, 'ENRIC', 'RIDÓ GÓMEZ', '[email protected]', 936528779, 'SANT ISCLE , 6'), (82, 46, 439076513, 'MARTA', 'SANTAMARIA FLOTATS', '[email protected]', 931021886, 'JAUME BALMES , 70, 3R, 1A.'), (83, 1, 418598305, 'CARLA', 'HERMS GÓMEZ', '[email protected]', 936201457, 'GERMAN DURAN , 27, 3R., 1A.'), (84, 61, 124335191, 'MARIA NOELIA', 'ARTIGAS MATURANO', '[email protected]', 938207515, 'SANT JOAN , 11'), (85, 28, 319912861, 'CRISTINA', 'AGUILAR MASANA', '[email protected]', 938208558, 'PUIG , 1'),
(86, 48, 212963026, 'CARLOS', 'ALTIMIRAS SERAROLS', '[email protected]', 938300496, 'PROL. JACINT VERDAGUER , 1, 2N., 2A'), (87, 99, 882448888, 'DAVID', 'TORRESCASANA GARCIA', '[email protected]', 930120545, 'RAMON I CAJAL , 81, 2N.'), (88, 68, 653588337, 'CRISTIAN', 'ARIZA PUIGBÓ', '[email protected]', 938207095, 'MORAGUES , 10'), (89, 83, 830674467, 'JULIO ALBERTO', 'ALVAREZ ARMENTEROS', 'dolç[email protected]', 938300214, 'PROL. PADRÓ , 1, 3R., 2A.'), (90, 59, 346357578, 'SERGI', 'BARALDÉS TARRAGÓ', '[email protected]', 938727244, 'FRANCESC DE VITÒRIA , 11, 4T 2A'), (91, 14, 412658813, 'ALEIX', 'GARCIA GARCÍA', '[email protected]', 936565874, 'ALBÉNIZ , 22, 2N.'), (92, 18, 135861677, 'VERÒNICA', 'AROCA GÓMEZ', '[email protected]', 938205782, 'TRES ROURES , 10, 4T 2A'), (93, 27, 489230178, 'MARIONA', 'ALONSO RODRIGUEZ', '[email protected]', 938305551, 'PROL. PADRÓ , 1, 2N., 1A.'), (94, 35, 347983089, 'MARC', 'CANO GÓMEZ', '[email protected]', 936577225, 'ALBÉNIZ , 13, 2N., 1A.'), (95, 41, 6241587, 'GEMMA', 'ALCAIDE MOLINA', '[email protected]', 938773647, 'FONT DEL GAT , 1'), (96, 92, 432279892, 'RICARD', 'AGUILERA PRAT', '[email protected]', 938208054, 'MONTCAU , 1'), (97, 3, 475015534, 'JUAN', 'ALAPONT ICART', '[email protected]', 938208054, 'MONTURIOL , 1'), (98, 11, 244195117, 'MARTA', 'RIVERO FLORIDO', '[email protected]', 930712563, 'VILATORRADA , 6'), (99, 98, 856483470, 'NATÀLIA', 'AVILA MASJUAN', '[email protected]', 938204078, 'JAUME GALOBART , 11'), (100, 49, 491185461, 'MARTA', 'GRANADOS ANDRÉS', '[email protected]', 936871045, 'SANT GENÍS , 25');
-- -- Estructura de tabla para la tabla tbl_detalle_movimiento --
