gitlabhq / mysql-postgresql-converter

Lanyrd's MySQL to PostgreSQL conversion script
BSD 2-Clause "Simplified" License
45 stars 23 forks source link

Convert `datetime` to `timestamp without time zone` rather than `timestamp with time zone` #9

Open DouweM opened 9 years ago

DouweM commented 9 years ago
diff --git a/Users/douwemaan/Desktop/snippets.table.psql b/Users/douwemaan/Desktop/snippets.table.mysql
index 0ca7fd6..8d77d01 100644
--- a/Users/douwemaan/Desktop/snippets.table.psql
+++ b/Users/douwemaan/Desktop/snippets.table.mysql
@@ -2,15 +2,15 @@
       Column      |            Type             |                       Modifiers                       
 ------------------+-----------------------------+-------------------------------------------------------
  id               | integer                     | not null default nextval('snippets_id_seq'::regclass)
- title            | character varying(255)      | 
+ title            | character varying(510)      | default NULL::character varying
  content          | text                        | 
  author_id        | integer                     | not null
  project_id       | integer                     | 
- created_at       | timestamp without time zone | 
- updated_at       | timestamp without time zone | 
- file_name        | character varying(255)      | 
- expires_at       | timestamp without time zone | 
- type             | character varying(255)      | 
+ created_at       | timestamp with time zone    | 
+ updated_at       | timestamp with time zone    | 
+ file_name        | character varying(510)      | default NULL::character varying
+ expires_at       | timestamp with time zone    | 
+ type             | character varying(510)      | default NULL::character varying
  visibility_level | integer                     | not null default 0
 Indexes:
     "snippets_pkey" PRIMARY KEY, btree (id)