CREATE TABLE assets (
id int(11) not null AUTO_INCREMENT PRIMARY KEY,
asset_name varchar(256) not null,
asset_number varchar(256) not null,
asset_class varchar(256) null,
location varchar(256) null,
date_acquired varchar(256) null,
date_asset_btu varchar(256) null,
unit varchar(256) null,
unit_cost varchar(256) null,
cost_inc_vat varchar(256) null,
initial_rec varchar(256) null,
disposal varchar(256) null,
total_cost varchar(256) null,
useful_life varchar(256) null,
life_m varchar(256) null,
dep_per varchar(256) null,
val_date varchar(256) null,
total_dep varchar(256) null,
acc_dep varchar(256) null,
asset_cost varchar(256) null,
nbv varchar(256) null
);