azures04
87407fe604
Add bootstrap entrypoint and migrate DB schema setup to SQL files. Introduces bootstrap.js, many data/ddl/*.sql files, and a new runDDL() in modules/database.js (exports pool and runDDL). Remove legacy modules/databaseGlobals.js. Update repositories and code to use database.pool.query calls. Bump package version and set main to bootstrap.js. Clean up server.js to remove inline DB/cert init (now handled by bootstrap). Overall: refactor DB initialization to run ordered SQL DDL files and centralize startup logic.
5 lines
164 B
SQL
5 lines
164 B
SQL
CREATE TABLE IF NOT EXISTS blockedServers (
|
|
hashedIp VARCHAR(40) NOT NULL PRIMARY KEY,
|
|
banner VARCHAR(256) DEFAULT 'CONSOLE',
|
|
reason VARCHAR(512) NULL
|
|
) |