[pLog-CVS] plog/install plog.sql,1.1.1.1,1.2
Brought to you by:
jondaley
Menu
▾
▴
[pLog-CVS] plog/install plog.sql,1.1.1.1,1.2
|
From: <phu...@us...> - 2003-11-19 15:49:58
|
Update of /cvsroot/plog/plog/install
In directory sc8-pr-cvs1:/tmp/cvs-serv23551
Modified Files:
plog.sql
Log Message:
Latest changes from yomcat :)
Index: plog.sql
===================================================================
RCS file: /cvsroot/plog/plog/install/plog.sql,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** plog.sql 24 Oct 2003 13:55:10 -0000 1.1.1.1
--- plog.sql 19 Nov 2003 15:49:54 -0000 1.2
***************
*** 1,12 ****
- -- MySQL dump 8.22
- --
- -- Host: localhost Database: plog_wizard_test
- ---------------------------------------------------------
- -- Server version 3.23.56-log
-
- --
- -- Table structure for table 'plog_articles'
- --
-
CREATE TABLE plog_articles (
id int(10) unsigned NOT NULL auto_increment,
--- 1,2 ----
***************
*** 19,29 ****
status enum('published','draft','deleted') NOT NULL default 'published',
num_reads int(10) default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_articles_categories'
- --
-
CREATE TABLE plog_articles_categories (
id int(10) unsigned NOT NULL auto_increment,
--- 9,16 ----
status enum('published','draft','deleted') NOT NULL default 'published',
num_reads int(10) default '0',
+ properties TEXT default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE plog_articles_categories (
id int(10) unsigned NOT NULL auto_increment,
***************
*** 35,43 ****
) TYPE=MyISAM;
! --
! -- Table structure for table 'plog_articles_comments'
! --
!
! CREATE TABLE plog_articles_comments (
id int(10) unsigned NOT NULL auto_increment,
article_id int(10) unsigned NOT NULL default '0',
--- 22,26 ----
) TYPE=MyISAM;
! CREATE TABLE plog_articles_comments (
id int(10) unsigned NOT NULL auto_increment,
article_id int(10) unsigned NOT NULL default '0',
***************
*** 54,61 ****
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_articles_notifications'
- --
-
CREATE TABLE plog_articles_notifications (
id int(10) NOT NULL auto_increment,
--- 37,40 ----
***************
*** 66,74 ****
) TYPE=MyISAM;
! --
! -- Table structure for table 'plog_blogs'
! --
!
! CREATE TABLE plog_blogs (
id int(10) unsigned NOT NULL auto_increment,
blog varchar(50) NOT NULL default '',
--- 45,49 ----
) TYPE=MyISAM;
! CREATE TABLE plog_blogs (
id int(10) unsigned NOT NULL auto_increment,
blog varchar(50) NOT NULL default '',
***************
*** 79,133 ****
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_config'
- --
-
- CREATE TABLE plog_config (
- id int(10) NOT NULL auto_increment,
- config_key varchar(255) NOT NULL default '',
- config_value text NOT NULL,
- value_type int(3) default '0',
- PRIMARY KEY (id,config_key)
- ) TYPE=MyISAM;
-
- --
- -- Dumping data for table 'plog_config'
- --
-
-
- INSERT INTO plog_config VALUES (1,'comments_enabled','1',2);
- INSERT INTO plog_config VALUES (2,'rdf_enabled','1',2);
- INSERT INTO plog_config VALUES (3,'temp_folder','./tmp',3);
- INSERT INTO plog_config VALUES (4,'base_url','http://home.renalias.net/plog',3);
- INSERT INTO plog_config VALUES (5,'search_enabled','1',2);
- INSERT INTO plog_config VALUES (6,'show_posts_max','15',1);
- INSERT INTO plog_config VALUES (7,'recent_posts_max','10',1);
- INSERT INTO plog_config VALUES (8,'default_template','grey',3);
- INSERT INTO plog_config VALUES (9,'template_folder','./templates',3);
- INSERT INTO plog_config VALUES (10,'default_blog_id','1',1);
- INSERT INTO plog_config VALUES (11,'default_locale','ru_RU',3);
- INSERT INTO plog_config VALUES (12,'html_allowed_tags_in_comments','<a><i><br><br/><b>',3);
- INSERT INTO plog_config VALUES (13,'referer_tracker_enabled','1',2);
- INSERT INTO plog_config VALUES (14,'rss_parser_enabled','1',2);
- INSERT INTO plog_config VALUES (15,'show_more_enabled','1',2);
- INSERT INTO plog_config VALUES (16,'show_more_threshold','150',1);
- INSERT INTO plog_config VALUES (17,'update_article_reads','1',2);
- INSERT INTO plog_config VALUES (18,'email_service_enabled','1',2);
- INSERT INTO plog_config VALUES (19,'post_notification_source_address','no...@no...',3);
- INSERT INTO plog_config VALUES (20,'request_format_mode','1',2);
- INSERT INTO plog_config VALUES (21,'xmlrpc_ping_hosts','a:0:{}',5);
- INSERT INTO plog_config VALUES (22,'trackback_server_enabled','1',2);
- INSERT INTO plog_config VALUES (23,'htmlarea_enabled','1',2);
- INSERT INTO plog_config VALUES (24,'plugin_manager_enabled','1',2);
- INSERT INTO plog_config VALUES (25,'check_email_address_validity','0',2);
- INSERT INTO plog_config VALUES (26,'summary_page_show_max','15',1);
- INSERT INTO plog_config VALUES (27,'minimum_password_length','4',1);
- INSERT INTO plog_config VALUES (29,'templates','a:4:{i:0;s:7:\"default\";i:1;s:4:\"grey\";i:2;s:7:\"grey-sf\";i:3;s:6:\"lemons\";}',5);
- INSERT INTO plog_config VALUES (31,'locales','a:8:{i:0;s:5:\"en_UK\";i:1;s:5:\"es_ES\";i:2;s:5:\"ca_ES\";i:3;s:5:\"it_IT\";i:4;s:5:\"pt_PT\";i:5;s:5:\"ru_RU\";i:6;s:5:\"zh_CN\";i:7;s:5:\"zh_TW\";}',5);
-
- --
- -- Table structure for table 'plog_mylinks'
- --
-
CREATE TABLE plog_mylinks (
id int(10) unsigned NOT NULL auto_increment,
--- 54,57 ----
***************
*** 140,147 ****
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_mylinks_categories'
- --
-
CREATE TABLE plog_mylinks_categories (
id int(10) NOT NULL auto_increment,
--- 64,67 ----
***************
*** 152,159 ****
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_myrecent'
- --
-
CREATE TABLE plog_myrecent (
id int(10) unsigned NOT NULL auto_increment,
--- 72,75 ----
***************
*** 166,173 ****
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_myrecent_categories'
- --
-
CREATE TABLE plog_myrecent_categories (
id int(10) unsigned NOT NULL auto_increment,
--- 82,85 ----
***************
*** 178,185 ****
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_permissions'
- --
-
CREATE TABLE plog_permissions (
id int(10) unsigned NOT NULL auto_increment,
--- 90,93 ----
***************
*** 189,203 ****
) TYPE=MyISAM;
- --
- -- Dumping data for table 'plog_permissions'
- --
-
- INSERT INTO plog_permissions VALUES (1,'ADMINISTRATOR','Gives administration permissions');
- INSERT INTO plog_permissions VALUES (2,'BLOG_USER','Allows non-owners of blogs to have access to a blog');
-
- --
- -- Table structure for table 'plog_referers'
- --
-
CREATE TABLE plog_referers (
id int(10) NOT NULL auto_increment,
--- 97,100 ----
***************
*** 206,217 ****
blog_id int(10) NOT NULL default '0',
hits int(10) default '1',
! last_date timestamp(14) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_trackbacks'
- --
-
CREATE TABLE plog_trackbacks (
id int(10) NOT NULL auto_increment,
--- 103,110 ----
blog_id int(10) NOT NULL default '0',
hits int(10) default '1',
! last_date timestamp(14),
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE plog_trackbacks (
id int(10) NOT NULL auto_increment,
***************
*** 225,235 ****
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_users'
- --
-
CREATE TABLE plog_users (
id int(10) unsigned NOT NULL auto_increment,
! user varchar(15) NOT NULL default '',
password varchar(32) NOT NULL default '',
email varchar(255) NOT NULL default '',
--- 118,124 ----
) TYPE=MyISAM;
CREATE TABLE plog_users (
id int(10) unsigned NOT NULL auto_increment,
! user varchar(15) NOT NULL default '' UNIQUE,
password varchar(32) NOT NULL default '',
email varchar(255) NOT NULL default '',
***************
*** 238,245 ****
) TYPE=MyISAM;
- --
- -- Table structure for table 'plog_users_permissions'
- --
-
CREATE TABLE plog_users_permissions (
id int(10) unsigned NOT NULL auto_increment,
--- 127,130 ----
***************
*** 249,250 ****
--- 134,214 ----
PRIMARY KEY (id)
) TYPE=MyISAM;
+
+
+ CREATE TABLE plog_config (
+ id int(10) NOT NULL auto_increment,
+ config_key varchar(255) NOT NULL default '',
+ config_value text NOT NULL,
+ value_type int(3) default '0',
+ PRIMARY KEY (id,config_key)
+ ) TYPE=MyISAM;
+
+ CREATE TABLE plog_filtered_content (
+ id int(10) NOT NULL auto_increment,
+ reg_exp text,
+ blog_id int(10) NOT NULL default '0',
+ reason text,
+ date timestamp(14) NOT NULL,
+ PRIMARY KEY (id)
+ ) TYPE=MyISAM;
+
+ CREATE TABLE plog_host_blocking_rules (
+ id int(10) NOT NULL auto_increment,
+ reason text,
+ date timestamp(14) NOT NULL,
+ blog_id int(10) NOT NULL default '0',
+ block_type int(1) default '1',
+ list_type int(1) default '1',
+ mask int(2) default '0',
+ host varchar(15) default '0.0.0.0',
+ PRIMARY KEY (id)
+ ) TYPE=MyISAM;
+
+ # These are the config dumps. You'll need to either change these now, or alter, in the Settings Panel.
+
+ INSERT INTO plog_config VALUES (1,'comments_enabled','0',1);
+ INSERT INTO plog_config VALUES (2,'rdf_enabled','1',1);
+ INSERT INTO plog_config VALUES (3,'temp_folder','./tmp',3);
+ INSERT INTO plog_config VALUES (4,'base_url','http://your.host.com/plog',3);
+ INSERT INTO plog_config VALUES (6,'show_posts_max','15',1);
+ INSERT INTO plog_config VALUES (7,'recent_posts_max','10',1);
+ INSERT INTO plog_config VALUES (8,'default_template','grey',3);
+ INSERT INTO plog_config VALUES (9,'template_folder','./templates',3);
+ INSERT INTO plog_config VALUES (10,'default_blog_id','1',1);
+ INSERT INTO plog_config VALUES (11,'default_locale','en_UK',3);
+ INSERT INTO plog_config VALUES (12,'html_allowed_tags_in_comments','<a><i><br><br/><b>',3);
+ INSERT INTO plog_config VALUES (13,'referer_tracker_enabled','1',1);
+ INSERT INTO plog_config VALUES (14,'rss_parser_enabled','1',1);
+ INSERT INTO plog_config VALUES (15,'show_more_enabled','1',1);
+ INSERT INTO plog_config VALUES (16,'show_more_threshold','150',1);
+ INSERT INTO plog_config VALUES (17,'update_article_reads','1',1);
+ INSERT INTO plog_config VALUES (18,'email_service_enabled','1',1);
+ INSERT INTO plog_config VALUES (19,'post_notification_source_address','no...@yo...',3);
+ INSERT INTO plog_config VALUES (20,'request_format_mode','2',1);
+ INSERT INTO plog_config VALUES (21,'xmlrpc_ping_hosts','a:2:{i:0;s:27:\http://rpc.weblogs.com/RPC2\;i:1;s:0:\\;}',5);
+ INSERT INTO plog_config VALUES (22,'trackback_server_enabled','1',1);
+ INSERT INTO plog_config VALUES (23,'htmlarea_enabled','1',1);
+ INSERT INTO plog_config VALUES (24,'plugin_manager_enabled','1',1);
+ INSERT INTO plog_config VALUES (25,'check_email_address_validity','0',1);
+ INSERT INTO plog_config VALUES (26,'summary_page_show_max','15',1);
+ INSERT INTO plog_config VALUES (27,'minimum_password_length','4',1);
+ INSERT INTO plog_config VALUES (29,'templates','a:4:{i:0;s:7:\default\;i:1;s:4:\grey\;i:2;s:7:\grey-sf\;i:3;s:6:\lemons\;}',5);
+ INSERT INTO plog_config VALUES (31,'locales','a:3:{i:0;s:5:\en_UK\;i:1;s:5:\es_ES\;i:2;s:5:\ja_JP\;}',5);
+ INSERT INTO plog_config VALUES (33,'email_service_type','php',3);
+ INSERT INTO plog_config VALUES (34,'smtp_host','your.smtp.host.com',3);
+ INSERT INTO plog_config VALUES (35,'smtp_port','25',1);
+ INSERT INTO plog_config VALUES (36,'smtp_use_authentication','0',1);
+ INSERT INTO plog_config VALUES (37,'smtp_username','',3);
+ INSERT INTO plog_config VALUES (38,'smtp_password','',3);
+ INSERT INTO plog_config VALUES (39,'locale_folder','./locale',3);
+ INSERT INTO plog_config VALUES (40,'xmlrpc_ping_enabled','0',1);
+ INSERT INTO plog_config VALUES (41,'path_to_tar','/bin/tar',3);
+ INSERT INTO plog_config VALUES (42,'path_to_gzip','/bin/gzip',3);
+ INSERT INTO plog_config VALUES (43,'path_to_bz2','/bin/bzip2',3);
+ INSERT INTO plog_config VALUES (44,'path_to_unzip','/bin/unzip',3);
+ INSERT INTO plog_config VALUES (45,'users_can_add_templates','/bin/unzip',3);
+ INSERT INTO plog_config VALUES (46, 'maximum_file_upload_size', 2000000, 1);
+ INSERT INTO plog_config VALUES (47, 'upload_forbidden_files', '*.php *.php3 *.php4 *.phtml', 3);
+ INSERT INTO plog_config VALUES (48, 'comments_order', 1, 1);
+ INSERT INTO plog_config VALUES (49, 'security_pipeline_enabled', 0, 1);
+ INSERT INTO plog_config VALUES (50, 'maximum_comment_size', 0, 1);
\ No newline at end of file
|