[php-blog-cvs] serendipity/sql db.sql,NONE,1.1 db_update_0.2_0.3_mysql.sql,NONE,1.1 db_update_0.2_0.3_pqsql.sql,NONE,1.1 db_update_0.3_0.4_mysql.sql,NONE,1.1 db_update_0.3_0.4_pgsql.sql,NONE,1.1 db_update_0.5_0.5.1_mysql.sql,NONE,1.1 db_update_0.5_0.5.1_pgsql.sql,NONE,1.1

[<tom...@us...>]

Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8914

Added Files:
	db.sql db_update_0.2_0.3_mysql.sql db_update_0.2_0.3_pqsql.sql 
	db_update_0.3_0.4_mysql.sql db_update_0.3_0.4_pgsql.sql 
	db_update_0.5_0.5.1_mysql.sql db_update_0.5_0.5.1_pgsql.sql 
Log Message:
Move SQL files, now seperate files for mysql and pqsql, to their own folder (called "sql")


--- NEW FILE: db.sql ---
#
# Table structure for table '{PREFIX}authors'
#

create table {PREFIX}authors (
  username varchar(20) default null,
  password varchar(32) default null,
  authorid {AUTOINCREMENT} {PRIMARY},
  mail_comments int(1) default '1',
  mail_trackbacks int(1) default '1',
  email varchar(128) not null default ''
);

#
# table structure for table '{PREFIX}comments'
#

create table {PREFIX}comments (
  id {AUTOINCREMENT} {PRIMARY},
  entry_id int(10) {UNSIGNED} not null default '0',
  timestamp int(10) {UNSIGNED} default null,
  title varchar(150) default null,
  author varchar(80) default null,
  email varchar(200) default null,
  url varchar(200) default null,
  ip varchar(15) default null,
  body text,
  type varchar(100) default 'regular',
  subscribed {BOOLEAN}
);

CREATE {FULLTEXT} INDEX body on {PREFIX}comments (body);

#
# table structure for table '{PREFIX}entries'
#

create table {PREFIX}entries (
  id {AUTOINCREMENT} {PRIMARY},
  title varchar(200) default null,
  timestamp int(10) {UNSIGNED} default null,
  body text,
  comments int(4) {UNSIGNED} default '0',
  trackbacks int(4) {UNSIGNED} default '0',
  extended text,
  exflag int(1) default null,
  author varchar(20) default null,
  authorid int(11) default null,
  categoryid int(11) default null,
  isdraft {BOOLEAN},
  allow_comments {BOOLEAN},
  last_modified int(10) {UNSIGNED} default null
);

CREATE {FULLTEXT} INDEX entry on {PREFIX}entries (title,body,extended);

#
# table structure for table '{PREFIX}references'
#

create table {PREFIX}references (
  id {AUTOINCREMENT} {PRIMARY},
  entry_id int(10) {UNSIGNED} not null default '0',
  link text,
  name text
);

#
# Table structure for table '{PREFIX}exits'
#

CREATE TABLE {PREFIX}exits (
  entry_id {AUTOINCREMENT},
  day date NOT NULL,
  count int(11) NOT NULL default '0',
  scheme varchar(5),
  host varchar(128) NOT NULL,
  port varchar(5),
  path varchar(255),
  query varchar(255),
  PRIMARY KEY  (host,day,entry_id)
);

#
# Table structure for table '{PREFIX}referrers'
#

CREATE TABLE {PREFIX}referrers (
  entry_id {AUTOINCREMENT},
  day date NOT NULL,
  count int(11) NOT NULL default '0',
  scheme varchar(5),
  host varchar(128) NOT NULL,
  port varchar(5),
  path varchar(255),
  query varchar(255),
  PRIMARY KEY  (host,day,entry_id)
);

#
# Table structure for table 'serendipity_css'
#

CREATE TABLE {PREFIX}css (
  cssid {AUTOINCREMENT} {PRIMARY},
  name varchar(40) default NULL,
  data text
);

#
# Table structure for table 'serendipity_config'
#

create table {PREFIX}config (
  name varchar(255) not null primary key,
  value text not null
);

CREATE TABLE {PREFIX}suppress (
  ip varchar(15) default NULL,
  scheme varchar(5),
  host varchar(128),
  port varchar(5),
  path varchar(255),
  query varchar(255),
  last timestamp NOT NULL
);

CREATE unique INDEX url on {PREFIX}suppress (host, ip);

CREATE TABLE {PREFIX}plugins (
  name varchar(128) not null,
  placement varchar(6) not null default 'right',
  sort_order int(4) not null default '0',
  PRIMARY KEY(name)
);

CREATE TABLE {PREFIX}category (
  categoryid {AUTOINCREMENT} {PRIMARY},
  category_name varchar(255) default NULL,
  category_description text,
  authorid int(11) default NULL
);

CREATE TABLE {PREFIX}images (
  id {AUTOINCREMENT} {PRIMARY},
  name varchar(255) not null default '',
  extension varchar(5) not null default '',
  mime varchar(15) not null default '',
  size int(11) not null default '0',
  dimensions_width int(11) not null default '0',
  dimensions_height int(11) not null default '0',
  date int(11) not null default '0'
);

--- NEW FILE: db_update_0.2_0.3_mysql.sql ---
ALTER TABLE serendipity_entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER `comments`;

ALTER TABLE serendipity_entries ADD COLUMN isdraft ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER `categoryid`;

ALTER TABLE serendipity_comments ADD COLUMN subscribed ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER `type`;

INSERT INTO serendipity_config (name, value) VALUES ('allowSubscriptions', 'false');

INSERT INTO serendipity_config (name, value) VALUES ('template', 'default');

INSERT INTO serendipity_config (name, value) VALUES ('embed', 'false');

INSERT INTO serendipity_config (name, value) VALUES ('indexFile', 'index.php');

INSERT INTO serendipity_config (name, value) VALUES ('blockReferer', ';');

INSERT INTO serendipity_config (name, value) VALUES ('XHTML11', 'false'); 

--- NEW FILE: db_update_0.2_0.3_pqsql.sql ---
ALTER TABLE serendipity_entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER `comments`;

ALTER TABLE serendipity_entries ADD COLUMN isdraft BOOLEAN NOT NULL FALSE AFTER `categoryid`;

ALTER TABLE serendipity_comments ADD COLUMN subscribed BOOLEAN NOT NULL AFTER `type`;

INSERT INTO serendipity_config (name, value) VALUES ('allowSubscriptions', 'false');

INSERT INTO serendipity_config (name, value) VALUES ('template', 'default');

INSERT INTO serendipity_config (name, value) VALUES ('embed', 'false');

INSERT INTO serendipity_config (name, value) VALUES ('indexFile', 'index.php');

INSERT INTO serendipity_config (name, value) VALUES ('blockReferer', ';');

INSERT INTO serendipity_config (name, value) VALUES ('XHTML11', 'false'); 

--- NEW FILE: db_update_0.3_0.4_mysql.sql ---
ALTER TABLE serendipity_entries ADD COLUMN allow_comments ENUM('true', 'false') NOT NULL DEFAULT 'true' AFTER isdraft;

--- NEW FILE: db_update_0.3_0.4_pgsql.sql ---
ALTER TABLE serendipity_entries ADD COLUMN allow_comments BOOLEAN NOT NULL TRUE AFTER isdraft;

--- NEW FILE: db_update_0.5_0.5.1_mysql.sql ---
CREATE TABLE `s9ytest_images` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `extension` varchar(5) NOT NULL default '',
  `mime` varchar(15) NOT NULL default '',
  `size` int(11) NOT NULL default '0',
  `dimensions_width` int(11) NOT NULL default '0',
  `dimensions_height` int(11) NOT NULL default '0',
  `thumbnail_name` varchar(255) NOT NULL default '',
  `date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;


ALTER TABLE s9ytest_entries ADD last_modified INT(10) UNSIGNED default null;
CREATE INDEX timestamp ON s9ytest_entries (timestamp);
CREATE INDEX last_modified ON s9ytest_entries (last_modified);
UPDATE s9ytest_entries SET last_modified = timestamp;

INSERT INTO s9ytest_plugins(name, placement, sort_order) VALUES ('serendipity_event_nl2br:39979424fea674e78399659e67edaf12', 'event', 10);
INSERT INTO s9ytest_plugins(name, placement, sort_order) VALUES ('serendipity_event_s9ymarkup:fdd8bf23ff500827cf76d7d31957d3c8', 'event', 11);
INSERT INTO s9ytest_plugins(name, placement, sort_order) VALUES ('serendipity_event_emoticate:e30b433546aa10a632b0d703ebe1aa29', 'event', 12);
INSERT INTO s9ytest_plugins(name, placement, sort_order) VALUES ('serendipity_event_trackexits:25e6d8eb7d662936abb6454956aaa8ab', 'event', 13);

--- NEW FILE: db_update_0.5_0.5.1_pgsql.sql ---
CREATE TABLE serendipity_images (
  id SERIAL primary key,
  name varchar(255) NOT NULL default '',
  extension varchar(5) NOT NULL default '',
  mime varchar(15) NOT NULL default '',
  size int NOT NULL default '0',
  dimensions_width int NOT NULL default '0',
  dimensions_height int NOT NULL default '0',
  thumbnail_name varchar(255) NOT NULL default '',
  date int NOT NULL default '0'
);

UPDATE serendipity_plugins
   SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite')
 WHERE name LIKE '%serendipity_plugin_content_rewrite%';

UPDATE serendipity_config
   SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite')
 WHERE name LIKE '%serendipity_plugin_content_rewrite%';
 
UPDATE serendipity_plugins
   SET placement = 'event'
 WHERE name LIKE '%serendipity_event_contentrewrite%';
 
ALTER TABLE serendipity_entries ADD last_modified INT UNSIGNED default null;

CREATE INDEX timestamp ON serendipity_entries (timestamp);
CREATE INDEX last_modified ON serendipity_entries (last_modified);
UPDATE serendipity_entries SET last_modified = timestamp;

INSERT INTO serendipity_plugins(name, placement, sort_order) VALUES ('serendipity_event_nl2br:39979424fea674e78399659e67edaf12', 'event', 10);
INSERT INTO serendipity_plugins(name, placement, sort_order) VALUES ('serendipity_event_s9ymarkup:fdd8bf23ff500827cf76d7d31957d3c8', 'event', 11);
INSERT INTO serendipity_plugins(name, placement, sort_order) VALUES ('serendipity_event_emoticate:e30b433546aa10a632b0d703ebe1aa29', 'event', 12);
INSERT INTO serendipity_plugins(name, placement, sort_order) VALUES ('serendipity_event_trackexits:25e6d8eb7d662936abb6454956aaa8ab', 'event', 13);