Hei, dimana gerangan db_setup.sql Alfresco ?
db_setup.sql dapat diganti dengan script berikut :
Untuk MySQL
Untuk MySQL
create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
Untuk PostgreSQL
Untuk PostgreSQL
CREATE DATABASE alfresco
WITH OWNER = alfresco
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
CONNECTION LIMIT = -1;