You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The SEP numbers are indeed a type of index and is unique to each sample and is hence suitable to use as Primary key in sqlite, but if one tries to add constraint or create triggers for creating a log table to keep track of all changes. The column names index creates problems as index is a keyword in sqlite3.
Example of trigger functions that would be interesting to implement to make backups and tracking changes easier
The SEP numbers are indeed a type of index and is unique to each sample and is hence suitable to use as Primary key in sqlite, but if one tries to add constraint or create triggers for creating a log table to keep track of all changes. The column names index creates problems as index is a keyword in sqlite3.
Example of trigger functions that would be interesting to implement to make backups and tracking changes easier
http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
The text was updated successfully, but these errors were encountered: