source: trunk/_InstallationResources/omwiki_green.sql @ 1306

-- 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),
(5, 0x687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f6578706c6f7265, 0x687474703a2f2f6f72672e6f70656e6d6574686f646f6c6f67792e6d696b65322e2f6578706c6f7265),
(5, 0x6d61696c746f3a6d696b6532406f70656e6d6574686f646f6c6f67792e6f7267, 0x6d61696c746f3a6f72672e6f70656e6d6574686f646f6c6f6779406d696b65322e);

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

-- 
-- 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=24 ;

-- 
-- 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),
('patrol', 'patrol', '20080701094814', 1, 0, 'Submenu', '', 0x32310a32300a31, 21, 0),
('patrol', 'patrol', '20090625080132', 1, 0, 'Welcome', '', 0x32320a300a31, 22, 0),
('patrol', 'patrol', '20090625080255', 1, 8, 'Featured_Article', '', 0x32330a300a31, 23, 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 
('om_wiki-om_:messages:en', 0x5d904d6b84301086effe8a90def652dd7e415c178ab5740f758b2ebdc81266e3741b48548c6e0bea7f6fa2bdb4a7cc33f340785f60376c30ec81d15c967882968686add7778c9261b8d258f5cc5b15c52bc88abcc119c7975ae3f1e8adecd2f427278cf80dba51487e99c80eb5538a226f5048502c438155273ea13aa3191722f1827fcd14bf1a70921dd074f39fff940caab2d6e3f2cc82bd4f93b729e5850805c644f4224d0f2a5668036d37d7f6b2e53cdd274fbb439ec487dd3ee5dc25b5b9df932cb74c43c902bb09ee197d46e8fa164bfed876522874e66d602b81852357079feba87acdeb0f6ea3b5203a6c4d14f8be4fc3e907, '2009-06-26 08:02:56'),
('omdev1_omwiki-om_:messages', 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=7 ;

-- 
-- 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, 'Admin', '', 0, 0, 1, 0.750118327798, '20080613121024', 10, 262),
(5, 0, 'Welcome', '', 1, 0, 1, 0.828877925496, '20090625080132', 22, 1253),
(6, 8, 'Featured_Article', '', 1, 0, 1, 0.82499884389, '20090625080255', 23, 40);


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

-- 
-- 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, 'Main_Page'),
(2, 0, 'Submenu'),
(5, 0, 'Enterprise_Information_Management_Concept'),
(5, 0, 'Information_Development'),
(5, 0, 'MIKE2:FAQs'),
(5, 0, 'MIKE2:Ways_to_Contribute'),
(5, 0, 'MIKE2:Ways_to_use_MIKE2.0'),
(5, 0, 'Open_Methodology_Framework'),
(5, 0, 'Open_Source_Concept'),
(5, 0, 'What_is_MIKE2.0'),
(5, 12, 'Contents');


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

-- 
-- 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=24 ;

-- 
-- 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, '20080701094814', '20080701094814', 1, 'Admin', 0, 'Submenu', '', 0, 0, 0, 3, 21, 20, 0, 0, '', 1, '127.0.0.1', 42, 30, 0, 0, NULL, NULL, NULL),
(22, '20090625080132', '20090625080132', 1, 'Admin', 0, 'Welcome', 'Created page with ''<div style="font-size: 130%;"> ''''''MIKE2.0 (Method for an Integrated Knowledge Environment)'''''' is an [[Open Source Concept|Open Source]] methodology for [[Enterprise Information M...''', 0, 0, 1, 5, 22, 0, 1, 0, '', 1, '127.0.0.1', 0, 1253, 0, 0, NULL, '', ''),
(23, '20090625080255', '20090625080255', 1, 'Admin', 8, 'Featured_Article', 'Created page with ''article=Main_Page|num_of_characters=1000''', 0, 0, 1, 6, 23, 0, 1, 0, '', 1, '127.0.0.1', 0, 40, 0, 0, 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),
(22, 5, 22, 0x437265617465642070616765207769746820273c646976207374796c653d22666f6e742d73697a653a20313030253b223e202727274d494b45322e3020284d6574686f6420666f7220616e20496e7465677261746564204b6e6f776c6564676520456e7669726f6e6d656e742927272720697320616e205b5b4f70656e20536f7572636520436f6e636570747c4f70656e20536f757263655d5d206d6574686f646f6c6f677920666f72205b5b456e746572707269736520496e666f726d6174696f6e204d2e2e2e27, 1, 'Admin', '20090625080132', 0, 0, 1253, 0),
(23, 6, 23, 0x4372656174656420706167652077697468202761727469636c653d4d61696e5f506167657c6e756d5f6f665f636861726163746572733d3130303027, 1, 'Admin', '20090625080255', 0, 0, 40, 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 '),
(5, 'welcome', '  mike2u82e0u800 method foru800 anu800 integrated knowledge environment   isu800 anu800 open source concept open source methodology foru800 enterprise information management concept enterprise information management that provides au800 framework foru800 information development . theu800 mike2u82e0u800 methodology isu800 part ofu800 theu800 overall open methodology framework .  mike2u82e0u800 isu800 au800 collaborative effort  tou800 help organisations whou800 have invested heavily inu800 applications andu800 infrastructures butu800 haven''tu800 focused onu800 theu800 data andu800 information needs ofu800 theu800 business. weu800 believe this hasu800 resulted inu800 many ofu800 theu800 business problems faced byu800 organisations today around compliance lack ofu800 customer insight failed transformation programmes andu800 theu800 high cost ofu800 technology systems. what isu800 mike2u82e0u800 what isu800 mike2u82e0u800 explore mike2u82e0u800 mike2 ways tou800 contribute contribute tou800 mike2u82e0u800 help contents help mike2 faqs faqs mike2 ways tou800 useu800 mike2u82e0u800 useu800 mike2u82e0u800 give usu800 feedback '),
(6, 'featured article', ' article main_page num_of_characters 1000 ');

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

-- 
-- 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, 102, 24, 3, 6, 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),
(22, 0x3c646976207374796c653d22666f6e742d73697a653a20313030253b223e0a2727274d494b45322e3020284d6574686f6420666f7220616e20496e7465677261746564204b6e6f776c6564676520456e7669726f6e6d656e742927272720697320616e205b5b4f70656e20536f7572636520436f6e636570747c4f70656e20536f757263655d5d206d6574686f646f6c6f677920666f72205b5b456e746572707269736520496e666f726d6174696f6e204d616e6167656d656e7420436f6e636570747c456e746572707269736520496e666f726d6174696f6e204d616e6167656d656e745d5d20746861742070726f76696465732061206672616d65776f726b20666f72205b5b496e666f726d6174696f6e20446576656c6f706d656e745d5d2e20546865204d494b45322e30204d6574686f646f6c6f67792069732070617274206f6620746865206f766572616c6c205b5b4f70656e204d6574686f646f6c6f6779204672616d65776f726b5d5d2e200a2727274d494b45322e30206973206120636f6c6c61626f726174697665206566666f727427272720746f2068656c70206f7267616e69736174696f6e732077686f206861766520696e7665737465642068656176696c7920696e206170706c69636174696f6e7320616e6420696e667261737472756374757265732c2062757420686176656e277420666f6375736564206f6e20746865206461746120616e6420696e666f726d6174696f6e206e65656473206f662074686520627573696e6573732e2057652062656c6965766520746869732068617320726573756c74656420696e206d616e79206f662074686520627573696e6573732070726f626c656d73206661636564206279206f7267616e69736174696f6e7320746f6461792061726f756e6420636f6d706c69616e63652c206c61636b206f6620637573746f6d657220696e73696768742c206661696c6564207472616e73666f726d6174696f6e2070726f6772616d6d657320616e6420746865206869676820636f7374206f6620746563686e6f6c6f67792073797374656d732e203c2f6469763e203c646976207374796c653d22626f726465723a2031707820736f6c696420726762283136332c203137362c20313931293b2070616464696e673a2030707820313470783b206d617267696e2d746f703a20313270783b20666c6f61743a2072696768743b20666f6e742d73697a653a20313030253b206261636b67726f756e642d636f6c6f723a20726762283232382c203233372c20323432293b223e5b5b57686174206973204d494b45322e307c57686174206973204d494b45322e303f5d5d207c205b687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f6578706c6f7265204578706c6f7265204d494b45322e305d207c205b5b4d494b45323a5761797320746f20436f6e747269627574657c436f6e7472696275746520746f204d494b45322e305d5d207c205b5b48656c703a436f6e74656e74737c48656c705d5d207c205b5b4d494b45323a464151737c464151735d5d207c205b5b4d494b45323a5761797320746f20757365204d494b45322e307c557365204d494b45322e305d5d207c205b6d61696c746f3a6d696b6532406f70656e6d6574686f646f6c6f67792e6f7267204769766520757320666565646261636b5d203c2f6469763e200a3c62723e3c62723e, 0x7574662d38),
(23, 0x61727469636c653d4d61696e5f506167657c6e756d5f6f665f636861726163746572733d31303030, 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, '', 0x717569636b6261723d310a756e6465726c696e653d320a636f6c733d38300a726f77733d32350a7365617263686c696d69743d32300a636f6e746578746c696e65733d350a636f6e7465787463686172733d35300a736b696e3d6d696b65320a6d6174683d310a7263646179733d370a72636c696d69743d35300a776c6c696d69743d3235300a686967686c6967687462726f6b656e3d310a737475627468726573686f6c643d300a707265766965776f6e746f703d310a6564697473656374696f6e3d310a6564697473656374696f6e6f6e7269676874636c69636b3d300a73686f77746f633d310a73686f77746f6f6c6261723d310a646174653d64656661756c740a696d61676573697a653d320a7468756d6273697a653d320a72656d656d62657270617373776f72643d300a656e6f74696677617463686c69737470616765733d300a656e6f7469667573657274616c6b70616765733d310a656e6f7469666d696e6f7265646974733d300a656e6f74696672657665616c616464723d300a73686f776e756d626572737761746368696e673d300a66616e63797369673d300a65787465726e616c656469746f723d300a65787465726e616c646966663d300a73686f776a756d706c696e6b733d310a6e756d62657268656164696e67733d300a7573656c697665707265766965773d300a77617463686c697374646179733d330a76617269616e743d0a6c616e67756167653d656e0a7365617263684e73303d310a6e69636b6e616d653d0a74696d65636f7272656374696f6e3d0a616a61787365617263683d0a7365617263684e73313d300a7365617263684e73323d300a7365617263684e73333d300a7365617263684e73343d300a7365617263684e73353d300a7365617263684e73363d300a7365617263684e73373d300a7365617263684e73383d300a7365617263684e73393d300a7365617263684e7331303d300a7365617263684e7331313d300a7365617263684e7331323d300a7365617263684e7331333d300a7365617263684e7331343d300a7365617263684e7331353d300a64697361626c656d61696c3d300a6a7573746966793d300a686964656d696e6f723d300a657874656e6477617463686c6973743d300a7573656e657772633d300a656469746f6e64626c636c69636b3d300a6564697477696474683d300a77617463686372656174696f6e733d300a776174636864656661756c743d300a77617463686d6f7665733d300a776174636864656c6574696f6e3d300a6d696e6f7264656661756c743d300a707265766965776f6e66697273743d300a6e6f63616368653d300a666f7263656564697473756d6d6172793d300a77617463686c697374686964656f776e3d300a77617463686c69737468696465626f74733d300a77617463686c697374686964656d696e6f723d300a63636d656f6e656d61696c733d300a646966666f6e6c793d300a7365617263684e733130303d300a7365617263684e733130313d30, 0x3230303830373031303934383139, 0x3962633035646234353464656531386530663430336461373664636563323638, NULL, NULL, NULL, 0x3230303830363035313033383034, 22);
-- --------------------------------------------------------

-- 
-- 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, 'welcome', 'c2', 5, 'tab_home'),
(0, 'community_chart', 'c3', 10, 'tab_home'),
(0, 'activity', 'c2', 7, 'tab_home'),
(0, 'team', 'c3', 11, 'tab_home'),
(1, 'profile', 'c1', 1, 'undefined'),
(1, 'shortcut', 'c1', 2, 'undefined'),
(1, 'welcome', 'c2', 5, 'undefined'),
(1, 'community_chart', 'c3', 10, 'undefined'),
(1, 'activity', 'c2', 7, 'undefined'),
(1, 'team', 'c3', 11, 'undefined');

-- 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'),
('team', 'home/portlets/team/Portlet.php', 'Teams', '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', 'c3', 8, 'tab_home'),
(1, 'contributor', 'c3', 8, 'undefined'),
(0, 'skill', 'c3', 9, 'tab_home'),
(1, 'skill', 'c3', 9, '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 ;

-- insert default user admin as showcase in db
INSERT INTO `{omcollab_db_table_prefix}omcollab_showcase` (`showcase_id`, `user_name`, `showcase_begin_time`, `showcase_end_time`, `notes`) VALUES
(1, 'Admin', DEFAULT, NULL, 'Contributor this week');

-- 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'),
('member', 'home/portlets/member/Portlet.php', 'Members', 'red');

INSERT INTO `{omcollab_db_table_prefix}omcollab_layout` (`user_id`, `portlet_name`, `col`, `seq`, `tab`) VALUES
(0, 'article', 'c2', 6, 'tab_home'),
(1, 'article', 'c2', 6, 'undefined'),
(0, 'member', 'c1', 3, 'tab_home'),
(1, 'member', 'c1', 3, 'undefined');

UPDATE `{omcollab_db_table_prefix}omcollab_portlets`
   SET  `title` = 'Shortcuts'
 WHERE  `name` = 'shortcut';


-- comments out advertising module for milestone 1.3
-- --Advertising tables
-- 
-- 
-- --
-- -- Table structure for table `{omcollab_db_table_prefix}omcollab_adcode`
-- --
-- DROP TABLE IF EXISTS `{omcollab_db_table_prefix}omcollab_adcode`;
-- CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}omcollab_adcode` (
--   `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
--   `size` enum('banner','column','sidebar','square','leftCol','rightCol') DEFAULT 'banner',
--   `src` varchar(25) DEFAULT '',
--   `code` text,
--   PRIMARY KEY (`id`)
-- ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;
-- 
-- --
-- -- Dumping data for table `{omcollab_db_table_prefix}omcollab_adcode`
-- --
-- 
-- INSERT INTO `{omcollab_db_table_prefix}omcollab_adcode` (`id`, `size`, `src`, `code`) VALUES
-- (1, 'banner', 'google', '<script type="text/javascript"><!--\ngoogle_ad_client = "pub-9975156792632579";\ngoogle_alternate_ad_url = "http://www.newscloud.com/static/ads/index.php?size=banner&exclude=google";\ngoogle_ad_width = 728;\ngoogle_ad_height = 90;\ngoogle_ad_format = "728x90_as";\ngoogle_ad_type = "image";\ngoogle_ad_channel = "4088172800";\ngoogle_color_border = "000000";\ngoogle_color_bg = "F0F0F0";\ngoogle_color_link = "0000FF";\ngoogle_color_text = "000000";\ngoogle_color_url = "008000";\n//--></script>\n<script type="text/javascript"\n  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n</script>'),
-- (2, 'banner', 'googleText', '<script type="text/javascript"><!-- google_ad_client = "pub-9975156792632579";google_ad_width = 728;google_ad_height = 90;google_ad_format= "728x90_as";google_ad_type = "text";google_ad_channel = "4088172800";google_color_border = "202020";google_color_bg = "ffffff";google_color_link = "0000FF";google_color_text = "000000";google_color_url = "008000"; //--></script>\n<script type="text/javascript"\n  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n</script>'),
-- (3, 'banner', 'insurance', '<a href="http://www.kqzyfj.com/click-2252260-10310322" target="_top"><img src="http://www.afcyhf.com/image-2252260-10310322" width="468" height="60" alt="Turn 21 today!" border="0"/></a>'),
-- (4, 'banner', 'amazon', '<script type="text/javascript"><!--\n  amazon_ad_tag = "commonmediaor-20";  amazon_ad_width = "728";  amazon_ad_height = "90";  amazon_ad_logo = "hide";  amazon_ad_exclude = "gillmor+zune";  amazon_ad_include = ""; amazon_ad_link_target = "new"; //--></script>\n<script type="text/javascript" src="http://www.assoc-amazon.com/s/ads.js"></script>'),
-- (5, 'banner', 'spamArrest', '<a target="_cts" href="http://www.spamarrest.com/affl?4024588-{trackid}"><img src="http://img.spamarrest.com/img/affiliate/1845_SA9_728x90.gif?4024588-{trackid}" height="90" width="728" border="1"></a>\r'),
-- (6, 'banner', 'spamArrest', '<a target="_cts" href="http://www.spamarrest.com/affl?4024588-{trackid}"><img src="http://img.spamarrest.com/img/affiliate/1845_SA1_r1_728x90.gif?4024588-{trackid}" height="90" width="728" border="1"></a>\r'),
-- (7, 'banner', 'spamArrest', '<a target="_cts" href="http://www.spamarrest.com/affl?4024588-{trackid}"><img src="http://img.spamarrest.com/img/affiliate/1845_SA11_728x90.gif?4024588-{trackid}" height="90" width="728" border="1"></a>\r'),
-- (8, 'banner', 'spamArrest', '<a target="_cts" href="http://www.spamarrest.com/affl?4024588-{trackid}"><img src="http://img.spamarrest.com/img/affiliate/1845_SA4_728x60.gif?4024588-{trackid}" height="90" width="728" border="1"></a>\r'),
-- (9, 'banner', 'dotster', '<script type="text/javascript" language="javascript" src="http://www.anrdoezrs.net/placeholder-1723061?target=_blank&mouseover=N"></script>'),
-- (10, 'banner', 'dotster', '<script type="text/javascript" language="javascript" src="http://www.anrdoezrs.net/placeholder-1723063?target=_blank&mouseover=N"></script>'),
-- (11, 'banner', 'smug', '<a href="http://www.kqzyfj.com/click-2252260-10381614" target="_blank"><img src="http://www.afcyhf.com/image-2252260-10381614" width="468" height="60" alt="" border="0"/></a>'),
-- (12, 'banner', 'meeting', '<a href="http://www.tkqlhce.com/click-2252260-10444284" target="_top"><img src="http://www.ftjcfx.com/image-2252260-10444284" width="728" height="90" alt="GoToWebinar - Web Events Made Easy " border="0"/></a>'),
-- (13, 'banner', 'tax', '<a href="http://www.jdoqocy.com/click-2252260-10378068" target="_top"><img src="http://www.awltovhc.com/image-2252260-10378068" width="468" height="60" alt="Faster tax refunds, guaranteed accurate." border="0"/></a>'),
-- (14, 'banner', 'wsj', '<a href="http://www.tkqlhce.com/click-2252260-10446800" target="_top"><img src="http://www.tqlkg.com/image-2252260-10446800" width="728" height="90" alt="Click Here For The Wall Street Journal Online" border="0"/></a>'),
-- (15, 'rightCol', 'wsj', '<a href="http://www.kqzyfj.com/click-2252260-10298072" target="_top"><img src="http://www.ftjcfx.com/image-2252260-10298072" width="234" height="60" alt="" border="0"/></a>'),
-- (16, 'rightCol', 'netflix', '<div style="margin-left:10px;margin-right:0px;"><a href="http://click.linksynergy.com/fs-bin/click?id=03*eottKFZU&offerid=78684.10000014&type=4&subid=0"><IMG alt="Netflix, Inc." border="0" src="http://cdn.netflix.com/us/affiliates/banners/0804/300250E_599.gif"></a><IMG border="0" width="1" height="1" src="http://ad.linksynergy.com/fs-bin/show?id=03*eottKFZU&bids=78684.10000014&type=4&subid=0"></div>'),
-- (17, 'rightCol', 'flowers', '<div style="margin-left:10px;margin-right:0px;"><a href="http://click.linksynergy.com/fs-bin/click?id=03*eottKFZU&offerid=100462.10001650&type=4&subid=0"><IMG alt="1-800-FLOWERS.COM" border="0" src="http://a1516.g.akamai.net/f/1516/9236/1h/affiliate.1800flowers.com/flowers/graphics/VDayFY07/VD01b84nF7_12k.gif"></a><IMG border="0" width="1" height="1" src="http://ad.linksynergy.com/fs-bin/show?id=03*eottKFZU&bids=100462.10001650&type=4&subid=0"></div>'),
-- (18, 'rightCol', 'google', '<div style="margin-left:10px;margin-right:0px;"><script type="text/javascript"><!--\ngoogle_ad_client = "pub-9975156792632579";\ngoogle_ad_width = 300;\ngoogle_ad_height = 250;\ngoogle_ad_format = "300x250_as";\ngoogle_ad_type = "text_image";\n//2007-01-23: nc_cover\ngoogle_ad_channel = "7323463625";\ngoogle_color_border = "202020";\ngoogle_color_bg = "ffffff";\ngoogle_color_link = "0000FF";\ngoogle_color_text = "000000";\ngoogle_color_url = "008000";\n//--></script>\n<script type="text/javascript"\n  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n</script></div>'),
-- (19, 'leftCol', 'dotster', '<form action="http://www.kqzyfj.com/interactive" method="get">\n<table width="238" border="0" cellpadding="0" cellspacing="0" align="center">\n        <tr>\n          <td><img src="http://www.dotsteraffiliate.com/affiliateads/interactive/516693images-3/new.gif" width="238" height="48" border="0" alt="Select a Domain"></td>\n        </tr>\n        <tr>\n          <td align="top" height="43" background="http://www.dotsteraffiliate.com/affiliateads/interactive/516693images-3/steponemid.gif" bgcolor="#FFFFFF">\n            &nbsp; &nbsp;<input type="text" size="18" align="top" name="DomainName" value>&nbsp;<input type="image" src="http://www.dotsteraffiliate.com/affiliateads/interactive/516693images-3/btncheckh.gif" border="0" align="absbottom" WIDTH="58" HEIGHT="36"><input type="hidden" size="15" name="siteid" value="4798">\n          </td>\n        </tr>\n        <tr>\n          <td><img src="http://www.dotsteraffiliate.com/affiliateads/interactive/516693images-3/steponebot.gif" width="238" height="15" border="0"></td>\n        </tr>\n      </table>\n\n<input type="hidden" name="aid" value="10275199"/>\n<input type="hidden" name="pid" value="2252260"/>\n<input type="hidden" name="url" value="https://secure.registerapi.com/dds2/index.php"/>\n</form>\n<img src="http://www.tqlkg.com/image-2252260-10275199" width="1" height="1" border="0"/>'),
-- (20, 'leftCol', 'dotster', '<script type="text/javascript" language="javascript" src="http://www.jdoqocy.com/placeholder-1723060?target=_blank&mouseover=N"></script>'),
-- (21, 'leftCol', 'dotster', '<script type="text/javascript" language="javascript" src="http://www.kqzyfj.com/placeholder-1723062?target=_blank&mouseover=N"></script>'),
-- (22, 'leftCol', 'smug', '<a href="http://www.kqzyfj.com/click-2252260-10392477" target="_blank"><img src="http://www.lduhtrp.net/image-2252260-10392477" width="234" height="60" alt="" border="0"/></a>'),
-- (23, 'leftCol', 'insurance', '<a href="http://www.tkqlhce.com/click-2252260-9260138" target="_top"><img src="http://www.afcyhf.com/image-2252260-9260138" width="234" height="60" alt="Turn 21 Today!" border="0"/></a>'),
-- (24, 'leftCol', 'google', '<div style="margin-left:10px;margin-right:0px;"><script type="text/javascript"><!--\ngoogle_ad_client = "pub-9975156792632579";\ngoogle_ad_width = 250;\ngoogle_ad_height = 250;\ngoogle_ad_format = "250x250_as";\ngoogle_ad_type = "image";\n//2007-01-23: nc_cover\ngoogle_ad_channel = "7323463625";\ngoogle_color_border = "000000";\ngoogle_color_bg = "F0F0F0";\ngoogle_color_link = "0000FF";\ngoogle_color_text = "000000";\ngoogle_color_url = "008000";\n//--></script>\n<script type="text/javascript"\n  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n</script></div>'),
-- (25, 'banner', 'lava', '<a href="http://click.linksynergy.com/fs-bin/click?id=03*eottKFZU&offerid=122784&subid=0"><IMG alt="Lavalife.com" border="0"  width="728" height="90" src="http://ad.linksynergy.com/fs-bin/show?id=03*eottKFZU&bids=122784&gridnum=16&catid=-1&subid=0"></a>'),
-- (26, 'banner', 'netflix', '<a href="http://click.linksynergy.com/fs-bin/click?id=03*eottKFZU&offerid=78684.10000010&type=4&subid=0"><IMG alt="Netflix, Inc." border="0" src="http://cdn.netflix.com/us/affiliates/banners/0804/728090B_599.gif"></a><IMG border="0" width="1" height="1" src="http://ad.linksynergy.com/fs-bin/show?id=03*eottKFZU&bids=78684.10000010&type=4&subid=0">'),
-- (28, 'square', 'tax', '<a href="http://www.tkqlhce.com/click-2252260-10379592" target="_top"><img src="http://www.tqlkg.com/image-2252260-10379592" width="125" height="125" alt="Get Money in 48 Hours - TaxBrain.com" border="0"/></a>'),
-- (29, 'square', 'insurance', '<a href="http://www.anrdoezrs.net/click-2252260-9129459" target="_top"><img src="http://www.awltovhc.com/image-2252260-9129459" width="125" height="125" alt="Turn 21 Today!" border="0"/></a>'),
-- (30, 'square', 'typepad', '<a href="http://www.dpbolvw.net/click-2252260-10441127" target="_top"><img src="http://www.awltovhc.com/image-2252260-10441127" width="120" height="90" alt="" border="0"/></a>'),
-- (31, 'square', 'spamarrest', '<a target="_cts" href="http://www.spamarrest.com/affl?4024588-newscloud"><img src="//img.spamarrest.com/img/affiliate/''.$saImages[rand(0,4)].''.gif?4024588-newscloud" height="125" width="125" border="0"></a>'),
-- (32, 'square', 'spamarrest', '<a target="_cts" href="http://www.spamarrest.com/affl?4024588-newscloud"><img src="//img.spamarrest.com/img/affiliate/1845_ninja_125x125.gif?4024588-{trackid}" height="125" width="125" border="0"></a>\r'),
-- (33, 'square', 'spamarrest', '<a target="_cts" href="http://www.spamarrest.com/affl?4024588-newscloud"><img src="//img.spamarrest.com/img/affiliate/1845_ninja_125x125.gif?4024588-{trackid}" height="125" width="125" border="0"></a>\r'),
-- (34, 'square', 'spamarrest', '<a target="_cts" href="http://www.spamarrest.com/affl?4024588-newscloud"><img src="//img.spamarrest.com/img/affiliate/1845_popular_125x125.gif?4024588-{trackid}" height="125" width="125" border="0"></a>\r'),
-- (35, 'square', 'spamarrest', '<a target="_cts" href="http://www.spamarrest.com/affl?4024588-newscloud"><img src="//img.spamarrest.com/img/affiliate/1845_stop_125x125.gif?4024588-{trackid}" height="125" width="125" border="0"></a>\r'),
-- (36, 'square', 'amazon', '<a href="http://www.spamarrest.com/affl?4024588-ncBlog" title="I''m a customer of SpamArrest. It''s fantastic."><img src="//img.spamarrest.com/img/affiliate/1845_filter1_125x125.gif?4024588-ncBlog" height="125" width="125" border="0"></a>\r');
-- 
-- -- --------------------------------------------------------
-- 
-- --
-- -- Table structure for table `{omcollab_db_table_prefix}omcollab_adshare`
-- --
-- DROP TABLE IF EXISTS `{omcollab_db_table_prefix}omcollab_adshare`;
-- CREATE TABLE IF NOT EXISTS `{omcollab_db_table_prefix}omcollab_adshare` (
--   `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
--   `size` enum('banner','column','sidebar','square','leftCol','rightCol') DEFAULT 'banner',
--   `src` varchar(25) DEFAULT '',
--   `share` int(1) DEFAULT '0',
--   `site` enum('default','newscloud','idealog','ncblog','idealog') DEFAULT 'default',
--   PRIMARY KEY (`id`)
-- ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;
-- 
-- --
-- -- Dumping data for table `{omcollab_db_table_prefix}omcollab_adshare`
-- --
-- 
-- INSERT INTO `{omcollab_db_table_prefix}omcollab_adshare` (`id`, `size`, `src`, `share`, `site`) VALUES
-- (24, 'banner', 'spamArrest', 10, 'default'),
-- (25, 'banner', 'insurance', 1, 'default'),
-- (26, 'banner', 'wsj', 2, 'default'),
-- (27, 'banner', 'tax', 2, 'default'),
-- (28, 'banner', 'amazon', 10, 'default'),
-- (29, 'banner', 'meeting', 1, 'default'),
-- (30, 'banner', 'lava', 25, 'default'),
-- (31, 'banner', 'netflix', 25, 'default'),
-- (32, 'banner', 'googleText', 0, 'default'),
-- (33, 'banner', 'smug', 2, 'default'),
-- (34, 'banner', 'google', 50, 'default'),
-- (35, 'banner', 'dotster', 1, 'default'),
-- (36, 'rightCol', 'wsj', 10, 'default'),
-- (37, 'rightCol', 'netflix', 40, 'default'),
-- (38, 'rightCol', 'flowers', 25, 'default'),
-- (39, 'rightCol', 'google', 25, 'default'),
-- (40, 'leftCol', 'dotster', 5, 'default'),
-- (41, 'leftCol', 'smug', 25, 'default'),
-- (42, 'leftCol', 'insurance', 20, 'default'),
-- (43, 'leftCol', 'google', 50, 'default'),
-- (45, 'square', 'tax', 15, 'default'),
-- (46, 'square', 'insurance', 5, 'default'),
-- (47, 'square', 'typepad', 30, 'default'),
-- (48, 'square', 'spamarrest', 50, 'default'),
-- (49, 'square', 'amazon', 10, 'default');

DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_subscription`;
CREATE TABLE  `{omcollab_db_table_prefix}user_subscription` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `subscribe_flag` varchar(4) NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


-- Table and data script for score algorithm
DROP TABLE IF EXISTS `{omcollab_db_table_prefix}user_title_category`;
CREATE TABLE `{omcollab_db_table_prefix}user_title_category` (
  `tc_id` int(10) unsigned NOT NULL auto_increment,
  `tc_title` varchar(100) NOT NULL,
  `tc_score` int NOT NULL,
  `tc_comment` varchar(255) NOT NULL,
  PRIMARY Key (`tc_id`),
  KEY `key_tc_score` (`tc_score`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `{omcollab_db_table_prefix}user_title_category` (
`tc_id` ,
`tc_title` ,
`tc_score` ,
`tc_comment`
)
VALUES 
(1, 'Joiner', 0, '>=0'),
(2, 'Beginner', 20, '>=20'),
(3, 'Contributor', 50, '>=50'),
(4, 'Leader', 250, '>=250'),
(5, 'Expert', 500, '>=500'),
(6, 'Guru', 1000, '>=1000');

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;



-- New layout by Zhongzhen
-- reduce font size of welcome article  
UPDATE `{omcollab_db_table_prefix}text`
   SET `old_text` = 0x3c646976207374796c653d22666f6e742d73697a653a20313030253b223e0a2727274d494b45322e3020284d6574686f6420666f7220616e20496e7465677261746564204b6e6f776c6564676520456e7669726f6e6d656e742927272720697320616e205b5b4f70656e20536f7572636520436f6e636570747c4f70656e20536f757263655d5d206d6574686f646f6c6f677920666f72205b5b456e746572707269736520496e666f726d6174696f6e204d616e6167656d656e7420436f6e636570747c456e746572707269736520496e666f726d6174696f6e204d616e6167656d656e745d5d20746861742070726f76696465732061206672616d65776f726b20666f72205b5b496e666f726d6174696f6e20446576656c6f706d656e745d5d2e20546865204d494b45322e30204d6574686f646f6c6f67792069732070617274206f6620746865206f766572616c6c205b5b4f70656e204d6574686f646f6c6f6779204672616d65776f726b5d5d2e200a2727274d494b45322e30206973206120636f6c6c61626f726174697665206566666f727427272720746f2068656c70206f7267616e69736174696f6e732077686f206861766520696e7665737465642068656176696c7920696e206170706c69636174696f6e7320616e6420696e667261737472756374757265732c2062757420686176656e277420666f6375736564206f6e20746865206461746120616e6420696e666f726d6174696f6e206e65656473206f662074686520627573696e6573732e2057652062656c6965766520746869732068617320726573756c74656420696e206d616e79206f662074686520627573696e6573732070726f626c656d73206661636564206279206f7267616e69736174696f6e7320746f6461792061726f756e6420636f6d706c69616e63652c206c61636b206f6620637573746f6d657220696e73696768742c206661696c6564207472616e73666f726d6174696f6e2070726f6772616d6d657320616e6420746865206869676820636f7374206f6620746563686e6f6c6f67792073797374656d732e203c2f6469763e203c646976207374796c653d22626f726465723a2031707820736f6c696420726762283136332c203137362c20313931293b2070616464696e673a2030707820313470783b206d617267696e2d746f703a20313270783b20666c6f61743a2072696768743b20666f6e742d73697a653a20313030253b206261636b67726f756e642d636f6c6f723a20726762283232382c203233372c20323432293b223e5b5b57686174206973204d494b45322e307c57686174206973204d494b45322e303f5d5d207c205b687474703a2f2f6d696b65322e6f70656e6d6574686f646f6c6f67792e6f72672f6578706c6f7265204578706c6f7265204d494b45322e305d207c205b5b4d494b45323a5761797320746f20436f6e747269627574657c436f6e7472696275746520746f204d494b45322e305d5d207c205b5b48656c703a436f6e74656e74737c48656c705d5d207c205b5b4d494b45323a464151737c464151735d5d207c205b5b4d494b45323a5761797320746f20757365204d494b45322e307c557365204d494b45322e305d5d207c205b6d61696c746f3a6d696b6532406f70656e6d6574686f646f6c6f67792e6f7267204769766520757320666565646261636b5d203c2f6469763e200a3c62723e3c62723e
  WHERE `old_id`=22;

-- change portlet layout for anonymous user
  -- Column 1
  UPDATE `{omcollab_db_table_prefix}omcollab_layout`
     SET `col`='c1',
         `seq`=3
   WHERE `user_id` in (0,1) and `portlet_name`='member';
 
  UPDATE `{omcollab_db_table_prefix}omcollab_layout`
     SET `col`='c1',
         `seq`=4
   where `user_id` in (0,1) and `portlet_name`='subscription';

  -- Column 2
  UPDATE `{omcollab_db_table_prefix}omcollab_layout`
     SET `col`='c2',
         `seq`=5
   WHERE `user_id` in (0,1) and `portlet_name`='welcome';

  UPDATE `{omcollab_db_table_prefix}omcollab_layout`
     SET `col`='c2',
         `seq`=6
   WHERE `user_id` in (0,1) and `portlet_name`='article';

  UPDATE `{omcollab_db_table_prefix}omcollab_layout`
     SET `col`='c2', 
         `seq`=7
   WHERE `user_id` in (0,1) and `portlet_name`='activity';

  -- Column 3
  UPDATE `{omcollab_db_table_prefix}omcollab_layout`
     SET `col`='c3', 
         `seq`=8
   WHERE `user_id` in (0,1) and `portlet_name`='contributor';

  UPDATE `{omcollab_db_table_prefix}omcollab_layout`
     SET `col`='c3', 
         `seq`=9
   WHERE `user_id` in (0,1) and `portlet_name`='skill';

  UPDATE `{omcollab_db_table_prefix}omcollab_layout`
     SET `col`='c3', 
         `seq`=10
   WHERE `user_id` in (0,1) and `portlet_name`='community_chart';

  UPDATE `{omcollab_db_table_prefix}omcollab_layout`
     SET `col`='c3', 
          `seq`=11
   WHERE `user_id` in (0,1) and `portlet_name`='team';