File: create_uploader_table.Pg.sql

package info (click to toggle)
libcgi-uploader-perl 2.18-2.1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 312 kB
  • sloc: perl: 1,456; sql: 52; makefile: 2
file content (12 lines) | stat: -rw-r--r-- 403 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
11
12
 
CREATE SEQUENCE upload_id_seq;
CREATE TABLE uploads (
	upload_id   int primary key not null default nextval('upload_id_seq'),
	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
)