# Host:
# Database: test
# Table: 'item'
#
CREATE TABLE `item` (
  `uid` BIGINT UNSIGNED NOT NULL,
  `date` datetime,
  `node_uid` BIGINT UNSIGNED default '0',
  `section_uid` BIGINT UNSIGNED default '0',
  `resource_uid` BIGINT UNSIGNED default '0',
  `aggregate_uid` BIGINT UNSIGNED default '0',
  `variation_text` VARCHAR(255),
  `simulation_state` VARCHAR(255) default '',
  KEY `uid` (`uid`),
  KEY `node_uid` (`node_uid`),
  KEY `section_uid` (`section_uid`),
  KEY `resource_uid` (`resource_uid`),
  KEY `variation_text` (`variation_text`)
) TYPE=ndb;

