From a15034bea561c778207c899d5893dbf6bfc3b637 Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@controlyourself.ca>
Date: Wed, 22 Oct 2008 16:36:00 -0400
Subject: [PATCH] notice inbox

darcs-hash:20081022203600-5ed1f-344e77e348655806a27db2de043b55ba67afc73a.gz
---
 classes/Notice_inbox.php | 22 ++++++++++++++++++++++
 classes/laconica.ini     |  9 +++++++++
 db/laconica.sql          | 10 ++++++++++
 3 files changed, 41 insertions(+)
 create mode 100644 classes/Notice_inbox.php

diff --git a/classes/Notice_inbox.php b/classes/Notice_inbox.php
new file mode 100644
index 0000000000..3d838a7b08
--- /dev/null
+++ b/classes/Notice_inbox.php
@@ -0,0 +1,22 @@
+<?php
+/**
+ * Table Definition for notice_inbox
+ */
+require_once 'classes/Memcached_DataObject';
+
+class Notice_inbox extends Memcached_DataObject 
+{
+    ###START_AUTOCODE
+    /* the code below is auto generated do not remove the above tag */
+
+    public $__table = 'notice_inbox';                    // table name
+    public $user_id;                         // int(4)  primary_key not_null
+    public $notice_id;                       // int(4)  primary_key not_null
+    public $source;                          // tinyint(1)   default_1
+
+    /* Static get */
+    function staticGet($k,$v=NULL) { return Memcached_DataObject::staticGet('Notice_inbox',$k,$v); }
+
+    /* the code above is auto generated do not remove the tag below */
+    ###END_AUTOCODE
+}
diff --git a/classes/laconica.ini b/classes/laconica.ini
index c74cd9ccee..15055c12ef 100644
--- a/classes/laconica.ini
+++ b/classes/laconica.ini
@@ -152,6 +152,15 @@ source = 2
 [notice__keys]
 id = N
 
+[notice_inbox]
+user_id = 129
+notice_id = 129
+source = 17
+
+[notice_inbox__keys]
+user_id = K
+notice_id = K
+
 [notice_source]
 code = 130
 name = 130
diff --git a/db/laconica.sql b/db/laconica.sql
index ad4ae69830..f1d3a484f4 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -331,3 +331,13 @@ create table message (
     index message_to_idx (to_profile),
     index message_created_idx (created)
 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
+
+create table notice_inbox (
+
+    user_id integer not null comment 'user receiving the message' references user (id),
+    notice_id integer not null comment 'notice received' references notice (id),
+    source tinyint default 1 comment 'reason it is in the inbox; 1=subscription',
+    
+    constraint primary key (user_id, notice_id),
+    index notice_inbox_notice_id_idx (notice_id)
+) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
-- 
2.39.5