You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@archiva.apache.org by jo...@apache.org on 2007/05/22 17:53:44 UTC
svn commit: r540617 - in
/maven/archiva/trunk/archiva-web/archiva-webapp/src/sql: ./ mysql/
mysql/dev_bootstrap.sql mysql/drop_archiva_tables.sql
Author: joakime
Date: Tue May 22 08:53:43 2007
New Revision: 540617
URL: http://svn.apache.org/viewvc?view=rev&rev=540617
Log:
Adding some dev-time sql files for mysql.
Added:
maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/
maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/
maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql (with props)
maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql (with props)
Added: maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql
URL: http://svn.apache.org/viewvc/maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql?view=auto&rev=540617
==============================================================================
--- maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql (added)
+++ maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql Tue May 22 08:53:43 2007
@@ -0,0 +1,17 @@
+-- mysql mysql --user=root --password < dev_bootstrap.sql
+
+create database archiva;
+create database redback;
+
+use mysql;
+
+GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX
+ ON archiva.*
+ TO 'archiva'@'localhost'
+ IDENTIFIED BY 'sa';
+
+GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX
+ ON redback.*
+ TO 'archiva'@'localhost'
+ IDENTIFIED BY 'sa';
+
Propchange: maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/dev_bootstrap.sql
------------------------------------------------------------------------------
svn:keywords = "Author Date Id Revision"
Added: maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql
URL: http://svn.apache.org/viewvc/maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql?view=auto&rev=540617
==============================================================================
--- maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql (added)
+++ maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql Tue May 22 08:53:43 2007
@@ -0,0 +1,32 @@
+-- mysql archiva --user=archiva --password=sa < drop_archiva_tables.sql
+
+DROP TABLE IF EXISTS `ARCHIVAPROJECTMODEL_BUILDEXTENSIONS` ;
+DROP TABLE IF EXISTS `ARCHIVAPROJECTMODEL_DEPENDENCIES` ;
+DROP TABLE IF EXISTS `ARCHIVAPROJECTMODEL_DEPENDENCYMANAGEMENT` ;
+DROP TABLE IF EXISTS `ARCHIVAPROJECTMODEL_INDIVIDUALS` ;
+DROP TABLE IF EXISTS `ARCHIVAPROJECTMODEL_LICENSES` ;
+DROP TABLE IF EXISTS `ARCHIVAPROJECTMODEL_MAILINGLISTS` ;
+DROP TABLE IF EXISTS `ARCHIVAPROJECTMODEL_PLUGINS` ;
+DROP TABLE IF EXISTS `ARCHIVAPROJECTMODEL_REPORTS` ;
+DROP TABLE IF EXISTS `ARCHIVAPROJECTMODEL_REPOSITORIES` ;
+DROP TABLE IF EXISTS `ARCHIVA_ARTIFACT` ;
+DROP TABLE IF EXISTS `ARCHIVA_ARTIFACT_REFERENCE` ;
+DROP TABLE IF EXISTS `ARCHIVA_CIMANAGEMENT` ;
+DROP TABLE IF EXISTS `ARCHIVA_DEPENDENCY` ;
+DROP TABLE IF EXISTS `ARCHIVA_EXCLUSIONS` ;
+DROP TABLE IF EXISTS `ARCHIVA_INDIVIDUAL` ;
+DROP TABLE IF EXISTS `ARCHIVA_ISSUE_MANAGEMENT` ;
+DROP TABLE IF EXISTS `ARCHIVA_LICENSES` ;
+DROP TABLE IF EXISTS `ARCHIVA_MAILING_LISTS` ;
+DROP TABLE IF EXISTS `ARCHIVA_ORGANIZATION` ;
+DROP TABLE IF EXISTS `ARCHIVA_PROJECT` ;
+DROP TABLE IF EXISTS `ARCHIVA_PROJECT_REPOSITORIES` ;
+DROP TABLE IF EXISTS `ARCHIVA_REPOSITORIES` ;
+DROP TABLE IF EXISTS `ARCHIVA_REPOSITORY_STATS` ;
+DROP TABLE IF EXISTS `ARCHIVA_SCM` ;
+DROP TABLE IF EXISTS `ARCHIVA_VERSIONED_REFERENCE` ;
+DROP TABLE IF EXISTS `DEPENDENCY_EXCLUSIONS` ;
+DROP TABLE IF EXISTS `INDIVIDUAL_ROLES` ;
+DROP TABLE IF EXISTS `MAILINGLIST_OTHERARCHIVES` ;
+DROP TABLE IF EXISTS `SEQUENCE_TABLE` ;
+
Propchange: maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: maven/archiva/trunk/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql
------------------------------------------------------------------------------
svn:keywords = "Author Date Id Revision"