CREATE DATABASE vuoronumerodb;

USE vuoronumerodb;
CREATE SCHEMA [default];


CREATE TABLE [default].turn_number
(
    id         INT IDENTITY,
    office        VARCHAR(255) NOT NULL,
    issued_at DATETIME NOT NULL
                DEFAULT CURRENT_TIMESTAMP,
    done_at DATETIME,
    PRIMARY KEY(id)
);

GO
EXEC sys.sp_cdc_enable_db
GO


GO
EXEC sys.sp_cdc_enable_table
@source_schema = N'default',
@source_name   = N'turn_number',
@role_name     = NULL,
@filegroup_name = NULL,
@supports_net_changes = 1
GO

USE vuoronumerodb;
INSERT INTO [default].turn_number (office) VALUES ('toolon-toimipiste');