API tools faq
paste
Guest User

Untitled

a guest
May 19th, 2018
149
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.69 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
  3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4. xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">
  5.  
  6. <changeSet id="1" author="tobias">
  7. <createTable tableName="Entwickler">
  8. <column name="id" type="int" autoIncrement="true">
  9. <constraints primaryKey="true" nullable="false"/>
  10. </column>
  11. <column name="name" type="varchar(50)"/>
  12. <column name="webseite" type="varchar(50)"/>
  13. <column name="gruendungsdatum" type="BIGINT"/>
  14. </createTable>
  15.  
  16. <createTable tableName="Publisher">
  17. <column name="id" type="int" autoIncrement="true">
  18. <constraints primaryKey="true" nullable="false"/>
  19. </column>
  20. <column name="name" type="varchar(50)"/>
  21. <column name="webseite" type="varchar(50)"/>
  22. <column name="gruendungsdatum" type="BIGINT"/>
  23. </createTable>
  24.  
  25. <createTable tableName="Spiel">
  26. <column name="id" type="int" autoIncrement="true">
  27. <constraints primaryKey="true" nullable="false"/>
  28. </column>
  29. <column name="name" type="varchar(50)"/>
  30. <column name="publisher_id" type="int">
  31. <constraints nullable="false"
  32. foreignKeyName="fk_publisher"
  33. references="Publisher(id)"/>
  34. </column>
  35.  
  36. </createTable>
  37.  
  38. <createTable tableName="Bilder">
  39. <column name="id" type="int" autoIncrement="true">
  40. <constraints primaryKey="true" nullable="false"/>
  41. </column>
  42. <column name="name" type="varchar(50)"/>
  43. <column name="picture_kind" type="varchar(50)"/>
  44. <column name="game_id" type="int">
  45. <constraints nullable="false"
  46. foreignKeyName="fk_game"
  47. references="Spiel(id)"/>
  48. </column>
  49.  
  50. </createTable>
  51.  
  52. <createTable tableName="Spiel_Entwickler">
  53. <column name="id" type="int" autoIncrement="true">
  54. <constraints primaryKey="true" nullable="false"/>
  55. </column>
  56. <column name="entwickler_id" type="int">
  57. <constraints nullable="false"
  58. foreignKeyName="fk_Entwickler"
  59. references="Entwickler(id)"/>
  60. </column>
  61. <column name="game_id" type="int">
  62. <constraints nullable="false"
  63. foreignKeyName="fk_Game"
  64. references="Spiel(id)"/>
  65. </column>
  66.  
  67. </createTable>
  68.  
  69. <createTable tableName="Language">
  70. <column name="id" type="int" autoIncrement="true">
  71. <constraints primaryKey="true" nullable="false"/>
  72. </column>
  73. <column name="Language" type="varchar(50)"/>
  74.  
  75. </createTable>
  76.  
  77. <createTable tableName="plattform">
  78. <column name="id" type="int" autoIncrement="true">
  79. <constraints primaryKey="true" nullable="false"/>
  80. </column>
  81. <column name="plattform" type="varchar(50)"/>
  82.  
  83. </createTable>
  84.  
  85. <createTable tableName="Redaktion">
  86. <column name="id" type="int" autoIncrement="true">
  87. <constraints primaryKey="true" nullable="false"/>
  88. </column>
  89. <column name="Redaktion" type="varchar(50)"/>
  90.  
  91. </createTable>
  92.  
  93. <createTable tableName="Language_Spiel">
  94. <column name="id" type="int" autoIncrement="true">
  95. <constraints primaryKey="true" nullable="false"/>
  96. </column>
  97. <column name="name" type="varchar(50)"/>
  98. <column name="spiel_id" type="int">
  99. <constraints nullable="false"
  100. foreignKeyName="fk_spiel"
  101. references="Spiel(id)"/>
  102. </column>
  103. <column name="language_id" type="int">
  104. <constraints nullable="false"
  105. foreignKeyName="fk_language"
  106. references="Language(id)"/>
  107. </column>
  108. <column name="Youtube" type="varchar(50)"/>
  109. <column name="Beschreibung" type="varchar(50)"/>
  110. <column name="Altersfreigabe" type="int"/>
  111. </createTable>
  112.  
  113. <createTable tableName="spiel_plattform">
  114. <column name="id" type="int" autoIncrement="true">
  115. <constraints primaryKey="true" nullable="false"/>
  116. </column>
  117. <column name="name" type="varchar(50)"/>
  118. <column name="spiel_id" type="int">
  119. <constraints nullable="false"
  120. foreignKeyName="fk_spiel"
  121. references="Language_Spiel(id)"/>
  122. </column>
  123. <column name="plattform_id" type="int">
  124. <constraints nullable="false"
  125. foreignKeyName="fk_plattform"
  126. references="plattform(id)"/>
  127. </column>
  128. <column name="releasedate" type="bigint"/>
  129. <column name="releasedate_kind" type="varchar(50)"/>
  130. <column name="shop" type="varchar(50)"/>
  131. </createTable>
  132.  
  133. <createTable tableName="Rating">
  134. <column name="id" type="int" autoIncrement="true">
  135. <constraints primaryKey="true" nullable="false"/>
  136. </column>
  137. <column name="redaktion_id" type="int">
  138. <constraints nullable="false"
  139. foreignKeyName="fk_Rating"
  140. references="Redaktion(id)"/>
  141. </column>
  142. <column name="plattform_id" type="int">
  143. <constraints nullable="false"
  144. foreignKeyName="fk_plattform"
  145. references="spiel_plattform(id)"/>
  146. </column>
  147. <column name="rating" type="bigint"/>
  148.  
  149.  
  150. </createTable>
  151.  
  152. <createTable tableName="Genre">
  153. <column name="id" type="int" autoIncrement="true">
  154. <constraints primaryKey="true" nullable="false"/>
  155. </column>
  156. <column name="genre" type="bigint"/>
  157.  
  158.  
  159. </createTable>
  160.  
  161. <createTable tableName="Rating">
  162. <column name="id" type="int" autoIncrement="true">
  163. <constraints primaryKey="true" nullable="false"/>
  164. </column>
  165. <column name="game_id" type="int">
  166. <constraints nullable="false"
  167. foreignKeyName="fk_Game"
  168. references="Language_Spiel(id)"/>
  169. </column>
  170. <column name="genre_id" type="int">
  171. <constraints nullable="false"
  172. foreignKeyName="fk_genre"
  173. references="Genre(id)"/>
  174. </column>
  175. <column name="rating" type="bigint"/>
  176.  
  177.  
  178. </createTable>
  179. </changeSet>
  180.  
  181. </databaseChangeLog>
  182.  
  183. C:UsersTobiIdeaProjectsgames>mvn liquibase:update
  184. [INFO] Scanning for projects...
  185. [INFO]
  186. [INFO] ------------------------------------------------------------------------
  187. [INFO] Building games 1.0-SNAPSHOT
  188. [INFO] ------------------------------------------------------------------------
  189. [INFO]
  190. [INFO] --- liquibase-maven-plugin:3.4.2:update (default-cli) @ games ---
  191. [INFO] ------------------------------------------------------------------------
  192. [INFO] Parsing Liquibase Properties File
  193. [INFO] File: liquibase/liquibase.properties
  194. [INFO] ------------------------------------------------------------------------
  195. [INFO] Executing on Database: jdbc:mysql://localhost:3306/games
  196. INFO 19.05.18 14:44: liquibase: Successfully acquired change log lock
  197. WARNING 19.05.18 14:44: liquibase: SchemaLocation: schemaLocation-Wert = 'http://www.liquibase.org/xml/ns/dbchangelog http://www
  198. .liquibase.org/xml/ns/dbchangelog/dbchangelog-3.0.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquiba
  199. se.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext ' muss eine gerade Anzahl an URIs
  200. haben.
  201. INFO 19.05.18 14:44: liquibase: Successfully released change log lock
  202. [INFO] ------------------------------------------------------------------------
  203. [INFO] BUILD FAILURE
  204. [INFO] ------------------------------------------------------------------------
  205. [INFO] Total time: 1.568 s
  206. [INFO] Finished at: 2018-05-19T14:44:16+02:00
  207. [INFO] Final Memory: 13M/200M
  208. [INFO] ------------------------------------------------------------------------
  209. [ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.4.2:update (default-cli) on project games: Error setting u
  210. p or running Liquibase: liquibase.exception.SetupException: Error parsing line 7 column 52 of liquibase/changelogs/Gameinterface
  211. -changelog-1.xml: SchemaLocation: schemaLocation-Wert = 'http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xm
  212. l/ns/dbchangelog/dbchangelog-3.0.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbc
  213. hangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext ' muss eine gerade Anzahl an URIs haben. -> [Help 1
  214. ]
  215. [ERROR]
  216. [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
  217. [ERROR] Re-run Maven using the -X switch to enable full debug logging.
  218. [ERROR]
  219. [ERROR] For more information about the errors and possible solutions, please read the following articles:
  220. [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!