[ros-diffs] [frik85] 19284: RosCMS (Part 6)

RosCMS (Part 6)

Plain SQL file for RosCMS
Added: trunk/web/reactos.org/sql/
Added: trunk/web/reactos.org/sql/roscms.sql
  _____  

Added: trunk/web/reactos.org/sql/roscms.sql
--- trunk/web/reactos.org/sql/roscms.sql	2005-11-16 21:44:26 UTC
(rev 19283)
+++ trunk/web/reactos.org/sql/roscms.sql	2005-11-16 21:55:42 UTC
(rev 19284)
@@ -0,0 +1,249 @@

+--
+-- RosCMS - ReactOS Content Management System
+-- Copyright (C) 2005  Ge van Geldorp <gvg(a)reactos.org>
+-- 
+-- This program is free software; you can redistribute it and/or modify
+-- it under the terms of the GNU General Public License as published by
+-- the Free Software Foundation; either version 2 of the License, or
+-- (at your option) any later version.
+-- 
+-- This program is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+-- GNU General Public License for more details.
+-- 
+-- You should have received a copy of the GNU General Public License
+-- along with this program; if not, write to the Free Software
+-- Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
+-- 
+-- 
+-- Database: `roscms`
+-- 
+
+-- --------------------------------------------------------
+
+-- 
+-- `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_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' AUTO_INCREMENT=0;
+
+-- --------------------------------------------------------
+
+-- 
+-- `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' AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+-- 
+-- `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' AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+-- 
+-- `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';
+
+-- --------------------------------------------------------
+
+-- 
+-- `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
'',
+  `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' AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+-- 
+-- `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' AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+-- 
+-- `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;
+
+-- --------------------------------------------------------
+
+-- 
+-- `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',
+  PRIMARY KEY  (`usersession_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
PACK_KEYS=0 COMMENT='Sessions';
+
+-- --------------------------------------------------------
+
+-- 
+-- `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;
+
+-- --------------------------------------------------------
+
+-- 
+-- `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;
+
+-- --------------------------------------------------------
+
+-- 
+-- `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 'true',
+  `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`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
COMMENT='RosCMS User Table' AUTO_INCREMENT=0 ;
+
+
Property changes on: trunk/web/reactos.org/sql/roscms.sql
___________________________________________________________________
Name: svn:keywords
   + Author Date Id Revision
Name: svn:eol-style
   + native