end task w/ db create statement

CREATE TABLE `pm_inventory_stock_adjustment` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `reason` varchar(500) NOT NULL,
  `datetime`
varchar(45) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '2',

`created_by` int(11) NOT NULL,
  `approved_by` int(11) NOT NULL,

PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT
CHARSET=latin1;
CREATE TABLE `pm_inventory_stock_adjustment_detail` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`fk_inventory_stock_adjustment_id` int(11) NOT NULL,

`fk_inventory_product_id` varchar(45) NOT NULL,
  `quantity` int(11) NOT
NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53
DEFAULT CHARSET=latin1;
CREATE TABLE `pm_accounting_credit_memo` (

`id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_sales_customer_id` int(11)
NOT NULL,
  `datetime` varchar(45) NOT NULL,
  `purpose` varchar(100)
NOT NULL,
  `amount` float NOT NULL DEFAULT '0',
  `description` text
NOT NULL,
  `status` int(2) NOT NULL DEFAULT '2',
  `created_by` int(11)
NOT NULL,
  `approved_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;