use [% mysql.gl.sqldb %];

CREATE TABLE [% table_prefix %]_trackback (
  cid int(10) unsigned NOT NULL auto_increment, 
  sid varchar(40) NOT NULL, 
  url varchar(255) default NULL,
  title varchar(128) default NULL,
  blog varchar(80) default NULL, 
  excerpt text,
  date datetime default NULL,
  type varchar(30) NOT NULL default 'article',
  ipaddress varchar(15) NOT NULL default '',
  PRIMARY KEY (cid),
  INDEX trackback_sid(sid), 
  INDEX trackback_url(url), 
  INDEX trackback_date(date), 
  INDEX trackback_type(type)
) ENGINE=MyISAM;

CREATE TABLE [% table_prefix %]_pingservice (
  pid smallint(5) unsigned NOT NULL auto_increment,
  name varchar(128) default NULL,
  ping_url varchar(255) default NULL,
  site_url varchar(255) default NULL,
  method varchar(80) default NULL,
  is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (pid),
  INDEX pingservice_is_enabled(is_enabled)
) ENGINE=MyISAM;

CREATE TABLE [% table_prefix %]_trackbackcodes (
  code tinyint(4) NOT NULL default '0',
  name varchar(32) default NULL,
  PRIMARY KEY  (code)
) ENGINE=MyISAM;

INSERT INTO [% table_prefix %]_pingservice (pid, name, site_url, ping_url, method, is_enabled) VALUES (1, 'Ping-O-Matic', 'http://pingomatic.com/', 'http://rpc.pingomatic.com/', 'weblogUpdates.ping', 1);

INSERT INTO [% table_prefix %]_trackbackcodes (code, name) VALUES (0,'Trackback Enabled');
INSERT INTO [% table_prefix %]_trackbackcodes (code, name) VALUES (-1,'Trackback Disabled');

ALTER TABLE [% table_prefix %]_blocks ADD rdflimit smallint(5) unsigned NOT NULL default '0' AFTER rdfupdated;

INSERT INTO [% table_prefix %]_features (ft_name, ft_descr, ft_gl_core) VALUES ('story.ping', 'Ability to send pings, pingbacks, or trackbacks for stories', 1);

ALTER TABLE [% table_prefix %]_users ADD remoteusername varchar(60) NULL after username;
ALTER TABLE [% table_prefix %]_users ADD remoteservice varchar(60) NULL after remoteusername;

ALTER TABLE [% table_prefix %]_users ADD status smallint(5) unsigned NOT NULL default '1';

UPDATE [% table_prefix %]_users SET status=3 WHERE (passwd IS NOT NULL) OR (passwd != '');

ALTER TABLE [% table_prefix %]_users ADD INDEX users_username(username);ALTER TABLE [% table_prefix %]_users ADD INDEX users_fullname(fullname);ALTER TABLE [% table_prefix %]_users ADD INDEX users_email(email);ALTER TABLE [% table_prefix %]_users ADD INDEX users_passwd(passwd);ALTER TABLE [% table_prefix %]_users ADD INDEX users_pwrequestid(pwrequestid);
INSERT INTO [% table_prefix %]_groups (grp_name, grp_descr, grp_gl_core) VALUES ('Remote Users', 'Users in this group can have authenticated against a remote server.',1) ;
ALTER TABLE [% table_prefix %]_speedlimit ADD INDEX type_ipaddress(type,ipaddress);ALTER TABLE [% table_prefix %]_speedlimit ADD INDEX date(date);
ALTER TABLE [% table_prefix %]_stories ADD in_transit tinyint(1) unsigned default '0' AFTER frontpage;ALTER TABLE [% table_prefix %]_stories ADD INDEX stories_in_transit(in_transit);
ALTER TABLE [% table_prefix %]_stories ADD trackbackcode tinyint(4) NOT NULL default '0' AFTER commentcode;
ALTER TABLE [% table_prefix %]_stories ADD trackbacks mediumint(8) unsigned NOT NULL default '0' AFTER comments;
ALTER TABLE [% table_prefix %]_syndication ADD header_tid varchar(48) NOT NULL default 'none' AFTER topic;
ALTER TABLE [% table_prefix %]_syndication ADD feedlogo varchar(255) AFTER description;
ALTER TABLE [% table_prefix %]_syndication CHANGE format format varchar(20) NOT NULL default 'RSS-2.0';
UPDATE [% table_prefix %]_syndication SET format='Atom-0.3' WHERE format='atom';UPDATE [% table_prefix %]_syndication SET format='RDF-1.0' WHERE format='rdf';UPDATE [% table_prefix %]_syndication SET format='RSS-0.9x' WHERE format='rss';UPDATE [% table_prefix %]_syndication SET format='RSS-2.0' WHERE format='rss2';
INSERT INTO [% table_prefix %]_plugins (pi_name, pi_version, pi_gl_version, pi_enabled, pi_homepage) VALUES ('links', '1.0', '1.4.0', 1, 'http://www.geeklog.net/');
UPDATE [% table_prefix %]_syndication SET type = 'links', topic = 'all' WHERE topic = '::links';
INSERT INTO [% table_prefix %]_plugins (pi_name, pi_version, pi_gl_version,pi_enabled, pi_homepage) VALUES ('polls', '1.0', '1.4.0', '1', 'http://www.geeklog.net/');
UPDATE [% table_prefix %]_blocks SET type = 'phpblock', phpblockfn ='phpblock_polls' WHERE name = 'poll_block';UPDATE [% table_prefix %]_features SET ft_gl_core = '0', ft_name='polls.edit' WHERE ft_name = 'poll.edit';;UPDATE [% table_prefix %]_groups SET grp_gl_core = '0', grp_name = 'Links Admin' WHERE grp_name = 'Link Admin';;UPDATE [% table_prefix %]_groups SET grp_gl_core = '0', grp_name = 'Polls Admin' WHERE grp_name = 'Poll Admin';
UPDATE [% table_prefix %]_features SET ft_name = 'links.moderate', ft_gl_core = '0' WHERE ft_name = 'link.moderate';;UPDATE [% table_prefix %]_features SET ft_name = 'links.edit', ft_gl_core = '0' WHERE ft_name = 'link.edit';;UPDATE [% table_prefix %]_features SET ft_name = 'links.submit', ft_gl_core = '0' WHERE ft_name = 'link.submit';
UPDATE [% table_prefix %]_plugins SET pi_version = '1.0.3', pi_gl_version = '1.4.0' WHERE pi_name = 'spamx';
UPDATE [% table_prefix %]_plugins SET pi_version = '1.4.2', pi_gl_version = '1.4.0', pi_homepage = 'http://www.geeklog.net/' WHERE pi_name = 'staticpages';
UPDATE [% table_prefix %]_comments SET type = 'polls' WHERE type = 'poll';
ALTER TABLE [% table_prefix %]_userindex CHANGE etids etids text;
ALTER TABLE [% table_prefix %]_events ADD hits mediumint(8) unsigned NOT NULL default '0' AFTER url;ALTER TABLE [% table_prefix %]_events ADD postmode varchar(10) NOT NULL default 'plaintext' AFTER description;ALTER TABLE [% table_prefix %]_personal_events ADD postmode varchar(10) NOT NULL default 'plaintext' AFTER description;
ALTER TABLE [% table_prefix %]_links CHANGE lid lid varchar(40) NOT NULL default '';ALTER TABLE [% table_prefix %]_linksubmission CHANGE lid lid varchar(40) NOT NULL default '';


ALTER TABLE [% table_prefix %]_groups DROP INDEX grp_name;
ALTER TABLE [% table_prefix %]_groups ADD UNIQUE grp_name(grp_name);
