PKGBUILD/pkg/repository/postgres/ddl/1_table_devices.up.sql

CREATE TABLE devices (
  device_id               CHAR(36)                                                NOT NULL,
  device_name             VARCHAR(64)                                             NOT NULL,
  device_location         VARCHAR(64),
  creation_date           TIMESTAMP WITH TIME ZONE    DEFAULT CURRENT_TIMESTAMP   NOT NULL,
  update_date             TIMESTAMP WITH TIME ZONE,
  CONSTRAINT pk_devices PRIMARY KEY(device_id)
);
fix: use go-migrate pkg to init or update db schema Instead to implement own logic how the database scheme should be updated or migrated to a newer or older version flucky use now instead the go-migrate package. 2021-01-30 14:44:21 +00:00			`CREATE TABLE devices (`
			`device_id CHAR(36) NOT NULL,`
fix: add postgres backend changes: - Add postgres backend - Modified or added table attributes. UpdateDate, ForeignKeys, Booleans - Fix test for sqlite and postgres. Compare json instead the struct. 2020-06-01 20:36:57 +00:00			`device_name VARCHAR(64) NOT NULL,`
			`device_location VARCHAR(64),`
fix: postgres columns with timezone Add timezone for the columns creation_date and update_date, otherwise it's difficult to compare the times correctly in the unit test. Furthermore the default value of the creation_date will now be defined by the postgres implementation of the database interface. 2020-10-07 21:38:27 +00:00			`creation_date TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL,`
fix: use go-migrate pkg to init or update db schema Instead to implement own logic how the database scheme should be updated or migrated to a newer or older version flucky use now instead the go-migrate package. 2021-01-30 14:44:21 +00:00			`update_date TIMESTAMP WITH TIME ZONE,`
			`CONSTRAINT pk_devices PRIMARY KEY(device_id)`
fix: add postgres backend changes: - Add postgres backend - Modified or added table attributes. UpdateDate, ForeignKeys, Booleans - Fix test for sqlite and postgres. Compare json instead the struct. 2020-06-01 20:36:57 +00:00			`);`