Changeset 20 for trunk/Forms/UMainForm.pas

Timestamp:

Jun 15, 2011, 11:11:59 AM (13 years ago)

Author:

george

Message:

• Added: Import relation one and many from existed database.

File:

• trunk/Forms/UMainForm.pas (modified) (1 diff)

trunk/Forms/UMainForm.pas

@@ -361 +361 @@
     end;
 
+    if Tables.IndexOf(TypeDateTime) = -1 then begin
+      Database.Query(DbRows, 'CREATE TABLE IF NOT EXISTS `' + TypeDateTime + '` ( ' +
+        '`Id` int(11) NOT NULL AUTO_INCREMENT,' +
+        '`CustomType` int NOT NULL,' +
+        '`Default` datetime NOT NULL,' +
+        '`Min` datetime NOT NULL,' +
+        '`Max` datetime NOT NULL,' +
+        'KEY `CustomType` (`CustomType`),' +
+        'PRIMARY KEY (`Id`)' +
+        ') ENGINE=InnoDB  DEFAULT CHARSET=utf8');
+    end;
+
     if Tables.IndexOf(TypeString) = -1 then begin
       Database.Query(DbRows, 'CREATE TABLE IF NOT EXISTS `' + TypeString + '` ( ' +