source: trunk/_InstallationResources/omwiki_red.sql @ 1217

-- omCollab MySQL Dump

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `{omwiki_database_name}`
-- 


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}archive`;
CREATE TABLE `{omcollab_db_table_prefix}archive` (
  `ar_namespace` int(11) NOT NULL default '0',
  `ar_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `ar_text` mediumblob NOT NULL,
  `ar_comment` tinyblob NOT NULL,
  `ar_user` int(10) unsigned NOT NULL default '0',
  `ar_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
  `ar_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `ar_minor_edit` tinyint(4) NOT NULL default '0',
  `ar_flags` tinyblob NOT NULL,
  `ar_rev_id` int(10) unsigned default NULL,
  `ar_text_id` int(10) unsigned default NULL,
  `ar_deleted` tinyint(3) unsigned NOT NULL default '0',
  `ar_len` int(10) unsigned default NULL,
  `ar_page_id` int(10) unsigned default NULL,
  `ar_parent_id` int(10) unsigned DEFAULT NULL,
  KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`),
  KEY `usertext_timestamp` (`ar_user_text`,`ar_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}category` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `cat_pages` int(11) NOT NULL DEFAULT '0',
  `cat_subcats` int(11) NOT NULL DEFAULT '0',
  `cat_files` int(11) NOT NULL DEFAULT '0',
  `cat_hidden` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  UNIQUE KEY `cat_title` (`cat_title`),
  KEY `cat_pages` (`cat_pages`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}categorylinks`;
CREATE TABLE `{omcollab_db_table_prefix}categorylinks` (
  `cl_from` int(10) unsigned NOT NULL default '0',
  `cl_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `cl_sortkey` varchar(70) character set latin1 collate latin1_bin NOT NULL default '',
  `cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
  KEY `cl_sortkey` (`cl_to`,`cl_sortkey`,`cl_from`),
  KEY `cl_timestamp` (`cl_to`,`cl_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `{omcollab_db_table_prefix}categorylinks` (`cl_from`, `cl_to`, `cl_sortkey`, `cl_timestamp`) VALUES 
(1, 0x546573745f43617465676f7279, 0x4d61696e2050616765, '2008-07-01 09:33:37');

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}externallinks`;
CREATE TABLE `{omcollab_db_table_prefix}externallinks` (
  `el_from` int(10) unsigned NOT NULL default '0',
  `el_to` blob NOT NULL,
  `el_index` blob NOT NULL,
  KEY `el_from` (`el_from`,`el_to`(40)),
  KEY `el_to` (`el_to`(60),`el_from`),
  KEY `el_index` (`el_index`(60))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `{omcollab_db_table_prefix}externallinks` (`el_from`, `el_to`, `el_index`) VALUES 
(1, 0x687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473, 0x687474703a2f2f6f72672e77696b696d656469612e6d6574612e2f77696b692f48656c703a436f6e74656e7473),
(1, 0x687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e6773, 0x687474703a2f2f6f72672e6d6564696177696b692e7777772e2f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e6773),
(1, 0x687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151, 0x687474703a2f2f6f72672e6d6564696177696b692e7777772e2f77696b692f4d616e75616c3a464151),
(1, 0x687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365, 0x687474703a2f2f6f72672e77696b696d656469612e6c697374732e2f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365),
(4, 0x687474703a2f2f6f6d636f6c6c61622e6c6f63616c686f73742f6f6d57696b692f696e6465782e7068703f7469746c653d5370656369616c3a546f67676c65557365725061676526616374696f6e3d65646974, 0x687474703a2f2f6c6f63616c686f73742e6f6d636f6c6c61622e2f6f6d57696b692f696e6465782e7068703f7469746c653d5370656369616c3a546f67676c65557365725061676526616374696f6e3d65646974),
(1, 0x687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f77696b69, 0x687474703a2f2f6f72672e6f70656e6d6574686f646f6c6f67792e6d696b65322e2f77696b69),
(1, 0x687474703a2f2f6d696b652e6f70656e6d6574686f646f6c6f67792e6f72672f626f6f6b6d61726b73, 0x687474703a2f2f6f72672e6f70656e6d6574686f646f6c6f67792e6d696b652e2f626f6f6b6d61726b73);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}filearchive`;
CREATE TABLE `{omcollab_db_table_prefix}filearchive` (
  `fa_id` int(11) NOT NULL auto_increment,
  `fa_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `fa_archive_name` varchar(255) character set latin1 collate latin1_bin default '',
  `fa_storage_group` varbinary(16) default NULL,
  `fa_storage_key` varbinary(64) default '',
  `fa_deleted_user` int(11) default NULL,
  `fa_deleted_timestamp` binary(14) default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `fa_deleted_reason` text,
  `fa_size` int(10) unsigned default '0',
  `fa_width` int(11) default '0',
  `fa_height` int(11) default '0',
  `fa_metadata` mediumblob,
  `fa_bits` int(11) default '0',
  `fa_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
  `fa_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') default 'unknown',
  `fa_minor_mime` varbinary(32) default 'unknown',
  `fa_description` tinyblob,
  `fa_user` int(10) unsigned default '0',
  `fa_user_text` varchar(255) character set latin1 collate latin1_bin default NULL,
  `fa_timestamp` binary(14) default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `fa_deleted` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`fa_id`),
  KEY `fa_name` (`fa_name`,`fa_timestamp`),
  KEY `fa_storage_group` (`fa_storage_group`,`fa_storage_key`),
  KEY `fa_deleted_timestamp` (`fa_deleted_timestamp`),
  KEY `fa_user_timestamp` (`fa_user_text`,`fa_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}hitcounter`;
CREATE TABLE `{omcollab_db_table_prefix}hitcounter` (
  `hc_id` int(10) unsigned NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1 MAX_ROWS=25000;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}image`;
CREATE TABLE `{omcollab_db_table_prefix}image` (
  `img_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `img_size` int(10) unsigned NOT NULL default '0',
  `img_width` int(11) NOT NULL default '0',
  `img_height` int(11) NOT NULL default '0',
  `img_metadata` mediumblob NOT NULL,
  `img_bits` int(11) NOT NULL default '0',
  `img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
  `img_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL default 'unknown',
  `img_minor_mime` varbinary(32) NOT NULL default 'unknown',
  `img_description` tinyblob NOT NULL,
  `img_user` int(10) unsigned NOT NULL default '0',
  `img_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
  `img_timestamp` varbinary(14) NOT NULL default '',
  `img_sha1` varbinary(32) NOT NULL default '',
  PRIMARY KEY  (`img_name`),
  KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
  KEY `img_size` (`img_size`),
  KEY `img_timestamp` (`img_timestamp`),
  KEY `img_sha1` (`img_sha1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}imagelinks`;
CREATE TABLE `{omcollab_db_table_prefix}imagelinks` (
  `il_from` int(10) unsigned NOT NULL default '0',
  `il_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  UNIQUE KEY `il_from` (`il_from`,`il_to`),
  KEY `il_to` (`il_to`,`il_from`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}interwiki`;
CREATE TABLE `{omcollab_db_table_prefix}interwiki` (
  `iw_prefix` varchar(32) NOT NULL,
  `iw_url` blob NOT NULL,
  `iw_local` tinyint(1) NOT NULL,
  `iw_trans` tinyint(4) NOT NULL default '0',
  UNIQUE KEY `iw_prefix` (`iw_prefix`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `{omcollab_db_table_prefix}interwiki` (`iw_prefix`, `iw_url`, `iw_local`, `iw_trans`) VALUES 
('abbenormal', 0x687474703a2f2f7777772e6f7572706c612e6e65742f6367692d62696e2f70696b69652e6367693f2431, 0, 0),
('acronym', 0x687474703a2f2f7777772e6163726f6e796d66696e6465722e636f6d2f61662d71756572792e6173703f537472696e673d6578616374264163726f6e796d3d2431, 0, 0),
('advogato', 0x687474703a2f2f7777772e6164766f6761746f2e6f72672f2431, 0, 0),
('aiwiki', 0x687474703a2f2f7777772e6966692e756e697a682e63682f61696c61622f616977696b692f6169772e6367693f2431, 0, 0),
('annotationwiki', 0x687474703a2f2f7777772e7365656477696b692e636f6d2f706167652e63666d3f77696b6969643d33363826646f633d2431, 0, 0),
('arxiv', 0x687474703a2f2f7777772e61727869762e6f72672f6162732f2431, 0, 0),
('bemi', 0x687474703a2f2f62656d692e667265652e66722f76696b696f2f696e6465782e7068703f2431, 0, 0),
('c2find', 0x687474703a2f2f63322e636f6d2f6367692f77696b693f46696e64506167652676616c75653d2431, 0, 0),
('cache', 0x687474703a2f2f7777772e676f6f676c652e636f6d2f7365617263683f713d63616368653a2431, 0, 0),
('cliki', 0x687474703a2f2f77772e74656c656e742e6e65742f636c696b692f2431, 0, 0),
('cmwiki', 0x687474703a2f2f7777772e6f7572706c612e6e65742f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('codersbase', 0x687474703a2f2f7777772e636f64657273626173652e636f6d2f696e6465782e7068702f2431, 0, 0),
('commons', 0x687474703a2f2f636f6d6d6f6e732e77696b696d656469612e6f72672f77696b692f2431, 0, 0),
('consciousness', 0x687474703a2f2f746561647675732e696e73706972616c2e6f72672f, 0, 0),
('corpknowpedia', 0x687474703a2f2f636f72706b6e6f7770656469612e6f72672f77696b692f696e6465782e7068702f2431, 0, 0),
('creationmatters', 0x687474703a2f2f7777772e6f7572706c612e6e65742f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('dejanews', 0x687474703a2f2f7777772e64656a612e636f6d2f3d646e632f676574646f632e78703f414e3d2431, 0, 0),
('dictionary', 0x687474703a2f2f7777772e646963742e6f72672f62696e2f446963743f44617461626173653d2a26466f726d3d44696374312653747261746567793d2a2651756572793d2431, 0, 0),
('disinfopedia', 0x687474703a2f2f7777772e646973696e666f70656469612e6f72672f77696b692e7068746d6c3f7469746c653d2431, 0, 0),
('diveintoosx', 0x687474703a2f2f64697665696e746f6f73782e6f72672f2431, 0, 0),
('docbook', 0x687474703a2f2f77696b692e646f63626f6f6b2e6f72672f746f7069632f2431, 0, 0),
('dolphinwiki', 0x687474703a2f2f7777772e6f626a6563742d617274732e636f6d2f77696b692f68746d6c2f446f6c7068696e2f2431, 0, 0),
('drumcorpswiki', 0x687474703a2f2f7777772e6472756d636f72707377696b692e636f6d2f696e6465782e7068702f2431, 0, 0),
('dwjwiki', 0x687474703a2f2f7777772e737562657269632e6e65742f6367692d62696e2f64776a2f77696b692e6367693f2431, 0, 0),
('echei', 0x687474703a2f2f7777772e696b736f2e6e65742f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('ecxei', 0x687474703a2f2f7777772e696b736f2e6e65742f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('efnetceewiki', 0x687474703a2f2f7075726c2e6e65742f77696b692f632f2431, 0, 0),
('efnetcppwiki', 0x687474703a2f2f7075726c2e6e65742f77696b692f6370702f2431, 0, 0),
('efnetpythonwiki', 0x687474703a2f2f7075726c2e6e65742f77696b692f707974686f6e2f2431, 0, 0),
('efnetxmlwiki', 0x687474703a2f2f7075726c2e6e65742f77696b692f786d6c2f2431, 0, 0),
('elibre', 0x687474703a2f2f656e6369636c6f70656469612e75732e65732f696e6465782e7068702f2431, 0, 0),
('eljwiki', 0x687474703a2f2f656c6a2e736f75726365666f7267652e6e65742f70687077696b692f696e6465782e7068702f2431, 0, 0),
('emacswiki', 0x687474703a2f2f7777772e656d61637377696b692e6f72672f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('eokulturcentro', 0x687474703a2f2f6573706572616e746f2e746f756c6f7573652e667265652e66722f77616b6b612e7068703f77696b693d2431, 0, 0),
('evowiki', 0x687474703a2f2f7777772e65766f77696b692e6f72672f696e6465782e7068702f2431, 0, 0),
('eĉei', 0x687474703a2f2f7777772e696b736f2e6e65742f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('finalempire', 0x687474703a2f2f66696e616c2d656d706972652e736f75726365666f7267652e6e65742f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('firstwiki', 0x687474703a2f2f666972737477696b692e6f72672f696e6465782e7068702f2431, 0, 0),
('foldoc', 0x687474703a2f2f7777772e666f6c646f632e6f72672f666f6c646f632f666f6c646f632e6367693f2431, 0, 0),
('foxwiki', 0x687474703a2f2f666f782e77696b69732e636f6d2f77632e646c6c3f57696b697e2431, 0, 0),
('fr.be', 0x687474703a2f2f66722e77696b696e6174696f6e732e62652f2431, 0, 0),
('fr.ca', 0x687474703a2f2f66722e63612e77696b696e6174696f6e732e6f72672f2431, 0, 0),
('fr.fr', 0x687474703a2f2f66722e66722e77696b696e6174696f6e732e6f72672f2431, 0, 0),
('fr.org', 0x687474703a2f2f66722e77696b696e6174696f6e732e6f72672f2431, 0, 0),
('freebsdman', 0x687474703a2f2f7777772e467265654253442e6f72672f6367692f6d616e2e6367693f6170726f706f733d312671756572793d2431, 0, 0),
('gamewiki', 0x687474703a2f2f67616d6577696b692e6f72672f77696b692f696e6465782e7068702f2431, 0, 0),
('gej', 0x687474703a2f2f7777772e6573706572616e746f2e64652f6367692d62696e2f616b746976696b696f2f77696b692e706c3f2431, 0, 0),
('gentoo-wiki', 0x687474703a2f2f67656e746f6f2d77696b692e636f6d2f2431, 0, 0),
('globalvoices', 0x687474703a2f2f63796265722e6c61772e686172766172642e6564752f64796e2f676c6f62616c766f696365732f77696b692f2431, 0, 0),
('gmailwiki', 0x687474703a2f2f7777772e676d61696c77696b692e636f6d2f696e6465782e7068702f2431, 0, 0),
('google', 0x687474703a2f2f7777772e676f6f676c652e636f6d2f7365617263683f713d2431, 0, 0),
('googlegroups', 0x687474703a2f2f67726f7570732e676f6f676c652e636f6d2f67726f7570733f713d2431, 0, 0),
('gotamac', 0x687474703a2f2f7777772e676f742d612d6d61632e6f72672f2431, 0, 0),
('greencheese', 0x687474703a2f2f7777772e677265656e6368656573652e6f72672f2431, 0, 0),
('hammondwiki', 0x687474703a2f2f7777772e64616972696b692e6f72672f48616d6d6f6e6457696b692f696e6465782e706870333f2431, 0, 0),
('haribeau', 0x687474703a2f2f77696b692e68617269626561752e64652f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('herzkinderwiki', 0x687474703a2f2f7777772e6865727a6b696e646572696e666f2e64652f4d6564696177696b692f696e6465782e7068702f2431, 0, 0),
('hewikisource', 0x687474703a2f2f68652e77696b69736f757263652e6f72672f77696b692f2431, 1, 0),
('hrwiki', 0x687474703a2f2f7777772e687277696b692e6f72672f696e6465782e7068702f2431, 0, 0),
('iawiki', 0x687474703a2f2f7777772e494177696b692e6e65742f2431, 0, 0),
('imdb', 0x687474703a2f2f75732e696d64622e636f6d2f5469746c653f2431, 0, 0),
('infosecpedia', 0x687474703a2f2f7777772e696e666f73656370656469612e6f72672f70656469612f696e6465782e7068702f2431, 0, 0),
('jargonfile', 0x687474703a2f2f73756e69722e6f72672f617070732f6d6574612e706c3f77696b693d4a6172676f6e46696c652672656469726563743d2431, 0, 0),
('jefo', 0x687474703a2f2f7777772e6573706572616e746f2d6a65756e65732e6f72672f76696b696f2f696e6465782e7068703f2431, 0, 0),
('jiniwiki', 0x687474703a2f2f7777772e63646567726f6f742e636f6d2f6367692d62696e2f6a696e693f2431, 0, 0),
('jspwiki', 0x687474703a2f2f7777772e65637972642e636f6d2f4a535057696b692f57696b692e6a73703f706167653d2431, 0, 0),
('keiki', 0x687474703a2f2f6b65692e6b692f656e2f2431, 0, 0),
('kerimwiki', 0x687474703a2f2f77696b692e6f7875732e6e65742f2431, 0, 0),
('kmwiki', 0x687474703a2f2f7777772e766f6768742e636f6d2f6367692d62696e2f707977696b693f2431, 0, 0),
('knowhow', 0x687474703a2f2f777777322e69726f2e756d6f6e747265616c2e63612f7e70617175657473652f6367692d62696e2f77696b692e6367693f2431, 0, 0),
('lanifexwiki', 0x687474703a2f2f6f70742e6c616e696665782e636f6d2f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('lasvegaswiki', 0x687474703a2f2f77696b692e676d6e6f772e636f6d2f696e6465782e7068702f2431, 0, 0),
('linuxwiki', 0x687474703a2f2f7777772e6c696e757877696b692e64652f2431, 0, 0),
('lojban', 0x687474703a2f2f7777772e6c6f6a62616e2e6f72672f74696b692f74696b692d696e6465782e7068703f706167653d2431, 0, 0),
('lqwiki', 0x687474703a2f2f77696b692e6c696e75787175657374696f6e732e6f72672f77696b692f2431, 0, 0),
('lugkr', 0x687474703a2f2f6c75672d6b722e736f75726365666f7267652e6e65742f6367692d62696e2f6c756777696b692e706c3f2431, 0, 0),
('lutherwiki', 0x687474703a2f2f7777772e6c7574686572616e61726368697665732e636f6d2f6d772f696e6465782e7068702f2431, 0, 0),
('mathsongswiki', 0x687474703a2f2f5365656457696b692e636f6d2f706167652e63666d3f77696b6969643d32333726646f633d2431, 0, 0),
('mbtest', 0x687474703a2f2f7777772e7573656d6f642e636f6d2f6367692d62696e2f6d62746573742e706c3f2431, 0, 0),
('meatball', 0x687474703a2f2f7777772e7573656d6f642e636f6d2f6367692d62696e2f6d622e706c3f2431, 0, 0),
('mediawikiwiki', 0x687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f2431, 0, 0),
('mediazilla', 0x687474703a2f2f6275677a696c6c612e77696b6970656469612e6f72672f2431, 1, 0),
('memoryalpha', 0x687474703a2f2f7777772e6d656d6f72792d616c7068612e6f72672f656e2f696e6465782e7068702f2431, 0, 0),
('metaweb', 0x687474703a2f2f7777772e6d6574617765622e636f6d2f77696b692f77696b692e7068746d6c3f7469746c653d2431, 0, 0),
('metawiki', 0x687474703a2f2f73756e69722e6f72672f617070732f6d6574612e706c3f2431, 0, 0),
('metawikipedia', 0x687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f2431, 0, 0),
('moinmoin', 0x687474703a2f2f7075726c2e6e65742f77696b692f6d6f696e2f2431, 0, 0),
('mozillawiki', 0x687474703a2f2f77696b692e6d6f7a696c6c612e6f72672f696e6465782e7068702f2431, 0, 0),
('muweb', 0x687474703a2f2f7777772e64756e737461626c652e636f6d2f736372697074732f4d755765625765623f2431, 0, 0),
('netvillage', 0x687474703a2f2f7777772e6e657462726f732e636f6d2f3f2431, 0, 0),
('oeis', 0x687474703a2f2f7777772e72657365617263682e6174742e636f6d2f6367692d62696e2f6163636573732e6367692f61732f6e6a61732f73657175656e6365732f656973412e6367693f416e756d3d2431, 0, 0),
('openfacts', 0x687474703a2f2f6f70656e66616374732e6265726c696f732e64652f696e6465782e7068746d6c3f7469746c653d2431, 0, 0),
('openwiki', 0x687474703a2f2f6f70656e77696b692e636f6d2f3f2431, 0, 0),
('opera7wiki', 0x687474703a2f2f6e6f6e74726f70706f2e6f72672f77696b692f2431, 0, 0),
('orgpatterns', 0x687474703a2f2f7777772e62656c6c2d6c6162732e636f6d2f6367692d757365722f4f72675061747465726e732f4f72675061747465726e733f2431, 0, 0),
('osi reference model', 0x687474703a2f2f77696b692e7469676d612e65652f, 0, 0),
('pangalacticorg', 0x687474703a2f2f7777772e70616e67616c61637469632e6f72672f57696b692f2431, 0, 0),
('patwiki', 0x687474703a2f2f67617573732e666669692e6f72672f2431, 0, 0),
('personaltelco', 0x687474703a2f2f7777772e706572736f6e616c74656c636f2e6e65742f696e6465782e6367692f2431, 0, 0),
('phpwiki', 0x687474703a2f2f70687077696b692e736f75726365666f7267652e6e65742f70687077696b692f696e6465782e7068703f2431, 0, 0),
('pikie', 0x687474703a2f2f70696b69652e6461726b746563682e6f72672f6367692f70696b69653f2431, 0, 0),
('pmeg', 0x687474703a2f2f7777772e62657274696c6f772e636f6d2f706d65672f24312e706870, 0, 0),
('ppr', 0x687474703a2f2f63322e636f6d2f6367692f77696b693f2431, 0, 0),
('purlnet', 0x687474703a2f2f7075726c2e6f636c632e6f72672f4e45542f2431, 0, 0),
('pythoninfo', 0x687474703a2f2f7777772e707974686f6e2e6f72672f6367692d62696e2f6d6f696e6d6f696e2f2431, 0, 0),
('pythonwiki', 0x687474703a2f2f7777772e707974686f6e77696b692e64652f2431, 0, 0),
('pywiki', 0x687474703a2f2f7777772e766f6768742e636f6d2f6367692d62696e2f707977696b693f2431, 0, 0),
('raec', 0x687474703a2f2f7777772e726165632e636c6163736f2e6564752e61723a383038302f726165632f4d656d626572732f7261656370656469612f2431, 0, 0),
('revo', 0x687474703a2f2f7075726c2e6f72672f4e45542f766f6b6f2f7265766f2f6172742f24312e68746d6c, 0, 0),
('rfc', 0x687474703a2f2f7777772e7266632d656469746f722e6f72672f7266632f72666324312e747874, 0, 0),
('s23wiki', 0x687474703a2f2f69732d726f6f742e64652f77696b692f696e6465782e7068702f2431, 0, 0),
('scoutpedia', 0x687474703a2f2f7777772e73636f757470656469612e696e666f2f696e6465782e7068702f2431, 0, 0),
('seapig', 0x687474703a2f2f7777772e7365617069672e6f72672f2431, 0, 0),
('seattlewiki', 0x687474703a2f2f73656174746c6577696b692e6f72672f77696b692f2431, 0, 0),
('seattlewireless', 0x687474703a2f2f73656174746c65776972656c6573732e6e65742f3f2431, 0, 0),
('seeds', 0x687474703a2f2f7777772e49736c616e6453656564732e6f72672f77696b692f2431, 0, 0),
('senseislibrary', 0x687474703a2f2f73656e736569732e786d702e6e65742f3f2431, 0, 0),
('shakti', 0x687474703a2f2f6367692e616c676f6e65742e73652f687462696e2f636769777261702f7067642f5368616b746957696b692f2431, 0, 0),
('slashdot', 0x687474703a2f2f736c617368646f742e6f72672f61727469636c652e706c3f7369643d2431, 0, 0),
('smikipedia', 0x687474703a2f2f7777772e736d696b6970656469612e6f72672f2431, 0, 0),
('sockwiki', 0x687474703a2f2f77696b692e736f636b6c6162732e636f6d2f2431, 0, 0),
('sourceforge', 0x687474703a2f2f736f75726365666f7267652e6e65742f2431, 0, 0),
('squeak', 0x687474703a2f2f6d696e6e6f772e63632e6761746563682e6564752f73717565616b2f2431, 0, 0),
('strikiwiki', 0x687474703a2f2f63682e7477692e747564656c66742e6e6c2f7e6d6f73746572742f737472696b692f74657374737472696b692e706c3f2431, 0, 0),
('susning', 0x687474703a2f2f7777772e7375736e696e672e6e752f2431, 0, 0),
('svgwiki', 0x687474703a2f2f7777772e70726f746f636f6c372e636f6d2f7376672d77696b692f64656661756c742e6173703f2431, 0, 0),
('tavi', 0x687474703a2f2f746176692e736f75726365666f7267652e6e65742f2431, 0, 0),
('tejo', 0x687474703a2f2f7777772e74656a6f2e6f72672f76696b696f2f2431, 0, 0),
('terrorwiki', 0x687474703a2f2f7777772e6c69626572616c73616761696e7374746572726f7269736d2e636f6d2f77696b692f696e6465782e7068702f2431, 0, 0),
('theopedia', 0x687474703a2f2f7777772e7468656f70656469612e636f6d2f2431, 0, 0),
('tmbw', 0x687474703a2f2f7777772e746d62772e6e65742f77696b692f696e6465782e7068702f2431, 0, 0),
('tmnet', 0x687474703a2f2f7777772e746563686e6f6d616e69666573746f732e6e65742f3f2431, 0, 0),
('tmwiki', 0x687474703a2f2f7777772e45617379546f7069634d6170732e636f6d2f3f706167653d2431, 0, 0),
('turismo', 0x687474703a2f2f7777772e74656a6f2e6f72672f74757269736d6f2f2431, 0, 0),
('twiki', 0x687474703a2f2f7477696b692e6f72672f6367692d62696e2f766965772f2431, 0, 0),
('twistedwiki', 0x687474703a2f2f7075726c2e6e65742f77696b692f747769737465642f2431, 0, 0),
('uea', 0x687474703a2f2f7777772e74656a6f2e6f72672f7565612f2431, 0, 0),
('unreal', 0x687474703a2f2f77696b692e6265796f6e64756e7265616c2e636f6d2f77696b692f2431, 0, 0),
('ursine', 0x687474703a2f2f77696b692e757273696e652e63612f2431, 0, 0),
('usej', 0x687474703a2f2f7777772e74656a6f2e6f72672f7573656a2f2431, 0, 0),
('usemod', 0x687474703a2f2f7777772e7573656d6f642e636f6d2f6367692d62696e2f77696b692e706c3f2431, 0, 0),
('vinismo', 0x687474703a2f2f76696e69736d6f2e636f6d2f656e2f2431, 0, 0),
('visualworks', 0x687474703a2f2f77696b692e63732e756975632e6564752f56697375616c576f726b732f2431, 0, 0),
('warpedview', 0x687474703a2f2f7777772e776172706564766965772e636f6d2f696e6465782e7068702f2431, 0, 0),
('webdevwikinl', 0x687474703a2f2f7777772e70726f6d6f2d69742e6e6c2f57656244657657696b692f696e6465782e7068703f706167653d2431, 0, 0),
('webisodes', 0x687474703a2f2f7777772e77656269736f6465732e6f72672f2431, 0, 0),
('webseitzwiki', 0x687474703a2f2f776562736569747a2e666c7578656e742e636f6d2f77696b692f2431, 0, 0),
('why', 0x687474703a2f2f636c75626c65742e636f6d2f632f632f7768793f2431, 0, 0),
('wiki', 0x687474703a2f2f63322e636f6d2f6367692f77696b693f2431, 0, 0),
('wikia', 0x687474703a2f2f7777772e77696b69612e636f6d2f77696b692f2431, 0, 0),
('wikibooks', 0x687474703a2f2f656e2e77696b69626f6f6b732e6f72672f77696b692f2431, 1, 0),
('wikicities', 0x687474703a2f2f7777772e77696b696369746965732e636f6d2f696e6465782e7068702f2431, 0, 0),
('wikif1', 0x687474703a2f2f7777772e77696b6966312e6f72672f2431, 0, 0),
('wikihow', 0x687474703a2f2f7777772e77696b69686f772e636f6d2f2431, 0, 0),
('wikimedia', 0x687474703a2f2f77696b696d65646961666f756e646174696f6e2e6f72672f77696b692f2431, 0, 0),
('wikinews', 0x687474703a2f2f656e2e77696b696e6577732e6f72672f77696b692f2431, 1, 0),
('wikinfo', 0x687474703a2f2f7777772e77696b696e666f2e6f72672f696e6465782e7068702f2431, 0, 0),
('wikipedia', 0x687474703a2f2f656e2e77696b6970656469612e6f72672f77696b692f2431, 1, 0),
('wikiquote', 0x687474703a2f2f656e2e77696b6971756f74652e6f72672f77696b692f2431, 1, 0),
('wikisource', 0x687474703a2f2f736f75726365732e77696b6970656469612e6f72672f77696b692f2431, 1, 0),
('wikispecies', 0x687474703a2f2f737065636965732e77696b6970656469612e6f72672f77696b692f2431, 1, 0),
('wikitravel', 0x687474703a2f2f77696b6974726176656c2e6f72672f656e2f2431, 0, 0),
('wikiworld', 0x687474703a2f2f57696b69576f726c642e636f6d2f77696b692f696e6465782e7068702f2431, 0, 0),
('wikt', 0x687474703a2f2f656e2e77696b74696f6e6172792e6f72672f77696b692f2431, 1, 0),
('wiktionary', 0x687474703a2f2f656e2e77696b74696f6e6172792e6f72672f77696b692f2431, 1, 0),
('wlug', 0x687474703a2f2f7777772e776c75672e6f72672e6e7a2f2431, 0, 0),
('wlwiki', 0x687474703a2f2f77696e736c6f77736c6169722e73757072656d65706978656c732e6e65742f77696b692f696e6465782e7068702f2431, 0, 0),
('ypsieyeball', 0x687474703a2f2f736b6e6b77726b732e64796e646e732e6f72673a313935372f777269746577696b692f77696b692e706c3f2431, 0, 0),
('zwiki', 0x687474703a2f2f7777772e7a77696b692e6f72672f2431, 0, 0),
('zzz wiki', 0x687474703a2f2f77696b692e7a7a7a2e65652f, 0, 0);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}ipblocks`;
CREATE TABLE `{omcollab_db_table_prefix}ipblocks` (
  `ipb_id` int(11) NOT NULL auto_increment,
  `ipb_address` tinyblob NOT NULL,
  `ipb_user` int(10) unsigned NOT NULL default '0',
  `ipb_by` int(10) unsigned NOT NULL default '0',
  `ipb_reason` tinyblob NOT NULL,
  `ipb_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `ipb_auto` tinyint(1) NOT NULL default '0',
  `ipb_anon_only` tinyint(1) NOT NULL default '0',
  `ipb_create_account` tinyint(1) NOT NULL default '1',
  `ipb_enable_autoblock` tinyint(1) NOT NULL default '1',
  `ipb_expiry` varbinary(14) NOT NULL default '',
  `ipb_range_start` tinyblob NOT NULL,
  `ipb_range_end` tinyblob NOT NULL,
  `ipb_deleted` tinyint(1) NOT NULL default '0',
  `ipb_block_email` tinyint(1) NOT NULL default '0',
  `ipb_by_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
   `ipb_allow_usertalk` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY  (`ipb_id`),
  UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`),
  KEY `ipb_user` (`ipb_user`),
  KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)),
  KEY `ipb_timestamp` (`ipb_timestamp`),
  KEY `ipb_expiry` (`ipb_expiry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}job`;
CREATE TABLE `{omcollab_db_table_prefix}job` (
  `job_id` int(10) unsigned NOT NULL auto_increment,
  `job_cmd` varbinary(60) NOT NULL default '',
  `job_namespace` int(11) NOT NULL,
  `job_title` varchar(255) character set latin1 collate latin1_bin NOT NULL,
  `job_params` blob NOT NULL,
  PRIMARY KEY  (`job_id`),
  KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}langlinks`;
CREATE TABLE `{omcollab_db_table_prefix}langlinks` (
  `ll_from` int(10) unsigned NOT NULL default '0',
  `ll_lang` varbinary(20) NOT NULL default '',
  `ll_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`),
  KEY `ll_lang` (`ll_lang`,`ll_title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}logging`;
CREATE TABLE `{omcollab_db_table_prefix}logging` (
  `log_type` varbinary(10) NOT NULL default '',
  `log_action` varbinary(10) NOT NULL default '',
  `log_timestamp` binary(14) NOT NULL default '19700101000000',
  `log_user` int(10) unsigned NOT NULL default '0',
  `log_namespace` int(11) NOT NULL default '0',
  `log_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `log_comment` varchar(255) NOT NULL default '',
  `log_params` blob NOT NULL,
  `log_id` int(10) unsigned NOT NULL auto_increment,
  `log_deleted` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`log_id`),
  KEY `type_time` (`log_type`,`log_timestamp`),
  KEY `user_time` (`log_user`,`log_timestamp`),
  KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
  KEY `times` (`log_timestamp`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

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

INSERT INTO `{omcollab_db_table_prefix}logging` (`log_type`, `log_action`, `log_timestamp`, `log_user`, `log_namespace`, `log_title`, `log_comment`, `log_params`, `log_id`, `log_deleted`) VALUES 
(0x72656e616d6575736572, 0x72656e616d6575736572, 0x3230303830363036313434383334, 1, 2, 0x57696b695379734f70, '0 edits. Reason: ', 0x41646d696e, 1, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830363131303934363539, 1, 8, 0x53696465626172, '', 0x320a300a31, 2, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830363131303934383030, 1, 8, 0x53696465626172, '', 0x330a320a31, 3, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830363131303934393130, 1, 8, 0x53696465626172, '', 0x340a330a31, 4, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830363131313030393135, 1, 0, 0x5375626d656e75, '', 0x350a300a31, 5, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830363131313031353130, 1, 0, 0x5375626d656e75, '', 0x360a350a31, 6, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830363133303934393338, 1, 0, 0x4d61696e5f50616765, '', 0x370a310a31, 7, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830363133303935313239, 1, 0, 0x4d61696e5f50616765, '', 0x380a370a31, 8, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830363133313031353339, 1, 0, 0x4d61696e5f50616765, '', 0x390a380a31, 9, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830363133313231303234, 1, 0, 0x41646d696e, '', 0x31300a300a31, 10, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303933333337, 1, 0, 0x4d61696e5f50616765, '', 0x31310a390a31, 11, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303933353131, 1, 0, 0x4d61696e5f50616765, '', 0x31320a31310a31, 12, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303933353438, 1, 0, 0x4d61696e5f50616765, '', 0x31330a31320a31, 13, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303933363330, 1, 0, 0x4d61696e5f50616765, '', 0x31340a31330a31, 14, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303933373234, 1, 0, 0x4d61696e5f50616765, '', 0x31350a31340a31, 15, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303933383537, 1, 0, 0x4d61696e5f50616765, '', 0x31360a31350a31, 16, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303933393431, 1, 0, 0x4d61696e5f50616765, '', 0x31370a31360a31, 17, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303934303233, 1, 0, 0x4d61696e5f50616765, '', 0x31380a31370a31, 18, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303934373132, 1, 0, 0x5375626d656e75, '', 0x31390a360a31, 19, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303934373436, 1, 0, 0x5375626d656e75, '', 0x32300a31390a31, 20, 0),
(0x706174726f6c, 0x706174726f6c, 0x3230303830373031303934383134, 1, 0, 0x5375626d656e75, '', 0x32310a32300a31, 21, 0);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}math`;
CREATE TABLE `{omcollab_db_table_prefix}math` (
  `math_inputhash` varbinary(16) NOT NULL,
  `math_outputhash` varbinary(16) NOT NULL,
  `math_html_conservativeness` tinyint(4) NOT NULL,
  `math_html` text,
  `math_mathml` text,
  UNIQUE KEY `math_inputhash` (`math_inputhash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}objectcache`;
CREATE TABLE `{omcollab_db_table_prefix}objectcache` (
  `keyname` varbinary(255) NOT NULL default '',
  `value` mediumblob,
  `exptime` datetime default NULL,
  UNIQUE KEY `keyname` (`keyname`),
  KEY `exptime` (`exptime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `{omcollab_db_table_prefix}objectcache` (`keyname`, `value`, `exptime`) VALUES 
(0x6f6d646576315f6f6d77696b692d6f6d5f3a6d65737361676573, 0x5d8fc10a82401086ef3ec5b2ddba444204637531a10e596874919051875ad8dda4d50ad4776fcd2e759af9e6ff60f8115c680ccc81c7a2a00cefdc33e0ba33e0ac69468a740dce38497628343be085dacd4dd1f9ec8cedd1d4592fb4f442554a625f66a222d52b491297940b9410514ebacaafa82f64da81983fe0af19d2b3c45eb20b99eaf3f34f89501737d50ee323d8bceb9c45211e2c9768cc923f84a951fa926ca1d5626293559a86fb60bd3dc6817fdceec334ed9bdadea7208a2d734fc0d4ebde, '2008-07-02 09:22:21');

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}oldimage`;
CREATE TABLE `{omcollab_db_table_prefix}oldimage` (
  `oi_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `oi_archive_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `oi_size` int(10) unsigned NOT NULL default '0',
  `oi_width` int(11) NOT NULL default '0',
  `oi_height` int(11) NOT NULL default '0',
  `oi_bits` int(11) NOT NULL default '0',
  `oi_description` tinyblob NOT NULL,
  `oi_user` int(10) unsigned NOT NULL default '0',
  `oi_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
  `oi_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `oi_metadata` mediumblob NOT NULL,
  `oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
  `oi_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL default 'unknown',
  `oi_minor_mime` varbinary(32) NOT NULL default 'unknown',
  `oi_deleted` tinyint(3) unsigned NOT NULL default '0',
  `oi_sha1` varbinary(32) NOT NULL default '',
  KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
  KEY `oi_name_timestamp` (`oi_name`,`oi_timestamp`),
  KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
  KEY `oi_sha1` (`oi_sha1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}page`;
CREATE TABLE `{omcollab_db_table_prefix}page` (
  `page_id` int(10) unsigned NOT NULL auto_increment,
  `page_namespace` int(11) NOT NULL,
  `page_title` varchar(255) character set latin1 collate latin1_bin NOT NULL,
  `page_restrictions` tinyblob NOT NULL,
  `page_counter` bigint(20) unsigned NOT NULL default '0',
  `page_is_redirect` tinyint(3) unsigned NOT NULL default '0',
  `page_is_new` tinyint(3) unsigned NOT NULL default '0',
  `page_random` double unsigned NOT NULL,
  `page_touched` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `page_latest` int(10) unsigned NOT NULL,
  `page_len` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`page_id`),
  UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
  KEY `page_random` (`page_random`),
  KEY `page_len` (`page_len`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

INSERT INTO `{omcollab_db_table_prefix}page` (`page_id`, `page_namespace`, `page_title`, `page_restrictions`, `page_counter`, `page_is_redirect`, `page_is_new`, `page_random`, `page_touched`, `page_latest`, `page_len`) VALUES 
(1, 0, 0x4d61696e5f50616765, '', 90, 0, 0, 0.106481737462, 0x3230303830373031303934303233, 18, 2722),
(2, 8, 0x53696465626172, '', 4, 0, 0, 0.423490804093, 0x3230303830363131313030393135, 4, 224),
(3, 0, 0x5375626d656e75, '', 6, 0, 0, 0.825034213397, 0x3230303830373031303934383134, 21, 30),
(4, 200, 0x41646d696e, '', 0, 0, 1, 0.750118327798, 0x3230303830363133313231303234, 10, 262);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}pagelinks`;
CREATE TABLE `{omcollab_db_table_prefix}pagelinks` (
  `pl_from` int(10) unsigned NOT NULL default '0',
  `pl_namespace` int(11) NOT NULL default '0',
  `pl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  UNIQUE KEY `pl_from` (`pl_from`,`pl_namespace`,`pl_title`),
  KEY `pl_namespace` (`pl_namespace`,`pl_title`,`pl_from`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `{omcollab_db_table_prefix}pagelinks` (`pl_from`, `pl_namespace`, `pl_title`) VALUES 
(2, 0, 0x4d61696e5f50616765),
(2, 0, 0x5375626d656e75);

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

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

CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}page_props` (
  `pp_page` int(11) NOT NULL,
  `pp_propname` varbinary(60) NOT NULL,
  `pp_value` blob NOT NULL,
  PRIMARY KEY (`pp_page`,`pp_propname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}page_restrictions`;
CREATE TABLE `{omcollab_db_table_prefix}page_restrictions` (
  `pr_page` int(11) NOT NULL,
  `pr_type` varbinary(60) NOT NULL,
  `pr_level` varbinary(60) NOT NULL,
  `pr_cascade` tinyint(4) NOT NULL,
  `pr_user` int(11) default NULL,
  `pr_expiry` varbinary(14) default NULL,
  `pr_id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`pr_page`,`pr_type`),
  UNIQUE KEY `pr_id` (`pr_id`),
  KEY `pr_typelevel` (`pr_type`,`pr_level`),
  KEY `pr_level` (`pr_level`),
  KEY `pr_cascade` (`pr_cascade`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}protected_titles`;
CREATE TABLE `{omcollab_db_table_prefix}protected_titles` (
  `pt_namespace` int(11) NOT NULL,
  `pt_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `pt_user` int(10) unsigned NOT NULL,
  `pt_reason` tinyblob,
  `pt_timestamp` binary(14) NOT NULL,
  `pt_expiry` varbinary(14) NOT NULL default '',
  `pt_create_perm` varbinary(60) NOT NULL,
  PRIMARY KEY  (`pt_namespace`,`pt_title`),
  KEY `pt_timestamp` (`pt_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}querycache`;
CREATE TABLE `{omcollab_db_table_prefix}querycache` (
  `qc_type` varbinary(32) NOT NULL,
  `qc_value` int(10) unsigned NOT NULL default '0',
  `qc_namespace` int(11) NOT NULL default '0',
  `qc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  KEY `qc_type` (`qc_type`,`qc_value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}querycachetwo`;
CREATE TABLE `{omcollab_db_table_prefix}querycachetwo` (
  `qcc_type` varbinary(32) NOT NULL,
  `qcc_value` int(10) unsigned NOT NULL default '0',
  `qcc_namespace` int(11) NOT NULL default '0',
  `qcc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `qcc_namespacetwo` int(11) NOT NULL default '0',
  `qcc_titletwo` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  KEY `qcc_type` (`qcc_type`,`qcc_value`),
  KEY `qcc_title` (`qcc_type`,`qcc_namespace`,`qcc_title`),
  KEY `qcc_titletwo` (`qcc_type`,`qcc_namespacetwo`,`qcc_titletwo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}querycache_info`;
CREATE TABLE `{omcollab_db_table_prefix}querycache_info` (
  `qci_type` varbinary(32) NOT NULL default '',
  `qci_timestamp` binary(14) NOT NULL default '19700101000000',
  UNIQUE KEY `qci_type` (`qci_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}recentchanges`;
CREATE TABLE `{omcollab_db_table_prefix}recentchanges` (
  `rc_id` int(11) NOT NULL auto_increment,
  `rc_timestamp` varbinary(14) NOT NULL default '',
  `rc_cur_time` varbinary(14) NOT NULL default '',
  `rc_user` int(10) unsigned NOT NULL default '0',
  `rc_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL,
  `rc_namespace` int(11) NOT NULL default '0',
  `rc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `rc_comment` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `rc_minor` tinyint(3) unsigned NOT NULL default '0',
  `rc_bot` tinyint(3) unsigned NOT NULL default '0',
  `rc_new` tinyint(3) unsigned NOT NULL default '0',
  `rc_cur_id` int(10) unsigned NOT NULL default '0',
  `rc_this_oldid` int(10) unsigned NOT NULL default '0',
  `rc_last_oldid` int(10) unsigned NOT NULL default '0',
  `rc_type` tinyint(3) unsigned NOT NULL default '0',
  `rc_moved_to_ns` tinyint(3) unsigned NOT NULL default '0',
  `rc_moved_to_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `rc_patrolled` tinyint(3) unsigned NOT NULL default '0',
  `rc_ip` varbinary(40) NOT NULL default '',
  `rc_old_len` int(11) default NULL,
  `rc_new_len` int(11) default NULL,
  `rc_deleted` tinyint(3) unsigned NOT NULL default '0',
  `rc_logid` int(10) unsigned NOT NULL default '0',
  `rc_log_type` varbinary(255) default NULL,
  `rc_log_action` varbinary(255) default NULL,
  `rc_params` blob,
  PRIMARY KEY  (`rc_id`),
  KEY `rc_timestamp` (`rc_timestamp`),
  KEY `rc_namespace_title` (`rc_namespace`,`rc_title`),
  KEY `rc_cur_id` (`rc_cur_id`),
  KEY `new_name_timestamp` (`rc_new`,`rc_namespace`,`rc_timestamp`),
  KEY `rc_ip` (`rc_ip`),
  KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
  KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

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

INSERT INTO `{omcollab_db_table_prefix}recentchanges` (`rc_id`, `rc_timestamp`, `rc_cur_time`, `rc_user`, `rc_user_text`, `rc_namespace`, `rc_title`, `rc_comment`, `rc_minor`, `rc_bot`, `rc_new`, `rc_cur_id`, `rc_this_oldid`, `rc_last_oldid`, `rc_type`, `rc_moved_to_ns`, `rc_moved_to_title`, `rc_patrolled`, `rc_ip`, `rc_old_len`, `rc_new_len`, `rc_deleted`, `rc_logid`, `rc_log_type`, `rc_log_action`, `rc_params`) VALUES 
(1, 0x3230303830363036313434383334, 0x3230303830363036313434383334, 1, 0x41646d696e, -1, 0x4c6f672f72656e616d6575736572, 0x6861732072656e616d656420557365723a57696b695379734f7020746f202241646d696e223a20302065646974732e20526561736f6e3a20, 0, 0, 0, 0, 0, 0, 3, 0, '', 1, 0x3132372e302e302e31, NULL, NULL, 0, 0, NULL, NULL, NULL),
(2, 0x3230303830363131303934363539, 0x3230303830363131303934363539, 1, 0x41646d696e, 8, 0x53696465626172, 0x4e657720706167653a207b7b236d656e753a202a5b5b6d61696e706167657c6d61696e706167655d5d202a5b5b5370656369616c3a526563656e746368616e6765737c526563656e74204368616e6765735d5d202a5b5b5370656369616c3a4e657770616765737c4e65776573742050616765735d5d202a5b5b5370656369616c3a52616e646f6d7c52616e646f6d20506167655d5d207d7d203c64697620636c6173733d2276697375616c436c656172223e3c2f6469763e5f5f4e4f4544495453454354492e2e2e, 0, 0, 1, 2, 2, 0, 1, 0, '', 1, 0x3132372e302e302e31, 0, 192, 0, 0, NULL, NULL, NULL),
(3, 0x3230303830363131303934383030, 0x3230303830363131303934383030, 1, 0x41646d696e, 8, 0x53696465626172, '', 0, 0, 0, 2, 3, 2, 0, 0, '', 1, 0x3132372e302e302e31, 192, 227, 0, 0, NULL, NULL, NULL),
(4, 0x3230303830363131303934393130, 0x3230303830363131303934393130, 1, 0x41646d696e, 8, 0x53696465626172, '', 0, 0, 0, 2, 4, 3, 0, 0, '', 1, 0x3132372e302e302e31, 227, 224, 0, 0, NULL, NULL, NULL),
(5, 0x3230303830363131313030393135, 0x3230303830363131313030393135, 1, 0x41646d696e, 0, 0x5375626d656e75, 0x4e657720706167653a204e6176696761746520746f202f6f6d57696b692f4d6564696157696b693a5369646562617220616e642065646974206173207265717569726564, 0, 0, 1, 3, 5, 0, 1, 0, '', 1, 0x3132372e302e302e31, 0, 58, 0, 0, NULL, NULL, NULL),
(6, 0x3230303830363131313031353130, 0x3230303830363131313031353130, 1, 0x41646d696e, 0, 0x5375626d656e75, '', 0, 0, 0, 3, 6, 5, 0, 0, '', 1, 0x3132372e302e302e31, 58, 62, 0, 0, NULL, NULL, NULL),
(7, 0x3230303830363133303934393338, 0x3230303830363133303934393338, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, '', 0, 0, 0, 1, 7, 1, 0, 0, '', 1, 0x3132372e302e302e31, 449, 462, 0, 0, NULL, NULL, NULL),
(8, 0x3230303830363133303935313239, 0x3230303830363133303935313239, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, '', 0, 0, 0, 1, 8, 7, 0, 0, '', 1, 0x3132372e302e302e31, 462, 449, 0, 0, NULL, NULL, NULL),
(9, 0x3230303830363133313031353339, 0x3230303830363133313031353339, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, '', 0, 0, 0, 1, 9, 8, 0, 0, '', 1, 0x3132372e302e302e31, 449, 462, 0, 0, NULL, NULL, NULL),
(10, 0x3230303830363133313231303234, 0x3230303830363133313231303234, 1, 0x41646d696e, 200, 0x41646d696e, 0x696d706f727420757365722077696b69, 0, 0, 1, 4, 10, 0, 1, 0, '', 1, 0x3132372e302e302e31, 0, 262, 0, 0, NULL, NULL, NULL),
(11, 0x3230303830373031303933333337, 0x3230303830373031303933333337, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, '', 0, 0, 0, 1, 11, 9, 0, 0, '', 1, 0x3132372e302e302e31, 462, 2739, 0, 0, NULL, NULL, NULL),
(12, 0x3230303830373031303933353131, 0x3230303830373031303933353131, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, 0x2f2a204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465202a2f20, 0, 0, 0, 1, 12, 11, 0, 0, '', 1, 0x3132372e302e302e31, 2739, 2723, 0, 0, NULL, NULL, NULL),
(13, 0x3230303830373031303933353438, 0x3230303830373031303933353438, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f20, 0, 0, 0, 1, 13, 12, 0, 0, '', 1, 0x3132372e302e302e31, 2723, 2719, 0, 0, NULL, NULL, NULL),
(14, 0x3230303830373031303933363330, 0x3230303830373031303933363330, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f20, 0, 0, 0, 1, 14, 13, 0, 0, '', 1, 0x3132372e302e302e31, 2719, 2718, 0, 0, NULL, NULL, NULL),
(15, 0x3230303830373031303933373234, 0x3230303830373031303933373234, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f20, 0, 0, 0, 1, 15, 14, 0, 0, '', 1, 0x3132372e302e302e31, 2718, 2708, 0, 0, NULL, NULL, NULL),
(16, 0x3230303830373031303933383537, 0x3230303830373031303933383537, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f20, 0, 0, 0, 1, 16, 15, 0, 0, '', 1, 0x3132372e302e302e31, 2708, 2720, 0, 0, NULL, NULL, NULL),
(17, 0x3230303830373031303933393431, 0x3230303830373031303933393431, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, 0x2f2a204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69202a2f20, 0, 0, 0, 1, 17, 16, 0, 0, '', 1, 0x3132372e302e302e31, 2720, 2715, 0, 0, NULL, NULL, NULL),
(18, 0x3230303830373031303934303233, 0x3230303830373031303934303233, 1, 0x41646d696e, 0, 0x4d61696e5f50616765, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f20, 0, 0, 0, 1, 18, 17, 0, 0, '', 1, 0x3132372e302e302e31, 2715, 2722, 0, 0, NULL, NULL, NULL),
(19, 0x3230303830373031303934373132, 0x3230303830373031303934373132, 1, 0x41646d696e, 0, 0x5375626d656e75, '', 0, 0, 0, 3, 19, 6, 0, 0, '', 1, 0x3132372e302e302e31, 62, 58, 0, 0, NULL, NULL, NULL),
(20, 0x3230303830373031303934373436, 0x3230303830373031303934373436, 1, 0x41646d696e, 0, 0x5375626d656e75, '', 0, 0, 0, 3, 20, 19, 0, 0, '', 1, 0x3132372e302e302e31, 58, 42, 0, 0, NULL, NULL, NULL),
(21, 0x3230303830373031303934383134, 0x3230303830373031303934383134, 1, 0x41646d696e, 0, 0x5375626d656e75, '', 0, 0, 0, 3, 21, 20, 0, 0, '', 1, 0x3132372e302e302e31, 42, 30, 0, 0, NULL, NULL, NULL);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}redirect`;
CREATE TABLE `{omcollab_db_table_prefix}redirect` (
  `rd_from` int(10) unsigned NOT NULL default '0',
  `rd_namespace` int(11) NOT NULL default '0',
  `rd_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  PRIMARY KEY  (`rd_from`),
  KEY `rd_ns_title` (`rd_namespace`,`rd_title`,`rd_from`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}revision`;
CREATE TABLE `{omcollab_db_table_prefix}revision` (
  `rev_id` int(10) unsigned NOT NULL auto_increment,
  `rev_page` int(10) unsigned NOT NULL,
  `rev_text_id` int(10) unsigned NOT NULL,
  `rev_comment` tinyblob NOT NULL,
  `rev_user` int(10) unsigned NOT NULL default '0',
  `rev_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `rev_timestamp` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `rev_minor_edit` tinyint(3) unsigned NOT NULL default '0',
  `rev_deleted` tinyint(3) unsigned NOT NULL default '0',
  `rev_len` int(10) unsigned default NULL,
  `rev_parent_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`rev_page`,`rev_id`),
  UNIQUE KEY `rev_id` (`rev_id`),
  KEY `rev_timestamp` (`rev_timestamp`),
  KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
  KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
  KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 MAX_ROWS=10000000 AVG_ROW_LENGTH=1024 AUTO_INCREMENT=22 ;

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

INSERT INTO `{omcollab_db_table_prefix}revision` (`rev_id`, `rev_page`, `rev_text_id`, `rev_comment`, `rev_user`, `rev_user_text`, `rev_timestamp`, `rev_minor_edit`, `rev_deleted`, `rev_len`, `rev_parent_id`) VALUES 
(1, 1, 1, '', 0, 'MediaWiki default', '20080605103804', 0, 0, 449, 0),
(7, 1, 7, '', 1, 'Admin', '20080613094938', 0, 0, 462, 1),
(8, 1, 8, '', 1, 'Admin', '20080613095129', 0, 0, 449, 7),
(9, 1, 9, '', 1, 'Admin', '20080613101539', 0, 0, 462, 8),
(11, 1, 11, '', 1, 'Admin', '20080701093337', 0, 0, 2739, 9),
(12, 1, 12, 0x2f2a204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465202a2f, 1, 'Admin', '20080701093511', 0, 0, 2723, 11),
(13, 1, 13, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701093548', 0, 0, 2719, 12),
(14, 1, 14, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701093630', 0, 0, 2718, 13),
(15, 1, 15, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701093724', 0, 0, 2708, 14),
(16, 1, 16, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701093857', 0, 0, 2720, 15),
(17, 1, 17, 0x2f2a204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69202a2f, 1, 'Admin', '20080701093941', 0, 0, 2715, 16),
(18, 1, 18, 0x2f2a204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473202a2f, 1, 'Admin', '20080701094023', 0, 0, 2722, 17),
(2, 2, 2, 0x4e657720706167653a207b7b236d656e753a202a5b5b6d61696e706167657c6d61696e706167655d5d202a5b5b5370656369616c3a526563656e746368616e6765737c526563656e74204368616e6765735d5d202a5b5b5370656369616c3a4e657770616765737c4e65776573742050616765735d5d202a5b5b5370656369616c3a52616e646f6d7c52616e646f6d20506167655d5d207d7d203c64697620636c6173733d2276697375616c436c656172223e3c2f6469763e5f5f4e4f4544495453454354492e2e2e, 1, 'Admin', '20080611094659', 0, 0, 192, 0),
(3, 2, 3, '', 1, 'Admin', '20080611094800', 0, 0, 227, 2),
(4, 2, 4, '', 1, 'Admin', '20080611094910', 0, 0, 224, 3),
(5, 3, 5, 0x4e657720706167653a204e6176696761746520746f202f6f6d57696b692f4d6564696157696b693a5369646562617220616e642065646974206173207265717569726564, 1, 'Admin', '20080611100915', 0, 0, 58, 0),
(6, 3, 6, '', 1, 'Admin', '20080611101510', 0, 0, 62, 5),
(19, 3, 19, '', 1, 'Admin', '20080701094712', 0, 0, 58, 6),
(20, 3, 20, '', 1, 'Admin', '20080701094746', 0, 0, 42, 19),
(21, 3, 21, '', 1, 'Admin', '20080701094814', 0, 0, 30, 20),
(10, 4, 10, 0x696d706f727420757365722077696b69, 1, 'Admin', '20080613121024', 0, 0, 262, 0);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}searchindex`;
CREATE TABLE `{omcollab_db_table_prefix}searchindex` (
  `si_page` int(10) unsigned NOT NULL,
  `si_title` varchar(255) NOT NULL default '',
  `si_text` mediumtext NOT NULL,
  UNIQUE KEY `si_page` (`si_page`),
  FULLTEXT KEY `si_title` (`si_title`),
  FULLTEXT KEY `si_text` (`si_text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `{omcollab_db_table_prefix}searchindex` (`si_page`, `si_title`, `si_text`) VALUES 
(2, 'sidebar', ' #menu main page home submenu example submenu item special recentchanges recent changes special newpages newest pages special random random page __noeditsection__ '),
(3, 'submenu', ' refer to mediawiki sidebar '),
(1, 'main page', '  mediawiki for omcollab has been successfully installed   consult the user user''s guide for information on using the wiki software getting started getting started getting started configuration settings list mediawiki faq mediawiki release mailing list a few examples a few examples a few examples below are three examples of pre-installed wiki extensions that enhance and extend the collaborative nature of the omcollab suite for the full list refer to special version example 1 links to assets of a particular type on an external wiki example 1 links to assets of a particular type on an external wiki example 1 links to assets of a particular type on an external wiki the links shown here are generated by the apiquery extension which is pre-installed action query; list categorymembers; cmcategory omcollab; cmlimit 10; the extension reaches out to an external wiki you configure the destination wiki in your localsettings php file and retrieves links to articles on that wiki which correspond to the apiquery settings specified in the wiki tag click view source or edit to see the tag in our example we are reaching out to the mike2 0 wiki and retrieving links to all articles there in the category ''omcollab'' use this method when you do not have credentials to query an external wiki directly example 2 bookmarks from an external omcollab bookmarks site example 2 bookmarks from an external omcollab bookmarks site example 2 bookmarks from an external omcollab bookmarks site the links shown here point to bookmarks on an external omcollab bookmarks or scuttle web site these require the ombookmarksexternal extension which is pre-installed with omcollab collaboration in this example we are displaying bookmarks from mike2 0 bookmarks where the term ''collaboration'' appears in a bookmark bookmark''s tag on that site to see the configuration options for this extension view source or edit this page use this extension when you want to display bookmarks from an external site example 3 locally bookmarked assets example 3 locally bookmarked assets example 3 locally bookmarked assets the links shown here are retrieved from your own instance of omcollab bookmarks using the pre-installed extension ''omcollabbookmarks omcollab you can configure the lookup attributes by editing or viewing the source of this page category test category '),
(4, 'admin', ' there is currently no text in this page you can special search toggleuserpage search for this page title in other pages or edit this page ');

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}site_stats`;
CREATE TABLE `{omcollab_db_table_prefix}site_stats` (
  `ss_row_id` int(10) unsigned NOT NULL,
  `ss_total_views` bigint(20) unsigned default '0',
  `ss_total_edits` bigint(20) unsigned default '0',
  `ss_good_articles` bigint(20) unsigned default '0',
  `ss_total_pages` bigint(20) default '-1',
  `ss_users` bigint(20) default '-1',
  `ss_admins` int(11) default '-1',
  `ss_images` int(11) default '0',
  `ss_active_users` bigint(20) DEFAULT '-1',
  UNIQUE KEY `ss_row_id` (`ss_row_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `{omcollab_db_table_prefix}site_stats`
-- 
INSERT INTO `{omcollab_db_table_prefix}site_stats` (`ss_row_id`, `ss_total_views`, `ss_total_edits`, `ss_good_articles`, `ss_total_pages`, `ss_users`, `ss_admins`, `ss_images`, `ss_active_users`) VALUES
(1, 100, 22, 2, 4, 1, 1, 0, 0);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}templatelinks`;
CREATE TABLE `{omcollab_db_table_prefix}templatelinks` (
  `tl_from` int(10) unsigned NOT NULL default '0',
  `tl_namespace` int(11) NOT NULL default '0',
  `tl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  UNIQUE KEY `tl_from` (`tl_from`,`tl_namespace`,`tl_title`),
  KEY `tl_namespace` (`tl_namespace`,`tl_title`,`tl_from`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}text`;
CREATE TABLE `{omcollab_db_table_prefix}text` (
  `old_id` int(10) unsigned NOT NULL auto_increment,
  `old_text` mediumblob NOT NULL,
  `old_flags` tinyblob NOT NULL,
  PRIMARY KEY  (`old_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 MAX_ROWS=10000000 AVG_ROW_LENGTH=10240 AUTO_INCREMENT=22 ;

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

INSERT INTO `{omcollab_db_table_prefix}text` (`old_id`, `old_text`, `old_flags`) VALUES 
(1, 0x3c6269673e2727274d6564696157696b6920686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d, 0x7574662d38),
(2, 0x7b7b236d656e753a0a2a5b5b6d61696e706167657c6d61696e706167655d5d0a2a5b5b5370656369616c3a526563656e746368616e6765737c526563656e74204368616e6765735d5d0a2a5b5b5370656369616c3a4e657770616765737c4e65776573742050616765735d5d0a2a5b5b5370656369616c3a52616e646f6d7c52616e646f6d20506167655d5d0a7d7d0a3c64697620636c6173733d2276697375616c436c656172223e3c2f6469763e5f5f4e4f4544495453454354494f4e5f5f, 0x7574662d38),
(3, 0x7b7b236d656e753a0a2a5b5b6d61696e706167657c6d61696e706167655d5d0a2a2a5b5b7375626d656e757c6578616d706c65207375626d656e75206974656d5d5d0a2a5b5b5370656369616c3a526563656e746368616e6765737c526563656e74204368616e6765735d5d0a2a5b5b5370656369616c3a4e657770616765737c4e65776573742050616765735d5d0a2a5b5b5370656369616c3a52616e646f6d7c52616e646f6d20506167655d5d0a7d7d0a3c64697620636c6173733d2276697375616c436c656172223e3c2f6469763e5f5f4e4f4544495453454354494f4e5f5f, 0x7574662d38),
(4, 0x7b7b236d656e753a0a2a5b5b4d61696e20506167657c486f6d655d5d0a2a2a5b5b7375626d656e757c6578616d706c65207375626d656e75206974656d5d5d0a2a5b5b5370656369616c3a526563656e746368616e6765737c526563656e74204368616e6765735d5d0a2a5b5b5370656369616c3a4e657770616765737c4e65776573742050616765735d5d0a2a5b5b5370656369616c3a52616e646f6d7c52616e646f6d20506167655d5d0a7d7d0a3c64697620636c6173733d2276697375616c436c656172223e3c2f6469763e5f5f4e4f4544495453454354494f4e5f5f, 0x7574662d38),
(5, 0x4e6176696761746520746f202f6f6d57696b692f4d6564696157696b693a5369646562617220616e642065646974206173207265717569726564, 0x7574662d38),
(6, 0x526566657220746f202f6f6d57696b692f696e6465782e7068703f7469746c653d4d6564696157696b693a5369646562617226616374696f6e3d65646974, 0x7574662d38),
(7, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d, 0x7574662d38),
(8, 0x3c6269673e2727274d6564696157696b6920686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d, 0x7574662d38),
(9, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d, 0x7574662d38),
(10, 0x3c64697620636c6173733d276e6f61727469636c6574657874273e54686572652069732063757272656e746c79206e6f207465787420696e207468697320706167652c20796f752063616e205b5b5370656369616c3a5365617263682f546f67676c6555736572506167657c73656172636820666f7220746869732070616765207469746c655d5d20696e206f74686572207061676573206f72205b687474703a2f2f6f6d636f6c6c61622e6c6f63616c686f73742f6f6d57696b692f696e6465782e7068703f7469746c653d5370656369616c3a546f67676c65557365725061676526616374696f6e3d656469742065646974207468697320706167655d2e3c2f6469763e, 0x7574662d38),
(11, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d0a0a0a3d3d204120666577206578616d706c6573203d3d0a42656c6f7720617265207468726565206578616d706c6573206f66207072652d696e7374616c6c65642077696b6920657874656e73696f6e73207468617420656e68616e636520616e6420657874656e642074686520636f6c6c61626f726174697665206e6174757265206f6620746865206f6d436f6c6c61622053756974652e20466f72207468652066756c6c206c6973742c20726566657220746f205b5b5370656369616c3a56657273696f6e5d5d2e0a0a3d3d204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69203d3d0a0a546865206c696e6b732073686f776e2068657265206172652067656e6572617465642062792074686520415049517565727920657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642e200a0a3c6170697175657279200a646973706c6179747970653d22626c6f67726f6c6c22200a7469746c653d2245787465726e616c2077696b692061727469636c65732061626f7574204f6d436f6c6c61623a223e0a616374696f6e3d71756572793b0a6c6973743d63617465676f72796d656d626572733b0a636d63617465676f72793d4f6d436f6c6c61623b0a636d6c696d69743d3530303b0a3c2f61706971756572793e0a0a54686520657874656e73696f6e2072656163686573206f757420746f20616e2065787465726e616c2077696b692028796f7520636f6e666967757265207468652064657374696e6174696f6e2077696b6920696e20796f7572204c6f63616c53657474696e67732e7068702066696c652920616e6420726574726965766573206c696e6b7320746f2061727469636c6573206f6e20746861742077696b6920776869636820636f72726573706f6e6420746f207468652061706971756572792073657474696e67732073706563696669656420696e207468652077696b69207461672028636c69636b207669657720736f757263652c206f7220656469742c20746f207365652074686520746167292e0a0a496e206f7572206578616d706c652c20776520617265207265616368696e67206f757420746f20746865204d494b45322e302077696b692028687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f77696b692920616e642072657472696576696e67206c696e6b7320746f20616c6c2061727469636c65732074686572652c20696e207468652063617465676f727920274f6d436f6c6c6162272e0a0a5573652074686973206d6574686f64207768656e20796f7520646f206e6f7420686176652063726564656e7469616c7320746f20717565727920616e2065787465726e616c2077696b69206469726563746c792e0a0a0a3d3d204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465203d3d0a0a546865206c696e6b732073686f776e206865726520706f696e7420746f20626f6f6b6d61726b73206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320286f722053637574746c65292077656220736974652e205468657365207265717569726520746865206f6d426f6f6b6d61726b7345787465726e616c20657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642077697468204f6d436f6c6c61622e0a0a3c6f6d636f6c6c6162626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c22200a696e707574747970653d227461677322200a736561726368747970653d227465726d22200a7469746c653d2241727469636c6573206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320736974653a220a3e636f6c6c61626f726174696f6e3c2f6f6d636f6c6c6162626f6f6b6d61726b733e0a0a496e2074686973206578616d706c652c2077652061726520646973706c6179696e6720626f6f6b6d61726b732066726f6d204d494b45322e3020426f6f6b6d61726b732028687474703a2f2f6d696b652e6f70656e6d6574686f646f6c6f67792e6f72672f626f6f6b6d61726b732920776865726520746865207465726d2027636f6c6c61626f726174696f6e27206170706561727320696e206120626f6f6b6d61726b277320746167206f6e207468617420736974652e20546f207365652074686520636f6e66696775726174696f6e206f7074696f6e7320666f72207468697320657874656e73696f6e2c207669657720736f75726365206f722065646974207468697320706167652e0a0a557365207468697320657874656e73696f6e207768656e20796f752077616e7420746f20646973706c617920626f6f6b6d61726b732066726f6d20616e2065787465726e616c20736974652e0a0a0a3d3d204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473203d3d0a0a546865206c696e6b732073686f776e206865726520617265207265747269657665642066726f6d20796f7572206f776e20696e7374616e6365206f66206f6d436f6c6c616220426f6f6b6d61726b732c207573696e6720746865207072652d696e7374616c6c656420657874656e73696f6e20276f6d436f6c6c6162426f6f6b6d61726b73272e0a3c6f6d436f6c6c6162426f6f6b6d61726b73200a646973706c6179747970653d22626c6f67726f6c6c22200a696e707574747970653d227461677322200a736561726368747970653d227465726d22200a7469746c653d224c6f63616c6c7920736176656420626f6f6b6d61726b73223e6f6d636f6c6c61623c2f6f6d436f6c6c6162426f6f6b6d61726b733e0a0a596f752063616e20636f6e66696775726520746865206c6f6f6b757020617474726962757465732062792065646974696e67206f722076696577696e672074686520736f75726365206f66207468697320706167652e0a0a5b5b43617465676f72793a546573742043617465676f72795d5d, 0x7574662d38),
(12, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d0a0a0a3d3d204120666577206578616d706c6573203d3d0a42656c6f7720617265207468726565206578616d706c6573206f66207072652d696e7374616c6c65642077696b6920657874656e73696f6e73207468617420656e68616e636520616e6420657874656e642074686520636f6c6c61626f726174697665206e6174757265206f6620746865206f6d436f6c6c61622053756974652e20466f72207468652066756c6c206c6973742c20726566657220746f205b5b5370656369616c3a56657273696f6e5d5d2e0a0a3d3d204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69203d3d0a0a546865206c696e6b732073686f776e2068657265206172652067656e6572617465642062792074686520415049517565727920657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642e200a0a3c6170697175657279200a646973706c6179747970653d22626c6f67726f6c6c22200a7469746c653d2245787465726e616c2077696b692061727469636c65732061626f7574204f6d436f6c6c61623a223e0a616374696f6e3d71756572793b0a6c6973743d63617465676f72796d656d626572733b0a636d63617465676f72793d4f6d436f6c6c61623b0a636d6c696d69743d3530303b0a3c2f61706971756572793e0a0a54686520657874656e73696f6e2072656163686573206f757420746f20616e2065787465726e616c2077696b692028796f7520636f6e666967757265207468652064657374696e6174696f6e2077696b6920696e20796f7572204c6f63616c53657474696e67732e7068702066696c652920616e6420726574726965766573206c696e6b7320746f2061727469636c6573206f6e20746861742077696b6920776869636820636f72726573706f6e6420746f207468652061706971756572792073657474696e67732073706563696669656420696e207468652077696b69207461672028636c69636b207669657720736f757263652c206f7220656469742c20746f207365652074686520746167292e0a0a496e206f7572206578616d706c652c20776520617265207265616368696e67206f757420746f20746865204d494b45322e302077696b692028687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f77696b692920616e642072657472696576696e67206c696e6b7320746f20616c6c2061727469636c65732074686572652c20696e207468652063617465676f727920274f6d436f6c6c6162272e0a0a5573652074686973206d6574686f64207768656e20796f7520646f206e6f7420686176652063726564656e7469616c7320746f20717565727920616e2065787465726e616c2077696b69206469726563746c792e0a0a0a3d3d204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465203d3d0a0a546865206c696e6b732073686f776e206865726520706f696e7420746f20626f6f6b6d61726b73206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320286f722053637574746c65292077656220736974652e205468657365207265717569726520746865206f6d426f6f6b6d61726b7345787465726e616c20657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642077697468204f6d436f6c6c61622e0a0a3c6f6d626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d2241727469636c6573206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320736974653a220a3e636f6c6c61626f726174696f6e3c2f6f6d626f6f6b6d61726b733e0a0a496e2074686973206578616d706c652c2077652061726520646973706c6179696e6720626f6f6b6d61726b732066726f6d204d494b45322e3020426f6f6b6d61726b732028687474703a2f2f6d696b652e6f70656e6d6574686f646f6c6f67792e6f72672f626f6f6b6d61726b732920776865726520746865207465726d2027636f6c6c61626f726174696f6e27206170706561727320696e206120626f6f6b6d61726b277320746167206f6e207468617420736974652e20546f207365652074686520636f6e66696775726174696f6e206f7074696f6e7320666f72207468697320657874656e73696f6e2c207669657720736f75726365206f722065646974207468697320706167652e0a0a557365207468697320657874656e73696f6e207768656e20796f752077616e7420746f20646973706c617920626f6f6b6d61726b732066726f6d20616e2065787465726e616c20736974652e0a0a3d3d204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473203d3d0a0a546865206c696e6b732073686f776e206865726520617265207265747269657665642066726f6d20796f7572206f776e20696e7374616e6365206f66206f6d436f6c6c616220426f6f6b6d61726b732c207573696e6720746865207072652d696e7374616c6c656420657874656e73696f6e20276f6d436f6c6c6162426f6f6b6d61726b73272e0a3c6f6d436f6c6c6162426f6f6b6d61726b73200a646973706c6179747970653d22626c6f67726f6c6c22200a696e707574747970653d227461677322200a736561726368747970653d227465726d22200a7469746c653d224c6f63616c6c7920736176656420626f6f6b6d61726b73223e6f6d636f6c6c61623c2f6f6d436f6c6c6162426f6f6b6d61726b733e0a0a596f752063616e20636f6e66696775726520746865206c6f6f6b757020617474726962757465732062792065646974696e67206f722076696577696e672074686520736f75726365206f66207468697320706167652e0a0a5b5b43617465676f72793a546573742043617465676f72795d5d, 0x7574662d38),
(13, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d0a0a0a3d3d204120666577206578616d706c6573203d3d0a42656c6f7720617265207468726565206578616d706c6573206f66207072652d696e7374616c6c65642077696b6920657874656e73696f6e73207468617420656e68616e636520616e6420657874656e642074686520636f6c6c61626f726174697665206e6174757265206f6620746865206f6d436f6c6c61622053756974652e20466f72207468652066756c6c206c6973742c20726566657220746f205b5b5370656369616c3a56657273696f6e5d5d2e0a0a3d3d204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69203d3d0a0a546865206c696e6b732073686f776e2068657265206172652067656e6572617465642062792074686520415049517565727920657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642e200a0a3c6170697175657279200a646973706c6179747970653d22626c6f67726f6c6c22200a7469746c653d2245787465726e616c2077696b692061727469636c65732061626f7574204f6d436f6c6c61623a223e0a616374696f6e3d71756572793b0a6c6973743d63617465676f72796d656d626572733b0a636d63617465676f72793d4f6d436f6c6c61623b0a636d6c696d69743d3530303b0a3c2f61706971756572793e0a0a54686520657874656e73696f6e2072656163686573206f757420746f20616e2065787465726e616c2077696b692028796f7520636f6e666967757265207468652064657374696e6174696f6e2077696b6920696e20796f7572204c6f63616c53657474696e67732e7068702066696c652920616e6420726574726965766573206c696e6b7320746f2061727469636c6573206f6e20746861742077696b6920776869636820636f72726573706f6e6420746f207468652061706971756572792073657474696e67732073706563696669656420696e207468652077696b69207461672028636c69636b207669657720736f757263652c206f7220656469742c20746f207365652074686520746167292e0a0a496e206f7572206578616d706c652c20776520617265207265616368696e67206f757420746f20746865204d494b45322e302077696b692028687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f77696b692920616e642072657472696576696e67206c696e6b7320746f20616c6c2061727469636c65732074686572652c20696e207468652063617465676f727920274f6d436f6c6c6162272e0a0a5573652074686973206d6574686f64207768656e20796f7520646f206e6f7420686176652063726564656e7469616c7320746f20717565727920616e2065787465726e616c2077696b69206469726563746c792e0a0a0a3d3d204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465203d3d0a0a546865206c696e6b732073686f776e206865726520706f696e7420746f20626f6f6b6d61726b73206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320286f722053637574746c65292077656220736974652e205468657365207265717569726520746865206f6d426f6f6b6d61726b7345787465726e616c20657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642077697468204f6d436f6c6c61622e0a0a3c6f6d626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d2241727469636c6573206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320736974653a220a3e636f6c6c61626f726174696f6e3c2f6f6d626f6f6b6d61726b733e0a0a496e2074686973206578616d706c652c2077652061726520646973706c6179696e6720626f6f6b6d61726b732066726f6d204d494b45322e3020426f6f6b6d61726b732028687474703a2f2f6d696b652e6f70656e6d6574686f646f6c6f67792e6f72672f626f6f6b6d61726b732920776865726520746865207465726d2027636f6c6c61626f726174696f6e27206170706561727320696e206120626f6f6b6d61726b277320746167206f6e207468617420736974652e20546f207365652074686520636f6e66696775726174696f6e206f7074696f6e7320666f72207468697320657874656e73696f6e2c207669657720736f75726365206f722065646974207468697320706167652e0a0a557365207468697320657874656e73696f6e207768656e20796f752077616e7420746f20646973706c617920626f6f6b6d61726b732066726f6d20616e2065787465726e616c20736974652e0a0a3d3d204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473203d3d0a0a546865206c696e6b732073686f776e206865726520617265207265747269657665642066726f6d20796f7572206f776e20696e7374616e6365206f66206f6d436f6c6c616220426f6f6b6d61726b732c207573696e6720746865207072652d696e7374616c6c656420657874656e73696f6e20276f6d436f6c6c6162426f6f6b6d61726b73272e0a3c6f6d636f6c6c6162626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d224c6f63616c6c7920736176656420626f6f6b6d61726b73223e6f6d636f6c6c61623c2f6f6d636f6c6c6162626f6f6b6d61726b733e0a0a596f752063616e20636f6e66696775726520746865206c6f6f6b757020617474726962757465732062792065646974696e67206f722076696577696e672074686520736f75726365206f66207468697320706167652e0a0a5b5b43617465676f72793a546573742043617465676f72795d5d, 0x7574662d38),
(14, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d0a0a0a3d3d204120666577206578616d706c6573203d3d0a42656c6f7720617265207468726565206578616d706c6573206f66207072652d696e7374616c6c65642077696b6920657874656e73696f6e73207468617420656e68616e636520616e6420657874656e642074686520636f6c6c61626f726174697665206e6174757265206f6620746865206f6d436f6c6c61622053756974652e20466f72207468652066756c6c206c6973742c20726566657220746f205b5b5370656369616c3a56657273696f6e5d5d2e0a0a3d3d204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69203d3d0a0a546865206c696e6b732073686f776e2068657265206172652067656e6572617465642062792074686520415049517565727920657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642e200a0a3c6170697175657279200a646973706c6179747970653d22626c6f67726f6c6c22200a7469746c653d2245787465726e616c2077696b692061727469636c65732061626f7574204f6d436f6c6c61623a223e0a616374696f6e3d71756572793b0a6c6973743d63617465676f72796d656d626572733b0a636d63617465676f72793d4f6d436f6c6c61623b0a636d6c696d69743d3530303b0a3c2f61706971756572793e0a0a54686520657874656e73696f6e2072656163686573206f757420746f20616e2065787465726e616c2077696b692028796f7520636f6e666967757265207468652064657374696e6174696f6e2077696b6920696e20796f7572204c6f63616c53657474696e67732e7068702066696c652920616e6420726574726965766573206c696e6b7320746f2061727469636c6573206f6e20746861742077696b6920776869636820636f72726573706f6e6420746f207468652061706971756572792073657474696e67732073706563696669656420696e207468652077696b69207461672028636c69636b207669657720736f757263652c206f7220656469742c20746f207365652074686520746167292e0a0a496e206f7572206578616d706c652c20776520617265207265616368696e67206f757420746f20746865204d494b45322e302077696b692028687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f77696b692920616e642072657472696576696e67206c696e6b7320746f20616c6c2061727469636c65732074686572652c20696e207468652063617465676f727920274f6d436f6c6c6162272e0a0a5573652074686973206d6574686f64207768656e20796f7520646f206e6f7420686176652063726564656e7469616c7320746f20717565727920616e2065787465726e616c2077696b69206469726563746c792e0a0a0a3d3d204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465203d3d0a0a546865206c696e6b732073686f776e206865726520706f696e7420746f20626f6f6b6d61726b73206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320286f722053637574746c65292077656220736974652e205468657365207265717569726520746865206f6d426f6f6b6d61726b7345787465726e616c20657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642077697468204f6d436f6c6c61622e0a0a3c6f6d626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d2241727469636c6573206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320736974653a220a3e636f6c6c61626f726174696f6e3c2f6f6d626f6f6b6d61726b733e0a0a496e2074686973206578616d706c652c2077652061726520646973706c6179696e6720626f6f6b6d61726b732066726f6d204d494b45322e3020426f6f6b6d61726b732028687474703a2f2f6d696b652e6f70656e6d6574686f646f6c6f67792e6f72672f626f6f6b6d61726b732920776865726520746865207465726d2027636f6c6c61626f726174696f6e27206170706561727320696e206120626f6f6b6d61726b277320746167206f6e207468617420736974652e20546f207365652074686520636f6e66696775726174696f6e206f7074696f6e7320666f72207468697320657874656e73696f6e2c207669657720736f75726365206f722065646974207468697320706167652e0a0a557365207468697320657874656e73696f6e207768656e20796f752077616e7420746f20646973706c617920626f6f6b6d61726b732066726f6d20616e2065787465726e616c20736974652e0a0a3d3d204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473203d3d0a0a546865206c696e6b732073686f776e206865726520617265207265747269657665642066726f6d20796f7572206f776e20696e7374616e6365206f66206f6d436f6c6c616220426f6f6b6d61726b732c207573696e6720746865207072652d696e7374616c6c656420657874656e73696f6e20276f6d436f6c6c6162426f6f6b6d61726b73272e0a3c73637574746c65626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d224c6f63616c6c7920736176656420626f6f6b6d61726b73220a3e6f6d636f6c6c61623c2f73637574746c65626f6f6b6d61726b733e0a0a596f752063616e20636f6e66696775726520746865206c6f6f6b757020617474726962757465732062792065646974696e67206f722076696577696e672074686520736f75726365206f66207468697320706167652e0a0a5b5b43617465676f72793a546573742043617465676f72795d5d, 0x7574662d38),
(15, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d0a0a0a3d3d204120666577206578616d706c6573203d3d0a42656c6f7720617265207468726565206578616d706c6573206f66207072652d696e7374616c6c65642077696b6920657874656e73696f6e73207468617420656e68616e636520616e6420657874656e642074686520636f6c6c61626f726174697665206e6174757265206f6620746865206f6d436f6c6c61622053756974652e20466f72207468652066756c6c206c6973742c20726566657220746f205b5b5370656369616c3a56657273696f6e5d5d2e0a0a3d3d204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69203d3d0a0a546865206c696e6b732073686f776e2068657265206172652067656e6572617465642062792074686520415049517565727920657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642e200a0a3c6170697175657279200a646973706c6179747970653d22626c6f67726f6c6c22200a7469746c653d2245787465726e616c2077696b692061727469636c65732061626f7574204f6d436f6c6c61623a223e0a616374696f6e3d71756572793b0a6c6973743d63617465676f72796d656d626572733b0a636d63617465676f72793d4f6d436f6c6c61623b0a636d6c696d69743d3530303b0a3c2f61706971756572793e0a0a54686520657874656e73696f6e2072656163686573206f757420746f20616e2065787465726e616c2077696b692028796f7520636f6e666967757265207468652064657374696e6174696f6e2077696b6920696e20796f7572204c6f63616c53657474696e67732e7068702066696c652920616e6420726574726965766573206c696e6b7320746f2061727469636c6573206f6e20746861742077696b6920776869636820636f72726573706f6e6420746f207468652061706971756572792073657474696e67732073706563696669656420696e207468652077696b69207461672028636c69636b207669657720736f757263652c206f7220656469742c20746f207365652074686520746167292e0a0a496e206f7572206578616d706c652c20776520617265207265616368696e67206f757420746f20746865204d494b45322e302077696b692028687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f77696b692920616e642072657472696576696e67206c696e6b7320746f20616c6c2061727469636c65732074686572652c20696e207468652063617465676f727920274f6d436f6c6c6162272e0a0a5573652074686973206d6574686f64207768656e20796f7520646f206e6f7420686176652063726564656e7469616c7320746f20717565727920616e2065787465726e616c2077696b69206469726563746c792e0a0a0a3d3d204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465203d3d0a0a546865206c696e6b732073686f776e206865726520706f696e7420746f20626f6f6b6d61726b73206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320286f722053637574746c65292077656220736974652e205468657365207265717569726520746865206f6d426f6f6b6d61726b7345787465726e616c20657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642077697468204f6d436f6c6c61622e0a0a3c6f6d626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d2241727469636c6573206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320736974653a220a3e636f6c6c61626f726174696f6e3c2f6f6d626f6f6b6d61726b733e0a0a496e2074686973206578616d706c652c2077652061726520646973706c6179696e6720626f6f6b6d61726b732066726f6d204d494b45322e3020426f6f6b6d61726b732028687474703a2f2f6d696b652e6f70656e6d6574686f646f6c6f67792e6f72672f626f6f6b6d61726b732920776865726520746865207465726d2027636f6c6c61626f726174696f6e27206170706561727320696e206120626f6f6b6d61726b277320746167206f6e207468617420736974652e20546f207365652074686520636f6e66696775726174696f6e206f7074696f6e7320666f72207468697320657874656e73696f6e2c207669657720736f75726365206f722065646974207468697320706167652e0a0a557365207468697320657874656e73696f6e207768656e20796f752077616e7420746f20646973706c617920626f6f6b6d61726b732066726f6d20616e2065787465726e616c20736974652e0a0a3d3d204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473203d3d0a0a546865206c696e6b732073686f776e206865726520617265207265747269657665642066726f6d20796f7572206f776e20696e7374616e6365206f66206f6d436f6c6c616220426f6f6b6d61726b732c207573696e6720746865207072652d696e7374616c6c656420657874656e73696f6e20276f6d436f6c6c6162426f6f6b6d61726b73272e0a3c6f6d626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d224c6f63616c6c7920736176656420626f6f6b6d61726b73220a3e6f6d636f6c6c61623c2f6f6d626f6f6b6d61726b733e0a0a596f752063616e20636f6e66696775726520746865206c6f6f6b757020617474726962757465732062792065646974696e67206f722076696577696e672074686520736f75726365206f66207468697320706167652e0a0a5b5b43617465676f72793a546573742043617465676f72795d5d, 0x7574662d38),
(16, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d0a0a0a3d3d204120666577206578616d706c6573203d3d0a42656c6f7720617265207468726565206578616d706c6573206f66207072652d696e7374616c6c65642077696b6920657874656e73696f6e73207468617420656e68616e636520616e6420657874656e642074686520636f6c6c61626f726174697665206e6174757265206f6620746865206f6d436f6c6c61622053756974652e20466f72207468652066756c6c206c6973742c20726566657220746f205b5b5370656369616c3a56657273696f6e5d5d2e0a0a3d3d204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69203d3d0a0a546865206c696e6b732073686f776e2068657265206172652067656e6572617465642062792074686520415049517565727920657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642e200a0a3c6170697175657279200a646973706c6179747970653d22626c6f67726f6c6c22200a7469746c653d2245787465726e616c2077696b692061727469636c65732061626f7574204f6d436f6c6c61623a223e0a616374696f6e3d71756572793b0a6c6973743d63617465676f72796d656d626572733b0a636d63617465676f72793d4f6d436f6c6c61623b0a636d6c696d69743d3530303b0a3c2f61706971756572793e0a0a54686520657874656e73696f6e2072656163686573206f757420746f20616e2065787465726e616c2077696b692028796f7520636f6e666967757265207468652064657374696e6174696f6e2077696b6920696e20796f7572204c6f63616c53657474696e67732e7068702066696c652920616e6420726574726965766573206c696e6b7320746f2061727469636c6573206f6e20746861742077696b6920776869636820636f72726573706f6e6420746f207468652061706971756572792073657474696e67732073706563696669656420696e207468652077696b69207461672028636c69636b207669657720736f757263652c206f7220656469742c20746f207365652074686520746167292e0a0a496e206f7572206578616d706c652c20776520617265207265616368696e67206f757420746f20746865204d494b45322e302077696b692028687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f77696b692920616e642072657472696576696e67206c696e6b7320746f20616c6c2061727469636c65732074686572652c20696e207468652063617465676f727920274f6d436f6c6c6162272e0a0a5573652074686973206d6574686f64207768656e20796f7520646f206e6f7420686176652063726564656e7469616c7320746f20717565727920616e2065787465726e616c2077696b69206469726563746c792e0a0a0a3d3d204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465203d3d0a0a546865206c696e6b732073686f776e206865726520706f696e7420746f20626f6f6b6d61726b73206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320286f722053637574746c65292077656220736974652e205468657365207265717569726520746865206f6d426f6f6b6d61726b7345787465726e616c20657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642077697468204f6d436f6c6c61622e0a0a3c6f6d626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d2241727469636c6573206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320736974653a220a3e636f6c6c61626f726174696f6e3c2f6f6d626f6f6b6d61726b733e0a0a496e2074686973206578616d706c652c2077652061726520646973706c6179696e6720626f6f6b6d61726b732066726f6d204d494b45322e3020426f6f6b6d61726b732028687474703a2f2f6d696b652e6f70656e6d6574686f646f6c6f67792e6f72672f626f6f6b6d61726b732920776865726520746865207465726d2027636f6c6c61626f726174696f6e27206170706561727320696e206120626f6f6b6d61726b277320746167206f6e207468617420736974652e20546f207365652074686520636f6e66696775726174696f6e206f7074696f6e7320666f72207468697320657874656e73696f6e2c207669657720736f75726365206f722065646974207468697320706167652e0a0a557365207468697320657874656e73696f6e207768656e20796f752077616e7420746f20646973706c617920626f6f6b6d61726b732066726f6d20616e2065787465726e616c20736974652e0a0a3d3d204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473203d3d0a0a546865206c696e6b732073686f776e206865726520617265207265747269657665642066726f6d20796f7572206f776e20696e7374616e6365206f66206f6d436f6c6c616220426f6f6b6d61726b732c207573696e6720746865207072652d696e7374616c6c656420657874656e73696f6e20276f6d436f6c6c6162426f6f6b6d61726b73272e0a3c6f6d436f6c6c6162426f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d224c6f63616c6c7920736176656420626f6f6b6d61726b73220a3e6f6d636f6c6c61623c2f6f6d436f6c6c6162426f6f6b6d61726b733e0a0a596f752063616e20636f6e66696775726520746865206c6f6f6b757020617474726962757465732062792065646974696e67206f722076696577696e672074686520736f75726365206f66207468697320706167652e0a0a5b5b43617465676f72793a546573742043617465676f72795d5d, 0x7574662d38),
(17, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d0a0a0a3d3d204120666577206578616d706c6573203d3d0a42656c6f7720617265207468726565206578616d706c6573206f66207072652d696e7374616c6c65642077696b6920657874656e73696f6e73207468617420656e68616e636520616e6420657874656e642074686520636f6c6c61626f726174697665206e6174757265206f6620746865206f6d436f6c6c61622053756974652e20466f72207468652066756c6c206c6973742c20726566657220746f205b5b5370656369616c3a56657273696f6e5d5d2e0a0a3d3d204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69203d3d0a0a546865206c696e6b732073686f776e2068657265206172652067656e6572617465642062792074686520415049517565727920657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642e0a0a3c61706971756572790a646973706c6179747970653d22626c6f67726f6c6c220a7469746c653d2245787465726e616c2077696b692061727469636c65732061626f7574204f6d436f6c6c61623a223e0a616374696f6e3d71756572793b0a6c6973743d63617465676f72796d656d626572733b0a636d63617465676f72793d4f6d436f6c6c61623b0a636d6c696d69743d31303b0a3c2f61706971756572793e0a0a54686520657874656e73696f6e2072656163686573206f757420746f20616e2065787465726e616c2077696b692028796f7520636f6e666967757265207468652064657374696e6174696f6e2077696b6920696e20796f7572204c6f63616c53657474696e67732e7068702066696c652920616e6420726574726965766573206c696e6b7320746f2061727469636c6573206f6e20746861742077696b6920776869636820636f72726573706f6e6420746f207468652061706971756572792073657474696e67732073706563696669656420696e207468652077696b69207461672028636c69636b207669657720736f757263652c206f7220656469742c20746f207365652074686520746167292e0a0a496e206f7572206578616d706c652c20776520617265207265616368696e67206f757420746f20746865204d494b45322e302077696b692028687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f77696b692920616e642072657472696576696e67206c696e6b7320746f20616c6c2061727469636c65732074686572652c20696e207468652063617465676f727920274f6d436f6c6c6162272e0a0a5573652074686973206d6574686f64207768656e20796f7520646f206e6f7420686176652063726564656e7469616c7320746f20717565727920616e2065787465726e616c2077696b69206469726563746c792e0a0a3d3d204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465203d3d0a0a546865206c696e6b732073686f776e206865726520706f696e7420746f20626f6f6b6d61726b73206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320286f722053637574746c65292077656220736974652e205468657365207265717569726520746865206f6d426f6f6b6d61726b7345787465726e616c20657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642077697468204f6d436f6c6c61622e0a0a3c6f6d626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d2241727469636c6573206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320736974653a220a3e636f6c6c61626f726174696f6e3c2f6f6d626f6f6b6d61726b733e0a0a496e2074686973206578616d706c652c2077652061726520646973706c6179696e6720626f6f6b6d61726b732066726f6d204d494b45322e3020426f6f6b6d61726b732028687474703a2f2f6d696b652e6f70656e6d6574686f646f6c6f67792e6f72672f626f6f6b6d61726b732920776865726520746865207465726d2027636f6c6c61626f726174696f6e27206170706561727320696e206120626f6f6b6d61726b277320746167206f6e207468617420736974652e20546f207365652074686520636f6e66696775726174696f6e206f7074696f6e7320666f72207468697320657874656e73696f6e2c207669657720736f75726365206f722065646974207468697320706167652e0a0a557365207468697320657874656e73696f6e207768656e20796f752077616e7420746f20646973706c617920626f6f6b6d61726b732066726f6d20616e2065787465726e616c20736974652e0a0a3d3d204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473203d3d0a0a546865206c696e6b732073686f776e206865726520617265207265747269657665642066726f6d20796f7572206f776e20696e7374616e6365206f66206f6d436f6c6c616220426f6f6b6d61726b732c207573696e6720746865207072652d696e7374616c6c656420657874656e73696f6e20276f6d436f6c6c6162426f6f6b6d61726b73272e0a3c6f6d436f6c6c6162426f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d224c6f63616c6c7920736176656420626f6f6b6d61726b73220a3e6f6d636f6c6c61623c2f6f6d436f6c6c6162426f6f6b6d61726b733e0a0a596f752063616e20636f6e66696775726520746865206c6f6f6b757020617474726962757465732062792065646974696e67206f722076696577696e672074686520736f75726365206f66207468697320706167652e0a0a5b5b43617465676f72793a546573742043617465676f72795d5d, 0x7574662d38),
(18, 0x3c6269673e2727274d6564696157696b6920666f72206f6d436f6c6c616220686173206265656e207375636365737366756c6c7920696e7374616c6c65642e2727273c2f6269673e0a0a436f6e73756c7420746865205b687474703a2f2f6d6574612e77696b696d656469612e6f72672f77696b692f48656c703a436f6e74656e7473205573657227732047756964655d20666f7220696e666f726d6174696f6e206f6e207573696e67207468652077696b6920736f6674776172652e0a0a3d3d2047657474696e672073746172746564203d3d0a0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a436f6e66696775726174696f6e5f73657474696e677320436f6e66696775726174696f6e2073657474696e6773206c6973745d0a2a205b687474703a2f2f7777772e6d6564696177696b692e6f72672f77696b692f4d616e75616c3a464151204d6564696157696b69204641515d0a2a205b687474703a2f2f6c697374732e77696b696d656469612e6f72672f6d61696c6d616e2f6c697374696e666f2f6d6564696177696b692d616e6e6f756e6365204d6564696157696b692072656c65617365206d61696c696e67206c6973745d0a0a0a3d3d204120666577206578616d706c6573203d3d0a42656c6f7720617265207468726565206578616d706c6573206f66207072652d696e7374616c6c65642077696b6920657874656e73696f6e73207468617420656e68616e636520616e6420657874656e642074686520636f6c6c61626f726174697665206e6174757265206f6620746865206f6d436f6c6c61622053756974652e20466f72207468652066756c6c206c6973742c20726566657220746f205b5b5370656369616c3a56657273696f6e5d5d2e0a0a3d3d204578616d706c6520313a204c696e6b7320746f20617373657473206f66206120706172746963756c617220747970652c206f6e20616e2065787465726e616c2077696b69203d3d0a0a546865206c696e6b732073686f776e2068657265206172652067656e6572617465642062792074686520415049517565727920657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642e0a0a3c61706971756572790a646973706c6179747970653d22626c6f67726f6c6c220a7469746c653d2245787465726e616c2077696b692061727469636c65732061626f7574204f6d436f6c6c61623a223e0a616374696f6e3d71756572793b0a6c6973743d63617465676f72796d656d626572733b0a636d63617465676f72793d4f6d436f6c6c61623b0a636d6c696d69743d31303b0a3c2f61706971756572793e0a0a54686520657874656e73696f6e2072656163686573206f757420746f20616e2065787465726e616c2077696b692028796f7520636f6e666967757265207468652064657374696e6174696f6e2077696b6920696e20796f7572204c6f63616c53657474696e67732e7068702066696c652920616e6420726574726965766573206c696e6b7320746f2061727469636c6573206f6e20746861742077696b6920776869636820636f72726573706f6e6420746f207468652061706971756572792073657474696e67732073706563696669656420696e207468652077696b69207461672028636c69636b207669657720736f757263652c206f7220656469742c20746f207365652074686520746167292e0a0a496e206f7572206578616d706c652c20776520617265207265616368696e67206f757420746f20746865204d494b45322e302077696b692028687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f77696b692920616e642072657472696576696e67206c696e6b7320746f20616c6c2061727469636c65732074686572652c20696e207468652063617465676f727920274f6d436f6c6c6162272e0a0a5573652074686973206d6574686f64207768656e20796f7520646f206e6f7420686176652063726564656e7469616c7320746f20717565727920616e2065787465726e616c2077696b69206469726563746c792e0a0a3d3d204578616d706c6520323a20426f6f6b6d61726b732066726f6d20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b732073697465203d3d0a0a546865206c696e6b732073686f776e206865726520706f696e7420746f20626f6f6b6d61726b73206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320286f722053637574746c65292077656220736974652e205468657365207265717569726520746865206f6d426f6f6b6d61726b7345787465726e616c20657874656e73696f6e2c207768696368206973207072652d696e7374616c6c65642077697468204f6d436f6c6c61622e0a0a3c6f6d626f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d2274616773220a736561726368747970653d227465726d220a7469746c653d2241727469636c6573206f6e20616e2065787465726e616c206f6d436f6c6c616220426f6f6b6d61726b7320736974653a220a3e636f6c6c61626f726174696f6e3c2f6f6d626f6f6b6d61726b733e0a0a496e2074686973206578616d706c652c2077652061726520646973706c6179696e6720626f6f6b6d61726b732066726f6d204d494b45322e3020426f6f6b6d61726b732028687474703a2f2f6d696b652e6f70656e6d6574686f646f6c6f67792e6f72672f626f6f6b6d61726b732920776865726520746865207465726d2027636f6c6c61626f726174696f6e27206170706561727320696e206120626f6f6b6d61726b277320746167206f6e207468617420736974652e20546f207365652074686520636f6e66696775726174696f6e206f7074696f6e7320666f72207468697320657874656e73696f6e2c207669657720736f75726365206f722065646974207468697320706167652e0a0a557365207468697320657874656e73696f6e207768656e20796f752077616e7420746f20646973706c617920626f6f6b6d61726b732066726f6d20616e2065787465726e616c20736974652e0a0a3d3d204578616d706c6520333a204c6f63616c6c7920426f6f6b6d61726b656420417373657473203d3d0a0a546865206c696e6b732073686f776e206865726520617265207265747269657665642066726f6d20796f7572206f776e20696e7374616e6365206f66206f6d436f6c6c616220426f6f6b6d61726b732c207573696e6720746865207072652d696e7374616c6c656420657874656e73696f6e20276f6d436f6c6c6162426f6f6b6d61726b73272e0a3c6f6d436f6c6c6162426f6f6b6d61726b730a646973706c6179747970653d22626c6f67726f6c6c220a696e707574747970653d227365617263687465726d73220a736561726368747970653d227465726d220a7469746c653d224c6f63616c6c7920736176656420626f6f6b6d61726b73220a3e6f6d636f6c6c61623c2f6f6d436f6c6c6162426f6f6b6d61726b733e0a0a596f752063616e20636f6e66696775726520746865206c6f6f6b757020617474726962757465732062792065646974696e67206f722076696577696e672074686520736f75726365206f66207468697320706167652e0a0a5b5b43617465676f72793a546573742043617465676f72795d5d, 0x7574662d38),
(19, 0x526566657220746f205b5b696e6465782e7068703f7469746c653d4d6564696157696b693a5369646562617226616374696f6e3d656469745d5d, 0x7574662d38),
(20, 0x526566657220746f205b5b4d6564696157696b693a5369646562617226616374696f6e3d656469745d5d, 0x7574662d38);
INSERT INTO `{omcollab_db_table_prefix}text` (`old_id`, `old_text`, `old_flags`) VALUES 
(21, 0x526566657220746f205b5b4d6564696157696b693a536964656261725d5d, 0x7574662d38);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}trackbacks`;
CREATE TABLE `{omcollab_db_table_prefix}trackbacks` (
  `tb_id` int(11) NOT NULL auto_increment,
  `tb_page` int(11) default NULL,
  `tb_title` varchar(255) NOT NULL,
  `tb_url` blob NOT NULL,
  `tb_ex` text,
  `tb_name` varchar(255) default NULL,
  PRIMARY KEY  (`tb_id`),
  KEY `tb_page` (`tb_page`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}transcache`;
CREATE TABLE `{omcollab_db_table_prefix}transcache` (
  `tc_url` varbinary(255) NOT NULL,
  `tc_contents` text,
  `tc_time` int(11) NOT NULL,
  UNIQUE KEY `tc_url_idx` (`tc_url`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

-- 
-- Table structure for table `{omcollab_db_table_prefix}updatelog`
--
DROP TABLE IF EXISTS `{omcollab_db_table_prefix}updatelog`;
CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}updatelog` (
  `ul_key` varchar(255) NOT NULL,
  PRIMARY KEY (`ul_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `{omcollab_db_table_prefix}updatelog` (`ul_key`) VALUES
('password format'),
('populate category'),
('populate rev_parent_id');

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user`;
CREATE TABLE `{omcollab_db_table_prefix}user` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `user_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `user_real_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `user_password` tinyblob NOT NULL,
  `user_newpassword` tinyblob NOT NULL,
  `user_newpass_time` binary(14) default NULL,
  `user_email` tinytext NOT NULL,
  `user_options` blob NOT NULL,
  `user_touched` binary(14) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `user_token` binary(32) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `user_email_authenticated` binary(14) default NULL,
  `user_email_token` binary(32) default NULL,
  `user_email_token_expires` binary(14) default NULL,
  `user_registration` binary(14) default NULL,
  `user_editcount` int(11) default NULL,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  KEY `user_email_token` (`user_email_token`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `{omcollab_db_table_prefix}user`
-- 
--              MW1.12.0 old password hash = bdf6301b822e7778e38bf1072a74e4e8 
--                                                                       md5(concat(user_id,'-',md5('password')))
--              MW1.14.0 new password hash = :B:1:bdf6301b822e7778e38bf1072a74e4e8
--                                                                       UPDATE $user SET user_password=CONCAT(':B:', user_id, ':', user_password)

INSERT INTO `{omcollab_db_table_prefix}user` (`user_id`, `user_name`, `user_real_name`, `user_password`, `user_newpassword`, `user_newpass_time`, `user_email`, `user_options`, `user_touched`, `user_token`, `user_email_authenticated`, `user_email_token`, `user_email_token_expires`, `user_registration`, `user_editcount`) VALUES 
(1, 'Admin', '',':B:1:bdf6301b822e7778e38bf1072a74e4e8', '', NULL, '', 0x717569636b6261723d310a756e6465726c696e653d320a636f6c733d38300a726f77733d32350a7365617263686c696d69743d32300a636f6e746578746c696e65733d350a636f6e7465787463686172733d35300a736b696e3d0a6d6174683d310a7263646179733d370a72636c696d69743d35300a776c6c696d69743d3235300a686967686c6967687462726f6b656e3d310a737475627468726573686f6c643d300a707265766965776f6e746f703d310a6564697473656374696f6e3d310a6564697473656374696f6e6f6e7269676874636c69636b3d300a73686f77746f633d310a73686f77746f6f6c6261723d310a646174653d64656661756c740a696d61676573697a653d320a7468756d6273697a653d320a72656d656d62657270617373776f72643d300a656e6f74696677617463686c69737470616765733d300a656e6f7469667573657274616c6b70616765733d310a656e6f7469666d696e6f7265646974733d300a656e6f74696672657665616c616464723d300a73686f776e756d626572737761746368696e673d310a66616e63797369673d300a65787465726e616c656469746f723d300a65787465726e616c646966663d300a73686f776a756d706c696e6b733d310a6e756d62657268656164696e67733d300a7573656c697665707265766965773d300a77617463686c697374646179733d330a76617269616e743d656e0a6c616e67756167653d656e0a7365617263684e73303d310a7365617263684e733130303d31, 0x3230303830373031303934383139, 0x3962633035646234353464656531386530663430336461373664636563323638, NULL, NULL, NULL, 0x3230303830363035313033383034, 20);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_board`;
CREATE TABLE `{omcollab_db_table_prefix}user_board` (
  `ub_id` int(11) NOT NULL auto_increment,
  `ub_user_id` int(11) NOT NULL default '0',
  `ub_user_name` varchar(255) NOT NULL default '',
  `ub_user_id_from` int(11) NOT NULL default '0',
  `ub_user_name_from` varchar(255) NOT NULL default '',
  `ub_message` text NOT NULL,
  `ub_type` int(5) default '0',
  `ub_date` datetime default NULL,
  PRIMARY KEY  (`ub_id`),
  KEY `ub_user_id` (`ub_user_id`),
  KEY `ub_user_id_from` (`ub_user_id_from`),
  KEY `ub_type` (`ub_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_groups`;
CREATE TABLE `{omcollab_db_table_prefix}user_groups` (
  `ug_user` int(10) unsigned NOT NULL default '0',
  `ug_group` varbinary(16) NOT NULL default '',
  PRIMARY KEY  (`ug_user`,`ug_group`),
  KEY `ug_group` (`ug_group`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `{omcollab_db_table_prefix}user_groups` (`ug_user`, `ug_group`) VALUES 
(1, 0x62757265617563726174),
(1, 0x7379736f70);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_newtalk`;
CREATE TABLE `{omcollab_db_table_prefix}user_newtalk` (
  `user_id` int(11) NOT NULL default '0',
  `user_ip` varbinary(40) NOT NULL default '',
  `user_last_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  KEY `user_id` (`user_id`),
  KEY `user_ip` (`user_ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_profile`;
CREATE TABLE `{omcollab_db_table_prefix}user_profile` (
  `up_user_id` int(5) NOT NULL default '0',
  `up_location_city` varchar(255) default NULL,
  `up_location_state` varchar(100) default NULL,
  `up_location_country` varchar(255) default NULL,
  `up_hometown_city` varchar(255) default NULL,
  `up_hometown_state` varchar(100) default NULL,
  `up_hometown_country` varchar(255) default NULL,
  `up_birthday` date default NULL,
  `up_relationship` int(5) NOT NULL default '0',
  `up_occupation` varchar(255) default '',
  `up_companies` text,
  `up_about` text,
  `up_places_lived` text,
  `up_schools` text,
  `up_websites` text,
  `up_movies` text,
  `up_books` text,
  `up_magazines` text,
  `up_music` text,
  `up_tv` text,
  `up_drinks` text,
  `up_snacks` text,
  `up_video_games` text,
  `up_interests` text,
  `up_quotes` text,
  `up_custom_1` text,
  `up_custom_2` text,
  `up_custom_3` text,
  `up_custom_4` text,
  `up_custom_5` text,
  `up_last_seen` datetime default NULL,
  `up_type` int(5) NOT NULL default '1',
  PRIMARY KEY  (`up_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `{omcollab_db_table_prefix}user_profile` (`up_user_id`, `up_location_city`, `up_location_state`, `up_location_country`, `up_hometown_city`, `up_hometown_state`, `up_hometown_country`, `up_birthday`, `up_relationship`, `up_occupation`, `up_companies`, `up_about`, `up_places_lived`, `up_schools`, `up_websites`, `up_movies`, `up_books`, `up_magazines`, `up_music`, `up_tv`, `up_drinks`, `up_snacks`, `up_video_games`, `up_interests`, `up_quotes`, `up_custom_1`, `up_custom_2`, `up_custom_3`, `up_custom_4`, `up_custom_5`, `up_last_seen`, `up_type`) VALUES 
(1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1);

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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_relationship`;
CREATE TABLE `{omcollab_db_table_prefix}user_relationship` (
  `r_id` int(11) NOT NULL auto_increment,
  `r_user_id` int(5) unsigned NOT NULL default '0',
  `r_user_name` varchar(255) NOT NULL default '',
  `r_user_id_relation` int(5) unsigned NOT NULL default '0',
  `r_user_name_relation` varchar(255) NOT NULL default '',
  `r_type` int(2) default NULL,
  `r_date` datetime default NULL,
  PRIMARY KEY  (`r_id`),
  KEY `r_user_id` (`r_user_id`),
  KEY `r_user_id_relation` (`r_user_id_relation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_relationship_request`;
CREATE TABLE `{omcollab_db_table_prefix}user_relationship_request` (
  `ur_id` int(11) NOT NULL auto_increment,
  `ur_user_id_from` int(5) unsigned NOT NULL default '0',
  `ur_user_name_from` varchar(255) NOT NULL default '',
  `ur_user_id_to` int(5) unsigned NOT NULL default '0',
  `ur_user_name_to` varchar(255) NOT NULL default '',
  `ur_status` int(2) default '0',
  `ur_type` int(2) default NULL,
  `ur_message` varchar(255) default NULL,
  `ur_date` datetime default NULL,
  PRIMARY KEY  (`ur_id`),
  KEY `ur_user_id_from` (`ur_user_id_from`),
  KEY `ur_user_id_to` (`ur_user_id_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_stats`;
CREATE TABLE `{omcollab_db_table_prefix}user_stats` (
  `stats_year_id` int(2) NOT NULL default '0',
  `stats_user_id` int(11) NOT NULL default '0',
  `stats_user_name` varchar(255) NOT NULL default '',
  `stats_user_image_count` int(11) NOT NULL default '0',
  `stats_comment_count` int(11) NOT NULL default '0',
  `stats_comment_score` int(11) NOT NULL default '0',
  `stats_comment_score_positive_rec` int(11) NOT NULL default '0',
  `stats_comment_score_negative_rec` int(11) NOT NULL default '0',
  `stats_comment_score_positive_given` int(11) NOT NULL default '0',
  `stats_comment_score_negative_given` int(11) NOT NULL default '0',
  `stats_comment_blocked` int(11) NOT NULL default '0',
  `stats_vote_count` int(11) NOT NULL default '0',
  `stats_edit_count` int(11) NOT NULL default '0',
  `stats_opinions_created` int(11) NOT NULL default '0',
  `stats_opinions_published` int(11) NOT NULL default '0',
  `stats_referrals` int(11) NOT NULL default '0',
  `stats_referrals_completed` int(11) NOT NULL default '0',
  `stats_challenges_count` int(11) NOT NULL default '0',
  `stats_challenges_won` int(11) NOT NULL default '0',
  `stats_challenges_rating_positive` int(11) NOT NULL default '0',
  `stats_challenges_rating_negative` int(11) NOT NULL default '0',
  `stats_friends_count` int(11) NOT NULL default '0',
  `stats_foe_count` int(11) NOT NULL default '0',
  `stats_gifts_rec_count` int(11) NOT NULL default '0',
  `stats_gifts_sent_count` int(11) NOT NULL default '0',
  `stats_weekly_winner_count` int(11) NOT NULL default '0',
  `stats_monthly_winner_count` int(11) NOT NULL default '0',
  `stats_total_points` int(20) default '0',
  `stats_overall_rank` int(11) NOT NULL default '0',
  `up_complete` int(5) default NULL,
  `user_board_count` int(5) default '0',
  `user_board_sent` int(5) default '0',
  `user_board_count_priv` int(5) default '0',
  `stats_picturegame_votes` int(5) default '0',
  `stats_picturegame_created` int(5) default '0',
  `user_status_count` int(5) default '0',
  `stats_poll_votes` int(5) default '0',
  `user_status_agree` int(11) default '0',
  `stats_quiz_questions_answered` int(11) default '0',
  `stats_quiz_questions_correct` int(11) default '0',
  `stats_quiz_points` int(11) default '0',
  `stats_quiz_questions_created` int(11) default '0',
  `stats_quiz_questions_correct_percent` float default '0',
  PRIMARY KEY  (`stats_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}watchlist`;
CREATE TABLE `{omcollab_db_table_prefix}watchlist` (
  `wl_user` int(10) unsigned NOT NULL,
  `wl_namespace` int(11) NOT NULL default '0',
  `wl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `wl_notificationtimestamp` varbinary(14) default NULL,
  UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`),
  KEY `namespace_title` (`wl_namespace`,`wl_title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}thread`;

CREATE TABLE `{omcollab_db_table_prefix}thread` (
  thread_id int(8) unsigned NOT NULL auto_increment,
  thread_root int(8) unsigned UNIQUE NOT NULL,
  thread_ancestor int(8) unsigned NOT NULL,
  thread_parent int(8) unsigned NULL,
  thread_summary_page int(8) unsigned NULL,

  thread_modified char(14) binary NOT NULL default '',
  thread_created char(14) binary NOT NULL default '',
  thread_revision int(8) unsigned NOT NULL default 1,

  thread_editedness int(1) NOT NULL default 0,

  thread_article_namespace int NOT NULL,
  thread_article_title varchar(255) binary NOT NULL,

  -- Special thread types such as schrodinger's thread:
  thread_type int(4) unsigned NOT NULL default 0,

  thread_change_type int(4) unsigned NOT NULL,
  thread_change_object int(8) unsigned NULL,
  thread_change_comment tinyblob NOT NULL,
  thread_change_user int unsigned NOT NULL default '0',
  thread_change_user_text varchar(255) binary NOT NULL default '',

  PRIMARY KEY thread_id (thread_id),
  UNIQUE INDEX thread_id (thread_id),
  INDEX thread_ancestor (thread_ancestor),
  INDEX thread_article_title (thread_article_namespace, thread_article_title),
  INDEX thread_modified (thread_modified),
  INDEX thread_created (thread_created),
  INDEX thread_summary_page (thread_summary_page)
) TYPE=InnoDB;


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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}historical_thread`;

CREATE TABLE `{omcollab_db_table_prefix}historical_thread` (

  -- Note that many hthreads can share an id, which is the same as the id
  -- of the live thread. It is only the id/revision combo which must be unique.
  hthread_id int(8) unsigned NOT NULL,
  hthread_revision int(8) unsigned NOT NULL,
  hthread_contents BLOB NOT NULL,
  hthread_change_type int(4) unsigned NOT NULL,
  hthread_change_object int(8) unsigned NULL,
  PRIMARY KEY hthread_id_revision (hthread_id, hthread_revision)
) TYPE=InnoDB;


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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_message_state`;

CREATE TABLE `{omcollab_db_table_prefix}user_message_state` (
  ums_user int unsigned NOT NULL,
  ums_thread int(8) unsigned NOT NULL,
  ums_read_timestamp varbinary(14),
  
  PRIMARY KEY (ums_user, ums_thread)
) TYPE=InnoDB;


--
-- verion 1.010.0
--

-- create new fields

alter table `{omcollab_db_table_prefix}user_profile` add `up_summary` text NULL;
alter table `{omcollab_db_table_prefix}user_profile` add `up_industries` text NULL;
alter table `{omcollab_db_table_prefix}user_profile` add `up_skills` text NULL;
alter table `{omcollab_db_table_prefix}user_profile` add `up_roles` text NULL;
alter table `{omcollab_db_table_prefix}user_profile` add `up_vendors` text NULL;


-- move data

-- drop old fileds

alter table `{omcollab_db_table_prefix}user_profile` drop `up_movies`;
alter table `{omcollab_db_table_prefix}user_profile` drop `up_books`;
alter table `{omcollab_db_table_prefix}user_profile` drop `up_magazines`;
alter table `{omcollab_db_table_prefix}user_profile` drop `up_music`;
alter table `{omcollab_db_table_prefix}user_profile` drop `up_tv`;
alter table `{omcollab_db_table_prefix}user_profile` drop `up_drinks`;
alter table `{omcollab_db_table_prefix}user_profile` drop `up_snacks`;
alter table `{omcollab_db_table_prefix}user_profile` drop `up_video_games`;
alter table `{omcollab_db_table_prefix}user_profile` drop `up_interests`;
alter table `{omcollab_db_table_prefix}user_profile` drop `up_quotes`;


-- skill initial data
DROP TABLE IF EXISTS `{omcollab_db_table_prefix}skills`;
CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}skills` (
  `s_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_description` varchar(255) DEFAULT NULL,
  `s_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`s_id`),
  KEY `s_description_type` (`s_description`,`s_type`)
) TYPE=InnoDB AUTO_INCREMENT=30 ;

-- user skill rate
DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_skill`;
CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}user_skill` (
  `us_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `us_rated_by` int(10) unsigned NOT NULL,
  `s_id` varchar(255) DEFAULT NULL,
  `us_level` int(10) unsigned NOT NULL default '0',
  `us_rated_on` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   PRIMARY KEY `us_id` (`us_id`),
   UNIQUE KEY `us_fk`(`s_id`,`user_id`,`us_rated_by`)
) TYPE=InnoDB;

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

INSERT INTO `{omcollab_db_table_prefix}skills` (`s_id`, `s_description`,`s_type`) VALUES
(1,'energy','industry'),
(2,'oil and gas','industry'),
(3,'utilities','industry'),
(4,'automotive','industry'),
(5,'aerospace','industry'),
(6,'telecommunications','industry'),
(7,'media','industry'),
(8,'consumer markets','industry'),
(9,'high tech','industry'),
(10,'industrial','industry'),
(11,'medical devices','industry'),
(12,'pharmaceuticals','industry'),
(13,'banking','industry'),
(14,'insurance','industry'),
(15,'global markets','industry'),
(16,'financial services','industry'),
(17,'central/federal government','industry'),
(18,'defense','industry'),
(19,'education','industry'),
(20,'emerging markets','industry'),
(21,'heath','industry'),
(22,'state/local/provincial government','industry'),
(23,'im quickscan','skill'),
(24,'rational requisite pro','skill'),
(25,'actuate','skill'),
(26,'arcplan','skill'),
(27,'sap bex','skill'),
(28,'business objects','skill'),
(29,'clarity','skill'),
(30,'cognos framework manager','skill'),
(31,'composite','skill'),
(32,'crystal reports','skill'),
(33,'fast radar','skill'),
(34,' hyperion  bi','skill'),
(35,'webfocus','skill'),
(36,'jaspersoft','skill'),
(37,'kalido bi','skill'),
(38,'oracle biee','skill'),
(39,'oracle discoverer','skill'),
(40,'panorama','skill'),
(41,'pentaho','skill'),
(42,'peoplesoft epm','skill'),
(43,'qlikview','skill'),
(44,'sap bi','skill'),
(45,'sas','skill'),
(46,'spss','skill'),
(47,'tableau','skill'),
(48,'tibco','skill'),
(49,'spotfire','skill'),
(50,'xcelsius bi','skill'),
(51,'hyperion financial manager','skill'),
(52,'oracle financials','skill'),
(53,'sap sem','skill'),
(54,'data modelling','skill'),
(55,'dbdesigner','skill'),
(56,'data modeling erwin','skill'),
(57,'ibm rational data architect','skill'),
(58,'ibm rational rose data modeler','skill'),
(59,'oracle designer','skill'),
(60,'data modeling - acxiom','skill'),
(61,'ibm infosphere','skill'),
(62,'informatica dq','skill'),
(63,'sas dataflux dq','skill'),
(64,'sap business objects dq','skill'),
(65,'teradata db','skill'),
(66,'db2/udb db','skill'),
(67,'mysql db','skill'),
(68,'oracle db','skill'),
(69,'paraccel db','skill'),
(70,'sql server db','skill'),
(71,'sybase db','skill'),
(72,'data warehouse appliances','skill'),
(73,'aster data db','skill'),
(74,'dataupia','skill'),
(75,'exadata','skill'),
(76,'greenplum','skill'),
(77,'neoview','skill'),
(78,'infobright','skill'),
(79,'kognitio','skill'),
(80,'netezza','skill'),
(81,'vertica','skill'),
(82,'etl','skill'),
(83,'data junction etl','skill'),
(84,'ibm etl','skill'),
(85,'informatica etl','skill'),
(86,'ibm datastage etl','skill'),
(87,'informatica powercenter','skill'),
(88,'oracle warehouse builder','skill'),
(89,'sap business objects ','skill'),
(90,'sql server integration services','skill'),
(91,'talend etl','skill'),
(92,'delta data etl','skill'),
(93,'hyperion mdm','skill'),
(94,'ibm infosphere','skill'),
(95,'initiatiate mdm','skill'),
(96,'kalido mdm','skill'),
(97,'microsoft strature mdm','skill'),
(98,'sap mdm','skill'),
(99,'siperian mdm','skill'),
(100,'google search appliance','skill'),
(101,'ibm/omnifind and uima','skill'),
(102,'lucene','skill'),
(103,'netapp','skill'),
(104,'voltage','skill'),
(105,'search','skill'),
(106,'data quality','skill'),
(107,'data profiling','skill'),
(108,'data re-enginnering','skill'),
(109,'web content management','skill'),
(110,'master data management','skill'),
(111,'data integration','skill'),
(112,'performance management','skill'),
(113,'business intelligence','skill'),
(114,'predictive analytics','skill'),
(115,'information lifecycle management','skill'),
(116,'information security','skill'),
(117,'data warehousing','skill'),
(118,'master data management','skill'),
(119,'enterprise 2.0','skill'),
(120,'agile development','skill'),
(121,'it transformation','skill'),
(122,'information sharing','skill'),
(123,'information governance','skill'),
(124,'collaboration','skill'),
(125,'business architect','role'),
(126,'chief architect','role'),
(127,'data steward','role'),
(128,'etl developer','role'),
(129,'development lead','role'),
(130,'information architect','role'),
(131,'infrastructure architect','role'),
(132,'metadata development manager','role'),
(133,'data modeller','role'),
(134,'program manager','role'),
(135,'solution architect','role'),
(136,'xbr process manager','role'),
(137,'web developer','role'),
(138,'tester','role'),
(139,'requirements analyst','role'),
(140,'quality manager','role'),
(141,'project leader','role'),
(142,'talend','vendor'),
(143,'sun','vendor'),
(144,'documentum','vendor'),
(145,'sas','vendor'),
(146,'spss','vendor'),
(147,'tableau','vendor'),
(148,'tibco','vendor'),
(149,'spotfire','vendor'),
(150,'trillium ','vendor'),
(151,'teradata','vendor'),
(152,'ab initio','vendor'),
(153,'filenet','vendor'),
(154,'interwoven','vendor'),
(155,'knowlegetree','vendor'),
(156,'nuxeo','vendor'),
(157,'opentext','vendor'),
(158,'oracle/stellent','vendor'),
(159,'vignette','vendor'),
(160,'autonomy','vendor'),
(161,'bea','vendor');


-- #ticket 72


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

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

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}omcollab_portlets`;
CREATE TABLE `{omcollab_db_table_prefix}omcollab_portlets` (
  `name` varchar(100) NOT NULL COMMENT 'portlet identity',
  `url` varchar(255) NOT NULL COMMENT 'url of this portlet',
  `title` varchar(255) NOT NULL COMMENT 'title of this portlet',
  `color` varchar(10) NOT NULL COMMENT 'optional color definition for title bar',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Portlet Definitions';

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

INSERT INTO `{omcollab_db_table_prefix}omcollab_portlets` (`name`, `url`, `title`, `color`) VALUES
('activity', 'home/portlets/activity/Portlet.php', 'Recent Activity', 'green'),
('community_chart', 'home/portlets/community_chart/Portlet.php', 'Community Chart', 'blue'),
('profile', 'home/portlets/profile/Portlet.php', 'Profile', 'red'),
('welcome', 'home/portlets/welcome/Portlet.php', 'Welcome', 'yellow'),
('shortcut', 'home/portlets/shortcut/Portlet.php', 'Shortcut', 'yellow');

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

--
-- Table structure for table `{omcollab_db_table_prefix}omcollab_layout`
--
DROP TABLE IF EXISTS `{omcollab_db_table_prefix}omcollab_layout`;
CREATE TABLE `{omcollab_db_table_prefix}omcollab_layout` (
  `user_id` int(10) NOT NULL,
  `portlet_name` varchar(100) NOT NULL COMMENT 'id of the portlet',
  `col` varchar(10) NOT NULL COMMENT 'column it belongs to',
  `seq` int(11) NOT NULL,
  `tab` varchar(100) NOT NULL COMMENT 'tab it belongs to',
  PRIMARY KEY (`user_id`,`portlet_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Layout Definitions for each tab';

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

INSERT INTO `{omcollab_db_table_prefix}omcollab_layout` (`user_id`, `portlet_name`, `col`, `seq`, `tab`) VALUES
(0, 'profile', 'c1', 1, 'tab_home'),
(0, 'shortcut', 'c1', 2, 'tab_home'),
(0, 'member', 'c1', 3, 'tab_home'),
(0, 'subscription', 'c1', 4, 'tab_home'),
(0, 'welcome', 'c2', 5, 'tab_home'),
(0, 'article', 'c2', 6, 'tab_home'),
(0, 'team', 'c2', 7, 'tab_home'),
(0, 'activity', 'c3', 8, 'tab_home'),
(0, 'contributor', 'c3', 9, 'tab_home'),
(0, 'skill', 'c3', 10, 'tab_home'),
(0, 'community_chart', 'c3', 11, 'tab_home');

-- 1.100.5

INSERT INTO `{omcollab_db_table_prefix}omcollab_portlets` (`name`, `url`, `title`, `color`) VALUES
('contributor', 'home/portlets/contributor/Portlet.php', 'Contributor of the week', 'blue'),
('skill', 'home/portlets/skill/Portlet.php', 'Community Skills', 'red');

INSERT INTO `{omcollab_db_table_prefix}omcollab_layout` (`user_id`, `portlet_name`, `col`, `seq`, `tab`) VALUES
(0, 'contributor', 'c2', 6, 'tab_home'),
(1, 'contributor', 'c2', 6, 'undefined'),
(0, 'skill', 'c2', 7, 'tab_home'),
(1, 'skill', 'c2', 7, 'undefined');


--
-- Table structure for table `om_omcollab_showcase`
--
DROP TABLE IF EXISTS `{omcollab_db_table_prefix}omcollab_showcase`;
CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}omcollab_showcase` (
  `showcase_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) NOT NULL,
  `showcase_begin_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `showcase_end_time` timestamp NULL DEFAULT NULL,
  `notes` text,
  PRIMARY KEY (`showcase_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


-- 1.300.0

INSERT INTO `{omcollab_db_table_prefix}omcollab_portlets` (`name`, `url`, `title`, `color`) VALUES
('article', 'home/portlets/article/Portlet.php', 'Featured Article', 'blue');

INSERT INTO `{omcollab_db_table_prefix}omcollab_layout` (`user_id`, `portlet_name`, `col`, `seq`, `tab`) VALUES
(0, 'article', 'c3', 8, 'tab_home'),
(1, 'article', 'c3', 8, 'undefined');

INSERT INTO `{omcollab_db_table_prefix}omcollab_portlets` (`name`, `url`, `title`, `color`) VALUES
('subscription', 'home/portlets/subscribe/Portlet.php', 'Subscription', 'blue');

INSERT INTO `{omcollab_db_table_prefix}omcollab_layout` (`user_id`, `portlet_name`, `col`, `seq`, `tab`) VALUES
(0, 'subscription', 'c10', 10, 'tab_home');


DROP TABLE IF EXISTS `{omcollab_db_table_prefix}team`;
CREATE TABLE  `{omcollab_db_table_prefix}team` (
  `team_id` int(10) unsigned NOT NULL auto_increment,
  `team_name` varchar(100) NOT NULL,
  `team_desc` varchar(500) default NULL,
  `team_leader` int(10) unsigned NOT NULL,
  `create_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `is_active` tinyint(3) unsigned NOT NULL default '1',
  `total_member` int(10) unsigned default NULL,
  `total_bonus` int(10) unsigned default NULL,
  PRIMARY KEY  (`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



DROP TABLE IF EXISTS `{omcollab_db_table_prefix}team_request`;
CREATE TABLE  `{omcollab_db_table_prefix}team_request` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL,
  `team_id` int(10) unsigned NOT NULL,
  `msg` varchar(500) NOT NULL,
  `request_status` smallint(5) unsigned NOT NULL default '0' COMMENT '0:new;1:approved;2:rejected',
  `request_type` smallint(5) unsigned NOT NULL COMMENT '0:apply to join;1:invite to join',
  `is_active` smallint(5) unsigned NOT NULL default '1' COMMENT '0:deleted;1:active',
  `request_date` datetime NOT NULL,
  `to_user_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_team`;
CREATE TABLE  `{omcollab_db_table_prefix}user_team` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL,
  `team_id` int(10) unsigned NOT NULL,
  `start_date` date default NULL,
  `end_date` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;