Generates a wrong DDL

[aymanbagabas]

I'm still new to GORM and have been using modernc.org/sqlite for quite a while.

When I try to rerun the migrations I get the following error for these models:

// Model is the base model for all models.
type Model struct {
	ID        uint           `gorm:"primaryKey"`
	CreatedAt time.Time      `gorm:"not null;default:CURRENT_TIMESTAMP"`
	UpdatedAt time.Time      `gorm:"not null;default:CURRENT_TIMESTAMP"`
	DeletedAt gorm.DeletedAt `gorm:"index"`
}

// PublicKey is a public key model.
type PublicKey struct {
	Model
	Key    string `gorm:"column:public_key;index:idx_public_key_key,unique;index:idx_public_key_user,unique;not null"`
	UserID uint   `gorm:"index:idx_public_key_user,unique;not null"`
	User   User   `gorm:"constraint:OnDelete:CASCADE,OnUpdate:CASCADE;"`
}

// TableName returns the table name for the public key model.
func (PublicKey) TableName() string {
	return "public_key"
}

2023/07/05 16:07:27 /Users/ayman/.go/pkg/mod/github.com/glebarez/sqlite@v1.8.0/migrator.go:406 SQL logic error: near "text": syntax error (1)
[0.014ms] [rows:0] CREATE TABLE `public_key__temp` text NOT NULL UNIQUE,`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,`deleted_at` datetime,`public_key` ?,`user_id` integer NOT NULL,PRIMARY KEY (`id`),CONSTRAINT `fk_user_public_key` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON DELETE CASCADE ON UPDATE CASCADE)

I'm assuming the error is happening because I'm using the same name for the column public_key and table name public_key

[glebarez]

Hello,
does this reproduce using the GORM standard driver?