All tests pass except for the transaction tests under MySQL. InnoDB sucks

[dbsrgits/DBM-Deep.git] / etc / mysql_tables.sql

diff --git a/etc/mysql_tables.sql b/etc/mysql_tables.sql
index ab9674a..1f4cb58 100644 (file)
--- a/etc/mysql_tables.sql
+++ b/etc/mysql_tables.sql
@@ -5,16 +5,16 @@ CREATE TABLE refs (
     id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
    ,ref_type ENUM( 'H', 'A' ) NOT NULL DEFAULT 'H'
    ,refcount BIGINT UNSIGNED NOT NULL DEFAULT 1
-);
+   ,classname LONGTEXT
+) ENGINE=MyISAM;
 
 CREATE TABLE datas (
     id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
    ,ref_id BIGINT UNSIGNED NOT NULL
    ,data_type ENUM( 'S', 'R' ) DEFAULT 'S'
-   ,`key` TEXT NOT NULL
-   ,value TEXT
-   ,class TEXT
+   ,`key` LONGTEXT NOT NULL
+   ,value LONGTEXT
    ,FOREIGN KEY (ref_id) REFERENCES refs (id)
         ON DELETE CASCADE ON UPDATE CASCADE
-   ,UNIQUE INDEX (ref_id, `key` (900) )
-);
+   ,UNIQUE INDEX (ref_id, `key` (700) )
+) ENGINE=MyISAM;