· 10 years ago · Sep 08, 2016, 10:34 AM
1
2
3CREATE TABLE IF NOT EXISTS `jari` (
4 `id` int(11) NOT NULL AUTO_INCREMENT,
5 `ipFinger` varchar(40) NOT NULL,
6 `pin` int(11) NOT NULL,
7 `jarike` int(11) NOT NULL,
8 `size` int(11) NOT NULL,
9 `valid` int(11) NOT NULL,
10 `jari` text NOT NULL,
11 `tanda` int(11) NOT NULL,
12 `upload` int(11) NOT NULL,
13 `timeget` datetime NOT NULL,
14 `timeup` datetime NOT NULL,
15 PRIMARY KEY (`id`),
16 KEY `pin` (`pin`,`jarike`)
17) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;