add notice sources (currently unused)

darcs-hash:20080722164639-84dde-19c6300516443862da016120cf9eed40e5972b6d.gz

4 files changed, 45 insertions, 0 deletions

diff --git a/classes/Notice.php b/classes/Notice.php
index 1d157b8a0..1b9191ad6 100644
--- a/classes/Notice.php
+++ b/classes/Notice.php
@@ -40,6 +40,7 @@ class Notice extends DB_DataObject
     public $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP
     public $reply_to;                        // int(4)  
     public $is_local;                        // tinyint(1)  
+    public $source;                          // varchar(8)  
 
     /* Static get */
     function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('Notice',$k,$v); }
diff --git a/classes/Notice_source.php b/classes/Notice_source.php
new file mode 100644
index 000000000..cef2883b0
--- /dev/null
+++ b/classes/Notice_source.php
@@ -0,0 +1,24 @@
+<?php
+/**
+ * Table Definition for notice_source
+ */
+require_once 'DB/DataObject.php';
+
+class Notice_source extends DB_DataObject 
+{
+    ###START_AUTOCODE
+    /* the code below is auto generated do not remove the above tag */
+
+    public $__table = 'notice_source';                   // table name
+    public $code;                            // varchar(8)  primary_key not_null
+    public $name;                            // varchar(255)   not_null
+    public $url;                             // varchar(255)   not_null
+    public $created;                         // datetime()   not_null
+    public $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP
+
+    /* Static get */
+    function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('Notice_source',$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 1fa0a333f..aba79d11e 100644
--- a/classes/stoica.ini
+++ b/classes/stoica.ini
@@ -62,10 +62,21 @@ created = 142
 modified = 384
 reply_to = 1
 is_local = 17
+source = 2
 
 [notice__keys]
 id = N
 
+[notice_source]
+code = 130
+name = 130
+url = 130
+created = 142
+modified = 384
+
+[notice_source__keys]
+code = K
+
 [profile]
 id = 129
 nickname = 130
diff --git a/db/laconica.sql b/db/laconica.sql
index b6de405f9..4a09670a2 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -101,6 +101,7 @@ create table notice (
     modified timestamp comment 'date this record was modified',
     reply_to integer comment 'notice replied to (usually a guess)' references notice (id),
     is_local tinyint default 0 comment 'notice was generated by a user',
+    source varchar(8) comment 'source of comment, like "web", "im", or "clientname"',
     
     index notice_profile_id_idx (profile_id),
     index notice_created_idx (profile_id),
@@ -108,6 +109,14 @@ create table notice (
     FULLTEXT(content)
 ) ENGINE=MyISAM;
 
+create table notice_source (
+     code varchar(8) primary key not null comment 'source code',
+     name varchar(255) not null comment 'name of the source',
+     url varchar(255) not null comment 'url to link to',
+     created datetime not null comment 'date this record was created',
+     modified timestamp comment 'date this record was modified'
+) ENGINE=MyISAM;
+
 create table reply (
 
     notice_id integer not null comment 'notice that is the reply' references notice (id),