github.com/qiuhoude/go-web@v0.0.0-20220223060959-ab545e78f20d/prepare/04_database/demo2_mysql/test.sql (about)

     1  CREATE TABLE `userinfo`
     2  (
     3    `uid`        INT(10) NOT NULL AUTO_INCREMENT,
     4    `username`   VARCHAR(64) NULL DEFAULT NULL,
     5    `departname` VARCHAR(64) NULL DEFAULT NULL,
     6    `created`    DATE NULL DEFAULT NULL,
     7    PRIMARY KEY (`uid`)
     8  );
     9  
    10  CREATE TABLE `userdetail`
    11  (
    12    `uid`     INT(10) NOT NULL DEFAULT '0',
    13    `intro`   TEXT NULL,
    14    `profile` TEXT NULL,
    15    PRIMARY KEY (`uid`)
    16  ) COMMIT "用户详细";
    17  
    18  
    19  CREATE TABLE `account`
    20  (
    21    `id`    int(4) NOT NULL,
    22    `name`  varchar(30) DEFAULT NULL,
    23    `money` float(8,
    24    2
    25  ) DEFAULT NULL,
    26    PRIMARY KEY
    27  (
    28    `id`
    29  )
    30    );
    31  
    32  INSERT
    33  INTO
    34    `account`
    35  VALUES
    36  ('1',
    37   'ruby',
    38   '3000.00');
    39  INSERT INTO `account`
    40  
    41  VALUES ('2', '王二狗', '1000.00');