| ITEM  | CREATE TABLE `ITEM` (
  `I_ID` int(11) NOT NULL DEFAULT '0',
  `I_TITLE` varchar(60) DEFAULT NULL,
  `I_A_ID` int(11) DEFAULT NULL,
  `I_PUB_DATE` date DEFAULT NULL,
  `I_PUBLISHER` varchar(60) DEFAULT NULL,
  `I_SUBJECT` varchar(60) DEFAULT NULL,
  `I_DESC` blob,
  `I_RELATED1` int(11) DEFAULT NULL,
  `I_RELATED2` int(11) DEFAULT NULL,
  `I_RELATED3` int(11) DEFAULT NULL,
  `I_RELATED4` int(11) DEFAULT NULL,
  `I_RELATED5` int(11) DEFAULT NULL,
  `I_THUMBNAIL` varchar(40) DEFAULT NULL,
  `I_IMAGE` varchar(40) DEFAULT NULL,
  `I_SRP` double DEFAULT NULL,
  `I_COST` double DEFAULT NULL,
  `I_AVAIL` date DEFAULT NULL,
  `I_STOCK` int(11) DEFAULT NULL,
  `I_ISBN` varchar(13) DEFAULT NULL,
  `I_PAGE` int(11) DEFAULT NULL,
  `I_BACKING` varchar(15) DEFAULT NULL,
  `I_DIMENSIONS` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`I_ID`),
  KEY `item_i_title` (`I_TITLE`),
  KEY `item_i_subject` (`I_SUBJECT`),
  KEY `item_i_a_id` (`I_A_ID`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 |


| ADDRESS | CREATE TABLE `ADDRESS` (
  `ADDR_ID` int(11) NOT NULL DEFAULT '0',
  `ADDR_STREET1` varchar(40) DEFAULT NULL,
  `ADDR_STREET2` varchar(40) DEFAULT NULL,
  `ADDR_CITY` varchar(30) DEFAULT NULL,
  `ADDR_STATE` varchar(20) DEFAULT NULL,
  `ADDR_ZIP` varchar(10) DEFAULT NULL,
  `ADDR_CO_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ADDR_ID`),
  KEY `address_addr_co_id` (`ADDR_CO_ID`),
  KEY `addr_zip` (`ADDR_ZIP`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 |



| 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               |
+--------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+-----------------------+
| ADDRESS            | NDBCLUSTER |      10 | Dynamic    |  399997 |             20 |    14024704 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
| AUTHOR             | NDBCLUSTER |      10 | Dynamic    |    2500 |             20 |      131072 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
| CC_XACTS           | NDBCLUSTER |      10 | Dynamic    |  967588 |             36 |    48758784 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
| COUNTRY            | NDBCLUSTER |      10 | Dynamic    |      92 |             24 |      131072 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
| CUSTOMER           | NDBCLUSTER |      10 | Dynamic    |  214288 |             64 |    16777216 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
| ITEM               | NDBCLUSTER |      10 | Dynamic    |   10000 |            336 |     3670016 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
| ORDERS             | NDBCLUSTER |      10 | Dynamic    |  967694 |             60 |    82051072 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
| ORDER_LINE         | NDBCLUSTER |      10 | Dynamic    | 1275597 |             36 |    69074944 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
| SHOPPING_CART      | NDBCLUSTER |      10 | Fixed      |  645598 |             24 |    16777216 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
| SHOPPING_CART_LINE | NDBCLUSTER |      10 | Fixed      |  516726 |             32 |    16777216 |               0 |            0 | 0 |           NULL | NULL        | NULL        | NULL       | latin1_swedish_ci |     NULL |                | number_of_replicas: 2 |
+--------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+----