bwpnL4Gp

1
2CREATE TABLE IF NOT EXISTS `procurement_items` (
3  `procurement_item_id` int(11) NOT NULL AUTO_INCREMENT,
4  `procurement_id` mediumint(9) NOT NULL,
5  `aip_no` varchar(150) CHARACTER SET latin1 NOT NULL,
6  `item_no` varchar(150) CHARACTER SET latin1 NOT NULL,
7  `pvms_id` mediumint(11) NOT NULL,
8  `previous_price` decimal(12,2) NOT NULL,
9  `probable_price` decimal(12,2) NOT NULL,
10  `quantity` smallint(6) NOT NULL,
11  `equipment_id` mediumint(9) NOT NULL,
12  PRIMARY KEY (`procurement_item_id`),
13  KEY `pvms_id` (`pvms_id`),
14  KEY `specification` (`equipment_id`),
15  KEY `procurement_id` (`procurement_id`)
16) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
17
18-- Added new table to DGMS --
19-- Md. Eftakhairul Islam Date: 11 May 2011 --
20
21CREATE TABLE `procurements` (
22`procurement_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
23`demand_no` VARCHAR( 200 ) NULL ,
24`currency` BOOLEAN NOT NULL ,
25`demand_date` DATE NOT NULL ,
26`to_e` BOOLEAN NOT NULL
27) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;