Mercurial > molko

annotate src/libmlk-rpg/assets/sql/property-set.sql @ 320:8f9937403749

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc: improve loading of data
author David Demelier <markand@malikania.fr>
date Fri, 01 Oct 2021 20:30:00 +0200
parents libmlk-rpg/assets/sql/property-set.sql@d01e83210ca2
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
173
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
1 --
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
2 -- property-set.sql -- set a property
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
3 --
314
d01e83210ca2 misc: update years
David Demelier <markand@malikania.fr>
parents: 281
diff changeset
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 )