API tools faq
paste
NMatheisen

Untitled

NMatheisen
Sep 17th, 2024 (edited)
36
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 23.84 KB | None | 0 0
raw download clone embed print report
  1. > discordbot@1.0.0 dev
  2. > nodemon app.js
  3.  
  4. [nodemon] 3.1.4
  5. [nodemon] TO restart at any TIME, enter `rs`
  6. [nodemon] watching path(s): *.*
  7. [nodemon] watching extensions: js,mjs,cjs,json
  8. [nodemon] starting `node app.js index.js`
  9. Executing (DEFAULT): SELECT name FROM sqlite_master WHERE TYPE='table' AND name='AccountInformations';
  10. Executing (DEFAULT): SELECT 1+1 AS RESULT
  11. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  12. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  13. Connection has been established successfully.
  14. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  15. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  16. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  17. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  18. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  19. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations_backup` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  20. Executing (DEFAULT): INSERT INTO `AccountInformations_backup` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations`;
  21. Executing (DEFAULT): DROP TABLE `AccountInformations`;
  22. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  23. Executing (DEFAULT): INSERT INTO `AccountInformations` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations_backup`;
  24. Executing (DEFAULT): DROP TABLE `AccountInformations_backup`;
  25. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  26. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  27. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  28. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations_backup` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  29. Executing (DEFAULT): INSERT INTO `AccountInformations_backup` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations`;
  30. Executing (DEFAULT): DROP TABLE `AccountInformations`;
  31. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  32. Executing (DEFAULT): INSERT INTO `AccountInformations` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations_backup`;
  33. Executing (DEFAULT): DROP TABLE `AccountInformations_backup`;
  34. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  35. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  36. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  37. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations_backup` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  38. Executing (DEFAULT): INSERT INTO `AccountInformations_backup` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations`;
  39. Executing (DEFAULT): DROP TABLE `AccountInformations`;
  40. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  41. Executing (DEFAULT): INSERT INTO `AccountInformations` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations_backup`;
  42. Executing (DEFAULT): DROP TABLE `AccountInformations_backup`;
  43. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  44. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  45. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  46. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations_backup` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  47. Executing (DEFAULT): INSERT INTO `AccountInformations_backup` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations`;
  48. Executing (DEFAULT): DROP TABLE `AccountInformations`;
  49. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  50. Executing (DEFAULT): INSERT INTO `AccountInformations` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations_backup`;
  51. Executing (DEFAULT): DROP TABLE `AccountInformations_backup`;
  52. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  53. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  54. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  55. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations_backup` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  56. Executing (DEFAULT): INSERT INTO `AccountInformations_backup` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations`;
  57. Executing (DEFAULT): DROP TABLE `AccountInformations`;
  58. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  59. Executing (DEFAULT): INSERT INTO `AccountInformations` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations_backup`;
  60. Executing (DEFAULT): DROP TABLE `AccountInformations_backup`;
  61. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  62. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  63. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  64. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations_backup` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  65. Executing (DEFAULT): INSERT INTO `AccountInformations_backup` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations`;
  66. Executing (DEFAULT): DROP TABLE `AccountInformations`;
  67. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  68. Executing (DEFAULT): INSERT INTO `AccountInformations` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations_backup`;
  69. Executing (DEFAULT): DROP TABLE `AccountInformations_backup`;
  70. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  71. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  72. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  73. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations_backup` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  74. Executing (DEFAULT): INSERT INTO `AccountInformations_backup` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations`;
  75. Executing (DEFAULT): DROP TABLE `AccountInformations`;
  76. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  77. Executing (DEFAULT): INSERT INTO `AccountInformations` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations_backup`;
  78. Executing (DEFAULT): DROP TABLE `AccountInformations_backup`;
  79. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  80. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  81. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  82. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations_backup` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  83. Executing (DEFAULT): INSERT INTO `AccountInformations_backup` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations`;
  84. Executing (DEFAULT): DROP TABLE `AccountInformations`;
  85. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  86. Executing (DEFAULT): INSERT INTO `AccountInformations` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations_backup`;
  87. Executing (DEFAULT): DROP TABLE `AccountInformations_backup`;
  88. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  89. Executing (DEFAULT): SELECT name FROM sqlite_master WHERE TYPE='table' AND name='Transactions';
  90. Executing (DEFAULT): PRAGMA TABLE_INFO(`Transactions`);
  91. Executing (DEFAULT): PRAGMA foreign_key_list(`Transactions`)
  92. Executing (DEFAULT): PRAGMA INDEX_LIST(`Transactions`)
  93. Executing (DEFAULT): PRAGMA foreign_key_list(`Transactions`)
  94. Executing (DEFAULT): PRAGMA TABLE_INFO(`Transactions`);
  95. Executing (DEFAULT): PRAGMA INDEX_LIST(`Transactions`)
  96. Executing (DEFAULT): PRAGMA foreign_key_list(`Transactions`)
  97. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions_backup` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE, `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  98. Executing (DEFAULT): INSERT INTO `Transactions_backup` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions`;
  99. Executing (DEFAULT): DROP TABLE `Transactions`;
  100. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE, `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  101. Executing (DEFAULT): INSERT INTO `Transactions` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions_backup`;
  102. Executing (DEFAULT): DROP TABLE `Transactions_backup`;
  103. Executing (DEFAULT): PRAGMA TABLE_INFO(`Transactions`);
  104. Executing (DEFAULT): PRAGMA INDEX_LIST(`Transactions`)
  105. Executing (DEFAULT): PRAGMA foreign_key_list(`Transactions`)
  106. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions_backup` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  107. Executing (DEFAULT): INSERT INTO `Transactions_backup` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions`;
  108. Executing (DEFAULT): DROP TABLE `Transactions`;
  109. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  110. Executing (DEFAULT): INSERT INTO `Transactions` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions_backup`;
  111. Executing (DEFAULT): DROP TABLE `Transactions_backup`;
  112. Executing (DEFAULT): PRAGMA TABLE_INFO(`Transactions`);
  113. Executing (DEFAULT): PRAGMA INDEX_LIST(`Transactions`)
  114. Executing (DEFAULT): PRAGMA foreign_key_list(`Transactions`)
  115. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions_backup` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  116. Executing (DEFAULT): INSERT INTO `Transactions_backup` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions`;
  117. Executing (DEFAULT): DROP TABLE `Transactions`;
  118. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  119. Executing (DEFAULT): INSERT INTO `Transactions` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions_backup`;
  120. Executing (DEFAULT): DROP TABLE `Transactions_backup`;
  121. Executing (DEFAULT): PRAGMA TABLE_INFO(`Transactions`);
  122. Executing (DEFAULT): PRAGMA INDEX_LIST(`Transactions`)
  123. Executing (DEFAULT): PRAGMA foreign_key_list(`Transactions`)
  124. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions_backup` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  125. Ready! Logged IN AS Master Builder#8495
  126. Executing (DEFAULT): INSERT INTO `Transactions_backup` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions`;
  127. Executing (DEFAULT): DROP TABLE `Transactions`;
  128. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  129. Executing (DEFAULT): INSERT INTO `Transactions` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions_backup`;
  130. Executing (DEFAULT): DROP TABLE `Transactions_backup`;
  131. Executing (DEFAULT): PRAGMA TABLE_INFO(`Transactions`);
  132. Executing (DEFAULT): PRAGMA INDEX_LIST(`Transactions`)
  133. Executing (DEFAULT): PRAGMA foreign_key_list(`Transactions`)
  134. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions_backup` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  135. Executing (DEFAULT): INSERT INTO `Transactions_backup` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions`;
  136. Executing (DEFAULT): DROP TABLE `Transactions`;
  137. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  138. Executing (DEFAULT): INSERT INTO `Transactions` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions_backup`;
  139. Executing (DEFAULT): DROP TABLE `Transactions_backup`;
  140. Executing (DEFAULT): PRAGMA TABLE_INFO(`Transactions`);
  141. Executing (DEFAULT): PRAGMA INDEX_LIST(`Transactions`)
  142. Executing (DEFAULT): PRAGMA foreign_key_list(`Transactions`)
  143. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions_backup` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  144. Executing (DEFAULT): INSERT INTO `Transactions_backup` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions`;
  145. Executing (DEFAULT): DROP TABLE `Transactions`;
  146. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `Transactions` (`id` INTEGER PRIMARY KEY, `AccountInformationID` INTEGER NOT NULL REFERENCES `AccountInformations` (`ID`), `TransactionType` VARCHAR(255) NOT NULL, `TransactionValue` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  147. Executing (DEFAULT): INSERT INTO `Transactions` SELECT `id`, `AccountInformationID`, `TransactionType`, `TransactionValue`, `Timestamp`, `createdAt`, `updatedAt` FROM `Transactions_backup`;
  148. Executing (DEFAULT): DROP TABLE `Transactions_backup`;
  149. Executing (DEFAULT): PRAGMA INDEX_LIST(`Transactions`)
  150. DATABASE & TABLES created WITH associations!
  151.  
  152.  
  153.  
  154.  
  155. restart my bot
  156.  
  157. > discordbot@1.0.0 dev
  158. > nodemon app.js
  159.  
  160. [nodemon] 3.1.4
  161. [nodemon] TO restart at any TIME, enter `rs`
  162. [nodemon] watching path(s): *.*
  163. [nodemon] watching extensions: js,mjs,cjs,json
  164. [nodemon] starting `node app.js index.js`
  165. Executing (DEFAULT): SELECT name FROM sqlite_master WHERE TYPE='table' AND name='AccountInformations';
  166. Executing (DEFAULT): SELECT 1+1 AS RESULT
  167. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  168. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  169. Connection has been established successfully.
  170. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  171. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  172. Executing (DEFAULT): PRAGMA TABLE_INFO(`AccountInformations`);
  173. Executing (DEFAULT): PRAGMA INDEX_LIST(`AccountInformations`)
  174. Executing (DEFAULT): PRAGMA foreign_key_list(`AccountInformations`)
  175. Executing (DEFAULT): CREATE TABLE IF NOT EXISTS `AccountInformations_backup` (`ID` INTEGER PRIMARY KEY, `DiscordID` VARCHAR(255) NOT NULL, `DiscordUsername` VARCHAR(255) NOT NULL, `DiscordServerID` VARCHAR(255) NOT NULL, `DiscordServerName` VARCHAR(255) NOT NULL, `Balance` INTEGER NOT NULL, `Timestamp` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
  176. Executing (DEFAULT): INSERT INTO `AccountInformations_backup` SELECT `ID`, `DiscordID`, `DiscordUsername`, `DiscordServerID`, `DiscordServerName`, `Balance`, `Timestamp`, `createdAt`, `updatedAt` FROM `AccountInformations`;
  177. Executing (DEFAULT): DROP TABLE `AccountInformations`;
  178. Error creating DATABASE & TABLES WITH associations: Error
  179.     at DATABASE.<anonymous> (/home/discordbot/node_modules/sequelize/lib/dialects/sqlite/query.js:185:27)
  180.     at /home/discordbot/node_modules/sequelize/lib/dialects/sqlite/query.js:183:50
  181.     at NEW Promise (<anonymous>)
  182.     at Query.run (/home/discordbot/node_modules/sequelize/lib/dialects/sqlite/query.js:183:12)
  183.     at /home/discordbot/node_modules/sequelize/lib/sequelize.js:315:28
  184.     at async SQLiteQueryInterface.changeColumn (/home/discordbot/node_modules/sequelize/lib/dialects/sqlite/query-interface.js:43:7)
  185.     at async AccountInformation.sync (/home/discordbot/node_modules/sequelize/lib/model.js:984:11)
  186.     at async Sequelize.sync (/home/discordbot/node_modules/sequelize/lib/sequelize.js:377:9) {
  187.   name: 'SequelizeForeignKeyConstraintError',
  188.   parent: [Error: SQLITE_CONSTRAINT: FOREIGN KEY CONSTRAINT failed] {
  189.     errno: 19,
  190.     code: 'SQLITE_CONSTRAINT',
  191.     SQL: 'DROP TABLE `AccountInformations`;'
  192.   },
  193.   original: [Error: SQLITE_CONSTRAINT: FOREIGN KEY CONSTRAINT failed] {
  194.     errno: 19,
  195.     code: 'SQLITE_CONSTRAINT',
  196.     SQL: 'DROP TABLE `AccountInformations`;'
  197.   },
  198.   SQL: 'DROP TABLE `AccountInformations`;',
  199.   parameters: {},
  200.   TABLE: undefined,
  201.   FIELDS: undefined,
  202.   VALUE: undefined,
  203.   INDEX: undefined,
  204.   reltype: undefined
  205. }
  206. Ready! Logged IN AS Master Builder#8495
  207.  
  208.  
  209.  
Advertisement
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!