CREATE TABLE IF NOT EXISTS `#__vq_history` (
              `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
              `quote_id` int(11) UNSIGNED NOT NULL,
              `quote` varchar(5120) NOT NULL,
              `author` varchar(64) NOT NULL,
              `category_id` tinyint(4) UNSIGNED NOT NULL,
              `user_id` int(11) UNSIGNED NOT NULL,
              `date_time` timestamp(14) NOT NULL,
              PRIMARY KEY(`id`)
            )
ENGINE=MYISAM
ROW_FORMAT=default
CHARACTER SET utf8 
COLLATE utf8_general_ci ;

CREATE TABLE IF NOT EXISTS `#__vq_quotes` (
              `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
              `quote` varchar(5120) NOT NULL,
              `author` varchar(64) NOT NULL,
              `category_id` tinyint(4) UNSIGNED NOT NULL,
              `user_id` int(11) UNSIGNED NOT NULL,
              `published` tinyint(1) UNSIGNED NOT NULL,
              PRIMARY KEY(`id`)
            )
ENGINE=MYISAM
ROW_FORMAT=default
CHARACTER SET utf8 
COLLATE utf8_general_ci ;

CREATE TABLE IF NOT EXISTS `#__vq_categories` (
              `id` tinyint(4) UNSIGNED NOT NULL AUTO_INCREMENT,
              `name` varchar(32) NOT NULL,
              `published` tinyint(1) UNSIGNED NOT NULL,
              PRIMARY KEY(`id`)
            )
ENGINE=MYISAM
ROW_FORMAT=default
CHARACTER SET utf8 
COLLATE utf8_general_ci ;