add database tables for foreign services

darcs-hash:20080819221214-84dde-15683b1e146b9e29064aa8ae04bc7daebfaf2e92.gz

4 files changed, 111 insertions, 0 deletions

diff --git a/classes/Foreign_service.php b/classes/Foreign_service.php
new file mode 100644
index 000000000..ec38c5417
--- /dev/null
+++ b/classes/Foreign_service.php
@@ -0,0 +1,24 @@
+<?php
+/**
+ * Table Definition for foreign_service
+ */
+require_once 'DB/DataObject.php';
+
+class Foreign_service extends DB_DataObject 
+{
+    ###START_AUTOCODE
+    /* the code below is auto generated do not remove the above tag */
+
+    public $__table = 'foreign_service';                 // table name
+    public $id;                              // int(4)  primary_key not_null
+    public $name;                            // varchar(32)  unique_key not_null
+    public $description;                     // varchar(255)  
+    public $created;                         // datetime()   not_null
+    public $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP
+
+    /* Static get */
+    function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('Foreign_service',$k,$v); }
+
+    /* the code above is auto generated do not remove the tag below */
+    ###END_AUTOCODE
+}
diff --git a/classes/Foreign_subscription.php b/classes/Foreign_subscription.php
new file mode 100644
index 000000000..b8cbed8ca
--- /dev/null
+++ b/classes/Foreign_subscription.php
@@ -0,0 +1,23 @@
+<?php
+/**
+ * Table Definition for foreign_subscription
+ */
+require_once 'DB/DataObject.php';
+
+class Foreign_subscription extends DB_DataObject 
+{
+    ###START_AUTOCODE
+    /* the code below is auto generated do not remove the above tag */
+
+    public $__table = 'foreign_subscription';            // table name
+    public $service;                         // int(4)  primary_key not_null
+    public $subscriber;                      // int(4)  primary_key not_null
+    public $subscribed;                      // int(4)  primary_key not_null
+    public $created;                         // datetime()   not_null
+
+    /* Static get */
+    function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('Foreign_subscription',$k,$v); }
+
+    /* the code above is auto generated do not remove the tag below */
+    ###END_AUTOCODE
+}
diff --git a/classes/Foreign_user.php b/classes/Foreign_user.php
new file mode 100644
index 000000000..98034df49
--- /dev/null
+++ b/classes/Foreign_user.php
@@ -0,0 +1,27 @@
+<?php
+/**
+ * Table Definition for foreign_user
+ */
+require_once 'DB/DataObject.php';
+
+class Foreign_user extends DB_DataObject 
+{
+    ###START_AUTOCODE
+    /* the code below is auto generated do not remove the above tag */
+
+    public $__table = 'foreign_user';                    // table name
+    public $id;                              // int(4)  primary_key not_null
+    public $service;                         // int(4)  primary_key not_null
+    public $uri;                             // varchar(255)  unique_key not_null
+    public $nickname;                        // varchar(255)  
+    public $user_id;                         // int(4)  
+    public $credentials;                     // varchar(255)  
+    public $created;                         // datetime()   not_null
+    public $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP
+
+    /* Static get */
+    function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('Foreign_user',$k,$v); }
+
+    /* the code above is auto generated do not remove the tag below */
+    ###END_AUTOCODE
+}
diff --git a/classes/stoica.ini b/classes/stoica.ini
index 8a21d33ce..4dead9610 100644
--- a/classes/stoica.ini
+++ b/classes/stoica.ini
@@ -47,6 +47,43 @@ modified = 384
 notice_id = K
 user_id = K
 
+[foreign_service]
+id = 129
+name = 130
+description = 2
+created = 142
+modified = 384
+
+[foreign_service__keys]
+id = K
+name = U
+
+[foreign_subscription]
+service = 129
+subscriber = 129
+subscribed = 129
+created = 142
+
+[foreign_subscription__keys]
+service = K
+subscriber = K
+subscribed = K
+
+[foreign_user]
+id = 129
+service = 129
+uri = 130
+nickname = 2
+user_id = 1
+credentials = 2
+created = 142
+modified = 384
+
+[foreign_user__keys]
+id = K
+service = K
+uri = U
+
 [nonce]
 consumer_key = 130
 tok = 130