Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- SQLyog Ultimate v8.71
- MySQL - 5.6.37-log : Database - etracs254_bukidnon
- *********************************************************************
- */
- /*!40101 SET NAMES utf8 */;
- /*!40101 SET SQL_MODE=''*/;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- /*Table structure for table `material` */
- DROP TABLE IF EXISTS `material`;
- CREATE TABLE `material` (
- `objid` VARCHAR(50) NOT NULL,
- `state` VARCHAR(10) NOT NULL,
- `code` VARCHAR(20) NOT NULL,
- `name` varchar(100) NOT NULL,
- PRIMARY KEY (`objid`),
- UNIQUE KEY `ux_material_code` (`code`),
- UNIQUE KEY `ux_material_name` (`name`),
- KEY `ix_material_state` (`state`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*Data for the table `material` */
- 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');
- /*Table structure for table `structure` */
- DROP TABLE IF EXISTS `structure`;
- CREATE TABLE `structure` (
- `objid` varchar(50) NOT NULL,
- `state` varchar(10) NOT NULL,
- `code` varchar(20) NOT NULL,
- `name` varchar(100) NOT NULL,
- `indexno` int(11) NOT NULL,
- `showinfaas` int(11) NOT NULL,
- PRIMARY KEY (`objid`),
- UNIQUE KEY `ux_structure_code` (`code`),
- UNIQUE KEY `ux_structure_name` (`name`),
- KEY `ix_structure_state` (`state`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*Data for the table `structure` */
- 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);
- /*Table structure for table `structurematerial` */
- DROP TABLE IF EXISTS `structurematerial`;
- CREATE TABLE `structurematerial` (
- `structure_objid` varchar(50) NOT NULL,
- `material_objid` varchar(50) NOT NULL,
- `display` int(11) DEFAULT NULL,
- `idx` int(11) DEFAULT NULL,
- PRIMARY KEY (`structure_objid`,`material_objid`),
- KEY `FK_structurematerial_material` (`material_objid`),
- CONSTRAINT `structurematerial_ibfk_1` FOREIGN KEY (`material_objid`) REFERENCES `material` (`objid`),
- CONSTRAINT `structurematerial_ibfk_2` FOREIGN KEY (`structure_objid`) REFERENCES `structure` (`objid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*Data for the table `structurematerial` */
- 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);
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement