Mercurial > molko
annotate src/libmlk-rpg/assets/sql/property-save.sql @ 328:60a4f904da21
rpg: separate property from save
author | David Demelier <markand@malikania.fr> |
---|---|
date | Mon, 04 Oct 2021 13:10:11 +0200 |
parents | src/libmlk-rpg/assets/sql/property-set.sql@8f9937403749 |
children | 460c78706989 |
rev | line source |
---|---|
173
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
1 -- |
328
60a4f904da21
rpg: separate property from save
David Demelier <markand@malikania.fr>
parents:
320
diff
changeset
|
2 -- property-save.sql -- set a property |
173
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
3 -- |
314 | 4 -- Copyright (c) 2020-2021 David Demelier <markand@malikania.fr> |
173
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
5 -- |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
6 -- Permission to use, copy, modify, and/or distribute this software for any |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
7 -- purpose with or without fee is hereby granted, provided that the above |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
8 -- copyright notice and this permission notice appear in all copies. |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
9 -- |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
17 -- |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
18 |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
19 INSERT OR REPLACE INTO property( |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
20 key, |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
21 value |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
22 ) |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
23 VALUES( |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
24 ?, |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
25 ? |
cd69c8791dac
core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
26 ) |