Advertisement
pjesbert

structureAndMaterialFixFINAL

Jun 20th, 2018
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.79 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. /*Table structure for table `material` */
  18.  
  19. DROP TABLE IF EXISTS `material`;
  20.  
  21. CREATE TABLE `material` (
  22. `objid` VARCHAR(50) NOT NULL,
  23. `state` VARCHAR(10) NOT NULL,
  24. `code` VARCHAR(20) NOT NULL,
  25. `name` varchar(100) NOT NULL,
  26. PRIMARY KEY (`objid`),
  27. UNIQUE KEY `ux_material_code` (`code`),
  28. UNIQUE KEY `ux_material_name` (`name`),
  29. KEY `ix_material_state` (`state`)
  30. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  31.  
  32. /*Data for the table `material` */
  33.  
  34. 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');
  35.  
  36. /*Table structure for table `structure` */
  37.  
  38. DROP TABLE IF EXISTS `structure`;
  39.  
  40. CREATE TABLE `structure` (
  41. `objid` varchar(50) NOT NULL,
  42. `state` varchar(10) NOT NULL,
  43. `code` varchar(20) NOT NULL,
  44. `name` varchar(100) NOT NULL,
  45. `indexno` int(11) NOT NULL,
  46. `showinfaas` int(11) NOT NULL,
  47. PRIMARY KEY (`objid`),
  48. UNIQUE KEY `ux_structure_code` (`code`),
  49. UNIQUE KEY `ux_structure_name` (`name`),
  50. KEY `ix_structure_state` (`state`)
  51. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  52.  
  53. /*Data for the table `structure` */
  54.  
  55. insert into `structure`(`objid`,`state`,`code`,`name`,`indexno`,`showinfaas`) values ('SP','DRAFT','SP','SWIMMING POOL',14,1),('ST-eeb5bee:131d50001c1:-7fd2','APPROVED','CE','CEILING',12,1),('ST-eeb5bee:131d50001c1:-7fdb','APPROVED','WA','WALL FINISH',11,1),('ST-eeb5bee:131d50001c1:-7fe0','APPROVED','PA','PARTITION',10,1),('ST-eeb5bee:131d50001c1:-7fe1','APPROVED','ST','STAIRS',9,1),('ST-eeb5bee:131d50001c1:-7fe4','APPROVED','WI','WINDOWS',8,1),('ST-eeb5bee:131d50001c1:-7fe9','APPROVED','DO','DOORS',7,1),('ST-eeb5bee:131d50001c1:-7ff2','APPROVED','FL','FLOORING',6,1),('ST-eeb5bee:131d50001c1:-7ff3','APPROVED','EX','EXTERIOR WALLS',5,1),('ST-eeb5bee:131d50001c1:-7ff4','APPROVED','RO','ROOF',4,1),('ST-eeb5bee:131d50001c1:-7ff5','APPROVED','TR','TRUSS',3,1),('ST-eeb5bee:131d50001c1:-7ff9','APPROVED','COL','COLUMNS',2,1),('ST-eeb5bee:131d50001c1:-7ffa','APPROVED','FOU','FOUNDATION',1,1),('ST5f61a30d:140e66b3f0e:-7f51','DRAFT','WAL','WALLING',13,1);
  56.  
  57. /*Table structure for table `structurematerial` */
  58.  
  59. DROP TABLE IF EXISTS `structurematerial`;
  60.  
  61. CREATE TABLE `structurematerial` (
  62. `structure_objid` varchar(50) NOT NULL,
  63. `material_objid` varchar(50) NOT NULL,
  64. `display` int(11) DEFAULT NULL,
  65. `idx` int(11) DEFAULT NULL,
  66. PRIMARY KEY (`structure_objid`,`material_objid`),
  67. KEY `FK_structurematerial_material` (`material_objid`),
  68. CONSTRAINT `structurematerial_ibfk_1` FOREIGN KEY (`material_objid`) REFERENCES `material` (`objid`),
  69. CONSTRAINT `structurematerial_ibfk_2` FOREIGN KEY (`structure_objid`) REFERENCES `structure` (`objid`)
  70. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  71.  
  72. /*Data for the table `structurematerial` */
  73.  
  74. 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,12),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fc7',1,11),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fc9',1,10),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fca',1,9),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fce',1,8),('ST-eeb5bee:131d50001c1:-7fd2','MAT-eeb5bee:131d50001c1:-7fd4',1,7),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7df5',1,6),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7dfc',1,5),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7e09',1,4),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7e0b',1,3),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7e1e',1,2),('ST-eeb5bee:131d50001c1:-7fd2','MAT28c943e4:131d0b6a0af:-7e20',1,13),('ST-eeb5bee:131d50001c1:-7fdb','MAT-eeb5bee:131d50001c1:-7f87',0,1),('ST-eeb5bee:131d50001c1:-7fdb','MAT-eeb5bee:131d50001c1:-7fa0',1,2),('ST-eeb5bee:131d50001c1:-7fdb','MAT-eeb5bee:131d50001c1:-7faa',1,3),('ST-eeb5bee:131d50001c1:-7fdb','MAT-eeb5bee:131d50001c1:-7fb0',1,4),('ST-eeb5bee:131d50001c1:-7fdb','MAT28c943e4:131d0b6a0af:-7e07',1,5),('ST-eeb5bee:131d50001c1:-7fdb','MAT28c943e4:131d0b6a0af:-7e1d',1,6),('ST-eeb5bee:131d50001c1:-7fdb','MAT28c943e4:131d0b6a0af:-7e1e',1,7),('ST-eeb5bee:131d50001c1:-7fdb','MAT28c943e4:131d0b6a0af:-7e20',1,8),('ST-eeb5bee:131d50001c1:-7fe0','MAT-eeb5bee:131d50001c1:-7f87',1,1),('ST-eeb5bee:131d50001c1:-7fe0','MAT-eeb5bee:131d50001c1:-7fa0',1,9),('ST-eeb5bee:131d50001c1:-7fe0','MAT-eeb5bee:131d50001c1:-7fc4',1,8),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7dfc',1,7),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e03',1,6),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e06',1,5),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e09',1,4),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e0b',1,3),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e1e',1,2),('ST-eeb5bee:131d50001c1:-7fe0','MAT28c943e4:131d0b6a0af:-7e20',1,10),('ST-eeb5bee:131d50001c1:-7fe1','MAT28c943e4:131d0b6a0af:-7dfc',1,1),('ST-eeb5bee:131d50001c1:-7fe1','MAT28c943e4:131d0b6a0af:-7e1e',1,2),('ST-eeb5bee:131d50001c1:-7fe1','MAT28c943e4:131d0b6a0af:-7e20',1,3),('ST-eeb5bee:131d50001c1:-7fe4','MAT-eeb5bee:131d50001c1:-7fc9',0,1),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7df5',1,2),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7dfe',1,3),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e01',1,4),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e07',1,5),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e09',1,6),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e0b',1,7),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e18',1,8),('ST-eeb5bee:131d50001c1:-7fe4','MAT28c943e4:131d0b6a0af:-7e1e',1,9),('ST-eeb5bee:131d50001c1:-7fe9','MAT-eeb5bee:131d50001c1:-7fb3',0,1),('ST-eeb5bee:131d50001c1:-7fe9','MAT-eeb5bee:131d50001c1:-7fca',1,2),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7df1',1,3),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7df5',1,4),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7dfc',1,5),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7e06',1,6),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7e19',1,7),('ST-eeb5bee:131d50001c1:-7fe9','MAT28c943e4:131d0b6a0af:-7e1e',1,8),('ST-eeb5bee:131d50001c1:-7ff2','MAT-eeb5bee:131d50001c1:-7fad',1,1),('ST-eeb5bee:131d50001c1:-7ff2','MAT-eeb5bee:131d50001c1:-7fae',1,2),('ST-eeb5bee:131d50001c1:-7ff2','MAT-eeb5bee:131d50001c1:-7fb0',1,3),('ST-eeb5bee:131d50001c1:-7ff2','MAT28c943e4:131d0b6a0af:-7df1',1,4),('ST-eeb5bee:131d50001c1:-7ff2','MAT28c943e4:131d0b6a0af:-7e1d',1,5),('ST-eeb5bee:131d50001c1:-7ff2','MAT28c943e4:131d0b6a0af:-7e1e',1,6),('ST-eeb5bee:131d50001c1:-7ff2','MAT28c943e4:131d0b6a0af:-7e20',1,7),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7f87',1,1),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fa0',1,10),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fb3',1,9),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fc7',1,8),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fc9',1,7),('ST-eeb5bee:131d50001c1:-7ff3','MAT-eeb5bee:131d50001c1:-7fca',1,6),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7df1',1,5),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7df5',1,4),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7dfc',1,3),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7e1e',1,2),('ST-eeb5bee:131d50001c1:-7ff3','MAT28c943e4:131d0b6a0af:-7e20',1,11),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7f8a',1,1),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7f8d',1,11),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7f96',1,10),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7f99',1,9),('ST-eeb5bee:131d50001c1:-7ff4','MAT-eeb5bee:131d50001c1:-7fbe',1,8),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7df1',1,7),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7df9',1,6),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e07',1,5),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e16',1,4),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e18',1,3),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e1d',1,2),('ST-eeb5bee:131d50001c1:-7ff4','MAT28c943e4:131d0b6a0af:-7e20',1,12),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7df1',1,1),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7df5',1,2),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7df7',1,3),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7dfc',1,4),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7e1e',1,5),('ST-eeb5bee:131d50001c1:-7ff5','MAT28c943e4:131d0b6a0af:-7e20',1,6),('ST-eeb5bee:131d50001c1:-7ff9','MAT-eeb5bee:131d50001c1:-7fc7',1,1),('ST-eeb5bee:131d50001c1:-7ff9','MAT28c943e4:131d0b6a0af:-7df1',1,2),('ST-eeb5bee:131d50001c1:-7ff9','MAT28c943e4:131d0b6a0af:-7dfc',1,3),('ST-eeb5bee:131d50001c1:-7ff9','MAT28c943e4:131d0b6a0af:-7e1e',1,4),('ST-eeb5bee:131d50001c1:-7ff9','MAT28c943e4:131d0b6a0af:-7e20',1,5),('ST-eeb5bee:131d50001c1:-7ffa','MAT-eeb5bee:131d50001c1:-7fa5',1,1),('ST-eeb5bee:131d50001c1:-7ffa','MAT28c943e4:131d0b6a0af:-7e20',1,2);
  75.  
  76. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  77. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  78. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  79. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement