IDBTable.cs 952 Bytes
Newer Older
潘栩锋's avatar
潘栩锋 committed
1 2 3 4 5
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

6
namespace SQLite
潘栩锋's avatar
潘栩锋 committed
7 8 9
{
    public interface IDBTable
    {
潘栩锋's avatar
潘栩锋 committed
10 11 12
        /// <summary>
        /// 表名
        /// </summary>
潘栩锋's avatar
潘栩锋 committed
13
        string TableName { get; }
14

潘栩锋's avatar
潘栩锋 committed
15 16 17
        /// <summary>
        /// 表的 Create SQL
        /// </summary>
潘栩锋's avatar
潘栩锋 committed
18
        string DDL { get; }
19

20 21 22 23 24 25

        /// <summary>
        /// 表的 INDEX, 只能有一个
        /// </summary>
        string INDEX { get; }

26 27 28 29
        /// <summary>
        /// 时间列 名称
        /// </summary>
        string TimeFieldName { get; }
潘栩锋's avatar
潘栩锋 committed
30 31 32
        /// <summary>
        /// 创建表
        /// </summary>
潘栩锋's avatar
潘栩锋 committed
33
        void Create();
34

35 36
        long FreeID { get; }
        long MaxID { get; set; }
潘栩锋's avatar
潘栩锋 committed
37 38 39
        /// <summary>
        /// 初始化
        /// </summary>
40 41
        /// <param name="sQLiteHelper"></param>
        void Init(SQLiteHelper sQLiteHelper);
潘栩锋's avatar
潘栩锋 committed
42

43
        string GetDeleteSQL(DateTime del_time);
潘栩锋's avatar
潘栩锋 committed
44
    }
45 46


潘栩锋's avatar
潘栩锋 committed
47
}