diff options
| author | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-03-07 17:58:11 +0000 |
|---|---|---|
| committer | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-03-07 17:58:11 +0000 |
| commit | 06bca872ab35a415621f75601c3c5fe8824ebb5d (patch) | |
| tree | 3ab73f5381873c8c9c718dce6eb352f94d3818b0 /engine/schema/mysql.sql | |
| parent | 4318e9697253546e8bb4f76166ac92ee6918e94e (diff) | |
| download | elgg-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.sql | 29 |
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 |