Changeset 146 for trunk/Modules/News/ModuleNews.pas
- Timestamp:
- Dec 29, 2023, 11:44:26 PM (11 months ago)
- File:
-
- 1 moved
Legend:
- Unmodified
- Added
- Removed
-
trunk/Modules/News/ModuleNews.pas
r145 r146 1 unit UModuleNews;1 unit ModuleNews; 2 2 3 3 interface 4 4 5 5 uses 6 Classes, SysUtils, UModularSystem, UModuleBase, UNews, UHTTPServer, UModuleUser;6 Classes, SysUtils, UModularSystem, ModuleBase, News, UHTTPServer, ModuleUser; 7 7 8 8 type … … 27 27 28 28 uses 29 UCore, UUserControlPage, USqlDatabase;29 Core, UserControlPage, USqlDatabase; 30 30 31 31 { TModuleNews } … … 83 83 DbRows := TDbRows.Create; 84 84 85 Core.Co mmonDatabase.Query(DbRows,85 Core.Core.CommonDatabase.Query(DbRows, 86 86 'CREATE TABLE IF NOT EXISTS `News` (' + 87 87 ' `Id` int(11) NOT NULL AUTO_INCREMENT,' + … … 103 103 ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;'); 104 104 105 Core.Co mmonDatabase.Query(DbRows,105 Core.Core.CommonDatabase.Query(DbRows, 106 106 'CREATE TABLE IF NOT EXISTS `NewsCategory` (' + 107 107 ' `Id` int(11) NOT NULL AUTO_INCREMENT,' + … … 116 116 ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1; '); 117 117 118 Core.Co mmonDatabase.Query(DbRows,118 Core.Core.CommonDatabase.Query(DbRows, 119 119 'ALTER TABLE `News`' + 120 120 ' ADD CONSTRAINT `News_ibfk_1` FOREIGN KEY (`Category`) REFERENCES `NewsCategory` (`Id`);'); … … 133 133 DbRows := TDbRows.Create; 134 134 135 Core.Co mmonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `News`');136 Core.Co mmonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `NewsGroup`');135 Core.Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `News`'); 136 Core.Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `NewsGroup`'); 137 137 finally 138 138 DbRows.Free;
Note:
See TracChangeset
for help on using the changeset viewer.