jlweb1.7.0.sql 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.0
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost
  6. -- Generation Time: 2017-04-14 15:35:57
  7. -- 服务器版本: 5.7.17-13
  8. -- PHP Version: 7.0.15-0ubuntu0.16.04.4
  9. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  10. SET AUTOCOMMIT = 0;
  11. START TRANSACTION;
  12. SET time_zone = "+00:00";
  13. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16. /*!40101 SET NAMES utf8mb4 */;
  17. -- --------------------------------------------------------
  18. --
  19. -- 表的结构 `jl_attachment`
  20. --
  21. CREATE TABLE `jl_attachment` (
  22. `aid` int(11) NOT NULL,
  23. `pid` mediumint(9) NOT NULL,
  24. `stid` mediumint(9) NOT NULL,
  25. `mpid` mediumint(9) NOT NULL,
  26. `pmid` mediumint(9) NOT NULL,
  27. `numpname` smallint(6) NOT NULL,
  28. `times` smallint(6) NOT NULL DEFAULT '0',
  29. `auditoruid` mediumint(9) NOT NULL,
  30. `filepath` char(255) NOT NULL,
  31. `ziphashcode` char(32) NOT NULL,
  32. `filehashcode` char(32) NOT NULL,
  33. `isnew` tinyint(4) NOT NULL DEFAULT '1',
  34. `intime` int(11) NOT NULL
  35. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  36. -- --------------------------------------------------------
  37. --
  38. -- 表的结构 `jl_auser`
  39. --
  40. CREATE TABLE `jl_auser` (
  41. `auid` mediumint(9) NOT NULL,
  42. `auname` char(255) NOT NULL,
  43. `aupass` char(255) NOT NULL,
  44. `aemail` char(255) NOT NULL
  45. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  46. --
  47. -- 转存表中的数据 `jl_auser`
  48. --
  49. INSERT INTO `jl_auser` (`auid`, `auname`, `aupass`, `aemail`) VALUES
  50. (1, 'madmin', '$2a$08$TbScA7uWG/VGm6KWqMfkiOAuCdC4wqRlSWcafwObi5PS71jJVXXve', '');
  51. -- --------------------------------------------------------
  52. --
  53. -- 表的结构 `jl_config`
  54. --
  55. CREATE TABLE `jl_config` (
  56. `conid` tinyint(4) NOT NULL,
  57. `proname` char(255) NOT NULL,
  58. `onoff` tinyint(2) NOT NULL DEFAULT '0',
  59. `upgradeinfo` text NOT NULL,
  60. `smsswitch` tinyint(4) NOT NULL DEFAULT '1'
  61. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  62. --
  63. -- 转存表中的数据 `jl_config`
  64. --
  65. INSERT INTO `jl_config` (`conid`, `proname`, `onoff`, `upgradeinfo`, `smsswitch`) VALUES
  66. (1, '', 0, '', 1);
  67. -- --------------------------------------------------------
  68. --
  69. -- 表的结构 `jl_item_attachment`
  70. --
  71. CREATE TABLE `jl_item_attachment` (
  72. `iaid` mediumint(11) NOT NULL,
  73. `ownerid` smallint(11) NOT NULL,
  74. `pid` int(11) NOT NULL DEFAULT '0',
  75. `pmid` int(11) NOT NULL DEFAULT '0',
  76. `filename` varchar(255) NOT NULL,
  77. `fileext` char(5) NOT NULL,
  78. `filesize` char(255) NOT NULL,
  79. `filepath` char(255) NOT NULL,
  80. `intime` int(11) NOT NULL,
  81. `isdel` tinyint(2) NOT NULL DEFAULT '0'
  82. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  83. -- --------------------------------------------------------
  84. --
  85. -- 表的结构 `jl_item_measure_numofper`
  86. --
  87. CREATE TABLE `jl_item_measure_numofper` (
  88. `imnid` int(11) NOT NULL,
  89. `iaid` int(11) NOT NULL,
  90. `pid` int(11) NOT NULL,
  91. `pmid` int(11) NOT NULL,
  92. `numpname` smallint(6) NOT NULL,
  93. `softwareitemid` int(11) NOT NULL,
  94. `isdel` tinyint(4) NOT NULL DEFAULT '0',
  95. `intime` int(11) NOT NULL DEFAULT '0',
  96. `deltime` int(11) NOT NULL DEFAULT '0',
  97. `deluid` mediumint(9) NOT NULL,
  98. `ownerid` mediumint(9) NOT NULL DEFAULT '0',
  99. `categoryid` mediumint(9) NOT NULL DEFAULT '0',
  100. `tips` text NOT NULL
  101. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  102. -- --------------------------------------------------------
  103. --
  104. -- 表的结构 `jl_measure_audit`
  105. --
  106. CREATE TABLE `jl_measure_audit` (
  107. `maid` smallint(6) NOT NULL,
  108. `pid` mediumint(9) NOT NULL,
  109. `creatoruid` mediumint(9) NOT NULL,
  110. `auditoruid` mediumint(9) NOT NULL DEFAULT '0',
  111. `mpid` mediumint(9) NOT NULL DEFAULT '0',
  112. `pmid` mediumint(9) NOT NULL,
  113. `stid` mediumint(9) NOT NULL,
  114. `numpname` mediumint(9) NOT NULL,
  115. `times` smallint(6) NOT NULL DEFAULT '0',
  116. `mastatus` enum('uncheck','checking','checked','checkno') NOT NULL DEFAULT 'uncheck',
  117. `last` tinyint(4) NOT NULL DEFAULT '2',
  118. `audittime` int(11) NOT NULL,
  119. `auditcontent` text,
  120. `intime` int(11) DEFAULT NULL,
  121. `onlineaudit` tinyint(4) NOT NULL DEFAULT '0'
  122. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  123. -- --------------------------------------------------------
  124. --
  125. -- 表的结构 `jl_measure_numofper`
  126. --
  127. CREATE TABLE `jl_measure_numofper` (
  128. `mpid` mediumint(9) NOT NULL,
  129. `iszero` tinyint(3) UNSIGNED NOT NULL,
  130. `uid` mediumint(9) NOT NULL,
  131. `pid` smallint(6) UNSIGNED NOT NULL,
  132. `pmid` smallint(5) UNSIGNED NOT NULL,
  133. `stid` smallint(5) UNSIGNED NOT NULL,
  134. `numpname` smallint(5) UNSIGNED NOT NULL,
  135. `times` smallint(6) NOT NULL DEFAULT '0',
  136. `currcontractval` char(255) NOT NULL COMMENT '本期合同计量',
  137. `currchangeval` char(255) NOT NULL COMMENT '本期数量变更计量',
  138. `stopnowtotal` char(255) NOT NULL COMMENT '截止上期累计完成',
  139. `currdone` char(255) NOT NULL COMMENT '本期完成计量',
  140. `curralltotal` char(255) NOT NULL COMMENT '累计完成计量',
  141. `currstatus` enum('uncheck','checking','checked','checkno') NOT NULL DEFAULT 'checking',
  142. `audittime` int(11) NOT NULL,
  143. `intime` int(11) NOT NULL
  144. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  145. -- --------------------------------------------------------
  146. --
  147. -- 表的结构 `jl_project`
  148. --
  149. CREATE TABLE `jl_project` (
  150. `pid` int(11) NOT NULL,
  151. `uid` mediumint(9) NOT NULL,
  152. `pname` char(255) NOT NULL,
  153. `intime` int(11) NOT NULL
  154. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  155. -- --------------------------------------------------------
  156. --
  157. -- 表的结构 `jl_project_measure`
  158. --
  159. CREATE TABLE `jl_project_measure` (
  160. `pmid` int(11) NOT NULL,
  161. `pid` mediumint(8) DEFAULT '0',
  162. `stid` mediumint(8) NOT NULL DEFAULT '0',
  163. `uid` mediumint(9) NOT NULL,
  164. `pmname` char(255) DEFAULT NULL,
  165. `contracttotal` char(255) NOT NULL DEFAULT '0',
  166. `intime` int(11) NOT NULL
  167. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  168. -- --------------------------------------------------------
  169. --
  170. -- 表的结构 `jl_section_type`
  171. --
  172. CREATE TABLE `jl_section_type` (
  173. `stid` int(11) NOT NULL,
  174. `pid` mediumint(8) NOT NULL DEFAULT '0',
  175. `uid` mediumint(9) NOT NULL,
  176. `stname` char(255) NOT NULL,
  177. `stkey` char(255) NOT NULL,
  178. `intime` int(11) NOT NULL
  179. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  180. -- --------------------------------------------------------
  181. --
  182. -- 表的结构 `jl_share`
  183. --
  184. CREATE TABLE `jl_share` (
  185. `sid` mediumint(8) UNSIGNED NOT NULL,
  186. `hashcode` char(255) NOT NULL,
  187. `ids` int(11) NOT NULL,
  188. `idtype` tinyint(3) UNSIGNED NOT NULL,
  189. `intime` int(10) UNSIGNED NOT NULL,
  190. `endtime` int(10) UNSIGNED NOT NULL
  191. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  192. -- --------------------------------------------------------
  193. --
  194. -- 表的结构 `jl_sign`
  195. --
  196. CREATE TABLE `jl_sign` (
  197. `sid` int(11) NOT NULL COMMENT '主键',
  198. `project` int(11) NOT NULL COMMENT '项目主键',
  199. `tender` int(11) NOT NULL COMMENT '标段主键',
  200. `phaseno` int(11) NOT NULL COMMENT '期数',
  201. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '报表名',
  202. `ownuid` smallint(6) NOT NULL COMMENT '生成人id',
  203. `intime` int(11) NOT NULL COMMENT '生成时间',
  204. `pagenum` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '共有多少张报表,未解压默认为0',
  205. `widhei` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '报表纸张大小 以mm为单位',
  206. `audituid` smallint(6) UNSIGNED DEFAULT NULL COMMENT '发起人id',
  207. `aintime` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '发起时间',
  208. `status` enum('uncheck','checking','checked') NOT NULL DEFAULT 'uncheck' COMMENT '签署状态',
  209. `sintime` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '签署完成时间',
  210. `ishare` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否分享,0不分享(默认),1分享'
  211. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='在线签署报表信息表';
  212. -- --------------------------------------------------------
  213. --
  214. -- 表的结构 `jl_sign_attachment`
  215. --
  216. CREATE TABLE `jl_sign_attachment` (
  217. `said` int(11) UNSIGNED NOT NULL COMMENT '主键',
  218. `sid` int(11) UNSIGNED NOT NULL COMMENT '报表id主键',
  219. `curnum` smallint(5) UNSIGNED NOT NULL COMMENT '编号,第几张',
  220. `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '报表文件路径'
  221. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='签署文件信息表';
  222. -- --------------------------------------------------------
  223. --
  224. -- 表的结构 `jl_sign_audit`
  225. --
  226. CREATE TABLE `jl_sign_audit` (
  227. `satid` int(11) UNSIGNED NOT NULL COMMENT '主键',
  228. `sid` int(11) UNSIGNED NOT NULL COMMENT '报表id主键',
  229. `status` enum('uncheck','checking','checked') NOT NULL DEFAULT 'uncheck' COMMENT '个人签署状态',
  230. `audituid` int(11) UNSIGNED NOT NULL COMMENT '签署人id',
  231. `aname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '签署人姓名',
  232. `intime` int(11) NOT NULL COMMENT '签署时间'
  233. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户签署表';
  234. -- --------------------------------------------------------
  235. --
  236. -- 表的结构 `jl_sign_audit_attachment`
  237. --
  238. CREATE TABLE `jl_sign_audit_attachment` (
  239. `saaid` int(11) NOT NULL COMMENT '主键',
  240. `audituid` int(11) NOT NULL COMMENT '签署人id',
  241. `said` int(11) NOT NULL COMMENT '报表文件id',
  242. `picpath` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '签名图片地址',
  243. `position` varchar(500) CHARACTER SET utf8 NOT NULL COMMENT '签名所在位置'
  244. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='用户签名关联表' ROW_FORMAT=COMPACT;
  245. -- --------------------------------------------------------
  246. --
  247. -- 表的结构 `jl_users`
  248. --
  249. CREATE TABLE `jl_users` (
  250. `uid` int(11) NOT NULL,
  251. `uemail` char(255) NOT NULL,
  252. `upass` char(60) NOT NULL,
  253. `intime` int(11) NOT NULL,
  254. `isstop` tinyint(1) NOT NULL
  255. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  256. -- --------------------------------------------------------
  257. --
  258. -- 表的结构 `jl_users_auth`
  259. --
  260. CREATE TABLE `jl_users_auth` (
  261. `aid` int(11) NOT NULL,
  262. `token` char(255) NOT NULL,
  263. `expirestime` int(11) NOT NULL
  264. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  265. -- --------------------------------------------------------
  266. --
  267. -- 表的结构 `jl_users_friends`
  268. --
  269. CREATE TABLE `jl_users_friends` (
  270. `uid` int(11) NOT NULL,
  271. `fuid` int(11) NOT NULL
  272. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  273. -- --------------------------------------------------------
  274. --
  275. -- 表的结构 `jl_user_profiles`
  276. --
  277. CREATE TABLE `jl_user_profiles` (
  278. `userid` int(11) NOT NULL,
  279. `name` char(50) NOT NULL,
  280. `company` char(255) NOT NULL,
  281. `jobs` char(255) NOT NULL,
  282. `phone` char(255) NOT NULL,
  283. `mobile` char(255) NOT NULL,
  284. `qq` char(50) NOT NULL,
  285. `groups` enum('vip','anonymous') NOT NULL DEFAULT 'anonymous',
  286. `avatar` char(255) NOT NULL DEFAULT 'global/avatar/avtra.jpg',
  287. `isnotice` tinyint(4) NOT NULL DEFAULT '0',
  288. `signpath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'global/signpath/signavatar.png' COMMENT '签名图片地址',
  289. `remark` varchar(500) NOT NULL COMMENT '备注信息'
  290. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  291. -- --------------------------------------------------------
  292. --
  293. -- 表的结构 `jl_zero_audit`
  294. --
  295. CREATE TABLE `jl_zero_audit` (
  296. `zaid` smallint(6) NOT NULL,
  297. `uid` int(11) NOT NULL,
  298. `catid` int(11) NOT NULL,
  299. `auditstatus` int(11) NOT NULL
  300. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  301. --
  302. -- Indexes for dumped tables
  303. --
  304. --
  305. -- Indexes for table `jl_attachment`
  306. --
  307. ALTER TABLE `jl_attachment`
  308. ADD PRIMARY KEY (`aid`),
  309. ADD KEY `isnew` (`isnew`),
  310. ADD KEY `numpname` (`numpname`),
  311. ADD KEY `times` (`times`);
  312. --
  313. -- Indexes for table `jl_auser`
  314. --
  315. ALTER TABLE `jl_auser`
  316. ADD PRIMARY KEY (`auid`);
  317. --
  318. -- Indexes for table `jl_config`
  319. --
  320. ALTER TABLE `jl_config`
  321. ADD PRIMARY KEY (`conid`);
  322. --
  323. -- Indexes for table `jl_item_attachment`
  324. --
  325. ALTER TABLE `jl_item_attachment`
  326. ADD PRIMARY KEY (`iaid`);
  327. --
  328. -- Indexes for table `jl_item_measure_numofper`
  329. --
  330. ALTER TABLE `jl_item_measure_numofper`
  331. ADD PRIMARY KEY (`imnid`);
  332. --
  333. -- Indexes for table `jl_measure_audit`
  334. --
  335. ALTER TABLE `jl_measure_audit`
  336. ADD PRIMARY KEY (`maid`),
  337. ADD UNIQUE KEY `auditoruid` (`auditoruid`,`pmid`,`numpname`,`times`);
  338. --
  339. -- Indexes for table `jl_measure_numofper`
  340. --
  341. ALTER TABLE `jl_measure_numofper`
  342. ADD PRIMARY KEY (`mpid`),
  343. ADD UNIQUE KEY `pmid_numpname_times` (`pmid`,`numpname`,`times`),
  344. ADD UNIQUE KEY `mpid` (`mpid`);
  345. --
  346. -- Indexes for table `jl_project`
  347. --
  348. ALTER TABLE `jl_project`
  349. ADD PRIMARY KEY (`pid`);
  350. --
  351. -- Indexes for table `jl_project_measure`
  352. --
  353. ALTER TABLE `jl_project_measure`
  354. ADD PRIMARY KEY (`pmid`);
  355. --
  356. -- Indexes for table `jl_section_type`
  357. --
  358. ALTER TABLE `jl_section_type`
  359. ADD PRIMARY KEY (`stid`);
  360. --
  361. -- Indexes for table `jl_share`
  362. --
  363. ALTER TABLE `jl_share`
  364. ADD PRIMARY KEY (`sid`);
  365. --
  366. -- Indexes for table `jl_sign`
  367. --
  368. ALTER TABLE `jl_sign`
  369. ADD PRIMARY KEY (`sid`);
  370. --
  371. -- Indexes for table `jl_sign_attachment`
  372. --
  373. ALTER TABLE `jl_sign_attachment`
  374. ADD PRIMARY KEY (`said`);
  375. --
  376. -- Indexes for table `jl_sign_audit`
  377. --
  378. ALTER TABLE `jl_sign_audit`
  379. ADD PRIMARY KEY (`satid`);
  380. --
  381. -- Indexes for table `jl_sign_audit_attachment`
  382. --
  383. ALTER TABLE `jl_sign_audit_attachment`
  384. ADD PRIMARY KEY (`saaid`);
  385. --
  386. -- Indexes for table `jl_users`
  387. --
  388. ALTER TABLE `jl_users`
  389. ADD PRIMARY KEY (`uid`),
  390. ADD UNIQUE KEY `uemail` (`uemail`);
  391. --
  392. -- Indexes for table `jl_users_auth`
  393. --
  394. ALTER TABLE `jl_users_auth`
  395. ADD PRIMARY KEY (`aid`);
  396. --
  397. -- Indexes for table `jl_user_profiles`
  398. --
  399. ALTER TABLE `jl_user_profiles`
  400. ADD UNIQUE KEY `userid` (`userid`);
  401. --
  402. -- Indexes for table `jl_zero_audit`
  403. --
  404. ALTER TABLE `jl_zero_audit`
  405. ADD PRIMARY KEY (`zaid`);
  406. --
  407. -- 在导出的表使用AUTO_INCREMENT
  408. --
  409. --
  410. -- 使用表AUTO_INCREMENT `jl_attachment`
  411. --
  412. ALTER TABLE `jl_attachment`
  413. MODIFY `aid` int(11) NOT NULL AUTO_INCREMENT;
  414. --
  415. -- 使用表AUTO_INCREMENT `jl_auser`
  416. --
  417. ALTER TABLE `jl_auser`
  418. MODIFY `auid` mediumint(9) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  419. --
  420. -- 使用表AUTO_INCREMENT `jl_config`
  421. --
  422. ALTER TABLE `jl_config`
  423. MODIFY `conid` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  424. --
  425. -- 使用表AUTO_INCREMENT `jl_item_attachment`
  426. --
  427. ALTER TABLE `jl_item_attachment`
  428. MODIFY `iaid` mediumint(11) NOT NULL AUTO_INCREMENT;
  429. --
  430. -- 使用表AUTO_INCREMENT `jl_item_measure_numofper`
  431. --
  432. ALTER TABLE `jl_item_measure_numofper`
  433. MODIFY `imnid` int(11) NOT NULL AUTO_INCREMENT;
  434. --
  435. -- 使用表AUTO_INCREMENT `jl_measure_audit`
  436. --
  437. ALTER TABLE `jl_measure_audit`
  438. MODIFY `maid` smallint(6) NOT NULL AUTO_INCREMENT;
  439. --
  440. -- 使用表AUTO_INCREMENT `jl_measure_numofper`
  441. --
  442. ALTER TABLE `jl_measure_numofper`
  443. MODIFY `mpid` mediumint(9) NOT NULL AUTO_INCREMENT;
  444. --
  445. -- 使用表AUTO_INCREMENT `jl_project`
  446. --
  447. ALTER TABLE `jl_project`
  448. MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT;
  449. --
  450. -- 使用表AUTO_INCREMENT `jl_project_measure`
  451. --
  452. ALTER TABLE `jl_project_measure`
  453. MODIFY `pmid` int(11) NOT NULL AUTO_INCREMENT;
  454. --
  455. -- 使用表AUTO_INCREMENT `jl_section_type`
  456. --
  457. ALTER TABLE `jl_section_type`
  458. MODIFY `stid` int(11) NOT NULL AUTO_INCREMENT;
  459. --
  460. -- 使用表AUTO_INCREMENT `jl_share`
  461. --
  462. ALTER TABLE `jl_share`
  463. MODIFY `sid` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;COMMIT;
  464. --
  465. -- 使用表AUTO_INCREMENT `jl_sign`
  466. --
  467. ALTER TABLE `jl_sign`
  468. MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=1;
  469. --
  470. -- 使用表AUTO_INCREMENT `jl_sign_attachment`
  471. --
  472. ALTER TABLE `jl_sign_attachment`
  473. MODIFY `said` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=1;
  474. --
  475. -- 使用表AUTO_INCREMENT `jl_sign_audit`
  476. --
  477. ALTER TABLE `jl_sign_audit`
  478. MODIFY `satid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=1;
  479. --
  480. -- 使用表AUTO_INCREMENT `jl_sign_audit_attachment`
  481. --
  482. ALTER TABLE `jl_sign_audit_attachment`
  483. MODIFY `saaid` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', AUTO_INCREMENT=1;COMMIT;
  484. --
  485. -- 使用表AUTO_INCREMENT `jl_users`
  486. --
  487. ALTER TABLE `jl_users`
  488. MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT;
  489. --
  490. -- 使用表AUTO_INCREMENT `jl_users_auth`
  491. --
  492. ALTER TABLE `jl_users_auth`
  493. MODIFY `aid` int(11) NOT NULL AUTO_INCREMENT;
  494. --
  495. -- 使用表AUTO_INCREMENT `jl_zero_audit`
  496. --
  497. ALTER TABLE `jl_zero_audit`
  498. MODIFY `zaid` smallint(6) NOT NULL AUTO_INCREMENT;COMMIT;
  499. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  500. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  501. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;