· 8 years ago · Jul 14, 2018, 11:04 PM
1DROP TABLE IF EXISTS `budget09`.`rsdetails`;
2CREATE TABLE `budget09`.`rsdetails` (
3 `id` int(9) NOT NULL AUTO_INCREMENT,
4 `rsid` int(9) NOT NULL,
5 `rspg` int(9) NOT NULL,
6 `budgetdetailsid` int(9) NOT NULL,
7 `remainingqty` int(9) NOT NULL,
8 `rs_q1qty` double(50,2) NOT NULL DEFAULT '0.00',
9 `rs_q1amt` double(50,2) NOT NULL DEFAULT '0.00',
10 `rs_q2qty` double(50,2) NOT NULL DEFAULT '0.00',
11 `rs_q2amt` double(50,2) NOT NULL DEFAULT '0.00',
12 `rs_q3qty` double(50,2) NOT NULL DEFAULT '0.00',
13 `rs_q3amt` double(50,2) NOT NULL DEFAULT '0.00',
14 `rs_q4qty` double(50,2) NOT NULL DEFAULT '0.00',
15 `rs_q4amt` double(50,2) NOT NULL DEFAULT '0.00',
16 PRIMARY KEY (`id`)
17) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;