Select Code to Download

 
   sub convert_schema {
  my ($name,$schema,$engine) = @_;
...
    s/ datetime/ varchar(32)/g;
    s/ real/ float/g;
    s/ bit/ boolean/g;

CREATE TABLE Allele (
    allele_id int NOT NULL,
...
    last_updated_time varchar(32) NULL 

)

CREATE TABLE [Allele] (
    [allele_id] [int] NOT NULL ,
...
    [last_updated_time] [smalldatetime] NULL 

)

 s/\)\n/\);\n/;