Sha256: bf5a78514576751ed9213aeb258f7f9ae07cbcbdc3d1adfa1a2e1bef5111fa17

Contents?: true

Size: 912 Bytes

Versions: 30

Compression:

Stored size: 912 Bytes

Contents

CREATE TABLE blacklist_patterns (
  id SERIAL PRIMARY KEY NOT NULL,
  type varchar(15) default NULL,
  pattern varchar(255) default NULL
);

CREATE TABLE sessions (
  id SERIAL PRIMARY KEY NOT NULL,
  sessid varchar(255) default NULL,
  data text,
  created_at TIMESTAMP DEFAULT now(),
  updated_at TIMESTAMP DEFAULT now()
);                                                                                                                                                                  

CREATE TABLE settings (
  id SERIAL PRIMARY KEY NOT NULL,
  name varchar(255) default NULL,
  value varchar(255) default NULL,
  position int default NULL
);

CREATE TABLE users (
  id SERIAL PRIMARY KEY NOT NULL,
  login varchar(40) default NULL,
  password varchar(40) default NULL,
  UNIQUE (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.psql.sql
typo-5.4.4 db/updates/update.168.to.200.psql.sql
typo-5.4.3 db/updates/update.168.to.200.psql.sql
typo-5.4.2 db/updates/update.168.to.200.psql.sql
typo-5.4.1 db/updates/update.168.to.200.psql.sql
typo-5.4 db/updates/update.168.to.200.psql.sql
typo-3.99.0 db/updates/update.168.to.200.psql.sql
typo-3.99.3 db/updates/update.168.to.200.psql.sql
typo-3.99.2 db/updates/update.168.to.200.psql.sql
typo-3.99.1 db/updates/update.168.to.200.psql.sql
typo-4.0.2 db/updates/update.168.to.200.psql.sql
typo-4.0.0 db/updates/update.168.to.200.psql.sql
typo-3.99.4 db/updates/update.168.to.200.psql.sql
typo-4.0.1 db/updates/update.168.to.200.psql.sql
typo-4.1.1 db/updates/update.168.to.200.psql.sql
typo-4.0.3 db/updates/update.168.to.200.psql.sql
typo-5.0.1 db/updates/update.168.to.200.psql.sql
typo-4.1 db/updates/update.168.to.200.psql.sql
typo-5.0.2 db/updates/update.168.to.200.psql.sql
typo-5.0.3.98.1 db/updates/update.168.to.200.psql.sql