?? minierp.sql
字號:
CREATE TABLE `kucout` ( `AUTOID` bigint(20) NOT NULL auto_increment, `KCO01` varchar(20) NOT NULL, `KCO02` varchar(20) default NULL, `KCO03` varchar(20) default NULL, `KCO04` int(11) default '0', `KCO05` varchar(20) default NULL, `DT999` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='庫存序號出庫資料檔' AUTO_INCREMENT=1255 ;-- ---------------------------------------------------------- -- 表的結構 `log`-- CREATE TABLE `log` ( `AUTOID` bigint(20) NOT NULL auto_increment, `LOGID` varchar(20) NOT NULL default '', `LOG01` varchar(20) NOT NULL default '', `LOG02` varchar(40) NOT NULL default '', `LOG03` varchar(40) NOT NULL default '', `DT999` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='操作記錄表' AUTO_INCREMENT=172 ;-- ---------------------------------------------------------- -- 表的結構 `pleibie`-- CREATE TABLE `pleibie` ( `AUTOID` bigint(20) NOT NULL auto_increment, `PLB01` varchar(40) default NULL, `PLB02` varchar(40) default NULL, `PLB03` tinyint(3) default NULL, `PLB04` tinyint(3) default NULL, `DT998` tinyint(1) NOT NULL default '0', `DT999` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;-- ---------------------------------------------------------- -- 表的結構 `products`-- CREATE TABLE `products` ( `AUTOID` bigint(20) NOT NULL auto_increment, `ID` varchar(20) NOT NULL default '', `PROD01` varchar(40) NOT NULL default '', `PROD02` varchar(20) default NULL, `PROD03` tinyint(1) NOT NULL default '0', `PROD04` varchar(50) default NULL, `PROD05` varchar(10) default NULL, `PROD06` varchar(10) default NULL, `PROD07` float default NULL, `PROD08` varchar(10) default NULL, `PROD09` date default NULL, `PROD10` varchar(5) default NULL, `PROD11` varchar(10) default NULL, `PROD12` float default NULL, `PRODID` varchar(10) default NULL, `PROD13` tinyint(1) default '0', `DT999` datetime default NULL, `DT998` tinyint(1) NOT NULL default '0', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='產品資料表' AUTO_INCREMENT=322 ;-- ---------------------------------------------------------- -- 表的結構 `shddelt`-- CREATE TABLE `shddelt` ( `AUTOID` bigint(20) NOT NULL auto_increment, `SHDID` varchar(20) NOT NULL, `SHD01` varchar(10) NOT NULL default '', `SHD02` varchar(30) NOT NULL default '', `SHD03` float NOT NULL default '1', `SHD04` float(10,2) NOT NULL default '0.00', `SHD05` float(10,2) NOT NULL default '0.00', `SHD06` varchar(4) default NULL, `SHD07` varchar(15) default NULL, `SHD08` varchar(15) default NULL, `SHD09` varchar(30) default NULL, `DT999` datetime default NULL, `DT998` tinyint(1) NOT NULL default '0', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1178 ;-- ---------------------------------------------------------- -- 表的結構 `shdmast`-- CREATE TABLE `shdmast` ( `AUTOID` bigint(20) NOT NULL auto_increment, `SHMID` varchar(20) NOT NULL default '', `CLIID` varchar(10) default NULL, `SHM01` date NOT NULL default '0000-00-00', `SHM02` varchar(30) NOT NULL default '', `SHM03` varchar(10) NOT NULL default '', `SHM04` varchar(10) NOT NULL default '', `SHM05` varchar(10) NOT NULL default '', `SHM06` float(10,2) NOT NULL default '0.00', `SHM07` varchar(50) NOT NULL default '', `SHM08` varchar(255) default NULL, `SHM09` varchar(50) default NULL, `SHM10` varchar(8) default '0', `SHM11` int(11) default NULL, `SHM12` tinyint(1) default '0', `DT999` datetime default NULL, `DT998` tinyint(1) NOT NULL default '0', PRIMARY KEY (`AUTOID`), UNIQUE KEY `SHMID` (`SHMID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='送貨單主表' AUTO_INCREMENT=711 ;-- ---------------------------------------------------------- -- 表的結構 `shebei`-- CREATE TABLE `shebei` ( `AUTOID` bigint(20) NOT NULL auto_increment, `SEBID` varchar(15) NOT NULL default '', `SEB01` varchar(10) NOT NULL default '', `SEB02` varchar(30) NOT NULL default '', `SEB03` varchar(10) default NULL, `SEB04` date default NULL, `SEB05` date default NULL, `SEB06` varchar(15) default NULL, `SEB07` varchar(10) default NULL, `SEB08` varchar(10) default NULL, `SEB09` date default NULL, `SEB10` varchar(50) default NULL, `SEB11` varchar(10) default NULL, `SEB12` date default NULL, `DT999` datetime NOT NULL default '0000-00-00 00:00:00', `SEBMID` varchar(15) default NULL, `SEBDET` binary(1) default '\0', `SEBSN` varchar(15) default NULL, `DT998` tinyint(1) NOT NULL default '0', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='設備資料表' AUTO_INCREMENT=52 ;-- ---------------------------------------------------------- -- 表的結構 `softlist`-- CREATE TABLE `softlist` ( `AUTOID` bigint(20) NOT NULL auto_increment, `SOFID` varchar(5) NOT NULL default '', `SOF01` varchar(10) NOT NULL default '', `SOF02` varchar(30) NOT NULL default '', `SOF03` varchar(10) NOT NULL default '', `SOF04` varchar(4) NOT NULL default '', `SOFSN` varchar(100) NOT NULL default '', `SOFRED` text NOT NULL, `DT999` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='軟件列表' AUTO_INCREMENT=2 ;-- ---------------------------------------------------------- -- 表的結構 `sokdelt`-- CREATE TABLE `sokdelt` ( `AUTOID` bigint(20) NOT NULL auto_increment, `SKD01` varchar(20) NOT NULL, `SKD02` varchar(20) default NULL, `SKD03` varchar(20) default NULL, `SKD04` float default NULL, `DT998` tinyint(1) default '0', `DT999` timestamp NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='收款單明細表' AUTO_INCREMENT=78 ;-- ---------------------------------------------------------- -- 表的結構 `sokmast`-- CREATE TABLE `sokmast` ( `AUTOID` bigint(20) NOT NULL auto_increment, `SKM01` varchar(20) NOT NULL, `SKM02` varchar(20) default NULL, `SKM03` date default NULL, `SKM04` float default NULL, `SKM05` varchar(10) default NULL, `SKM06` varchar(10) default NULL, `SKM07` int(3) default NULL, `SKM08` float default NULL, `DT998` tinyint(1) default '0', `DT999` timestamp NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='收款單主表' AUTO_INCREMENT=27 ;-- ---------------------------------------------------------- -- 表的結構 `taskdelt`-- CREATE TABLE `taskdelt` ( `AUTOID` bigint(20) NOT NULL auto_increment, `TAD01` varchar(20) default NULL, `TAD02` varchar(20) default NULL, `TAD03` varchar(40) default NULL, `TAD04` datetime default '0000-00-00 00:00:00', `TAD05` varchar(200) default '0000-00-00 00:00:00', `TAD06` tinyint(1) default '0', `DT998` tinyint(1) default '0', `DT999` datetime default '0000-00-00 00:00:00', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='任務進度表' AUTO_INCREMENT=946 ;-- ---------------------------------------------------------- -- 表的結構 `taskmast`-- CREATE TABLE `taskmast` ( `AUTOID` bigint(20) NOT NULL auto_increment, `TAS01` varchar(20) default NULL, `TAS02` varchar(100) default NULL, `TAS03` varchar(200) default '0', `TAS04` varchar(200) default '0', `TAS05` tinyint(1) default '0', `TAS06` tinyint(1) default '0', `TAS07` datetime default '0000-00-00 00:00:00', `TAS08` datetime default '0000-00-00 00:00:00', `TAS09` int(11) default NULL, `TAS10` varchar(20) default NULL, `TAS11` varchar(20) default NULL, `TAS12` int(11) default NULL, `TAS13` varchar(50) default NULL, `TAS14` varchar(20) default NULL, `DT998` tinyint(1) default '0', `DT999` datetime default '0000-00-00 00:00:00', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='任務主表' AUTO_INCREMENT=452 ;-- ---------------------------------------------------------- -- 表的結構 `user`-- CREATE TABLE `user` ( `AUTOID` bigint(20) NOT NULL auto_increment, `UID` varchar(20) NOT NULL default '', `UNAME` varchar(20) NOT NULL default '', `UPASS` varchar(100) NOT NULL default '', `DT999` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用戶表' AUTO_INCREMENT=8 ;-- ---------------------------------------------------------- -- 表的結構 `user2role`-- CREATE TABLE `user2role` ( `AUTOID` bigint(20) NOT NULL auto_increment, `URID` varchar(10) NOT NULL, `PRID` varchar(20) NOT NULL, `URVI` tinyint(1) default NULL, `URRE` tinyint(1) default NULL, `URED` tinyint(1) default NULL, `URDE` tinyint(1) default NULL, `URME` tinyint(1) default NULL, `PRNA` varchar(50) default '測試', `UORD` int(3) default '3', `DT998` tinyint(1) default NULL, `DT999` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用戶權限表' AUTO_INCREMENT=31 ;-- ---------------------------------------------------------- -- 表的結構 `worklog`-- CREATE TABLE `worklog` ( `AUTOID` bigint(20) NOT NULL auto_increment, `WOR01` varchar(30) NOT NULL default '', `WOR02` varchar(30) default NULL, `WOR03` varchar(50) default NULL, `WOR04` varchar(200) default NULL, `WOR05` varchar(50) default NULL, `WOR06` tinyint(2) default '0', `WOR07` varchar(20) default NULL, `WOR08` varchar(50) default NULL, `WOR09` tinyint(1) default '0', `WOR10` varchar(20) default NULL, `DT998` tinyint(1) default '0', `DT999` datetime default '0000-00-00 00:00:00', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='工作記錄表' AUTO_INCREMENT=24 ;-- ---------------------------------------------------------- -- 表的結構 `yinfu`-- CREATE TABLE `yinfu` ( `AUTOID` bigint(20) NOT NULL auto_increment, `YIF01` varchar(20) default NULL, `YIF02` varchar(40) default NULL, `YIF03` int(6) default NULL, `YIF04` float(10,2) default NULL, `YIF05` float(10,2) default NULL, `YIF06` float(10,2) default NULL, `YIF07` float(10,2) default NULL, `DT998` tinyint(1) default '0', `DG999` datetime default NULL, PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='應付帳款' AUTO_INCREMENT=1 ;-- ---------------------------------------------------------- -- 表的結構 `yinfudelt`-- CREATE TABLE `yinfudelt` ( `AUTOID` bigint(20) NOT NULL auto_increment, `YFD01` varchar(20) default NULL, `YFD02` varchar(20) default NULL, `YFD03` float(10,2) default '0.00', `YFD04` float(10,2) default '0.00', `YFD05` float(10,2) default '0.00', `YFD06` float(10,2) default '0.00', `YFD07` varchar(20) default NULL, `YFD08` date default NULL, `DT998` tinyint(1) default '0', `DT999` datetime default NULL, PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='應付帳款明細' AUTO_INCREMENT=221 ;-- ---------------------------------------------------------- -- 表的結構 `yinshou`-- CREATE TABLE `yinshou` ( `AUTOID` bigint(20) NOT NULL auto_increment, `YIS01` varchar(20) default NULL, `YIS02` varchar(40) default NULL, `YIS03` int(6) default NULL, `YIS05` float(10,2) default NULL, `YIS06` float(10,2) default NULL, `YIS07` float(10,2) default NULL, `YIS08` float(10,2) default NULL, `DT998` tinyint(1) default '0', `DT999` datetime default NULL, PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='客戶應收帳款' AUTO_INCREMENT=1 ;-- ---------------------------------------------------------- -- 表的結構 `yinshoudelt`-- CREATE TABLE `yinshoudelt` ( `AUTOID` bigint(20) NOT NULL auto_increment, `YSD01` varchar(20) default NULL, `YSD02` varchar(20) default NULL, `YSD03` float(10,2) default '0.00', `YSD04` float(10,2) default '0.00', `YSD05` float(10,2) default '0.00', `YSD06` float(10,2) default '0.00', `YSD07` varchar(20) default NULL, `YSD08` date default NULL, `DT998` tinyint(1) default '0', `DT999` datetime default NULL, PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='應收帳款明細' AUTO_INCREMENT=436 ;-- ---------------------------------------------------------- -- 表的結構 `zudelt`-- CREATE TABLE `zudelt` ( `AUTOID` bigint(20) NOT NULL auto_increment, `ZUDID` varchar(16) NOT NULL default '', `ZUD01` varchar(20) default NULL, `ZUD02` varchar(30) default NULL, `ZUD03` varchar(4) default NULL, `ZUD04` float default NULL, `ZUD05` float(10,2) default NULL, `ZUD06` float(10,2) default NULL, `ZUD07` varchar(15) default NULL, `ZUD08` varchar(15) default NULL, `ZUD09` tinyint(1) default '0', `DT998` tinyint(1) default NULL, `DT999` datetime default NULL, PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='組裝明細表' AUTO_INCREMENT=395 ;-- ---------------------------------------------------------- -- 表的結構 `zumast`-- CREATE TABLE `zumast` ( `AUTOID` bigint(20) NOT NULL auto_increment, `ZUMID` varchar(16) NOT NULL default '', `ZUM01` date NOT NULL default '0000-00-00', `ZUM02` varchar(10) NOT NULL default '', `ZUM03` varchar(10) NOT NULL default '', `ZUM04` float(10,2) NOT NULL default '0.00', `ZUM05` varchar(50) NOT NULL default '', `ZUM06` varchar(255) NOT NULL default '', `ZUM07` varchar(20) default NULL, `ZUM08` varchar(30) default NULL, `ZUM09` varchar(4) default NULL, `ZUM10` float default NULL, `ZUM11` float(10,2) default NULL, `ZUM12` float(10,2) default NULL, `ZUM13` varchar(15) default NULL, `ZUM14` varchar(15) default NULL, `DT998` tinyint(1) NOT NULL default '0', `DT999` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`AUTOID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='組裝單主表' AUTO_INCREMENT=31 ;?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -