[geeklog-cvs] Geeklog-1.x/sql mysql_tableanddata.php,1.202,1.203
Dirk Haun
dhaun at qs1489.pair.com
Sat Apr 12 07:48:23 EDT 2008
Update of /cvsroot/geeklog/Geeklog-1.x/sql
In directory qs1489.pair.com:/tmp/cvs-serv32538/sql
Modified Files:
mysql_tableanddata.php
Log Message:
More cosmetics and grouping
Index: mysql_tableanddata.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mysql_tableanddata.php,v
retrieving revision 1.202
retrieving revision 1.203
diff -C2 -d -r1.202 -r1.203
*** mysql_tableanddata.php 12 Apr 2008 11:21:46 -0000 1.202
--- mysql_tableanddata.php 12 Apr 2008 11:48:21 -0000 1.203
***************
*** 18,22 ****
";
! $_SQL[2] = "
CREATE TABLE {$_TABLES['blocks']} (
bid smallint(5) unsigned NOT NULL auto_increment,
--- 18,22 ----
";
! $_SQL[] = "
CREATE TABLE {$_TABLES['blocks']} (
bid smallint(5) unsigned NOT NULL auto_increment,
***************
*** 96,109 ****
$_SQL[] = "
CREATE TABLE {$_TABLES['conf_values']} (
! name varchar(50) default NULL,
! value text,
! type varchar(50) default NULL,
! group_name varchar(50) default NULL,
! default_value text,
! subgroup int(11) default NULL,
! selectionArray int(11) default NULL,
! sort_order int(11) default NULL,
! fieldset int(11) default NULL
! ) TYPE=MyISAM
";
--- 96,109 ----
$_SQL[] = "
CREATE TABLE {$_TABLES['conf_values']} (
! name varchar(50) default NULL,
! value text,
! type varchar(50) default NULL,
! group_name varchar(50) default NULL,
! default_value text,
! subgroup int(11) default NULL,
! selectionArray int(11) default NULL,
! sort_order int(11) default NULL,
! fieldset int(11) default NULL
! ) TYPE=MyISAM
";
***************
*** 126,185 ****
$_SQL[] = "
- CREATE TABLE {$_TABLES['events']} (
- eid varchar(20) NOT NULL default '',
- title varchar(128) default NULL,
- description text,
- postmode varchar(10) NOT NULL default 'plaintext',
- datestart date default NULL,
- dateend date default NULL,
- url varchar(255) default NULL,
- hits mediumint(8) unsigned NOT NULL default '0',
- owner_id mediumint(8) unsigned NOT NULL default '1',
- group_id mediumint(8) unsigned NOT NULL default '1',
- perm_owner tinyint(1) unsigned NOT NULL default '3',
- perm_group tinyint(1) unsigned NOT NULL default '3',
- perm_members tinyint(1) unsigned NOT NULL default '2',
- perm_anon tinyint(1) unsigned NOT NULL default '2',
- address1 varchar(40) default NULL,
- address2 varchar(40) default NULL,
- city varchar(60) default NULL,
- state varchar(40) default NULL,
- zipcode varchar(5) default NULL,
- allday tinyint(1) NOT NULL default '0',
- event_type varchar(40) NOT NULL default '',
- location varchar(128) default NULL,
- timestart time default NULL,
- timeend time default NULL,
- INDEX events_eid(eid),
- INDEX events_event_type(event_type),
- INDEX events_datestart(datestart),
- INDEX events_dateend(dateend),
- PRIMARY KEY (eid)
- ) TYPE=MyISAM
- ";
-
- $_SQL[] = "
- CREATE TABLE {$_TABLES['eventsubmission']} (
- eid varchar(20) NOT NULL default '',
- title varchar(128) default NULL,
- description text,
- location varchar(128) default NULL,
- datestart date default NULL,
- dateend date default NULL,
- url varchar(255) default NULL,
- allday tinyint(1) NOT NULL default '0',
- zipcode varchar(5) default NULL,
- state varchar(40) default NULL,
- city varchar(60) default NULL,
- address2 varchar(40) default NULL,
- address1 varchar(40) default NULL,
- event_type varchar(40) NOT NULL default '',
- timestart time default NULL,
- timeend time default NULL,
- PRIMARY KEY (eid)
- ) TYPE=MyISAM
- ";
-
- $_SQL[] = "
CREATE TABLE {$_TABLES['featurecodes']} (
code tinyint(4) NOT NULL default '0',
--- 126,129 ----
***************
*** 239,272 ****
$_SQL[] = "
- CREATE TABLE {$_TABLES['personal_events']} (
- eid varchar(20) NOT NULL default '',
- title varchar(128) default NULL,
- event_type varchar(40) NOT NULL default '',
- datestart date default NULL,
- dateend date default NULL,
- address1 varchar(40) default NULL,
- address2 varchar(40) default NULL,
- city varchar(60) default NULL,
- state varchar(40) default NULL,
- zipcode varchar(5) default NULL,
- allday tinyint(1) NOT NULL default '0',
- url varchar(255) default NULL,
- description text,
- postmode varchar(10) NOT NULL default 'plaintext',
- owner_id mediumint(8) unsigned NOT NULL default '1',
- group_id mediumint(8) unsigned NOT NULL default '1',
- perm_owner tinyint(1) unsigned NOT NULL default '3',
- perm_group tinyint(1) unsigned NOT NULL default '3',
- perm_members tinyint(1) unsigned NOT NULL default '2',
- perm_anon tinyint(1) unsigned NOT NULL default '2',
- uid mediumint(8) NOT NULL default '0',
- location varchar(128) default NULL,
- timestart time default NULL,
- timeend time default NULL,
- PRIMARY KEY (eid,uid)
- ) TYPE=MyISAM
- ";
-
- $_SQL[] = "
CREATE TABLE {$_TABLES['pingservice']} (
pid smallint(5) unsigned NOT NULL auto_increment,
--- 183,186 ----
***************
*** 430,439 ****
$_SQL[] = "
CREATE TABLE {$_TABLES['tokens']} (
! token varchar(32) NOT NULL,
! created datetime NOT NULL,
! owner_id mediumint(8) unsigned NOT NULL,
! urlfor varchar(2000) NOT NULL,
! ttl mediumint(8) unsigned NOT NULL default '1',
! PRIMARY KEY (token)
) TYPE=MyISAM
";
--- 344,353 ----
$_SQL[] = "
CREATE TABLE {$_TABLES['tokens']} (
! token varchar(32) NOT NULL,
! created datetime NOT NULL,
! owner_id mediumint(8) unsigned NOT NULL,
! urlfor varchar(2000) NOT NULL,
! ttl mediumint(8) unsigned NOT NULL default '1',
! PRIMARY KEY (token)
) TYPE=MyISAM
";
***************
*** 580,583 ****
--- 494,585 ----
// Tables used by the bundled plugins
+ // Calendar plugin
+ $_SQL[] = "
+ CREATE TABLE {$_TABLES['events']} (
+ eid varchar(20) NOT NULL default '',
+ title varchar(128) default NULL,
+ description text,
+ postmode varchar(10) NOT NULL default 'plaintext',
+ datestart date default NULL,
+ dateend date default NULL,
+ url varchar(255) default NULL,
+ hits mediumint(8) unsigned NOT NULL default '0',
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '3',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ address1 varchar(40) default NULL,
+ address2 varchar(40) default NULL,
+ city varchar(60) default NULL,
+ state varchar(40) default NULL,
+ zipcode varchar(5) default NULL,
+ allday tinyint(1) NOT NULL default '0',
+ event_type varchar(40) NOT NULL default '',
+ location varchar(128) default NULL,
+ timestart time default NULL,
+ timeend time default NULL,
+ INDEX events_eid(eid),
+ INDEX events_event_type(event_type),
+ INDEX events_datestart(datestart),
+ INDEX events_dateend(dateend),
+ PRIMARY KEY (eid)
+ ) TYPE=MyISAM
+ ";
+
+ $_SQL[] = "
+ CREATE TABLE {$_TABLES['eventsubmission']} (
+ eid varchar(20) NOT NULL default '',
+ title varchar(128) default NULL,
+ description text,
+ location varchar(128) default NULL,
+ datestart date default NULL,
+ dateend date default NULL,
+ url varchar(255) default NULL,
+ allday tinyint(1) NOT NULL default '0',
+ zipcode varchar(5) default NULL,
+ state varchar(40) default NULL,
+ city varchar(60) default NULL,
+ address2 varchar(40) default NULL,
+ address1 varchar(40) default NULL,
+ event_type varchar(40) NOT NULL default '',
+ timestart time default NULL,
+ timeend time default NULL,
+ PRIMARY KEY (eid)
+ ) TYPE=MyISAM
+ ";
+
+ $_SQL[] = "
+ CREATE TABLE {$_TABLES['personal_events']} (
+ eid varchar(20) NOT NULL default '',
+ title varchar(128) default NULL,
+ event_type varchar(40) NOT NULL default '',
+ datestart date default NULL,
+ dateend date default NULL,
+ address1 varchar(40) default NULL,
+ address2 varchar(40) default NULL,
+ city varchar(60) default NULL,
+ state varchar(40) default NULL,
+ zipcode varchar(5) default NULL,
+ allday tinyint(1) NOT NULL default '0',
+ url varchar(255) default NULL,
+ description text,
+ postmode varchar(10) NOT NULL default 'plaintext',
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '3',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ uid mediumint(8) NOT NULL default '0',
+ location varchar(128) default NULL,
+ timestart time default NULL,
+ timeend time default NULL,
+ PRIMARY KEY (eid,uid)
+ ) TYPE=MyISAM
+ ";
+
+ // Links plugin
$_SQL[] = "
CREATE TABLE {$_TABLES['linkcategories']} (
***************
*** 635,638 ****
--- 637,641 ----
";
+ // Polls plugin
$_SQL[] = "
CREATE TABLE {$_TABLES['pollanswers']} (
***************
*** 693,696 ****
--- 696,700 ----
";
+ // Spam-X plugin
$_SQL[] = "
CREATE TABLE {$_TABLES['spamx']} (
***************
*** 701,704 ****
--- 705,709 ----
";
+ // Static Pages plugin
$_SQL[] = "
CREATE TABLE {$_TABLES['staticpage']} (
***************
*** 736,739 ****
--- 741,745 ----
) TYPE=MyISAM
";
+
$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (1,3) ";
More information about the geeklog-cvs
mailing list