github.com/yoogoc/kratos-scaffold@v0.0.0-20240402032722-a538b3c18955/generator/tmpl/migration.sql.tmpl (about)

     1  {{- /*gotype: github.com/yoogoc/kratos-scaffold/generator.Data*/ -}}
     2  -- +goose Up
     3  -- +goose StatementBegin
     4  create table {{.TableName}} (
     5  {{- range $i, $f := .Fields }}
     6  {{$f.Name | ToSnake | ToLower}} {{ $f.FieldType.StringMysql }},
     7  {{- end }}
     8  PRIMARY KEY (id)
     9  );
    10  -- +goose StatementEnd
    11  
    12  -- +goose Down
    13  -- +goose StatementBegin
    14  drop table {{.TableName}};
    15  -- +goose StatementEnd