
CREATE TABLE `pw_flash` (
 `id` int(11) unsigned NOT NULL auto_increment,
 `cid` smallint(8) NOT NULL default '0',
 `nkflash` varchar(200) NOT NULL,
 `title` varchar(100) NOT NULL default '',
 `star` smallint(2) NOT NULL default '0',
 `price` int(11) NOT NULL default '0',
 `intro` text NOT NULL,
 `ename` text NOT NULL,
 `image` text NOT NULL,
 `path` text NOT NULL,
 `imageurl` varchar(255) NOT NULL default '',
 `pathurl` varchar(255) NOT NULL default '',
 `uluid` int(10) NOT NULL default '0',
 `uluser` varchar(50) NOT NULL default '',
 `ultime` int(10) NOT NULL default '0',
 `hits` int(10) unsigned NOT NULL default '0',
 `chack` int(2) NOT NULL default '0',
 `fraction` tinyint(1) NOT NULL default '0',
 `fwidth` int(6) NOT NULL default '0',
 `fheight` int(6) NOT NULL default '0',
 `date1` int(10) unsigned NOT NULL default '0',
 `score1` varchar(255) NOT NULL,
 `date2` int(10) unsigned NOT NULL default '0',
 `score2` varchar(255) NOT NULL,
 `date3` int(10) unsigned NOT NULL default '0',
 `score3` varchar(255) NOT NULL,
 `date4` int(10) unsigned NOT NULL default '0',
 `score4` varchar(255) NOT NULL,
 `date5` int(10) unsigned NOT NULL default '0',
 `score5` varchar(255) NOT NULL,
 `date6` int(10) unsigned NOT NULL default '0',
 `score6` varchar(255) NOT NULL,
 `date7` int(10) unsigned NOT NULL default '0',
 `score7` varchar(255) NOT NULL,
 `date8` int(10) unsigned NOT NULL default '0',
 `score8` varchar(255) NOT NULL,
 `date9` int(10) unsigned NOT NULL default '0',
 `score9` varchar(255) NOT NULL,
 `date10` int(10) unsigned NOT NULL default '0',
 `score10` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

CREATE TABLE pw_flashcate (
 cid tinyint(5) unsigned NOT NULL auto_increment,
 name char(50) NOT NULL default '',
 vieworder int(10) NOT NULL default '0',
 ename char(50) NOT NULL default '',
 PRIMARY KEY  (cid)
)TYPE=MyISAM;

INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (1, 'ʧ@', 0, 'dongzuo');
INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (2, 'd', 0, 'gaoxiao');
INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (3, 'q', 0, 'yizhi');
INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (4, '_I', 0, 'maoxian');
INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (5, 'ӱ', 0, 'zonghe');
INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (6, 'ѵP', 0, 'qipai');
INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (7, 'g', 0, 'sheji');
INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (8, '|', 0, 'tiyu');
INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (9, '', 0, 'xiuxian');
INSERT INTO pw_flashcate (cid, name, vieworder, ename) VALUES (10, 'L', 0, 'minjie');

CREATE TABLE pw_flashlog (
 id int(11) unsigned NOT NULL auto_increment,
 uid int(10) unsigned NOT NULL default '0',
 username varchar(50) NOT NULL default '',
 title varchar(50) NOT NULL default '',
 ename text NOT NULL,   
 image text NOT NULL,
 path text NOT NULL,
 imageurl text NOT NULL,
 pathurl text NOT NULL,
 time int(10) NOT NULL default '0',
 PRIMARY KEY  (id)
)TYPE=MyISAM;

CREATE TABLE pw_flashdellog (
 id int(11) unsigned NOT NULL auto_increment,
 uid int(10) unsigned NOT NULL default '0',
 username varchar(100) NOT NULL default '',
 title varchar(50) NOT NULL default '',
 ename text NOT NULL,   
 image text NOT NULL,
 path text NOT NULL,
 imageurl text NOT NULL,
 pathurl text NOT NULL,
 time int(10) NOT NULL default '0',
 PRIMARY KEY  (id)
)TYPE=MyISAM;

CREATE TABLE pw_flashreply (
  aid int(11) unsigned NOT NULL auto_increment,
  tid int(10) unsigned NOT NULL,
  uid int(10) unsigned NOT NULL,
  username varchar(100) NOT NULL default '',
  content varchar(255) NOT NULL default '',
  userlog varchar(10) NOT NULL default '',
  ipfrom varchar(100) NOT NULL default '',
  `time` int(11) NOT NULL,
  KEY aid (aid)
) ENGINE=MyISAM;
