[Canyamo-cvs] canyamo-apps/items/db-schema items-pgsql.sql,NONE,1.1

[Roberto S. <rs...@us...>]

Update of /cvsroot/canyamo/canyamo-apps/items/db-schema
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11836/items/db-schema

Added Files:
	items-pgsql.sql 
Log Message:
no message

--- NEW FILE: items-pgsql.sql ---
--
-- Table structure for table `news`
--
DROP TABLE news;
CREATE TABLE "news" (
    "id" SERIAL NOT NULL,
    "type" character varying(255) NOT NULL DEFAULT 'canyamo',
    "date" timestamp without time zone NOT NULL,
    "title" character varying(50) NOT NULL default '',
    "body" text NOT NULL,
    "author" character varying(12) NOT NULL default '',
    "url" character varying(80) NOT NULL default '',
    "votes" integer DEFAULT 0,
    "visits" integer DEFAULT 0,
    "comments" integer DEFAULT 0,
    "lastcomment" timestamp without time zone NOT NULL,
    "approved" character(1) DEFAULT 'y' NOT NULL,
    PRIMARY KEY (id)
);

--------------------------------------------------------
insert into news values(1, 'canyamo', '16-02-2003', 'Bienvenido', 'Enhorabuena, si estas viendo esto es que tu instalación de Cáñamo, en concreto de la aplicación de <i>items</i> se ha efectuado correctamente.', 'javahispano', 'canyamo.action', 11111, 0, 0, '16-02-2003', 'y');

--
-- Table structure for table `news_comments`
--

DROP TABLE news_comments;
CREATE TABLE news_comments (
  "id" SERIAL NOT NULL,
  "item" integer NOT NULL default 0,
  "user" character varying(20) NOT NULL DEFAULT '',
  "comment" text NOT NULL,
  "date" timestamp without time zone NOT NULL default '16-02-2003',
  "approved" character(1) NOT NULL DEFAULT 'n',
  PRIMARY KEY (id)
);
--------------------------------------------------------

--
-- Table structure for table `news_types`
--

DROP TABLE news_types;
CREATE TABLE news_types (
  "id" character varying(15) NOT NULL default '',
  "text" character varying(25) NOT NULL default '',
  "parent" character varying(15) default '',
  PRIMARY KEY (id)
);

insert into news_types values ('canyamo', 'Noticias sobre Cáñamo', 'null');
insert into news_types values ('newcanyamo', 'Nueva versión de Cáñamo', 'canyamo');
insert into news_types values ('otro', 'Otro tipo de noticias', 'null');

DROP TABLE news_votes;
CREATE TABLE news_votes (
  "id" SERIAL NOT NULL,
  "item" integer NOT NULL,
  "user" character varying(20) NOT NULL default '',
  PRIMARY KEY  (id)
);