Просмотр архива Конструктор сайтов MOBRUS.RU

#
# Table structure for table admins
#

CREATE TABLE `admins` (
  `Id`
int(6) unsigned NOT NULL auto_increment,
  `login` varchar(50) default
NULL,
  `password` varchar(50) default NULL,
  PRIMARY KEY  (`Id`)
)
TYPE=MyISAM;

#
# Dumping data for table admins
#

INSERT INTO `admins`
VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3');

#
# Table structure
for table advertising_links
#

CREATE TABLE `advertising_links` (
  `Id`
int(6) unsigned NOT NULL auto_increment,
  `name` varchar(255) default
NULL,
  `url` varchar(255) default NULL,
  PRIMARY KEY  (`Id`)
)
TYPE=MyISAM;

#
# Table structure for table config
#

CREATE TABLE `config`
(
  `id` int(6) unsigned NOT NULL default '0',
  `block_limit` int(4) NOT
NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Table structure
for table counter
#

CREATE TABLE `counter` (
  `id` int(6) unsigned NOT
NULL default '0',
  `today` int(4) NOT NULL default '0',
  `total` int(4)
NOT NULL default '0',
  `last_date` date NOT NULL default '0000-00-00',
 
PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Table structure for table
counter_ips
#

CREATE TABLE `counter_ips` (
  `id` int(6) unsigned NOT NULL
default '0',
  `ip` char(15) NOT NULL default '',
  `last_date` date NOT
NULL default '0000-00-00',
  PRIMARY KEY  (`id`,`ip`)
) TYPE=MyISAM;

#
#
Table structure for table guest_book
#

CREATE TABLE `guest_book` (
  `id`
int(6) unsigned NOT NULL auto_increment,
  `name` varchar(255) default
NULL,
  `email` varchar(255) default NULL,
  `text` text,
  `date` datetime
default NULL,
  `user_id` int(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY
`user_id` (`user_id`)
) TYPE=MyISAM;

#
# Table structure for table
links
#

CREATE TABLE `links` (
  `id` int(6) unsigned NOT NULL
auto_increment,
  `name` varchar(255) default NULL,
  `url` varchar(255)
default NULL,
  `user_id` int(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY
`user_id` (`user_id`)
) TYPE=MyISAM;

#
# Table structure for table
news
#

CREATE TABLE `news` (
  `id` int(6) unsigned NOT NULL
auto_increment,
  `text` text,
  `date` datetime default NULL,
  `user_id`
int(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
)
TYPE=MyISAM;

#
# Table structure for table polls_answers
#

CREATE TABLE
`polls_answers` (
  `qid` int(10) unsigned NOT NULL default '0',
  `aid`
int(10) unsigned NOT NULL default '0',
  `answer` varchar(255) NOT NULL
default '',
  `votes` int(10) unsigned NOT NULL default '0',
  KEY `pid`
(`qid`)
) TYPE=MyISAM;

#
# Table structure for table
polls_questions
#

CREATE TABLE `polls_questions` (
  `id` int(10) unsigned
NOT NULL auto_increment,
  `question` varchar(250) NOT NULL default '',
 
`date` datetime default NULL,
  `user_id` int(6) default NULL,
  PRIMARY
KEY  (`id`),
  KEY `user_id` (`user_id`)
) TYPE=MyISAM;

#
# Table
structure for table users
#

CREATE TABLE `users` (
  `id` int(11) NOT NULL
auto_increment,
  `login` varchar(50) NOT NULL default '',
  `password`
varchar(50) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',

 `surname` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL
default '',
  `banner` enum('top','bottom','none') NOT NULL default 'top',

 `active` enum('0','1') NOT NULL default '1',
  `block_date` datetime NOT
NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;