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