CREATE TABLE oauth_consumers ( consumer_id INT NOT NULL, editor_id INT NOT NULL, name VARCHAR(20) NOT NULL, fullname VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, ckey VARCHAR(50) NOT NULL, csecret VARCHAR(50) NOT NULL, datecreated TIMESTAMP NOT NULL ) ALTER TABLE oauth_consumers ADD CONSTRAINT PK_oauth_consumers PRIMARY KEY (consumer_id) CREATE TABLE oauth_tokens ( tkey VARCHAR(50) NOT NULL, consumer_id INT NOT NULL, type VARCHAR(10), tsecret VARCHAR(50), nonce VARCHAR(50), time_stamp TIMESTAMP ) CREATE INDEX IDX_oautt_consumer_id ON oauth_tokens ( consumer_id ) ALTER TABLE oauth_tokens ADD CONSTRAINT PK_oauth_tokens PRIMARY KEY (tkey) ALTER TABLE oauth_tokens ADD CONSTRAINT FK_oautc_oautt FOREIGN KEY (consumer_id) REFERENCES oauth_consumers (consumer_id) ON DELETE CASCADE ON UPDATE CASCADE; CREATE TABLE oauth_consumers ( consumer_ID int NOT NULL, editor_ID int NOT NULL, name nvarchar(20) NOT NULL, fullname nvarchar(50) NOT NULL, email nvarchar(50) NOT NULL, ckey nvarchar(50) NOT NULL, csecret nvarchar(50) NOT NULL, datecreated datetime NOT NULL ) ALTER TABLE oauth_consumers ADD CONSTRAINT PK_oauth_consumers PRIMARY KEY CLUSTERED ( consumer_ID ASC) CREATE TABLE oauth_tokens ( tkey nvarchar(50) NOT NULL, consumer_ID int NOT NULL, type varchar(10) NULL, tsecret nvarchar(50) NULL, nonce nvarchar(50) NULL, time_stamp datetime NULL ) CREATE INDEX IDX_oautt_consumer_ID ON oauth_tokens ( consumer_ID ASC ) ALTER TABLE oauth_tokens ADD CONSTRAINT PK_oauth_tokens PRIMARY KEY CLUSTERED (tkey ASC) ALTER TABLE oauth_tokens ADD CONSTRAINT FK_oautc_oautt FOREIGN KEY (consumer_ID) REFERENCES oauth_consumers (consumer_ID) ON DELETE CASCADE ON UPDATE CASCADE CREATE TABLE oauth_consumers ( consumer_ID INTEGER NOT NULL, editor_ID INTEGER NOT NULL, name NVARCHAR2(20) NOT NULL, fullname NVARCHAR2(50) NOT NULL, email NVARCHAR2(50) NOT NULL, ckey NVARCHAR2(50) NOT NULL, csecret NVARCHAR2(50) NOT NULL, datecreated DATE NOT NULL ) ALTER TABLE oauth_consumers ADD CONSTRAINT PK_oauth_consumers PRIMARY KEY (consumer_ID) CREATE TABLE oauth_tokens ( tkey NVARCHAR2(50) NOT NULL, consumer_ID INTEGER NOT NULL, type VARCHAR2(10) NULL, tsecret NVARCHAR2(50) NULL, nonce NVARCHAR2(50) NULL, time_stamp DATE NULL ) CREATE INDEX IDX_oautt_consumer_ID ON oauth_tokens ( consumer_ID ASC ) ALTER TABLE oauth_tokens ADD CONSTRAINT PK_oauth_tokens PRIMARY KEY (tkey) ALTER TABLE oauth_tokens ADD CONSTRAINT FK_oautc_oautt FOREIGN KEY (consumer_ID) REFERENCES oauth_consumers (consumer_ID) ON DELETE CASCADE