diff options
Diffstat (limited to 'www/wiki/extensions/OATHAuth/sql/mssql/tables.sql')
| -rw-r--r-- | www/wiki/extensions/OATHAuth/sql/mssql/tables.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/www/wiki/extensions/OATHAuth/sql/mssql/tables.sql b/www/wiki/extensions/OATHAuth/sql/mssql/tables.sql new file mode 100644 index 00000000..f4db281c --- /dev/null +++ b/www/wiki/extensions/OATHAuth/sql/mssql/tables.sql @@ -0,0 +1,10 @@ +CREATE TABLE /*_*/oathauth_users ( + -- User ID + id INT NOT NULL PRIMARY KEY IDENTITY(0,1), + + -- Secret key + secret NVARCHAR(255) NULL DEFAULT NULL, + + -- Scratch tokens + scratch_tokens varbinary(511) NULL DEFAULT NULL +); |