summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-08-13 10:26:37 -0400
committerEvan Prodromou <evan@prodromou.name>2008-08-13 10:26:37 -0400
commit47d15bc662c0bf160f895640b882e92a56c34208 (patch)
treed2a1be2079ffd3b8d3d735f559c907fb532925de
parentc9d9ecffd45143a1214aafb5fab5c6f040c2250e (diff)
first step towards adding favorites to the system
darcs-hash:20080813142637-84dde-9530d153eceb6bbedbb692755aa5c96d65d8e071.gz
-rw-r--r--classes/Fave.php22
-rw-r--r--classes/stoica.ini9
-rw-r--r--classes/stoica.links.ini4
-rw-r--r--db/laconica.sql13
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 (