12 lines
278 B
Go
12 lines
278 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 NOT NULL,
|
||
|
|
at TIMESTAMP NOT NULL,
|
||
|
|
name VARCHAR(50) NOT NULL,
|
||
|
|
programme_id NOT NULL
|
||
|
|
);
|
||
|
|
`
|