Nadir,
The archive engine is not a supported storage engine in Infobright and cannot be added. Although one can issue DDL referencing the archive engine type and it will execute without an error, it will create the table and issue warnings. Review the following session information:
mysql> use test
Database changed
mysql> create table archie(col1 integer, col2 char(1)) engine=archive;
Query OK, 0 rows affected, 2 warnings (0.09 sec)
mysql> show warnings;
+---------+------+-----------------------------------------------------+
| Level | Code | Message |
+---------+------+-----------------------------------------------------+
| Warning | 1286 | Unknown table engine 'archive' |
| Warning | 1266 | Using storage engine BRIGHTHOUSE for table 'archie' |
+---------+------+-----------------------------------------------------+
2 rows in set (0.00 sec)
mysql> show table status;
+----------------+-------------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+----------------------------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+----------------+-------------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+----------------------------------+
| archie | BRIGHTHOUSE | 10 | Compressed | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2010-02-08 12:18:48 | 2010-02-08 12:18:48 | NULL | latin1_swedish_ci | NULL | | Overall compression ratio: 0.000 |
+----------------+-------------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+----------------------------------+
1 row in set (0.00 sec)
