pngファイルはリソースで読む

[newbbs/newbbs.git] / Unit1.dfm

diff --git a/Unit1.dfm b/Unit1.dfm
index 9485c3f..e1c1bb2 100644 (file)
--- a/Unit1.dfm
+++ b/Unit1.dfm
@@ -1,13 +1,12 @@
 object DataModule1: TDataModule1
   OldCreateOrder = False
-  Height = 230
+  Height = 231
   Width = 302
   object FDTable1: TFDTable
-    Active = True
     IndexFieldNames = 'DBNUM'
     Connection = FDConnection1
-    UpdateOptions.UpdateTableName = 'DBNAME'
-    TableName = 'DBNAME'
+    UpdateOptions.UpdateTableName = 'dbname'
+    TableName = 'dbname'
     Left = 32
     Top = 88
     object FDTable1DBNUM: TIntegerField
@@ -17,33 +16,32 @@ object DataModule1: TDataModule1
     end
     object FDTable1DATABASE: TWideStringField
       FieldName = 'DATABASE'
-      Origin = '"DATABASE"'
+      Origin = 'DATABASE'
       Required = True
       Size = 80
     end
   end
   object FDConnection1: TFDConnection
     Params.Strings = (
-      'Database=C:\Users\yamat\Documents\GitHub\newbbs\MYDATA.IB'
-      'CharacterSet=UTF8'
-      'User_Name=sysdba'
-      'Password=masterkey'
-      'OpenMode=OpenOrCreate'
-      'DriverID=IBLite')
+      'Password=kainushi'
+      'CharacterSet=utf8'
+      'User_Name=masasi'
+      'Database=kainushi'
+      'Server=localhost'
+      'DriverID=MySQL')
     Connected = True
     Left = 144
     Top = 24
   end
   object FDTable2: TFDTable
-    Active = True
     IndexFieldNames = 'DBNUM;NUMBER'
     MasterSource = DataSource1
     MasterFields = 'DBNUM'
     Connection = FDConnection1
     FetchOptions.AssignedValues = [evLiveWindowParanoic]
     FetchOptions.LiveWindowParanoic = True
-    UpdateOptions.UpdateTableName = 'ARTICLE'
-    TableName = 'ARTICLE'
+    UpdateOptions.UpdateTableName = 'article'
+    TableName = 'article'
     Left = 96
     Top = 88
     object FDTable2DBNUM: TIntegerField
@@ -80,18 +78,19 @@ object DataModule1: TDataModule1
     end
     object FDTable2DATE: TDateField
       FieldName = 'DATE'
-      Origin = '"DATE"'
+      Origin = 'DATE'
     end
-    object FDTable2PASS: TIntegerField
+    object FDTable2PASS: TWideStringField
       FieldName = 'PASS'
       Origin = 'PASS'
+      FixedChar = True
+      Size = 40
     end
   end
   object FDTable3: TFDTable
-    Active = True
     Connection = FDConnection1
-    UpdateOptions.UpdateTableName = 'SETTING'
-    TableName = 'SETTING'
+    UpdateOptions.UpdateTableName = 'setting'
+    TableName = 'setting'
     Left = 160
     Top = 88
     object FDTable3TITLE: TWideStringField
@@ -114,7 +113,13 @@ object DataModule1: TDataModule1
     end
     object FDTable3COUNT: TIntegerField
       FieldName = 'COUNT'
-      Origin = '"COUNT"'
+      Origin = 'COUNT'
+    end
+    object FDTable3PASSWORD: TWideStringField
+      FieldName = 'PASSWORD'
+      Origin = 'PASSWORD'
+      Required = True
+      Size = 80
     end
   end
   object FDGUIxWaitCursor1: TFDGUIxWaitCursor
@@ -127,18 +132,17 @@ object DataModule1: TDataModule1
     Left = 64
     Top = 152
   end
-  object FDQuery1: TFDQuery
-    Connection = FDConnection1
-    Left = 160
-    Top = 152
-  end
   object FDTable4: TFDTable
-    Active = True
     Connection = FDConnection1
-    UpdateOptions.UpdateTableName = 'REQ'
-    TableName = 'REQ'
+    UpdateOptions.UpdateTableName = 'req'
+    TableName = 'req'
     Left = 224
     Top = 88
+    object FDTable4ID: TIntegerField
+      FieldName = 'ID'
+      Origin = 'ID'
+      Required = True
+    end
     object FDTable4DBNAME: TIntegerField
       FieldName = 'DBNAME'
       Origin = 'DBNAME'
@@ -149,7 +153,7 @@ object DataModule1: TDataModule1
     end
     object FDTable4DATE: TDateField
       FieldName = 'DATE'
-      Origin = '"DATE"'
+      Origin = 'DATE'
       Required = True
     end
     object FDTable4REQUEST: TWideMemoField
@@ -158,4 +162,34 @@ object DataModule1: TDataModule1
       BlobType = ftWideMemo
     end
   end
+  object FDTable5: TFDTable
+    IndexFieldNames = 'ID'
+    Connection = FDConnection1
+    UpdateOptions.UpdateTableName = 'images'
+    TableName = 'images'
+    Left = 224
+    Top = 144
+    object FDTable5ID: TIntegerField
+      FieldName = 'ID'
+      Origin = 'ID'
+      Required = True
+    end
+    object FDTable5NAME: TWideStringField
+      FieldName = 'NAME'
+      Origin = 'NAME'
+      FixedChar = True
+    end
+    object FDTable5SOURCE: TBlobField
+      FieldName = 'SOURCE'
+      Origin = 'SOURCE'
+    end
+  end
+  object FDQuery1: TFDQuery
+    Connection = FDConnection1
+    SQL.Strings = (
+      'select dbnum,number,title,date from article'
+      ' where number = 1 order by date;')
+    Left = 160
+    Top = 144
+  end
 end