fulldecent/cameralife

BEGIN TRANSACTION;
CREATE TABLE "albums" (
  "id" int(11) NOT NULL ,
  "topic" varchar(20) NOT NULL DEFAULT '',
  "name" varchar(25) NOT NULL DEFAULT '',
  "term" varchar(20) NOT NULL DEFAULT '',
  "poster_id" int(11) NOT NULL DEFAULT '0',
  "hits" bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY ("id")
);
CREATE TABLE "comments" (
  "id" int(11) NOT NULL ,
  "photo_id" int(11) NOT NULL,
  "username" varchar(30) NOT NULL,
  "user_ip" varchar(16) NOT NULL,
  "comment" varchar(255) NOT NULL,
  "date" datetime NOT NULL,
  PRIMARY KEY ("id")
);
CREATE TABLE "exif" (
  "photoid" int(11) NOT NULL,
  "tag" varchar(50) NOT NULL,
  "value" varchar(255) NOT NULL,
  PRIMARY KEY ("photoid","tag")
);
CREATE TABLE "logs" (
  "id" int(11) NOT NULL ,
  "record_type" text  NOT NULL DEFAULT 'album',
  "record_id" int(11) NOT NULL DEFAULT '0',
  "value_field" varchar(40) NOT NULL DEFAULT '',
  "value_new" text NOT NULL,
  "user_name" varchar(30) NOT NULL DEFAULT '',
  "user_ip" varchar(16) NOT NULL DEFAULT '',
  "user_date" date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY ("id")
);
CREATE TABLE "photos" (
  "id" int(11) NOT NULL ,
  "filename" varchar(255) NOT NULL,
  "path" varchar(255) NOT NULL DEFAULT '',
  "description" varchar(255) NOT NULL DEFAULT '',
  "username" varchar(30) DEFAULT NULL,
  "status" int(11) NOT NULL DEFAULT '0',
  "flag" text  DEFAULT NULL,
  "width" int(11) DEFAULT NULL,
  "height" int(11) DEFAULT NULL,
  "tn_width" int(11) DEFAULT NULL,
  "tn_height" int(11) DEFAULT NULL,
  "hits" bigint(20) NOT NULL DEFAULT '0',
  "created" date DEFAULT NULL,
  "fsize" int(11) NOT NULL DEFAULT '0',
  "modified" int(1) DEFAULT NULL,
  "mtime" int(11) DEFAULT NULL,
  "keywords" varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY ("id")
);
CREATE TABLE "preferences" (
  "prefmodule" varchar(64) NOT NULL DEFAULT 'core',
  "prefkey" varchar(64) NOT NULL DEFAULT '',
  "prefvalue" varchar(255) NOT NULL DEFAULT '',
  "prefdefault" varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY ("prefmodule","prefkey")
);
INSERT INTO "preferences" VALUES ('CameraLife','sitedate','2014-05-13 23:56:29','2014-05-13 23:56:29');
INSERT INTO "preferences" VALUES ('CameraLife','db_version','1','1');
CREATE TABLE "ratings" (
  "id" int(11) NOT NULL,
  "username" varchar(30) DEFAULT NULL,
  "user_ip" varchar(16) NOT NULL,
  "rating" int(11) NOT NULL,
  "date" datetime NOT NULL
);
CREATE TABLE "test" (
  "id" int(11) NOT NULL DEFAULT '0',
  "rec" int(11) NOT NULL DEFAULT '0'
);
CREATE TABLE "users" (
  "id" int(20) NOT NULL ,
  "username" varchar(30) NOT NULL DEFAULT '',
  "password" varchar(255) NOT NULL DEFAULT '',
  "auth" int(11) NOT NULL DEFAULT '0',
  "cookie" varchar(64) NOT NULL DEFAULT '',
  "last_online" date NOT NULL DEFAULT '0000-00-00',
  "last_ip" varchar(20) DEFAULT NULL,
  "email" varchar(80) DEFAULT NULL,
  PRIMARY KEY ("username")
);
CREATE INDEX "ratings_id_3" ON "ratings" ("id","username","user_ip");
CREATE INDEX "ratings_id" ON "ratings" ("id");
CREATE INDEX "ratings_id_2" ON "ratings" ("id","username","user_ip");
CREATE INDEX "ratings_id_4" ON "ratings" ("id");
CREATE INDEX "photos_fingerprint" ON "photos" ("filename","fsize");
CREATE INDEX "photos_description" ON "photos" ("description");
CREATE INDEX "exif_photoid" ON "exif" ("photoid");
CREATE INDEX "comments_id" ON "comments" ("photo_id");
CREATE INDEX "users_username" ON "users" ("username");
CREATE INDEX "users_id" ON "users" ("id");
END TRANSACTION;