FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
APIJSON/PostgreSQL/sys.sql at patch-1 · CoolGeo2016/APIJSON · GitHub
CoolGeo2016
/
APIJSON
Public
forked from
Tencent/APIJSON
Notifications
You must be signed in to change notification settings
Fork
0
Star
1
Code
Pull requests
0
Actions
Projects
Wiki
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Expand file tree
Breadcrumbs
APIJSON
/
PostgreSQL
/
sys.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
80 lines (70 loc) · 6.51 KB
Breadcrumbs
APIJSON
/
PostgreSQL
/
sys.sql
Copy path
File metadata and controls
80 lines (70 loc) · 6.51 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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
/*
Navicat PostgreSQL Data Transfer
Source Server : localhost
Source Server Type : PostgreSQL
Source Server Version : 100005
Source Host : localhost:5432
Source Catalog : postgres
Source Schema : sys
Target Server Type : PostgreSQL
Target Server Version : 100005
File Encoding : 65001
Date: 26/08/2018 18:50:42
*/
--
----------------------------
--
Table structure for apijson_user
--
----------------------------
DROP
TABLE
IF EXISTS
"
sys
"
.
"
apijson_user
"
;
CREATE
TABLE
"
sys
".
"
apijson_user
"
(
"
id
"
int8
NOT NULL
,
"
name
"
varchar
(
30
) COLLATE
"
pg_catalog
"
.
"
default
"
NOT NULL
,
"
sex
"
int2
NOT NULL
DEFAULT
0
,
"
date
"
timestamp
(
6
),
"
head
"
varchar
(
255
) COLLATE
"
pg_catalog
"
.
"
default
"
NOT NULL
DEFAULT
'
http://my.oschina.net/img/portrait.gif?t=1451961935000
'
::character varying,
"
contactidlist
"
json
NOT NULL
DEFAULT
'
[]
'
::json,
"
picturelist
"
json
NOT NULL
DEFAULT
'
[]
'
::json,
"
tag
"
varchar
(
50
) COLLATE
"
pg_catalog
"
.
"
default
"
)
;
ALTER
TABLE
"
sys
"
.
"
apijson_user
"
OWNER TO
"
postgres
"
;
--
----------------------------
--
Records of apijson_user
--
----------------------------
BEGIN
;
INSERT INTO
"
sys
"
.
"
apijson_user
"
VALUES
(
38710
,
'
TommyLemon
'
,
0
,
'
2017-02-01 19:21:50
'
,
'
http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000
'
,
'
[82003, 82005, 90814, 82004, 82009, 82002, 82044, 93793, 70793]
'
,
'
["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]
'
,
'
Android&Java
'
);
INSERT INTO
"
sys
"
.
"
apijson_user
"
VALUES
(
82002
,
'
Happy~
'
,
1
,
'
2017-02-01 19:21:50
'
,
'
http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000
'
,
'
[82005, 82001, 38710]
'
,
'
[]
'
,
'
iOS
'
);
INSERT INTO
"
sys
"
.
"
apijson_user
"
VALUES
(
82001
,
'
Test
'
,
0
,
'
2017-02-01 19:21:50
'
,
'
https://static.oschina.net/uploads/user/19/39085_50.jpg
'
,
'
[82030, 82025, 82003, 93793, 82006, 1520242280259, 82005, 82024, 1531969715979]
'
,
'
["http://common.cnblogs.com/images/icon_weibo_24.png"]
'
,
'
APIJSON User
'
);
INSERT INTO
"
sys
"
.
"
apijson_user
"
VALUES
(
70793
,
'
Strong
'
,
0
,
'
2017-02-01 19:21:50
'
,
'
http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000
'
,
'
[38710, 82002]
'
,
'
["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg", "http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg", "https://camo.githubusercontent.com/788c0a7e11a", "https://camo.githubusercontent.com/f513f67"]
'
,
'
djdj
'
);
COMMIT
;
--
----------------------------
--
Table structure for moment
--
----------------------------
DROP
TABLE
IF EXISTS
"
sys
"
.
"
moment
"
;
CREATE
TABLE
"
sys
".
"
moment
"
(
"
id
"
int8
NOT NULL
,
"
content
"
varchar
(
1000
) COLLATE
"
pg_catalog
"
.
"
default
"
,
"
userid
"
int8
NOT NULL
DEFAULT
0
,
"
praiseuseridlist
"
json
NOT NULL
DEFAULT
'
[]
'
::json,
"
picturelist
"
json
NOT NULL
DEFAULT
'
[]
'
::json,
"
date
"
timestamp
(
6
)
)
;
ALTER
TABLE
"
sys
"
.
"
moment
"
OWNER TO
"
postgres
"
;
--
----------------------------
--
Records of moment
--
----------------------------
BEGIN
;
INSERT INTO "sys"."moment" VALUES (12, '1111534034', 70793, '[70793, 93793, 82044, 82040, 82055, 90814, 38710, 82002, 82006, 1508072105320, 82001]', '["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg", "http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg", "https://camo.githubusercontent.com/788c0a7e11a4f5aadef3c886f028c79b4808613a/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343932353935372d313732303737333630382e6a7067", "http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png", "https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067", "https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067", "https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067", "https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067"]', '2017-02-08 08:06:11');
INSERT INTO
"
sys
"
.
"
moment
"
VALUES
(
15
,
'
APIJSON is a JSON Transmission Structure Protocol…
'
,
70793
,
'
[82055, 82002, 38710]
'
,
'
["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]
'
,
'
2017-02-08 08:06:11
'
);
INSERT INTO
"
sys
"
.
"
moment
"
VALUES
(
32
,
NULL
,
82002
,
'
[38710, 82002, 82001]
'
,
'
["https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067", "https://camo.githubusercontent.com/5f5c4e0c4dc539c34e8eae8ac0cbc6dccdfee5d3/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343533333831362d323032373434343231382e6a7067", "http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg"]
'
,
'
2017-02-08 08:06:11
'
);
INSERT INTO
"
sys
"
.
"
moment
"
VALUES
(
1531969364022
,
'
APIJSON, let interfaces go to hell!
'
,
82001
,
'
[82001, 1532188114543, 1534926301956]
'
,
'
["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]
'
,
'
2018-07-19 11:02:44
'
);
INSERT INTO
"
sys
"
.
"
moment
"
VALUES
(
1512314438990
,
'
APIJSON iOS-Swift版发布，自动生成请求代码,欢迎使用^_^ https://github.com/TommyLemon/APIJSON
'
,
38710
,
'
[82001, 82002, 70793, 1512531601485]
'
,
'
["https://images2018.cnblogs.com/blog/660067/201712/660067-20171203231829476-1202860128.jpg"]
'
,
'
2017-12-03 23:20:38
'
);
COMMIT
;
--
----------------------------
--
Primary Key structure for table apijson_user
--
----------------------------
ALTER
TABLE
"
sys
"
.
"
apijson_user
"
ADD
CONSTRAINT
"
apijson_user_pkey
"
PRIMARY KEY
(
"
id
"
);
--
----------------------------
--
Primary Key structure for table moment
--
----------------------------
ALTER
TABLE
"
sys
"
.
"
moment
"
ADD
CONSTRAINT
"
moment_pkey
"
PRIMARY KEY
(
"
id
"
);
Back
|
FazBrowse Home
|
New Git URL