github.com/SupenBysz/gf-admin-community@v0.7.4/database/migrations/000014_v01.0220.up.sql (about)

     1  ALTER TABLE "public"."co_fd_account"
     2  DROP COLUMN "created_at",
     3    DROP COLUMN "updated_at",
     4    DROP COLUMN "deleted_at",
     5    ADD COLUMN "created_at" timestamp,
     6    ADD COLUMN "created_by" int8,
     7    ADD COLUMN "updated_at" timestamp,
     8    ADD COLUMN "updated_by" int8,
     9    ADD COLUMN "deleted_at" timestamp,
    10    ADD COLUMN "deleted_by" int8;
    11  
    12  
    13  
    14  ALTER TABLE "public"."co_fd_account_bill"
    15  DROP COLUMN "created_at",
    16    ADD COLUMN "created_at" timestamp,
    17    ADD COLUMN "created_by" int8;
    18  
    19  
    20  ALTER TABLE "public"."co_fd_bank_card"
    21  DROP COLUMN "created_at",
    22    DROP COLUMN "updated_at",
    23    DROP COLUMN "deleted_at",
    24    ADD COLUMN "created_at" timestamp,
    25    ADD COLUMN "created_by" int8,
    26    ADD COLUMN "updated_at" timestamp,
    27    ADD COLUMN "updated_by" int8,
    28    ADD COLUMN "deleted_at" timestamp,
    29    ADD COLUMN "deleted_by" int8;
    30  
    31  
    32  
    33  ALTER TABLE "public"."co_fd_invoice"
    34  DROP COLUMN "created_at",
    35    DROP COLUMN "updated_at",
    36    DROP COLUMN "deleted_at",
    37    ADD COLUMN "created_at" timestamp,
    38    ADD COLUMN "created_by" int8,
    39    ADD COLUMN "updated_at" timestamp,
    40    ADD COLUMN "updated_by" int8,
    41    ADD COLUMN "deleted_at" timestamp,
    42    ADD COLUMN "deleted_by" int8;
    43  
    44  
    45  ALTER TABLE "public"."co_fd_invoice_detail"
    46  DROP COLUMN "created_at",
    47    DROP COLUMN "updated_at",
    48    DROP COLUMN "deleted_at",
    49    ADD COLUMN "created_at" timestamp,
    50    ADD COLUMN "created_by" int8,
    51    ADD COLUMN "updated_at" timestamp,
    52    ADD COLUMN "updated_by" int8,
    53    ADD COLUMN "deleted_at" timestamp,
    54    ADD COLUMN "deleted_by" int8;