Open-ILS/src/sql/Pg/stats/asset_stats.sql

   1 DROP SCHEMA asset_hist CASCADE;
   2
   3 BEGIN
   4
   5 CREATE SCHEMA asset_hist;
   6
   7 CREATE TABLE asset_hist.copy_immutables (
   8         id              BIGINT                          PRIMARY KEY,
   9         owning_lib      BIGINT                          NOT NULL,
  10         creator         BIGINT                          NOT NULL,
  11         create_date     TIMESTAMP WITH TIME ZONE        NOT NULL,
  12         deleter         BIGINT,
  13         delete_date     TIMESTAMP WITH TIME ZONE,
  14         barcode         TEXT                            NOT NULL,
  15         copy_number     INT                             NOT NULL,
  16         price           NUMERIC(8,2)                    NOT NULL
  17 );
  18