Victor Lacasse-Beaudoin
20fa0e10d1
PRIMARY KEY est toujours UNIQUE et NOT NULL, alors NOT NULL est redondant Assigner type VARCHAR(6) à presences.programme_id
11 lines
280 B
Go
11 lines
280 B
Go
// Package dbschema defines the database schema for the application
|
|
package dbschema
|
|
|
|
const Schema string = `
|
|
CREATE TABLE IF NOT EXISTS presences (
|
|
id VARCHAR(7) PRIMARY KEY,
|
|
at TIMESTAMP NOT NULL,
|
|
name VARCHAR(50) NOT NULL,
|
|
programme_id VARCHAR(6) NOT NULL
|
|
);
|
|
`
|