mirror of
https://github.com/clockworklabs/SpacetimeDB.git
synced 2026-05-12 18:57:51 -04:00
Tyler Cloutier
14 lines
580 B
Plaintext
14 lines
580 B
Plaintext
statement ok
|
|
CREATE TABLE inventory (inventory_id INTEGER, name TEXT);
|
|
INSERT INTO inventory (inventory_id, name) VALUES (1, 'health1');
|
|
INSERT INTO inventory (inventory_id, name) VALUES (2, 'health2');
|
|
INSERT INTO inventory (inventory_id, name) VALUES (3, 'health3');
|
|
|
|
statement ok
|
|
CREATE TABLE player (entity_id INTEGER, inventory_id INTEGER);
|
|
INSERT INTO player (entity_id, inventory_id) VALUES (100,1), (200,1), (300,1);
|
|
|
|
statement ok
|
|
CREATE TABLE location (entity_id INTEGER, x REAL, z REAL);
|
|
INSERT INTO location (entity_id, x, z) VALUES (100, 0.0, 32.0), (100, 1.0, 31.0)
|