`InvID` int(11) NOT NULL auto_increment,
`InvNo` varchar(10) NOT NULL default '',
`Date` date NOT NULL default '0000-00-00',
`Seller` varchar(120) NOT NULL default '',
`CustCompany` varchar(255) NOT NULL default '',
`CustAddr` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
.
.
ข้อมูลระหว่างนี้ใส่เพิ่มเติมเองนะค่ะ
.
`Remarks` text character set utf8 collate utf8_unicode_ci NOT NULL,
`Status` char(1) NOT NULL default '' ,
`Creator` varchar(120) NOT NULL default '',
`Cdate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`QID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `InvoiceDetail` (
`QDid` int(11) NOT NULL auto_increment,
`InvID` varchar(14) NOT NULL default '',
`PType` varchar(2) NOT NULL default '',
`Detail` varchar(255) NOT NULL default '',
`Brand` varchar(255) NOT NULL default '',
`Piece` int(11) NOT NULL default '0',
`Price` float NOT NULL default '0',
`Remark` text character set utf8 collate utf8_unicode_ci,
PRIMARY KEY (`QDid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Load balance : Server 02
