-- phpMyAdmin SQL Dump-- version for WAPM 2.6.1-rc1-- http://www.phpmyadmin.net-- -- 主機: localhost-- 生成日期: 2007 年 12 月 27 日 14:46-- 服務器版本: 4.0.22-- PHP 版本: 4.3.10-- -- 數據庫: `3`-- CREATE DATABASE `3`;USE 3;-- ---------------------------------------------------------- -- 表的結構 `sfilm`-- CREATE TABLE `sfilm` (  `id` smallint(5) unsigned NOT NULL auto_increment,  `name` varchar(50) NOT NULL default '',  `md` tinyint(1) unsigned NOT NULL default '0',  `isshow` tinyint(1) unsigned NOT NULL default '1',  `sort1` tinyint(3) unsigned NOT NULL default '1',  `type` varchar(10) NOT NULL default '',  `star` tinyint(1) unsigned NOT NULL default '1',  `size` smallint(5) unsigned NOT NULL default '0',  `kb` enum('kb','mb') NOT NULL default 'kb',  `viewnum` smallint(5) unsigned zerofill NOT NULL default '00000',  `text` text,  `pic` varchar(100) default NULL,  `url1` varchar(150) NOT NULL default '',  `url2` varchar(150) default NULL,  `url3` varchar(120) default NULL,  `url4` varchar(120) default NULL,  `url5` varchar(120) default NULL,  `dotime` int(10) unsigned NOT NULL default '0',  PRIMARY KEY  (`id`),  UNIQUE KEY `id` (`id`)) TYPE=MyISAM AUTO_INCREMENT=1 ;-- -- 導出表中的數據 `sfilm`-- -- ---------------------------------------------------------- -- 表的結構 `sfilm_sort1`-- CREATE TABLE `sfilm_sort1` (  `id` tinyint(3) unsigned NOT NULL auto_increment,  `sort1` varchar(50) NOT NULL default '',  PRIMARY KEY  (`id`),  UNIQUE KEY `id` (`id`),  KEY `id_2` (`id`)) TYPE=MyISAM AUTO_INCREMENT=2 ;-- -- 導出表中的數據 `sfilm_sort1`-- INSERT INTO `sfilm_sort1` VALUES (1, '小電影');-- -- 數據庫: `a`-- CREATE DATABASE `a`;USE a;-- ---------------------------------------------------------- -- 表的結構 `c_messages`-- CREATE TABLE `c_messages` (  `type` tinyint(4) NOT NULL default '0',  `room` varchar(30) NOT NULL default '',  `username` varchar(30) NOT NULL default '',  `latin1` tinyint(4) NOT NULL default '0',  `m_time` int(11) NOT NULL default '0',  `address` varchar(30) NOT NULL default '',  `message` text NOT NULL) TYPE=MyISAM;-- -- 導出表中的數據 `c_messages`-- -- ---------------------------------------------------------- -- 表的結構 `c_reg_users`-- CREATE TABLE `c_reg_users` (  `username` varchar(30) NOT NULL default '',  `latin1` tinyint(4) NOT NULL default '0',  `password` varchar(32) NOT NULL default '',  `firstname` varchar(64) NOT NULL default '',  `lastname` varchar(64) NOT NULL default '',  `country` varchar(64) NOT NULL default '',  `website` varchar(64) NOT NULL default '',  `email` varchar(64) NOT NULL default '',  `showemail` int(11) NOT NULL default '0',  `perms` varchar(32) NOT NULL default '',  `rooms` varchar(128) NOT NULL default '') TYPE=MyISAM;-- -- 導出表中的數據 `c_reg_users`-- INSERT INTO `c_reg_users` VALUES ('admin', 0, '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '');-- ---------------------------------------------------------- -- 表的結構 `c_users`-- CREATE TABLE `c_users` (  `room` varchar(30) NOT NULL default '',  `username` varchar(30) NOT NULL default '',  `latin1` tinyint(4) NOT NULL default '0',  `u_time` int(11) NOT NULL default '0',  UNIQUE KEY `room` (`room`,`username`)) TYPE=MyISAM;-- -- 導出表中的數據 `c_users`-- -- -- 數據庫: `mysql`-- CREATE DATABASE `mysql`;USE mysql;-- ---------------------------------------------------------- -- 表的結構 `columns_priv`-- CREATE TABLE `columns_priv` (  `Host` char(60) binary NOT NULL default '',  `Db` char(64) binary NOT NULL default '',  `User` char(16) binary NOT NULL default '',  `Table_name` char(64) binary NOT NULL default '',  `Column_name` char(64) binary NOT NULL default '',  `Timestamp` timestamp(14) NOT NULL,  `Column_priv` set('Select','Insert','Update','References') NOT NULL default '',  PRIMARY KEY  (`Host`,`Db`,`User`,`Table_name`,`Column_name`)) TYPE=MyISAM COMMENT='Column privileges';-- -- 導出表中的數據 `columns_priv`-- -- ---------------------------------------------------------- -- 表的結構 `db`-- CREATE TABLE `db` (  `Host` char(60) binary NOT NULL default '',  `Db` char(64) binary NOT NULL default '',  `User` char(16) binary NOT NULL default '',  `Select_priv` enum('N','Y') NOT NULL default 'N',  `Insert_priv` enum('N','Y') NOT NULL default 'N',  `Update_priv` enum('N','Y') NOT NULL default 'N',  `Delete_priv` enum('N','Y') NOT NULL default 'N',  `Create_priv` enum('N','Y') NOT NULL default 'N',  `Drop_priv` enum('N','Y') NOT NULL default 'N',  `Grant_priv` enum('N','Y') NOT NULL default 'N',  `References_priv` enum('N','Y') NOT NULL default 'N',  `Index_priv` enum('N','Y') NOT NULL default 'N',  `Alter_priv` enum('N','Y') NOT NULL default 'N',  `Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',  `Lock_tables_priv` enum('N','Y') NOT NULL default 'N',  PRIMARY KEY  (`Host`,`Db`,`User`),  KEY `User` (`User`)) TYPE=MyISAM COMMENT='Database privileges';-- -- 導出表中的數據 `db`-- INSERT INTO `db` VALUES (0x6c6f63616c686f7374, 0x74657374, 0x74657374, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'N', 'N');-- ---------------------------------------------------------- -- 表的結構 `func`-- CREATE TABLE `func` (  `name` char(64) binary NOT NULL default '',  `ret` tinyint(1) NOT NULL default '0',  `dl` char(128) NOT NULL default '',  `type` enum('function','aggregate') NOT NULL default 'function',  PRIMARY KEY  (`name`)) TYPE=MyISAM COMMENT='User defined functions';-- -- 導出表中的數據 `func`-- -- ---------------------------------------------------------- -- 表的結構 `host`-- CREATE TABLE `host` (  `Host` char(60) binary NOT NULL default '',  `Db` char(64) binary NOT NULL default '',  `Select_priv` enum('N','Y') NOT NULL default 'N',  `Insert_priv` enum('N','Y') NOT NULL default 'N',  `Update_priv` enum('N','Y') NOT NULL default 'N',  `Delete_priv` enum('N','Y') NOT NULL default 'N',  `Create_priv` enum('N','Y') NOT NULL default 'N',  `Drop_priv` enum('N','Y') NOT NULL default 'N',  `Grant_priv` enum('N','Y') NOT NULL default 'N',  `References_priv` enum('N','Y') NOT NULL default 'N',  `Index_priv` enum('N','Y') NOT NULL default 'N',  `Alter_priv` enum('N','Y') NOT NULL default 'N',  `Create_tmp_table_priv` enum('N','Y') NOT NULL default 'N',  `Lock_tables_priv` enum('N','Y') NOT NULL default 'N',  PRIMARY KEY  (`Host`,`Db`)) TYPE=MyISAM COMMENT='Host privileges;  Merged with database privileges';-- -- 導出表中的數據 `host`-- -- ---------------------------------------------------------- -- 表的結構 `movie`-- CREATE TABLE `movie` (  `id` int(10) unsigned NOT NULL auto_increment,  `name` varchar(100) NOT NULL default '',  `viewnum` int(10) NOT NULL default '168',  `downnum` int(10) NOT NULL default '0',  `brief` mediumtext,  `sort2id` smallint(6) NOT NULL default '0',  `pic` varchar(200) NOT NULL default '',  `rmzx` varchar(200) default NULL,  `asf` varchar(200) default NULL,  `rm` varchar(200) default NULL,  `flash` varchar(200) default NULL,  `asfzx` varchar(200) default NULL,  `flashzx` varchar(200) default NULL,  PRIMARY KEY  (`id`)) TYPE=MyISAM AUTO_INCREMENT=934 ;-- -- 導出表中的數據 `movie`-- INSERT INTO `movie` VALUES (1, 'love', 1904, 5, 'love', 1, 'http://cartoonfile.163.com/source/5365/ai.gif', '', '', '', 'http://cartoonfile.163.com/source/5365/ai.swf', '', 'Online audio-visual');INSERT INTO `movie` VALUES (2, 'Soccer', 3215, 0, '<Soccer> A ', 11, 'http://2733.8u8.com/pic/slzq.gif', '', '', 'rtsp://61.138.3.123/asf_vcd/saolinzuqu_1.rm', '', '', '');INSERT INTO `movie` VALUES (3, 'Soccer', 2231, 0, '<Soccer> B ', 11, 'http://2733.8u8.com/pic/slzq.gif', '', '', 'rtsp://61.138.3.123/asf_vcd/saolinzuqu_2.rm', '', '', '');INSERT INTO `movie` VALUES (4, 'Chicken', 2548, 0, '<Chicken> ASF format', 14, 'http://y888.net/k666/tt78/8/pic/my.gif', '', 'mms://61.138.3.123/asf_dvd/cr.asf', '', '', '', '');INSERT INTO `movie` VALUES (5, 'I love you inadequate', 1930, 0, 'liu de hua <I love you inadequate> MTV', 2, 'http://cartoonfile.163.com/desktop/source/4009/andy2.jpg', '', 'mms://61.134.9.121/new/andy/01.wmv', '', '', 'View Online', '');INSERT INTO `movie` VALUES (6, 'heart', 772, 0, '<heart> FLASH', 1, 'http://cartoonfile.163.com/source/8849/copyofin2.jpg', '', '', '', 'http://cartoonfile.163.com/source/8849/inheart.swf', '', 'View Online');INSERT INTO `movie` VALUES (7, 'Black days', 783, 0, 'sun yan zi <Black days> FLASH', 1, 'http://cartoonfile.163.com/source/6525/tianhh.jpg', '', '', '', 'http://cartoonfile.163.com/source/6525/tianhh.swf', '', 'View Online');INSERT INTO `movie` VALUES (8, '<Journey to the West>', 725, 0, '<Journey to the West>', 1, 'http://cartoonfile.163.com/source/6331/xxj01.jpg', '', '', '', 'http://cartoonfile.163.com/source/6331/xxj01.swf', '', 'View Online');INSERT INTO `movie` VALUES (9, 'Single love songs', 991, 0, 'lin zhi xuan <Single love songs>', 1, 'http://cartoonfile.163.com/source/20/one.jpg', '', '', '', 'http://cartoonfile.163.com/source/20/d.swf', '', 'View Online');INSERT INTO `movie` VALUES (10, 'Thanks for you love1999', 1274, 0, 'xie ting feng <Thanks for you love1999>', 1, 'http://cartoonfile.163.com/source/46/5-20-007.jpg', '', '', '', 'http://cartoonfile.163.com/source/46/love1999.swf', '', 'View Online');INSERT INTO `movie` VALUES (11, 'rain', 1018, 0, 'zhang yu <rain>', 1, 'http://cartoonfile.163.com/source/77/snap.jpg', '', '', '', 'http://cartoonfile.163.com/source/77/load.swf', '', 'View Online');INSERT INTO `movie` VALUES (12, 'come back', 684, 0, 'sun nan <come back>', 1, 'http://cartoonfile.163.com/source/92/comebakce1.jpg', '', '', '', 'http://cartoonfile.163.com/source/92/ybmm3.swf', '', 'View Online');INSERT INTO `movie` VALUES (13, 'qing zang Plateau', 479, 0, 'qing zang Plateau', 1, 'http://cartoonfile.163.com/source/108/budala.jpg', '', '', '', 'http://cartoonfile.163.com/source/108/qzgy.swf', '', 'View Online');