multimedia.sql

来自「基于JSP＋MYSQL的教学资源库系统」· SQL 代码 · 共 99 行

# MySQL-Front 3.0  (Build 29.6)


CREATE TABLE animate (
  ID char(15) NOT NULL default '0',
  SubjectType char(15) NOT NULL default '媒体素材',
  ObjectType char(15) NOT NULL default '所有学者',
  KeyWords char(50) default '媒体',
  Description char(200) default NULL,
  WriteTime date NOT NULL default '2005-10-08',
  Writer char(15) NOT NULL default '',
  FileType char(6) NOT NULL default '',
  Size int(6) unsigned NOT NULL default '0',
  SavePath char(50) NOT NULL default '0',
  Download int(8) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;



CREATE TABLE classification (
  Classification char(8) NOT NULL default '',
  SubjectType char(15) NOT NULL default ''
) TYPE=MyISAM;



CREATE TABLE image (
  ID char(15) NOT NULL default '0',
  SubjectType char(15) NOT NULL default '媒体素材',
  ObjectType char(15) NOT NULL default '所有学者',
  KeyWords char(50) default '媒体',
  Description char(200) default NULL,
  WriteTime date NOT NULL default '2005-10-08',
  Writer char(15) NOT NULL default '',
  FileType char(6) NOT NULL default '',
  Size int(6) unsigned NOT NULL default '0',
  SavePath char(50) NOT NULL default '0',
  Download int(8) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;



CREATE TABLE sound (
  ID char(15) NOT NULL default '0',
  SubjectType char(15) NOT NULL default '媒体素材',
  ObjectType char(15) NOT NULL default '所有学者',
  KeyWords char(50) default '媒体',
  Description char(200) default NULL,
  WriteTime date NOT NULL default '2005-10-08',
  Writer char(15) NOT NULL default '',
  FileType char(6) NOT NULL default '',
  Size int(6) unsigned NOT NULL default '0',
  SavePath char(50) NOT NULL default '0',
  Download int(8) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;



CREATE TABLE text (
  ID char(15) NOT NULL default '0',
  SubjectType char(15) NOT NULL default '媒体素材',
  ObjectType char(15) NOT NULL default '所有学者',
  KeyWords char(50) default '媒体',
  Description char(200) default NULL,
  WriteTime date NOT NULL default '2005-10-08',
  Writer char(15) NOT NULL default '',
  FileType char(6) NOT NULL default '',
  Size int(6) unsigned NOT NULL default '0',
  SavePath char(50) NOT NULL default '0',
  Download int(8) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;


INSERT INTO text VALUES ('t17000','ppp','a','a','a','2005-02-09','a','doc',41472,'multiMedia/text/t17000.doc',0);
INSERT INTO text VALUES ('t16200','a','a','a','a','2005-01-09','a','doc',41472,'multiMedia/text/t16200.doc',0);
INSERT INTO text VALUES ('t105901843600','tt','ss','sadf','asdfsadf','2005-04-09','sdf','doc',41472,'multiMedia/text/t105901843600.doc',0);

CREATE TABLE video (
  ID char(15) NOT NULL default '0',
  SubjectType char(15) NOT NULL default '媒体素材',
  ObjectType char(15) NOT NULL default '所有学者',
  KeyWords char(50) default '媒体',
  Description char(200) default NULL,
  WriteTime date NOT NULL default '2005-10-08',
  Writer char(15) NOT NULL default '',
  FileType char(6) NOT NULL default '',
  Size int(6) unsigned NOT NULL default '0',
  SavePath char(50) NOT NULL default '0',
  Download int(8) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;