77 lines
3.0 KiB
SQL
77 lines
3.0 KiB
SQL
/*
|
|
Warnings:
|
|
|
|
- You are about to drop the column `address` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the column `created_at` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the column `firstname` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the column `img` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the column `lastname` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the column `password` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the column `phone` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the column `role` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the column `updated_at` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the column `username` on the `user` table. All the data in the column will be lost.
|
|
- You are about to drop the `koas-profile` table. If the table is not empty, all the data it contains will be lost.
|
|
- You are about to drop the `likes` table. If the table is not empty, all the data it contains will be lost.
|
|
- You are about to drop the `notifications` table. If the table is not empty, all the data it contains will be lost.
|
|
- You are about to drop the `pasien-profile` table. If the table is not empty, all the data it contains will be lost.
|
|
- You are about to drop the `posts` table. If the table is not empty, all the data it contains will be lost.
|
|
- You are about to drop the `treatment-types` table. If the table is not empty, all the data it contains will be lost.
|
|
|
|
*/
|
|
-- DropForeignKey
|
|
ALTER TABLE `koas-profile` DROP FOREIGN KEY `koas-profile_user_id_fkey`;
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE `likes` DROP FOREIGN KEY `likes_post_id_fkey`;
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE `likes` DROP FOREIGN KEY `likes_user_id_fkey`;
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE `notifications` DROP FOREIGN KEY `notifications_user_id_fkey`;
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE `pasien-profile` DROP FOREIGN KEY `pasien-profile_user_id_fkey`;
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE `posts` DROP FOREIGN KEY `posts_koas_id_fkey`;
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE `posts` DROP FOREIGN KEY `posts_user_id_fkey`;
|
|
|
|
-- DropIndex
|
|
DROP INDEX `user_username_key` ON `user`;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE `user` DROP COLUMN `address`,
|
|
DROP COLUMN `created_at`,
|
|
DROP COLUMN `firstname`,
|
|
DROP COLUMN `img`,
|
|
DROP COLUMN `lastname`,
|
|
DROP COLUMN `password`,
|
|
DROP COLUMN `phone`,
|
|
DROP COLUMN `role`,
|
|
DROP COLUMN `updated_at`,
|
|
DROP COLUMN `username`,
|
|
ADD COLUMN `image` VARCHAR(191) NULL,
|
|
ADD COLUMN `name` VARCHAR(191) NULL;
|
|
|
|
-- DropTable
|
|
DROP TABLE `koas-profile`;
|
|
|
|
-- DropTable
|
|
DROP TABLE `likes`;
|
|
|
|
-- DropTable
|
|
DROP TABLE `notifications`;
|
|
|
|
-- DropTable
|
|
DROP TABLE `pasien-profile`;
|
|
|
|
-- DropTable
|
|
DROP TABLE `posts`;
|
|
|
|
-- DropTable
|
|
DROP TABLE `treatment-types`;
|