Changeset 98 for trunk/Modules/ZdechovNET/UModuleZdechovNET.pas

Timestamp:

Oct 2, 2012, 12:24:00 PM (12 years ago)

Author:

chronos

Message:

• Upraveno: Přihlašování, odhlašování, registrace a nastavení profilu uživatele.

File:

• trunk/Modules/ZdechovNET/UModuleZdechovNET.pas (modified) (2 diffs)

trunk/Modules/ZdechovNET/UModuleZdechovNET.pas

@@ -146 +146 @@
     ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;');
 
+    Core.CommonDatabase.Query(DbRows,
+    'CREATE TABLE IF NOT EXISTS `HostedProject` (' +
+    '  `Id` int(11) NOT NULL AUTO_INCREMENT,' +
+    '  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,' +
+    '  `Homepage` varchar(255) COLLATE utf8_czech_ci NOT NULL,' +
+    '  `User` int(255) NOT NULL COMMENT "User.Id",' +
+    '  `TimeCreate` datetime NOT NULL,' +
+    '  `Server` int(11) DEFAULT NULL COMMENT "NetworkDevice.Id",' +
+    '  `Active` int(11) NOT NULL DEFAULT "1",' +
+    '  `WebHosting` int(11) NOT NULL,' +
+    '  PRIMARY KEY (`Id`)' +
+    ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;');
+
   finally
     Data.Free;
@@ -161 +174 @@
   try
     DbRows := TDbRows.Create;
+    Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `HostedProject`');
     Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `Plans`');
     Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `Webcam`');