· 6 years ago · Apr 29, 2019, 09:56 PM
1CREATE TABLE IF NOT EXISTS `quote_history` (
2 `id` INT NOT NULL AUTO_INCREMENT,
3 `question_id` INT NULL,
4 `session_id` VARCHAR(32) NULL,
5 `total_amt` FLOAT NULL,
6 `ip_address` VARCHAR(45) NULL,
7 `url` VARCHAR(128) NULL,
8 `time_stamp` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
9 PRIMARY KEY (`id`)
10 )