diff options
| author | Tristan Riehs <tristan.riehs@inria.fr> | 2025-12-27 16:15:52 +0100 |
|---|---|---|
| committer | Tristan Riehs <tristan.riehs@inria.fr> | 2025-12-27 16:15:52 +0100 |
| commit | 6aceab103e5cee24353f1d6ab2d01a979305b87c (patch) | |
| tree | d82fa9923007db1c29aa9627d5c9738acc0fd816 /sql | |
| parent | 60aebe82112277176ba437bf7310aecca2b74bbf (diff) | |
Remove old proof of concept from SQL init script
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/init.sql | 12 |
1 files changed, 0 insertions, 12 deletions
diff --git a/sql/init.sql b/sql/init.sql index d78a681..75fa4c7 100644 --- a/sql/init.sql +++ b/sql/init.sql @@ -19,15 +19,3 @@ CREATE TABLE file_tags ( FOREIGN KEY(file) REFERENCES files(id), 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 files VALUES(0, 'contrat_these.pdf', 'Contrat de travail pour la thèse.'); - --- 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; |
