[ros-diffs] [frik85] 26915: RosCMS update: * SQL import dump (structure only)
frik85 at svn.reactos.org
frik85 at svn.reactos.org
Sun May 27 13:07:12 CEST 2007
Author: frik85
Date: Sun May 27 15:07:11 2007
New Revision: 26915
URL: http://svn.reactos.org/svn/reactos?rev=26915&view=rev
Log:
RosCMS update:
* SQL import dump (structure only)
Added:
trunk/web/reactos.org/sql/roscms_v2_old.sql
Modified:
trunk/web/reactos.org/sql/roscms.sql
Modified: trunk/web/reactos.org/sql/roscms.sql
URL: http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/sql/roscms.sql?rev=26915&r1=26914&r2=26915&view=diff
==============================================================================
--- trunk/web/reactos.org/sql/roscms.sql (original)
+++ trunk/web/reactos.org/sql/roscms.sql Sun May 27 15:07:11 2007
@@ -1,14 +1,21 @@
---
--- Database: RosCMS
---
-
--- --------------------------------------------------------
-
---
--- Table structure for table `content`
---
-
-DROP TABLE IF EXISTS `content`;
+-- phpMyAdmin SQL Dump
+-- version 2.9.2
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Erstellungszeit: 27. Mai 2007 um 13:02
+-- Server Version: 5.0.33
+-- PHP-Version: 5.2.1
+--
+-- Datenbank: `roscms`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `content`
+--
+
CREATE TABLE `content` (
`content_id` bigint(20) NOT NULL auto_increment,
`content_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
@@ -23,34 +30,198 @@
`content_usrname_id` bigint(20) NOT NULL default '0',
`content_date` date NOT NULL default '0000-00-00',
`content_time` time NOT NULL default '00:00:00',
+ `content_altered` varchar(1) collate utf8_unicode_ci NOT NULL default '0',
PRIMARY KEY (`content_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents';
-
---
--- Data for table`content`
---
-
-INSERT INTO `content` (`content_id`, `content_name`, `content_lang`, `content_text`, `content_version`, `content_active`, `content_visible`, `content_type`, `content_description`, `content_editor`, `content_usrname_id`, `content_date`, `content_time`) VALUES (31, 'index', 'all', '<h1>ReactOS Content Management System - Test Page</h1>\r\n<p>English start page</p>', 1, 1, 1, 'default', '', 'richtext', 2, '2005-12-05', '11:48:43'),
-(2, 'bottom', 'all', '</div></td>\r\n </tr>\r\n</table>\r\n\r\n<!--\r\n links/lynx/etc.. dont handle css (atleast not external\r\n files by default) so dont overly depend on it.\r\n -->\r\n<hr style="height: 1px;"/>\r\n\r\n<address style="text-align:center;">\r\n ReactOS is a registered trademark or a trademark of ReactOS Foundation in the United States and other countries.</address>\r\n</body>\r\n</html> ', 1, 1, 1, 'layout', '', '', 2, '2005-09-19', '23:15:40'),
-(21, 'menu_top', 'all', '<div id="top">\r\n <div id="topMenu"> \r\n <!-- \r\n Use <p> to align things for links/lynx, then in the css make it\r\n margin: 0; and use text-align: left/right/etc;.\r\n -->\r\n <p style="text-align:left;"> \r\n <a href="[#link_index]">Home</a> <span style="color: #ffffff">|</span> \r\n <a href="[#link_news]">News</a> <span style="color: #ffffff">|</span> \r\n <a href="[#link_sitemap]">Sitemap</a></p>\r\n </div>\r\n </div>', 1, 1, 1, 'default', '2005-12-21 20:01:24 [2] |', '', 2, '2005-12-05', '11:49:02'),
-(24, 'menu_side', 'all', '<table style="border:0" width="100%" cellpadding="0" cellspacing="0">\r\n <tr valign="top">\r\n <td style="width:147px" id="leftNav"> \r\n <div class="navTitle">Navigation</div>\r\n <ol>\r\n <li><a href="[#link_index]">Home</a></li>\r\n <li><a href="[#link_news]">News</a></li>\r\n <li><a href="[#link_sitemap]">Sitemap</a></li>\r\n </ol>\r\n <p></p>\r\n ', 1, 1, 1, 'default', '2005-12-21 20:01:51 [2] |', '', 2, '2005-12-05', '11:48:53'),
-(96, 'head', 'all', '<?xml version="1.0" encoding="[#inc_charset]"?>\r\n<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"\r\n "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="[#roscms_language_short]" >\r\n\r\n<head>\r\n <title>ReactOS Homepage - [#roscms_pagetitle]</title>\r\n \r\n <meta http-equiv="Content-Type" content="application/xml" />\r\n <meta http-equiv="pics-label" content=''(pics-1.1 "http://www.icra.org/ratingsv02.html" l gen true for "http://www.reactos.com/" r (cz 1 lz 1 nz 1 oz 1 vz 1))'' />\r\n <meta http-equiv="Pragma" content="no-cache" />\r\n <meta name="Publisher" content="ReactOS Web Team" />\r\n <meta name="Copyright" content="ReactOS Foundation" />\r\n <meta name="generator" content="RosCMS" />\r\n <meta name="Keywords" content="reactos, ros, ros32, win32 ros64, roscms, operating system, wiki, forum, download, information, support database, compatibility database, compatibility, package database, reactos package manager, reactos content management system, reactos 0.1, reactos 0.2, reactos 0.3, ros 0.1, ros 0.2, ros 0.3" />\r\n <meta name="Description" content="ReactOS Homepage - ..." />\r\n <meta name="Page-topic" content="Betriebssystem, Computer, Software, downloads" />\r\n <meta name="Audience" content="all" />\r\n <meta name="Content-language" content="DE" />\r\n <meta name="Page-type" content="Operating System/Information/News" />\r\n <meta name="Robots" content="index,follow" />\r\n \r\n <link rel="SHORTCUT ICON" href="[#roscms_path_homepage]favicon.ico" />\r\n <link rel="alternate" type="application/rss+xml" title="ReactOS News Feed (RSS)" href="[#roscms_path_homepage]reactos.rdf" />\r\n <link href="[#roscms_path_homepage]style.css" type="text/css" rel="stylesheet" />\r\n</head>\r\n<body>', 2, 1, 1, 'layout', '2005-12-21 19:17:16 [2] |', '', 2, '2005-09-19', '23:38:29'),
-(228, 'menu_misc', 'all', '<div class="navTitle">Latest Update</div> \r\n <ol>\r\n <li><div style="text-align:center;">[#roscms_date] [#roscms_time]</div></li>\r\n </ol> \r\n <p> </p>\r\n </td>\r\n\r\n <td id="content"><div class="contentSmall"> ', 1, 1, 1, 'default', '', '', 2, '2005-12-21', '19:16:47'),
-(229, 'sidebar_right', 'all', '</div></td>\r\n\r\n <td id="rightNav">\r\n<h1>Latest Release</h1>\r\n<p><strong>Version [#inc_reactos_version]</strong>\r\n</p>\r\n', 8, 1, 1, 'default', '2005-12-21 19:50:38 [2] |', '', 2, '2005-12-21', '19:18:36'),
-(230, 'contmenu_home', 'all', '<div class="navTitle">Home</div> \r\n<ol> \r\n <li><a href="[#link_index]">Front Page</a></li>\r\n <li><a href="[#link_news]">News</a></li>\r\n <li><a href="[#link_sitemap]">Sitemap</a></li>\r\n</ol>\r\n<p></p>', 4, 1, 1, 'default', '2005-12-21 20:02:26 [2] |', '', 2, '2005-12-21', '19:20:34'),
-(120, 'menu_search', 'all', ' <div class="navTitle">Search</div> \r\n <div class="navBox"><form method="get" action="http://www.google.com/search" style="padding:0;margin:0">\r\n <div style="text-align:center;">\r\n\r\n <input name="q" value="" size="12" maxlength="80" class="searchInput" type="text" /><input name="domains" value="http://www.reactos.org" type="hidden" /><input name="sitesearch" value="http://www.reactos.org" type="hidden" />\r\n <input name="btnG" value="Go" type="submit" class="button" />\r\n\r\n </div></form>\r\n </div>\r\n<p></p>', 2, 1, 1, 'default', '', '', 2, '2005-11-09', '23:04:31'),
-(128, 'index', 'de', '<h1>ReactOS Content Management System - Test Page</h1>\r\n<p>German start page</p>', 1, 1, 1, 'default', '', 'richtext', 1, '2005-11-29', '20:14:46'),
-(152, 'menu_language', 'all', '<div class="navTitle">Language</div> \r\n <div class="navBox"> \r\n <form method="post" action="[#roscms_path_homepage]?page=[#roscms_pagename]&forma=[#roscms_format]&lang=" style="padding:0;margin:0">\r\n <div style="text-align:center;"> \r\n <select id="lang" size="1" name="lang" class="selectbox" style="width:110px" onchange="window.open(''[#roscms_path_homepage]?page=[#roscms_pagename]&forma=[#roscms_format]&lang='' + this.options[this.selectedIndex].value,''_main'')">\r\n <optgroup label="current language"> \r\n <option value="#" selected="selected">[#roscms_language]</option>\r\n </optgroup>\r\n <optgroup label="most popular"> \r\n <option value="en">English</option>\r\n <option value="de">Deutsch (German)</option>\r\n </optgroup>\r\n </select>\r\n <input name="langsubmit" type="submit" id="langsubmit" value=">" />\r\n </div>\r\n </form>\r\n </div>\r\n<p></p>', 3, 1, 1, 'layout', '2005-12-21 20:00:23 [2] |', '', 2, '2005-11-10', '21:48:20'),
-(220, 'contmenu_home', 'de', '<div class="navTitle">Startseite</div> \r\n<ol> \r\n <li><a href="[#link_index]">Startseite</a></li>\r\n <li><a href="[#link_news]">Neuigkeiten</a></li>\r\n <li><a href="[#link_sitemap]">Sitemap</a></li> \r\n</ol>\r\n<p></p>', 3, 1, 1, 'default', '2005-12-21 20:02:35 [2] |', '', 15, '2005-12-07', '21:24:40'),
-(222, 'sidebar_right', 'all', '</div></td>\r\n\r\n <td id="rightNav">\r\n[#inc_javascript_screenshot]\r\n <a href="[#link_screenshots]">More Screenshots</a><br />\r\n <a href="[#link_tour]">Take a look at the ReactOS Tour</a>\r\n</div><br />\r\n<h1>Latest Release</h1>\r\n<p><strong>Version [#inc_reactos_version]</strong><br />\r\n <a href="[#link_download]">Download Now!</a><br />\r\n <a href="[#link_dev_changelogs]">Changelog</a>\r\n</p>\r\n[#inc_template_news_latest]\r\n[#inc_template_newsletter_latest]\r\n<div class="contentSmall">\r\n <span class="contentSmallTitle">Developer Quotes</span>\r\n\r\n[#inc_javascript_quote]', 7, 0, 1, 'default', '', '', 2, '2005-12-07', '21:30:53');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `dyn_content`
---
-
-DROP TABLE IF EXISTS `dyn_content`;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents';
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_`
+--
+
+CREATE TABLE `data_` (
+ `data_id` int(11) NOT NULL auto_increment,
+ `data_name` varchar(100) collate utf8_unicode_ci NOT NULL COMMENT 'together with page_type unique entries',
+ `data_type` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT '"page", "layout", "content", "script"',
+ PRIMARY KEY (`data_id`),
+ KEY `data_name` (`data_name`,`data_type`),
+ KEY `data_type` (`data_type`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='all RosCMS v2 "pages", "content", "dyncontent" and "inctext"';
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_revision`
+--
+
+CREATE TABLE `data_revision` (
+ `rev_id` int(11) NOT NULL auto_increment COMMENT 'unique revisions id',
+ `data_id` int(11) NOT NULL,
+ `rev_version` int(11) NOT NULL COMMENT 'version number increase with every entry change',
+ `rev_language` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT 'language code ("en", "de", etc.)',
+ `rev_usrid` int(11) NOT NULL COMMENT 'user id who saved the entry',
+ `rev_datetime` datetime NOT NULL,
+ `rev_date` date NOT NULL,
+ `rev_time` time NOT NULL,
+ PRIMARY KEY (`rev_id`),
+ KEY `data_id` (`data_id`),
+ KEY `rev_language` (`rev_language`),
+ KEY `rev_version` (`rev_version`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_revision_a`
+--
+
+CREATE TABLE `data_revision_a` (
+ `rev_id` int(11) NOT NULL auto_increment COMMENT 'unique revisions id',
+ `data_id` int(11) NOT NULL,
+ `rev_version` int(11) NOT NULL COMMENT 'version number increase with every entry change',
+ `rev_language` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT 'language code ("en", "de", etc.)',
+ `rev_usrid` int(11) NOT NULL COMMENT 'user id who saved the entry',
+ `rev_datetime` datetime NOT NULL,
+ `rev_date` date NOT NULL,
+ `rev_time` time NOT NULL,
+ PRIMARY KEY (`rev_id`),
+ KEY `data_id` (`data_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_stext`
+--
+
+CREATE TABLE `data_stext` (
+ `stext_id` int(11) NOT NULL auto_increment,
+ `data_rev_id` int(11) NOT NULL,
+ `stext_name` varchar(100) collate utf8_unicode_ci NOT NULL,
+ `stext_content` varchar(255) collate utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`stext_id`),
+ KEY `data_rev_id` (`data_rev_id`),
+ FULLTEXT KEY `stext_content` (`stext_content`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_stext_a`
+--
+
+CREATE TABLE `data_stext_a` (
+ `stext_id` int(11) NOT NULL auto_increment,
+ `data_rev_id` int(11) NOT NULL,
+ `stext_name` varchar(100) collate utf8_unicode_ci NOT NULL,
+ `stext_content` varchar(255) collate utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`stext_id`),
+ FULLTEXT KEY `stext_content` (`stext_content`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_tag`
+--
+
+CREATE TABLE `data_tag` (
+ `tag_id` int(11) NOT NULL auto_increment,
+ `data_id` int(11) NOT NULL,
+ `data_rev_id` int(11) NOT NULL,
+ `tag_name_id` int(11) NOT NULL,
+ `tag_value_id` int(11) NOT NULL,
+ `tag_usrid` int(11) NOT NULL,
+ PRIMARY KEY (`tag_id`),
+ KEY `data_id` (`data_id`),
+ KEY `data_rev_id` (`data_rev_id`),
+ KEY `tag_name_id` (`tag_name_id`),
+ KEY `tag_value_id` (`tag_value_id`),
+ KEY `tag_usrid` (`tag_usrid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_tag_name`
+--
+
+CREATE TABLE `data_tag_name` (
+ `tn_id` int(11) NOT NULL auto_increment,
+ `tn_name` varchar(100) collate utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`tn_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_tag_value`
+--
+
+CREATE TABLE `data_tag_value` (
+ `tv_id` int(11) NOT NULL auto_increment,
+ `tv_value` varchar(255) collate utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`tv_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_text`
+--
+
+CREATE TABLE `data_text` (
+ `text_id` int(11) NOT NULL auto_increment,
+ `data_rev_id` int(11) NOT NULL,
+ `text_name` varchar(100) collate utf8_unicode_ci NOT NULL,
+ `text_content` text collate utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`text_id`),
+ KEY `data_rev_id` (`data_rev_id`),
+ FULLTEXT KEY `text_content` (`text_content`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_text_a`
+--
+
+CREATE TABLE `data_text_a` (
+ `text_id` int(11) NOT NULL auto_increment,
+ `data_rev_id` int(11) NOT NULL,
+ `text_name` varchar(100) collate utf8_unicode_ci NOT NULL,
+ `text_content` text collate utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`text_id`),
+ FULLTEXT KEY `text_content` (`text_content`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `data_user_filter`
+--
+
+CREATE TABLE `data_user_filter` (
+ `filt_id` int(11) NOT NULL auto_increment,
+ `filt_usrid` int(11) NOT NULL,
+ `filt_title` varchar(50) collate utf8_unicode_ci NOT NULL,
+ `filt_type` smallint(6) NOT NULL default '1',
+ `filt_string` varchar(255) collate utf8_unicode_ci NOT NULL,
+ `filt_datetime` datetime NOT NULL,
+ `filt_usage` int(11) NOT NULL,
+ `filt_usagedate` datetime NOT NULL,
+ PRIMARY KEY (`filt_id`),
+ KEY `filt_usrid` (`filt_usrid`),
+ KEY `filt_name` (`filt_title`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `dyn_content`
+--
+
CREATE TABLE `dyn_content` (
`dyn_id` bigint(20) NOT NULL auto_increment,
`dyn_content_id` bigint(20) NOT NULL default '0',
@@ -68,22 +239,16 @@
`dyn_content_usrname_id` bigint(20) NOT NULL default '0',
`dyn_content_date` date NOT NULL default '0000-00-00',
`dyn_content_time` time NOT NULL default '00:00:00',
+ `dyn_altered` varchar(1) collate utf8_unicode_ci NOT NULL default '0',
PRIMARY KEY (`dyn_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents';
-
---
--- Data for table`dyn_content`
---
-
-INSERT INTO `dyn_content` (`dyn_id`, `dyn_content_id`, `dyn_content_nr`, `dyn_content_name`, `dyn_content_lang`, `dyn_content_text1`, `dyn_content_text2`, `dyn_content_text3`, `dyn_content_text4`, `dyn_content_version`, `dyn_content_active`, `dyn_content_visible`, `dyn_content_editor`, `dyn_content_usrname_id`, `dyn_content_date`, `dyn_content_time`) VALUES (28, 1, 1, 'news_page', 'all', 'RosCMS test news', '', 'RosCMS test news description', '<p><b><u>RosCMS</u></b> test news content</p> ...', 0, 1, 1, '', 2, '2005-12-21', '19:53:14');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `include_text`
---
-
-DROP TABLE IF EXISTS `include_text`;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents';
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `include_text`
+--
+
CREATE TABLE `include_text` (
`inc_id` bigint(20) NOT NULL auto_increment,
`inc_level` tinyint(4) NOT NULL default '0',
@@ -96,50 +261,28 @@
`inc_usrname_id` bigint(20) NOT NULL default '0',
`inc_date` date NOT NULL default '0000-00-00',
`inc_time` time NOT NULL default '00:00:00',
+ `inc_altered` varchar(1) collate utf8_unicode_ci NOT NULL default '0',
PRIMARY KEY (`inc_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Replace words with text phrases';
-
---
--- Data for table`include_text`
---
-
-INSERT INTO `include_text` (`inc_id`, `inc_level`, `inc_word`, `inc_text`, `inc_lang`, `inc_extra`, `inc_vis`, `inc_seclevel`, `inc_usrname_id`, `inc_date`, `inc_time`) VALUES (48, 15, 'template_news_detail', '<?php\r\n if ( !defined("ROSCMS_SYSTEM") ) {\r\n define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking activity\r\n }\r\n\r\n include("db/connect_db.inc.php"); // database connection script\r\n\r\n $query_content = mysql_query("SELECT * \r\n FROM `dyn_content` \r\n WHERE 1 AND `dyn_content_name` = ''news_page'' AND `dyn_content_id` = ''$roscms_template_var_pageid''\r\n ORDER BY `dyn_content_nr` ASC Limit 1") ;\r\n \r\n $result_content = mysql_fetch_array($query_content);\r\n $roscms_usrnameid = $result_content["dyn_content_usrname_id"];\r\n $query_usraccount= mysql_query("SELECT * \r\n FROM `users` \r\n WHERE `user_id` = ".$roscms_usrnameid." LIMIT 1");\r\n $result_usraccount=mysql_fetch_array($query_usraccount);\r\n?>\r\n<h1><a href="[#link_index]">Home</a> > <a href="[#link_news]">ReactOS News</a> > News: <?php echo $result_content["dyn_content_text1"]; ?> #<?php echo $roscms_template_var_pageid; ?></h1> \r\n <p><strong><?php echo $result_content["dyn_content_text3"]; ?></strong></p>\r\n <p><i>by <?php echo $result_usraccount[''user_name'']; ?> on <?php echo $result_content[''dyn_content_date'']; ?></i></p>\r\n<?php echo $result_content[''dyn_content_text4'']; ?>\r\n<p><a href="[#link_news]">News Archive</a></p>', 'all', 'template_php', 1, 50, 1, '2005-12-21', '19:55:14'),
-(19, 10, 'path_homepage_media', '[#roscms_path_homepage]media/', 'all', '', 1, 50, 0, '2005-07-13', '18:00:35'),
-(20, 15, 'path_homepage_media_pictures', '[#roscms_path_homepage]media/pictures/', 'all', '', 1, 50, 0, '2005-07-13', '18:00:35'),
-(23, 15, 'template_news', '<h1><a href="[#link_index]">Home</a> > ReactOS News</h1>\r\n<?php\r\n if ( !defined("ROSCMS_SYSTEM") ) {\r\n define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking activity\r\n }\r\n\r\n include("db/connect_db.inc.php"); // database connection script\r\n\r\n\r\n $query_content = mysql_query("SELECT * \r\n FROM `dyn_content` \r\n WHERE 1 AND `dyn_content_name` = ''news_page'' AND `dyn_content_nr` = ''1''\r\n ORDER BY `dyn_content_id` DESC ") ;\r\n \r\n while($result_content = mysql_fetch_array($query_content)) { // content\r\n $roscms_usrnameid = $result_content["dyn_content_usrname_id"];\r\n $query_usraccount= mysql_query("SELECT * \r\n FROM `users` \r\n WHERE `user_id` = ".$roscms_usrnameid." LIMIT 0 , 1");\r\n $result_usraccount=mysql_fetch_array($query_usraccount);\r\n?>\r\n\r\n<p><b><a href="<?php echo "[#link_".$result_content["dyn_content_name"]."_".$result_content["dyn_content_id"]."]"; ?>"><?php echo $result_content["dyn_content_text1"]; ?></a></b>\r\n<br><?php echo $result_content[''dyn_content_text3'']; ?>\r\n<br><i>by <?php echo $result_usraccount[''user_name'']; ?> on <?php echo $result_content[''dyn_content_date'']; ?></i></p>\r\n <?php \r\n } // end while\r\n?>\r\n', 'all', 'template_php', 1, 50, 0, '2005-07-30', '11:50:18'),
-(26, 0, 'reactos_version', '0.2.8', 'all', '', 1, 50, 1, '2005-08-13', '16:18:56'),
-(27, 15, 'template_sitemap', '<h1><a href="[#link_index]">Home</a> > Sitemap</h1>\r\n<?php\r\n if ( !defined("ROSCMS_SYSTEM") ) {\r\n define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking activity\r\n }\r\n\r\n include("db/connect_db.inc.php"); // database connection script\r\n\r\n\r\n $query_sitemap = mysql_query("SELECT * \r\n FROM pages\r\n WHERE page_active = ''1'' AND page_visible = ''1'' AND (page_language = ''all'' OR page_language = ''en'')\r\n ORDER BY ''page_name'' ASC") ;\r\n \r\n while($result_sitemap = mysql_fetch_array($query_sitemap)) { // content\r\n if ($result_sitemap[''page_description''] != "") {\r\n?>\r\n\r\n<p><b><a href="<?php echo "[#link_".$result_sitemap[''page_name'']."]"; ?>"><?php echo ucfirst($result_sitemap[''page_title'']); ?></a></b>\r\n<br><i><?php echo $result_sitemap[''page_description'']; ?></i></p>\r\n <?php\r\n } \r\n } // end while\r\n?>\r\n', 'all', 'template_php', 1, 50, 0, '2005-08-13', '20:58:04'),
-(34, 0, 'charset', 'utf-8', 'all', '', 1, 50, 1, '2005-08-27', '15:54:16'),
-(39, 15, 'path_homepage_media_screenshots', '[#roscms_path_homepage]media/screenshots/', 'all', '', 1, 50, 0, '2005-07-13', '18:00:35');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `languages`
---
-
-DROP TABLE IF EXISTS `languages`;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Replace words with text phrases';
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `languages`
+--
+
CREATE TABLE `languages` (
`lang_id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
`lang_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
`lang_level` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='available languages';
---
--- Data for table`languages`
---
-
-INSERT INTO `languages` (`lang_id`, `lang_name`, `lang_level`)
-VALUES ('en', 'English', 10),
-('de', 'German', 8);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pages`
---
-
-DROP TABLE IF EXISTS `pages`;
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `pages`
+--
+
CREATE TABLE `pages` (
`page_id` bigint(20) NOT NULL auto_increment,
`page_name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
@@ -155,27 +298,19 @@
`page_time` time NOT NULL default '00:00:00',
`page_generate_usrid` bigint(20) NOT NULL default '0',
`page_generate_timestamp` varchar(50) collate utf8_unicode_ci NOT NULL default '',
+ `page_generate_force` char(1) collate utf8_unicode_ci NOT NULL default '0',
`page_title` varchar(150) collate utf8_unicode_ci NOT NULL default '',
`page_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
- PRIMARY KEY (`page_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Pages';
-
---
--- Data for table`pages`
---
-
-INSERT INTO `pages` (`page_id`, `page_name`, `page_language`, `pages_extra`, `pages_extention`, `page_text`, `page_version`, `page_active`, `page_visible`, `page_usrname_id`, `page_date`, `page_time`, `page_generate_usrid`, `page_generate_timestamp`, `page_title`, `page_description`) VALUES (6, 'news_page', 'all', 'dynamic', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#inc_template_news_detail]\r\n\r\n[#cont_bottom]', 1, 1, 1, 1, '2005-09-12', '18:50:20', 1, '1135191757', 'News', ''),
-(7, 'news', 'all', '', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#inc_template_news]\r\n\r\n[#cont_bottom]', 1, 1, 1, 1, '2005-09-12', '18:50:28', 1, '1135191757', 'News', 'News page: latest ReactOS news, rss news feed'),
-(9, 'index', 'all', '', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#cont_index]\r\n\r\n[#cont_sidebar_right]\r\n[#cont_bottom]', 1, 1, 1, 1, '2005-12-21', '19:21:43', 1, '1135191757', 'Frontpage', 'Frontpage'),
-(91, 'sitemap', 'all', '', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#inc_template_sitemap]\r\n\r\n[#cont_bottom]\r\n', 1, 1, 1, 1, '2005-12-21', '19:58:07', 1, '1135191757', 'Sitemap', 'Sitemap page');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `roscms_security_log`
---
-
-DROP TABLE IF EXISTS `roscms_security_log`;
+ PRIMARY KEY (`page_id`),
+ KEY `page_generate_force` (`page_generate_force`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Pages';
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `roscms_security_log`
+--
+
CREATE TABLE `roscms_security_log` (
`roscms_sec_log_id` bigint(20) NOT NULL auto_increment,
`roscms_sec_log_section` varchar(100) collate utf8_unicode_ci NOT NULL default '',
@@ -190,20 +325,14 @@
`roscms_sec_log_time` time NOT NULL default '00:00:00',
`roscms_sec_log_visible` int(11) NOT NULL default '1',
PRIMARY KEY (`roscms_sec_log_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS Security Log';
-
---
--- Data for table`roscms_security_log`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `subsys_mappings`
---
-
-DROP TABLE IF EXISTS `subsys_mappings`;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS Security Log';
+
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `subsys_mappings`
+--
+
CREATE TABLE `subsys_mappings` (
`map_roscms_userid` bigint(20) NOT NULL default '0',
`map_subsys_name` varchar(10) character set utf8 NOT NULL default '',
@@ -211,14 +340,12 @@
PRIMARY KEY (`map_roscms_userid`,`map_subsys_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `user_sessions`
---
-
-DROP TABLE IF EXISTS `user_sessions`;
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `user_sessions`
+--
+
CREATE TABLE `user_sessions` (
`usersession_id` varchar(32) character set utf8 NOT NULL default '' COMMENT 'Unique ID of this session',
`usersession_user_id` bigint(20) NOT NULL default '0' COMMENT 'User this session belongs to',
@@ -229,37 +356,23 @@
PRIMARY KEY (`usersession_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0 COMMENT='Sessions';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `usergroup_members`
---
-
-DROP TABLE IF EXISTS `usergroup_members`;
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `usergroup_members`
+--
+
CREATE TABLE `usergroup_members` (
`usergroupmember_userid` bigint(20) NOT NULL default '0',
`usergroupmember_usergroupid` varchar(10) collate utf8_unicode_ci NOT NULL default 'user'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
---
--- Data for table`usergroup_members`
---
-
-INSERT INTO `usergroup_members` (`usergroupmember_userid`, `usergroupmember_usergroupid`)
-VALUES (1, 'ros_sadmin'),
-(1, 'developer'),
-(1, 'translator'),
-(1, 'moderator'),
-(1, 'user');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `usergroups`
---
-
-DROP TABLE IF EXISTS `usergroups`;
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `usergroups`
+--
+
CREATE TABLE `usergroups` (
`usrgroup_name_id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
`usrgroup_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
@@ -270,26 +383,12 @@
UNIQUE KEY `usrgroup_name` (`usrgroup_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
---
--- Data for table`usergroups`
---
-
-INSERT INTO `usergroups` (`usrgroup_name_id`, `usrgroup_name`, `usrgroup_intern_id`, `usrgroup_securitylevel`, `usrgroup_description`) VALUES ('ros_admin', 'Administrator', 'roscms_usrgrp_admin', 70, 'Administrator-Group: manage the ReactOS homepage (content, database)'),
-('user', 'User', 'roscms_usrgrp_user', 0, 'Normal Visitors'),
-('developer', 'Developer', 'roscms_usrgrp_dev', 50, 'ReactOS Developer: persons with svn commit access'),
-('moderator', 'Moderator', 'roscms_usrgrp_team', 20, 'Homepage Moderators: for compatibility & package manager database, etc.'),
-('translator', 'Translator', 'roscms_usrgrp_trans', 10, 'Homepage Translators: translate the homepage content'),
-('ros_sadmin', 'Super-Administrator', 'roscms_usrgrp_sadmin', 100, 'Super-Administrator-Group: manage the ReactOS homepage (content, database, etc.); only persons who know what they are doing ...'),
-('mediateam', 'Media-Team', 'roscms_usrgrp_team', 20, 'Media-Team members: UI-Team, etc.'),
-('test', 'Test-User', 'roscms_usrgrp_team', 10, 'RosCMS tester group');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `users`
---
-
-DROP TABLE IF EXISTS `users`;
+-- --------------------------------------------------------
+
+--
+-- Tabellenstruktur für Tabelle `users`
+--
+
CREATE TABLE `users` (
`user_id` bigint(20) NOT NULL auto_increment,
`user_name` varchar(20) collate utf8_unicode_ci NOT NULL default '',
@@ -316,11 +415,4 @@
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name` (`user_name`),
UNIQUE KEY `user_email` (`user_email`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS User Table';
-
---
--- Data for table`users`
---
-
-INSERT INTO `users` (`user_id`, `user_name`, `user_roscms_password`, `user_roscms_getpwd_id`, `user_timestamp_touch`, `user_timestamp_touch2`, `user_login_counter`, `user_account_enabled`, `user_account_hidden`, `user_register`, `user_fullname`, `user_email`, `user_website`, `user_language`, `user_country`, `user_timezone`, `user_occupation`, `user_description`, `user_setting_multisession`, `user_setting_browseragent`, `user_setting_ipaddress`, `user_setting_timeout`)
-VALUES (1, 'roscms_user', '', '', '', '2005-12-08 20:02:50', 1, 'yes', 'yes', '2005-08-20 20:18:06', 'ReactOS Content Management System Default User', 'ros-dev at reactos.org', 'http://www.reactos.org', 'en', '', '', '', 'RosCMS Default User', 'true', 'false', 'false', 'true');
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS User Table';
Added: trunk/web/reactos.org/sql/roscms_v2_old.sql
URL: http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/sql/roscms_v2_old.sql?rev=26915&view=auto
==============================================================================
--- trunk/web/reactos.org/sql/roscms_v2_old.sql (added)
+++ trunk/web/reactos.org/sql/roscms_v2_old.sql Sun May 27 15:07:11 2007
@@ -1,0 +1,326 @@
+--
+-- Database: RosCMS
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `content`
+--
+
+DROP TABLE IF EXISTS `content`;
+CREATE TABLE `content` (
+ `content_id` bigint(20) NOT NULL auto_increment,
+ `content_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
+ `content_lang` varchar(10) collate utf8_unicode_ci NOT NULL default 'all',
+ `content_text` text collate utf8_unicode_ci NOT NULL,
+ `content_version` int(11) NOT NULL default '0',
+ `content_active` tinyint(4) NOT NULL default '0',
+ `content_visible` tinyint(4) NOT NULL default '0',
+ `content_type` varchar(10) collate utf8_unicode_ci NOT NULL default 'default',
+ `content_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ `content_editor` varchar(10) collate utf8_unicode_ci NOT NULL default '',
+ `content_usrname_id` bigint(20) NOT NULL default '0',
+ `content_date` date NOT NULL default '0000-00-00',
+ `content_time` time NOT NULL default '00:00:00',
+ PRIMARY KEY (`content_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents';
+
+--
+-- Data for table`content`
+--
+
+INSERT INTO `content` (`content_id`, `content_name`, `content_lang`, `content_text`, `content_version`, `content_active`, `content_visible`, `content_type`, `content_description`, `content_editor`, `content_usrname_id`, `content_date`, `content_time`) VALUES (31, 'index', 'all', '<h1>ReactOS Content Management System - Test Page</h1>\r\n<p>English start page</p>', 1, 1, 1, 'default', '', 'richtext', 2, '2005-12-05', '11:48:43'),
+(2, 'bottom', 'all', '</div></td>\r\n </tr>\r\n</table>\r\n\r\n<!--\r\n links/lynx/etc.. dont handle css (atleast not external\r\n files by default) so dont overly depend on it.\r\n -->\r\n<hr style="height: 1px;"/>\r\n\r\n<address style="text-align:center;">\r\n ReactOS is a registered trademark or a trademark of ReactOS Foundation in the United States and other countries.</address>\r\n</body>\r\n</html> ', 1, 1, 1, 'layout', '', '', 2, '2005-09-19', '23:15:40'),
+(21, 'menu_top', 'all', '<div id="top">\r\n <div id="topMenu"> \r\n <!-- \r\n Use <p> to align things for links/lynx, then in the css make it\r\n margin: 0; and use text-align: left/right/etc;.\r\n -->\r\n <p style="text-align:left;"> \r\n <a href="[#link_index]">Home</a> <span style="color: #ffffff">|</span> \r\n <a href="[#link_news]">News</a> <span style="color: #ffffff">|</span> \r\n <a href="[#link_sitemap]">Sitemap</a></p>\r\n </div>\r\n </div>', 1, 1, 1, 'default', '2005-12-21 20:01:24 [2] |', '', 2, '2005-12-05', '11:49:02'),
+(24, 'menu_side', 'all', '<table style="border:0" width="100%" cellpadding="0" cellspacing="0">\r\n <tr valign="top">\r\n <td style="width:147px" id="leftNav"> \r\n <div class="navTitle">Navigation</div>\r\n <ol>\r\n <li><a href="[#link_index]">Home</a></li>\r\n <li><a href="[#link_news]">News</a></li>\r\n <li><a href="[#link_sitemap]">Sitemap</a></li>\r\n </ol>\r\n <p></p>\r\n ', 1, 1, 1, 'default', '2005-12-21 20:01:51 [2] |', '', 2, '2005-12-05', '11:48:53'),
+(96, 'head', 'all', '<?xml version="1.0" encoding="[#inc_charset]"?>\r\n<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"\r\n "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="[#roscms_language_short]" >\r\n\r\n<head>\r\n <title>ReactOS Homepage - [#roscms_pagetitle]</title>\r\n \r\n <meta http-equiv="Content-Type" content="application/xml" />\r\n <meta http-equiv="pics-label" content=''(pics-1.1 "http://www.icra.org/ratingsv02.html" l gen true for "http://www.reactos.com/" r (cz 1 lz 1 nz 1 oz 1 vz 1))'' />\r\n <meta http-equiv="Pragma" content="no-cache" />\r\n <meta name="Publisher" content="ReactOS Web Team" />\r\n <meta name="Copyright" content="ReactOS Foundation" />\r\n <meta name="generator" content="RosCMS" />\r\n <meta name="Keywords" content="reactos, ros, ros32, win32 ros64, roscms, operating system, wiki, forum, download, information, support database, compatibility database, compatibility, package database, reactos package manager, reactos content management system, reactos 0.1, reactos 0.2, reactos 0.3, ros 0.1, ros 0.2, ros 0.3" />\r\n <meta name="Description" content="ReactOS Homepage - ..." />\r\n <meta name="Page-topic" content="Betriebssystem, Computer, Software, downloads" />\r\n <meta name="Audience" content="all" />\r\n <meta name="Content-language" content="DE" />\r\n <meta name="Page-type" content="Operating System/Information/News" />\r\n <meta name="Robots" content="index,follow" />\r\n \r\n <link rel="SHORTCUT ICON" href="[#roscms_path_homepage]favicon.ico" />\r\n <link rel="alternate" type="application/rss+xml" title="ReactOS News Feed (RSS)" href="[#roscms_path_homepage]reactos.rdf" />\r\n <link href="[#roscms_path_homepage]style.css" type="text/css" rel="stylesheet" />\r\n</head>\r\n<body>', 2, 1, 1, 'layout', '2005-12-21 19:17:16 [2] |', '', 2, '2005-09-19', '23:38:29'),
+(228, 'menu_misc', 'all', '<div class="navTitle">Latest Update</div> \r\n <ol>\r\n <li><div style="text-align:center;">[#roscms_date] [#roscms_time]</div></li>\r\n </ol> \r\n <p> </p>\r\n </td>\r\n\r\n <td id="content"><div class="contentSmall"> ', 1, 1, 1, 'default', '', '', 2, '2005-12-21', '19:16:47'),
+(229, 'sidebar_right', 'all', '</div></td>\r\n\r\n <td id="rightNav">\r\n<h1>Latest Release</h1>\r\n<p><strong>Version [#inc_reactos_version]</strong>\r\n</p>\r\n', 8, 1, 1, 'default', '2005-12-21 19:50:38 [2] |', '', 2, '2005-12-21', '19:18:36'),
+(230, 'contmenu_home', 'all', '<div class="navTitle">Home</div> \r\n<ol> \r\n <li><a href="[#link_index]">Front Page</a></li>\r\n <li><a href="[#link_news]">News</a></li>\r\n <li><a href="[#link_sitemap]">Sitemap</a></li>\r\n</ol>\r\n<p></p>', 4, 1, 1, 'default', '2005-12-21 20:02:26 [2] |', '', 2, '2005-12-21', '19:20:34'),
+(120, 'menu_search', 'all', ' <div class="navTitle">Search</div> \r\n <div class="navBox"><form method="get" action="http://www.google.com/search" style="padding:0;margin:0">\r\n <div style="text-align:center;">\r\n\r\n <input name="q" value="" size="12" maxlength="80" class="searchInput" type="text" /><input name="domains" value="http://www.reactos.org" type="hidden" /><input name="sitesearch" value="http://www.reactos.org" type="hidden" />\r\n <input name="btnG" value="Go" type="submit" class="button" />\r\n\r\n </div></form>\r\n </div>\r\n<p></p>', 2, 1, 1, 'default', '', '', 2, '2005-11-09', '23:04:31'),
+(128, 'index', 'de', '<h1>ReactOS Content Management System - Test Page</h1>\r\n<p>German start page</p>', 1, 1, 1, 'default', '', 'richtext', 1, '2005-11-29', '20:14:46'),
+(152, 'menu_language', 'all', '<div class="navTitle">Language</div> \r\n <div class="navBox"> \r\n <form method="post" action="[#roscms_path_homepage]?page=[#roscms_pagename]&forma=[#roscms_format]&lang=" style="padding:0;margin:0">\r\n <div style="text-align:center;"> \r\n <select id="lang" size="1" name="lang" class="selectbox" style="width:110px" onchange="window.open(''[#roscms_path_homepage]?page=[#roscms_pagename]&forma=[#roscms_format]&lang='' + this.options[this.selectedIndex].value,''_main'')">\r\n <optgroup label="current language"> \r\n <option value="#" selected="selected">[#roscms_language]</option>\r\n </optgroup>\r\n <optgroup label="most popular"> \r\n <option value="en">English</option>\r\n <option value="de">Deutsch (German)</option>\r\n </optgroup>\r\n </select>\r\n <input name="langsubmit" type="submit" id="langsubmit" value=">" />\r\n </div>\r\n </form>\r\n </div>\r\n<p></p>', 3, 1, 1, 'layout', '2005-12-21 20:00:23 [2] |', '', 2, '2005-11-10', '21:48:20'),
+(220, 'contmenu_home', 'de', '<div class="navTitle">Startseite</div> \r\n<ol> \r\n <li><a href="[#link_index]">Startseite</a></li>\r\n <li><a href="[#link_news]">Neuigkeiten</a></li>\r\n <li><a href="[#link_sitemap]">Sitemap</a></li> \r\n</ol>\r\n<p></p>', 3, 1, 1, 'default', '2005-12-21 20:02:35 [2] |', '', 15, '2005-12-07', '21:24:40'),
+(222, 'sidebar_right', 'all', '</div></td>\r\n\r\n <td id="rightNav">\r\n[#inc_javascript_screenshot]\r\n <a href="[#link_screenshots]">More Screenshots</a><br />\r\n <a href="[#link_tour]">Take a look at the ReactOS Tour</a>\r\n</div><br />\r\n<h1>Latest Release</h1>\r\n<p><strong>Version [#inc_reactos_version]</strong><br />\r\n <a href="[#link_download]">Download Now!</a><br />\r\n <a href="[#link_dev_changelogs]">Changelog</a>\r\n</p>\r\n[#inc_template_news_latest]\r\n[#inc_template_newsletter_latest]\r\n<div class="contentSmall">\r\n <span class="contentSmallTitle">Developer Quotes</span>\r\n\r\n[#inc_javascript_quote]', 7, 0, 1, 'default', '', '', 2, '2005-12-07', '21:30:53');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `dyn_content`
+--
+
+DROP TABLE IF EXISTS `dyn_content`;
+CREATE TABLE `dyn_content` (
+ `dyn_id` bigint(20) NOT NULL auto_increment,
+ `dyn_content_id` bigint(20) NOT NULL default '0',
+ `dyn_content_nr` int(11) NOT NULL default '0',
+ `dyn_content_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
+ `dyn_content_lang` varchar(10) collate utf8_unicode_ci NOT NULL default 'all',
+ `dyn_content_text1` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ `dyn_content_text2` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ `dyn_content_text3` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ `dyn_content_text4` longtext collate utf8_unicode_ci NOT NULL,
+ `dyn_content_version` int(11) NOT NULL default '0',
+ `dyn_content_active` tinyint(4) NOT NULL default '0',
+ `dyn_content_visible` tinyint(4) NOT NULL default '0',
+ `dyn_content_editor` varchar(10) collate utf8_unicode_ci NOT NULL default '',
+ `dyn_content_usrname_id` bigint(20) NOT NULL default '0',
+ `dyn_content_date` date NOT NULL default '0000-00-00',
+ `dyn_content_time` time NOT NULL default '00:00:00',
+ PRIMARY KEY (`dyn_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents';
+
+--
+-- Data for table`dyn_content`
+--
+
+INSERT INTO `dyn_content` (`dyn_id`, `dyn_content_id`, `dyn_content_nr`, `dyn_content_name`, `dyn_content_lang`, `dyn_content_text1`, `dyn_content_text2`, `dyn_content_text3`, `dyn_content_text4`, `dyn_content_version`, `dyn_content_active`, `dyn_content_visible`, `dyn_content_editor`, `dyn_content_usrname_id`, `dyn_content_date`, `dyn_content_time`) VALUES (28, 1, 1, 'news_page', 'all', 'RosCMS test news', '', 'RosCMS test news description', '<p><b><u>RosCMS</u></b> test news content</p> ...', 0, 1, 1, '', 2, '2005-12-21', '19:53:14');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `include_text`
+--
+
+DROP TABLE IF EXISTS `include_text`;
+CREATE TABLE `include_text` (
+ `inc_id` bigint(20) NOT NULL auto_increment,
+ `inc_level` tinyint(4) NOT NULL default '0',
+ `inc_word` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ `inc_text` text collate utf8_unicode_ci NOT NULL,
+ `inc_lang` varchar(10) collate utf8_unicode_ci NOT NULL default 'all',
+ `inc_extra` varchar(20) collate utf8_unicode_ci NOT NULL default '',
+ `inc_vis` tinyint(4) NOT NULL default '0',
+ `inc_seclevel` tinyint(4) NOT NULL default '50',
+ `inc_usrname_id` bigint(20) NOT NULL default '0',
+ `inc_date` date NOT NULL default '0000-00-00',
+ `inc_time` time NOT NULL default '00:00:00',
+ PRIMARY KEY (`inc_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Replace words with text phrases';
+
+--
+-- Data for table`include_text`
+--
+
+INSERT INTO `include_text` (`inc_id`, `inc_level`, `inc_word`, `inc_text`, `inc_lang`, `inc_extra`, `inc_vis`, `inc_seclevel`, `inc_usrname_id`, `inc_date`, `inc_time`) VALUES (48, 15, 'template_news_detail', '<?php\r\n if ( !defined("ROSCMS_SYSTEM") ) {\r\n define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking activity\r\n }\r\n\r\n include("db/connect_db.inc.php"); // database connection script\r\n\r\n $query_content = mysql_query("SELECT * \r\n FROM `dyn_content` \r\n WHERE 1 AND `dyn_content_name` = ''news_page'' AND `dyn_content_id` = ''$roscms_template_var_pageid''\r\n ORDER BY `dyn_content_nr` ASC Limit 1") ;\r\n \r\n $result_content = mysql_fetch_array($query_content);\r\n $roscms_usrnameid = $result_content["dyn_content_usrname_id"];\r\n $query_usraccount= mysql_query("SELECT * \r\n FROM `users` \r\n WHERE `user_id` = ".$roscms_usrnameid." LIMIT 1");\r\n $result_usraccount=mysql_fetch_array($query_usraccount);\r\n?>\r\n<h1><a href="[#link_index]">Home</a> > <a href="[#link_news]">ReactOS News</a> > News: <?php echo $result_content["dyn_content_text1"]; ?> #<?php echo $roscms_template_var_pageid; ?></h1> \r\n <p><strong><?php echo $result_content["dyn_content_text3"]; ?></strong></p>\r\n <p><i>by <?php echo $result_usraccount[''user_name'']; ?> on <?php echo $result_content[''dyn_content_date'']; ?></i></p>\r\n<?php echo $result_content[''dyn_content_text4'']; ?>\r\n<p><a href="[#link_news]">News Archive</a></p>', 'all', 'template_php', 1, 50, 1, '2005-12-21', '19:55:14'),
+(19, 10, 'path_homepage_media', '[#roscms_path_homepage]media/', 'all', '', 1, 50, 0, '2005-07-13', '18:00:35'),
+(20, 15, 'path_homepage_media_pictures', '[#roscms_path_homepage]media/pictures/', 'all', '', 1, 50, 0, '2005-07-13', '18:00:35'),
+(23, 15, 'template_news', '<h1><a href="[#link_index]">Home</a> > ReactOS News</h1>\r\n<?php\r\n if ( !defined("ROSCMS_SYSTEM") ) {\r\n define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking activity\r\n }\r\n\r\n include("db/connect_db.inc.php"); // database connection script\r\n\r\n\r\n $query_content = mysql_query("SELECT * \r\n FROM `dyn_content` \r\n WHERE 1 AND `dyn_content_name` = ''news_page'' AND `dyn_content_nr` = ''1''\r\n ORDER BY `dyn_content_id` DESC ") ;\r\n \r\n while($result_content = mysql_fetch_array($query_content)) { // content\r\n $roscms_usrnameid = $result_content["dyn_content_usrname_id"];\r\n $query_usraccount= mysql_query("SELECT * \r\n FROM `users` \r\n WHERE `user_id` = ".$roscms_usrnameid." LIMIT 0 , 1");\r\n $result_usraccount=mysql_fetch_array($query_usraccount);\r\n?>\r\n\r\n<p><b><a href="<?php echo "[#link_".$result_content["dyn_content_name"]."_".$result_content["dyn_content_id"]."]"; ?>"><?php echo $result_content["dyn_content_text1"]; ?></a></b>\r\n<br><?php echo $result_content[''dyn_content_text3'']; ?>\r\n<br><i>by <?php echo $result_usraccount[''user_name'']; ?> on <?php echo $result_content[''dyn_content_date'']; ?></i></p>\r\n <?php \r\n } // end while\r\n?>\r\n', 'all', 'template_php', 1, 50, 0, '2005-07-30', '11:50:18'),
+(26, 0, 'reactos_version', '0.2.8', 'all', '', 1, 50, 1, '2005-08-13', '16:18:56'),
+(27, 15, 'template_sitemap', '<h1><a href="[#link_index]">Home</a> > Sitemap</h1>\r\n<?php\r\n if ( !defined("ROSCMS_SYSTEM") ) {\r\n define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking activity\r\n }\r\n\r\n include("db/connect_db.inc.php"); // database connection script\r\n\r\n\r\n $query_sitemap = mysql_query("SELECT * \r\n FROM pages\r\n WHERE page_active = ''1'' AND page_visible = ''1'' AND (page_language = ''all'' OR page_language = ''en'')\r\n ORDER BY ''page_name'' ASC") ;\r\n \r\n while($result_sitemap = mysql_fetch_array($query_sitemap)) { // content\r\n if ($result_sitemap[''page_description''] != "") {\r\n?>\r\n\r\n<p><b><a href="<?php echo "[#link_".$result_sitemap[''page_name'']."]"; ?>"><?php echo ucfirst($result_sitemap[''page_title'']); ?></a></b>\r\n<br><i><?php echo $result_sitemap[''page_description'']; ?></i></p>\r\n <?php\r\n } \r\n } // end while\r\n?>\r\n', 'all', 'template_php', 1, 50, 0, '2005-08-13', '20:58:04'),
+(34, 0, 'charset', 'utf-8', 'all', '', 1, 50, 1, '2005-08-27', '15:54:16'),
+(39, 15, 'path_homepage_media_screenshots', '[#roscms_path_homepage]media/screenshots/', 'all', '', 1, 50, 0, '2005-07-13', '18:00:35');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `languages`
+--
+
+DROP TABLE IF EXISTS `languages`;
+CREATE TABLE `languages` (
+ `lang_id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
+ `lang_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
+ `lang_level` int(11) NOT NULL default '0'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='available languages';
+
+--
+-- Data for table`languages`
+--
+
+INSERT INTO `languages` (`lang_id`, `lang_name`, `lang_level`)
+VALUES ('en', 'English', 10),
+('de', 'German', 8);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `pages`
+--
+
+DROP TABLE IF EXISTS `pages`;
+CREATE TABLE `pages` (
+ `page_id` bigint(20) NOT NULL auto_increment,
+ `page_name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
+ `page_language` varchar(50) collate utf8_unicode_ci NOT NULL default '',
+ `pages_extra` varchar(20) collate utf8_unicode_ci NOT NULL default '',
+ `pages_extention` varchar(10) collate utf8_unicode_ci NOT NULL default 'default',
+ `page_text` text collate utf8_unicode_ci NOT NULL,
+ `page_version` int(11) NOT NULL default '0',
+ `page_active` tinyint(4) NOT NULL default '0',
+ `page_visible` tinyint(4) NOT NULL default '0',
+ `page_usrname_id` bigint(20) NOT NULL default '0',
+ `page_date` date NOT NULL default '0000-00-00',
+ `page_time` time NOT NULL default '00:00:00',
+ `page_generate_usrid` bigint(20) NOT NULL default '0',
+ `page_generate_timestamp` varchar(50) collate utf8_unicode_ci NOT NULL default '',
+ `page_title` varchar(150) collate utf8_unicode_ci NOT NULL default '',
+ `page_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ PRIMARY KEY (`page_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Pages';
+
+--
+-- Data for table`pages`
+--
+
+INSERT INTO `pages` (`page_id`, `page_name`, `page_language`, `pages_extra`, `pages_extention`, `page_text`, `page_version`, `page_active`, `page_visible`, `page_usrname_id`, `page_date`, `page_time`, `page_generate_usrid`, `page_generate_timestamp`, `page_title`, `page_description`) VALUES (6, 'news_page', 'all', 'dynamic', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#inc_template_news_detail]\r\n\r\n[#cont_bottom]', 1, 1, 1, 1, '2005-09-12', '18:50:20', 1, '1135191757', 'News', ''),
+(7, 'news', 'all', '', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#inc_template_news]\r\n\r\n[#cont_bottom]', 1, 1, 1, 1, '2005-09-12', '18:50:28', 1, '1135191757', 'News', 'News page: latest ReactOS news, rss news feed'),
+(9, 'index', 'all', '', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#cont_index]\r\n\r\n[#cont_sidebar_right]\r\n[#cont_bottom]', 1, 1, 1, 1, '2005-12-21', '19:21:43', 1, '1135191757', 'Frontpage', 'Frontpage'),
+(91, 'sitemap', 'all', '', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#inc_template_sitemap]\r\n\r\n[#cont_bottom]\r\n', 1, 1, 1, 1, '2005-12-21', '19:58:07', 1, '1135191757', 'Sitemap', 'Sitemap page');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `roscms_security_log`
+--
+
+DROP TABLE IF EXISTS `roscms_security_log`;
+CREATE TABLE `roscms_security_log` (
+ `roscms_sec_log_id` bigint(20) NOT NULL auto_increment,
+ `roscms_sec_log_section` varchar(100) collate utf8_unicode_ci NOT NULL default '',
+ `roscms_sec_log_priority` int(11) NOT NULL default '100',
+ `roscms_sec_log_reason` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ `roscms_sec_log_user` varchar(100) collate utf8_unicode_ci NOT NULL default 'roscms_system',
+ `roscms_sec_log_useraccount` varchar(100) collate utf8_unicode_ci NOT NULL default '',
+ `roscms_sec_log_userip` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ `roscms_sec_log_referrer` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ `roscms_sec_log_text` text collate utf8_unicode_ci NOT NULL,
+ `roscms_sec_log_date` date NOT NULL default '0000-00-00',
+ `roscms_sec_log_time` time NOT NULL default '00:00:00',
+ `roscms_sec_log_visible` int(11) NOT NULL default '1',
+ PRIMARY KEY (`roscms_sec_log_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS Security Log';
+
+--
+-- Data for table`roscms_security_log`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `subsys_mappings`
+--
+
+DROP TABLE IF EXISTS `subsys_mappings`;
+CREATE TABLE `subsys_mappings` (
+ `map_roscms_userid` bigint(20) NOT NULL default '0',
+ `map_subsys_name` varchar(10) character set utf8 NOT NULL default '',
+ `map_subsys_userid` int(7) NOT NULL default '0',
+ PRIMARY KEY (`map_roscms_userid`,`map_subsys_name`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `user_sessions`
+--
+
+DROP TABLE IF EXISTS `user_sessions`;
+CREATE TABLE `user_sessions` (
+ `usersession_id` varchar(32) character set utf8 NOT NULL default '' COMMENT 'Unique ID of this session',
+ `usersession_user_id` bigint(20) NOT NULL default '0' COMMENT 'User this session belongs to',
+ `usersession_expires` datetime default NULL COMMENT 'Expiry date/time (NULL if does not expire)',
+ `usersession_browseragent` varchar(255) character set utf8 NOT NULL default '' COMMENT 'HTTP_USER_AGENT when this session was created',
+ `usersession_ipaddress` varchar(15) character set utf8 NOT NULL default '' COMMENT 'IP address from which this session was created',
+ `usersession_created` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'session created (date/time) - all session will get deleted ... by date',
+ PRIMARY KEY (`usersession_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0 COMMENT='Sessions';
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `usergroup_members`
+--
+
+DROP TABLE IF EXISTS `usergroup_members`;
+CREATE TABLE `usergroup_members` (
+ `usergroupmember_userid` bigint(20) NOT NULL default '0',
+ `usergroupmember_usergroupid` varchar(10) collate utf8_unicode_ci NOT NULL default 'user'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- Data for table`usergroup_members`
+--
+
+INSERT INTO `usergroup_members` (`usergroupmember_userid`, `usergroupmember_usergroupid`)
+VALUES (1, 'ros_sadmin'),
+(1, 'developer'),
+(1, 'translator'),
+(1, 'moderator'),
+(1, 'user');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `usergroups`
+--
+
+DROP TABLE IF EXISTS `usergroups`;
+CREATE TABLE `usergroups` (
+ `usrgroup_name_id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
+ `usrgroup_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
+ `usrgroup_intern_id` varchar(25) collate utf8_unicode_ci NOT NULL default '',
+ `usrgroup_securitylevel` tinyint(4) NOT NULL default '0',
+ `usrgroup_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ PRIMARY KEY (`usrgroup_name_id`),
+ UNIQUE KEY `usrgroup_name` (`usrgroup_name`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
+--
+-- Data for table`usergroups`
+--
+
+INSERT INTO `usergroups` (`usrgroup_name_id`, `usrgroup_name`, `usrgroup_intern_id`, `usrgroup_securitylevel`, `usrgroup_description`) VALUES ('ros_admin', 'Administrator', 'roscms_usrgrp_admin', 70, 'Administrator-Group: manage the ReactOS homepage (content, database)'),
+('user', 'User', 'roscms_usrgrp_user', 0, 'Normal Visitors'),
+('developer', 'Developer', 'roscms_usrgrp_dev', 50, 'ReactOS Developer: persons with svn commit access'),
+('moderator', 'Moderator', 'roscms_usrgrp_team', 20, 'Homepage Moderators: for compatibility & package manager database, etc.'),
+('translator', 'Translator', 'roscms_usrgrp_trans', 10, 'Homepage Translators: translate the homepage content'),
+('ros_sadmin', 'Super-Administrator', 'roscms_usrgrp_sadmin', 100, 'Super-Administrator-Group: manage the ReactOS homepage (content, database, etc.); only persons who know what they are doing ...'),
+('mediateam', 'Media-Team', 'roscms_usrgrp_team', 20, 'Media-Team members: UI-Team, etc.'),
+('test', 'Test-User', 'roscms_usrgrp_team', 10, 'RosCMS tester group');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `users`
+--
+
+DROP TABLE IF EXISTS `users`;
+CREATE TABLE `users` (
+ `user_id` bigint(20) NOT NULL auto_increment,
+ `user_name` varchar(20) collate utf8_unicode_ci NOT NULL default '',
+ `user_roscms_password` varchar(32) collate utf8_unicode_ci NOT NULL default '',
+ `user_roscms_getpwd_id` varchar(50) collate utf8_unicode_ci NOT NULL default '',
+ `user_timestamp_touch` varchar(50) collate utf8_unicode_ci NOT NULL default '',
+ `user_timestamp_touch2` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+ `user_login_counter` bigint(20) NOT NULL default '0',
+ `user_account_enabled` varchar(10) collate utf8_unicode_ci NOT NULL default 'no',
+ `user_account_hidden` varchar(5) collate utf8_unicode_ci NOT NULL default 'no',
+ `user_register` timestamp NULL default NULL,
+ `user_fullname` varchar(100) collate utf8_unicode_ci NOT NULL default '',
+ `user_email` varchar(150) collate utf8_unicode_ci NOT NULL default '',
+ `user_website` varchar(150) collate utf8_unicode_ci NOT NULL default '',
+ `user_language` varchar(2) collate utf8_unicode_ci NOT NULL default '',
+ `user_country` varchar(2) collate utf8_unicode_ci NOT NULL default '',
+ `user_timezone` varchar(3) collate utf8_unicode_ci NOT NULL default '',
+ `user_occupation` varchar(50) collate utf8_unicode_ci NOT NULL default '',
+ `user_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+ `user_setting_multisession` varchar(5) collate utf8_unicode_ci NOT NULL default 'false',
+ `user_setting_browseragent` varchar(5) collate utf8_unicode_ci NOT NULL default 'true',
+ `user_setting_ipaddress` varchar(5) collate utf8_unicode_ci NOT NULL default 'true',
+ `user_setting_timeout` varchar(5) collate utf8_unicode_ci NOT NULL default 'true',
+ PRIMARY KEY (`user_id`),
+ UNIQUE KEY `user_name` (`user_name`),
+ UNIQUE KEY `user_email` (`user_email`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS User Table';
+
+--
+-- Data for table`users`
+--
+
+INSERT INTO `users` (`user_id`, `user_name`, `user_roscms_password`, `user_roscms_getpwd_id`, `user_timestamp_touch`, `user_timestamp_touch2`, `user_login_counter`, `user_account_enabled`, `user_account_hidden`, `user_register`, `user_fullname`, `user_email`, `user_website`, `user_language`, `user_country`, `user_timezone`, `user_occupation`, `user_description`, `user_setting_multisession`, `user_setting_browseragent`, `user_setting_ipaddress`, `user_setting_timeout`)
+VALUES (1, 'roscms_user', '', '', '', '2005-12-08 20:02:50', 1, 'yes', 'yes', '2005-08-20 20:18:06', 'ReactOS Content Management System Default User', 'ros-dev at reactos.org', 'http://www.reactos.org', 'en', '', '', '', 'RosCMS Default User', 'true', 'false', 'false', 'true');
More information about the Ros-diffs
mailing list