jlweb_add_table_config_20151022.sql 466 B

12345678910111213141516171819202122232425262728
  1. --
  2. -- 表的结构 `jl_config`
  3. --
  4. CREATE TABLE IF NOT EXISTS `jl_config` (
  5. `conid` tinyint(4) NOT NULL,
  6. `proname` char(255) NOT NULL
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  8. --
  9. -- Indexes for dumped tables
  10. --
  11. --
  12. -- Indexes for table `jl_config`
  13. --
  14. ALTER TABLE `jl_config`
  15. ADD PRIMARY KEY (`conid`);
  16. --
  17. -- AUTO_INCREMENT for dumped tables
  18. --
  19. --
  20. -- AUTO_INCREMENT for table `jl_config`
  21. --
  22. ALTER TABLE `jl_config`
  23. MODIFY `conid` tinyint(4) NOT NULL AUTO_INCREMENT;