File: create_uploader_table.SQLite.sql

package info (click to toggle)
libcgi-uploader-perl 2.18-2
  • links: PTS, VCS
  • area: main
  • in suites: bullseye, buster, sid, stretch
  • size: 312 kB
  • ctags: 140
  • sloc: perl: 1,456; sql: 52; makefile: 2
file content (12 lines) | stat: -rw-r--r-- 422 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
CREATE TABLE uploads (
    -- Notice AUTOINCREMENT has no underscore like MySQL does.  
	upload_id  INTEGER primary key AUTOINCREMENT NOT NULL, 
	file_name  character varying(255),
	mime_type  character varying(64),
	extension  character varying(8), -- file extension
	width      integer,                 
	height     integer,

	-- refer to the ID of the image used to create this thumbnail, if any
	gen_from_id integer
)