create table script

tables.sql

CREATE TABLE ages (
  ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  agename VARCHAR(16) NOT NULL,
  author MEDIUMINT(8) UNSIGNED NOT NULL,
  longname VARCHAR(255) NOT NULL,
  version INTEGER UNSIGNED NOT NULL,
  release DATE NOT NULL,
  updated DATE NOT NULL,
  seqprefix INTEGER UNSIGNED NULL,
  PRIMARY KEY(ID)
);

ALTER TABLE ages AUTO_INCREMENT = 200;

CREATE TABLE checksums (
  ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  filepath VARCHAR(255) NOT NULL,
  hash VARCHAR(40) NOT NULL,
  ageid INTEGER UNSIGNED NOT NULL,
  PRIMARY KEY(ID)
);

CREATE TABLE trashedprefixes (
  ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  prefix INTEGER UNSIGNED NULL,
  PRIMARY KEY(ID)
);