-- ----------------------------
-- Mysql 脚本
-- ----------------------------
DROP TABLE IF EXISTS `iphone`;
CREATE TABLE `iphone` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
  `price` float NOT NULL,
  `publish_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_mycyppg5tmywf55kc5fj7j4tq` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of iphone
-- ----------------------------
INSERT INTO `iphone` VALUES ('1', '华为P30', '2488', '2018-08-14 16:00:00');
INSERT INTO `iphone` VALUES ('2', '小米11', '4388', '2020-08-14 16:00:00');
INSERT INTO `iphone` VALUES ('5', '小米23', '4388', '2020-08-14 16:00:00');
INSERT INTO `iphone` VALUES ('6', '小米243', '4388', '2020-08-14 16:00:00');
INSERT INTO `iphone` VALUES ('7', '小米78', '4388', '2020-08-14 16:00:00');
INSERT INTO `iphone` VALUES ('9', '小米788', '4388', '2020-08-14 16:00:00');



-- ----------------------------
-- Oracle 脚本
-- ----------------------------
CREATE TABLE iphone (
  id number NOT NULL,
  name varchar(32) DEFAULT NULL,
  price number(18,4) NOT NULL,
  publish_time date DEFAULT NULL);

alter table iphone add constraint pk_iphone primary key(id);

INSERT INTO iphone VALUES ('1', '华为P30', '2488', to_date('2018-08-14 16:00:00', 'yyyy-mm-dd hh24:mi:ss'));
INSERT INTO iphone VALUES ('2', '小米11', '4388', to_date('2020-08-14 16:00:00', 'yyyy-mm-dd hh24:mi:ss'));
INSERT INTO iphone VALUES ('5', '小米23', '4388', to_date('2020-08-14 16:00:00', 'yyyy-mm-dd hh24:mi:ss'));
INSERT INTO iphone VALUES ('6', '小米243', '4388', to_date('2020-08-14 16:00:00', 'yyyy-mm-dd hh24:mi:ss'));
INSERT INTO iphone VALUES ('7', '小米78', '4388', to_date('2020-08-14 16:00:00', 'yyyy-mm-dd hh24:mi:ss'));
INSERT INTO iphone VALUES ('9', '小米788', '4388', to_date('2020-08-14 16:00:00', 'yyyy-mm-dd hh24:mi:ss'));