-CREATE TABLE "links_imcs" (
- "id" integer DEFAULT nextval('links_imcs_id_seq'::text) NOT NULL,
- "to_parent_id" integer,
- "title" character varying(80) NOT NULL,
- "url" character varying(255) NOT NULL,
- "sortpriority" integer DEFAULT '1',
- "to_language" integer DEFAULT '0' NOT NULL,
- Constraint "links_imcs_pkey" Primary Key ("id")
+CREATE TABLE "content" (
+ "id" integer DEFAULT nextval('media_id_seq'::text) NOT NULL,
+ "title" character varying(255),
+ "subtitle" character varying(255),
+ "edittitle" character varying(255),
+ "date" character(8) NOT NULL,
+ "creator" character varying(80),
+ "creator_main_url" character varying(255),
+ "creator_email" character varying(80),
+ "creator_address" character varying(80),
+ "creator_phone" character varying(80),
+ "description" text,
+ "comment" text,
+ "source" character varying(255),
+ "is_published" boolean DEFAULT '0' NOT NULL,
+ "is_produced" boolean DEFAULT '0' NOT NULL,
+ "to_publisher" integer NOT NULL,
+ "to_language" integer DEFAULT '0',
+ "to_rights" integer DEFAULT '0',
+ "webdb_create" timestamp with time zone NOT NULL,
+ "webdb_lastchange" timestamp with time zone,
+ "content_data" text,
+ "is_html" boolean DEFAULT '0' NOT NULL,
+ "to_article_type" smallint DEFAULT '0' NOT NULL,
+ "to_content" integer,
+ "keywords" text,
+ "to_locking_user" integer,
+ Constraint "content_pkey" Primary Key ("id")