/
custdata.table
29 lines (28 loc) · 1.12 KB
/
custdata.table
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
use is4c_op;
DROP TABLE IF EXISTS `custdata`;
CREATE TABLE `custdata` (
`CardNo` int(8) default NULL,
`personNum` tinyint(4) NOT NULL default '1',
`LastName` varchar(30) default NULL,
`FirstName` varchar(30) default NULL,
`CashBack` double NOT NULL default '60',
`Balance` double NOT NULL default '0',
`Discount` smallint(6) default NULL,
`MemDiscountLimit` double NOT NULL default '0',
`ChargeOk` tinyint(4) NOT NULL default '1',
`WriteChecks` tinyint(4) NOT NULL default '1',
`StoreCoupons` tinyint(4) NOT NULL default '1',
`Type` varchar(10) NOT NULL default 'pc',
`memType` tinyint(4) default NULL,
`staff` tinyint(4) NOT NULL default '0',
`SSI` tinyint(4) NOT NULL default '0',
`Purchases` double NOT NULL default '0',
`NumberOfChecks` smallint(6) NOT NULL default '0',
`memCoupons` int(11) NOT NULL default '1',
`blueLine` varchar(50) default NULL,
`Shown` tinyint(4) NOT NULL default '1',
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`),
KEY `CardNo` (`CardNo`),
KEY `LastName` (`LastName`)
) ENGINE=MyISAM AUTO_INCREMENT=926 DEFAULT CHARSET=latin1;