-- ------------------------------------------------
-- Table sod_activity_fieldvalues
-- Created 20140703
-- ------------------------------------------------

CREATE TABLE IF NOT EXISTS `sod_activity_fieldvalues` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `act_id` int(11) NOT NULL,
  `object_id` int(11) NOT NULL,
  `field_number` int(11) NOT NULL,
  `val_low` varchar(40) DEFAULT NULL,
  `val_high` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `act` (`act_id`),
  KEY `obj` (`object_id`),
  CONSTRAINT `fk_actfv_act` FOREIGN KEY (`act_id`) REFERENCES `sod_activities` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_actfv_obj` FOREIGN KEY (`object_id`) REFERENCES `sod_auth_object` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
);

DROP TABLE sod_activity_values;
