diff options
| author | Evan Prodromou <evan@prodromou.name> | 2008-07-22 10:16:14 -0400 |
|---|---|---|
| committer | Evan Prodromou <evan@prodromou.name> | 2008-07-22 10:16:14 -0400 |
| commit | e1361cdf489fc87aecb84261c5e2b7b47ce9c829 (patch) | |
| tree | 294c5be88c17119c24d148603e37782adcc38b5a | |
| parent | 1cc71d0684360b0a7e6cf7bf966dd5ff7fcf5386 (diff) | |
mark notices as local
darcs-hash:20080722141614-84dde-b80c6945fdb90a5f67acaba65a1e4c2b306b1f8e.gz
| -rw-r--r-- | classes/Notice.php | 1 | ||||
| -rw-r--r-- | classes/stoica.ini | 1 | ||||
| -rw-r--r-- | db/laconica.sql | 5 |
3 files changed, 6 insertions, 1 deletions
diff --git a/classes/Notice.php b/classes/Notice.php index a00114f95..1d157b8a0 100644 --- a/classes/Notice.php +++ b/classes/Notice.php @@ -39,6 +39,7 @@ class Notice extends DB_DataObject public $created; // datetime() not_null public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP public $reply_to; // int(4) + public $is_local; // tinyint(1) /* Static get */ function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('Notice',$k,$v); } diff --git a/classes/stoica.ini b/classes/stoica.ini index 99196909e..1fa0a333f 100644 --- a/classes/stoica.ini +++ b/classes/stoica.ini @@ -61,6 +61,7 @@ url = 2 created = 142 modified = 384 reply_to = 1 +is_local = 17 [notice__keys] id = N diff --git a/db/laconica.sql b/db/laconica.sql index 66510b148..b6de405f9 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -100,8 +100,11 @@ create table notice ( created datetime not null comment 'date this record was created', 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', + index notice_profile_id_idx (profile_id), + index notice_created_idx (profile_id), + FULLTEXT(content) ) ENGINE=MyISAM; |