gistfile1.txt

create table new_products_stock_adjustments (
  products_stock_adjustments_id int(12) auto_increment,
  products_id int(12) default 0,
  purchases_id int(12) default 0,
  assemblies_runs_id int(12) default 0,
  batch_id int(12) default 0,
  orders_id int(12) default 0,
  admin_users_id int(12) default 0,
  customers_id int(12) default 0,
  adjustment_amount int(12) default 0,
  adjustment_date datetime default '0000-00-00 00:00:00',
  adjustment_notes text default '',
  adjustment_amount_physical int(12) default 0,
  new_physical_quantity int(12) default 0,
  quantity_on_orders int(12) default 0,
  unit_flat_cost decimal(15,5) default 0.00000,
  unit_full_cost decimal(15,5) default 0.00000,
  new_average_full_cost decimal(15,5) default 0.00000,
  new_average_flat_cost decimal(15,5) default 0.00000,
  method set('automatic','manual','transfer') default 'automatic',
  burn tinyint(1) default 1,
  primary key (products_stock_adjustments_id)
);