首页 > 数据库技术 > 详细

sqlite

时间:2020-10-26 12:29:19      阅读:31      评论:0      收藏:0      [点我收藏+]

数据库

                   con.Execute(string.Format(@"CREATE TABLE Category (
                                                Id INTEGER PRIMARY KEY AUTOINCREMENT  NOT NULL,
                                                Name  VARCHAR (50) NOT NULL,
                                                Pid  INTEGER,  CreationTime datetime,
                                                Sort  INT,
                                                LastModificationTime datetime
                                                );"));
                    con.Execute(string.Format(@"CREATE TABLE TableInfo (
                                                Id INTEGER PRIMARY KEY AUTOINCREMENT  NOT NULL,
                                                Name  VARCHAR (50) UNIQUE NOT NULL)
                                                ;"));
                    con.Execute(string.Format(@"CREATE TABLE Column (
                                                Id INTEGER PRIMARY KEY AUTOINCREMENT  NOT NULL,
                                                Name  VARCHAR (50) ,
                                                Text  VARCHAR (50) ,
                                                TableId  INTEGER)
                                                ;"));
                    con.Execute(string.Format(@"CREATE TABLE NumberInfo (
                                                Id INTEGER PRIMARY KEY AUTOINCREMENT  NOT NULL,
                                                Number  VARCHAR (50) UNIQUE NOT NULL,
                                                OldPass  VARCHAR (50)   , 
                                                NewPass  VARCHAR (50)   ,
                                                Phone  VARCHAR (50),
                                                MobileToken  VARCHAR (50),
                                                FullName  VARCHAR (50),
                                                IdCard  VARCHAR (50),
                                                CommonIp  VARCHAR (50),
                                                Mark  VARCHAR (50),
                                                CategoryId  INTEGER,
                                                Status  INT,
                                                Sell BOOLEAN,
                                                Rank INT,
                                                CreationTime datetime,
                                                LastModificationTime datetime,
                                                Dnf                  VARCHAR (500),
                                                IsSearchDnf          BOOLEAN       DEFAULT 0,
                                                IsDeleteFriend       BOOLEAN       DEFAULT 0
                                                );"));
                    con.Execute(string.Format(@"CREATE TABLE PhoneInfo (
                                                Id INTEGER PRIMARY KEY AUTOINCREMENT  NOT NULL,
                                                PhoneNumber  VARCHAR (50) UNIQUE NOT NULL,
                                                ImSi  VARCHAR (50)   , 
                                                CcId  VARCHAR (50)   , 
                                                Pass  VARCHAR (50)   , 
                                                Balance  VARCHAR (50)   ,
                                                Type  INT,
                                                State  INT, 
                                                DirectoryId INTEGER,
                                                Mark  VARCHAR (50),
                                                CreationTime datetime,
                                                LastModificationTime datetime
                                                );"));
                    con.Execute(string.Format(@"CREATE TABLE Directory (
                                                Id INTEGER PRIMARY KEY AUTOINCREMENT  NOT NULL,
                                                Name  VARCHAR (50) NOT NULL,
                                                Pid  INTEGER,  CreationTime datetime,
                                                Sort  INT,
                                                LastModificationTime datetime
                                                );"));

sqlite

原文:https://www.cnblogs.com/wangyinlon/p/13877089.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!