diff options
| -rw-r--r-- | classes/Notice.php | 1 | ||||
| -rw-r--r-- | classes/Notice_source.php | 24 | ||||
| -rw-r--r-- | classes/stoica.ini | 11 | ||||
| -rw-r--r-- | db/laconica.sql | 9 |
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), |