Home Explore Help
Register Sign In
vidane
/
vtorio
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: ab6e0cf041
Branches Tags
vtorio
/
prisma
/
migrations
/
20260202233207_update_gow_tables
/
migration.sql

migration.sql 4.5 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980 
  1. /*
    2. 

  2.   Warnings:
    3. 

  3. 

  4.   - You are about to drop the column `createdAt` on the `gow_corp_ref` table. All the data in the column will be lost.
    5. 

  5.   - You are about to drop the column `updatedAt` on the `gow_corp_ref` table. All the data in the column will be lost.
    6. 

  6.   - You are about to drop the column `corpId` on the `gow_data` table. All the data in the column will be lost.
    7. 

  7.   - You are about to drop the column `createdAt` on the `gow_data` table. All the data in the column will be lost.
    8. 

  8.   - You are about to drop the column `updatedAt` on the `gow_data` table. All the data in the column will be lost.
    9. 

  9.   - You are about to drop the column `createdAt` on the `gow_fac_id` table. All the data in the column will be lost.
    10. 

  10.   - You are about to drop the column `updatedAt` on the `gow_fac_id` table. All the data in the column will be lost.
    11. 

  11.   - Added the required column `updated_at` to the `gow_corp_ref` table without a default value. This is not possible if the table is not empty.
    12. 

  12.   - Added the required column `updated_at` to the `gow_data` table without a default value. This is not possible if the table is not empty.
    13. 

  13.   - Added the required column `updated_at` to the `gow_fac_id` table without a default value. This is not possible if the table is not empty.
    14. 

  14. 

  15. */
    16. 

  16. -- AlterTable
    17. 

  17. ALTER TABLE "gow_corp_ref" DROP COLUMN "createdAt",
    18. 

  18. DROP COLUMN "updatedAt",
    19. 

  19. ADD COLUMN     "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    20. 

  20. ADD COLUMN     "updated_at" TIMESTAMP(3) NOT NULL,
    21. 

  21. ALTER COLUMN "well_name" SET DATA TYPE VARCHAR(4000),
    22. 

  22. ALTER COLUMN "api_no" SET DATA TYPE VARCHAR(4000),
    23. 

  23. ALTER COLUMN "corporate_id" SET DATA TYPE VARCHAR(4000),
    24. 

  24. ALTER COLUMN "current_well_status" SET DATA TYPE VARCHAR(4000),
    25. 

  25. ALTER COLUMN "county_parish" SET DATA TYPE VARCHAR(4000),
    26. 

  26. ALTER COLUMN "state" SET DATA TYPE VARCHAR(4000),
    27. 

  27. ALTER COLUMN "area" SET DATA TYPE VARCHAR(4000),
    28. 

  28. ALTER COLUMN "completion_date" SET DATA TYPE VARCHAR(4000),
    29. 

  29. ALTER COLUMN "pop_first_production" SET DATA TYPE VARCHAR(4000),
    30. 

  30. ALTER COLUMN "operator" SET DATA TYPE VARCHAR(4000),
    31. 

  31. ALTER COLUMN "abandon_date" SET DATA TYPE VARCHAR(4000),
    32. 

  32. ALTER COLUMN "battery" SET DATA TYPE VARCHAR(4000),
    33. 

  33. ALTER COLUMN "common_pad_name" SET DATA TYPE VARCHAR(4000),
    34. 

  34. ALTER COLUMN "id_well" SET DATA TYPE VARCHAR(4000),
    35. 

  35. ALTER COLUMN "lease_id" SET DATA TYPE VARCHAR(4000),
    36. 

  36. ALTER COLUMN "latitude" SET DATA TYPE VARCHAR(4000),
    37. 

  37. ALTER COLUMN "longitude" SET DATA TYPE VARCHAR(4000),
    38. 

  38. ALTER COLUMN "pad_code" SET DATA TYPE VARCHAR(4000),
    39. 

  39. ALTER COLUMN "pad_name" SET DATA TYPE VARCHAR(4000),
    40. 

  40. ALTER COLUMN "permit_number" SET DATA TYPE VARCHAR(4000),
    41. 

  41. ALTER COLUMN "well_sub_status" SET DATA TYPE VARCHAR(4000),
    42. 

  42. ALTER COLUMN "shut_in_date" SET DATA TYPE VARCHAR(4000);
    43. 

  43. 

  44. -- AlterTable
    45. 

  45. ALTER TABLE "gow_data" DROP COLUMN "corpId",
    46. 

  46. DROP COLUMN "createdAt",
    47. 

  47. DROP COLUMN "updatedAt",
    48. 

  48. ADD COLUMN     "corp_id" VARCHAR(4000),
    49. 

  49. ADD COLUMN     "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    50. 

  50. ADD COLUMN     "updated_at" TIMESTAMP(3) NOT NULL,
    51. 

  51. ALTER COLUMN "well_name" SET DATA TYPE VARCHAR(4000),
    52. 

  52. ALTER COLUMN "month" SET DATA TYPE VARCHAR(4000),
    53. 

  53. ALTER COLUMN "completion_type" SET DATA TYPE VARCHAR(4000),
    54. 

  54. ALTER COLUMN "state" SET DATA TYPE VARCHAR(4000),
    55. 

  55. ALTER COLUMN "days_on" SET DATA TYPE VARCHAR(4000),
    56. 

  56. ALTER COLUMN "gas_production" SET DATA TYPE VARCHAR(4000),
    57. 

  57. ALTER COLUMN "gas_sales" SET DATA TYPE VARCHAR(4000),
    58. 

  58. ALTER COLUMN "oil_production" SET DATA TYPE VARCHAR(4000),
    59. 

  59. ALTER COLUMN "oil_sales" SET DATA TYPE VARCHAR(4000),
    60. 

  60. ALTER COLUMN "water_production" SET DATA TYPE VARCHAR(4000),
    61. 

  61. ALTER COLUMN "operator" SET DATA TYPE VARCHAR(4000);
    62. 

  62. 

  63. -- AlterTable
    64. 

  64. ALTER TABLE "gow_fac_id" DROP COLUMN "createdAt",
    65. 

  65. DROP COLUMN "updatedAt",
    66. 

  66. ADD COLUMN     "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    67. 

  67. ADD COLUMN     "updated_at" TIMESTAMP(3) NOT NULL,
    68. 

  68. ALTER COLUMN "corp_id" SET DATA TYPE VARCHAR(4000),
    69. 

  69. ALTER COLUMN "odeq_fac_id" SET DATA TYPE VARCHAR(4000),
    70. 

  70. ALTER COLUMN "odeq_facility_name" SET DATA TYPE VARCHAR(4000),
    71. 

  71. ALTER COLUMN "corp_id_2" SET DATA TYPE VARCHAR(4000);
    72. 

  72. 

  73. -- AddForeignKey
    74. 

  74. ALTER TABLE "gow_fac_id" ADD CONSTRAINT "gow_fac_id_import_id_fkey" FOREIGN KEY ("import_id") REFERENCES "imports"("id") ON DELETE CASCADE ON UPDATE CASCADE;
    75. 

  75. 

  76. -- AddForeignKey
    77. 

  77. ALTER TABLE "gow_data" ADD CONSTRAINT "gow_data_import_id_fkey" FOREIGN KEY ("import_id") REFERENCES "imports"("id") ON DELETE CASCADE ON UPDATE CASCADE;
    78. 

  78. 

  79. -- AddForeignKey
    80. 

  80. ALTER TABLE "gow_corp_ref" ADD CONSTRAINT "gow_corp_ref_import_id_fkey" FOREIGN KEY ("import_id") REFERENCES "imports"("id") ON DELETE CASCADE ON UPDATE CASCADE;
    81.