ojengwa / openmeetings

Automatically exported from code.google.com/p/openmeetings
1 stars 0 forks source link

add mysql_skeleton and description to installation instructions #111

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
to make the app running on mysql:
- mysql_skelton needed
- some description in installation instructions

Original issue reported on code.google.com by seba.wag...@gmail.com on 20 Jun 2007 at 6:24

GoogleCodeExporter commented 9 years ago
I've added a mysql skeleton here:
 http://openmeetings-dev.googlegroups.com/web/mysql_skeleton.sql

I still don't have red5 running though, but I doubt that's because of the mysql
database I'm using.

You could do a diff against the postgres skeleleton to see the changes.

There are problems with mysql not allowing multiple columns to have a
CURRENT_TIMESTAMP/now() as default.
I've have chosen just one column on those occasions and used '000.... etc. as 
the
default for the rest,
hoping the java code will update the stamps by itself...

I've tried automatic conversion of the postgres dump but that lead to nothing, 
so
this one is edited by hand.

Maybe you could import the default postgres skeleton as mysql skeleton into 
your SCM,
then update it with this file, so
reviewing the changes will be easy and logged.

Original comment by rob.ha...@gmail.com on 25 Jun 2007 at 6:01

GoogleCodeExporter commented 9 years ago
don't worry its just a simple click to export the mysql_skeleton from my 
database
designer. The designer should be also taking care about different data-types et 
cetera.

Original comment by seba.wag...@gmail.com on 25 Jun 2007 at 6:03

GoogleCodeExporter commented 9 years ago
fixed since Beta3 where the skeleton is no longer necessary

Original comment by seba.wag...@gmail.com on 10 Jul 2007 at 4:40

GoogleCodeExporter commented 9 years ago

Original comment by seba.wag...@gmail.com on 29 Aug 2011 at 7:57