Project

General

Profile

« Previous | Next » 

Revision 561

Added by Aaron Marcuse-Kubitza almost 13 years ago

PostgreSQL-MySQL.csv: Convert double quotes to backticks (`)

View differences:

schemas/vegbien.for_ERD.my.sql
121 121 
  confidentialityreason character varying(200),
122 122 
  latitude double precision,
123 123 
  longitude double precision,
124 
  -- ...
124 
  `... (truncated) ...` int(11),
125 125 
  accessioncode character varying(255),
126 126 
  sublocationxposition double precision,
127 127 
  sublocationyposition double precision,
......
146 146 
  location_id int(11) NOT NULL,
147 147 
  project_id int(11),
148 148 
  sourceid character varying(30),
149 
  -- ...
149 
  `... (truncated) ...` int(11),
150 150 
  accessioncode character varying(255),
151 151 
  CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id ),
152 152 
  CONSTRAINT locationevent_location_id FOREIGN KEY (location_id)
......
166 166 
  reference_id int(11),
167 167 
  taxoninferencearea double precision,
168 168 
  emb_taxonoccurrence int(11),
169 
  -- ...
169 
  `... (truncated) ...` int(11),
170 170 
  accessioncode character varying(255),
171 171 
  CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id ),
172 172 
  CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id)
schemas/vegbien.for_wiki.sql
11 11 
  confidentialityreason character varying(200),
12 12 
  latitude double precision,
13 13 
  longitude double precision,
14 
  -- ...
14 
  "... (truncated) ..." integer,
15 15 
  accessioncode character varying(255),
16 16 
  sublocationxposition double precision,
17 17 
  sublocationyposition double precision,
......
25 25 
  location_id integer NOT NULL,
26 26 
  project_id integer,
27 27 
  sourceid character varying(30),
28 
  -- ...
28 
  "... (truncated) ..." integer,
29 29 
  accessioncode character varying(255),
30 30 
);
31 31 

  		




  ......




  37
  37
  
    
  reference_id integer,


  		




  38
  38
  
    
  taxoninferencearea double precision,


  		




  39
  39
  
    
  emb_taxonoccurrence integer,


  		




  40
  
  
    
  -- ...


  		




  
  40
  
    
  "... (truncated) ..." integer,


  		




  41
  41
  
    
  accessioncode character varying(255),


  		




  42
  42
  
    
);


  		




  43
  43
  
    

  		












  

    
      schemas/vegbien.for_ERD.sql
    
  





  121
  121
  
    
  confidentialityreason character varying(200),


  		




  122
  122
  
    
  latitude double precision,


  		




  123
  123
  
    
  longitude double precision,


  		




  124
  
  
    
  -- ...


  		




  
  124
  
    
  "... (truncated) ..." integer,


  		




  125
  125
  
    
  accessioncode character varying(255),


  		




  126
  126
  
    
  sublocationxposition double precision,


  		




  127
  127
  
    
  sublocationyposition double precision,


  		




  ......




  146
  146
  
    
  location_id integer NOT NULL,


  		




  147
  147
  
    
  project_id integer,


  		




  148
  148
  
    
  sourceid character varying(30),


  		




  149
  
  
    
  -- ...


  		




  
  149
  
    
  "... (truncated) ..." integer,


  		




  150
  150
  
    
  accessioncode character varying(255),


  		




  151
  151
  
    
  CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id ),


  		




  152
  152
  
    
  CONSTRAINT locationevent_location_id FOREIGN KEY (location_id)


  		




  ......




  166
  166
  
    
  reference_id integer,


  		




  167
  167
  
    
  taxoninferencearea double precision,


  		




  168
  168
  
    
  emb_taxonoccurrence integer,


  		




  169
  
  
    
  -- ...


  		




  
  169
  
    
  "... (truncated) ..." integer,


  		




  170
  170
  
    
  accessioncode character varying(255),


  		




  171
  171
  
    
  CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id ),


  		




  172
  172
  
    
  CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id)


  		












  

    
      lib/PostgreSQL-MySQL.csv
    
  





  1
  1
  
    
"PostgreSQL","MySQL","Comments"


  		




  2
  2
  
    
"^--(?=\S)","\g<0> ",


  		




  
  3
  
    
"""([^""]*?)""","`\1`",


  		




  3
  4
  
    
"\bserial( NOT NULL\b)?","int(11)\1 AUTO_INCREMENT",


  		




  4
  5
  
    
"Integer","int(11)",


  		




  5
  6
  
    
"Boolean","int(1)",


  		












Also available in:  Unified diff