Editing ray

Title / Description

Code
CREATE TABLE IF NOT EXISTS `cdas`.`saved_search` ( `search_id` BIGINT NOT NULL AUTO_INCREMENT , `channel_id` BIGINT NOT NULL , `product_id` BIGINT NOT NULL , `search_term` VARCHAR(255) NOT NULL , `created_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP , `modified_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP , `usage_counter` BIGINT NULL DEFAULT 0 , `fit_id` BIGINT UNSIGNED NULL , `search_statistics_id` BIGINT NOT NULL , PRIMARY KEY (`search_id`, `channel_id`) , CONSTRAINT `fk_saved_search_search_statistics1` FOREIGN KEY (`search_statistics_id` ) REFERENCES `cdas`.`search_statistics` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_saved_search_channel1` FOREIGN KEY (`channel_id` ) REFERENCES `cdas`.`channel` (`channel_id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_saved_search_product1` FOREIGN KEY (`product_id` ) REFERENCES `cdas`.`product` (`product_id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB

Author

Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code