2022-10-31 22:31:49 +00:00
|
|
|
ALTER TABLE properties_contents
|
|
|
|
ADD COLUMN model_name TEXT NOT NULL DEFAULT "",
|
|
|
|
ADD COLUMN model_description TEXT NOT NULL DEFAULT "",
|
2024-11-15 09:05:05 +00:00
|
|
|
ADD COLUMN behavior_1 INTEGER NOT NULL DEFAULT 0,
|
|
|
|
ADD COLUMN behavior_2 INTEGER NOT NULL DEFAULT 0,
|
|
|
|
ADD COLUMN behavior_3 INTEGER NOT NULL DEFAULT 0,
|
|
|
|
ADD COLUMN behavior_4 INTEGER NOT NULL DEFAULT 0,
|
|
|
|
ADD COLUMN behavior_5 INTEGER NOT NULL DEFAULT 0;
|
2022-10-31 22:31:49 +00:00
|
|
|
|
|
|
|
UPDATE properties_contents SET model_name = CONCAT("Objects_", lot, "_name") WHERE model_name = "";
|
2024-11-15 09:05:05 +00:00
|
|
|
CREATE TABLE IF NOT EXISTS behaviors (id INTEGER NOT NULL, behavior_info TEXT NOT NULL);
|