[opencms-dev] Alpha1 - Database Character Set Issue
Cyrill Brunschwiler
cbrunsch at hsr.ch
Thu Sep 23 00:11:44 CEST 2004
Alex,
Test Result:
°°°°°°°°°°°°
POSITIVE, OpenCMS is able to run on MySQL Versions 4.1.x
Neccessary Improvements:
°°°°°°°°°°°°°°°°°°°°°°°°
There's no need to start the deamon with any special character set params.
But the mysql database init scripts should define the database, table and
field charsets and collations.
CREATE TABLE ....
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
->> See the attached opencms database dump.
Running Alpha1 on MySQL 4.1.x WORKAROUND:
°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°
1. Let the import wizard create the database and its tables. Stop
following the wizards instructions yet and leave your browser
window open.
2. Dump the whole database to a file eg. opencms.dump
# mysqldump -h 127.0.0.1 -u root -p opencms > opencms.dump
3. Replace the charset and collations eg. latin1, latin1_bin
# perl -p -i -e 's/latin1/utf8/' opencms.dump
# perl -p -i -e 's/latin1_bin/utf8_general_ci/' opencms.dump
4. Drop the existing opencms database and create a new one
# mysql -h 127.0.0.1 -u root -p
mysql> DROP DATABASE opencms;
mysql> CREATE DATABASE opencms;
mysql> ALTER DATABASE opencms CHARACTER SET utf8;
mysql> ALTER DATABASE opencms COLLATE utf8_general_ci;
mysql> quit
5. Reload the whole opencms database from the modified dump
# mysql -h 127.0.0.1 -u root -p opencms < opencms.dump
6. Go back to the left open browser window and proceed by following the
import wizard's instructions.
->> SAMPLE DUMP: Attached
Hope this helps,
Cyrill
> Cyrill,
>
> The honest truth is we actually have not tested with MySQL 4.1.x so
> far, only with 4.0.x. I guess they have improved UTF-8 support and now
> require the DB to actually be setup with UTF-8. UTF-8 support in MySQL
> 4.0.x is actually pretty weak, even though it works fine with OpenCms.
>
> If this is the only issue with 4.1.x I say we look pretty good ;-)
>
> Let me know if you find it works / doesn't work with MySQL 4.1.x in
> genreal.
>
> Best Regards,
> Alex.
>
> > Hi
> >
> > Btw, i didn't test any other OpenCms version since 5.0.1. I'm
> > impressed.
> > Great work guys!
> >
> > Issue:
> > °°°°°°
> > Run into charset conflict while importing the workplace:
> > SQL Exception: Illegal mix of collations (latin1_bin,IMPLICIT) and
> > (utf8_general_ci,COERCIBLE) for operation '='
> >
> > Environement:
> > °°°°°°°°°°°°°
> > - Debian Linux (testing), Kernel 2.6.x
> > - MySQL Server 4.1.3-beta-standard
> > - Tomcat 5.0.27
> > - JDK 1.4.2_05
> >
> > Solutions:
> > °°°°°°°°°°
> > - Start mysqld with:
> > --default-character-set=utf8 \
> > --default-collation=utf8_general_ci
> > (this works for me)
> >
> > or
> >
> > - alter database characterset:
> > ALTER DATABASE cms CHARACTER SET utf8;
> > ALTER DATABASE cms COLLATE utf8_general_ci;
> > (didn't work for me, needs more investigation)
> >
> > rgrds,
> > Cyrill
-------------- next part --------------
-- MySQL dump 9.11
--
-- Host: 127.0.0.1 Database: cms
-- ------------------------------------------------------
-- Server version 4.1.3-beta-standard
--
-- Table structure for table `CMS_BACKUP_CONTENTS`
--
CREATE TABLE CMS_BACKUP_CONTENTS (
BACKUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
CONTENT_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
FILE_CONTENT mediumblob NOT NULL,
PUBLISH_TAG int(11) default NULL,
VERSION_ID int(11) NOT NULL default '0',
PRIMARY KEY (BACKUP_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_BACKUP_CONTENTS`
--
--
-- Table structure for table `CMS_BACKUP_PROJECTRESOURCES`
--
CREATE TABLE CMS_BACKUP_PROJECTRESOURCES (
PUBLISH_TAG int(11) NOT NULL default '0',
PROJECT_ID int(11) NOT NULL default '0',
RESOURCE_PATH text NOT NULL,
PRIMARY KEY (PUBLISH_TAG,PROJECT_ID,RESOURCE_PATH(255))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_BACKUP_PROJECTRESOURCES`
--
--
-- Table structure for table `CMS_BACKUP_PROJECTS`
--
CREATE TABLE CMS_BACKUP_PROJECTS (
PROJECT_ID int(11) NOT NULL default '0',
PROJECT_NAME varchar(64) character set utf8 collate utf8_general_ci NOT NULL default '',
PROJECT_DESCRIPTION varchar(255) NOT NULL default '',
PROJECT_TYPE int(11) NOT NULL default '0',
USER_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
GROUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
MANAGERGROUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
TASK_ID int(11) NOT NULL default '0',
DATE_CREATED bigint(20) NOT NULL default '0',
PUBLISH_TAG int(11) NOT NULL default '0',
PROJECT_PUBLISHDATE datetime default NULL,
PROJECT_PUBLISHED_BY varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROJECT_PUBLISHED_BY_NAME varchar(167) default NULL,
USER_NAME varchar(167) default NULL,
GROUP_NAME varchar(64) character set utf8 collate utf8_general_ci default NULL,
MANAGERGROUP_NAME varchar(64) character set utf8 collate utf8_general_ci default NULL,
PRIMARY KEY (PUBLISH_TAG)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_BACKUP_PROJECTS`
--
--
-- Table structure for table `CMS_BACKUP_PROPERTIES`
--
CREATE TABLE CMS_BACKUP_PROPERTIES (
BACKUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTY_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTYDEF_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTY_MAPPING_ID varchar(36) NOT NULL default '',
PROPERTY_MAPPING_TYPE int(11) NOT NULL default '0',
PROPERTY_VALUE text NOT NULL,
PUBLISH_TAG int(11) default NULL,
VERSION_ID int(11) NOT NULL default '0',
PRIMARY KEY (PROPERTY_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_BACKUP_PROPERTIES`
--
--
-- Table structure for table `CMS_BACKUP_PROPERTYDEF`
--
CREATE TABLE CMS_BACKUP_PROPERTYDEF (
PROPERTYDEF_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTYDEF_NAME varchar(128) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTYDEF_MAPPING_TYPE int(11) NOT NULL default '0',
PRIMARY KEY (PROPERTYDEF_ID),
UNIQUE KEY PROPERTYDEF_NAME (PROPERTYDEF_NAME,PROPERTYDEF_MAPPING_TYPE)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_BACKUP_PROPERTYDEF`
--
--
-- Table structure for table `CMS_BACKUP_RESOURCES`
--
CREATE TABLE CMS_BACKUP_RESOURCES (
BACKUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_TYPE int(11) NOT NULL default '0',
RESOURCE_FLAGS int(11) NOT NULL default '0',
RESOURCE_STATE smallint(5) unsigned NOT NULL default '0',
RESOURCE_SIZE int(11) NOT NULL default '0',
SIBLING_COUNT int(11) NOT NULL default '0',
DATE_CREATED bigint(20) NOT NULL default '0',
DATE_LASTMODIFIED bigint(20) NOT NULL default '0',
USER_CREATED varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
USER_LASTMODIFIED varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROJECT_LASTMODIFIED smallint(5) unsigned NOT NULL default '0',
PUBLISH_TAG int(11) NOT NULL default '0',
VERSION_ID int(11) NOT NULL default '0',
USER_CREATED_NAME varchar(64) NOT NULL default '',
USER_LASTMODIFIED_NAME varchar(64) NOT NULL default '',
PRIMARY KEY (BACKUP_ID),
KEY RESOURCE_RESOURCEID (RESOURCE_ID),
KEY REESOURCE_TYPE (RESOURCE_TYPE)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_BACKUP_RESOURCES`
--
--
-- Table structure for table `CMS_BACKUP_STRUCTURE`
--
CREATE TABLE CMS_BACKUP_STRUCTURE (
BACKUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PUBLISH_TAG int(11) NOT NULL default '0',
VERSION_ID int(11) NOT NULL default '0',
STRUCTURE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_PATH text NOT NULL,
STRUCTURE_STATE smallint(5) unsigned NOT NULL default '0',
DATE_RELEASED bigint(20) NOT NULL default '0',
DATE_EXPIRED bigint(20) NOT NULL default '0',
PRIMARY KEY (BACKUP_ID),
KEY IDX1 (STRUCTURE_ID,RESOURCE_PATH(255)),
KEY IDX2 (RESOURCE_PATH(255),RESOURCE_ID),
KEY IDX4 (STRUCTURE_ID,RESOURCE_ID),
KEY IDX7 (STRUCTURE_STATE),
KEY IDX8 (PUBLISH_TAG)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_BACKUP_STRUCTURE`
--
--
-- Table structure for table `CMS_GROUPS`
--
CREATE TABLE CMS_GROUPS (
GROUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PARENT_GROUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
GROUP_NAME varchar(64) character set utf8 collate utf8_general_ci NOT NULL default '',
GROUP_DESCRIPTION varchar(255) NOT NULL default '',
GROUP_FLAGS int(11) NOT NULL default '0',
PRIMARY KEY (GROUP_ID),
UNIQUE KEY GROUP_NAME (GROUP_NAME),
KEY GROUP_PARENTID (PARENT_GROUP_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_GROUPS`
--
--
-- Table structure for table `CMS_GROUPUSERS`
--
CREATE TABLE CMS_GROUPUSERS (
GROUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
USER_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
GROUPUSER_FLAGS int(11) NOT NULL default '0',
KEY GROUP_ID (GROUP_ID),
KEY USER_ID (USER_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_GROUPUSERS`
--
--
-- Table structure for table `CMS_OFFLINE_ACCESSCONTROL`
--
CREATE TABLE CMS_OFFLINE_ACCESSCONTROL (
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PRINCIPAL_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
ACCESS_ALLOWED int(11) default NULL,
ACCESS_DENIED int(11) default NULL,
ACCESS_FLAGS int(11) default NULL,
PRIMARY KEY (RESOURCE_ID,PRINCIPAL_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_OFFLINE_ACCESSCONTROL`
--
--
-- Table structure for table `CMS_OFFLINE_CONTENTS`
--
CREATE TABLE CMS_OFFLINE_CONTENTS (
CONTENT_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
FILE_CONTENT mediumblob NOT NULL,
PRIMARY KEY (CONTENT_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_OFFLINE_CONTENTS`
--
--
-- Table structure for table `CMS_OFFLINE_PROPERTIES`
--
CREATE TABLE CMS_OFFLINE_PROPERTIES (
PROPERTY_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTYDEF_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTY_MAPPING_ID varchar(36) NOT NULL default '',
PROPERTY_MAPPING_TYPE int(11) NOT NULL default '0',
PROPERTY_VALUE text NOT NULL,
PRIMARY KEY (PROPERTY_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_OFFLINE_PROPERTIES`
--
--
-- Table structure for table `CMS_OFFLINE_PROPERTYDEF`
--
CREATE TABLE CMS_OFFLINE_PROPERTYDEF (
PROPERTYDEF_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTYDEF_NAME varchar(128) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTYDEF_MAPPING_TYPE int(11) NOT NULL default '0',
PRIMARY KEY (PROPERTYDEF_ID),
UNIQUE KEY PROPERTYDEF_NAME (PROPERTYDEF_NAME,PROPERTYDEF_MAPPING_TYPE)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_OFFLINE_PROPERTYDEF`
--
--
-- Table structure for table `CMS_OFFLINE_RESOURCES`
--
CREATE TABLE CMS_OFFLINE_RESOURCES (
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_TYPE int(11) NOT NULL default '0',
RESOURCE_FLAGS int(11) NOT NULL default '0',
RESOURCE_STATE smallint(5) unsigned NOT NULL default '0',
RESOURCE_SIZE int(11) NOT NULL default '0',
SIBLING_COUNT int(11) NOT NULL default '0',
DATE_CREATED bigint(20) NOT NULL default '0',
DATE_LASTMODIFIED bigint(20) NOT NULL default '0',
USER_CREATED varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
USER_LASTMODIFIED varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROJECT_LASTMODIFIED smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (RESOURCE_ID),
KEY RESOURCE_TYPE (RESOURCE_TYPE)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_OFFLINE_RESOURCES`
--
--
-- Table structure for table `CMS_OFFLINE_STRUCTURE`
--
CREATE TABLE CMS_OFFLINE_STRUCTURE (
STRUCTURE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_PATH text NOT NULL,
STRUCTURE_STATE smallint(5) unsigned NOT NULL default '0',
DATE_RELEASED bigint(20) NOT NULL default '0',
DATE_EXPIRED bigint(20) NOT NULL default '0',
PRIMARY KEY (STRUCTURE_ID),
KEY IDX1 (STRUCTURE_ID,RESOURCE_PATH(255)),
KEY IDX2 (RESOURCE_PATH(255),RESOURCE_ID),
KEY IDX4 (STRUCTURE_ID,RESOURCE_ID),
KEY IDX7 (STRUCTURE_STATE)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_OFFLINE_STRUCTURE`
--
--
-- Table structure for table `CMS_ONLINE_ACCESSCONTROL`
--
CREATE TABLE CMS_ONLINE_ACCESSCONTROL (
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PRINCIPAL_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
ACCESS_ALLOWED int(11) default NULL,
ACCESS_DENIED int(11) default NULL,
ACCESS_FLAGS int(11) default NULL,
PRIMARY KEY (RESOURCE_ID,PRINCIPAL_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_ONLINE_ACCESSCONTROL`
--
--
-- Table structure for table `CMS_ONLINE_CONTENTS`
--
CREATE TABLE CMS_ONLINE_CONTENTS (
CONTENT_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
FILE_CONTENT mediumblob NOT NULL,
PRIMARY KEY (CONTENT_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_ONLINE_CONTENTS`
--
--
-- Table structure for table `CMS_ONLINE_PROPERTIES`
--
CREATE TABLE CMS_ONLINE_PROPERTIES (
PROPERTY_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTYDEF_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTY_MAPPING_ID varchar(36) NOT NULL default '',
PROPERTY_MAPPING_TYPE int(11) NOT NULL default '0',
PROPERTY_VALUE text NOT NULL,
PRIMARY KEY (PROPERTY_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_ONLINE_PROPERTIES`
--
--
-- Table structure for table `CMS_ONLINE_PROPERTYDEF`
--
CREATE TABLE CMS_ONLINE_PROPERTYDEF (
PROPERTYDEF_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTYDEF_NAME varchar(128) character set utf8 collate utf8_general_ci NOT NULL default '',
PROPERTYDEF_MAPPING_TYPE int(11) NOT NULL default '0',
PRIMARY KEY (PROPERTYDEF_ID),
UNIQUE KEY PROPERTYDEF_NAME (PROPERTYDEF_NAME,PROPERTYDEF_MAPPING_TYPE)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_ONLINE_PROPERTYDEF`
--
--
-- Table structure for table `CMS_ONLINE_RESOURCES`
--
CREATE TABLE CMS_ONLINE_RESOURCES (
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_TYPE int(11) NOT NULL default '0',
RESOURCE_FLAGS int(11) NOT NULL default '0',
RESOURCE_STATE smallint(5) unsigned NOT NULL default '0',
RESOURCE_SIZE int(11) NOT NULL default '0',
SIBLING_COUNT int(11) NOT NULL default '0',
DATE_CREATED bigint(20) NOT NULL default '0',
DATE_LASTMODIFIED bigint(20) NOT NULL default '0',
USER_CREATED varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
USER_LASTMODIFIED varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PROJECT_LASTMODIFIED smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (RESOURCE_ID),
KEY RESOURCE_TYPE (RESOURCE_TYPE)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_ONLINE_RESOURCES`
--
--
-- Table structure for table `CMS_ONLINE_STRUCTURE`
--
CREATE TABLE CMS_ONLINE_STRUCTURE (
STRUCTURE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_PATH text NOT NULL,
STRUCTURE_STATE smallint(5) unsigned NOT NULL default '0',
DATE_RELEASED bigint(20) NOT NULL default '0',
DATE_EXPIRED bigint(20) NOT NULL default '0',
PRIMARY KEY (STRUCTURE_ID),
KEY IDX1 (STRUCTURE_ID,RESOURCE_PATH(255)),
KEY IDX2 (RESOURCE_PATH(255),RESOURCE_ID),
KEY IDX4 (STRUCTURE_ID,RESOURCE_ID),
KEY IDX7 (STRUCTURE_STATE)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_ONLINE_STRUCTURE`
--
--
-- Table structure for table `CMS_PROJECTRESOURCES`
--
CREATE TABLE CMS_PROJECTRESOURCES (
PROJECT_ID int(11) NOT NULL default '0',
RESOURCE_PATH text NOT NULL,
PRIMARY KEY (PROJECT_ID,RESOURCE_PATH(255)),
KEY PROJECTRESOURCE_RESOURCEPATH (RESOURCE_PATH(255))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_PROJECTRESOURCES`
--
--
-- Table structure for table `CMS_PROJECTS`
--
CREATE TABLE CMS_PROJECTS (
PROJECT_ID int(11) NOT NULL default '0',
PROJECT_NAME varchar(64) character set utf8 collate utf8_general_ci NOT NULL default '',
PROJECT_DESCRIPTION varchar(255) NOT NULL default '',
PROJECT_FLAGS int(11) NOT NULL default '0',
PROJECT_TYPE int(11) NOT NULL default '0',
USER_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
GROUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
MANAGERGROUP_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
TASK_ID int(11) NOT NULL default '0',
DATE_CREATED bigint(20) NOT NULL default '0',
PRIMARY KEY (PROJECT_ID),
UNIQUE KEY PROJECT_NAME_2 (PROJECT_NAME,DATE_CREATED),
KEY PROJECT_NAME (PROJECT_NAME,DATE_CREATED),
KEY PROJECT_FLAGS (PROJECT_FLAGS),
KEY PROJECTS_GROUPID (GROUP_ID),
KEY PROJECTS_MANAGERID (MANAGERGROUP_ID),
KEY PROJECTS_USERID (USER_ID),
KEY PROJECTS_TASKID (TASK_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_PROJECTS`
--
--
-- Table structure for table `CMS_PUBLISH_HISTORY`
--
CREATE TABLE CMS_PUBLISH_HISTORY (
HISTORY_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
PUBLISH_TAG int(11) NOT NULL default '0',
STRUCTURE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
RESOURCE_PATH text NOT NULL,
RESOURCE_STATE int(11) NOT NULL default '0',
RESOURCE_TYPE int(11) NOT NULL default '0',
SIBLING_COUNT int(11) NOT NULL default '0',
PRIMARY KEY (HISTORY_ID,PUBLISH_TAG,STRUCTURE_ID,RESOURCE_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_PUBLISH_HISTORY`
--
--
-- Table structure for table `CMS_STATICEXPORT_LINKS`
--
CREATE TABLE CMS_STATICEXPORT_LINKS (
LINK_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
LINK_RFS_PATH text NOT NULL,
LINK_TYPE int(11) NOT NULL default '0',
LINK_PARAMETER text,
LINK_TIMESTAMP bigint(20) default NULL,
PRIMARY KEY (LINK_ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_STATICEXPORT_LINKS`
--
--
-- Table structure for table `CMS_SYSTEMID`
--
CREATE TABLE CMS_SYSTEMID (
TABLE_KEY varchar(255) NOT NULL default '',
ID int(11) NOT NULL default '0',
PRIMARY KEY (TABLE_KEY)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_SYSTEMID`
--
--
-- Table structure for table `CMS_TASK`
--
CREATE TABLE CMS_TASK (
AUTOFINISH int(11) default NULL,
ENDTIME datetime default NULL,
ESCALATIONTYPEREF int(11) default NULL,
ID int(11) NOT NULL default '0',
INITIATORUSERREF varchar(36) character set utf8 collate utf8_general_ci default NULL,
MILESTONEREF int(11) default NULL,
NAME varchar(254) default NULL,
ORIGINALUSERREF varchar(36) character set utf8 collate utf8_general_ci default NULL,
AGENTUSERREF varchar(36) character set utf8 collate utf8_general_ci default NULL,
PARENT int(11) default NULL,
PERCENTAGE varchar(50) default NULL,
PERMISSION varchar(50) default NULL,
PRIORITYREF int(11) default '2',
ROLEREF varchar(36) character set utf8 collate utf8_general_ci default NULL,
ROOT int(11) default NULL,
STARTTIME datetime default NULL,
STATE int(11) default NULL,
TASKTYPEREF int(11) default NULL,
TIMEOUT datetime default NULL,
WAKEUPTIME datetime default NULL,
HTMLLINK varchar(254) default NULL,
ESTIMATETIME int(11) default '86400',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_TASK`
--
--
-- Table structure for table `CMS_TASKLOG`
--
CREATE TABLE CMS_TASKLOG (
COMENT text,
EXTERNALUSERNAME varchar(254) default NULL,
ID int(11) NOT NULL default '0',
STARTTIME datetime default NULL,
TASKREF int(11) default NULL,
USERREF varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
`TYPE` int(18) default '0',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_TASKLOG`
--
--
-- Table structure for table `CMS_TASKPAR`
--
CREATE TABLE CMS_TASKPAR (
ID int(11) NOT NULL default '0',
PARNAME varchar(50) default NULL,
PARVALUE varchar(50) default NULL,
REF int(11) default NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_TASKPAR`
--
--
-- Table structure for table `CMS_TASKTYPE`
--
CREATE TABLE CMS_TASKTYPE (
AUTOFINISH int(11) default NULL,
ESCALATIONTYPEREF int(11) default NULL,
HTMLLINK varchar(254) default NULL,
ID int(11) NOT NULL default '0',
NAME varchar(50) default NULL,
PERMISSION varchar(50) default NULL,
PRIORITYREF int(11) default NULL,
ROLEREF varchar(36) character set utf8 collate utf8_general_ci default NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_TASKTYPE`
--
--
-- Table structure for table `CMS_USERS`
--
CREATE TABLE CMS_USERS (
USER_ID varchar(36) character set utf8 collate utf8_general_ci NOT NULL default '',
USER_NAME varchar(64) character set utf8 collate utf8_general_ci NOT NULL default '',
USER_PASSWORD varchar(32) character set utf8 collate utf8_general_ci NOT NULL default '',
USER_DESCRIPTION varchar(255) NOT NULL default '',
USER_FIRSTNAME varchar(50) NOT NULL default '',
USER_LASTNAME varchar(50) NOT NULL default '',
USER_EMAIL varchar(100) NOT NULL default '',
USER_LASTLOGIN bigint(20) NOT NULL default '0',
USER_FLAGS int(11) NOT NULL default '0',
USER_INFO blob,
USER_ADDRESS varchar(100) NOT NULL default '',
USER_TYPE int(11) NOT NULL default '0',
PRIMARY KEY (USER_ID),
UNIQUE KEY USER_NAME (USER_NAME)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CMS_USERS`
--
More information about the opencms-dev
mailing list