CREATE TABLE pw_dowannounce (
  id int(10) unsigned NOT NULL auto_increment,
  subject text NOT NULL,
  content text NOT NULL,
  time int(10) unsigned NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM;

INSERT INTO pw_dowannounce (id, subject, content, time) VALUES (1, 'wӨ̱M~U', 'wӨ̱M~U!', '$timestamp');

CREATE TABLE pw_downloads (
  id int(10) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL,
  username varchar(50) NOT NULL,
  sofname varchar(255) NOT NULL,
  catidname varchar(100) NOT NULL,
  catname int(10) unsigned NOT NULL,
  addstar int(10) unsigned NOT NULL,
  addsizest int(10) NOT NULL,
  addsizend varchar(3) NOT NULL,
  addlang int(20) NOT NULL,
  addedition int(20) NOT NULL,
  addhold varchar(100) NOT NULL,
  addurl varchar(100) NOT NULL,
  addos1 varchar(20) NOT NULL,
  addos2 varchar(20) NOT NULL,
  addos3 varchar(20) NOT NULL,
  addos4 varchar(20) NOT NULL,
  addos5 varchar(20) NOT NULL,
  addos6 varchar(20) NOT NULL,
  addos7 varchar(20) NOT NULL,
  imageurl varchar(150) NOT NULL,
  imageupl varchar(150) NOT NULL,
  imagname varchar(255) NOT NULL,
  imagsize varchar(255) NOT NULL,
  attche int(8) NOT NULL,
  buytype varchar(100) NOT NULL,
  money int(10) unsigned NOT NULL,
  content text NOT NULL,
  digeht int(1) NOT NULL,
  recommend int(1) NOT NULL,
  fraction int(10) NOT NULL,
  userlog varchar(255) NOT NULL,
  hit int(20) unsigned NOT NULL,
  chack int(2) NOT NULL,
  top int(2) NOT NULL,
  lockid int(2) NOT NULL,
  dowguest int(2) NOT NULL,
  time int(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;

CREATE TABLE pw_dowattach (
  aid mediumint(10) unsigned NOT NULL auto_increment,
  tid mediumint(10) unsigned NOT NULL,
  uid int(10) unsigned NOT NULL,
  name char(255) NOT NULL,
  path char(255) NOT NULL,
  type char(20) NOT NULL,
  dtime int(10) unsigned NOT NULL,
  hits mediumint(8) unsigned NOT NULL,
  size int(10) unsigned NOT NULL,
  PRIMARY KEY  (aid)
) ENGINE=MyISAM;

CREATE TABLE pw_dowdata (
  fid smallint(6) unsigned NOT NULL auto_increment,
  fup smallint(6) unsigned NOT NULL default '0',
  childid tinyint(1) NOT NULL default '0',
  type enum('category','forum','sub') NOT NULL default 'category',
  name char(50) NOT NULL default '',
  vieworder tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (fid),
  KEY fup (fup),
  KEY `type` (vieworder,fup)
) ENGINE=MyISAM;

CREATE TABLE pw_dowreply (
  tid int(10) unsigned NOT NULL,
  aid int(11) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL,
  username char(20) NOT NULL default '',
  content text NOT NULL,
  userlog char(100) NOT NULL default '',
  ipfrom char(100) NOT NULL default '',
  time int(11) NOT NULL,
  KEY aid (aid)
) ENGINE=MyISAM;


CREATE TABLE pw_dowlinks (
  pid int(10) unsigned NOT NULL auto_increment,
  tid int(10) NOT NULL,
  uid int(10) unsigned NOT NULL,
  addtxt mediumtext NOT NULL,
  addattache varchar(255) NOT NULL,
  PRIMARY KEY  (pid)
) ENGINE=MyISAM;


INSERT INTO pw_dowdata (fid, fup, childid, type, name, vieworder) VALUES 
(1, 0, 1, 'category', 'tΤu', 0),
(2, 0, 1, 'category', 'u{', 0),
(3, 0, 1, 'category', 's', 0),
(4, 0, 1, 'category', 'wPp', 0),
(5, 0, 1, 'category', '', 0),
(6, 0, 1, 'category', 'Ϥu', 0),
(7, 0, 1, 'category', 'ୱu', 0),
(8, 0, 1, 'category', 'v', 0),
(9, 0, 1, 'category', '֬', 0),
(10, 0, 1, 'category', 'hC', 0),
(11, 0, 1, 'category', 's{}o', 0),
(12, 0, 1, 'category', 'CT', 0),
(13, 0, 1, 'category', 'L', 0),
(14, 1, 0, 'forum', 'h@~t', 0),
(15, 1, 0, 'forum', '۰ʱƵ{', 0),
(16, 1, 0, 'forum', 'tΥ[t', 0),
(17, 1, 0, 'forum', 'tδ', 0),
(18, 1, 0, 'forum', 'tκʴ', 0),
(19, 1, 0, 'forum', 'tνվ', 0),
(20, 1, 0, 'forum', 't٭', 0),
(21, 1, 0, 'forum', 'jƮį', 0),
(22, 1, 0, 'forum', 'n鲾', 0),
(23, 1, 0, 'forum', 'n', 0),
(24, 1, 0, 'forum', 'Lnץ', 0),
(25, 1, 0, 'forum', 'ʱ', 0),
(26, 2, 0, 'forum', '/X', 0),
(27, 2, 0, 'forum', 'ƥu', 0),
(28, 2, 0, 'forum', 'qlѻs@', 0),
(29, 2, 0, 'forum', 'ϺФu', 0),
(30, 2, 0, 'forum', 'ϺвMz', 0),
(31, 2, 0, 'forum', 'Y/Y', 0),
(32, 2, 0, 'forum', 'ɦW', 0),
(33, 2, 0, 'forum', 'ɮ׺޲z', 0),
(34, 2, 0, 'forum', 'ɮ٭', 0),
(35, 2, 0, 'forum', 'ɤu', 0),
(36, 3, 0, 'forum', 'FirefoxXRM', 0),
(37, 3, 0, 'forum', 'hy', 0),
(38, 3, 0, 'forum', 'Һ޲z', 0),
(39, 3, 0, 'forum', 's', 0),
(40, 3, 0, 'forum', 'Lo', 0),
(41, 3, 0, 'forum', 'siLo', 0),
(42, 3, 0, 'forum', 'Lu', 0),
(43, 3, 0, 'forum', 's~', 0),
(44, 3, 0, 'forum', '½Ķn', 0),
(45, 3, 0, 'forum', 'us', 0),
(46, 4, 0, 'forum', '[Ku', 0),
(47, 4, 0, 'forum', 's', 0),
(48, 4, 0, 'forum', 'w@', 0),
(49, 4, 0, 'forum', 'tκʵ', 0),
(50, 4, 0, 'forum', '', 0),
(51, 4, 0, 'forum', 'rn', 0),
(52, 4, 0, 'forum', 'S쨾r', 0),
(53, 4, 0, 'forum', 'fru', 0),
(54, 4, 0, 'forum', 'frX', 0),
(55, 4, 0, 'forum', 'KX޲z', 0),
(56, 4, 0, 'forum', 'ҵ{', 0),
(57, 4, 0, 'forum', 'pO@', 0),
(58, 5, 0, 'forum', 'FTPΤ', 0),
(59, 5, 0, 'forum', 'IPu', 0),
(60, 5, 0, 'forum', 'BBS', 0),
(61, 5, 0, 'forum', '@ɳsu', 0),
(62, 5, 0, 'forum', 'yC', 0),
(63, 5, 0, 'forum', 'YɳqT~', 0),
(64, 5, 0, 'forum', '[u', 0),
(65, 5, 0, 'forum', '', 0),
(66, 5, 0, 'forum', 'ɮפ', 0),
(67, 5, 0, 'forum', 'ǤU', 0),
(68, 6, 0, 'forum', '3Dø', 0),
(69, 6, 0, 'forum', 'pϥܤu', 0),
(70, 6, 0, 'forum', '~o', 0),
(71, 6, 0, 'forum', 'qϺ޲z', 0),
(72, 6, 0, 'forum', 'ʵes@', 0),
(73, 6, 0, 'forum', 'vBz', 0),
(74, 6, 0, 'forum', 'v', 0),
(75, 6, 0, 'forum', 'Ʀ۾u', 0),
(76, 6, 0, 'forum', 'Ʀï', 0),
(77, 6, 0, 'forum', 'ù^', 0),
(78, 6, 0, 'forum', 'u', 0),
(79, 6, 0, 'forum', 'øϬ', 0),
(80, 7, 0, 'forum', 'ICONϮw', 0),
(81, 7, 0, 'forum', 'GDD', 0),
(82, 7, 0, 'forum', '/xa', 0),
(83, 7, 0, 'forum', '६', 0),
(84, 7, 0, 'forum', 'ୱpN', 0),
(85, 7, 0, 'forum', 'ୱKQK', 0),
(86, 7, 0, 'forum', 'ୱϮw', 0),
(87, 7, 0, 'forum', 'ୱ', 0),
(88, 7, 0, 'forum', 'ƹ', 0),
(89, 7, 0, 'forum', 'ùO@', 0),
(90, 8, 0, 'forum', 'DVD', 0),
(91, 8, 0, 'forum', 'DVD', 0),
(92, 8, 0, 'forum', 'MPEG', 0),
(93, 8, 0, 'forum', 'ru', 0),
(94, 8, 0, 'forum', 'vu', 0),
(95, 8, 0, 'forum', 'v', 0),
(96, 8, 0, 'forum', 'vX', 0),
(97, 8, 0, 'forum', 'v', 0),
(98, 8, 0, 'forum', 'vs', 0),
(99, 8, 0, 'forum', 'v', 0),
(100, 9, 0, 'forum', 'MIDI', 0),
(101, 9, 0, 'forum', 'MP3u', 0),
(102, 9, 0, 'forum', 'MP3', 0),
(103, 9, 0, 'forum', 'MP3', 0),
(104, 9, 0, 'forum', 'y', 0),
(105, 9, 0, 'forum', 'ĮĪG', 0),
(106, 9, 0, 'forum', 'ֳЧ@', 0),
(107, 9, 0, 'forum', 'ֺ޲z', 0),
(108, 9, 0, 'forum', 'ּ', 0),
(109, 9, 0, 'forum', 'ֽs', 0),
(110, 9, 0, 'forum', '', 0),
(111, 9, 0, 'forum', 'yu', 0),
(112, 9, 0, 'forum', '{', 0),
(113, 10, 0, 'forum', 'dOK', 0),
(114, 10, 0, 'forum', '~{', 0),
(115, 10, 0, 'forum', 'hCu', 0),
(116, 10, 0, 'forum', 'hC޲z', 0),
(117, 10, 0, 'forum', 'hC鼽', 0),
(118, 10, 0, 'forum', 'hC', 0),
(119, 10, 0, 'forum', 'v^', 0),
(120, 10, 0, 'forum', 'ҽs', 0),
(121, 10, 0, 'forum', 'sX/ѽXu', 0),
(122, 11, 0, 'forum', 'Ƥu', 0),
(123, 11, 0, 'forum', '', 0),
(124, 11, 0, 'forum', '[/', 0),
(125, 11, 0, 'forum', 'w/{s@', 0),
(126, 11, 0, 'forum', 'n}oM', 0),
(127, 11, 0, 'forum', '{lX', 0),
(128, 11, 0, 'forum', '{s', 0),
(129, 11, 0, 'forum', 'q]p', 0),
(130, 11, 0, 'forum', 'ɻs@', 0),
(131, 11, 0, 'forum', 'U]p', 0),
(132, 12, 0, 'forum', 'PC C', 0),
(133, 12, 0, 'forum', 'ɯ/ץ', 0),
(134, 12, 0, 'forum', 'Cu', 0),
(135, 12, 0, 'forum', 'CAu', 0),
(136, 12, 0, 'forum', 'C', 0),
(137, 12, 0, 'forum', 'uWC', 0),
(138, 13, 0, 'forum', 'Ln', 0),
(139, 13, 0, 'forum', 'LlX', 0),
(140, 13, 0, 'forum', 'Lӷ~n', 0);
