📄 road_defect_setup.sql
字号:
USE PRRM;
--
-- Dumping data for table `prrm`.`contact`
--
INSERT INTO `CONTACT` (`ID`,`BLOCK`,`COUNTRY`,`EMAIL`,`FIRSTNAME`,`FLOOR`,`LASTMODIFIEDTIME`,`LASTNAME`,`POSTCODE`,`ROADNAME`,`TELEPHONE`,`UNIT`) VALUES
(1,'123','SG','alison@mail.com','Alison',11,'2006-06-15 11:33:46','Tan','523587','Ang Mio Kio Avenue','623153533',11),
(2,'246','SG','matt@mail.com','Matt',6,'2006-06-16 18:42:43','Lim','754112','Braddell Road','63243444',191),
(3,'999','SG','zena@mail.com','Zena',13,'2006-06-19 16:09:33','Tan','978422','Clementi Road','67745544',211),
(4,'123','SG','amy@mail.com','Amy',11,'2006-06-15 11:33:46','Kang','523587','Delta Road','623153533',11),
(5,'246','SG','ian@mail.com','Ian',6,'2006-06-16 18:42:43','Wilson','754112','Elias Road','63243444',191),
(6,'999','SG','kavitha@mail.com','Kavitha',13,'2006-06-19 16:09:33','Kamal','978422','French Road','67745544',211),
(7,'123','SG','mary@mail.com','Mary',11,'2006-06-15 11:33:46','Tay','523587','Holland Drive','623153533',11),
(8,'246','SG','keith@mail.com','Keith',6,'2006-06-16 18:42:43','Lam','754112','Jurong Town Hall Road','63243444',191),
(9,'999','SG','selena@mail.com','Selena',13,'2006-06-19 16:09:33','Chew','978422','Merchant Road','67745544',211),
(10,'123','SG','joe@mail.com','Joe',11,'2006-06-15 11:33:46','Sem','523587','Pioneer Road','623153533',11),
(11,'246','SG','susan@mail.com','Susan',6,'2006-06-16 18:42:43','Lim','754112','Simei Road','63243444',191),
(12,'999','SG','jack@mail.com','Jack',13,'2006-06-19 16:09:33','Tan','978422','Tiong Bahru Road','67745544',211),
(13,'123','SG','rose@mail.com','Rose',11,'2006-06-15 11:33:46','Tan','523587','Upper Changi Road','623153533',11),
(14,'246','SG','rita@mail.com','Rita',6,'2006-06-16 18:42:43','Lim','754112','Woodlands Road','63243444',191),
(15,'999','SG','veronica@mail.com','Veronica',13,'2006-06-19 16:09:33','Tan','978422','Yio Chu Kang Road','67745544',211);
INSERT INTO `CONTACT` (`ID`,`BLOCK`,`COUNTRY`,`EMAIL`,`FIRSTNAME`,`FLOOR`,`LASTMODIFIEDTIME`,`LASTNAME`,`POSTCODE`,`ROADNAME`,`TELEPHONE`,`UNIT`) VALUES
(16,'123','SG','addison@mail.com','Addison',11,'2006-06-15 11:33:46','Zhao','523587','Ang Mio Kio Avenue','623153533',11),
(17,'246','SG','adeline@mail.com','Adeline',6,'2006-06-16 18:42:43','Qian','754112','Braddell Road','63243444',191),
(18,'999','SG','aileen@mail.com','Aileen',13,'2006-06-19 16:09:33','Sun','978422','Clementi Road','67745544',211),
(19,'123','SG','alice@mail.com','Alice',11,'2006-06-15 11:33:46','Li','523587','Delta Road','623153533',11),
(20,'246','SG','ally@mail.com','Ally',6,'2006-06-16 18:42:43','Zhou','754112','Elias Road','63243444',191),
(21,'999','SG','amanda@mail.com','Amanda',13,'2006-06-19 16:09:33','Wu','978422','French Road','67745544',211),
(22,'123','SG','angela@mail.com','Angela',11,'2006-06-15 11:33:46','Zheng','523587','Holland Drive','623153533',11),
(23,'246','SG','andrea@mail.com','Andrea',6,'2006-06-16 18:42:43','Feng','754112','Jurong Town Hall Road','63243444',191),
(24,'999','SG','angelina@mail.com','Angelina',13,'2006-06-19 16:09:33','Chen','978422','Merchant Road','67745544',211),
(25,'123','SG','bella@mail.com','Bella',11,'2006-06-15 11:33:46','Chu','523587','Pioneer Road','623153533',11),
(26,'246','SG','brenda@mail.com','Brenda',6,'2006-06-16 18:42:43','Wei','754112','Simei Road','63243444',191),
(27,'999','SG','britney@mail.com','Britney',13,'2006-06-19 16:09:33','Jiang','978422','Tiong Bahru Road','67745544',211),
(28,'123','SG','camila@mail.com','Camila',11,'2006-06-15 11:33:46','Shen','523587','Upper Changi Road','623153533',11),
(29,'246','SG','candice@mail.com','Candice',6,'2006-06-16 18:42:43','Yang','754112','Woodlands Road','63243444',191),
(30,'999','SG','caroline@mail.com','Caroline',13,'2006-06-19 16:09:33','Zhu','978422','Yio Chu Kang Road','67745544',211);
INSERT INTO `CONTACT` (`ID`,`BLOCK`,`COUNTRY`,`EMAIL`,`FIRSTNAME`,`FLOOR`,`LASTMODIFIEDTIME`,`LASTNAME`,`POSTCODE`,`ROADNAME`,`TELEPHONE`,`UNIT`) VALUES
(31,'123','SG','charlotte@mail.com','Charlotte',11,'2006-06-15 11:33:46','Qin','523587','Ang Mio Kio Avenue','623153533',11),
(32,'246','SG','christine@mail.com','Christine',6,'2006-06-16 18:42:43','You','754112','Braddell Road','63243444',191),
(33,'999','SG','cindy@mail.com','Cindy',13,'2006-06-19 16:09:33','He','978422','Clementi Road','67745544',211),
(34,'123','SG','claire@mail.com','Claire',11,'2006-06-15 11:33:46','Lu','523587','Delta Road','623153533',11),
(35,'246','SG','daisy@mail.com','Daisy',6,'2006-06-16 18:42:43','Shi','754112','Elias Road','63243444',191),
(36,'999','SG','deborah@mail.com','Deborah',13,'2006-06-19 16:09:33','Zhang','978422','French Road','67745544',211),
(37,'123','SG','diana@mail.com','Diana',11,'2006-06-15 11:33:46','Kong','523587','Holland Drive','623153533',11),
(38,'246','SG','donna@mail.com','Donna',6,'2006-06-16 18:42:43','Shui','754112','Jurong Town Hall Road','63243444',191),
(39,'999','SG','eileen@mail.com','Eileen',13,'2006-06-19 16:09:33','Dou','978422','Merchant Road','67745544',211),
(40,'123','SG','eliza@mail.com','Eliza',11,'2006-06-15 11:33:46','Sem','523587','Pioneer Road','623153533',11),
(41,'246','SG','esther@mail.com','Esther',6,'2006-06-16 18:42:43','Yun','754112','Simei Road','63243444',191),
(42,'999','SG','evelyn@mail.com','Evelyn',13,'2006-06-19 16:09:33','Su','978422','Tiong Bahru Road','67745544',211),
(43,'123','SG','fiona@mail.com','Fiona',11,'2006-06-15 11:33:46','Ge','523587','Upper Changi Road','623153533',11),
(44,'246','SG','gabriella@mail.com','Gabriella',6,'2006-06-16 18:42:43','Xi','754112','Woodlands Road','63243444',191),
(45,'999','SG','haley@mail.com','Haley',13,'2006-06-19 16:09:33','Tan','978422','Yio Chu Kang Road','67745544',211);
INSERT INTO `CONTACT` (`ID`,`BLOCK`,`COUNTRY`,`EMAIL`,`FIRSTNAME`,`FLOOR`,`LASTMODIFIEDTIME`,`LASTNAME`,`POSTCODE`,`ROADNAME`,`TELEPHONE`,`UNIT`) VALUES
(46,'123','SG','melody@mail.com','Melody',11,'2006-06-15 11:33:46','Fan','523587','Ang Mio Kio Avenue','623153533',11),
(47,'246','SG','rachael@mail.com','Rachael',6,'2006-06-16 18:42:43','Peng','754112','Braddell Road','63243444',191),
(48,'999','SG','rayna@mail.com','Rayna',13,'2006-06-19 16:09:33','Lang','978422','Clementi Road','67745544',211),
(49,'123','SG','yuliana@mail.com','Yuliana',11,'2006-06-15 11:33:46','Chang','523587','Delta Road','623153533',11),
(50,'246','SG','zoey@mail.com','Zoey',6,'2006-06-16 18:42:43','Ma','754112','Elias Road','63243444',191),
(51,'999','SG','aaron@mail.com','Aaron',13,'2006-06-19 16:09:33','Miao','978422','French Road','67745544',211),
(52,'123','SG','alexander@mail.com','Alexander',11,'2006-06-15 11:33:46','Hua','523587','Holland Drive','623153533',11),
(53,'246','SG','andy@mail.com','Andy',6,'2006-06-16 18:42:43','Fang','754112','Jurong Town Hall Road','63243444',191),
(54,'999','SG','ben@mail.com','Ben',13,'2006-06-19 16:09:33','Ren','978422','Merchant Road','67745544',211),
(55,'123','SG','benjamin@mail.com','Benjamin',11,'2006-06-15 11:33:46','Yuan','523587','Pioneer Road','623153533',11),
(56,'246','SG','brian@mail.com','Brian',6,'2006-06-16 18:42:43','Liu','754112','Simei Road','63243444',191),
(57,'999','SG','bruce@mail.com','Bruce',13,'2006-06-19 16:09:33','Bao','978422','Tiong Bahru Road','67745544',211),
(58,'123','SG','calvin@mail.com','Calvin',11,'2006-06-15 11:33:46','Tang','523587','Upper Changi Road','623153533',11),
(59,'246','SG','rita@mail.com','Rita',6,'2006-06-16 18:42:43','Fei','754112','Woodlands Road','63243444',191),
(60,'999','SG','charles@mail.com','Charles',13,'2006-06-19 16:09:33','Lian','978422','Yio Chu Kang Road','67745544',211);
INSERT INTO `CONTACT` (`ID`,`BLOCK`,`COUNTRY`,`EMAIL`,`FIRSTNAME`,`FLOOR`,`LASTMODIFIEDTIME`,`LASTNAME`,`POSTCODE`,`ROADNAME`,`TELEPHONE`,`UNIT`) VALUES
(61,'123','SG','christopher@mail.com','Christopher',11,'2006-06-15 11:33:46','Cen','523587','Ang Mio Kio Avenue','623153533',11),
(62,'246','SG','clarence@mail.com','Clarence',6,'2006-06-16 18:42:43','Xue','754112','Braddell Road','63243444',191),
(63,'999','SG','clifford@mail.com','Clifford',13,'2006-06-19 16:09:33','Lei','978422','Clementi Road','67745544',211),
(64,'123','SG','amy@mail.com','Amy',11,'2006-06-15 11:33:46','Ni','523587','Delta Road','623153533',11),
(65,'246','SG','coleman@mail.com','Coleman',6,'2006-06-16 18:42:43','Teng','754112','Elias Road','63243444',191),
(66,'999','SG','colin@mail.com','Colin',13,'2006-06-19 16:09:33','Yin','978422','French Road','67745544',211),
(67,'123','SG','conrad@mail.com','Conrad',11,'2006-06-15 11:33:46','Luo','523587','Holland Drive','623153533',11),
(68,'246','SG','daniel@mail.com','Daniel',6,'2006-06-16 18:42:43','Bi','754112','Jurong Town Hall Road','63243444',191),
(69,'999','SG','darren@mail.com','Darren',13,'2006-06-19 16:09:33','Hao','978422','Merchant Road','67745544',211),
(70,'123','SG','david@mail.com','David',11,'2006-06-15 11:33:46','Wu','523587','Pioneer Road','623153533',11),
(71,'246','SG','derek@mail.com','Derek',6,'2006-06-16 18:42:43','Chang','754112','Simei Road','63243444',191),
(72,'999','SG','eric@mail.com','Eric',13,'2006-06-19 16:09:33','Le','978422','Tiong Bahru Road','67745544',211),
(73,'123','SG','forrest@mail.com','Forrest',11,'2006-06-15 11:33:46','Fu','523587','Upper Changi Road','623153533',11),
(74,'246','SG','frank@mail.com','Frank',6,'2006-06-16 18:42:43','Bian','754112','Woodlands Road','63243444',191),
(75,'999','SG','fred@mail.com','Fred',13,'2006-06-19 16:09:33','Pi','978422','Yio Chu Kang Road','67745544',211);
INSERT INTO `CONTACT` (`ID`,`BLOCK`,`COUNTRY`,`EMAIL`,`FIRSTNAME`,`FLOOR`,`LASTMODIFIEDTIME`,`LASTNAME`,`POSTCODE`,`ROADNAME`,`TELEPHONE`,`UNIT`) VALUES
(76,'123','SG','gilbert@mail.com','Gilbert',11,'2006-06-15 11:33:46','Kang','523587','Ang Mio Kio Avenue','623153533',11),
(77,'246','SG','harry@mail.com','Harry',6,'2006-06-16 18:42:43','Gu','754112','Braddell Road','63243444',191),
(78,'999','SG','isaac@mail.com','Isaac',13,'2006-06-19 16:09:33','Meng','978422','Clementi Road','67745544',211),
(79,'123','SG','ivan@mail.com','Ivan',11,'2006-06-15 11:33:46','Ping','523587','Delta Road','623153533',11),
(80,'246','SG','jack@mail.com','Jack',6,'2006-06-16 18:42:43','Huang','754112','Elias Road','63243444',191),
(81,'999','SG','jacob@mail.com','Jacob',13,'2006-06-19 16:09:33','Mu','978422','French Road','67745544',211),
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -