From 06bca872ab35a415621f75601c3c5fe8824ebb5d Mon Sep 17 00:00:00 2001
From: icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Fri, 7 Mar 2008 17:58:11 +0000
Subject: Marcus Povey <marcus@dushka.co.uk> * 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/mysql.sql')

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

