VvebOIDC/install/sql/sqlite/schema/fields/field_value_content.sql

13 lines
389 B
SQL

DROP TABLE IF EXISTS `field_value_content`;
CREATE TABLE `field_value_content` (
`field_value_id` INTEGER NOT NULL,
`field_id` INTEGER NOT NULL,
`language_id` INTEGER NOT NULL,
`name` TEXT NOT NULL,
`content` longtext NOT NULL
-- PRIMARY KEY (`field_value_id`,`language_id`)
);
CREATE INDEX `field_value_content_field_id_language_id` ON `field_value_content` (`field_id`,`language_id`);