File: tables.sql

package info (click to toggle)
mediawiki 1%3A1.31.16-1%2Bdeb10u2
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 174,400 kB
  • sloc: php: 475,610; javascript: 366,085; sql: 14,033; python: 4,042; xml: 1,953; ruby: 1,076; pascal: 925; perl: 789; sh: 529; makefile: 162
file content (15 lines) | stat: -rw-r--r-- 351 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
define mw_prefix='{$wgDBprefix}';

CREATE SEQUENCE oathauth_users_id_seq;
CREATE TABLE &mw_prefix.oathauth_users (
	-- User ID
	id NUMBER NOT NULL,

	-- Secret key
	secret VARCHAR2(255) NULL,

	-- Scratch tokens
	scratch_tokens varbinary(511) NULL

);
ALTER TABLE &mw_prefix.oathauth_users ADD CONSTRAINT &mw_prefix.oathauth_users_pk PRIMARY KEY (id);