Просмотр архива super

CREATE TABLE `ban_user` (
  `uid` int(10) unsigned NOT NULL default '0',

 `link` varchar(35) NOT NULL default '',
  PRIMARY KEY  (`uid`)
)
TYPE=MyISAM;

CREATE TABLE `count_24` (
  `id` int(10) unsigned NOT NULL
auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `date`
int(10) unsigned NOT NULL default '0',
  `hour` smallint(5) unsigned NOT
NULL default '0',
  `count` int(10) unsigned NOT NULL default '0',
 
`host` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
)
TYPE=MyISAM  ;

CREATE TABLE `hits_ip` (
  `uid` int(10) unsigned NOT
NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `ua`
varchar(255) NOT NULL default 'n/a',
  PRIMARY KEY  (`ip`,`ua`,`uid`)
)
TYPE=MyISAM;

CREATE TABLE `hits_time` (
  `uid` int(10) unsigned NOT
NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
 
PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

CREATE TABLE `models_data` (
 
`ua` varchar(40) NOT NULL default '',
  `vendor` varchar(20) NOT NULL
default 'n/a',
  `model` varchar(20) NOT NULL default 'n/a',
 
`screensize` varchar(7) NOT NULL default 'n/a',
  `bitsperpixel`
smallint(5) unsigned NOT NULL default '0',
  `supportedbearers`
varchar(50) NOT NULL default 'n/a',
  `javaplatform` varchar(50) NOT NULL
default 'n/a',
  `wapversion` varchar(30) NOT NULL default 'n/a',
 
`wmlversion` varchar(30) NOT NULL default 'n/a',
  `wmlscript` varchar(30)
NOT NULL default 'n/a',
  `keyboard` varchar(40) NOT NULL default 'n/a',

 `numsoftkeys` varchar(5) NOT NULL default 'n/a',
  `charset` varchar(50)
NOT NULL default 'n/a',
  `emailschemes` varchar(30) NOT NULL default
'n/a',
  `browserframes` varchar(10) NOT NULL default 'n/a',
 
`browserjavaapplet` varchar(10) NOT NULL default 'n/a',
  `html`
varchar(10) NOT NULL default 'n/a',
  `xhtml` varchar(10) NOT NULL default
'n/a',
  `browsertables` varchar(10) NOT NULL default 'n/a',
  PRIMARY
KEY  (`ua`)
) TYPE=MyISAM;

CREATE TABLE `months` (
  `id` int(10)
unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL
default '0',
  `date` int(10) unsigned NOT NULL default '0',
  `count`
int(10) unsigned NOT NULL default '0',
  `host` int(10) unsigned NOT NULL
default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE
`online_ip` (
  `uid` int(10) unsigned NOT NULL default '0',
  `ip`
varchar(15) NOT NULL default '',
  `time` int(10) unsigned NOT NULL
default '0',
  `browser` varchar(25) NOT NULL default 'unknow',
  PRIMARY
KEY  (`ip`,`uid`)
) TYPE=MyISAM;

CREATE TABLE `superadmin` (
  `id`
int(10) unsigned NOT NULL auto_increment,
  `login` varchar(20) NOT NULL
default '',
  `pass` varchar(50) NOT NULL default '',
  PRIMARY KEY 
(`id`,`login`)
) TYPE=MyISAM;

CREATE TABLE `online_time` (
  `uid`
int(10) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL
default '0',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

CREATE TABLE
`users` (
  `uid` int(10) unsigned NOT NULL auto_increment,
  `site_name`
varchar(50) NOT NULL default '',
  `link` varchar(50) NOT NULL default
'',
  `admin` varchar(30) NOT NULL default '',
  `email` varchar(30) NOT
NULL default '',
  `info` varchar(200) NOT NULL default '',
  `date`
int(10) unsigned NOT NULL default '0',
  `pass` varchar(50) NOT NULL
default '',
  `ncont` varchar(6) NOT NULL default '',
  `type` int(1)
unsigned NOT NULL default '2',
  `typeStat` int(1) unsigned NOT NULL
default '1',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

CREATE TABLE
`weeks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uid`
int(10) unsigned NOT NULL default '0',
  `next_mon` int(10) unsigned NOT
NULL default '0',
  `date` int(10) unsigned NOT NULL default '0',
 
`day_week` smallint(5) unsigned NOT NULL default '0',
  `count` int(10)
unsigned NOT NULL default '0',
  `host` int(10) unsigned NOT NULL default
'0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;