From 06bca872ab35a415621f75601c3c5fe8824ebb5d Mon Sep 17 00:00:00 2001 From: icewing Date: Fri, 7 Mar 2008 17:58:11 +0000 Subject: Marcus Povey * Initial work on API git-svn-id: https://code.elgg.org/elgg/trunk@106 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) (limited to 'engine/schema') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index 1361f7ebc..2ce3f71e4 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -185,3 +185,32 @@ CREATE TABLE `prefix_metadata` ( UNIQUE KEY (`object_id`,`object_type`, `name`) ) ENGINE=MyISAM; + +-- +-- API Users - Users who have access to the api (may not be real users) +-- +CREATE TABLE api_users ( + id int(11) auto_increment, + + email_address varchar(128), + + api_key varchar(40), + secret varchar(40) NOT NULL, + active int default 1, + + unique key (email_address), + unique key (api_key), + primary key (id) +); + +-- +-- Configuration settings +-- +CREATE TABLE configuration ( + id int(11) NOT NULL auto_increment, + name varchar(50) not null default '', + `value` varchar(255) not null default '', + + primary key (id), + unique key (name) +); \ No newline at end of file -- cgit v1.2.3