View file base.sql

File size: 2.79Kb
CREATE TABLE IF NOT EXISTS `ban` (
`id` int(255) NOT NULL auto_increment,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`why` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `forum` (
`id` int(255) NOT NULL auto_increment,
`name` text collate utf8_unicode_ci NOT NULL,
`msg` text collate utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`open` int(1) NOT NULL default '1',
`up` int(1) NOT NULL,
`razdel` int(255) NOT NULL default '0',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `forum_komm` (
`id` int(255) NOT NULL auto_increment,
`msg` text collate utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`theme` int(255) NOT NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `forum_t` (
`id` int(255) NOT NULL auto_increment,
`name` text collate utf8_unicode_ci NOT NULL,
`opis` text collate utf8_unicode_ci NOT NULL,
`razdel` int(15) NOT NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `guestbook` (
`id` int(255) NOT NULL auto_increment,
`user` int(255) NOT NULL,
`msg` varchar(512) collate utf8_unicode_ci default '-',
`time` int(255) NOT NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `jurnal` (
`id` int(255) NOT NULL auto_increment,
`time` int(255) NOT NULL,
`msg` text collate utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`read` int(1) NOT NULL default '0',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `mail` (
`id` int(255) NOT NULL auto_increment,
`from` int(255) NOT NULL,
`to` int(255) NOT NULL,
`msg` text collate utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`read` int(1) NOT NULL default '0',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `user` (
`id` int(255) NOT NULL auto_increment,
`name` varchar(15) collate utf8_unicode_ci NOT NULL,
`pass` text collate utf8_unicode_ci NOT NULL,
`reg` int(255) NOT NULL,
`gorod` text collate utf8_unicode_ci NOT NULL,
`email` text collate utf8_unicode_ci NOT NULL,
`tel` varchar(11) collate utf8_unicode_ci NOT NULL,
`tsel` text collate utf8_unicode_ci NOT NULL,
`zhel` text collate utf8_unicode_ci NOT NULL,
`aname` text collate utf8_unicode_ci NOT NULL,
`click` int(255) NOT NULL,
`admin` int(1) NOT NULL default '0',
`pol` int(1) NOT NULL default '1',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;