| 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 | +--------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+----