pjesbert

structureAndMaterialFix

Jun 19th, 2018
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.78 KB | None | 0 0
  1. /*
  2. SQLyog Ultimate v8.71
  3. MySQL - 5.6.37-log : Database - etracs254_bukidnon
  4. *********************************************************************
  5. */
  6.  
  7.  
  8. /*!40101 SET NAMES utf8 */;
  9.  
  10. /*!40101 SET SQL_MODE=''*/;
  11.  
  12. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16.  
  17.  
  18. /*Table structure for table `material` */
  19.  
  20. DROP TABLE IF EXISTS `material`;
  21.  
  22. CREATE TABLE `material` (
  23. `objid` VARCHAR(50) NOT NULL,
  24. `state` VARCHAR(10) NOT NULL,
  25. `code` VARCHAR(20) NOT NULL,
  26. `name` VARCHAR(100) NOT NULL,
  27. PRIMARY KEY (`objid`),
  28. UNIQUE KEY `ux_material_code` (`code`),
  29. UNIQUE KEY `ux_material_name` (`name`),
  30. KEY `ix_material_state` (`state`)
  31. ) ENGINE=INNODB DEFAULT CHARSET=utf8;
  32.  
  33. /*Data for the table `material` */
  34.  
  35. INSERT INTO `material`(`objid`,`state`,`code`,`name`) VALUES ('MA','APPROVED','MA','MARBLE'),('MAT-1df4f91e:142e96d3956:-7f1f','DRAFT','CS','CONCRETE SLAB'),('MAT-4824ce7b:145c9d7f664:-7d30','DRAFT','GFW','GLASS (FRENCH WINDOW (WOOD FRAME)'),('MAT-4824ce7b:145c9d7f664:-7d32','DRAFT','GFWS','GLASS (FRENCH WINDOW W/ STEEL FRAME)'),('MAT-692aa082:13fcb5753a8:-7f0c','DRAFT','TS','TALISAYAN'),('MAT-699b37ce:1432c6076cc:-7e4d','DRAFT','CHB&W','CONCRETE HALLOW BLOCKS & WOOD'),('MAT-6d09e1d2:147d1f2ea6c:-7ede','APPROVED','GFJ','GLASS (FRENCH WINDOW W/ STEEL FRAME & JELOUSY)'),('MAT-6d09e1d2:147d1f2ea6c:-7ee2','DRAFT','CHBFP','CHB W/ FINISHING & PAINT'),('MAT-6d09e1d2:147d1f2ea6c:-7ee3','DRAFT','CHBF','CHB W/ FINISHING'),('MAT-eeb5bee:131d50001c1:-7f87','APPROVED','PLA','PLASTIC SCREEN'),('MAT-eeb5bee:131d50001c1:-7f8a','APPROVED','CO','COGON GRASS'),('MAT-eeb5bee:131d50001c1:-7f8d','APPROVED','AL','ALUMINUM SHEETS'),('MAT-eeb5bee:131d50001c1:-7f96','APPROVED','PO','POLYCARBONATE SHEETS'),('MAT-eeb5bee:131d50001c1:-7f99','DRAFT','RU','RUBBERIZED CELLOPHANE'),('MAT-eeb5bee:131d50001c1:-7fa0','APPROVED','CHB','CONCRETE HOLLOW BLOCK'),('MAT-eeb5bee:131d50001c1:-7fa5','DRAFT','PI','PILES'),('MAT-eeb5bee:131d50001c1:-7fa7','DRAFT','SS','STAINLESS STEEL'),('MAT-eeb5bee:131d50001c1:-7faa','APPROVED','BR','BRICKS'),('MAT-eeb5bee:131d50001c1:-7fad','DRAFT','VI','VINYL'),('MAT-eeb5bee:131d50001c1:-7fae','DRAFT','MS','MARBLE SLABS'),('MAT-eeb5bee:131d50001c1:-7fb0','DRAFT','GR','GRANITE'),('MAT-eeb5bee:131d50001c1:-7fb3','APPROVED','PL','PLASTIC'),('MAT-eeb5bee:131d50001c1:-7fbe','APPROVED','AS','ASBESTOUS'),('MAT-eeb5bee:131d50001c1:-7fc0','APPROVED','AC','ACOUSTIC BOARD'),('MAT-eeb5bee:131d50001c1:-7fc1','DRAFT','STE','STEEL PLATE'),('MAT-eeb5bee:131d50001c1:-7fc4','DRAFT','IN','INTERLINK'),('MAT-eeb5bee:131d50001c1:-7fc7','DRAFT','PR','PRE FABRICATED'),('MAT-eeb5bee:131d50001c1:-7fc9','APPROVED','HA','HARDIFLEX'),('MAT-eeb5bee:131d50001c1:-7fca','APPROVED','LA','LAWANIT'),('MAT-eeb5bee:131d50001c1:-7fce','DRAFT','SP','SPECIAL FINISHED'),('MAT-eeb5bee:131d50001c1:-7fd4','DRAFT','LU','LUMINOUS'),('MAT1311424e:142d9fade5c:-7918','DRAFT','BC','BAMBO & CHB'),('MAT28c943e4:131d0b6a0af:-7df1','APPROVED','BAM','BAMBOO'),('MAT28c943e4:131d0b6a0af:-7df5','APPROVED','ALU','ALUMINUM'),('MAT28c943e4:131d0b6a0af:-7df7','APPROVED','CL','COCO LUMBER'),('MAT28c943e4:131d0b6a0af:-7df9','APPROVED','CR','COLOR ROOF'),('MAT28c943e4:131d0b6a0af:-7dfc','APPROVED','ST','STEEL'),('MAT28c943e4:131d0b6a0af:-7dfe','APPROVED','GJ','GLASS JALOUSY'),('MAT28c943e4:131d0b6a0af:-7e01','DRAFT','WJ','WOODEN JALOUSY'),('MAT28c943e4:131d0b6a0af:-7e03','APPROVED','GB','GLASS BLOCKS'),('MAT28c943e4:131d0b6a0af:-7e06','DRAFT','GP','GLASS PANEL'),('MAT28c943e4:131d0b6a0af:-7e07','DRAFT','GL','GLASS'),('MAT28c943e4:131d0b6a0af:-7e09','APPROVED','PB','PLYBOARD'),('MAT28c943e4:131d0b6a0af:-7e0b','APPROVED','PW','PLYWOOD'),('MAT28c943e4:131d0b6a0af:-7e16','APPROVED','NI','NIPA'),('MAT28c943e4:131d0b6a0af:-7e18','APPROVED','GI','GALVANIZED IRON'),('MAT28c943e4:131d0b6a0af:-7e19','DRAFT','FL','FLASH DOOR'),('MAT28c943e4:131d0b6a0af:-7e1d','DRAFT','TI','TILES'),('MAT28c943e4:131d0b6a0af:-7e1e','DRAFT','WD','WOOD'),('MAT28c943e4:131d0b6a0af:-7e20','APPROVED','RC','REINFORCED CONCRETE'),('MAT2f7635b1:143d11ee743:-7c41','DRAFT','RUP','ROLL-UP'),('MAT2f7635b1:143d11ee743:-7c97','DRAFT','MT','MARBLE TILES'),('MAT4024174a:14722ed4c6f:-7f3f','DRAFT','TB','TILE BRICKS'),('MAT51aea6a3:1480fcf585a:-7fc1','DRAFT','GS','GLASS (SLIDING)'),('MAT56ab7fee:137781d2873:-749d','DRAFT','ERT','EARTH'),('MAT56ab7fee:137781d2873:-74a0','APPROVED','CEM','CEMENT'),('MAT5f61a30d:140e66b3f0e:-7f38','DRAFT','T&C','TILES & CEMENT'),('MAT5f61a30d:140e66b3f0e:-7f52','DRAFT','W&C','WOOD & CONCRETE'),('MAT5f61a30d:140e66b3f0e:-7f79','APPROVED','CON','CONCRETE'),('MAT5f61a30d:140e66b3f0e:-7fbb','DRAFT','PC','PLAIN CEMENT'),('MAT63f9622c:14935608391:-7fdb','DRAFT','RUD','ROLL UP DOOR'),('MAT6b3f0a71:143bca6c1f8:-7fb4','DRAFT','C&W','CEMENT & WOOD'),('MAT7fa8ef5d:13e1f9043b3:-7b85','APPROVED','AT','ATTIC'),('MAT9cf92bf:144f6b168f1:-7ea9','DRAFT','PW&CHB','PLYWOOD, WOOD & CHB');
  36.  
  37. /*Table structure for table `structure` */
  38.  
  39. DROP TABLE IF EXISTS `structure`;
  40.  
  41. CREATE TABLE `structure` (
  42. `objid` VARCHAR(50) NOT NULL,
  43. `state` VARCHAR(10) NOT NULL,
  44. `code` VARCHAR(20) NOT NULL,
  45. `name` VARCHAR(100) NOT NULL,
  46. `indexno` INT(11) NOT NULL,
  47. `showinfaas` INT(11) NOT NULL,
  48. PRIMARY KEY (`objid`),
  49. UNIQUE KEY `ux_structure_code` (`code`),
  50. UNIQUE KEY `ux_structure_name` (`name`),
  51. KEY `ix_structure_state` (`state`)
  52. ) ENGINE=INNODB DEFAULT CHARSET=utf8;
  53.  
  54. /*Data for the table `structure` */
  55.  
  56. INSERT INTO `structure`(`objid`,`state`,`code`,`name`,`indexno`,`showinfaas`) VALUES ('SP','DRAFT','SP','SWIMMING POOL',1,1),('ST-eeb5bee:131d50001c1:-7fd2','APPROVED','CE','CEILING',1,1),('ST-eeb5bee:131d50001c1:-7fdb','APPROVED','WA','WALL FINISH',1,1),('ST-eeb5bee:131d50001c1:-7fe0','APPROVED','PA','PARTITION',1,1),('ST-eeb5bee:131d50001c1:-7fe1','APPROVED','ST','STAIRS',1,1),('ST-eeb5bee:131d50001c1:-7fe4','APPROVED','WI','WINDOWS',1,1),('ST-eeb5bee:131d50001c1:-7fe9','APPROVED','DO','DOORS',1,1),('ST-eeb5bee:131d50001c1:-7ff2','APPROVED','FL','FLOORING',1,1),('ST-eeb5bee:131d50001c1:-7ff3','APPROVED','EX','EXTERIOR WALLS',1,1),('ST-eeb5bee:131d50001c1:-7ff4','APPROVED','RO','ROOF',1,1),('ST-eeb5bee:131d50001c1:-7ff5','APPROVED','TR','TRUSS',1,1),('ST-eeb5bee:131d50001c1:-7ff9','APPROVED','COL','COLUMNS',1,1),('ST-eeb5bee:131d50001c1:-7ffa','APPROVED','FOU','FOUNDATION',1,1),('ST5f61a30d:140e66b3f0e:-7f51','DRAFT','WAL','WALLING',1,1);
  57.  
  58. /*Table structure for table `structurematerial` */
  59.  
  60. DROP TABLE IF EXISTS `structurematerial`;
  61.  
  62. CREATE TABLE `structurematerial` (
  63. `structure_objid` VARCHAR(50) NOT NULL,
  64. `material_objid` VARCHAR(50) NOT NULL,
  65. `display` INT(11) DEFAULT NULL,
  66. `idx` INT(11) DEFAULT NULL,
  67. PRIMARY KEY (`structure_objid`,`material_objid`),
  68. KEY `FK_structurematerial_material` (`material_objid`),
  69. CONSTRAINT `structurematerial_ibfk_1` FOREIGN KEY (`material_objid`) REFERENCES `material` (`objid`),
  70. CONSTRAINT `structurematerial_ibfk_2` FOREIGN KEY (`structure_objid`) REFERENCES `structure` (`objid`)
  71. ) ENGINE=INNODB DEFAULT CHARSET=utf8;
  72.  
  73. /*Data for the table `structurematerial` */
  74.  
  75. INSERT INTO `structurematerial`(`structure_objid`,`material_objid`,`display`,`idx`) VALUES ('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fa7',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fc0',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fc7',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fc9',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fca',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fce',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fd4',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7df5',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7dfc',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7e09',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7e0b',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7e20',1,1),('ST-eeb5bee:131d50001c1:-7fdb','MAT-eeb5bee:131d50001c1:-7f87',1,1),('ST-eeb5bee:131d50001c1:-7fdb','MAT-eeb5bee:131d50001c1:-7fa0',1,1),('ST-eeb5bee:131d50001c1:-7fdb','MAT-eeb5bee:131d50001c1:-7faa',1,1),('ST-eeb5bee:131d50001c1:-7fdb','MAT-eeb5bee:131d50001c1:-7fb0',1,1),('ST-eeb5bee:131d50001c1:-7fdb','MAT28c943e4:131d0b6a0af:-7e07',1,1),('ST-eeb5bee:131d50001c1:-7fdb','MAT28c943e4:131d0b6a0af:-7e1d',1,1),('ST-eeb5bee:131d50001c1:-7fdb','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7fdb','MAT28c943e4:131d0b6a0af:-7e20',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT-eeb5bee:131d50001c1:-7f87',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT-eeb5bee:131d50001c1:-7fa0',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT-eeb5bee:131d50001c1:-7fc4',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7dfc',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e03',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e06',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e09',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e0b',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e20',1,1),('ST-eeb5bee:131d50001c1:-7fe1','MAT28c943e4:131d0b6a0af:-7dfc',1,1),('ST-eeb5bee:131d50001c1:-7fe1','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7fe1','MAT28c943e4:131d0b6a0af:-7e20',1,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT-eeb5bee:131d50001c1:-7fc9',1,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7df5',1,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7dfe',1,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e01',1,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e07',1,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e09',1,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e0b',1,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e18',1,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7fe9','MAT-eeb5bee:131d50001c1:-7fb3',1,1),('ST-eeb5bee:131d50001c1:-7fe9','MAT-eeb5bee:131d50001c1:-7fca',1,1),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7df1',1,1),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7df5',1,1),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7dfc',1,1),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7e06',1,1),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7e19',1,1),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7ff2','MAT-eeb5bee:131d50001c1:-7fad',1,1),('ST-eeb5bee:131d50001c1:-7ff2','MAT-eeb5bee:131d50001c1:-7fae',1,1),('ST-eeb5bee:131d50001c1:-7ff2','MAT-eeb5bee:131d50001c1:-7fb0',1,1),('ST-eeb5bee:131d50001c1:-7ff2','MAT28c943e4:131d0b6a0af:-7df1',1,1),('ST-eeb5bee:131d50001c1:-7ff2','MAT28c943e4:131d0b6a0af:-7e1d',1,1),('ST-eeb5bee:131d50001c1:-7ff2','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7ff2','MAT28c943e4:131d0b6a0af:-7e20',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7f87',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fa0',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fb3',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fc7',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fc9',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fca',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7df1',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7df5',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7dfc',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7e20',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7f8a',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7f8d',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7f96',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7f99',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7fbe',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7df1',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7df9',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e07',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e16',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e18',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e1d',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e20',1,1),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7df1',1,1),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7df5',1,1),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7df7',1,1),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7dfc',1,1),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7e20',1,1),('ST-eeb5bee:131d50001c1:-7ff9','MAT-eeb5bee:131d50001c1:-7fc7',1,1),('ST-eeb5bee:131d50001c1:-7ff9','MAT28c943e4:131d0b6a0af:-7df1',1,1),('ST-eeb5bee:131d50001c1:-7ff9','MAT28c943e4:131d0b6a0af:-7dfc',1,1),('ST-eeb5bee:131d50001c1:-7ff9','MAT28c943e4:131d0b6a0af:-7e1e',1,1),('ST-eeb5bee:131d50001c1:-7ff9','MAT28c943e4:131d0b6a0af:-7e20',1,1),('ST-eeb5bee:131d50001c1:-7ffa','MAT-eeb5bee:131d50001c1:-7fa5',1,1),('ST-eeb5bee:131d50001c1:-7ffa','MAT28c943e4:131d0b6a0af:-7e20',1,1);
  76.  
  77. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  78. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  79. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  80. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Advertisement
Add Comment
Please, Sign In to add comment