User Tools

Site Tools


podoc:photo_spooler_sql_table

Database Table Description of "photo_spooler"

Name

photo_spooler

Description

Purpose

Schema

CREATE TABLE photo_spooler (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  users                 INTEGER REFERENCES users(identifier),
  photo                 INTEGER REFERENCES photo(identifier)
);

References tables

  • photo references photo(identifier)
  • users references users(identifier)

Is referenced by tables

None.

None.

None.

None.

History

Used first

Version 2.15

Used last

Version 2.33

Schema change history

= Version 2.15 =

ALTER TABLE printer_spooler RENAME TO photo_spooler;
DELETE FROM photo_spooler;

= Version 2.34 =

-- Drop the old spooler
DROP TABLE photo_spooler;
Data change history
podoc/photo_spooler_sql_table.txt · Last modified: 2007/10/19 14:41 by Luud