aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
diff options
context:
space:
mode:
authoricewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-03-07 17:58:11 +0000
committericewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-03-07 17:58:11 +0000
commit06bca872ab35a415621f75601c3c5fe8824ebb5d (patch)
tree3ab73f5381873c8c9c718dce6eb352f94d3818b0 /engine/schema/mysql.sql
parent4318e9697253546e8bb4f76166ac92ee6918e94e (diff)
downloadelgg-06bca872ab35a415621f75601c3c5fe8824ebb5d.tar.gz
elgg-06bca872ab35a415621f75601c3c5fe8824ebb5d.tar.bz2
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
Diffstat (limited to 'engine/schema/mysql.sql')
-rw-r--r--engine/schema/mysql.sql29
1 files changed, 29 insertions, 0 deletions
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