+++ /dev/null
-CREATE TABLE connections (
- `server` VARCHAR(30) NOT NULL,
- `port` INT NOT NULL DEFAULT '6667',
- `nick` VARCHAR(20) NOT NULL,
- `nickservpass` VARCHAR(8) NOT NULL,
- `ircname` VARCHAR (20) NOT NULL DEFAULT 'infobot',
- `timeadded` INT UNSIGNED DEFAULT '0',
- PRIMARY KEY (server,port,nick)
-);
+++ /dev/null
-CREATE TABLE `freshmeat` (
- `projectname_short` VARCHAR(64) NOT NULL,
- `latest_version` VARCHAR(32) DEFAULT 'none' NOT NULL,
- `license` VARCHAR(32),
- `url_homepage` VARCHAR(128),
- `desc_short` VARCHAR(96) NOT NULL,
- PRIMARY KEY (`projectname_short`,`latest_version`)
-);
+++ /dev/null
-CREATE TABLE `news` (
- `channel` VARCHAR(30) NOT NULL,
- `id` INT UNSIGNED DEFAULT '0',
- `key` VARCHAR(16) NOT NULL,
- `value` TEXT NOT NULL,
- PRIMARY KEY (`channel`,`id`,`key`)
-);
+++ /dev/null
-CREATE TABLE `uptime` (
- `uptime` INT UNSIGNED DEFAULT '0', # start.
- `endtime` INT UNSIGNED DEFAULT '0', # end.
- `string` VARCHAR(128) NOT NULL,
- PRIMARY KEY (`uptime`)
-);
+++ /dev/null
-CREATE TABLE connections (
- server character varying(30) NOT NULL,
- port integer DEFAULT 6667 NOT NULL,
- nick character varying(20) NOT NULL,
- nickservpass character varying(8) NOT NULL,
- ircname character varying(20) DEFAULT 'infobot IRC bot'::character varying NOT NULL,
- timeadded numeric DEFAULT 0
-) WITHOUT OIDS;
-
-REVOKE ALL ON TABLE connections FROM PUBLIC;
-
-ALTER TABLE ONLY connections
- ADD CONSTRAINT connections_pkey PRIMARY KEY (server, port, nick);
+++ /dev/null
-CREATE TABLE freshmeat (
- projectname_short VARCHAR(64) NOT NULL,
- latest_version VARCHAR(32) DEFAULT 'none'::VARCHAR NOT NULL,
- license VARCHAR(32),
- url_homepage VARCHAR(128),
- desc_short VARCHAR(96) NOT NULL
-) WITHOUT OIDS;
-
-REVOKE ALL ON TABLE freshmeat FROM PUBLIC;
-
-ALTER TABLE ONLY freshmeat
- ADD CONSTRAINT freshmeat_pkey PRIMARY KEY (projectname_short, latest_version);
+++ /dev/null
-CREATE TABLE news (
- channel VARCHAR(30) NOT NULL,
- id numeric DEFAULT 0 NOT NULL,
- "key" VARCHAR(16) NOT NULL,
- value text NOT NULL
-) WITHOUT OIDS;
-
-REVOKE ALL ON TABLE news FROM PUBLIC;
-
-ALTER TABLE ONLY news
- ADD CONSTRAINT news_pkey PRIMARY KEY (channel, id, "key");
+++ /dev/null
-CREATE TABLE uptime (
- uptime numeric DEFAULT 0,
- endtime numeric DEFAULT 0,
- string VARCHAR(128) NOT NULL
-) WITHOUT OIDS;
-
-REVOKE ALL ON TABLE uptime FROM PUBLIC;
-
-ALTER TABLE ONLY uptime
- ADD CONSTRAINT uptime_pkey PRIMARY KEY (uptime);
+++ /dev/null
-CREATE TABLE connections (
- server VARCHAR(30) NOT NULL,
- port INT NOT NULL DEFAULT '6667',
- nick VARCHAR(20) NOT NULL,
- nickservpass VARCHAR(8) NOT NULL,
- ircname VARCHAR (20) NOT NULL DEFAULT 'infobot experimental bot',
- timeadded INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
- PRIMARY KEY (server,port,nick)
-);
+++ /dev/null
-CREATE TABLE freshmeat (
- projectname_short VARCHAR(64) NOT NULL,
- latest_version VARCHAR(32) DEFAULT 'none' NOT NULL,
- license VARCHAR(32),
- url_homepage VARCHAR(128),
- desc_short VARCHAR(96) NOT NULL,
- PRIMARY KEY (projectname_short,latest_version)
-);
+++ /dev/null
-CREATE TABLE news (
- channel VARCHAR(30) NOT NULL,
- id INT UNSIGNED DEFAULT '0',
- key VARCHAR(16) NOT NULL,
- value TEXT NOT NULL, # limit to ~450 or so.
- PRIMARY KEY (channel,id,key)
-);
+++ /dev/null
-CREATE TABLE uptime (
- uptime INT UNSIGNED DEFAULT '0', # start.
- endtime INT UNSIGNED DEFAULT '0', # end.
- string VARCHAR(128) NOT NULL,
- PRIMARY KEY (uptime)
-);
+++ /dev/null
-CREATE TABLE connections (
- server VARCHAR(30) NOT NULL,
- port INT NOT NULL DEFAULT '6667',
- nick VARCHAR(20) NOT NULL,
- nickservpass VARCHAR(8) NOT NULL,
- ircname VARCHAR (20) NOT NULL DEFAULT 'infobot - perl irc bot',
- timeadded INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
- PRIMARY KEY (server,port,nick)
-);
+++ /dev/null
-CREATE TABLE freshmeat (
- projectname_short VARCHAR(64) NOT NULL,
- latest_version VARCHAR(32) DEFAULT 'none' NOT NULL,
- license VARCHAR(32),
- url_homepage VARCHAR(128),
- desc_short VARCHAR(96) NOT NULL,
- PRIMARY KEY (projectname_short,latest_version)
-);
+++ /dev/null
-CREATE TABLE news (
- channel VARCHAR(30) NOT NULL,
- id INT UNSIGNED DEFAULT '0',
- key VARCHAR(16) NOT NULL,
- value TEXT NOT NULL,
- PRIMARY KEY (channel,id,key)
-);
--- limit value to ~450 or so.
+++ /dev/null
-CREATE TABLE uptime (
- uptime INT UNSIGNED DEFAULT '0',
- endtime INT UNSIGNED DEFAULT '0',
- string VARCHAR(128) NOT NULL,
- PRIMARY KEY (uptime)
-);
-
--- uptime is start time
--- endtime is endtime :)