Contents

CREATE TABLE IF NOT EXISTS `blacklist_patterns` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(15) default NULL,
  `pattern` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE IF NOT EXISTS  `settings` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(40) default NULL,
  `value` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE IF NOT EXISTS `sessions` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `sessid` varchar(32) default NULL,
  `data` text,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `sessid` (`sessid`)
);  

CREATE TABLE IF NOT EXISTS  `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(80) default NULL,
  `password` varchar(40) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`login`)
);

ALTER TABLE `comments` ADD `ip` varchar(15) DEFAULT NULL;
ALTER TABLE `articles` ADD `text_filter` varchar(20) DEFAULT NULL;

Version data entries

30 entries across 30 versions & 1 rubygems

Version	Path
typo-5.5	db/updates/update.168.to.200.mysql.sql
typo-5.4.4	db/updates/update.168.to.200.mysql.sql
typo-5.4.3	db/updates/update.168.to.200.mysql.sql
typo-5.4.2	db/updates/update.168.to.200.mysql.sql
typo-5.4.1	db/updates/update.168.to.200.mysql.sql
typo-5.4	db/updates/update.168.to.200.mysql.sql
typo-3.99.0	db/updates/update.168.to.200.mysql.sql
typo-3.99.3	db/updates/update.168.to.200.mysql.sql
typo-3.99.1	db/updates/update.168.to.200.mysql.sql
typo-3.99.2	db/updates/update.168.to.200.mysql.sql
typo-3.99.4	db/updates/update.168.to.200.mysql.sql
typo-4.0.2	db/updates/update.168.to.200.mysql.sql
typo-4.0.1	db/updates/update.168.to.200.mysql.sql
typo-4.0.0	db/updates/update.168.to.200.mysql.sql
typo-4.1.1	db/updates/update.168.to.200.mysql.sql
typo-4.0.3	db/updates/update.168.to.200.mysql.sql
typo-5.0.2	db/updates/update.168.to.200.mysql.sql
typo-5.0.1	db/updates/update.168.to.200.mysql.sql
typo-4.1	db/updates/update.168.to.200.mysql.sql
typo-5.0.3.98.1	db/updates/update.168.to.200.mysql.sql