Skip to content
Navigation Menu
Sign in
Products
Platform
GitHub
Repository hosting, code review, and collaboration
Copilot
AI coding agent for tasks, projects, and automated work
Build & Ship
Actions
CI/CD and automation
Code Quality
Quality analysis, fixes, and enforcement
Codespaces
Cloud development environments
Secure
Code Security
Vulnerability detection and remediation
Secret Protection
Secret scanning and leak prevention
All Features
Developers
Learn
Documentation
Training
Certifications
Build
Build with Copilot
Customize Copilot
Integrations
Explore
Trending repos
GitHub Sponsors
Developer articles
Changelog
Changelog
Your source for the latest features, improvements, and fixes across GitHub products, all in one place.
Businesses
By Stage
Enterprises
Team
Startups
Nonprofits
By Industry
Healthcare
Financial services
Manufacturing
Government
See all industries
Evaluate GitHub
Why GitHub
Customer Stories
Business insights
Trust Center
Add-ons
GitHub Advanced Security
Enterprise-grade code security
Copilot for business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Resources
Learn & Connect
Documentation
Resource center
Blog
Events & webinars
Community Forum
Customer Stories
Integrations
Support
Customer support
Training
GitHub Status
Company
About
Partners
Changelog
GitHub Universe
GitHub Universe
The event for developers, by developers — talks, workshops, and what’s next for GitHub.
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
bulejava
coder
Repository navigation
Code
Issues
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
More
items
Files
Expand file tree
master
Breadcrumbs
coder
/
modules
/
orm
/
auth-schema-postgresql.sql
Copy path
Blame
More file actions
Blame
More file actions
Latest commit
History
History
History
executable file
·
53 lines (46 loc) · 1.56 KB
master
Breadcrumbs
coder
/
modules
/
orm
/
auth-schema-postgresql.sql
Copy path
Top
File metadata and controls
Code
Blame
executable file
·
53 lines (46 loc) · 1.56 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
CREATE
TABLE
roles
(
id
serial
,
"
name
"
varchar
(
32
)
NOT NULL
,
description
text
NOT NULL
,
CONSTRAINT
roles_id_pkey
PRIMARY KEY
(id),
CONSTRAINT
roles_name_key UNIQUE (name)
);
CREATE
TABLE
roles_users
(
user_id
integer
,
role_id
integer
);
CREATE
TABLE
users
(
id
serial
,
email
varchar
(
254
)
NOT NULL
,
username
varchar
(
32
)
NOT NULL
,
"
password
"
varchar
(
64
)
NOT NULL
,
logins
integer
NOT NULL
DEFAULT
0
,
last_login
integer
,
CONSTRAINT
users_id_pkey
PRIMARY KEY
(id),
CONSTRAINT
users_username_key UNIQUE (username),
CONSTRAINT
users_email_key UNIQUE (email),
CONSTRAINT
users_logins_check
CHECK
(logins
>=
0
)
);
CREATE
TABLE
user_tokens
(
id
serial
,
user_id
integer
NOT NULL
,
user_agent
varchar
(
40
)
NOT NULL
,
token
character varying
(
32
)
NOT NULL
,
created
integer
NOT NULL
,
expires
integer
NOT NULL
,
CONSTRAINT
user_tokens_id_pkey
PRIMARY KEY
(id),
CONSTRAINT
user_tokens_token_key UNIQUE (token)
);
CREATE
INDEX
user_id_idx
ON
roles_users (user_id);
CREATE
INDEX
role_id_idx
ON
roles_users (role_id);
ALTER
TABLE
roles_users
ADD
CONSTRAINT
user_id_fkey
FOREIGN KEY
(user_id)
REFERENCES
users(id)
ON DELETE CASCADE
,
ADD
CONSTRAINT
role_id_fkey
FOREIGN KEY
(role_id)
REFERENCES
roles(id)
ON DELETE CASCADE
;
ALTER
TABLE
user_tokens
ADD
CONSTRAINT
user_id_fkey
FOREIGN KEY
(user_id)
REFERENCES
users(id)
ON DELETE CASCADE
;
INSERT INTO
roles (name, description)
VALUES
(
'
login
'
,
'
Login privileges, granted after account confirmation
'
);
INSERT INTO
roles (name, description)
VALUES
(
'
admin
'
,
'
Administrative user, has access to everything.
'
);
You can’t perform that action at this time.