FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
APIJSON-Demo/PostgreSQL/single/postgres_sys_Praise.sql at master · feiok/APIJSON-Demo · GitHub
feiok
/
APIJSON-Demo
Public
forked from
APIJSON/APIJSON-Demo
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
APIJSON-Demo
/
PostgreSQL
/
single
/
postgres_sys_Praise.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
38 lines (32 loc) · 2.35 KB
Breadcrumbs
APIJSON-Demo
/
PostgreSQL
/
single
/
postgres_sys_Praise.sql
Copy path
File metadata and controls
38 lines (32 loc) · 2.35 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
create
table
"
Praise
"
(
id
bigint
not null
primary key
,
"
momentId
"
bigint
not null
,
"
userId
"
bigint
not null
,
date
timestamp
(
6
)
);
comment on column "Praise".id is
'
动态id
'
;
comment on column "Praise"."momentId" is
'
唯一标识
'
;
comment on column "Praise"."userId" is
'
用户id
'
;
comment on column "Praise".date is
'
点赞时间
'
;
alter
table
"
Praise
"
owner to postgres;
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
1
,
12
,
82001
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
2
,
15
,
82002
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
3
,
32
,
82003
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
4
,
58
,
82004
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
5
,
170
,
82005
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
6
,
235
,
82006
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
7
,
301
,
82007
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
8
,
371
,
82008
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
9
,
470
,
82009
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
10
,
511
,
82010
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
11
,
543
,
82011
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
12
,
551
,
82012
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
13
,
594
,
82013
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
14
,
595
,
82014
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
15
,
704
,
82015
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
16
,
1491200468898
,
82016
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
17
,
1491277116776
,
82017
,
'
2017-11-19 13:02:30.000000
'
);
INSERT INTO
"
Praise
"
(id,
"
momentId
"
,
"
userId
"
,
date
)
VALUES
(
18
,
1493835799335
,
82018
,
'
2017-11-19 13:02:30.000000
'
);
Back
|
FazBrowse Home
|
New Git URL