CREATE TABLE RefundFT003 
(
          id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
          LockId CHAR(32) DEFAULT NULL,
          Operation ENUM( "Credit", "Bill" ) NOT NULL,
          Status ENUM( "QUEUE", "WORK", "DONE", "FAILED" ) DEFAULT "QUEUE",

          MonthlyBill BIGINT UNSIGNED NOT NULL,
          Customer BIGINT UNSIGNED NOT NULL,
          Quantity SMALLINT NOT NULL,
          Price DECIMAL( 10,2 ) NOT NULL,
          Item BIGINT UNSIGNED NOT NULL,

          UNIQUE( Customer, Operation ),
          KEY( MonthlyBill ),
          KEY( LockId )

) ;
