diff options
| author | Tristan Riehs <tristan.riehs@inria.fr> | 2025-11-11 10:07:25 +0100 |
|---|---|---|
| committer | Tristan Riehs <tristan.riehs@inria.fr> | 2025-11-11 10:07:25 +0100 |
| commit | 683d6ee7a31c5294810b12f81fde360dbd2d3455 (patch) | |
| tree | 167c6015a59d5556c76e671ead4f2608c1a02734 /sql | |
| parent | cf6ef0ccc0124bae4298d41da447f1b4a5e8c636 (diff) | |
Comment out old stuff
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/init.sql | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/sql/init.sql b/sql/init.sql index 9501f9f..259a591 100644 --- a/sql/init.sql +++ b/sql/init.sql @@ -19,14 +19,14 @@ CREATE TABLE file_tags ( FOREIGN KEY(tag) REFERENCES tags(id) ); -INSERT INTO tags VALUES(0, 'inria', 'Document lié à Inria'); -INSERT INTO tags VALUES(1, 'enseirb', 'Document lié à Enseirb'); +-- INSERT INTO tags VALUES(0, 'inria', 'Document lié à Inria'); +-- INSERT INTO tags VALUES(1, 'enseirb', 'Document lié à Enseirb'); -INSERT INTO files VALUES(0, 'contrat_these.pdf', 'Contrat de travail pour la thèse.'); +-- INSERT INTO files VALUES(0, 'contrat_these.pdf', 'Contrat de travail pour la thèse.'); -INSERT INTO file_tags VALUES(0 ,0); +-- INSERT INTO file_tags VALUES(0 ,0); --- Query: all files related to Inria -SELECT name, description FROM ( - files JOIN file_tags ON files.id = file_tags.file -) WHERE file_tags.tag = 0; +-- -- Query: all files related to Inria +-- SELECT name, description FROM ( +-- files JOIN file_tags ON files.id = file_tags.file +-- ) WHERE file_tags.tag = 0; |
