Kawai Wiki

Compare Revisions

Ignore whitespace Rev 4 → Rev 5

/trunk/src/main/webapp/WEB-INF/conf/test/appManager.properties
9,13 → 9,15
auto_reload = false
 
# MentaBean with H2 (embedded database)
mentabean.dialect = org.mentabean.jdbc.H2BeanSession
jdbc.driver = org.h2.Driver
jdbc.url = jdbc:h2:MentaTest
jdbc.user = sa
jdbc.pass =
#mentabean.dialect = org.mentabean.jdbc.H2BeanSession
#jdbc.driver = org.h2.Driver
#jdbc.url = jdbc:h2:MentaTest
#jdbc.user = sa
#jdbc.pass =
 
# Hibernate
hibernate.dialect = org.hibernate.dialect.H2Dialect
hibernate.show_sql = false
hibernate.c3p0.maxIdleTime = 5
# MentaBean with MySQL
mentabean.dialect = org.mentabean.jdbc.MySQLBeanSession
jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost/Kawai?autoReconnect=true
jdbc.user = kawai
jdbc.pass = 1kawai23
/trunk/src/main/webapp/WEB-INF/conf/qa/appManager.properties
11,13 → 11,7
# MentaBean with MySQL
mentabean.dialect = org.mentabean.jdbc.MySQLBeanSession
jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost/Menta?autoReconnect=true
jdbc.user = menta
jdbc.pass = menta
jdbc.url = jdbc:mysql://localhost/Kawai?autoReconnect=true
jdbc.user = kawai
jdbc.pass = 1kawai23
 
# Hibernate
hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.show_sql = false
hibernate.c3p0.maxIdleTime = 5
 
 
/trunk/src/main/webapp/WEB-INF/conf/default/appManager.properties
14,6 → 14,6
email.from_name = Menta Web App
 
# Initialization script for database
db.script = WEB-INF/db/menta.sql
db.script = WEB-INF/db/kawai.sql
 
 
/trunk/src/main/webapp/WEB-INF/conf/prod/appManager.properties
11,13 → 11,6
# MentaBean with MySQL
mentabean.dialect = org.mentabean.jdbc.MySQLBeanSession
jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost/Menta?autoReconnect=true
jdbc.user = menta
jdbc.pass = menta
 
# Hibernate
hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.show_sql = false
hibernate.c3p0.maxIdleTime = 5
 
 
jdbc.url = jdbc:mysql://localhost/Kawai?autoReconnect=true
jdbc.user = kawai
jdbc.pass = 1kawai23
/trunk/src/main/webapp/WEB-INF/conf/int/appManager.properties
11,13 → 11,6
# MentaBean with MySQL
mentabean.dialect = org.mentabean.jdbc.MySQLBeanSession
jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost/Menta?autoReconnect=true
jdbc.user = menta
jdbc.pass = menta
 
# Hibernate
hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.show_sql = false
hibernate.c3p0.maxIdleTime = 5
 
 
jdbc.url = jdbc:mysql://localhost/Kawai?autoReconnect=true
jdbc.user = kawai
jdbc.pass = 1kawai23
/trunk/src/main/webapp/WEB-INF/conf/dev/appManager.properties
8,14 → 8,9
# Mentawai auto-reload with JRebel
auto_reload = true
 
# MentaBean with H2 (embedded database)
mentabean.dialect = org.mentabean.jdbc.H2BeanSession
jdbc.driver = org.h2.Driver
jdbc.url = jdbc:h2:Menta
jdbc.user = sa
jdbc.pass =
 
# Hibernate
hibernate.dialect = org.hibernate.dialect.H2Dialect
hibernate.show_sql = false
hibernate.c3p0.maxIdleTime = 5
# MentaBean with MySQL
mentabean.dialect = org.mentabean.jdbc.MySQLBeanSession
jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost/Kawai?autoReconnect=true
jdbc.user = kawai
jdbc.pass = 1kawai23
/trunk/src/main/webapp/WEB-INF/db/grant.sql
New file
0,0 → 1,0
grant all privileges on Kawai.* to 'kawai'@'localhost' identified by '1kawai23';
/trunk/src/main/webapp/WEB-INF/db/kawai.sql
New file
0,0 → 1,99
-- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: Kawai
-- ------------------------------------------------------
-- Server version 5.1.41-3ubuntu12.10
 
 
 
 
 
 
 
 
 
 
 
 
--
-- Current Database: `Kawai`
--
 
 
 
--
-- Table structure for table `groups`
--
 
DROP TABLE IF EXISTS `groups`;
 
 
CREATE TABLE `groups` (
`id` int(11) NOT NULL,
`locale` varchar(10) NOT NULL,
`value` varchar(50) NOT NULL,
PRIMARY KEY (`id`,`locale`)
);
 
 
--
-- Dumping data for table `groups`
--
 
 
INSERT INTO `groups` VALUES (1,'en_US','Guest'),(2,'en_US','Admin'),(3,'en_US','Editor'),(1,'pt_BR','Convidado'),(2,'pt_BR','Admin'),(3,'pt_BR','Editor');
 
 
--
-- Table structure for table `languages`
--
 
DROP TABLE IF EXISTS `languages`;
 
 
CREATE TABLE `languages` (
`id` int(11) NOT NULL,
`locale` varchar(10) NOT NULL DEFAULT '',
`value` varchar(100) NOT NULL,
PRIMARY KEY (`id`,`locale`)
);
 
 
--
-- Dumping data for table `languages`
--
 
 
INSERT INTO `languages` VALUES (1,'en_US','English'),(2,'en_US','Portuguese'),(1,'pt_BR','Inglês'),(2,'pt_BR','Português');
 
 
--
-- Table structure for table `users`
--
 
DROP TABLE IF EXISTS `users`;
 
 
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(100) DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`group_id` int(11) DEFAULT NULL,
`language_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_username` (`username`)
);
 
 
--
-- Dumping data for table `users`
--
 
 
INSERT INTO `users` VALUES (1,'soliveira','abc123','sergio.oliveira.jr@gmail.com',1,1),(2,'saoj','abc123','sergio.oliveira.jr@gmail.com',2,1),(3,'pelasaco','abc123','pela@pela.com.br',3,1);