Code Review
/
portal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
review
|
tree
raw
|
inline
| side by side
Merge "LanguageController tests up"
[portal.git]
/
ecomp-portal-DB-common
/
PortalDDLMySql_2_1_Common.sql
diff --git
a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
index
2cf5b75
..
f80fb9a
100644
(file)
--- a/
ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
+++ b/
ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@
-13,6
+13,12
@@
set foreign_key_checks=1;
create database portal;
create database portal;
+SET GLOBAL character_set_client = utf8;
+SET GLOBAL character_set_connection = utf8;
+SET GLOBAL character_set_database = utf8;
+SET GLOBAL character_set_results = utf8;
+SET GLOBAL character_set_server = utf8;
+
use portal;
-- ------------------ create table section
use portal;
-- ------------------ create table section
@@
-309,7
+315,7
@@
create table fn_user (
silo_status character varying(10)
);
silo_status character varying(10)
);
-alter table fn_user add column language_id int(2)
not null
default 1;
+alter table fn_user add column language_id int(2) default 1;
create table fn_language(
language_id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
create table fn_language(
language_id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,