source: trunk/_InstallationResources/ombookmarks.sql @ 424

-- omCollab MySQL Dump

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `{ombookmarks_database_name}`
-- 

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

-- 
-- Table structure for table `{omcollab_db_table_prefix}bookmarks`
-- 

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}bookmarks`;
CREATE TABLE `{omcollab_db_table_prefix}bookmarks` (
  `bId` int(11) NOT NULL auto_increment,
  `uId` int(11) NOT NULL default '0',
  `bIp` varchar(40) default NULL,
  `bStatus` tinyint(1) NOT NULL default '0',
  `bDatetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `bModified` datetime NOT NULL default '0000-00-00 00:00:00',
  `bTitle` varchar(255) NOT NULL default '',
  `bAddress` text NOT NULL,
  `bDescription` varchar(255) default NULL,
  `bHash` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`bId`),
  KEY `{omcollab_db_table_prefix}bookmarks_usd` (`uId`,`bStatus`,`bDatetime`),
  KEY `{omcollab_db_table_prefix}bookmarks_hui` (`bHash`,`uId`,`bId`),
  KEY `{omcollab_db_table_prefix}bookmarks_du` (`bDatetime`,`uId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=130 ;

-- 
-- Dumping data for table `{omcollab_db_table_prefix}bookmarks`
-- 

INSERT INTO `{omcollab_db_table_prefix}bookmarks` (`bId`, `uId`, `bIp`, `bStatus`, `bDatetime`, `bModified`, `bTitle`, `bAddress`, `bDescription`, `bHash`) VALUES 
(127, 1, '127.0.0.1', 0, '2008-06-12 09:53:39', '2008-06-13 11:00:53', 'MIKE2.0 - an implementation of the omCollab application suite', 'http://mike2.openmethodology.org', 'This is the first site to use the omCollab application suite', 'e5e4b3f6980a0c09f60646a258f2954a'),
(129, 1, '127.0.0.1', 0, '2008-07-04 14:24:15', '2008-07-04 14:30:47', 'Example of SPAM bookmark', 'http://www.spam.com', 'Occasionally, you will get spammed. Read this bookmarks comments to learn how to manage it.', '4ff84ed87bfff74f86a7f37d37dce222');

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

-- 
-- Table structure for table `{omcollab_db_table_prefix}comments`
-- 

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}comments`;
CREATE TABLE `{omcollab_db_table_prefix}comments` (
  `cId` int(11) NOT NULL auto_increment,
  `cParentId` int(11) default NULL,
  `uId` int(11) NOT NULL,
  `cText` text NOT NULL,
  `cHash` varchar(32) NOT NULL,
  `cDatePosted` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`cId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `{omcollab_db_table_prefix}comments`
-- 

INSERT INTO `{omcollab_db_table_prefix}comments` (`cId`, `cParentId`, `uId`, `cText`, `cHash`, `cDatePosted`) VALUES 
(1, 0, 1, 'This is a sample comment', 'e5e4b3f6980a0c09f60646a258f2954a', '2008-06-13 12:24:02'),
(2, 1, 1, 'This is a sample reply', 'e5e4b3f6980a0c09f60646a258f2954a', '2008-06-13 12:24:18'),
(3, 0, 1, 'When you are logged in as a user with admin rights, you may delete any bookmark by clicking the ''Delete Spam Bookmark'' link on the main bookmark page. This permanently deletes all bookmarks sharing that URL (and related comments and ratings).', '4ff84ed87bfff74f86a7f37d37dce222', '2008-07-04 15:27:50');

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

-- 
-- Table structure for table `{omcollab_db_table_prefix}ratings`
-- 

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}ratings`;
CREATE TABLE `{omcollab_db_table_prefix}ratings` (
  `rId` int(11) NOT NULL auto_increment,
  `uId` int(11) NOT NULL,
  `rValue` int(11) NOT NULL,
  `rHash` varchar(32) NOT NULL,
  `rDateRated` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`rId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `{omcollab_db_table_prefix}ratings`
-- 

INSERT INTO `{omcollab_db_table_prefix}ratings` (`rId`, `uId`, `rValue`, `rHash`, `rDateRated`) VALUES 
(1, 1, 5, 'e5e4b3f6980a0c09f60646a258f2954a', '2008-06-13 11:41:53'),
(3, 1, 5, '4ff84ed87bfff74f86a7f37d37dce222', '2008-07-04 15:30:23');

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

-- 
-- Table structure for table `{omcollab_db_table_prefix}tags`
-- 

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}tags`;
CREATE TABLE `{omcollab_db_table_prefix}tags` (
  `id` int(11) NOT NULL auto_increment,
  `bId` int(11) NOT NULL default '0',
  `tag` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `{omcollab_db_table_prefix}tags_tag_bId` (`tag`,`bId`),
  KEY `{omcollab_db_table_prefix}tags_bId` (`bId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=321 ;

-- 
-- Dumping data for table `{omcollab_db_table_prefix}tags`
-- 

INSERT INTO `{omcollab_db_table_prefix}tags` (`id`, `bId`, `tag`) VALUES 
(316, 127, 'omcollab examples'),
(319, 129, 'spam spam spam'),
(320, 129, 'omcollab examples');

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

-- 
-- Table structure for table `{omcollab_db_table_prefix}users`
-- 

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}users`;
CREATE TABLE `{omcollab_db_table_prefix}users` (
  `uId` int(11) NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `uDatetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `uModified` datetime NOT NULL default '0000-00-00 00:00:00',
  `name` varchar(50) default NULL,
  `email` varchar(50) NOT NULL default '',
  `homepage` varchar(255) default NULL,
  `uContent` text,
  `uIsAdmin` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`uId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `{omcollab_db_table_prefix}users`
-- 

INSERT INTO `{omcollab_db_table_prefix}users` (`uId`, `username`, `password`, `uDatetime`, `uModified`, `name`, `email`, `homepage`, `uContent`, `uIsAdmin`) VALUES 
(1, 'Admin', '5f4dcc3b5aa765d61d8327deb882cf99', '2008-06-06 00:00:00', '2008-06-06 00:00:00', 'Admin', '', NULL, NULL, 1);

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

-- 
-- Table structure for table `{omcollab_db_table_prefix}watched`
-- 

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}watched`;
CREATE TABLE `{omcollab_db_table_prefix}watched` (
  `wId` int(11) NOT NULL auto_increment,
  `uId` int(11) NOT NULL default '0',
  `watched` int(11) NOT NULL default '0',
  PRIMARY KEY  (`wId`),
  KEY `{omcollab_db_table_prefix}watched_uId` (`uId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `{omcollab_db_table_prefix}watched`
--