Changeset 94 for trunk/Modules
- Timestamp:
- Sep 7, 2012, 10:43:02 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Modules/User/UModuleUser.pas
r92 r94 6 6 7 7 uses 8 Classes, SysUtils, UModularSystem ;8 Classes, SysUtils, UModularSystem, SpecializedDictionary; 9 9 10 10 type … … 62 62 var 63 63 DbRows: TDbRows; 64 Data: TDictionaryStringString; 64 65 begin 65 66 try 66 67 DbRows := TDbRows.Create; 68 Data := TDictionaryStringString.Create; 69 67 70 Core.CommonDatabase.Query(DbRows, 68 71 'CREATE TABLE IF NOT EXISTS `User` (' + … … 76 79 ' PRIMARY KEY (`Id`)' + 77 80 ') ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;'); 81 82 Data.Add('Id', '1'); 83 Data.Add('Name', 'anonymous'); 84 Data.Add('FullName', 'Anonymous'); 85 Data.Add('RegistrationTime', 'NOW()'); 86 Core.CommonDatabase.Insert('User', Data); 87 78 88 Core.CommonDatabase.Query(DbRows, 79 89 'CREATE TABLE IF NOT EXISTS `UserOnline` (' + … … 90 100 ') ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;'); 91 101 finally 102 Data.Free; 92 103 DbRows.Free; 93 104 end;
Note:
See TracChangeset
for help on using the changeset viewer.