| 1 |
# MySQL dump 7.1 |
| 2 |
# |
| 3 |
# Host: localhost Database: nuke |
| 4 |
#-------------------------------------------------------- |
| 5 |
# Server version 3.22.32 |
| 6 |
|
| 7 |
# |
| 8 |
# Table structure for table 'adminblock' |
| 9 |
# |
| 10 |
CREATE TABLE adminblock ( |
| 11 |
title varchar(60), |
| 12 |
content text |
| 13 |
); |
| 14 |
|
| 15 |
# |
| 16 |
# Dumping data for table 'adminblock' |
| 17 |
# |
| 18 |
|
| 19 |
INSERT INTO adminblock VALUES ('Administration','Admins can have its own box, but just one. Who need more?<br>\r\nAdd the options you like. This box will appear only if you\r\nhas been logged like Admin. No others users can view this.<br>\r\n<li><a href=admin.php>Administration</a>\r\n<li><a href=admin.php?op=logout>Logout</a>'); |
| 20 |
|
| 21 |
# |
| 22 |
# Table structure for table 'authors' |
| 23 |
# |
| 24 |
CREATE TABLE authors ( |
| 25 |
aid varchar(30) DEFAULT '' NOT NULL, |
| 26 |
name varchar(50), |
| 27 |
url varchar(60), |
| 28 |
email varchar(60), |
| 29 |
pwd varchar(13), |
| 30 |
counter int(11) DEFAULT '0' NOT NULL, |
| 31 |
PRIMARY KEY (aid) |
| 32 |
); |
| 33 |
|
| 34 |
# |
| 35 |
# Dumping data for table 'authors' |
| 36 |
# |
| 37 |
|
| 38 |
INSERT INTO authors VALUES ('God','God','http://www.ncc.org.ve/php-nuke.php3','http://www.ncc.org.ve/php-nuke.php3','Password',1); |
| 39 |
|
| 40 |
# |
| 41 |
# Table structure for table 'banner' |
| 42 |
# |
| 43 |
CREATE TABLE banner ( |
| 44 |
bid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 45 |
cid int(11) DEFAULT '0' NOT NULL, |
| 46 |
imptotal int(11) DEFAULT '0' NOT NULL, |
| 47 |
impmade int(11) DEFAULT '0' NOT NULL, |
| 48 |
clicks int(11) DEFAULT '0' NOT NULL, |
| 49 |
imageurl varchar(100) DEFAULT '' NOT NULL, |
| 50 |
clickurl varchar(200) DEFAULT '' NOT NULL, |
| 51 |
date datetime, |
| 52 |
PRIMARY KEY (bid) |
| 53 |
); |
| 54 |
|
| 55 |
# |
| 56 |
# Dumping data for table 'banner' |
| 57 |
# |
| 58 |
|
| 59 |
|
| 60 |
# |
| 61 |
# Table structure for table 'bannerclient' |
| 62 |
# |
| 63 |
CREATE TABLE bannerclient ( |
| 64 |
cid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 65 |
name varchar(60) DEFAULT '' NOT NULL, |
| 66 |
contact varchar(60) DEFAULT '' NOT NULL, |
| 67 |
email varchar(60) DEFAULT '' NOT NULL, |
| 68 |
login varchar(10) DEFAULT '' NOT NULL, |
| 69 |
passwd varchar(10) DEFAULT '' NOT NULL, |
| 70 |
extrainfo text NOT NULL, |
| 71 |
PRIMARY KEY (cid) |
| 72 |
); |
| 73 |
|
| 74 |
# |
| 75 |
# Dumping data for table 'bannerclient' |
| 76 |
# |
| 77 |
|
| 78 |
|
| 79 |
# |
| 80 |
# Table structure for table 'bannerfinish' |
| 81 |
# |
| 82 |
CREATE TABLE bannerfinish ( |
| 83 |
bid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 84 |
cid int(11) DEFAULT '0' NOT NULL, |
| 85 |
impressions int(11) DEFAULT '0' NOT NULL, |
| 86 |
clicks int(11) DEFAULT '0' NOT NULL, |
| 87 |
datestart datetime, |
| 88 |
dateend datetime, |
| 89 |
PRIMARY KEY (bid) |
| 90 |
); |
| 91 |
|
| 92 |
# |
| 93 |
# Dumping data for table 'bannerfinish' |
| 94 |
# |
| 95 |
|
| 96 |
|
| 97 |
# |
| 98 |
# Table structure for table 'comments' |
| 99 |
# |
| 100 |
CREATE TABLE comments ( |
| 101 |
tid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 102 |
pid int(11) DEFAULT '0', |
| 103 |
sid int(11) DEFAULT '0', |
| 104 |
date datetime, |
| 105 |
name varchar(60) DEFAULT '' NOT NULL, |
| 106 |
email varchar(60), |
| 107 |
url varchar(60), |
| 108 |
host_name varchar(60), |
| 109 |
subject varchar(60) DEFAULT '' NOT NULL, |
| 110 |
comment text NOT NULL, |
| 111 |
score tinyint(4) DEFAULT '0' NOT NULL, |
| 112 |
reason tinyint(4) DEFAULT '0' NOT NULL, |
| 113 |
PRIMARY KEY (tid) |
| 114 |
); |
| 115 |
|
| 116 |
# |
| 117 |
# Dumping data for table 'comments' |
| 118 |
# |
| 119 |
|
| 120 |
INSERT INTO comments VALUES (1,0,1,'2000-09-23 12:00:00','','','','150.10.10.10','Re: Welcome to PHP-Nuke 2.5','FIRST COMMENT!\r<br>\n\r<br>\nAll my life I wanted to do this ;)',0,0); |
| 121 |
|
| 122 |
# |
| 123 |
# Table structure for table 'counter' |
| 124 |
# |
| 125 |
CREATE TABLE counter ( |
| 126 |
type varchar(80) DEFAULT '' NOT NULL, |
| 127 |
var varchar(80) DEFAULT '' NOT NULL, |
| 128 |
count int(10) unsigned DEFAULT '0' NOT NULL |
| 129 |
); |
| 130 |
|
| 131 |
# |
| 132 |
# Dumping data for table 'counter' |
| 133 |
# |
| 134 |
|
| 135 |
INSERT INTO counter VALUES ('browser','WebTV',0); |
| 136 |
INSERT INTO counter VALUES ('browser','Lynx',0); |
| 137 |
INSERT INTO counter VALUES ('browser','MSIE',0); |
| 138 |
INSERT INTO counter VALUES ('browser','Opera',0); |
| 139 |
INSERT INTO counter VALUES ('browser','Konqueror',0); |
| 140 |
INSERT INTO counter VALUES ('total','hits',2); |
| 141 |
INSERT INTO counter VALUES ('browser','Netscape',1); |
| 142 |
INSERT INTO counter VALUES ('os','Linux',1); |
| 143 |
INSERT INTO counter VALUES ('browser','Bot',0); |
| 144 |
INSERT INTO counter VALUES ('browser','Other',1); |
| 145 |
INSERT INTO counter VALUES ('os','Windows',0); |
| 146 |
INSERT INTO counter VALUES ('os','Mac',0); |
| 147 |
INSERT INTO counter VALUES ('os','FreeBSD',0); |
| 148 |
INSERT INTO counter VALUES ('os','SunOS',0); |
| 149 |
INSERT INTO counter VALUES ('os','IRIX',0); |
| 150 |
INSERT INTO counter VALUES ('os','BeOS',0); |
| 151 |
INSERT INTO counter VALUES ('os','OS/2',0); |
| 152 |
INSERT INTO counter VALUES ('os','AIX',0); |
| 153 |
INSERT INTO counter VALUES ('os','Other',1); |
| 154 |
|
| 155 |
# |
| 156 |
# Table structure for table 'ephem' |
| 157 |
# |
| 158 |
CREATE TABLE ephem ( |
| 159 |
eid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 160 |
did int(2) DEFAULT '0' NOT NULL, |
| 161 |
mid int(2) DEFAULT '0' NOT NULL, |
| 162 |
yid int(4) DEFAULT '0' NOT NULL, |
| 163 |
content text NOT NULL, |
| 164 |
PRIMARY KEY (eid) |
| 165 |
); |
| 166 |
|
| 167 |
# |
| 168 |
# Dumping data for table 'ephem' |
| 169 |
# |
| 170 |
|
| 171 |
|
| 172 |
# |
| 173 |
# Table structure for table 'lblocks' |
| 174 |
# |
| 175 |
CREATE TABLE lblocks ( |
| 176 |
id tinyint(4) DEFAULT '0' NOT NULL auto_increment, |
| 177 |
title varchar(60), |
| 178 |
content text, |
| 179 |
PRIMARY KEY (id) |
| 180 |
); |
| 181 |
|
| 182 |
# |
| 183 |
# Dumping data for table 'lblocks' |
| 184 |
# |
| 185 |
|
| 186 |
INSERT INTO lblocks VALUES (1,'First Left Block','You can add/remove/edit blocks for your site with PHP-Nuke.\r\nAlso you can add HTML commands like <a href=http://www.ncc.org.ve/php-nuke.php3>links</a>, <b>Bold</b> text, images, etc.\r\nJust use you imagination.'); |
| 187 |
INSERT INTO lblocks VALUES (2,'Special Sections','What about a <a href=sections.php>Special Sections</a>option in the PHP-Nuke code? A place to publish reviews, special articles, interviews, or whatever, independent of the main news.'); |
| 188 |
|
| 189 |
# |
| 190 |
# Table structure for table 'links_categories' |
| 191 |
# |
| 192 |
CREATE TABLE links_categories ( |
| 193 |
cid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 194 |
title varchar(50) DEFAULT '' NOT NULL, |
| 195 |
PRIMARY KEY (cid) |
| 196 |
); |
| 197 |
|
| 198 |
# |
| 199 |
# Dumping data for table 'links_categories' |
| 200 |
# |
| 201 |
|
| 202 |
|
| 203 |
# |
| 204 |
# Table structure for table 'links_links' |
| 205 |
# |
| 206 |
CREATE TABLE links_links ( |
| 207 |
lid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 208 |
cid int(11) DEFAULT '0' NOT NULL, |
| 209 |
sid int(11) DEFAULT '0' NOT NULL, |
| 210 |
title varchar(100) DEFAULT '' NOT NULL, |
| 211 |
url varchar(100) DEFAULT '' NOT NULL, |
| 212 |
description text NOT NULL, |
| 213 |
date datetime, |
| 214 |
name varchar(60) DEFAULT '' NOT NULL, |
| 215 |
email varchar(60) DEFAULT '' NOT NULL, |
| 216 |
hits int(11) DEFAULT '0' NOT NULL, |
| 217 |
PRIMARY KEY (lid) |
| 218 |
); |
| 219 |
|
| 220 |
# |
| 221 |
# Dumping data for table 'links_links' |
| 222 |
# |
| 223 |
|
| 224 |
|
| 225 |
# |
| 226 |
# Table structure for table 'links_newlink' |
| 227 |
# |
| 228 |
CREATE TABLE links_newlink ( |
| 229 |
lid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 230 |
cid int(11) DEFAULT '0' NOT NULL, |
| 231 |
sid int(11) DEFAULT '0' NOT NULL, |
| 232 |
title varchar(100) DEFAULT '' NOT NULL, |
| 233 |
url varchar(100) DEFAULT '' NOT NULL, |
| 234 |
description text NOT NULL, |
| 235 |
name varchar(60) DEFAULT '' NOT NULL, |
| 236 |
email varchar(60) DEFAULT '' NOT NULL, |
| 237 |
PRIMARY KEY (lid) |
| 238 |
); |
| 239 |
|
| 240 |
# |
| 241 |
# Dumping data for table 'links_newlink' |
| 242 |
# |
| 243 |
|
| 244 |
|
| 245 |
# |
| 246 |
# Table structure for table 'links_subcategories' |
| 247 |
# |
| 248 |
CREATE TABLE links_subcategories ( |
| 249 |
sid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 250 |
cid int(11) DEFAULT '0' NOT NULL, |
| 251 |
title varchar(50) DEFAULT '' NOT NULL, |
| 252 |
PRIMARY KEY (sid) |
| 253 |
); |
| 254 |
|
| 255 |
# |
| 256 |
# Dumping data for table 'links_subcategories' |
| 257 |
# |
| 258 |
|
| 259 |
|
| 260 |
# |
| 261 |
# Table structure for table 'mainblock' |
| 262 |
# |
| 263 |
CREATE TABLE mainblock ( |
| 264 |
title varchar(60), |
| 265 |
content text |
| 266 |
); |
| 267 |
|
| 268 |
# |
| 269 |
# Dumping data for table 'mainblock' |
| 270 |
# |
| 271 |
|
| 272 |
INSERT INTO mainblock VALUES ('Main Menu','<li><a href=index.php>Home</a>\r\n<li><a href=topics.php>Topics</a>\r\n<li><a href=sections.php>Sections</a>\r\n<li><a href=links.php>Web Links</a>\r\n<li><a href=user.php>Your Account</a>\r\n<li><a href=submit.php>Submit News</a>\r\n<li><a href=stats.php>Stats</a>\r\n<li><a href=top.php>Top 10</a>\r\n<li><a href=faq.php>FAQ</a>'); |
| 273 |
|
| 274 |
# |
| 275 |
# Table structure for table 'poll_data' |
| 276 |
# |
| 277 |
CREATE TABLE poll_data ( |
| 278 |
pollID int(11) DEFAULT '0' NOT NULL, |
| 279 |
optionText char(50) DEFAULT '' NOT NULL, |
| 280 |
optionCount int(11) DEFAULT '0' NOT NULL, |
| 281 |
voteID int(11) DEFAULT '0' NOT NULL |
| 282 |
); |
| 283 |
|
| 284 |
# |
| 285 |
# Dumping data for table 'poll_data' |
| 286 |
# |
| 287 |
|
| 288 |
INSERT INTO poll_data VALUES (1,'Ummmm, not bad',0,1); |
| 289 |
INSERT INTO poll_data VALUES (1,'Cool',0,2); |
| 290 |
INSERT INTO poll_data VALUES (1,'Terrific',0,3); |
| 291 |
INSERT INTO poll_data VALUES (1,'The best one!',0,4); |
| 292 |
INSERT INTO poll_data VALUES (1,'what the hell is this?',0,5); |
| 293 |
INSERT INTO poll_data VALUES (1,'',0,6); |
| 294 |
INSERT INTO poll_data VALUES (1,'',0,7); |
| 295 |
INSERT INTO poll_data VALUES (1,'',0,8); |
| 296 |
INSERT INTO poll_data VALUES (1,'',0,9); |
| 297 |
INSERT INTO poll_data VALUES (1,'',0,10); |
| 298 |
INSERT INTO poll_data VALUES (1,'',0,11); |
| 299 |
INSERT INTO poll_data VALUES (1,'',0,12); |
| 300 |
|
| 301 |
# |
| 302 |
# Table structure for table 'poll_desc' |
| 303 |
# |
| 304 |
CREATE TABLE poll_desc ( |
| 305 |
pollID int(11) DEFAULT '0' NOT NULL auto_increment, |
| 306 |
pollTitle char(100) DEFAULT '' NOT NULL, |
| 307 |
timeStamp int(11) DEFAULT '0' NOT NULL, |
| 308 |
voters mediumint(9) DEFAULT '0' NOT NULL, |
| 309 |
PRIMARY KEY (pollID) |
| 310 |
); |
| 311 |
|
| 312 |
# |
| 313 |
# Dumping data for table 'poll_desc' |
| 314 |
# |
| 315 |
|
| 316 |
INSERT INTO poll_desc VALUES (1,'What do you think about PHP-Nuke?',961405160,0); |
| 317 |
|
| 318 |
# |
| 319 |
# Table structure for table 'pollcomments' |
| 320 |
# |
| 321 |
CREATE TABLE pollcomments ( |
| 322 |
tid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 323 |
pid int(11) DEFAULT '0', |
| 324 |
pollID int(11) DEFAULT '0', |
| 325 |
date datetime, |
| 326 |
name varchar(60) DEFAULT '' NOT NULL, |
| 327 |
email varchar(60), |
| 328 |
url varchar(60), |
| 329 |
host_name varchar(60), |
| 330 |
subject varchar(60) DEFAULT '' NOT NULL, |
| 331 |
comment text NOT NULL, |
| 332 |
score tinyint(4) DEFAULT '0' NOT NULL, |
| 333 |
reason tinyint(4) DEFAULT '0' NOT NULL, |
| 334 |
PRIMARY KEY (tid) |
| 335 |
); |
| 336 |
|
| 337 |
# |
| 338 |
# Dumping data for table 'pollcomments' |
| 339 |
# |
| 340 |
|
| 341 |
|
| 342 |
# |
| 343 |
# Table structure for table 'queue' |
| 344 |
# |
| 345 |
CREATE TABLE queue ( |
| 346 |
qid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment, |
| 347 |
uid mediumint(9) DEFAULT '0' NOT NULL, |
| 348 |
uname varchar(40) DEFAULT '' NOT NULL, |
| 349 |
subject varchar(100) DEFAULT '' NOT NULL, |
| 350 |
story text, |
| 351 |
timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, |
| 352 |
topic varchar(20) DEFAULT 'Linux' NOT NULL, |
| 353 |
PRIMARY KEY (qid) |
| 354 |
); |
| 355 |
|
| 356 |
# |
| 357 |
# Dumping data for table 'queue' |
| 358 |
# |
| 359 |
|
| 360 |
|
| 361 |
# |
| 362 |
# Table structure for table 'quotes' |
| 363 |
# |
| 364 |
CREATE TABLE quotes ( |
| 365 |
qid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, |
| 366 |
quote text, |
| 367 |
PRIMARY KEY (qid) |
| 368 |
); |
| 369 |
|
| 370 |
# |
| 371 |
# Dumping data for table 'quotes' |
| 372 |
# |
| 373 |
|
| 374 |
INSERT INTO quotes VALUES (1,'Nos morituri te salutamus - CBHS'); |
| 375 |
|
| 376 |
# |
| 377 |
# Table structure for table 'rblocks' |
| 378 |
# |
| 379 |
CREATE TABLE rblocks ( |
| 380 |
id tinyint(4) DEFAULT '0' NOT NULL auto_increment, |
| 381 |
title varchar(60), |
| 382 |
content text, |
| 383 |
PRIMARY KEY (id) |
| 384 |
); |
| 385 |
|
| 386 |
# |
| 387 |
# Dumping data for table 'rblocks' |
| 388 |
# |
| 389 |
|
| 390 |
INSERT INTO rblocks VALUES (1,'First Right Block','You can add/remove/edit blocks for your site with PHP-Nuke.\r\nAlso you can add HTML commands like <a href=http://www.ncc.org.ve/php-nuke.php3>links</a>, <b>Bold</b> text, images, etc.\r\nJust use you imagination.'); |
| 391 |
INSERT INTO rblocks VALUES (2,'Information','<center>\r\nSite made with:<br>\r\n<a href=http://www.ncc.org.ve/php-nuke.php3><img src=images/powered/phpnuke.gif border=0></a><br>\r\n'); |
| 392 |
|
| 393 |
# |
| 394 |
# Table structure for table 'referer' |
| 395 |
# |
| 396 |
CREATE TABLE referer ( |
| 397 |
rid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 398 |
url varchar(100) DEFAULT '' NOT NULL, |
| 399 |
PRIMARY KEY (rid) |
| 400 |
); |
| 401 |
|
| 402 |
# |
| 403 |
# Dumping data for table 'referer' |
| 404 |
# |
| 405 |
|
| 406 |
|
| 407 |
# |
| 408 |
# Table structure for table 'seccont' |
| 409 |
# |
| 410 |
CREATE TABLE seccont ( |
| 411 |
artid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 412 |
secid int(11) DEFAULT '0' NOT NULL, |
| 413 |
title text NOT NULL, |
| 414 |
content text NOT NULL, |
| 415 |
counter int(11) DEFAULT '0' NOT NULL, |
| 416 |
PRIMARY KEY (artid) |
| 417 |
); |
| 418 |
|
| 419 |
# |
| 420 |
# Dumping data for table 'seccont' |
| 421 |
# |
| 422 |
|
| 423 |
|
| 424 |
# |
| 425 |
# Table structure for table 'sections' |
| 426 |
# |
| 427 |
CREATE TABLE sections ( |
| 428 |
secid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 429 |
secname varchar(40) DEFAULT '' NOT NULL, |
| 430 |
image varchar(50) DEFAULT '' NOT NULL, |
| 431 |
PRIMARY KEY (secid) |
| 432 |
); |
| 433 |
|
| 434 |
# |
| 435 |
# Dumping data for table 'sections' |
| 436 |
# |
| 437 |
|
| 438 |
|
| 439 |
# |
| 440 |
# Table structure for table 'stories' |
| 441 |
# |
| 442 |
CREATE TABLE stories ( |
| 443 |
sid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 444 |
aid varchar(30) DEFAULT '' NOT NULL, |
| 445 |
title varchar(80), |
| 446 |
time datetime, |
| 447 |
hometext text, |
| 448 |
bodytext text NOT NULL, |
| 449 |
comments int(11) DEFAULT '0', |
| 450 |
counter mediumint(8) unsigned, |
| 451 |
topic int(2) DEFAULT '1' NOT NULL, |
| 452 |
informant varchar(20) DEFAULT '' NOT NULL, |
| 453 |
notes text NOT NULL, |
| 454 |
PRIMARY KEY (sid) |
| 455 |
); |
| 456 |
|
| 457 |
# |
| 458 |
# Dumping data for table 'stories' |
| 459 |
# |
| 460 |
|
| 461 |
INSERT INTO stories VALUES (1,'god','Welcome to PHP-Nuke!!!','2000-09-22 12:00:00','This is the first article in PHP-Nuke. You can delete it. Remember to set/change nickname and/or password for the main admin user. There aren\'t any registered/default user, so maybe you want to set the first one. Pelase read carefully the README file for some details, CREDITS files to see from where comes the things and remember that this is free software under the GPL License (COPYING file for details). Hope you enjoy this software. Please report any bug you find, and you\'ll for sure, so drop me an email when one of this annoying things happens and I\'ll try to fix it for the next releases.','',1,1,10,'god',''); |
| 462 |
|
| 463 |
# |
| 464 |
# Table structure for table 'topics' |
| 465 |
# |
| 466 |
CREATE TABLE topics ( |
| 467 |
topicid int(2) DEFAULT '0' NOT NULL auto_increment, |
| 468 |
topicname varchar(20), |
| 469 |
topicimage varchar(20), |
| 470 |
topictext varchar(40), |
| 471 |
counter int(11) DEFAULT '0' NOT NULL, |
| 472 |
PRIMARY KEY (topicid) |
| 473 |
); |
| 474 |
|
| 475 |
# |
| 476 |
# Dumping data for table 'topics' |
| 477 |
# |
| 478 |
|
| 479 |
INSERT INTO topics VALUES (1,'linux','linux.gif','Linux',0); |
| 480 |
INSERT INTO topics VALUES (2,'amd','amd.gif','AMD',0); |
| 481 |
INSERT INTO topics VALUES (3,'aol','aol.jpg','America Online',0); |
| 482 |
INSERT INTO topics VALUES (4,'caldera','caldera.gif','Caldera Systems',0); |
| 483 |
INSERT INTO topics VALUES (5,'apple','mac.gif','Apple / Mac',0); |
| 484 |
INSERT INTO topics VALUES (6,'beos','beos.gif','BeOS',0); |
| 485 |
INSERT INTO topics VALUES (7,'compaq','compaq.gif','Compaq',0); |
| 486 |
INSERT INTO topics VALUES (8,'corel','corel.gif','Corel',0); |
| 487 |
INSERT INTO topics VALUES (9,'debian','debian.gif','Debian',0); |
| 488 |
INSERT INTO topics VALUES (10,'phpnuke','phpnuke.gif','PHP-Nuke',0); |
| 489 |
INSERT INTO topics VALUES (11,'freebsd','freebsd.gif','FreeBSD',0); |
| 490 |
INSERT INTO topics VALUES (12,'gimp','gimp.gif','GIMP',0); |
| 491 |
INSERT INTO topics VALUES (13,'gnome','gnome.gif','GNOME',0); |
| 492 |
INSERT INTO topics VALUES (14,'gnu','gnu.jpg','GNU / GPL',0); |
| 493 |
INSERT INTO topics VALUES (15,'hp','hp.gif','Hewlett Packard',0); |
| 494 |
INSERT INTO topics VALUES (16,'ibm','ibm.gif','IBM',0); |
| 495 |
INSERT INTO topics VALUES (17,'intel','intel.gif','Intel',0); |
| 496 |
INSERT INTO topics VALUES (18,'java','java.gif','Java',0); |
| 497 |
INSERT INTO topics VALUES (19,'kde','kde.gif','KDE',0); |
| 498 |
INSERT INTO topics VALUES (20,'mandrake','mandrake.gif','Mandrake',0); |
| 499 |
INSERT INTO topics VALUES (21,'microsoft','microsoft.gif','Microsoft',0); |
| 500 |
INSERT INTO topics VALUES (22,'mozilla','mozilla.gif','Mozilla',0); |
| 501 |
INSERT INTO topics VALUES (23,'netscape','netscape.gif','Netscape',0); |
| 502 |
INSERT INTO topics VALUES (24,'perl','perl.gif','Perl',0); |
| 503 |
INSERT INTO topics VALUES (25,'redhat','redhat.gif','Red Hat',0); |
| 504 |
INSERT INTO topics VALUES (26,'sgi','sgi.gif','Silicon Graphics',0); |
| 505 |
INSERT INTO topics VALUES (27,'sun','sun.gif','Sun Microsystems',0); |
| 506 |
INSERT INTO topics VALUES (28,'suse','suse.gif','SuSE',0); |
| 507 |
INSERT INTO topics VALUES (29,'x','x.jpg','X Window',0); |
| 508 |
|
| 509 |
# |
| 510 |
# Table structure for table 'users' |
| 511 |
# |
| 512 |
CREATE TABLE users ( |
| 513 |
uid int(11) DEFAULT '0' NOT NULL auto_increment, |
| 514 |
name varchar(60) DEFAULT '' NOT NULL, |
| 515 |
uname varchar(25) DEFAULT '' NOT NULL, |
| 516 |
email varchar(60) DEFAULT '' NOT NULL, |
| 517 |
femail varchar(60) DEFAULT '' NOT NULL, |
| 518 |
url varchar(100) DEFAULT '' NOT NULL, |
| 519 |
pass varchar(20) DEFAULT '' NOT NULL, |
| 520 |
storynum tinyint(4) DEFAULT '10' NOT NULL, |
| 521 |
umode varchar(10) DEFAULT '' NOT NULL, |
| 522 |
uorder tinyint(1) DEFAULT '0' NOT NULL, |
| 523 |
thold tinyint(1) DEFAULT '0' NOT NULL, |
| 524 |
noscore tinyint(1) DEFAULT '0' NOT NULL, |
| 525 |
bio tinytext NOT NULL, |
| 526 |
ublockon tinyint(1) DEFAULT '0' NOT NULL, |
| 527 |
ublock tinytext NOT NULL, |
| 528 |
theme varchar(255) DEFAULT '' NOT NULL, |
| 529 |
commentmax int(11) DEFAULT '4096' NOT NULL, |
| 530 |
counter int(11) DEFAULT '0' NOT NULL, |
| 531 |
PRIMARY KEY (uid) |
| 532 |
); |
| 533 |
|
| 534 |
# |
| 535 |
# Dumping data for table 'users' |
| 536 |
# |
| 537 |
|
| 538 |
|
Parent Directory
| 
Revision Log