[cvs] [Wiki] created: Groo/Tables

[Luciano Ramalho]

luciano  Mon, 21 Aug 2006 06:03:29 -0700

Created page: http://wiki.horde.org/Groo/Tables

+ Groo tables

++ groo_books

<code type="sql">
CREATE TABLE groo_books (
    book_id INT UNSIGNED NOT NULL,
    isbn13 CHAR(14),      -- ISBN13 + 1 DIGIT = GTIN
    title VARCHAR(255),   -- Either isbn13 or title must not be null
    title_sort VARCHAR(255),   -- Title for sorting purposes (article at end)
    edition VARCHAR(63),  -- Ex: 1st; extended ultimate director's cut edition
    publisher VARCHAR(63),
    issued CHAR(10), -- publication date in partial ISO-8601 format Ex: 1999-12
    metadata_status VARCHAR(32),           -- status of the data in this record
    metadata_source VARCHAR(32) NOT NULL,  -- source of the data in this record
    metadata_modified_dt TIMESTAMP,
    created_dt DATETIME NOT NULL,
--
    PRIMARY KEY (book_id),
    UNIQUE (isbn13),
    FULLTEXT (title)
);
</code>