diff options
author | Martin v. L?wis <martin@v.loewis.de> | 2012-03-25 18:36:14 +0200 |
---|---|---|
committer | Martin v. L?wis <martin@v.loewis.de> | 2012-03-25 18:36:14 +0200 |
commit | af605d3157d7603c437e012f092b2766c12dde5e (patch) | |
tree | 89f235d35a908fecb02415b6f2af87ba4f1d0fcf /pkgbase_schema.sql | |
parent | 037cd32642b8fe7d5d37981501f9926167d7b2a1 (diff) | |
download | decorator-af605d3157d7603c437e012f092b2766c12dde5e.tar.gz |
Replace varchar2 with varchar. Closes #3 on https://bitbucket.org/loewis/pypi.
Diffstat (limited to 'pkgbase_schema.sql')
-rw-r--r-- | pkgbase_schema.sql | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/pkgbase_schema.sql b/pkgbase_schema.sql index edd3c3f..30dc206 100644 --- a/pkgbase_schema.sql +++ b/pkgbase_schema.sql @@ -321,27 +321,27 @@ CREATE TABLE oid_associations -- tables for the oauth library CREATE TABLE oauth_consumers ( - consumer varchar2(32) primary key, - secret varchar2(64) not null, + consumer varchar(32) primary key, + secret varchar(64) not null, date_created date not null, created_by TEXT REFERENCES users ON UPDATE CASCADE, last_modified date not null, - description varchar2(255) not null + description varchar(255) not null ); CREATE TABLE oauth_request_tokens ( - token varchar2(32) primary key, - secret varchar2(64) not null, - consumer varchar2(32) not null, + token varchar(32) primary key, + secret varchar(64) not null, + consumer varchar(32) not null, callback text, date_created date not null, user TEXT REFERENCES users ON UPDATE CASCADE ON DELETE CASCADE ); CREATE TABLE oauth_access_tokens ( - token varchar2(32) primary key, - secret varchar2(64) not null, - consumer varchar2(32) not null, + token varchar(32) primary key, + secret varchar(64) not null, + consumer varchar(32) not null, date_created date not null, last_modified date not null, user TEXT REFERENCES users ON UPDATE CASCADE ON DELETE CASCADE @@ -349,9 +349,9 @@ CREATE TABLE oauth_access_tokens ( CREATE TABLE oauth_nonce ( timestamp integer not null, - consumer varchar2(32) not null, - nonce varchar2(32) not null, - token varchar2(32) + consumer varchar(32) not null, + nonce varchar(32) not null, + token varchar(32) ); |