CREATE TABLE `rx_operator` (
`vn` VARCHAR(13) NOT NULL DEFAULT '',
`lock_order` CHAR(1) DEFAULT NULL,
`login` VARCHAR(50) NOT NULL DEFAULT '',
`rx_time` TIME DEFAULT NULL,
`pay` CHAR(1) DEFAULT NULL,
`rx_print` CHAR(1) DEFAULT NULL,
`check_staff` VARCHAR(6) DEFAULT NULL,
`pay_staff` VARCHAR(6) DEFAULT NULL,
`print_count` INT(11) DEFAULT NULL,
`confirm_staff` VARCHAR(6) DEFAULT NULL,
`note` text,
PRIMARY KEY (`vn`,`login`),
KEY `login` (`login`),
KEY `vn` (`vn`)
)