CREATE TABLE `neothemesconfig` (
  `nsn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `field`  text NOT NULL default '',   
  `modulesid` varchar(255)  NOT NULL default '',
  `mnsnid`  text NOT NULL default '', 
  `fnsnid` varchar(255)  NOT NULL default '',
  `menuid` varchar(255)  NOT NULL default '',
  `line` varchar(255)  NOT NULL default '',
  `fburl` varchar(255)  NOT NULL default '',
  `fbfansurl` varchar(255)  NOT NULL default '',
  `contactus` varchar(255)  NOT NULL default '',
  `contactmatters` varchar(1020)  NOT NULL default '', /*聯絡事項*/    
  `contactustext`  text NOT NULL default '', /*區塊聯絡資訊*/  
  `enable` enum('1','0') NOT NULL default '0', /*是否關閉更新通知(0開啟/1關閉)*/      
  `aboutustext`  text NOT NULL default '', /*區塊關於我們  */  
  `remarkstext`  text NOT NULL default '', /*聯絡我們說明  */  
  PRIMARY KEY (`nsn`)
) ENGINE=MyISAM;

INSERT INTO `neothemesconfig` (`nsn`,`field`,`modulesid`,`mnsnid`,`fnsnid`,`menuid`) VALUES
(1,'a:23:{i:0;s:1:"1";i:1;s:1:"1";i:2;s:1:"1";i:3;s:1:"1";i:4;s:1:"1";i:5;s:1:"0";i:6;s:1:"1";i:21;s:1:"5";i:7;s:1:"0";i:8;s:1:"1";i:9;s:1:"6";i:10;s:1:"0";i:11;s:1:"1";i:12;s:1:"1";i:14;s:1:"1";i:13;s:1:"1";i:15;s:1:"8";i:16;s:1:"8";i:17;s:8:"xsitemap";i:18;s:11:"logcounterx";i:19;s:0:"";i:20;s:2:"19";i:22;s:0:"";}','system','0','0','0');  


CREATE TABLE `neothemeskeyword` (
  `nsn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `keywordid` varchar(255) NOT NULL default '',
  `keywordcenter` text NOT NULL,
  `wdescription`  text NOT NULL,
  `title` varchar(255) NOT NULL default '',
  PRIMARY KEY (`nsn`)
) ENGINE=MyISAM;


CREATE TABLE `neothemesmarquee` (
  `nsn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `nnumber` smallint(5) unsigned NOT NULL default '0',  /* 排序 */
  `content` text NOT NULL,
  `url` text NOT NULL,
  `target` varchar(255) NOT NULL default '',
  `post_date` datetime NOT NULL,
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用*/    
  PRIMARY KEY (`nsn`),KEY nnumber (nnumber)
) ENGINE=MyISAM;


CREATE TABLE `neothemesflash` (
  `nsn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `nnumber` smallint(5) unsigned NOT NULL default '0',
  `content` text NOT NULL,
  `url` text NOT NULL,
  `target` varchar(255) NOT NULL default '',
  `post_date` datetime NOT NULL,
  `imgid` varchar(255) NOT NULL default '',
  `themesid` varchar(255) NOT NULL default '',
  `enable` enum('1','0') NOT NULL default '0', /*是否啟用(1啟用/0關閉)*/        
  PRIMARY KEY (`nsn`),KEY nnumber (nnumber)
) ENGINE=MyISAM;





CREATE TABLE `neothemesmenu` (  /*網站主選單料表*/
  `sortid` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `of_sortid` smallint(5) unsigned NOT NULL default 0, /*父分類id*/
  `sortidsort` smallint(5) UNSIGNED NOT NULL default 0, /*排序*/ 
  `sorttitle` varchar(255) NOT NULL default '', /*分類名稱*/  
  `url` text NOT NULL, /*分類說明*/
  `target` enum('1','0') NOT NULL default '0',  /*開啟方式*/ 
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用*/  
  `browsegroup` varchar(255) NOT NULL default '', /*可觀看群組*/    
  `displaytype` varchar(255) NOT NULL default '1', /*顯示狀態*/  
   PRIMARY KEY (`sortid`),KEY sortidsort (sortidsort)
) ENGINE=MyISAM;


CREATE TABLE `neorightmenu` (
  `nsn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `url` text NOT NULL,
  `target` varchar(255) NOT NULL default '',
  `snid`  smallint(5) unsigned NOT NULL default '0',  /*排序*/
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用*/    
  PRIMARY KEY (`nsn`),KEY snid (snid)
) ENGINE=MyISAM;


CREATE TABLE `neoblockmenusort` ( /*佈景區塊分類資料表*/
  `sortid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `sorttitle` varchar(255) NOT NULL default '',
  `sortimg` varchar(255) NOT NULL default '',  /*圖示編號圖片*/
  `sorting` smallint(5) unsigned NOT NULL default '0',  /*排序*/
  `radiogstyle` enum('text','img') NOT NULL default 'text',  
  `sorttitleurl` varchar(1024) NOT NULL default '',
  `target` enum('0','1') NOT NULL default '0',  
  `urlenable` enum('1','0') NOT NULL default '0', /*是否啟用連結(1啟用/0關閉)*/     
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用(1啟用/0關閉)*/      
  `icon` varchar(255) NOT NULL default '', /* icon */  
  `browsegroup` varchar(255) NOT NULL default '', /*可觀看群組*/   
  `boxwidth` varchar(255)  NOT NULL default '', /*圖檔寬度*/   
  PRIMARY KEY (`sortid`),KEY sorting (sorting)
) ENGINE=MyISAM;



CREATE TABLE `neoblockmenubutton` (  /*佈景區塊選單資料表*/
  `sortid` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `of_sortid` smallint(5) unsigned NOT NULL default '0', /*父分類id*/
  `categoryid` smallint(5) unsigned NOT NULL default '0', /*分類ID*/  
  `sorttitle` varchar(255) NOT NULL default '', /*分類名稱*/  
  `url` text NOT NULL, /*分類連結*/
  `target` enum('1','0') NOT NULL default '0',  /*開啟方式*/ 
  `typesof` enum('1','0') NOT NULL default '0',  /*按鈕型態*/   
  `modulesid` varchar(255) NOT NULL default '', /*模組ID*/
  `sortidsort` smallint(5) UNSIGNED NOT NULL default 0, /*排序*/ 
  `buttonimg` varchar(255)  NOT NULL default '', /*圖檔名*/
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用*/  
  `browsegroup` varchar(255) NOT NULL default '', /*可觀看群組*/   
   PRIMARY KEY (`sortid`),KEY sortidsort (sortidsort)
) ENGINE=MyISAM;








CREATE TABLE `neocontactusform` (
  `cfid` bigint(255) unsigned NOT NULL AUTO_INCREMENT,
  `name_user` varchar(255) NOT NULL default '',
  `email_user` varchar(255) NOT NULL default '',
  `tel_user` varchar(255) NOT NULL default '',
  `citytel_user` varchar(255) NOT NULL default '',
  `radiog` enum('male','female') NOT NULL default 'male',  
  `texe_user` text NOT NULL, /*說明事項*/
  `cfidtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `readtrue` smallint(5) unsigned NOT NULL default '0',
  `contactmatters` varchar(255) NOT NULL default '0', /*聯絡事項內容*/
  `replytext` longtext NOT NULL, /*回覆說明*/     
  `replytime` datetime default NULL,  /*回覆時間*/    
  `enable` enum('1','0') NOT NULL default '0', /*是否轉交其他會員回覆0否1是*/  
  `directions` longtext NOT NULL, /*管理員說明轉交回覆理由*/    
  `uid` mediumint(8) unsigned NOT NULL default '0', /*回覆者UID*/    
  `transfer` datetime default NULL, /*管理員轉交時間*/    
   PRIMARY KEY (`cfid`),KEY cfidtime (cfidtime)
) ENGINE=MyISAM;





CREATE TABLE `neilrandomidiom` (
  `nsn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `setuptime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, /*建立時間*/  
  `content` text NOT NULL,
  `author` varchar(255) NOT NULL default '',
  `snid`  smallint(5) unsigned NOT NULL default '0',  /*排序*/
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用*/    
  `color` varchar(255) NOT NULL default '', /* 背景顏色 */
  `icom` varchar(255) NOT NULL default '', /* icom */  
  PRIMARY KEY (`nsn`),KEY snid (snid)
) ENGINE=MyISAM;


INSERT INTO `neilrandomidiom` (`nsn`, `setuptime`, `content`, `author`, `snid`, `enable`, `color`, `icom`) VALUES
(1, current_timestamp(), '生活是一面鏡子。你對它笑，它就對你笑；你對它哭，它也對你哭。', '網路小語', 1, '1', 'rgb(0, 0, 255)', '<i class=\"fa fa-certificate\" aria-hidden=\"true\"></i>'),
(2, current_timestamp(), '在實現理想的路途中，必須排除一切干擾，特別是要看清那些美麗的誘惑。', '網路小語', 2, '1', 'rgb(0, 139, 139)', '<i class=\"fa fa-info-circle\" aria-hidden=\"true\"></i>'),
(3, current_timestamp(), '一杯清水因滴入一滴污水而變污濁，一杯污水卻不會因一滴清水的存在而變清澈。', '網路小語', 3, '1', 'rgb(128, 0, 128)', '<i class=\"fa fa-sort-amount-asc\" aria-hidden=\"true\"></i>');




CREATE TABLE `neilblocksicon` (
  `blocksid` bigint(255) unsigned NOT NULL AUTO_INCREMENT,
  `bid` bigint(255) unsigned NOT NULL default 0, /*區塊id*/
  `icon` varchar(255) NOT NULL default '', /* icom */  
  PRIMARY KEY (`blocksid`)
) ENGINE=MyISAM;


CREATE TABLE `neil_address` (  /*全國據點資料表*/
  `menuid` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `unit` varchar(255) NOT NULL default '', /*單位*/  
  `phone` varchar(255) NOT NULL default '', /*電話*/  
  `fax` varchar(255) NOT NULL default '', /*傳真*/    
  `address` text NOT NULL, /*地址*/  
  `remark` text NOT NULL, /*備註說明*/  
  `url` varchar(255) NOT NULL default '', /*連結*/   
  `target` enum('1','0') NOT NULL default '0',  /*開啟方式*/   
  `fb` varchar(255) NOT NULL default '', /*FB連結*/   
  `line` varchar(255) NOT NULL default '', /*line-id*/   
  `youtube` varchar(255) NOT NULL default '', /*youtube連結*/   
  `maps` varchar(255) NOT NULL default '', /*Google-map連結*/   
  `btnsort` smallint(5) UNSIGNED NOT NULL default 0, /*排序*/   
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用*/   
   PRIMARY KEY (`menuid`)
) ENGINE=MyISAM;


CREATE TABLE `neil_textblock` (  /*簡介區塊資料表*/
  `textid` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL default '', /*標題*/  
  `url` varchar(255) NOT NULL default '', /*圖片連結*/    
  `target` enum('1','0') NOT NULL default '0',  /*開啟方式*/      
  `imgid` varchar(255) NOT NULL default '',  /*圖檔名*/     
  `content` text NOT NULL, /*內容*/    
  `btnsort` smallint(5) UNSIGNED NOT NULL default 0, /*排序*/   
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用*/   
   PRIMARY KEY (`textid`)
) ENGINE=MyISAM;


CREATE TABLE `neil_popupads` (  /*彈出廣告資料表*/
  `ad` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL default '', /*廣告標題*/    
  `url` varchar(255) NOT NULL default '', /*圖片連結*/    
  `imgid` varchar(255) NOT NULL default '',  /*圖檔名*/       
  `target` enum('1','0') NOT NULL default '0',  /*開啟方式*/   
  `maturity` date NOT NULL, /*到期時間*/   
  `btnsort` smallint(5) UNSIGNED NOT NULL default 0, /*排序*/   
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用*/   
  `adenable` enum('1','0') NOT NULL default '0', /*播放中廣告*/   
  `imgwidth` varchar(255) NOT NULL default '', /*圖片寬度*/   
   PRIMARY KEY (`ad`)
) ENGINE=MyISAM;


CREATE TABLE `neil_lowerrightad` (  /*右下浮動廣告資料表*/
  `rdad` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL default '', /*廣告標題*/    
  `url` text NOT NULL,  /*圖片連結(陣列)*/   
  `imgid` varchar(255) NOT NULL default '',  /*圖檔名(陣列)*/       
  `target` varchar(255) NOT NULL default '',  /*開啟方式(陣列)*/    
  `maturity` date NOT NULL, /*到期時間*/   
  `btnsort` smallint(5) UNSIGNED NOT NULL default 0, /*排序*/   
  `enable` enum('1','0') NOT NULL default '1', /*是否啟用*/   
  `adenable` enum('1','0') NOT NULL default '0', /*播放中廣告*/   
   PRIMARY KEY (`rdad`)
) ENGINE=MyISAM;