1--List of parcels details related to an expedition
2create table llx_expedition_package
3(
4  rowid             integer AUTO_INCREMENT PRIMARY KEY,
5  fk_expedition     integer NOT NULL,
6  description       varchar(255),    --Description of goods in the package (required by the custom)
7  value             double(24,8)     DEFAULT 0,--Value (Price of the content, for insurance & custom)
8  fk_package_type    integer,           -- Type or package, linked to llx_c_shipment_parcel_type (eg: 1=enveloppe, 2=package, 3=palette, 4=other)
9  height            float,	       -- height
10  width             float,	       -- width
11  size              float,	       -- depth
12  size_units        integer,	       -- unit of all sizes (height, width, depth)
13  weight            float,	       -- weight
14  weight_units      integer,	       -- unit of weight
15  dangerous_goods   smallint          DEFAULT 0, -- 0 = no dangerous goods or 1 = Explosives, 2 = Flammable Gases, 3 = Flammable Liquids, 4 = Flammable solids, 5 = Oxidizing, 6 = Toxic & Infectious, 7 = Radioactive, 8 = Corrosives, 9 = Miscellaneous (see https://en.wikipedia.org/wiki/Dangerous_goods). I'm not sure if just register 0 (no) or 1 (yes) is enough.
16  tail_lift         smallint          DEFAULT 0, -- 0 = no tail lift required to load/unload package(s), 1 = a tail lift is required to load/unload package(s). Sometime tail lift load can be different than tail lift delivery so maybe adding a new table line.
17  rang              integer  DEFAULT 0
18)ENGINE=innodb;
19