RootZanli & NinjaCr3

: / home / o5t6x7pgljbm / public_html / admin / sqls /

Filename : v3_3_school_management.sql

back

ALTER TABLE schools ADD COLUMN `uuid` varchar(100) DEFAULT NULL AFTER school_id;
ALTER TABLE schools ADD COLUMN `subscribed` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE schools ADD COLUMN `subscribed_at` timestamp DEFAULT NULL;


CREATE TABLE `admin_school` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` bigint unsigned NOT NULL,
  `school_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB ;

ALTER TABLE product_wishlist ADD COLUMN group_id INT DEFAULT NULL AFTER product_id;