|
|
db
DB struktūra
-- Sukurta duomenų struktūra lentelei 'admin_chat'
--
CREATE TABLE admin_chat (
id int(11) NOT NULL auto_increment,
admin varchar(25) collate latin1_general_ci NOT NULL,
msg longtext collate latin1_general_ci NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'balsavimas'
--
CREATE TABLE balsavimas (
id int(11) NOT NULL auto_increment,
info varchar(255) collate latin1_general_ci NOT NULL,
autorius int(11) NOT NULL,
laikas date NOT NULL,
ijungtas varchar(4) collate latin1_general_ci NOT NULL default 'TAIP',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'bugai'
--
CREATE TABLE bugai (
id int(10) unsigned NOT NULL auto_increment,
nickas varchar(45) collate latin1_general_ci NOT NULL,
nicko_id int(10) unsigned NOT NULL,
`data` datetime default '0000-00-00 00:00:00',
bug text collate latin1_general_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'chat_box'
--
CREATE TABLE chat_box (
id int(11) NOT NULL auto_increment,
nikas varchar(150) collate latin1_general_ci NOT NULL,
msg varchar(250) collate latin1_general_ci NOT NULL,
`time` datetime NOT NULL,
niko_id int(11) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY msg (msg)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'codebin'
--
CREATE TABLE codebin (
id int(11) NOT NULL auto_increment,
nick varchar(50) NOT NULL default 'Svecias',
nick_id int(11) NOT NULL default '0',
pav varchar(150) NOT NULL default 'Be pavadinimo',
cod mediumtext NOT NULL,
cat set('PHP','mIRC') NOT NULL default 'PHP',
`data` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id),
KEY pav (pav)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'd_forumai'
--
CREATE TABLE d_forumai (
id int(11) NOT NULL auto_increment,
pav varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'd_straipsniai'
--
CREATE TABLE d_straipsniai (
id int(11) NOT NULL auto_increment,
tid int(11) NOT NULL,
pav varchar(100) collate latin1_general_ci NOT NULL,
last_data datetime NOT NULL,
last_nick varchar(25) collate latin1_general_ci NOT NULL,
autorius varchar(25) collate latin1_general_ci NOT NULL,
uzrakinta varchar(4) collate latin1_general_ci NOT NULL default 'ne',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'd_temos'
--
CREATE TABLE d_temos (
id int(11) NOT NULL auto_increment,
fid int(11) NOT NULL,
pav varchar(100) collate latin1_general_ci NOT NULL,
aprasymas varchar(255) collate latin1_general_ci NOT NULL,
last_data datetime NOT NULL,
last_nick varchar(25) collate latin1_general_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'd_zinute'
--
CREATE TABLE d_zinute (
id int(11) NOT NULL auto_increment,
tid int(11) NOT NULL,
sid int(11) NOT NULL,
nick int(11) NOT NULL,
zinute text collate latin1_general_ci NOT NULL,
laikas datetime NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'f_forumai'
--
CREATE TABLE f_forumai (
id int(10) NOT NULL auto_increment,
kid int(10) NOT NULL,
tid int(10) NOT NULL,
pav varchar(110) NOT NULL,
autorius int(10) NOT NULL,
perziuru int(10) NOT NULL,
uzrakintas enum('taip','ne') NOT NULL default 'ne',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'f_kategorijos'
--
CREATE TABLE f_kategorijos (
id int(11) NOT NULL auto_increment,
pavadinimas varchar(100) NOT NULL,
nr int(2) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'f_temos'
--
CREATE TABLE f_temos (
id int(10) NOT NULL auto_increment,
kid int(10) NOT NULL,
pavadinimas varchar(110) NOT NULL,
apie text,
nr int(10) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'f_zinutes'
--
CREATE TABLE f_zinutes (
id int(10) NOT NULL auto_increment,
tid int(10) NOT NULL,
kid int(10) NOT NULL,
fid int(10) NOT NULL,
sypsenos enum('0','1') NOT NULL default '0',
zinute text NOT NULL,
autorius int(1) NOT NULL,
`data` datetime NOT NULL,
ip int(10) unsigned default NULL,
failas varchar(110) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'kas_prisijunges'
--
CREATE TABLE kas_prisijunges (
id int(11) NOT NULL,
uid varchar(11) collate latin1_general_ci NOT NULL default '',
`timestamp` int(15) NOT NULL default '0',
ip varchar(40) collate latin1_general_ci NOT NULL default '',
`file` varchar(100) collate latin1_general_ci NOT NULL default '',
`user` varchar(100) collate latin1_general_ci default NULL,
ref varchar(100) collate latin1_general_ci default NULL,
clicks float default NULL,
PRIMARY KEY (uid),
KEY ip (ip),
KEY `file` (`file`),
KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'kom'
--
CREATE TABLE kom (
id int(11) NOT NULL auto_increment,
kid int(11) NOT NULL default '0',
pid int(11) NOT NULL default '0',
zinute text NOT NULL,
nick char(50) NOT NULL,
nick_id int(11) NOT NULL default '0',
`data` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'link'
--
CREATE TABLE link (
id int(11) NOT NULL auto_increment,
url varchar(20) collate latin1_general_ci NOT NULL,
pav varchar(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'link_pages'
--
CREATE TABLE link_pages (
id int(11) NOT NULL auto_increment,
pid int(11) NOT NULL,
`char` varchar(1) collate latin1_general_ci NOT NULL,
click int(11) NOT NULL,
pav varchar(200) character set utf8 collate utf8_bin NOT NULL,
`desc` varchar(500) collate latin1_general_ci NOT NULL,
url varchar(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'link_sub'
--
CREATE TABLE link_sub (
sub varchar(20) collate latin1_general_ci NOT NULL,
lid int(11) NOT NULL,
pav varchar(50) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'meniu'
--
CREATE TABLE meniu (
id int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default 'Meniu',
url varchar(100) NOT NULL default '?id,1',
`order` int(11) NOT NULL default '1',
command text,
UNIQUE KEY id (id,url)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'naujienos'
--
CREATE TABLE naujienos (
id int(11) NOT NULL auto_increment,
pavadinimas varchar(100) collate latin1_general_ci NOT NULL,
naujiena mediumtext collate latin1_general_ci NOT NULL,
daugiau text collate latin1_general_ci NOT NULL,
`data` datetime NOT NULL,
autorius varchar(25) collate latin1_general_ci NOT NULL,
kom varchar(4) collate latin1_general_ci NOT NULL default 'taip',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'nuorodos'
--
CREATE TABLE nuorodos (
id int(11) NOT NULL auto_increment,
cat int(3) NOT NULL default '1',
url varchar(200) collate latin1_general_ci NOT NULL default 'http://',
img varchar(200) collate latin1_general_ci NOT NULL,
rank decimal(10,0) NOT NULL default '0',
click int(11) NOT NULL default '0',
nick int(5) NOT NULL,
`date` datetime NOT NULL,
apie varchar(500) collate latin1_general_ci NOT NULL default '...',
PRIMARY KEY (id),
UNIQUE KEY url (url),
KEY apie (apie)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'nustatymai'
--
CREATE TABLE nustatymai (
Pavadinimas varchar(100) collate latin1_general_ci NOT NULL default '',
Apie text collate latin1_general_ci NOT NULL,
Render int(1) NOT NULL default '0',
Copyright varchar(100) collate latin1_general_ci NOT NULL default '',
Pastas varchar(100) collate latin1_general_ci NOT NULL default '',
Registracija enum('0','1') collate latin1_general_ci NOT NULL default '1',
Palaikymas enum('1','0') collate latin1_general_ci NOT NULL default '0',
Maintenance text collate latin1_general_ci NOT NULL,
Chat_limit int(2) NOT NULL default '10'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'panel'
--
CREATE TABLE panel (
id int(11) NOT NULL auto_increment,
panel varchar(100) character set utf8 collate utf8_lithuanian_ci NOT NULL,
`file` varchar(50) collate latin1_general_ci NOT NULL,
place int(11) NOT NULL,
align enum('R','L') collate latin1_general_ci NOT NULL default 'L',
`show` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'php_func'
--
CREATE TABLE php_func (
id int(11) NOT NULL auto_increment,
did int(11) NOT NULL,
pavadinimas varchar(100) collate latin1_general_ci NOT NULL,
aprasymas varchar(100) collate latin1_general_ci NOT NULL,
kodas text collate latin1_general_ci NOT NULL,
autorius varchar(25) collate latin1_general_ci NOT NULL,
`data` date NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY did (did)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'private_msg'
--
CREATE TABLE private_msg (
id int(11) NOT NULL auto_increment,
`from` varchar(25) collate utf8_lithuanian_ci NOT NULL,
`to` varchar(25) collate utf8_lithuanian_ci NOT NULL,
title varchar(100) collate utf8_lithuanian_ci NOT NULL default '...',
msg text collate utf8_lithuanian_ci NOT NULL,
`read` varchar(3) collate utf8_lithuanian_ci NOT NULL default 'NO',
`date` datetime NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'projektai'
--
CREATE TABLE projektai (
id int(11) NOT NULL auto_increment,
pav varchar(100) collate latin1_general_ci NOT NULL,
page varchar(50) collate latin1_general_ci NOT NULL,
rodyti varchar(4) collate latin1_general_ci NOT NULL default 'TAIP',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 's_kategorijos'
--
CREATE TABLE s_kategorijos (
id int(3) NOT NULL auto_increment,
pavadinimas char(100) NOT NULL default 'Be pavadinimo',
apie varchar(300) default '...',
PRIMARY KEY (id),
UNIQUE KEY pavadinimas (pavadinimas)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 's_punktai'
--
CREATE TABLE s_punktai (
id int(11) NOT NULL auto_increment,
pav varchar(255) collate latin1_general_ci NOT NULL,
sid int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 's_temos'
--
CREATE TABLE s_temos (
id int(11) NOT NULL auto_increment,
pav varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'salis'
--
CREATE TABLE salis (
iso char(2) collate latin1_general_ci NOT NULL,
`name` varchar(80) collate latin1_general_ci NOT NULL,
printable_name varchar(80) collate latin1_general_ci NOT NULL,
iso3 char(3) collate latin1_general_ci default NULL,
numcode smallint(6) default NULL,
PRIMARY KEY (iso)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'siuntiniai'
--
CREATE TABLE siuntiniai (
ID int(11) NOT NULL auto_increment,
pavadinimas char(100) default 'Be pavadinimo',
`file` char(100) NOT NULL default 'none.png',
foto text,
apie longtext,
autorius int(6) NOT NULL default '0',
`data` datetime default '0000-00-00 00:00:00',
categorija int(3) default '1',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- DUK lentele
--
CREATE TABLE `duk` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`klausimas` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL ,
`atsakymas` TEXT CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL ,
`order` INT NOT NULL DEFAULT '0'
) ENGINE = MYISAM ;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'straipsniai'
--
CREATE TABLE straipsniai (
id int(11) NOT NULL auto_increment,
pid int(11) NOT NULL,
pav varchar(255) collate latin1_general_ci NOT NULL,
t_text text collate latin1_general_ci NOT NULL,
f_text longtext collate latin1_general_ci NOT NULL,
`date` datetime NOT NULL,
autorius varchar(25) collate latin1_general_ci NOT NULL,
autorius_id int(11) NOT NULL,
vote int(11) NOT NULL,
click int(11) NOT NULL,
rodoma varchar(4) collate latin1_general_ci NOT NULL default 'NE',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei 'users'
--
CREATE TABLE users (
ip int(10) unsigned default NULL,
id int(11) NOT NULL auto_increment,
avatar varchar(100) collate latin1_general_ci NOT NULL default 'images/avatars/no_image.jpg',
nick varchar(15) character set utf8 collate utf8_lithuanian_ci NOT NULL,
levelis int(2) NOT NULL default '1',
pass varchar(32) character set utf8 collate utf8_lithuanian_ci NOT NULL,
email varchar(50) character set utf8 collate utf8_lithuanian_ci NOT NULL,
icq varchar(50) collate latin1_general_ci NOT NULL,
msn varchar(50) collate latin1_general_ci NOT NULL,
skype varchar(50) collate latin1_general_ci NOT NULL,
yahoo varchar(50) collate latin1_general_ci NOT NULL,
aim varchar(50) collate latin1_general_ci NOT NULL,
url varchar(50) collate latin1_general_ci NOT NULL,
salis varchar(3) collate latin1_general_ci NOT NULL,
miestas varchar(20) character set utf8 collate utf8_lithuanian_ci NOT NULL,
vardas varchar(15) collate latin1_general_ci NOT NULL,
pavarde varchar(25) collate latin1_general_ci NOT NULL,
amzius int(2) NOT NULL,
gim_data date NOT NULL,
parasas text collate latin1_general_ci NOT NULL,
forum_temos int(11) NOT NULL default '0',
forum_atsakyta int(11) NOT NULL default '0',
taskai decimal(11,0) NOT NULL default '0',
atsiusta_straipsniu int(11) NOT NULL default '0',
atsiusta_pamoku int(11) NOT NULL default '0',
atsiusta_scriptu int(11) NOT NULL default '0',
atsiusta_naujienu int(11) NOT NULL default '0',
balsai int(11) NOT NULL default '0',
balsavo text collate latin1_general_ci NOT NULL,
pm_viso int(11) NOT NULL default '50',
reg_data datetime NOT NULL,
login_data timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY nick (nick),
UNIQUE KEY email (email)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;Iškart po to įterpkite šiuos duomenis
Sign in to add a comment