data.sql

来自「STCMS 音乐系统 v2.5 build 090501： 为达到最佳效果」· SQL 代码 · 共 307 行 · 第 1/5 页

DROP TABLE IF EXISTS `DB_PREFIX_admin`<{|}>
CREATE TABLE `DB_PREFIX_admin` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL,
  `pwd` varchar(255) NOT NULL,
  `group` int(11) NOT NULL default '1',
  `categoryid` varchar(255) default '0',
  `lastlogin` datetime default NULL,
  `lastip` varchar(15) default NULL,
  `times` int(11) default NULL,
  `time` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8<{|}>
TRUNCATE TABLE `DB_PREFIX_admin`<{|}>
INSERT INTO `DB_PREFIX_admin` (`id`,`name`,`pwd`,`group`,`categoryid`,`lastlogin`,`lastip`,`times`,`time`) VALUES ('1','admin','admin','0','0','2009-05-02 02:44:28','127.0.0.1','20','0000-00-00 00:00:00')<{|}>

DROP TABLE IF EXISTS `DB_PREFIX_admin_group`<{|}>
CREATE TABLE `DB_PREFIX_admin_group` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `comment` varchar(255) default NULL,
  `intro` longtext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8<{|}>
TRUNCATE TABLE `DB_PREFIX_admin_group`<{|}>
INSERT INTO `DB_PREFIX_admin_group` (`id`,`name`,`comment`,`intro`) VALUES ('1','superAdmin','超级管理员','所有权限')<{|}>
INSERT INTO `DB_PREFIX_admin_group` (`id`,`name`,`comment`,`intro`) VALUES ('2','categoryAdmin','分类管理员','在该分类内有相应权限')<{|}>

DROP TABLE IF EXISTS `DB_PREFIX_artist`<{|}>
CREATE TABLE `DB_PREFIX_artist` (
  `id` int(11) NOT NULL auto_increment,
  `type` int(1) default NULL,
  `categoryid` int(11) default '0',
  `sort` varchar(5) NOT NULL,
  `name` varchar(255) NOT NULL,
  `picture` longtext,
  `birthday` varchar(255) default NULL,
  `hit` int(11) default '0',
  `week_hit` int(11) default '0',
  `month_hit` int(11) default '0',
  `from` varchar(255) default NULL,
  `intro` longtext,
  `adder` varchar(255) default NULL,
  `time` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8<{|}>
TRUNCATE TABLE `DB_PREFIX_artist`<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('1','','1','A','阿杜','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('2','','1','A','阿木','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('3','','1','A','阿牛','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('4','','1','C','陈晓东','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('5','','1','C','陈楚生','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('6','','1','C','陈奕迅','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('7','','1','C','陈浩民','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('8','','1','C','陈坤','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('9','','1','C','陈小春','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('10','','1','C','陈百强','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('11','','1','C','成龙','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('12','','1','D','刀郎','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('13','','1','D','杜德伟','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('14','','1','D','东来东往','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>
INSERT INTO `DB_PREFIX_artist` (`id`,`type`,`categoryid`,`sort`,`name`,`picture`,`birthday`,`hit`,`week_hit`,`month_hit`,`from`,`intro`,`adder`,`time`) VALUES ('15','','1','D','达明一派','','','0','0','0','','','','0000-00-00 00:00:00')<{|}>