source: contrib/Dms/todo @ 3526

CREATE TABLE phpgw_mydms_acls
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_acls'::regclass),
  target integer NOT NULL DEFAULT 0,
  targettype integer NOT NULL DEFAULT 0,
  userid integer NOT NULL DEFAULT (-1),
  groupid integer NOT NULL DEFAULT (-1),
  "mode" integer NOT NULL DEFAULT 0,
  CONSTRAINT phpgw_mydms_acls_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_acls OWNER TO postgres;



CREATE TABLE phpgw_mydms_documentcontent
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_documentcontent'::regclass),
  "document" integer DEFAULT 0,
  "version" integer DEFAULT 0,
  "comment" text,
  date integer DEFAULT 0,
  createdby integer DEFAULT 0,
  dir character varying(10) NOT NULL DEFAULT ' '::character varying,
  orgfilename character varying(150) NOT NULL DEFAULT ' '::character varying,
  filetype character varying(10) NOT NULL DEFAULT ' '::character varying,
  mimetype character varying(70) NOT NULL DEFAULT ' '::character varying,
  CONSTRAINT phpgw_mydms_documentcontent_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_documentcontent OWNER TO postgres;



CREATE TABLE phpgw_mydms_documentlinks
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_documentlinks'::regclass),
  "document" integer NOT NULL DEFAULT 0,
  target integer NOT NULL DEFAULT 0,
  userid integer NOT NULL DEFAULT 0,
  public boolean NOT NULL DEFAULT true,
  CONSTRAINT phpgw_mydms_documentlinks_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_documentlinks OWNER TO postgres;




CREATE TABLE phpgw_mydms_documents
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_documents'::regclass),
  "name" character varying(150) DEFAULT NULL::character varying,
  "comment" text,
  date integer DEFAULT 0,
  expires integer DEFAULT 0,
  "owner" integer DEFAULT 0,
  folder integer DEFAULT 0,
  inheritaccess boolean NOT NULL DEFAULT true,
  defaultaccess integer NOT NULL DEFAULT 0,
  locked integer NOT NULL DEFAULT (-1),
  keywords text,
  "sequence" double precision NOT NULL,
  CONSTRAINT phpgw_mydms_documents_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_documents OWNER TO postgres;




CREATE TABLE phpgw_mydms_folders
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_folders'::regclass),
  "name" character varying(90) DEFAULT NULL::character varying,
  parent integer DEFAULT 0,
  "comment" text,
  "owner" integer DEFAULT 0,
  inheritaccess boolean NOT NULL DEFAULT true,
  defaultaccess integer NOT NULL DEFAULT 0,
  "sequence" double precision NOT NULL,
  CONSTRAINT phpgw_mydms_folders_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_folders OWNER TO postgres;




CREATE TABLE phpgw_mydms_groupmembers
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_groupmembers'::regclass),
  groupid integer NOT NULL DEFAULT 0,
  userid integer NOT NULL DEFAULT 0,
  CONSTRAINT phpgw_mydms_groupmembers_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_groupmembers OWNER TO postgres;




CREATE TABLE phpgw_mydms_groups
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_groups'::regclass),
  "name" character varying(50) DEFAULT NULL::character varying,
  "comment" text,
  CONSTRAINT phpgw_mydms_groups_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_groups OWNER TO postgres;




CREATE TABLE phpgw_mydms_keywordcategories
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_keywordcategories'::regclass),
  "name" character varying(255) NOT NULL DEFAULT ''::character varying,
  "owner" integer NOT NULL DEFAULT 0,
  CONSTRAINT phpgw_mydms_keywordcategories_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_keywordcategories OWNER TO postgres;




CREATE TABLE phpgw_mydms_keywords
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_keywords'::regclass),
  category integer NOT NULL DEFAULT 0,
  keywords text,
  CONSTRAINT phpgw_mydms_keywords_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_keywords OWNER TO postgres;




CREATE TABLE phpgw_mydms_notify
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_notify'::regclass),
  target integer NOT NULL DEFAULT 0,
  targettype integer NOT NULL DEFAULT 0,
  userid integer NOT NULL DEFAULT (-1),
  groupid integer NOT NULL DEFAULT (-1),
  CONSTRAINT phpgw_mydms_notify_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_notify OWNER TO postgres;





CREATE TABLE phpgw_mydms_sessions
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_sessions'::regclass),
  userid integer NOT NULL DEFAULT 0,
  lastaccess integer NOT NULL DEFAULT 0,
  theme character varying(30) NOT NULL DEFAULT ''::character varying,
  "language" character varying(30) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT phpgw_mydms_sessions_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_sessions OWNER TO postgres;




CREATE TABLE phpgw_mydms_userimages
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_userimages'::regclass),
  userid integer NOT NULL DEFAULT 0,
  image oid,
  mimetype character varying(10) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT phpgw_mydms_userimages_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_userimages OWNER TO postgres;




CREATE TABLE phpgw_mydms_users
(
  id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_users'::regclass),
  "login" character varying(50) DEFAULT NULL::character varying,
  pwd character varying(50) DEFAULT NULL::character varying,
  fullname character varying(100) DEFAULT NULL::character varying,
  email character varying(70) DEFAULT NULL::character varying,
  "comment" text,
  isadmin integer NOT NULL DEFAULT 0,
  CONSTRAINT phpgw_mydms_users_key UNIQUE (id)
)
WITH (OIDS=TRUE);
ALTER TABLE phpgw_mydms_users OWNER TO postgres;