File "updates.sql"

Full Path: /srv/www/www.cadoro.it/sql/updates.sql
File size: 928 bytes
MIME-type: text/plain
Charset: utf-8

CREATE TABLE `qrcode` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `uniqid` varchar(255) DEFAULT NULL,
  `landing` varchar(255) DEFAULT NULL,
  `published` int(11) DEFAULT NULL,
  `date_begin` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
);

ALTER TABLE `blog_articles`
ADD COLUMN `published_app` INT(11) NULL DEFAULT 0 AFTER `focus`,
ADD COLUMN `image_app` VARCHAR(255) NULL DEFAULT NULL AFTER `published_app`;

ALTER TABLE `cadoro`.`pages`
ADD COLUMN `hero_mobile` VARCHAR(255) NULL DEFAULT NULL AFTER `hero`;
ALTER TABLE `cadoro`.`pages`
ADD COLUMN `hero_video` VARCHAR(255) NULL DEFAULT NULL AFTER `hero_mobile`;
ALTER TABLE `cadoro`.`pages`
ADD COLUMN `extra_props` INT(11) NULL DEFAULT NULL AFTER `hero_video`;