Mercurial > sci
comparison sql/project-save.sql @ 22:dd078aea5d02
misc: use project/worker name as primary key
| author | David Demelier <markand@malikania.fr> |
|---|---|
| date | Thu, 21 Jul 2022 20:23:22 +0200 |
| parents | sql/project-add.sql@de4bf839b565 |
| children | 081e1c258e64 |
comparison
equal
deleted
inserted
replaced
| 21:ec30e1b078a9 | 22:dd078aea5d02 |
|---|---|
| 1 -- | |
| 2 -- project-save.sql -- create a new project | |
| 3 -- | |
| 4 -- Copyright (c) 2021 David Demelier <markand@malikania.fr> | |
| 5 -- | |
| 6 -- Permission to use, copy, modify, and/or distribute this software for any | |
| 7 -- purpose with or without fee is hereby granted, provided that the above | |
| 8 -- copyright notice and this permission notice appear in all copies. | |
| 9 -- | |
| 10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES | |
| 11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF | |
| 12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR | |
| 13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES | |
| 14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN | |
| 15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF | |
| 16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. | |
| 17 -- | |
| 18 | |
| 19 REPLACE INTO project( | |
| 20 `name`, | |
| 21 `desc`, | |
| 22 `url`, | |
| 23 `script` | |
| 24 ) VALUES (?, ?, ?, ?) |