[p5sagit/Email-Archive.git] / lib / auto / Email / Archive / Storage / DBI / latest_schema.txt

CREATE TABLE messages (
  message_id  VARCHAR(50) PRIMARY KEY,
  from_addr   VARCHAR(255) NOT NULL DEFAULT '',
  to_addr     VARCHAR(255) NOT NULL DEFAULT '',
  cc          VARCHAR(255) NOT NULL DEFAULT '',
  subject     VARCHAR(255) NOT NULL DEFAULT '',
  date        VARCHAR(255) NOT NULL DEFAULT '',
  body        TEXT NOT NULL  DEFAULT ''
);

CREATE TABLE metadata (
  schema_version INT PRIMARY KEY DEFAULT 0
);
Commit	Line	Data
8581da38	1	CREATE TABLE messages (
	2	message_id VARCHAR(50) PRIMARY KEY,
	3	from_addr VARCHAR(255) NOT NULL DEFAULT '',
	4	to_addr VARCHAR(255) NOT NULL DEFAULT '',
	5	cc VARCHAR(255) NOT NULL DEFAULT '',
	6	subject VARCHAR(255) NOT NULL DEFAULT '',
	7	date VARCHAR(255) NOT NULL DEFAULT '',
	8	body TEXT NOT NULL DEFAULT ''
	9	);
	10
	11	CREATE TABLE metadata (
	12	schema_version INT PRIMARY KEY DEFAULT 0
	13	);