diff options
Diffstat (limited to 'database')
| -rw-r--r-- | database/migrate.go | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/database/migrate.go b/database/migrate.go index 1609bc2..a117480 100644 --- a/database/migrate.go +++ b/database/migrate.go @@ -59,10 +59,17 @@ func MigrateDNSRecords(dbConn *sql.DB) (*sql.DB, error) { ttl INTEGER NOT NULL, internal BOOLEAN NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, - FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE);`) + FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE + );`) + if err != nil { + return dbConn, err + } + + _, err = dbConn.Exec(`CREATE UNIQUE INDEX IF NOT EXISTS idx_dns_records_name_content_type ON dns_records (name, type, content);`) if err != nil { return dbConn, err } + return dbConn, nil } |