CREATE TABLE `stock_warehouse` (
`warehouse_id` INT(11) NOT NULL DEFAULT '0',
`warehouse_name` VARCHAR(150) DEFAULT NULL,
`warehouse_officer_po_name` VARCHAR(250) DEFAULT NULL,
`warehouse_officer_po_position` VARCHAR(200) DEFAULT NULL,
`warehouse_officer_director_name` VARCHAR(150) DEFAULT NULL,
`warehouse_officer_director_position` VARCHAR(150) DEFAULT NULL,
`warehouse_officer_chairman_name` VARCHAR(150) DEFAULT NULL,
`warehouse_officer_chairman_position` VARCHAR(150) DEFAULT NULL,
`warehouse_officer_board_name1` VARCHAR(150) DEFAULT NULL,
`warehouse_officer_board_position1` VARCHAR(150) DEFAULT NULL,
`warehouse_officer_board_name2` VARCHAR(150) DEFAULT NULL,
`warehouse_officer_board_position2` VARCHAR(150) DEFAULT NULL,
`oldcode` VARCHAR(20) DEFAULT NULL,
`hos_guid` VARCHAR(38) DEFAULT NULL,
`warehouse_responsible_officer` VARCHAR(200) DEFAULT NULL,
`warehouse_location` VARCHAR(250) DEFAULT NULL,
`warehouse_active` CHAR(1) DEFAULT NULL,
`warehouse_code` VARCHAR(10) DEFAULT NULL,
PRIMARY KEY (`warehouse_id`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620