quietlight/skraak.app - Change LD5U5NHLCULPSPQYYMHGHY3HJ3H5PPLZU4O4UALILXPLNAFVBMMQC

fix small consistency issues with schema.sql and schema.ts (drizzle)

Created by AEj8dahVWy718uSSFPe9VSRJ5qX5G8pC2zvFzJJ8yzBd on May 24, 2025

LD5U5NHLCULPSPQYYMHGHY3HJ3H5PPLZU4O4UALILXPLNAFVBMMQC

Dependencies

In channels

main

Change contents

Insertion in package.json at line 18 [4.254306]
[3.17198]
[4.254896]
```
    "nanoid": "^5.1.5",
```
Insertion in package-lock.json at line 23 [4.255732]
[3.17807]
[4.255972]
```
        "nanoid": "^5.1.5",
```

Replacement in package-lock.json at line 6112 [4.255732]

B:BD[4.397505] → [4.397505:397725]

      "version": "3.3.11",
      "resolved": "https://registry.npmjs.org/nanoid/-/nanoid-3.3.11.tgz",
      "integrity": "sha512-N8SpfPUnUp1bK+PMYW8qSWdl9U+wwNWI4QKxOYDy9JAro3WMX7p2OeVRF9v+347pnakNevPmiHhNmZ2HbFA76w==",

[4.397505]

[4.397744]

      "version": "5.1.5",
      "resolved": "https://registry.npmjs.org/nanoid/-/nanoid-5.1.5.tgz",
      "integrity": "sha512-Ir/+ZpE9fDsNH0hQ3C68uyThDXzYcim2EqcZ8zn8Chtt1iylPT9xXJB0kPCnqzgcEGikO9RxSrh63MsmVCU7Fw==",

Replacement in package-lock.json at line 6123 [4.255732]
B:BD[4.397909] → [4.397909:397944]
```
        "nanoid": "bin/nanoid.cjs"
```
[4.397909]
[4.397944]
```
        "nanoid": "bin/nanoid.js"
```
Replacement in package-lock.json at line 6126 [4.255732]
B:BD[4.397972] → [4.397972:398029]
```
        "node": "^10 || ^12 || ^13.7 || ^14 || >=15.0.1"
```
[4.397972]
[4.398029]
```
        "node": "^18 || >=20"
```

Insertion in package-lock.json at line 6409 [4.255732]

[3.43865]

[5.150660]

    "node_modules/postcss/node_modules/nanoid": {
      "version": "3.3.11",
      "resolved": "https://registry.npmjs.org/nanoid/-/nanoid-3.3.11.tgz",
      "integrity": "sha512-N8SpfPUnUp1bK+PMYW8qSWdl9U+wwNWI4QKxOYDy9JAro3WMX7p2OeVRF9v+347pnakNevPmiHhNmZ2HbFA76w==",
      "funding": [
        {
          "type": "github",
          "url": "https://github.com/sponsors/ai"
        }
      ],
      "license": "MIT",
      "bin": {
        "nanoid": "bin/nanoid.cjs"
      },
      "engines": {
        "node": "^10 || ^12 || ^13.7 || ^14 || >=15.0.1"
      }
    },

Replacement in db/schema.ts at line 10 [5.50781]

B:BD[5.51306] → [5.51306:51474]

import { pgEnum, pgTable, varchar, boolean, timestamp, decimal, integer, json, primaryKey, index, unique, foreignKey, uniqueIndex, bigint } from "drizzle-orm/pg-core";

[5.51306]

[5.51474]

import { pgEnum, pgTable, varchar, boolean, timestamp, date, decimal, integer, json, primaryKey, index, unique, foreignKey, uniqueIndex, bigint } from "drizzle-orm/pg-core";

Deletion in db/schema.ts at line 105 [5.50781]
B:BD[5.56580] → [5.56580:56650]
```
  storagePrefix: varchar("storage_prefix", { length: 34 }).notNull(),
```
Deletion in db/schema.ts at line 173 [5.50781]
B:BD[5.60291] → [5.60291:60361]
```
  storagePrefix: varchar("storage_prefix", { length: 34 }).notNull(),
```

Replacement in db/schema.ts at line 225 [5.50781]

B:BD[5.63037] → [5.63037:63119]

  validFrom: timestamp("valid_from").notNull(),
  validTo: timestamp("valid_to"),

[5.63037]

[6.3358]

  validFrom: date("valid_from").notNull(),
  validTo: date("valid_to"),

Replacement in db/schema.sql at line 382 [5.70506]

B:BD[5.88354] → [5.88354:88432]

    species_id VARCHAR(21) NOT NULL,  -- NB: should be 12 !!!!!!!!!!!!!!!!!!!

[5.88354]

[5.88432]

    species_id VARCHAR(12) NOT NULL,

Insertion in db/migrations.sql at line 728 [5.94401]

[2.483]


-- Fix species_dataset.species_id column length from VARCHAR(21) to VARCHAR(12)
-- Current data is already 12 characters, so this is safe
BEGIN;
ALTER TABLE species_dataset ALTER COLUMN species_id TYPE VARCHAR(12);
COMMIT;
SELECT NOW();
-- 2025-05-24 23:32:06.049277+00

fix small consistency issues with schema.sql and schema.ts (drizzle)

Dependencies

In channels

Change contents

Insertion in package.json at line 18 [4.254306]

Insertion in package-lock.json at line 23 [4.255732]

Replacement in package-lock.json at line 6112 [4.255732]

Replacement in package-lock.json at line 6123 [4.255732]

Replacement in package-lock.json at line 6126 [4.255732]

Insertion in package-lock.json at line 6409 [4.255732]

Replacement in db/schema.ts at line 10 [5.50781]

Deletion in db/schema.ts at line 105 [5.50781]

Deletion in db/schema.ts at line 173 [5.50781]

Replacement in db/schema.ts at line 225 [5.50781]

Replacement in db/schema.sql at line 382 [5.70506]

Insertion in db/migrations.sql at line 728 [5.94401]