-- 
-- Table structure for table `cdb_savepoint`
-- 

CREATE TABLE IF NOT EXISTS cdb_savepoint (
  `svp_id` int(10) unsigned NOT NULL auto_increment,
  `svp_uid` int(10) unsigned NOT NULL default '0',
  `svp_url` varchar(255) NOT NULL default '',
  `svp_rank` int(10) unsigned NOT NULL default '0',
  `svp_created` int(10) unsigned NOT NULL default '0',
  `svp_lastupdated` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`svp_id`),
  KEY `INDEX_UID` (`svp_uid`),
  KEY `INDEX_URL` (`svp_url`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cdb_geo_usage_simple`
-- 

CREATE TABLE IF NOT EXISTS cdb_geo_usage_simple (
  `gus_geo` varchar(100) NOT NULL default 'earth',
  `gus_name_cn` varchar(100) NOT NULL default '΅ΨΗς',
  `gus_name_en` varchar(100) NOT NULL default 'Earth',
  `gus_hits` int(10) unsigned NOT NULL default '0',
  `gus_lastupdated` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gus_geo`),
  UNIQUE KEY `INDEX_NAME_CN` (`gus_name_cn`),
  UNIQUE KEY `INDEX_NAME_EN` (`gus_name_en`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cdb_geo_going`
-- 

CREATE TABLE IF NOT EXISTS cdb_geo_going (
  `ggg_id` int(10) unsigned NOT NULL auto_increment,
  `ggg_uid` int(10) unsigned NOT NULL default '0',
  `ggg_geo` varchar(100) NOT NULL,
  `ggg_impression` text,
  `ggg_created` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ggg_id`),
  KEY `INDEX_UID` (`ggg_uid`),
  KEY `INDEX_GEO` (`ggg_geo`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cdb_geo_been`
-- 

CREATE TABLE IF NOT EXISTS cdb_geo_been (
  `gbn_id` int(10) unsigned NOT NULL auto_increment,
  `gbn_uid` int(10) unsigned NOT NULL default '0',
  `gbn_geo` varchar(100) NOT NULL,
  `gbn_impression` text,
  `gbn_created` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gbn_id`),
  KEY `INDEX_UID` (`gbn_uid`),
  KEY `INDEX_GEO` (`gbn_geo`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cdb_plugin_now`
-- 

CREATE TABLE IF NOT EXISTS cdb_plugin_now (
  `vid` mediumint(8) NOT NULL auto_increment,
  `dateline` int(10) NOT NULL default '0',
  `author` varchar(15) NOT NULL default '',
  `authorid` mediumint(8) NOT NULL default '0',
  `content` varchar(250) NOT NULL default '',
  `background` varchar(35) NOT NULL default '',
  `icons` int(2) NOT NULL default '0',
  PRIMARY KEY  (`vid`),
  KEY `authorid` (`authorid`),
  KEY `author` (`author`),
  KEY `dateline` (`dateline`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cdb_plugin_now_stats`
-- 

CREATE TABLE IF NOT EXISTS cdb_plugin_now_stats (
  `uid` mediumint(8) NOT NULL default '0',
  `total` int(10) NOT NULL default '0',
  `monthly` int(10) NOT NULL default '0',
  `weekly` int(10) NOT NULL default '0',
  `daily` mediumtext NOT NULL,
  `firstupdate` int(10) NOT NULL default '0',
  `lastupdate` int(10) NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cdb_expense`
-- 

CREATE TABLE IF NOT EXISTS cdb_expense (
  `exp_id` int(10) unsigned NOT NULL auto_increment,
  `exp_uid` int(10) unsigned NOT NULL default '0',
  `exp_amount` double NOT NULL default '0',
  `exp_type` int(10) unsigned NOT NULL default '0',
  `exp_memo` text,
  `exp_created` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`exp_id`),
  KEY `INDEX_UID` (`exp_uid`),
  KEY `INDEX_TYPE` (`exp_type`),
  KEY `INDEX_CREATED` (`exp_created`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cdb_plugin_tod_projecte`
-- 

CREATE TABLE IF NOT EXISTS cdb_plugin_tod_project (
  `tpr_id` int(10) unsigned NOT NULL auto_increment,
  `tpr_uid` int(10) unsigned NOT NULL default '0',
  `tpr_private` int(10) unsigned NOT NULL default '0',
  `tpr_title` varchar(100) NOT NULL default '',
  `tpr_progress` int(10) unsigned NOT NULL default '0',
  `tpr_type` int(10) unsigned NOT NULL default '0',
  `tpr_tasks` int(10) unsigned NOT NULL default '0',
  `tpr_notes` int(10) unsigned NOT NULL default '0',
  `tpr_dbs` int(10) unsigned NOT NULL default '0',
  `tpr_created` int(10) unsigned NOT NULL default '0',
  `tpr_lastupdated` int(10) unsigned NOT NULL default '0',
  `tpr_lasttouched` int(10) unsigned NOT NULL default '0',
  `tpr_completed` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tpr_id`),
  KEY `INDEX_UID` (`tpr_uid`),
  KEY `INDEX_PRIVATE` (`tpr_private`),
  KEY `INDEX_PROGRESS` (`tpr_progress`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cdb_plugin_tod_task`
-- 

CREATE TABLE IF NOT EXISTS cdb_plugin_tod_task (
  `tta_id` int(10) unsigned NOT NULL auto_increment,
  `tta_uid` int(10) unsigned NOT NULL default '0',
  `tta_pid` int(10) unsigned NOT NULL default '0',
  `tta_title` varchar(100) NOT NULL default '',
  `tta_level` int(10) unsigned NOT NULL default '0',
  `tta_todo` int(1) unsigned NOT NULL default '0',
  `tta_progress` int(10) unsigned NOT NULL default '0',
  `tta_created` int(10) unsigned NOT NULL default '0',
  `tta_lastupdated` int(10) unsigned NOT NULL default '0',
  `tta_lasttouched` int(10) unsigned NOT NULL default '0',
  `tta_completed` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tta_id`),
  KEY `INDEX_UID` (`tta_uid`),
  KEY `INDEX_PID` (`tta_pid`),
  KEY `INDEX_PROGRESS` (`tta_progress`)
) TYPE=MyISAM;


CREATE TABLE IF NOT EXISTS cdb_plugin_tod_note (
  `note_id` int(10) unsigned NOT NULL auto_increment,
  `note_hash` varchar(8) NOT NULL,
  `note_uid` int(10) unsigned NOT NULL default '0',
  `note_private` int(10) unsigned NOT NULL default '0',
  `note_message` mediumtext NOT NULL,
  `note_created` int(10) unsigned NOT NULL default '0',
  `note_lastupdated` int(10) unsigned NOT NULL default '0',
  `note_lasttouched` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`note_id`),
  KEY `INDEX_UID` (`note_uid`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cdb_channel`
-- 
CREATE TABLE IF NOT EXISTS cdb_channel (
  `chl_id` int(10) unsigned NOT NULL auto_increment,
  `chl_uid` int(10) NOT NULL,
  `chl_fid` int(10) unsigned NOT NULL default '0',
  `chl_title` varchar(200) NOT NULL default '',
  `chl_url` varchar(200) NOT NULL default '',
  `chl_dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`chl_id`),
  KEY `INDEX_fID` (`chl_fid`),
  KEY `INDEX_TITLE` (`chl_title`),
  KEY `INDEX_URL` (`chl_url`)
) TYPE=MyISAM;