



-- ݿű

 

--
-- Ľṹ `jxqy_yang_form`
--

CREATE TABLE `jxqy_yang_form` (
	`form_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
	`form_title` char(60) NOT NULL COMMENT '',
	`form_start_time` date NOT NULL COMMENT 'Чʱ',
	`form_end_time` date NOT NULL COMMENT 'Чʱ',
	`form_nums` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'ύ',
	`form_add_time` datetime NOT NULL COMMENT 'ʱ',
	`form_intro` text NOT NULL COMMENT '',
	`form_info_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'ϢǷʾ',
	`status` tinyint(1) unsigned NOT NULL DEFAULT '1',
	PRIMARY KEY (`form_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Ľṹ `jxqy_yang_form_items`
--

CREATE TABLE `jxqy_yang_form_items` (
	`item_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Ŀid',
	`form_id` mediumint(8) unsigned NOT NULL COMMENT 'id',
	`item_title` char(255) NOT NULL COMMENT 'Ŀ',
	`item_type` char(10) NOT NULL COMMENT 'Ŀ',
	`item_rule` char(255) NOT NULL COMMENT 'Ŀ',
	`item_ext` char(255) NOT NULL,
	`item_size` smallint(4) unsigned NOT NULL,
	`item_list` text NOT NULL COMMENT 'Ŀѡ',
	`item_must` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT 'ѡ',
	`item_hidden` mediumint(8) unsigned NOT NULL DEFAULT '0',
	`item_sort` smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT 'Ŀ˳',
	`item_add_time` datetime NOT NULL,
	`status` tinyint(3) unsigned NOT NULL DEFAULT '1',
	PRIMARY KEY (`item_id`),
	KEY `item_sort` (`item_sort`),
	KEY `form_id` (`form_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Ľṹ `jxqy_yang_form_data`
--

CREATE TABLE `jxqy_yang_form_data` (
	`data_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
	`form_id` mediumint(8) unsigned NOT NULL,
	`data_info` text NOT NULL,
	`addtime` datetime NOT NULL,
	`addip` char(15) NOT NULL,
	PRIMARY KEY (`data_id`),
	KEY `form_id` (`form_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;




