FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
ss-panel/sql/user.sql at master · python777/ss-panel · GitHub
python777
ss-panel
Repository navigation
Code
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Expand file tree
Breadcrumbs
ss-panel
/
sql
/
user.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
33 lines (30 loc) · 1.45 KB
Breadcrumbs
ss-panel
/
sql
/
user.sql
Copy path
File metadata and controls
33 lines (30 loc) · 1.45 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
SET
NAMES utf8;
SET
time_zone
=
'
+00:00
'
;
SET
foreign_key_checks
=
0
;
SET
sql_mode
=
'
NO_AUTO_VALUE_ON_ZERO
'
;
DROP
TABLE
IF EXISTS
`
user
`
;
CREATE
TABLE
`
user
` (
`
uid
`
int
(
11
)
NOT NULL
AUTO_INCREMENT,
`
user_name
`
varchar
(
128
) CHARACTER
SET
utf8mb4
NOT NULL
,
`
email
`
varchar
(
32
)
NOT NULL
,
`
pass
`
varchar
(
32
)
NOT NULL
,
`
passwd
`
varchar
(
16
)
NOT NULL
,
`
t
`
int
(
11
)
NOT NULL
DEFAULT
'
0
'
,
`
u
`
bigint
(
20
)
NOT NULL
,
`
d
`
bigint
(
20
)
NOT NULL
,
`
plan
`
varchar
(
2
) CHARACTER
SET
utf8mb4
NOT NULL
,
`
transfer_enable
`
bigint
(
20
)
NOT NULL
,
`
port
`
int
(
11
)
NOT NULL
,
`
switch
`
tinyint
(
4
)
NOT NULL
DEFAULT
'
1
'
,
`
enable
`
tinyint
(
4
)
NOT NULL
DEFAULT
'
1
'
,
`
type
`
tinyint
(
4
)
NOT NULL
DEFAULT
'
1
'
,
`
last_get_gift_time
`
int
(
11
)
NOT NULL
DEFAULT
'
0
'
,
`
last_check_in_time
`
int
(
11
)
NOT NULL
DEFAULT
'
0
'
,
`
last_rest_pass_time
`
int
(
11
)
NOT NULL
DEFAULT
'
0
'
,
`
reg_date
`
datetime
NOT NULL
,
`
invite_num
`
int
(
8
)
NOT NULL
,
`
money
`
decimal
(
12
,
2
)
NOT NULL
,
PRIMARY KEY
(
`
uid
`
)
) ENGINE
=
InnoDB DEFAULT CHARSET
=
utf8;
INSERT INTO
`
user
`
(
`
uid
`
,
`
user_name
`
,
`
email
`
,
`
pass
`
,
`
passwd
`
,
`
t
`
,
`
u
`
,
`
d
`
,
`
plan
`
,
`
transfer_enable
`
,
`
port
`
,
`
switch
`
,
`
enable
`
,
`
type
`
,
`
last_get_gift_time
`
,
`
last_check_in_time
`
,
`
last_rest_pass_time
`
,
`
reg_date
`
,
`
invite_num
`
,
`
money
`
)
VALUES
(
11
,
'
user1
'
,
'
user@msn.com
'
,
'
211e114055aeaf79e9b374819ab7d452
'
,
'
0000000
'
,
1420423709
,
25442965504
,
9583696025
,
'
A
'
,
347149959168
,
50000
,
1
,
1
,
7
,
0
,
1420386514
,
0
,
'
2014-11-07 00:00:00
'
,
0
,
0
);
Back
|
FazBrowse Home
|
New Git URL