forked from idawud/projects-microservice
-
Notifications
You must be signed in to change notification settings - Fork 1
/
project.sql
42 lines (28 loc) · 1001 Bytes
/
project.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET default_tablespace = '';
SET default_with_oids = false;
---
--- drop table
---
DROP TABLE IF EXISTS projects;
---
--- Name: projects
---
create table projects (
project_id serial primary key,
project_name varchar(200) not null,
description text not null
);
insert into projects(project_name, description) values ('client micro-service', 'tcms clients service');
insert into projects(project_name, description) values ('logging micro-service', 'tcms logging pub/sub service');
insert into projects(project_name, description) values ('email micro-service', 'tcms email pub/sub service');
insert into projects(project_name, description) values ('project micro-service', 'tcms project service');
-- NB: Transfer Object field must be same as db fields