• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Stop wasting time looking for files and revisions. Connect your Gmail, DriveDropbox, and Slack accounts and in less than 2 minutes, Dokkio will automatically organize all your file attachments. Learn more and claim your free account.

View
 

ImplementationNotes

Page history last edited by Leah Culver 12 years, 6 months ago

Implementation Notes

 

Pownce Database Tables

Contact: leah@pownce.com

Probably not the optimal design for these tables, but hey, here they are.

 

Request Token / Access Token

We have 2 different tables but they look identical.

 

id int(11) NO PRI NULL auto_increment
key varchar(32) NO UNI
secret varchar(32) NO
consumer_application_id int(11) NO MUL
user_id int(11) NO MUL
creation_date datetime NO

 

Consumer Application

 

id int(11) NO PRI NULL auto_increment
user_id int(11) NO MUL
key varchar(255) NO UNI
secret varchar(255) NO
consumer_type varchar(8) NO
callback_url varchar(255) YES NULL
status varchar(8) NO
status_reason varchar(255) YES NULL
ranking int(10) unsigned NO
is_featured tinyint(1) NO
name varchar(255) NO
developer_email varchar(75) NO
help_email varchar(75) NO
url varchar(255) NO
description longtext NO
photo_display_name varchar(255) YES NULL
orig_photo_key varchar(200) NO
large_photo_key varchar(200) NO
tos_accepted tinyint(1) NO
registration_date datetime NO
num_requests int(11) NO
last_request_date datetime NO

Comments (0)

You don't have permission to comment on this page.