دیتالایف انجین فارسی

CREATE TABLE dle_obmen2 (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `icq` varchar(255) NOT NULL default '',
  `mail` varchar(255) NOT NULL default '',
  `posit` smallint(5) NOT NULL default '1',
  `description` varchar(255) default NULL,
  `bold` char(1) NOT NULL default '',
  `color` varchar(6) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM /*!40101 DEFAULT CHARACTER SET cp1251 COLLATE cp1251_general_ci */;

CREATE TABLE dle_obmen2_setting (
  `id` varchar(5) NOT NULL default '',
  `text` text character set cp1251 NOT NULL,
  `showchecked` varchar(5) NOT NULL default ''
) TYPE=MyISAM /*!40101 DEFAULT CHARACTER SET cp1251 COLLATE cp1251_general_ci */;

CREATE TABLE `dle_linklogo` (
  `id` int(11) NOT NULL auto_increment,
  `logo` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `icq` varchar(255) NOT NULL default '',
  `mail` varchar(255) NOT NULL default '',
  `posit` smallint(5) NOT NULL default '1',
  `description` varchar(255) default NULL,
  `bold` char(1) NOT NULL default '',
  `color` varchar(6) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM /*!40101 DEFAULT CHARACTER SET cp1251 COLLATE cp1251_general_ci */;

CREATE TABLE `dle_linklogo_setting` (
  `id` varchar(5) NOT NULL default '',
  `text` text character set cp1251 NOT NULL,
  `showchecked` varchar(5) NOT NULL default ''
) TYPE=MyISAM /*!40101 DEFAULT CHARACTER SET cp1251 COLLATE cp1251_general_ci */;

CREATE TABLE dle_bazdid2 (
  `ip` varchar(16) NOT NULL default '',
  `last` int(10) unsigned NOT NULL default '0',
  `name` varchar(40) NOT NULL default ''
) ENGINE=MYISAM;

CREATE TABLE dle_bazdid2_week (
  `1` mediumint(8) unsigned NOT NULL default '0',
  `2` mediumint(8) unsigned NOT NULL default '0',
  `3` mediumint(8) unsigned NOT NULL default '0',
  `4` mediumint(8) unsigned NOT NULL default '0',
  `5` mediumint(8) unsigned NOT NULL default '0',
  `6` mediumint(8) unsigned NOT NULL default '0',
  `0` mediumint(8) unsigned NOT NULL default '0',
  `day` enum('1','2','3','4','5','6','0') NOT NULL default '1'
) ENGINE=MYISAM;

CREATE TABLE dle_toplist (
    `id` INT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `name` VARCHAR( 255 ) NOT NULL ,
    `link` VARCHAR( 255 ) NOT NULL ,
    `type` VARCHAR( 255 ) NOT NULL ,
    `icon` VARCHAR( 255 ) NOT NULL,
    `place` INT(3) NOT NULL
    ) ENGINE=MYISAM;

CREATE TABLE dle_online (
    `uid` int(10) unsigned NOT NULL default '0',
    `session` char(32) NOT NULL,
    `lastdate` int(10) unsigned NOT NULL default '0',
    `location` varchar(255) NOT NULL,
    `useragent` char(100) NOT NULL,
    `ip` char(15) default NULL,
    `Pro*xy` char(15) default NULL,
    PRIMARY KEY  (`session`),
    KEY `idx` (`uid`)
    ) ENGINE=MyISAM;

ALTER TABLE dle_usergroups ADD COLUMN group_max_speed varchar( 10 ) DEFAULT '0'";

ALTER TABLE dle_post ADD COLUMN metatitle VARCHAR(255) not null;

ALTER TABLE dle_usergroups ADD admin_addnews TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_editnews TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_comments TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_categories TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_editusers TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_wordfilter TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_xfields TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_userfields TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_static TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_editvote TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_newsletter TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_blockip TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_banners TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_rss TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_iptools TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_rssinform TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE dle_usergroups ADD admin_googlemap TINYINT( 1 ) NOT NULL DEFAULT '0';

UPDATE dle_usergroups SET admin_addnews='1', admin_editnews='1', admin_comments='1', admin_categories='1', admin_editusers='1', admin_wordfilter='1', admin_xfields='1', admin_userfields='1', admin_static='1', admin_editvote='1', admin_newsletter='1', admin_blockip='1', admin_banners='1', admin_rss='1', admin_iptools='1', admin_rssinform='1', admin_googlemap='1', admin_sql='1', admin_filemanager='1' WHERE id='1';
UPDATE dle_usergroups SET admin_addnews='1', admin_editnews='1', admin_wordfilter='1' WHERE id='2';
UPDATE dle_usergroups SET admin_addnews='1', admin_editnews='1' WHERE id='3';