first step towards adding favorites to the system

darcs-hash:20080813142637-84dde-9530d153eceb6bbedbb692755aa5c96d65d8e071.gz

4 files changed, 48 insertions, 0 deletions

diff --git a/classes/Fave.php b/classes/Fave.php
new file mode 100644
index 000000000..bbd72ca0b
--- /dev/null
+++ b/classes/Fave.php
@@ -0,0 +1,22 @@
+<?php
+/**
+ * Table Definition for fave
+ */
+require_once 'DB/DataObject.php';
+
+class Fave extends DB_DataObject 
+{
+    ###START_AUTOCODE
+    /* the code below is auto generated do not remove the above tag */
+
+    public $__table = 'fave';                            // table name
+    public $notice_id;                       // int(4)  primary_key not_null
+    public $user_id;                         // int(4)  primary_key not_null
+    public $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP
+
+    /* Static get */
+    function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('Fave',$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 3f75f369e..8a21d33ce 100644
--- a/classes/stoica.ini
+++ b/classes/stoica.ini
@@ -38,6 +38,15 @@ modified = 384
 [consumer__keys]
 consumer_key = K
 
+[fave]
+notice_id = 129
+user_id = 129
+modified = 384
+
+[fave__keys]
+notice_id = K
+user_id = K
+
 [nonce]
 consumer_key = 130
 tok = 130
diff --git a/classes/stoica.links.ini b/classes/stoica.links.ini
index bb849cbf2..173b18726 100644
--- a/classes/stoica.links.ini
+++ b/classes/stoica.links.ini
@@ -37,3 +37,7 @@ notice_id = notice:id
 [subscription]
 subscriber = profile:id
 subscribed = profile:id
+
+[fave]
+notice_id = notice:id
+user_id = user:id
diff --git a/db/laconica.sql b/db/laconica.sql
index 69dd4644f..e9ed0edb8 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -134,6 +134,19 @@ create table reply (
 
 ) ENGINE=MyISAM;
 
+create table fave (
+
+    notice_id integer not null comment 'notice that is the favorite' references notice (id),
+    user_id integer not null comment 'user who likes this notice' references user (id),
+    modified timestamp not null comment 'date this record was modified',
+
+    constraint primary key (notice_id, user_id),
+    index fave_notice_id_idx (notice_id),
+    index fave_user_id_idx (user_id),
+    index fave_modified_idx (modified)
+    
+) ENGINE=MyISAM;
+
 /* tables for OAuth */
 
 create table consumer (