[cfinck] 36547: Update the RosCMS SQL Dump to make it possible to test the current RosCMS locally
Author: cfinck Date: Sat Sep 27 11:43:52 2008 New Revision: 36547
URL: http://svn.reactos.org/svn/reactos?rev=36547&view=rev Log: Update the RosCMS SQL Dump to make it possible to test the current RosCMS locally
Modified: trunk/web/reactos.org/resources/roscms/roscms.sql
Modified: trunk/web/reactos.org/resources/roscms/roscms.sql URL: http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/resources/roscms/ro... ============================================================================== --- trunk/web/reactos.org/resources/roscms/roscms.sql [iso-8859-1] (original) +++ trunk/web/reactos.org/resources/roscms/roscms.sql [iso-8859-1] Sat Sep 27 11:43:52 2008 @@ -1,26 +1,34 @@ +-- phpMyAdmin SQL Dump +-- version 2.11.8.1 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Generation Time: Sep 26, 2008 at 03:26 PM +-- Server version: 4.1.20 +-- PHP Version: 5.0.4 + +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; + +-- -- Database: `roscms` -- --- Date: 2007-08-13 11:12 --- MySQL-Version: 5.0.33 --- PHP-Version: 5.2.1 --- - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_` --- + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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"', + `data_name` varchar(100) collate utf8_unicode_ci NOT NULL default '' COMMENT 'together with page_type unique entries', + `data_type` varchar(10) collate utf8_unicode_ci NOT NULL default '' COMMENT '"page", "layout", "content", "script"', `data_acl` varchar(50) collate utf8_unicode_ci NOT NULL default 'default', PRIMARY KEY (`data_id`), KEY `data_name` (`data_name`,`data_type`), KEY `data_type` (`data_type`), KEY `data_acl` (`data_acl`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='all RosCMS v1 "pages", "content", "dyncontent" and "inctext"'; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='all RosCMS v1 "pages", "content", "dyncontent" and "inctext"';
INSERT INTO `data_` VALUES (1, 'index', 'page', 'defaultpage'); INSERT INTO `data_` VALUES (2, 'default', 'template', 'layout'); @@ -28,46 +36,45 @@ INSERT INTO `data_` VALUES (4, 'news', 'script', 'script'); INSERT INTO `data_` VALUES (5, 'news_page', 'content', 'default');
- --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_a` --- +-- -------------------------------------------------------- + +-- +-- Table structure for table `data_a` +--
CREATE TABLE `data_a` ( `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"', + `data_name` varchar(100) collate utf8_unicode_ci NOT NULL default '' COMMENT 'together with page_type unique entries', + `data_type` varchar(10) collate utf8_unicode_ci NOT NULL default '' COMMENT '"page", "layout", "content", "script"', `data_acl` varchar(50) collate utf8_unicode_ci NOT NULL default 'default', PRIMARY KEY (`data_id`), KEY `data_name` (`data_name`,`data_type`), KEY `data_type` (`data_type`), KEY `data_acl` (`data_acl`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='all RosCMS v1 "pages", "content", "dyncontent" and "inctext"'; - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_revision` --- +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='all RosCMS v1 "pages", "content", "dyncontent" and "inctext"'; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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, + `data_id` int(11) NOT NULL default '0', + `rev_version` int(11) NOT NULL default '0' COMMENT 'version number increase with every entry change', + `rev_language` varchar(10) collate utf8_unicode_ci NOT NULL default '' COMMENT 'language code ("en", "de", etc.)', + `rev_usrid` int(11) NOT NULL default '0' COMMENT 'user id who saved the entry', + `rev_datetime` datetime NOT NULL default '0000-00-00 00:00:00', + `rev_date` date NOT NULL default '0000-00-00', + `rev_time` time NOT NULL default '00:00:00', PRIMARY KEY (`rev_id`), KEY `data_id` (`data_id`), KEY `rev_language` (`rev_language`), KEY `rev_version` (`rev_version`), KEY `rev_datetime` (`rev_datetime`), KEY `rev_usrid` (`rev_usrid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `data_revision` VALUES (1, 1, 1, 'en', 1, '2007-08-13 17:03:44', '2007-08-13', '17:03:44'); INSERT INTO `data_revision` VALUES (2, 2, 1, 'en', 1, '2007-08-13 17:05:03', '2007-08-13', '17:05:03'); @@ -76,41 +83,40 @@ INSERT INTO `data_revision` VALUES (7, 5, 1, 'en', 1, '2007-08-13 17:15:20', '2007-08-13', '17:15:20'); INSERT INTO `data_revision` VALUES (8, 5, 1, 'en', 1, '2007-08-13 17:15:45', '2007-08-13', '17:15:45');
- --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_revision_a` --- +-- -------------------------------------------------------- + +-- +-- Table structure for table `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, + `data_id` int(11) NOT NULL default '0', + `rev_version` int(11) NOT NULL default '0' COMMENT 'version number increase with every entry change', + `rev_language` varchar(10) collate utf8_unicode_ci NOT NULL default '' COMMENT 'language code ("en", "de", etc.)', + `rev_usrid` int(11) NOT NULL default '0' COMMENT 'user id who saved the entry', + `rev_datetime` datetime NOT NULL default '0000-00-00 00:00:00', + `rev_date` date NOT NULL default '0000-00-00', + `rev_time` time NOT NULL default '00:00:00', PRIMARY KEY (`rev_id`), KEY `data_id` (`data_id`), KEY `rev_language` (`rev_language`), KEY `rev_version` (`rev_version`), KEY `rev_datetime` (`rev_datetime`), KEY `rev_usrid` (`rev_usrid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_security` --- +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `data_security` +--
CREATE TABLE `data_security` ( - `sec_name` varchar(50) collate utf8_unicode_ci NOT NULL, - `sec_fullname` varchar(100) collate utf8_unicode_ci NOT NULL, - `sec_description` varchar(255) collate utf8_unicode_ci NOT NULL, - `sec_branch` varchar(10) collate utf8_unicode_ci NOT NULL, + `sec_name` varchar(50) collate utf8_unicode_ci NOT NULL default '', + `sec_fullname` varchar(100) collate utf8_unicode_ci NOT NULL default '', + `sec_description` varchar(255) collate utf8_unicode_ci NOT NULL default '', + `sec_branch` varchar(10) collate utf8_unicode_ci NOT NULL default '', `sec_lev1_read` tinyint(4) NOT NULL default '0', `sec_lev1_write` tinyint(4) NOT NULL default '0', `sec_lev1_add` tinyint(4) NOT NULL default '0', @@ -126,8 +132,8 @@ `sec_lev3_add` tinyint(4) NOT NULL default '0', `sec_lev3_pub` tinyint(4) NOT NULL default '0', `sec_lev3_trans` tinyint(4) NOT NULL default '0', - `sec_allow` varchar(255) collate utf8_unicode_ci NOT NULL, - `sec_deny` varchar(255) collate utf8_unicode_ci NOT NULL, + `sec_allow` varchar(255) collate utf8_unicode_ci NOT NULL default '', + `sec_deny` varchar(255) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`sec_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS content security';
@@ -143,22 +149,21 @@ INSERT INTO `data_security` VALUES ('readonly', 'Read-Only', 'Read only, noone can alter this', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, '', ''); INSERT INTO `data_security` VALUES ('langmaint', 'Language Maintainer', 'Language-Group related content', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '|transmaint|', '');
- --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_stext` --- +-- -------------------------------------------------------- + +-- +-- Table structure for table `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, + `data_rev_id` int(11) NOT NULL default '0', + `stext_name` varchar(100) collate utf8_unicode_ci NOT NULL default '', + `stext_content` varchar(255) collate utf8_unicode_ci NOT NULL default '', 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; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `data_stext` VALUES (14, 1, 'description', 'test page'); INSERT INTO `data_stext` VALUES (13, 1, 'comment', ''); @@ -171,43 +176,42 @@ INSERT INTO `data_stext` VALUES (26, 8, 'description', 'news issue 2'); INSERT INTO `data_stext` VALUES (27, 8, 'title', 'News_page');
- --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_stext_a` --- +-- -------------------------------------------------------- + +-- +-- Table structure for table `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, + `data_rev_id` int(11) NOT NULL default '0', + `stext_name` varchar(100) collate utf8_unicode_ci NOT NULL default '', + `stext_content` varchar(255) collate utf8_unicode_ci NOT NULL default '', 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_tag` --- +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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, + `data_id` int(11) NOT NULL default '0', + `data_rev_id` int(11) NOT NULL default '0', + `tag_name_id` int(11) NOT NULL default '0', + `tag_value_id` int(11) NOT NULL default '0', + `tag_usrid` int(11) NOT NULL default '0', 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; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `data_tag` VALUES (11, 1, 1, 1, 5, -1); INSERT INTO `data_tag` VALUES (2, 1, 1, 2, 2, -1); @@ -220,39 +224,38 @@ INSERT INTO `data_tag` VALUES (21, 5, 8, 1, 5, -1); INSERT INTO `data_tag` VALUES (20, 5, 8, 6, 10, -1);
- --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_tag_a` --- +-- -------------------------------------------------------- + +-- +-- Table structure for table `data_tag_a` +--
CREATE TABLE `data_tag_a` ( `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, + `data_id` int(11) NOT NULL default '0', + `data_rev_id` int(11) NOT NULL default '0', + `tag_name_id` int(11) NOT NULL default '0', + `tag_value_id` int(11) NOT NULL default '0', + `tag_usrid` int(11) NOT NULL default '0', 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` --- +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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, + `tn_name` varchar(100) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`tn_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `data_tag_name` VALUES (1, 'status'); INSERT INTO `data_tag_name` VALUES (2, 'extension'); @@ -260,30 +263,29 @@ INSERT INTO `data_tag_name` VALUES (5, 'kind'); INSERT INTO `data_tag_name` VALUES (6, 'number');
- --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_tag_name_a` --- +-- -------------------------------------------------------- + +-- +-- Table structure for table `data_tag_name_a` +--
CREATE TABLE `data_tag_name_a` ( `tn_id` int(11) NOT NULL auto_increment, - `tn_name` varchar(100) collate utf8_unicode_ci NOT NULL, + `tn_name` varchar(100) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`tn_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_tag_value` --- +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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, + `tv_value` varchar(255) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`tv_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `data_tag_value` VALUES (7, 'php'); INSERT INTO `data_tag_value` VALUES (2, 'html'); @@ -292,34 +294,33 @@ INSERT INTO `data_tag_value` VALUES (9, '1'); INSERT INTO `data_tag_value` VALUES (10, '2');
- --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_tag_value_a` --- +-- -------------------------------------------------------- + +-- +-- Table structure for table `data_tag_value_a` +--
CREATE TABLE `data_tag_value_a` ( `tv_id` int(11) NOT NULL auto_increment, - `tv_value` varchar(255) collate utf8_unicode_ci NOT NULL, + `tv_value` varchar(255) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`tv_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_text` --- +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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, + `data_rev_id` int(11) NOT NULL default '0', + `text_name` varchar(100) collate utf8_unicode_ci NOT NULL default '', `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; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `data_text` VALUES (9, 1, 'content', '[#templ_default]'); INSERT INTO `data_text` VALUES (8, 2, 'content', '[#cont_head][#cont_menu_top][#cont_menu_side][#cont_contmenu_[#%NAME%]][#cont_menu_search][#cont_menu_language][#cont_menu_misc][#cont_%NAME%][#cont_bottom]'); @@ -329,66 +330,61 @@ INSERT INTO `data_text` VALUES (12, 5, 'content', '<h3>News</h3> <?php $tmp_year = "2085"; $query_content = mysql_query("SELECT d.data_name, r.rev_usrid, s1.stext_content AS ''title'', s2.stext_content AS ''description'', v.tv_value as ''numb'', r.rev_date FROM data_ d, data_revision r, data_stext s1, data_stext s2, data_tag a, data_tag_name n, data_tag_value v WHERE d.data_name = ''news_page'' AND d.data_type = ''content'' AND r.data_id = d.data_id AND (r.rev_language = ''".mysql_real_escape_string($roscms_template_var_lang)."'' OR r.rev_language = ''en'') AND r.rev_version > 0 AND s1.data_rev_id = r.rev_id AND s1.stext_name = ''title'' AND s2.data_rev_id = r.rev_id AND s2.stext_name = ''description'' AND r.data_id = a.data_id AND r.rev_id = a.data_rev_id AND a.tag_usrid = ''-1'' AND a.tag_name_id = n.tn_id AND n.tn_name = ''number'' AND a.tag_value_id = v.tv_id ORDER BY r.rev_datetime DESC LIMIT 3;"); while($result_content = mysql_fetch_array($query_content)) { if ($tmp_year > substr($result_content[''rev_date''], 0, 4)) { $tmp_year = substr($result_content[''rev_date''], 0, 4); echo "<h3>".$tmp_year."</h3>"; } $query_usraccount= mysql_query("SELECT user_name, user_fullname FROM users WHERE user_id = ''".mysql_real_escape_string($result_content["rev_usrid"])."'' LIMIT 1;"); $result_usraccount=mysql_fetch_array($query_usraccount); ?> <p align="left"><b><font color="#666666"><?php echo $result_content[''rev_date'']; ?>, <?php if ($result_usraccount[''user_fullname'']) { echo $result_usraccount[''user_fullname'']; } else { echo $result_usraccount[''user_name'']; } ?> </font></b><br /> <b><a href="<?php echo "[#link_".$result_content["data_name"]."_".$result_content["numb"]."]"; ?>"><?php echo $result_content["title"]; ?></a></b><br /> <?php echo $result_content["description"]; ?></p> <?php } // end while ?> ');
- --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `data_text_a` --- +-- -------------------------------------------------------- + +-- +-- Table structure for table `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, + `data_rev_id` int(11) NOT NULL default '0', + `text_name` varchar(100) collate utf8_unicode_ci NOT NULL default '', `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_user_filter` --- +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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_usrid` int(11) NOT NULL default '0', + `filt_title` varchar(50) collate utf8_unicode_ci NOT NULL default '', `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, + `filt_string` varchar(255) collate utf8_unicode_ci NOT NULL default '', + `filt_datetime` datetime NOT NULL default '0000-00-00 00:00:00', + `filt_usage` int(11) NOT NULL default '0', + `filt_usagedate` datetime NOT NULL default '0000-00-00 00:00:00', 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 `languages` --- +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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_name_org` varchar(100) collate utf8_unicode_ci NOT NULL, + `lang_name_org` varchar(100) collate utf8_unicode_ci NOT NULL default '', `lang_level` int(11) NOT NULL default '0', PRIMARY KEY (`lang_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='available languages';
-INSERT INTO `languages` VALUES ('en', 'English', 'English', 10); -INSERT INTO `languages` VALUES ('de', 'German', 'Deutsch', 8); - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `subsys_mappings` --- +-- -------------------------------------------------------- + +-- +-- Table structure for table `subsys_mappings` +--
CREATE TABLE `subsys_mappings` ( `map_roscms_userid` bigint(20) NOT NULL default '0', @@ -399,36 +395,9 @@
-- --------------------------------------------------------
--- --- 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', - `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'; - --- -------------------------------------------------------- - --- --- 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; - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `usergroups` --- +-- +-- Table structure for table `usergroups` +--
CREATE TABLE `usergroups` ( `usrgroup_name_id` varchar(10) collate utf8_unicode_ci NOT NULL default '', @@ -437,24 +406,39 @@ `usrgroup_seclev` tinyint(4) NOT NULL default '0', `usrgroup_securitylevel` tinyint(4) NOT NULL default '0', `usrgroup_description` varchar(255) collate utf8_unicode_ci NOT NULL default '', + `usrgroup_visible` char(1) collate utf8_unicode_ci NOT NULL default '1', PRIMARY KEY (`usrgroup_name_id`), - UNIQUE KEY `usrgroup_name` (`usrgroup_name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - -INSERT INTO `usergroups` VALUES ('ros_admin', 'Administrator', 'roscms_usrgrp_admin', 3, 70, 'Administrator-Group'); -INSERT INTO `usergroups` VALUES ('user', 'User', 'roscms_usrgrp_user', 0, 0, 'Normal Visitors'); -INSERT INTO `usergroups` VALUES ('developer', 'Developer', 'roscms_usrgrp_dev', 2, 50, 'Developer'); -INSERT INTO `usergroups` VALUES ('moderator', 'Moderator', 'roscms_usrgrp_team', 2, 20, 'Website Moderators'); -INSERT INTO `usergroups` VALUES ('translator', 'Translator', 'roscms_usrgrp_trans', 1, 10, 'Translators'); -INSERT INTO `usergroups` VALUES ('ros_sadmin', 'Super-Administrator', 'roscms_usrgrp_sadmin', 3, 100, 'Super-Administrator-Group'); -INSERT INTO `usergroups` VALUES ('transmaint', 'Tranlation Maintainer', 'roscms_usrgrp_trans', 2, 15, 'Translation Maintainer'); - - --- -------------------------------------------------------- - --- --- Tabellenstruktur für Tabelle `users` --- + UNIQUE KEY `usrgroup_name` (`usrgroup_name`), + KEY `usrgroup_visible` (`usrgroup_visible`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +INSERT INTO `usergroups` VALUES('ros_admin', 'Administrator', 'roscms_usrgrp_admin', 3, 70, 'Administrator-Group: manage the ReactOS homepage (content, database)', '0'); +INSERT INTO `usergroups` VALUES('user', 'User', 'roscms_usrgrp_user', 0, 0, 'Normal Visitors', '1'); +INSERT INTO `usergroups` VALUES('developer', 'Developer', 'roscms_usrgrp_dev', 2, 50, 'ReactOS Developer: persons with svn commit access', '1'); +INSERT INTO `usergroups` VALUES('moderator', 'Moderator', 'roscms_usrgrp_team', 2, 20, 'Homepage Moderators: for compatibility & package manager database, etc.', '1'); +INSERT INTO `usergroups` VALUES('translator', 'Translator', 'roscms_usrgrp_trans', 1, 10, 'Homepage Translators: translate the homepage content', '1'); +INSERT INTO `usergroups` VALUES('ros_sadmin', 'Super-Administrator', 'roscms_usrgrp_sadmin', 3, 100, 'Super-Administrator-Group: manage the ReactOS homepage (content, database, etc.); only persons who know what they are doing ...', '0'); +INSERT INTO `usergroups` VALUES('mediateam', 'Media-Team', 'roscms_usrgrp_team', 1, 20, 'Media-Team members: UI-Team, etc.', '0'); +INSERT INTO `usergroups` VALUES('test', 'Test-User', 'roscms_usrgrp_team', 1, 10, 'RosCMS tester group', '0'); +INSERT INTO `usergroups` VALUES('transmaint', 'Language Maintainer', 'roscms_usrgrp_trans', 2, 15, 'Language Maintainer', '1'); +INSERT INTO `usergroups` VALUES('newsletter', 'Newsletter Author', 'roscms_usrgrp_dev', 2, 50, 'ReactOS Newsletter Author', '1'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `users` +--
CREATE TABLE `users` ( `user_id` bigint(20) NOT NULL auto_increment, @@ -467,20 +451,376 @@ `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_register_activation` varchar(50) collate utf8_unicode_ci NOT NULL default '', `user_fullname` varchar(100) collate utf8_unicode_ci NOT NULL default '', `user_email` varchar(150) collate utf8_unicode_ci NOT NULL default '', + `user_email_activation` varchar(200) 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_language` varchar(5) 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_timezone` varchar(5) 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_multisession` varchar(5) collate utf8_unicode_ci NOT NULL default 'true', + `user_setting_browseragent` varchar(5) collate utf8_unicode_ci NOT NULL default 'false', + `user_setting_ipaddress` varchar(5) collate utf8_unicode_ci NOT NULL default 'false', `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'; - +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS User Table'; + +INSERT INTO `users` VALUES (1, 'roscms_user', '', '', '', CURRENT_TIMESTAMP, 1, 'no', 'no', NULL, '', '', '', '', '', '', '', '', '', '', 'false', 'false', 'false', 'true'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `user_countries` +-- + +CREATE TABLE `user_countries` ( + `coun_id` varchar(2) NOT NULL default '', + `coun_name` varchar(100) NOT NULL default '', + PRIMARY KEY (`coun_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `user_countries` VALUES('af', 'Afghanistan'); +INSERT INTO `user_countries` VALUES('ax', 'Aland Islands'); +INSERT INTO `user_countries` VALUES('al', 'Albania'); +INSERT INTO `user_countries` VALUES('dz', 'Algeria'); +INSERT INTO `user_countries` VALUES('as', 'American Samoa'); +INSERT INTO `user_countries` VALUES('ad', 'Andorra'); +INSERT INTO `user_countries` VALUES('ao', 'Angola'); +INSERT INTO `user_countries` VALUES('ai', 'Anguilla'); +INSERT INTO `user_countries` VALUES('aq', 'Antarctica'); +INSERT INTO `user_countries` VALUES('ag', 'Antigua and Barbuda'); +INSERT INTO `user_countries` VALUES('ar', 'Argentina'); +INSERT INTO `user_countries` VALUES('am', 'Armenia'); +INSERT INTO `user_countries` VALUES('aw', 'Aruba'); +INSERT INTO `user_countries` VALUES('au', 'Australia'); +INSERT INTO `user_countries` VALUES('at', 'Austria'); +INSERT INTO `user_countries` VALUES('az', 'Azerbaijan'); +INSERT INTO `user_countries` VALUES('bs', 'Bahamas'); +INSERT INTO `user_countries` VALUES('bh', 'Bahrain'); +INSERT INTO `user_countries` VALUES('bd', 'Bangladesh'); +INSERT INTO `user_countries` VALUES('bb', 'Barbados'); +INSERT INTO `user_countries` VALUES('by', 'Belarus'); +INSERT INTO `user_countries` VALUES('be', 'Belgium'); +INSERT INTO `user_countries` VALUES('bz', 'Belize'); +INSERT INTO `user_countries` VALUES('bj', 'Benin'); +INSERT INTO `user_countries` VALUES('bm', 'Bermuda'); +INSERT INTO `user_countries` VALUES('bt', 'Bhutan'); +INSERT INTO `user_countries` VALUES('bo', 'Bolivia'); +INSERT INTO `user_countries` VALUES('ba', 'Bosnia and Herzegovina'); +INSERT INTO `user_countries` VALUES('bw', 'Botswana'); +INSERT INTO `user_countries` VALUES('bv', 'Bouvet Island'); +INSERT INTO `user_countries` VALUES('br', 'Brazil'); +INSERT INTO `user_countries` VALUES('io', 'British Indian Ocean Territory'); +INSERT INTO `user_countries` VALUES('vg', 'British Virgin Islands'); +INSERT INTO `user_countries` VALUES('bn', 'Brunei'); +INSERT INTO `user_countries` VALUES('bg', 'Bulgaria'); +INSERT INTO `user_countries` VALUES('bf', 'Burkina Faso'); +INSERT INTO `user_countries` VALUES('bi', 'Burundi'); +INSERT INTO `user_countries` VALUES('kh', 'Cambodia'); +INSERT INTO `user_countries` VALUES('cm', 'Cameroon'); +INSERT INTO `user_countries` VALUES('ca', 'Canada'); +INSERT INTO `user_countries` VALUES('cv', 'Cape Verde'); +INSERT INTO `user_countries` VALUES('ky', 'Cayman Islands'); +INSERT INTO `user_countries` VALUES('cf', 'Central African Republic'); +INSERT INTO `user_countries` VALUES('td', 'Chad'); +INSERT INTO `user_countries` VALUES('cl', 'Chile'); +INSERT INTO `user_countries` VALUES('cn', 'China'); +INSERT INTO `user_countries` VALUES('cx', 'Christmas Island'); +INSERT INTO `user_countries` VALUES('cc', 'Cocos (Keeling) Islands'); +INSERT INTO `user_countries` VALUES('co', 'Colombia'); +INSERT INTO `user_countries` VALUES('km', 'Comoros'); +INSERT INTO `user_countries` VALUES('cg', 'Congo'); +INSERT INTO `user_countries` VALUES('ck', 'Cook Islands'); +INSERT INTO `user_countries` VALUES('cr', 'Costa Rica'); +INSERT INTO `user_countries` VALUES('hr', 'Croatia'); +INSERT INTO `user_countries` VALUES('cy', 'Cyprus'); +INSERT INTO `user_countries` VALUES('cz', 'Czech Republic'); +INSERT INTO `user_countries` VALUES('cd', 'Democratic Republic of Congo'); +INSERT INTO `user_countries` VALUES('dk', 'Denmark'); +INSERT INTO `user_countries` VALUES('xx', 'Disputed Territory'); +INSERT INTO `user_countries` VALUES('dj', 'Djibouti'); +INSERT INTO `user_countries` VALUES('dm', 'Dominica'); +INSERT INTO `user_countries` VALUES('do', 'Dominican Republic'); +INSERT INTO `user_countries` VALUES('tl', 'East Timor'); +INSERT INTO `user_countries` VALUES('ec', 'Ecuador'); +INSERT INTO `user_countries` VALUES('eg', 'Egypt'); +INSERT INTO `user_countries` VALUES('sv', 'El Salvador'); +INSERT INTO `user_countries` VALUES('gq', 'Equatorial Guinea'); +INSERT INTO `user_countries` VALUES('er', 'Eritrea'); +INSERT INTO `user_countries` VALUES('ee', 'Estonia'); +INSERT INTO `user_countries` VALUES('et', 'Ethiopia'); +INSERT INTO `user_countries` VALUES('fk', 'Falkland Islands'); +INSERT INTO `user_countries` VALUES('fo', 'Faroe Islands'); +INSERT INTO `user_countries` VALUES('fm', 'Federated States of Micronesia'); +INSERT INTO `user_countries` VALUES('fj', 'Fiji'); +INSERT INTO `user_countries` VALUES('fi', 'Finland'); +INSERT INTO `user_countries` VALUES('fr', 'France'); +INSERT INTO `user_countries` VALUES('gf', 'French Guyana'); +INSERT INTO `user_countries` VALUES('pf', 'French Polynesia'); +INSERT INTO `user_countries` VALUES('tf', 'French Southern Territories'); +INSERT INTO `user_countries` VALUES('ga', 'Gabon'); +INSERT INTO `user_countries` VALUES('gm', 'Gambia'); +INSERT INTO `user_countries` VALUES('ge', 'Georgia'); +INSERT INTO `user_countries` VALUES('de', 'Germany'); +INSERT INTO `user_countries` VALUES('gh', 'Ghana'); +INSERT INTO `user_countries` VALUES('gi', 'Gibraltar'); +INSERT INTO `user_countries` VALUES('gr', 'Greece'); +INSERT INTO `user_countries` VALUES('gl', 'Greenland'); +INSERT INTO `user_countries` VALUES('gd', 'Grenada'); +INSERT INTO `user_countries` VALUES('gp', 'Guadeloupe'); +INSERT INTO `user_countries` VALUES('gu', 'Guam'); +INSERT INTO `user_countries` VALUES('gt', 'Guatemala'); +INSERT INTO `user_countries` VALUES('gn', 'Guinea'); +INSERT INTO `user_countries` VALUES('gw', 'Guinea-Bissau'); +INSERT INTO `user_countries` VALUES('gy', 'Guyana'); +INSERT INTO `user_countries` VALUES('ht', 'Haiti'); +INSERT INTO `user_countries` VALUES('hm', 'Heard Island and Mcdonald Islands'); +INSERT INTO `user_countries` VALUES('hn', 'Honduras'); +INSERT INTO `user_countries` VALUES('hk', 'Hong Kong'); +INSERT INTO `user_countries` VALUES('hu', 'Hungary'); +INSERT INTO `user_countries` VALUES('is', 'Iceland'); +INSERT INTO `user_countries` VALUES('in', 'India'); +INSERT INTO `user_countries` VALUES('id', 'Indonesia'); +INSERT INTO `user_countries` VALUES('iq', 'Iraq'); +INSERT INTO `user_countries` VALUES('xe', 'Iraq-Saudi Arabia Neutral Zone'); +INSERT INTO `user_countries` VALUES('ie', 'Ireland'); +INSERT INTO `user_countries` VALUES('il', 'Israel'); +INSERT INTO `user_countries` VALUES('it', 'Italy'); +INSERT INTO `user_countries` VALUES('ci', 'Ivory Coast'); +INSERT INTO `user_countries` VALUES('jm', 'Jamaica'); +INSERT INTO `user_countries` VALUES('jp', 'Japan'); +INSERT INTO `user_countries` VALUES('jo', 'Jordan'); +INSERT INTO `user_countries` VALUES('kz', 'Kazakhstan'); +INSERT INTO `user_countries` VALUES('ke', 'Kenya'); +INSERT INTO `user_countries` VALUES('ki', 'Kiribati'); +INSERT INTO `user_countries` VALUES('kw', 'Kuwait'); +INSERT INTO `user_countries` VALUES('kg', 'Kyrgyzstan'); +INSERT INTO `user_countries` VALUES('la', 'Laos'); +INSERT INTO `user_countries` VALUES('lv', 'Latvia'); +INSERT INTO `user_countries` VALUES('lb', 'Lebanon'); +INSERT INTO `user_countries` VALUES('ls', 'Lesotho'); +INSERT INTO `user_countries` VALUES('lr', 'Liberia'); +INSERT INTO `user_countries` VALUES('ly', 'Libya'); +INSERT INTO `user_countries` VALUES('li', 'Liechtenstein'); +INSERT INTO `user_countries` VALUES('lt', 'Lithuania'); +INSERT INTO `user_countries` VALUES('lu', 'Luxembourg'); +INSERT INTO `user_countries` VALUES('mo', 'Macau'); +INSERT INTO `user_countries` VALUES('mk', 'Macedonia'); +INSERT INTO `user_countries` VALUES('mg', 'Madagascar'); +INSERT INTO `user_countries` VALUES('mw', 'Malawi'); +INSERT INTO `user_countries` VALUES('my', 'Malaysia'); +INSERT INTO `user_countries` VALUES('mv', 'Maldives'); +INSERT INTO `user_countries` VALUES('ml', 'Mali'); +INSERT INTO `user_countries` VALUES('mt', 'Malta'); +INSERT INTO `user_countries` VALUES('mh', 'Marshall Islands'); +INSERT INTO `user_countries` VALUES('mq', 'Martinique'); +INSERT INTO `user_countries` VALUES('mr', 'Mauritania'); +INSERT INTO `user_countries` VALUES('mu', 'Mauritius'); +INSERT INTO `user_countries` VALUES('yt', 'Mayotte'); +INSERT INTO `user_countries` VALUES('mx', 'Mexico'); +INSERT INTO `user_countries` VALUES('md', 'Moldova'); +INSERT INTO `user_countries` VALUES('mc', 'Monaco'); +INSERT INTO `user_countries` VALUES('mn', 'Mongolia'); +INSERT INTO `user_countries` VALUES('ms', 'Montserrat'); +INSERT INTO `user_countries` VALUES('ma', 'Morocco'); +INSERT INTO `user_countries` VALUES('mz', 'Mozambique'); +INSERT INTO `user_countries` VALUES('mm', 'Myanmar'); +INSERT INTO `user_countries` VALUES('na', 'Namibia'); +INSERT INTO `user_countries` VALUES('nr', 'Nauru'); +INSERT INTO `user_countries` VALUES('np', 'Nepal'); +INSERT INTO `user_countries` VALUES('nl', 'Netherlands'); +INSERT INTO `user_countries` VALUES('an', 'Netherlands Antilles'); +INSERT INTO `user_countries` VALUES('nc', 'New Caledonia'); +INSERT INTO `user_countries` VALUES('nz', 'New Zealand'); +INSERT INTO `user_countries` VALUES('ni', 'Nicaragua'); +INSERT INTO `user_countries` VALUES('ne', 'Niger'); +INSERT INTO `user_countries` VALUES('ng', 'Nigeria'); +INSERT INTO `user_countries` VALUES('nu', 'Niue'); +INSERT INTO `user_countries` VALUES('nf', 'Norfolk Island'); +INSERT INTO `user_countries` VALUES('kp', 'North Korea'); +INSERT INTO `user_countries` VALUES('mp', 'Northern Mariana Islands'); +INSERT INTO `user_countries` VALUES('no', 'Norway'); +INSERT INTO `user_countries` VALUES('om', 'Oman'); +INSERT INTO `user_countries` VALUES('pk', 'Pakistan'); +INSERT INTO `user_countries` VALUES('pw', 'Palau'); +INSERT INTO `user_countries` VALUES('ps', 'Palestinian Occupied Territories'); +INSERT INTO `user_countries` VALUES('pa', 'Panama'); +INSERT INTO `user_countries` VALUES('pg', 'Papua New Guinea'); +INSERT INTO `user_countries` VALUES('py', 'Paraguay'); +INSERT INTO `user_countries` VALUES('pe', 'Peru'); +INSERT INTO `user_countries` VALUES('ph', 'Philippines'); +INSERT INTO `user_countries` VALUES('pn', 'Pitcairn Islands'); +INSERT INTO `user_countries` VALUES('pl', 'Poland'); +INSERT INTO `user_countries` VALUES('pt', 'Portugal'); +INSERT INTO `user_countries` VALUES('pr', 'Puerto Rico'); +INSERT INTO `user_countries` VALUES('qa', 'Qatar'); +INSERT INTO `user_countries` VALUES('re', 'Reunion'); +INSERT INTO `user_countries` VALUES('ro', 'Romania'); +INSERT INTO `user_countries` VALUES('ru', 'Russia'); +INSERT INTO `user_countries` VALUES('rw', 'Rwanda'); +INSERT INTO `user_countries` VALUES('sh', 'Saint Helena and Dependencies'); +INSERT INTO `user_countries` VALUES('kn', 'Saint Kitts and Nevis'); +INSERT INTO `user_countries` VALUES('lc', 'Saint Lucia'); +INSERT INTO `user_countries` VALUES('pm', 'Saint Pierre and Miquelon'); +INSERT INTO `user_countries` VALUES('vc', 'Saint Vincent and the Grenadines'); +INSERT INTO `user_countries` VALUES('ws', 'Samoa'); +INSERT INTO `user_countries` VALUES('sm', 'San Marino'); +INSERT INTO `user_countries` VALUES('st', 'Sao Tome and Principe'); +INSERT INTO `user_countries` VALUES('sa', 'Saudi Arabia'); +INSERT INTO `user_countries` VALUES('sn', 'Senegal'); +INSERT INTO `user_countries` VALUES('cs', 'Serbia and Montenegro'); +INSERT INTO `user_countries` VALUES('sc', 'Seychelles'); +INSERT INTO `user_countries` VALUES('sl', 'Sierra Leone'); +INSERT INTO `user_countries` VALUES('sg', 'Singapore'); +INSERT INTO `user_countries` VALUES('sk', 'Slovakia'); +INSERT INTO `user_countries` VALUES('si', 'Slovenia'); +INSERT INTO `user_countries` VALUES('sb', 'Solomon Islands'); +INSERT INTO `user_countries` VALUES('so', 'Somalia'); +INSERT INTO `user_countries` VALUES('za', 'South Africa'); +INSERT INTO `user_countries` VALUES('gs', 'South Georgia and South Sandwich Islands'); +INSERT INTO `user_countries` VALUES('kr', 'South Korea'); +INSERT INTO `user_countries` VALUES('es', 'Spain'); +INSERT INTO `user_countries` VALUES('pi', 'Spratly Islands'); +INSERT INTO `user_countries` VALUES('lk', 'Sri Lanka'); +INSERT INTO `user_countries` VALUES('sr', 'Suriname'); +INSERT INTO `user_countries` VALUES('sj', 'Svalbard and Jan Mayen'); +INSERT INTO `user_countries` VALUES('sz', 'Swaziland'); +INSERT INTO `user_countries` VALUES('se', 'Sweden'); +INSERT INTO `user_countries` VALUES('ch', 'Switzerland'); +INSERT INTO `user_countries` VALUES('sy', 'Syria'); +INSERT INTO `user_countries` VALUES('tw', 'Taiwan'); +INSERT INTO `user_countries` VALUES('tj', 'Tajikistan'); +INSERT INTO `user_countries` VALUES('tz', 'Tanzania'); +INSERT INTO `user_countries` VALUES('th', 'Thailand'); +INSERT INTO `user_countries` VALUES('tg', 'Togo'); +INSERT INTO `user_countries` VALUES('tk', 'Tokelau'); +INSERT INTO `user_countries` VALUES('to', 'Tonga'); +INSERT INTO `user_countries` VALUES('tt', 'Trinidad and Tobago'); +INSERT INTO `user_countries` VALUES('tn', 'Tunisia'); +INSERT INTO `user_countries` VALUES('tr', 'Turkey'); +INSERT INTO `user_countries` VALUES('tm', 'Turkmenistan'); +INSERT INTO `user_countries` VALUES('tc', 'Turks And Caicos Islands'); +INSERT INTO `user_countries` VALUES('tv', 'Tuvalu'); +INSERT INTO `user_countries` VALUES('ug', 'Uganda'); +INSERT INTO `user_countries` VALUES('ua', 'Ukraine'); +INSERT INTO `user_countries` VALUES('ae', 'United Arab Emirates'); +INSERT INTO `user_countries` VALUES('uk', 'United Kingdom'); +INSERT INTO `user_countries` VALUES('xd', 'United Nations Neutral Zone'); +INSERT INTO `user_countries` VALUES('us', 'United States'); +INSERT INTO `user_countries` VALUES('um', 'United States Minor Outlying Islands'); +INSERT INTO `user_countries` VALUES('uy', 'Uruguay'); +INSERT INTO `user_countries` VALUES('vi', 'US Virgin Islands'); +INSERT INTO `user_countries` VALUES('uz', 'Uzbekistan'); +INSERT INTO `user_countries` VALUES('vu', 'Vanuatu'); +INSERT INTO `user_countries` VALUES('va', 'Vatican City'); +INSERT INTO `user_countries` VALUES('ve', 'Venezuela'); +INSERT INTO `user_countries` VALUES('vn', 'Vietnam'); +INSERT INTO `user_countries` VALUES('wf', 'Wallis and Futuna'); +INSERT INTO `user_countries` VALUES('eh', 'Western Sahara'); +INSERT INTO `user_countries` VALUES('ye', 'Yemen'); +INSERT INTO `user_countries` VALUES('zm', 'Zambia'); +INSERT INTO `user_countries` VALUES('zw', 'Zimbabwe'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `user_language` +-- + +CREATE TABLE `user_language` ( + `lang_id` varchar(5) NOT NULL default '', + `lang_name` varchar(100) NOT NULL default '', + PRIMARY KEY (`lang_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `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', + PRIMARY KEY (`usersession_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0 COMMENT='Sessions'; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `user_timezone` +-- + +CREATE TABLE `user_timezone` ( + `tz_code` varchar(10) NOT NULL default '', + `tz_name` varchar(50) NOT NULL default '', + `tz_value` double NOT NULL default '0', + `tz_value2` varchar(10) NOT NULL default '', + PRIMARY KEY (`tz_code`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO `user_timezone` VALUES('IDLW', 'International Date Line West', -12, '-1200'); +INSERT INTO `user_timezone` VALUES('NT', 'Samoa', -11, '-1100'); +INSERT INTO `user_timezone` VALUES('HAST', 'Hawaii-Aleutian', -10, '-1000'); +INSERT INTO `user_timezone` VALUES('AKST', 'Alaska', -9, '-0900'); +INSERT INTO `user_timezone` VALUES('PST', 'Pacific (America)', -8, '-0800'); +INSERT INTO `user_timezone` VALUES('MST', 'Mountain (America)', -7, '-0700'); +INSERT INTO `user_timezone` VALUES('CST', 'Central (America)', -6, '-0600'); +INSERT INTO `user_timezone` VALUES('EST', 'Eastern (America)', -5, '-0500'); +INSERT INTO `user_timezone` VALUES('AST', 'Atlantic (America)', -4, '-0400'); +INSERT INTO `user_timezone` VALUES('NST', 'Newfoundland', -3.5, '-0330'); +INSERT INTO `user_timezone` VALUES('GST', 'Greenland', -3, '-0300'); +INSERT INTO `user_timezone` VALUES('AT', 'Azores', -2, '-0200'); +INSERT INTO `user_timezone` VALUES('WAT', 'West Africa', -1, '-0100'); +INSERT INTO `user_timezone` VALUES('UTC', 'Universal Coordinated', 0, '+0000'); +INSERT INTO `user_timezone` VALUES('GMT', 'Greenwich Mean', 0, '+0000'); +INSERT INTO `user_timezone` VALUES('WET', 'Western European', 0, '+0000'); +INSERT INTO `user_timezone` VALUES('CET', 'Central European', 1, '+0100'); +INSERT INTO `user_timezone` VALUES('EET', 'Eastern European', 2, '+0200'); +INSERT INTO `user_timezone` VALUES('MSK', 'Moscow', 3, '+0300'); +INSERT INTO `user_timezone` VALUES('IRT', 'Iran', 3.5, '+0330'); +INSERT INTO `user_timezone` VALUES('ZP4', 'Russia, United Arab Emirates', 4, '+0400'); +INSERT INTO `user_timezone` VALUES('ZP5', 'Russia', 5, '+0500'); +INSERT INTO `user_timezone` VALUES('IST', 'Indian', 5.5, '+0530'); +INSERT INTO `user_timezone` VALUES('ZP6', 'Russia', 6, '+0600'); +INSERT INTO `user_timezone` VALUES('ICT', 'Indochina', 7, '+0700'); +INSERT INTO `user_timezone` VALUES('CCT', 'China', 8, '+0800'); +INSERT INTO `user_timezone` VALUES('JST', 'Japan, Korea', 9, '+0900'); +INSERT INTO `user_timezone` VALUES('ACST', 'Australian Central', 9.5, '+0930'); +INSERT INTO `user_timezone` VALUES('AEST', 'Australian Eastern', 10, '+1000'); +INSERT INTO `user_timezone` VALUES('MAGS', 'Magadan', 11, '+1100'); +INSERT INTO `user_timezone` VALUES('NZST', 'New Zealand', 12, '+1200'); +INSERT INTO `user_timezone` VALUES('IDLE', 'International Date Line East', 12, '+1200'); +INSERT INTO `user_timezone` VALUES('AWST', 'Western Australian', 8, '+0800'); +INSERT INTO `user_timezone` VALUES('BT', 'Eastern Africa', 3, '+0300'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `user_unsafenames` +-- + +CREATE TABLE `user_unsafenames` ( + `unsafe_name` varchar(20) NOT NULL default '', + `unsafe_part` char(1) NOT NULL default '1', + PRIMARY KEY (`unsafe_name`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `user_unsafepwds` +-- + +CREATE TABLE `user_unsafepwds` ( + `pwd_name` varchar(100) NOT NULL default '', + PRIMARY KEY (`pwd_name`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
cfinck＠svn.reactos.org