1 CREATE TABLE `rec_array` (
2 `id` bigint(20) unsigned NOT NULL,
6 CREATE TABLE `rec_array_item` (
7 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
8 `array` bigint(20) NOT NULL,
9 `pos` bigint(20) NOT NULL,
10 `value_data` varchar(255) DEFAULT NULL,
11 `value_type` enum('array','data','hash','text','value') NOT NULL DEFAULT 'value',
13 UNIQUE KEY `array_2` (`array`,`pos`),
16 CREATE TABLE `rec_hash` (
17 `id` bigint(20) unsigned NOT NULL,
21 CREATE TABLE `rec_hash_item` (
22 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
23 `hash` bigint(20) NOT NULL,
24 `key_data` varchar(255) DEFAULT NULL,
25 `key_hash` varchar(22) NOT NULL,
26 `key_type` enum('text','value') NOT NULL DEFAULT 'value',
27 `value_data` varchar(255) DEFAULT NULL,
28 `value_type` enum('array','data','hash','text','value') NOT NULL DEFAULT 'value',
30 UNIQUE KEY `hash_2` (`hash`,`key_hash`),
33 CREATE TABLE `rec_item` (
34 `id` bigint(20) NOT NULL AUTO_INCREMENT,
35 `item_type` enum('array','hash') NOT NULL DEFAULT 'hash',
39 CREATE TABLE `rec_value_data` (
40 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
41 `data` longblob NOT NULL,
45 CREATE TABLE `rec_value_text` (
46 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
47 `data` longtext NOT NULL,