--source include/have_innodb.inc
|
|
INSTALL SONAME 'ha_oqgraph';
|
|
CREATE TABLE oq_backing (
|
origid INT UNSIGNED NOT NULL,
|
destid INT UNSIGNED NOT NULL,
|
PRIMARY KEY (origid, destid),
|
KEY (destid)
|
) ENGINE=InnoDB;
|
CREATE TABLE oq (
|
latch VARCHAR(32) NULL,
|
origid BIGINT UNSIGNED NULL,
|
destid BIGINT UNSIGNED NULL,
|
weight DOUBLE NULL,
|
seq BIGINT UNSIGNED NULL,
|
linkid BIGINT UNSIGNED NULL,
|
KEY (latch, origid, destid) USING HASH,
|
KEY (latch, destid, origid) USING HASH
|
) ENGINE=OQGRAPH data_table='oq_backing' origid='origid' destid='destid';
|
|
CREATE TABLE t (a INT);
|
CREATE OR REPLACE TABLE t AS SELECT * FROM oq;
|
|
# Cleanup
|
DROP TABLE t, oq, oq_backing;
|
UNINSTALL SONAME 'ha_oqgraph';
|