Menu
▾
▴
xoops-cvs2
|
From: <ok...@us...> - 2003-01-04 06:15:54
|
Update of /cvsroot/xoops/xoops2/install
In directory sc8-pr-cvs1:/tmp/cvs-serv11301/install
Modified Files:
index.php
Log Message:
column size optimization and fixes
Index: index.php
===================================================================
RCS file: /cvsroot/xoops/xoops2/install/index.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** index.php 2 Jan 2003 15:46:18 -0000 1.1
--- index.php 4 Jan 2003 06:15:51 -0000 1.2
***************
*** 628,634 ****
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix('groups')."` (
! `groupid` int(5) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
! `description` text,
`type` varchar(10) NOT NULL,
PRIMARY KEY (`groupid`),
--- 628,634 ----
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix('groups')."` (
! `groupid` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
! `description` text NOT NULL default '',
`type` varchar(10) NOT NULL,
PRIMARY KEY (`groupid`),
***************
*** 670,675 ****
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix('groups_users_link')."` (
`linkid` int(10) unsigned NOT NULL auto_increment,
! `groupid` int(5) unsigned NOT NULL default '0',
! `uid` int(5) unsigned NOT NULL default '0',
PRIMARY KEY (linkid),
KEY `groupid_uid` (`groupid`,`uid`)
--- 670,675 ----
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix('groups_users_link')."` (
`linkid` int(10) unsigned NOT NULL auto_increment,
! `groupid` smallint(5) unsigned NOT NULL default '0',
! `uid` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (linkid),
KEY `groupid_uid` (`groupid`,`uid`)
***************
*** 703,708 ****
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("groups_modules_link")."` (
linkid int(10) unsigned NOT NULL auto_increment,
! `groupid` int(5) unsigned NOT NULL default '0',
! `itemid` int(5) unsigned NOT NULL default '0',
`permtype` char(1) NOT NULL default '',
PRIMARY KEY (linkid),
--- 703,708 ----
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("groups_modules_link")."` (
linkid int(10) unsigned NOT NULL auto_increment,
! `groupid` smallint(5) unsigned NOT NULL default '0',
! `itemid` smallint(5) unsigned NOT NULL default '0',
`permtype` char(1) NOT NULL default '',
PRIMARY KEY (linkid),
***************
*** 731,736 ****
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("groups_system_link")."` (
linkid int(10) unsigned NOT NULL auto_increment,
! `groupid` int(5) unsigned NOT NULL default '0',
! `itemid` int(5) unsigned NOT NULL default '0',
`permtype` char(1) NOT NULL default '',
PRIMARY KEY (linkid)
--- 731,736 ----
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("groups_system_link")."` (
linkid int(10) unsigned NOT NULL auto_increment,
! `groupid` smallint(5) unsigned NOT NULL default '0',
! `itemid` smallint(5) unsigned NOT NULL default '0',
`permtype` char(1) NOT NULL default '',
PRIMARY KEY (linkid)
***************
*** 863,867 ****
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("modules")."` (
! `mid` int(5) UNSIGNED NOT NULL auto_increment,
`name` varchar(150) NOT NULL default '',
`version` smallint(5) unsigned NOT NULL default '100',
--- 863,867 ----
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("modules")."` (
! `mid` smallint(5) UNSIGNED NOT NULL auto_increment,
`name` varchar(150) NOT NULL default '',
`version` smallint(5) unsigned NOT NULL default '100',
***************
*** 917,922 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('tplfile')." (
! tpl_id int(7) unsigned NOT NULL auto_increment,
! tpl_refid int(5) unsigned NOT NULL default '0',
tpl_module varchar(25) NOT NULL default '',
tpl_themeset varchar(50) NOT NULL default '',
--- 917,922 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('tplfile')." (
! tpl_id mediumint(7) unsigned NOT NULL auto_increment,
! tpl_refid smallint(5) unsigned NOT NULL default '0',
tpl_module varchar(25) NOT NULL default '',
tpl_themeset varchar(50) NOT NULL default '',
***************
*** 942,946 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('tplsource')." (
! tpl_id int(7) unsigned NOT NULL default '0',
tpl_source mediumtext NOT NULL,
KEY tpl_id (tpl_id)
--- 942,946 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('tplsource')." (
! tpl_id mediumint(7) unsigned NOT NULL default '0',
tpl_source mediumtext NOT NULL,
KEY tpl_id (tpl_id)
***************
*** 994,1010 ****
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("newblocks")."` (
! `bid` int(5) UNSIGNED NOT NULL auto_increment,
! `mid` int(5) UNSIGNED NOT NULL default '0',
! `func_num` smallint(5) NOT NULL default '0',
`options` varchar(255) NOT NULL default '',
`name` varchar(150) NOT NULL default '',
title VARCHAR(255) NOT NULL DEFAULT '',
`content` text NOT NULL,
! `side` tinyint(1) NOT NULL default '0',
! `weight` smallint(5) NOT NULL default '0',
! `visible` tinyint(1) NOT NULL default '0',
`type` char(1) NOT NULL default '',
`c_type` char(1) NOT NULL default '',
! `isactive` TINYINT(1) DEFAULT '0' NOT NULL,
dirname VARCHAR(50) NOT NULL DEFAULT '',
func_file VARCHAR(50) NOT NULL DEFAULT '',
--- 994,1010 ----
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("newblocks")."` (
! `bid` mediumint(7) UNSIGNED NOT NULL auto_increment,
! `mid` smallint(5) UNSIGNED NOT NULL default '0',
! `func_num` tinyint(3) unsigned NOT NULL default '0',
`options` varchar(255) NOT NULL default '',
`name` varchar(150) NOT NULL default '',
title VARCHAR(255) NOT NULL DEFAULT '',
`content` text NOT NULL,
! `side` tinyint(1) unsigned NOT NULL default '0',
! `weight` smallint(5) unsigned NOT NULL default '0',
! `visible` tinyint(1) unsigned NOT NULL default '0',
`type` char(1) NOT NULL default '',
`c_type` char(1) NOT NULL default '',
! `isactive` TINYINT(1) unsigned NOT NULL DEFAULT '0',
dirname VARCHAR(50) NOT NULL DEFAULT '',
func_file VARCHAR(50) NOT NULL DEFAULT '',
***************
*** 1036,1041 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix("groups_blocks_link")." (
linkid int(10) unsigned NOT NULL auto_increment,
! groupid int(5) unsigned NOT NULL default '0',
! itemid int(5) unsigned NOT NULL default '0',
permtype char(1) NOT NULL default '',
PRIMARY KEY (linkid),
--- 1036,1041 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix("groups_blocks_link")." (
linkid int(10) unsigned NOT NULL auto_increment,
! groupid smallint(5) unsigned NOT NULL default '0',
! itemid mediumint(8) unsigned NOT NULL default '0',
permtype char(1) NOT NULL default '',
PRIMARY KEY (linkid),
***************
*** 1082,1089 ****
`msg_image` varchar(100) default NULL,
`subject` varchar(100) default NULL,
! `from_userid` int(5) unsigned NOT NULL default '0',
! `to_userid` int(5) unsigned NOT NULL default '0',
`msg_time` int(10) unsigned NOT NULL default '0',
! `msg_text` text,
`read_msg` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`msg_id`),
--- 1082,1089 ----
`msg_image` varchar(100) default NULL,
`subject` varchar(100) default NULL,
! `from_userid` mediumint(8) unsigned NOT NULL default '0',
! `to_userid` mediumint(8) unsigned NOT NULL default '0',
`msg_time` int(10) unsigned NOT NULL default '0',
! `msg_text` text NOT NULL,
`read_msg` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`msg_id`),
***************
*** 1264,1268 ****
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("users")."` (
! `uid` int(5) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`uname` varchar(25) NOT NULL default '',
--- 1264,1268 ----
$result = $xoopsDB->queryF("CREATE TABLE `".$xoopsDB->prefix("users")."` (
! `uid` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`uname` varchar(25) NOT NULL default '',
***************
*** 1270,1296 ****
`url` varchar(100) NOT NULL default '',
`user_avatar` varchar(30) NOT NULL default 'blank.gif',
! `user_regdate` int(10) NOT NULL default '',
! `user_icq` varchar(15) default NULL,
! `user_from` varchar(100) default NULL,
! `user_sig` text,
! `user_viewemail` tinyint(1) NOT NULL default '0',
! `actkey` varchar(8) default NULL,
! `user_aim` varchar(18) default NULL,
! `user_yim` varchar(25) default NULL,
! `user_msnm` varchar(100) default NULL,
`pass` varchar(32) NOT NULL default '',
! `posts` int(8) NOT NULL default '0',
! `attachsig` TINYINT(1) default '0',
! `rank` int(5) NOT NULL default '0',
! `level` int(5) NOT NULL default '1',
`theme` varchar(100) NOT NULL default '',
`timezone_offset` float(3,1) NOT NULL default '0.0',
! `last_login` INT(10) DEFAULT '0' NOT NULL,
`umode` varchar(10) NOT NULL default '',
! `uorder` tinyint(1) NOT NULL default '0',
! `user_occ` varchar(100) default NULL,
! `bio` tinytext NOT NULL,
! `user_intrest` varchar(150) default NULL,
! `user_mailok` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`uid`),
KEY `uname` (`uname`),
--- 1270,1296 ----
`url` varchar(100) NOT NULL default '',
`user_avatar` varchar(30) NOT NULL default 'blank.gif',
! `user_regdate` int(10) unsigned NOT NULL default '0',
! `user_icq` varchar(15) NOT NULL default '',
! `user_from` varchar(100) NOT NULL default '',
! `user_sig` text NOT NULL default '',
! `user_viewemail` tinyint(1) unsigned NOT NULL default '0',
! `actkey` varchar(8) NOT NULL default '',
! `user_aim` varchar(18) NOT NULL default '',
! `user_yim` varchar(25) NOT NULL default '',
! `user_msnm` varchar(100) NOT NULL default '',
`pass` varchar(32) NOT NULL default '',
! `posts` mediumint(8) NOT NULL default '0',
! `attachsig` TINYINT(1) unsigned NOT NULL default '0',
! `rank` smallint(5) unsigned NOT NULL default '0',
! `level` tinyint(3) unsigned NOT NULL default '1',
`theme` varchar(100) NOT NULL default '',
`timezone_offset` float(3,1) NOT NULL default '0.0',
! `last_login` int(10) unsigned NOT NULL DEFAULT '0',
`umode` varchar(10) NOT NULL default '',
! `uorder` tinyint(1) unsigned NOT NULL default '0',
! `user_occ` varchar(100) NOT NULL default '',
! `bio` tinytext NOT NULL default '',
! `user_intrest` varchar(150) NOT NULL default '',
! `user_mailok` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`uid`),
KEY `uname` (`uname`),
***************
*** 1324,1328 ****
$regdate = time();
$dbadminname= $myts->makeTboxData4Save($adminname);
! $result = $xoopsDB->queryF("INSERT INTO ".$xoopsDB->prefix('users')." VALUES (1,'','".$dbadminname."','".$adminmail."','".XOOPS_URL."/','blank.gif','".$regdate."','','','',1,NULL,'','','','".$temp."',0,0,7,5,'xoops','0.0',".time().",'thread',0,'','','',0)");
--- 1324,1328 ----
$regdate = time();
$dbadminname= $myts->makeTboxData4Save($adminname);
! $result = $xoopsDB->queryF("INSERT INTO ".$xoopsDB->prefix('users')." VALUES (1,'','".$dbadminname."','".$adminmail."','".XOOPS_URL."/','blank.gif','".$regdate."','','','',1,'','','','','".$temp."',0,0,7,5,'xoops','0.0',".time().",'thread',0,'','','',0)");
***************
*** 1334,1339 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix("block_module_link")." (
! block_id int(5) unsigned NOT NULL default '0',
! module_id int(5) NOT NULL default '0',
KEY module_id (module_id),
KEY block_id (block_id)
--- 1334,1339 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix("block_module_link")." (
! block_id mediumint(8) unsigned NOT NULL default '0',
! module_id smallint(5) unsigned NOT NULL default '0',
KEY module_id (module_id),
KEY block_id (block_id)
***************
*** 1380,1385 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('config')." (
conf_id smallint(5) unsigned NOT NULL auto_increment,
! conf_modid smallint(3) unsigned NOT NULL default '0',
! conf_catid smallint(3) unsigned NOT NULL default '0',
conf_name varchar(25) NOT NULL default '',
conf_title varchar(30) NOT NULL default '',
--- 1380,1385 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('config')." (
conf_id smallint(5) unsigned NOT NULL auto_increment,
! conf_modid smallint(5) unsigned NOT NULL default '0',
! conf_catid smallint(5) unsigned NOT NULL default '0',
conf_name varchar(25) NOT NULL default '',
conf_title varchar(30) NOT NULL default '',
***************
*** 1475,1481 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('configcategory')." (
! confcat_id smallint(3) NOT NULL auto_increment,
confcat_name varchar(25) NOT NULL default '',
! confcat_order smallint(3) unsigned NOT NULL default '0',
PRIMARY KEY (confcat_id)
) TYPE=MyISAM");
--- 1475,1481 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('configcategory')." (
! confcat_id smallint(5) unsigned NOT NULL auto_increment,
confcat_name varchar(25) NOT NULL default '',
! confcat_order smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (confcat_id)
) TYPE=MyISAM");
***************
*** 1516,1520 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('configoption')." (
! confop_id int(8) unsigned NOT NULL auto_increment,
confop_name varchar(30) NOT NULL default '',
confop_value varchar(50) NOT NULL default '',
--- 1516,1520 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('configoption')." (
! confop_id mediumint(8) unsigned NOT NULL auto_increment,
confop_name varchar(30) NOT NULL default '',
confop_value varchar(50) NOT NULL default '',
***************
*** 1576,1587 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('image')." (
! image_id smallint(5) unsigned NOT NULL auto_increment,
image_name varchar(30) NOT NULL default '',
image_nicename varchar(255) NOT NULL default '',
image_mimetype varchar(30) NOT NULL default '',
image_created int(10) unsigned NOT NULL default '0',
! image_display smallint(5) unsigned NOT NULL default '0',
! image_weight tinyint(1) unsigned NOT NULL default '0',
! imgcat_id smallint(3) unsigned NOT NULL default '0',
PRIMARY KEY (image_id),
KEY imgcat_id (imgcat_id),
--- 1576,1587 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('image')." (
! image_id mediumint(8) unsigned NOT NULL auto_increment,
image_name varchar(30) NOT NULL default '',
image_nicename varchar(255) NOT NULL default '',
image_mimetype varchar(30) NOT NULL default '',
image_created int(10) unsigned NOT NULL default '0',
! image_display tinyint(1) unsigned NOT NULL default '0',
! image_weight smallint(5) unsigned NOT NULL default '0',
! imgcat_id smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (image_id),
KEY imgcat_id (imgcat_id),
***************
*** 1614,1618 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('imagebody')." (
! image_id smallint(5) unsigned NOT NULL default '0',
image_body mediumblob,
KEY image_id (image_id)
--- 1614,1618 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('imagebody')." (
! image_id mediumint(8) unsigned NOT NULL default '0',
image_body mediumblob,
KEY image_id (image_id)
***************
*** 1645,1649 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('imagecategory')." (
! imgcat_id smallint(3) unsigned NOT NULL auto_increment,
imgcat_name varchar(100) NOT NULL default '',
imgcat_maxsize int(8) unsigned NOT NULL default '0',
--- 1645,1649 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('imagecategory')." (
! imgcat_id smallint(5) unsigned NOT NULL auto_increment,
imgcat_name varchar(100) NOT NULL default '',
imgcat_maxsize int(8) unsigned NOT NULL default '0',
***************
*** 1684,1688 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('imgcat_group_link')." (
linkid int(10) NOT NULL auto_increment,
! itemid smallint(3) unsigned NOT NULL default '0',
groupid smallint(5) unsigned NOT NULL default '0',
permtype char(1) NOT NULL default 'R',
--- 1684,1688 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('imgcat_group_link')." (
linkid int(10) NOT NULL auto_increment,
! itemid smallint(5) unsigned NOT NULL default '0',
groupid smallint(5) unsigned NOT NULL default '0',
permtype char(1) NOT NULL default 'R',
***************
*** 1716,1726 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('avatar')." (
! avatar_id smallint(5) unsigned NOT NULL auto_increment,
avatar_file varchar(30) NOT NULL default '',
avatar_name varchar(100) NOT NULL default '',
avatar_mimetype varchar(30) NOT NULL default '',
avatar_created int(10) NOT NULL default '0',
! avatar_display tinyint(1) NOT NULL default '0',
! avatar_weight tinyint(1) NOT NULL default '0',
avatar_type char(1) NOT NULL default '',
PRIMARY KEY (avatar_id),
--- 1716,1726 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('avatar')." (
! avatar_id mediumint(8) unsigned NOT NULL auto_increment,
avatar_file varchar(30) NOT NULL default '',
avatar_name varchar(100) NOT NULL default '',
avatar_mimetype varchar(30) NOT NULL default '',
avatar_created int(10) NOT NULL default '0',
! avatar_display tinyint(1) unsigned NOT NULL default '0',
! avatar_weight smallint(5) unsigned NOT NULL default '0',
avatar_type char(1) NOT NULL default '',
PRIMARY KEY (avatar_id),
***************
*** 1779,1784 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('avatar_user_link')." (
! avatar_id smallint(5) unsigned NOT NULL default '0',
! user_id int(8) unsigned NOT NULL default '0',
KEY avatar_user_id (avatar_id,user_id)
) TYPE=MyISAM");
--- 1779,1784 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('avatar_user_link')." (
! avatar_id mediumint(8) unsigned NOT NULL default '0',
! user_id mediumint(8) unsigned NOT NULL default '0',
KEY avatar_user_id (avatar_id,user_id)
) TYPE=MyISAM");
***************
*** 1800,1804 ****
imgset_id smallint(5) unsigned NOT NULL auto_increment,
imgset_name varchar(50) NOT NULL default '',
! imgset_refid smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (imgset_id),
KEY imgset_refid(imgset_refid)
--- 1800,1804 ----
imgset_id smallint(5) unsigned NOT NULL auto_increment,
imgset_name varchar(50) NOT NULL default '',
! imgset_refid mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (imgset_id),
KEY imgset_refid(imgset_refid)
***************
*** 1818,1822 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('imgsetimg')." (
! imgsetimg_id int(7) unsigned NOT NULL auto_increment,
imgsetimg_file varchar(50) NOT NULL default '',
imgsetimg_body blob NOT NULL,
--- 1818,1822 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('imgsetimg')." (
! imgsetimg_id mediumint(8) unsigned NOT NULL auto_increment,
imgsetimg_file varchar(50) NOT NULL default '',
imgsetimg_body blob NOT NULL,
***************
*** 1861,1865 ****
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('online')." (
! online_uid int(7) unsigned NOT NULL default '0',
online_uname varchar(25) NOT NULL default '',
online_updated int(10) unsigned NOT NULL default '0',
--- 1861,1865 ----
$result = $xoopsDB->queryF("CREATE TABLE ".$xoopsDB->prefix('online')." (
! online_uid mediumint(8) unsigned NOT NULL default '0',
online_uname varchar(25) NOT NULL default '',
online_updated int(10) unsigned NOT NULL default '0',
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X