33 lines
640 B
Go
33 lines
640 B
Go
package models
|
|
|
|
import (
|
|
"database/sql"
|
|
|
|
"timefu.li/backend/tubsql"
|
|
)
|
|
|
|
func Init_tables(db *sql.DB) {
|
|
tubsql.Init_table(db, "users", []string{
|
|
"id int not null PRIMARY KEY",
|
|
"name varchar(255)",
|
|
})
|
|
tubsql.Init_table(db, "tasks", []string{
|
|
"id int not null PRIMARY KEY",
|
|
"name varchar(255)",
|
|
|
|
"user_id int",
|
|
"FOREIGN KEY(user_id) REFERENCES users(id)",
|
|
})
|
|
tubsql.Init_table(db, "completed_tasks", []string{
|
|
"id int not null PRIMARY KEY",
|
|
"completed_date int",
|
|
"started_date int",
|
|
|
|
"task_id int",
|
|
"FOREIGN KEY(task_id) REFERENCES tasks(id)",
|
|
|
|
"user_id int",
|
|
"FOREIGN KEY(user_id) REFERENCES users(id)",
|
|
})
|
|
}
|