-- 表: program_categories
-- 自动生成于: 2026-03-06 00:39:05

DROP TABLE IF EXISTS `program_categories`;
CREATE TABLE `program_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `icon` varchar(255) DEFAULT 'fa-folder' COMMENT '分类图标',
  `description` text COMMENT '分类描述',
  `sort_order` int(11) DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态：1启用 0禁用',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='程序分类表';

-- 初始数据
INSERT INTO `program_categories` VALUES ('1', 'CMS系统', 'fa fa-cubes', '内容管理系统：织梦、帝国、PHPCMS、迅睿等', '1', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('2', '博客系统', 'fa fa-rss', '博客程序：WordPress、Typecho、Z-Blog、Emlog', '2', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('3', '电商系统', 'fa fa-shopping-cart', '电子商务：ECShop、ShopEx、ShopXO、WooCommerce', '3', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('4', '论坛系统', 'fa fa-comments', '论坛社区：Discuz、phpBB、HYBBS', '4', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('5', '企业官网', 'fa fa-building', '企业建站：米拓、DM建站、展示型网站', '5', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('6', '支付系统', 'fa fa-credit-card', '支付收款：易支付、码支付、虎皮椒', '6', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('7', '授权/代理', 'fa fa-key', '授权发卡：授权系统、卡密系统、代理系统', '7', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('8', '微信/小程序', 'fa fa-weixin', '微信生态：微擎、壹佰云、小程序', '8', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('9', '在线教育', 'fa fa-graduation-cap', '网校系统：MeEdu、云课网校', '9', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('10', '问答/社交', 'fa fa-question-circle', '问答社区：Tipask、Whatsns', '10', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
INSERT INTO `program_categories` VALUES ('11', '其他', 'fa fa-folder', '其他类型程序', '99', '1', '2026-02-28 19:49:53', '2026-02-28 19:49:53');
