/*
 * jwma User Preferences Database
 * MySql >3.23.43 using InnoDB
 *
 * author: Thomas Christensen

--
-- $Id: data.sql,v 1.254 2007/08/28 07:46:40 hregis Exp $
-- $Source: /cvsroot/dolibarr/dolibarr/mysql/data/data.sql,v $
--
--

-- To load SAMPLE data of EstMiner to MySql 4.0 or above, run the follwing script.
-- Part 1/2
-- Contact: bioinfo@uga.edu

-----------------
add_table
mysql
mysql
host

----------
SELECT host, db, user     FROM mysql.db
union
SELECT host, db, _utf8'*' FROM mysql.host

----------
UPDATE mysql.db SET db.name='new'
----------
----------

-----------------
add_table
mysql
mysql
forum_administrator

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_create_shared_tables_mysql.sql,v 1.8 2007/10/25 00:33:52 tdanard Exp $
 */
select '/framework/core/shared/install/mysql/install_all_create_shared_tables_mysql.sql';

----------
----------
select * from mysql.user
----------
----------

add_column
system
mysql
help_relation
help_keyword_id

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_shared_mysql.sql,v 1.2 2006/04/22 23:04:05 tdanard Exp $
 */
select '/main-wiki/shared/install/mysql/install_all_shared_mysql.sql';

# $Horde: horde/scripts/db/mysql_drop.sql,v 1.1 2001/03/22 05:50:33 bjn Exp $
#
# You can simply direct this file to mysql as STDIN:

add_column
system
mysql
help_relation
help_keyword_id

-----------------
add_table
mysql
mysql
host

add_column
system
mysql
help_relation
help_keyword_id

-- MySQL dump 8.22
--
-- Host: localhost    Database: aistockbot

DROP DATABASE TEST;
DELETE FROM mysql.user WHERE User='' AND Host = '%';
DELETE FROM mysql.db WHERE User='' AND Host = '%';
DELETE FROM mysql.tables_priv WHERE User='' AND Host = '%';

USE mysql;
DELETE FROM user WHERE Host = 'asterisk1.local' and user = 'root';

add_column
system
mysql
help_relation
help_keyword_id

-----------------
add_table
mysql
mysql
host

------
select 1, User, Host
from mysql.user
where User='root'
group by Host

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_create_geography_tables_mysql.sql,v 1.2 2007/01/03 17:43:28 tdanard Exp $
 */
select '/framework/core/geography/install/mysql/install_all_create_geography_tables_mysql.sql';

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * Version: $Id: install_all_create_organization_tables_mysql.sql,v 1.3 2007/01/03 17:43:29 tdanard Exp $
 */
select '/framework/core/organization/install/mysql/install_all_create_organization_tables_mysql.sql';

add_column
system
mysql
help_relation
help_keyword_id

add_column
system
mysql
help_relation
help_keyword_id