daily pastebin goal
22%
SHARE
TWEET

Untitled

a guest Sep 13th, 2017 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --
  2. -- Estructura de tabla para la tabla `s_miscelaneos`
  3. --
  4.  
  5. CREATE TABLE `s_miscelaneos` (
  6.   `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'pk',
  7.   `id_familia` INT(11) NOT NULL COMMENT 'fk',
  8.   `codigo` VARCHAR(20) NOT NULL,
  9.   `nombre` VARCHAR(50) NOT NULL,
  10.   `id_unidad` INT(11) NOT NULL COMMENT 'fk',
  11.   PRIMARY KEY  (`id`)
  12. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
  13.  
  14. --
  15. -- Volcar la base de datos para la tabla `s_miscelaneos`
  16. --
  17.  
  18. INSERT INTO `s_miscelaneos` VALUES (8, 3, 'ESPU', 'Espuma Expansiva', 15);
  19. INSERT INTO `s_miscelaneos` VALUES (10, 8, 'PINR', 'Pintura Roja', 23);
  20. INSERT INTO `s_miscelaneos` VALUES (11, 8, 'PINA', 'Pintura Amarilla', 23);
  21. INSERT INTO `s_miscelaneos` VALUES (20, 4, 'ALAM', 'Alambre Fino', 22);
  22. INSERT INTO `s_miscelaneos` VALUES (15, 2, 'BASS', 'Base 10', 17);
  23. INSERT INTO `s_miscelaneos` VALUES (19, 7, 'TOR3', 'Tornillo 1/2 pulg', 18);
  24. INSERT INTO `s_miscelaneos` VALUES (18, 1, 'ADAP', 'Adaptador Tuerca 2 pulg', 18);
  25. INSERT INTO `s_miscelaneos` VALUES (21, 11, 'DISC', 'Disco PUB', 18);
  26. INSERT INTO `s_miscelaneos` VALUES (22, 5, 'MALL', 'Malla STG', 21);
  27. INSERT INTO `s_miscelaneos` VALUES (23, 9, 'TUB3', 'Tubo 1/2 pulg', 22);
  28. INSERT INTO `s_miscelaneos` VALUES (24, 10, 'TUER', 'Tuerca 1/2 pulg', 18);
  29. INSERT INTO `s_miscelaneos` VALUES (29, 9, 'TUB1', 'Tubo 1 pulg', 22);
  30. INSERT INTO `s_miscelaneos` VALUES (30, 7, 'TOR2', 'Tornillo 2 pulg', 18);
  31. INSERT INTO `s_miscelaneos` VALUES (31, 2, 'BAS2', 'Base 20', 17);
  32. INSERT INTO `s_miscelaneos` VALUES (32, 4, 'ALA2', 'Alambre Grueso', 22);
  33.  
  34.  
  35. -- --------------------------------------------------------
  36.  
  37. --
  38. -- Estructura de tabla para la tabla `s_list`
  39. --
  40.  
  41. CREATE TABLE `s_list` (
  42.   `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'pk',
  43.   `list_id` INT(11) NOT NULL,
  44.   `list_name` VARCHAR(25) NOT NULL,
  45.   `item_parent_id` VARCHAR(25) NOT NULL,
  46.   `item_order` INT(11) NOT NULL,
  47.   `item_value` VARCHAR(255) NOT NULL,
  48.   PRIMARY KEY  (`id`)
  49. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
  50.  
  51. --
  52. -- Volcar la base de datos para la tabla `s_list`
  53. --
  54.  
  55. INSERT INTO `s_list` VALUES (1, 10, 'Familia', '', 0, 'Adaptadores');
  56. INSERT INTO `s_list` VALUES (2, 10, 'Familia', '', 0, 'Bases');
  57. INSERT INTO `s_list` VALUES (3, 10, 'Familia', '', 0, 'Espumas');
  58. INSERT INTO `s_list` VALUES (4, 10, 'Familia', '', 0, 'Alambres');
  59. INSERT INTO `s_list` VALUES (5, 10, 'Familia', '', 0, 'Mallas');
  60. INSERT INTO `s_list` VALUES (6, 10, 'Familia', '', 0, 'Cables');
  61. INSERT INTO `s_list` VALUES (7, 10, 'Familia', '', 0, 'Tornillos');
  62. INSERT INTO `s_list` VALUES (8, 10, 'Familia', '', 0, 'Pinturas');
  63. INSERT INTO `s_list` VALUES (9, 10, 'Familia', '', 0, 'Tubos');
  64. INSERT INTO `s_list` VALUES (10, 10, 'Familia', '', 0, 'Tuercas');
  65. INSERT INTO `s_list` VALUES (11, 10, 'Familia', '', 0, 'Discos');
  66. INSERT INTO `s_list` VALUES (14, 30, 'Unidad', '', 0, 'PZA');
  67. INSERT INTO `s_list` VALUES (15, 30, 'Unidad', '', 0, 'POTE');
  68. INSERT INTO `s_list` VALUES (16, 30, 'Unidad', '', 0, 'KG');
  69. INSERT INTO `s_list` VALUES (17, 30, 'Unidad', '', 0, 'KGF');
  70. INSERT INTO `s_list` VALUES (18, 30, 'Unidad', '', 0, 'UND');
  71. INSERT INTO `s_list` VALUES (19, 30, 'Unidad', '', 0, 'SCO');
  72. INSERT INTO `s_list` VALUES (20, 30, 'Unidad', '', 0, 'M3');
  73. INSERT INTO `s_list` VALUES (21, 30, 'Unidad', '', 0, 'M2');
  74. INSERT INTO `s_list` VALUES (22, 30, 'Unidad', '', 0, 'M');
  75. INSERT INTO `s_list` VALUES (23, 30, 'Unidad', '', 0, 'GLN');
RAW Paste Data
Top