MyVideos48 |
Table "files" |
![]() ![]() ![]() |
System: | ![]() |
Field | Data type | PK | FK | Not Null | Default | Collate | Check | On Conflict |
---|---|---|---|---|---|---|---|---|
idFile | integer | ![]() |
||||||
strFilename | text | ![]() |
Index | Fields | Primary | Unique |
---|---|---|---|
UniqueFilename | strFilename | ![]() |
CREATE TABLE files (
idFile integer PRIMARY KEY AUTOINCREMENT,
strFilename text NOT NULL
);
CREATE UNIQUE INDEX UniqueFilename
ON files
(strFilename);
![]() ![]() ![]() |
Generated by ""SQLite Maestro Professional"" at 08.07.2021 23:49:20 |