-- SVN FILE: $Id: blob.sql 434 2008-05-20 08:47:51Z bb_yujiro $
--
-- SQLite用バイナリオブジェクトテーブル定義
--
-- PHP versions 5
--
--      Hitsuji : Social Network Service <http://rakuto.net/rktSNS/>
--      Copyright (c) 2007 Yujiro Takahashi
--
-- Licensed under The MIT License
-- Redistributions of files must retain the above copyright notice.
--
-- @filesource
-- @copyright       Copyright (c) 2007 Yujiro Takahashi
-- @link            http://rakuto.net/
-- @author          Yujiro Takahashi <yujiro@rakuto.net>
-- @package         rktFW
-- @version         $Revision: 434 $
-- @modifiedby      $LastChangedBy: bb_yujiro $
-- @lastmodified    $Date: 2008-05-20 17:47:51 +0900 (火, 20 5 2008) $
-- @license         http://opensource.org/licenses/mit-license.php The MIT License
-- --------------------------------------------------------

-- 
-- Binary Large OBject
-- 
CREATE TABLE 'sns_sys_blob' (
  'id' integer NOT NULL,
  'modified' timestamp NOT NULL,
  'regist_date' timestamp NOT NULL,
  'origin' varchar(64) NOT NULL,
  'name' varchar(128) NOT NULL,
  'mime_type' varchar(128) NOT NULL,
  'uid' integer NOT NULL,
  'gid' integer NOT NULL,
  'size' integer NOT NULL,
  'buffer' blob NOT NULL,
  PRIMARY KEY  ('id'),
  UNIQUE ('origin')
);
